SAP table IKPF (Header: Physical Inventory Document)

SAP table IKPF has 3 primary key fields being MANDT,IBLNR,GJAHR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
IBLNR Physical Inventory Document CHAR 10 0 IBLNR
GJAHR Fiscal Year NUMC 4 0 GJAHR
VGART Transaction/Event Type CHAR 2 0 T158V VGART
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
BLDAT Document Date in Document DATS 8 0 BLDAT
GIDAT Planned Date of Inventory Count DATS 8 0 GIDAT
ZLDAT Date of Last Count DATS 8 0 DZLDAT
BUDAT Posting Date in the Document DATS 8 0 BUDAT
MONAT Fiscal period NUMC 2 0 MONAT
USNAM User Name CHAR 12 0 USNAM
SPERR Posting Block Due to Physical Inventory CHAR 1 0 ISPER
ZSTAT Count Status CHAR 1 0 DZSTAT
DSTAT Status of Adjustment Posting (Inventory Differences) CHAR 1 0 DSTAT
XBLNI Reference Number for Physical Inventory CHAR 16 0 XBLNI1
LSTAT Status of Deletion CHAR 1 0 LSTAT
XBUFI Freeze Book Inventory CHAR 1 0 XBUFI
KEORD Type of Grouping Criterion CHAR 2 0 KEORD
01 Material group
02 Storage bin
ORDNG Grouping Criterion of Physical Inventory Document Item CHAR 10 0 ORDNG
INVNU Physical Inventory Number CHAR 16 0 INVNU1
IBLTXT Description of Physical Inventory Document CHAR 40 0 IM_PI_DOC_DESCRIPTION
INVART Physical Inventory Type CHAR 1 0 INVART
Other Types of Physical Inventory
1 Cycle Count
LASTCHANGE_DATETIME Last Change Timestamp DEC 21 7 PI_LAST_CHANGED
WSTI_BSTAT Status of Calculation of Inventory Balance at Count Time CHAR 1 0 WSTI_BSTAT

IKPF foreign key relationships

Table Field Check Table Check Field
0 IKPF LGORT T001L Storage Locations MANDT
0 IKPF LGORT T001L Storage Locations WERKS
1 IKPF MANDT T000 Clients MANDT
0 IKPF SOBKZ T148 Special Stock Indicator MANDT
0 IKPF SOBKZ T148 Special Stock Indicator SOBKZ
1 IKPF VGART T158V Inv. Mngmt - General: Transaction/Event Types Allowed VGART
0 IKPF WERKS T001W Plants/Branches MANDT
0 IKPF WERKS T001W Plants/Branches WERKS