P_EWM_PINVITEMFLATTENEDROW02

CDS View
6 Fields 1 CDS Views

Private view 02 for Flattened Row of PI Item

P_EWM_PINVITEMFLATTENEDROW02 is a CDS View in S/4HANA. Private view 02 for Flattened Row of PI Item. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EWM_PInvItemFlattenedRow03 view_entity from COMPOSITE Parent node for P_EWM_PInvItemFlattenedRow02

Fields (6)

KeyField CDS FieldsUsed in Views
KEY LineIndexOfPInvItem LineIndexOfPInvItem 1
KEY PhysicalInventoryChangeVersion PhysicalInventoryChangeVersion 1
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID 1
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber 1
KEY PInvDocumentItemType PInvDocumentItemType 1
EWMWarehouse EWMWarehouse 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.

-- Private view 02 for Flattened Row of PI Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EWM_PINVITEMFLATTENEDROW02 (
    LINEINDEXOFPINVITEM,
    PHYSICALINVENTORYCHANGEVERSION,
    PHYSICALINVENTORYDOCUMENTUUID,
    PHYSICALINVENTORYITEMNUMBER,
    PINVDOCUMENTITEMTYPE,
    EWMWAREHOUSE,
    PRIMARY KEY (LINEINDEXOFPINVITEM, PHYSICALINVENTORYCHANGEVERSION, PHYSICALINVENTORYDOCUMENTUUID, PHYSICALINVENTORYITEMNUMBER, PINVDOCUMENTITEMTYPE)
);

Learn More