I_PHYSINVTRYDOCITEM

CDS View
6 Fields 9 CDS Views

Physical Inventory Document Item

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

CDS Views using this table (9)

ViewTypeJoinVDMDescription
A_PhysInventoryDocItem view_entity from BASIC Document Items
C_PhysInvtryDocItemDP view_entity from CONSUMPTION Physical Inventory Document Item
C_PhysInvtryDocItemForPrint view_entity from CONSUMPTION Physical Inventory Doc Item for Print
I_AugmentedPhysInvtryDocItem view_entity from COMPOSITE Augmented Physical Inventory Doc Item
P_PhysInvtryDocHdrItemTotals view_entity from CONSUMPTION PI Document Header Item Totals
P_PhysInvtryDocHdrItemTotals view_entity inner CONSUMPTION PI Document Header Item Totals
P_PhysInvtryDocItem view_entity from COMPOSITE PI Document Calculate Difference Values
P_PhysInvtryMngItmListDocItemQ view_entity from CONSUMPTION Private View for Physical Inventory Document Items
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