SAP Table IKPF
Header: Physical Inventory Document
IKPF (Header: Physical Inventory Document) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link IKPF to other SAP tables.
IKPF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| IBLNR | Physical Inventory Document | IBLNR | CHAR | 10 | 0 | |||||||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||||||
| VGART | Transaction/Event Type | VGART | T158V | CHAR | 2 | 0 | ||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | 0 | |||||||
| GIDAT | Planned date of inventory count | GIDAT | DATS | 8 | 0 | |||||||
| ZLDAT | Date of last count | DZLDAT | DATS | 8 | 0 | |||||||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | 0 | |||||||
| MONAT | Fiscal Period | MONAT | NUMC | 2 | 0 | |||||||
| USNAM | User name | USNAM | CHAR | 12 | 0 | |||||||
| SPERR | Posting block due to physical inventory | ISPER | CHAR | 1 | 0 |
Possible values
|
||||||
| ZSTAT | Status of count | DZSTAT | CHAR | 1 | 0 | |||||||
| DSTAT | Status of adjustment posting (inventory differences) | DSTAT | CHAR | 1 | 0 | |||||||
| XBLNI | Reference Number for Physical Inventory | XBLNI1 | CHAR | 16 | 0 | |||||||
| LSTAT | Status of delete flag | LSTAT | CHAR | 1 | 0 | |||||||
| XBUFI | Freeze book inventory | XBUFI | CHAR | 1 | 0 |
Possible values
|
||||||
| KEORD | Type of grouping criterion | KEORD | CHAR | 2 | 0 |
Possible values
|
||||||
| ORDNG | Grouping criterion of physical inventory document item | ORDNG | CHAR | 10 | 0 | |||||||
| INVNU | Physical inventory number | INVNU1 | CHAR | 16 | 0 | |||||||
| IBLTXT | Description of Physical Inventory Document | IM_PI_DOC_DESCRIPTION | CHAR | 40 | 0 | |||||||
| INVART | Physical Inventory Type | INVART | CHAR | 1 | 0 |
Possible values
|
||||||
| OIBLKIND | Ind: IS-Oil Excise duty revaluation | OIH_BLKIND | CHAR | 1 | 0 |
Possible values
|
||||||
| WSTI_BSTAT | Status of Calculation of Inventory Balance at Count Time | WSTI_BSTAT | CHAR | 1 | 0 | |||||||
IKPF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| IKPF | LGORT | IKPF | MANDT | T001L | Storage Locations | MANDT |
| IKPF | LGORT | IKPF | WERKS | T001L | Storage Locations | WERKS |
| IKPF | LGORT | IKPF | LGORT | T001L | Storage Locations | LGORT |
| IKPF | MANDT | IKPF | MANDT | T000 | Clients | MANDT |
| IKPF | SOBKZ | IKPF | MANDT | T148 | Special Stock Indicator | MANDT |
| IKPF | SOBKZ | IKPF | SOBKZ | T148 | Special Stock Indicator | SOBKZ |
| IKPF | VGART | IKPF | VGART | T158V | Inv. Mngmt - General: Transaction/Event Types Allowed | VGART |
| IKPF | WERKS | IKPF | MANDT | T001W | Plants/Branches | MANDT |
| IKPF | WERKS | IKPF | WERKS | T001W | Plants/Branches | WERKS |
