IKPF

Header: Physical Inventory Document | #transactional | Component: Inventory Management
Column Name Description
MANDT FK Client
IBLNR Physical Inventory Document
GJAHR Fiscal Year
Column Name Description
Column Name Description
Column Name Description
BLDAT Document Date in Document
GIDAT Planned Date of Inventory Count
ZLDAT Date of Last Count
BUDAT Posting Date in the Document
Column Name Description
SPERR Posting Block Due to Physical Inventory Show values
XBUFI Freeze Book Inventory Show values
KEORD Type of Grouping Criterion Show values
INVART Physical Inventory Type Show values
Column Name Description Domain name
MONAT Fiscal period MONAT
USNAM User Name XUBNAME
ZSTAT Count Status ZSTAT
DSTAT Status of Adjustment Posting (Inventory Differences) DSTAT
XBLNI Reference Number for Physical Inventory XBLNR1
LSTAT Status of Deletion DSTAT
ORDNG Grouping Criterion of Physical Inventory Document Item CHAR10
INVNU Physical Inventory Number XBLNR1
IBLTXT Description of Physical Inventory Document TEXT40
LASTCHANGE_DATETIME Last Change Timestamp TZNTSTMPL
WSTI_BSTAT Status of Calculation of Inventory Balance at Count Time WSTI_BSTAT
Master Data Relations Join Conditions
Storage location
  • Storage location
  • Client
  • Plant
  • IKPF.LGORT == T001L.LGORT
  • IKPF.MANDT == T001L.MANDT
  • IKPF.WERKS == T001L.WERKS
Client IKPF.MANDT == T000.MANDT
Special Stock Indicator
  • IKPF.MANDT == T148.MANDT
  • IKPF.SOBKZ == T148.SOBKZ
Transaction/Event Type IKPF.VGART == T158V.VGART
Plant
  • IKPF.MANDT == T001W.MANDT
  • IKPF.WERKS == T001W.WERKS