I_PHYSINVTRYDOCITEM

CDS View
6 Fields 7 CDS Views

Physical Inventory Document Item

I_PHYSINVTRYDOCITEM is a CDS View in S/4HANA. Physical Inventory Document Item. It contains 6 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_PhysInventoryDocItem view from BASIC Document Items
C_PhysInvtryDocItemForPrint view from CONSUMPTION Physical Inventory Doc Item for Print
I_AugmentedPhysInvtryDocItem view from COMPOSITE Augmented Physical Inventory Doc Item
P_PhysInvtryDocHdrItemTotals view from CONSUMPTION
P_PhysInvtryDocHdrItemTotals view inner CONSUMPTION
P_PhysInvtryDocItem view from COMPOSITE
V_Mmim_DDL_Om_Param_PI view from Physical Inventory Parameters

Fields (6)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear,PhysicalInventoryYear 2
KEY mandt SAPClient 1
KEY PhysicalInventoryDocument PhysicalInventoryDocument 2
PhysicalInventoryDocumentItem PhysicalInventoryItem 1
Plant Plant 2
StorageLocation StorageLocation 1

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.

-- Physical Inventory Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PHYSINVTRYDOCITEM (
    FISCALYEAR,
    MANDT,
    PHYSICALINVENTORYDOCUMENT,
    PHYSICALINVENTORYDOCUMENTITEM,
    PLANT,
    STORAGELOCATION,
    PRIMARY KEY (FISCALYEAR, MANDT, PHYSICALINVENTORYDOCUMENT)
);

Learn More