- Home
- Resources
- SAP Tables
- IIKPF - Import of IKPF for FM physical inventory
SAP Table IIKPF
Import of IKPF for FM physical inventory
IIKPF (Import of IKPF for FM physical inventory) 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 IIKPF to other SAP tables.
Source: IIKPF (Import of IKPF for FM physical inventory)
IIKPF 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
| 01 |
Material group |
| 02 |
Storage bin |
|
| 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
| NULL |
Other Types of Physical Inventory |
| 1 |
Cycle Count |
|
| 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 |
|
| SWERT |
Threshold Value for Physical Inventory Differences |
SWERT |
|
CURR |
|
13 |
2 |
|
| ABWEI |
Percentage Variance: Inventory Count Result/Book Quantity |
ABWEI |
|
NUMC |
|
3 |
0 |
|
| XLVOCA |
Include batches with deletion flag |
XLVOCA |
|
CHAR |
|
1 |
0 |
Possible values
|
IIKPF foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| IIKPF |
LGORT |
SY |
MANDT |
T001L |
Storage Locations |
MANDT |
| IIKPF |
LGORT |
IIKPF |
WERKS |
T001L |
Storage Locations |
WERKS |
| IIKPF |
LGORT |
IIKPF |
LGORT |
T001L |
Storage Locations |
LGORT |
| IIKPF |
MANDT |
IIKPF |
MANDT |
T000 |
Clients |
MANDT |
| IIKPF |
SOBKZ |
SY |
MANDT |
T148 |
Special Stock Indicator |
MANDT |
| IIKPF |
SOBKZ |
IIKPF |
SOBKZ |
T148 |
Special Stock Indicator |
SOBKZ |
| IIKPF |
VGART |
IIKPF |
VGART |
T158V |
Inv. Mngmt - General: Transaction/Event Types Allowed |
VGART |
| IIKPF |
WERKS |
SY |
MANDT |
T001W |
Plants/Branches |
MANDT |
| IIKPF |
WERKS |
IIKPF |
WERKS |
T001W |
Plants/Branches |
WERKS |
