IKPF

Transparent Table Application Table
26 Fields 3 CDS Views

Header: Physical Inventory Document

IKPF is an SAP database table in S/4HANA. Header: Physical Inventory Document. It contains 26 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PhysInvtryDocHeader view from BASIC Physical Inventory Document Header
Mmim_MatDocFlowStatusPI view from Status of Physical Inventory Documents
P_PhysInvtryDocHeader2 view_entity from BASIC

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY iblnr IBLNR Phys. Inv. Doc.
KEY gjahr GJAHR Fiscal Year
vgart VGART Trans. Ev. Type
werks WERKS_D Plant
lgort LGORT_D Location
sobkz SOBKZ Special Stock
bldat BLDAT Document Date
gidat GIDAT Plan.Count date
zldat DZLDAT Count Date
budat BUDAT Posting Date
monat MONAT Period
usnam USNAM User Name
sperr ISPER Posting Block
zstat DZSTAT Count Status
dstat DSTAT Adjust. Status
xblni XBLNI1 Phys.invent.ref
lstat LSTAT Deletion Status
xbufi XBUFI Freeze Book Inv
keord KEORD Grouping Type
ordng ORDNG Grpg Crit.
invnu INVNU1 Phys. Inv. No.
ibltxt IM_PI_DOC_DESCRIPTION Description
invart INVART Phys. Inv. Type
lastchange_datetime PI_LAST_CHANGED Last Change
wsti_bstat WSTI_BSTAT Calc.Status

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Header: Physical Inventory Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IKPF (
    MANDT,                -- Client [MANDT]
    IBLNR,                -- Phys. Inv. Doc. [IBLNR]
    GJAHR,                -- Fiscal Year [GJAHR]
    VGART,                -- Trans. Ev. Type [VGART]
    WERKS,                -- Plant [WERKS_D]
    LGORT,                -- Location [LGORT_D]
    SOBKZ,                -- Special Stock [SOBKZ]
    BLDAT,                -- Document Date [BLDAT]
    GIDAT,                -- Plan.Count date [GIDAT]
    ZLDAT,                -- Count Date [DZLDAT]
    BUDAT,                -- Posting Date [BUDAT]
    MONAT,                -- Period [MONAT]
    USNAM,                -- User Name [USNAM]
    SPERR,                -- Posting Block [ISPER]
    ZSTAT,                -- Count Status [DZSTAT]
    DSTAT,                -- Adjust. Status [DSTAT]
    XBLNI,                -- Phys.invent.ref [XBLNI1]
    LSTAT,                -- Deletion Status [LSTAT]
    XBUFI,                -- Freeze Book Inv [XBUFI]
    KEORD,                -- Grouping Type [KEORD]
    ORDNG,                -- Grpg Crit. [ORDNG]
    INVNU,                -- Phys. Inv. No. [INVNU1]
    IBLTXT,               -- Description [IM_PI_DOC_DESCRIPTION]
    INVART,               -- Phys. Inv. Type [INVART]
    LASTCHANGE_DATETIME,  -- Last Change [PI_LAST_CHANGED]
    WSTI_BSTAT,           -- Calc.Status [WSTI_BSTAT]
    PRIMARY KEY (MANDT, IBLNR, GJAHR)
);

Learn More