I_EWM_PINVDOCITEMLOG

CDS View
7 Fields 2 CDS Views

Log of Warehouse Physical Inventory Item

I_EWM_PINVDOCITEMLOG is a CDS View in S/4HANA. Log of Warehouse Physical Inventory Item. It contains 7 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EWM_PInvDocInWhseOrd01 view_entity from CONSUMPTION Help view of warehouse orders in PI doc
P_EWM_PInvDocItemLastChange view_entity from COMPOSITE Physical Inventory Last Change Date Time

Fields (7)

KeyField CDS FieldsUsed in Views
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID 1
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber 1
KEY PhysicalInventoryRefDocNumber PhysicalInventoryRefDocNumber 1
PhysicalInventoryLogByUserName PhysicalInventoryLogByUserName 1
PhysicalInventoryProcessType PhysicalInventoryProcessType 1
PhysicalInventoryRefDocType PhysicalInventoryRefDocType 1
PInvLogItemTimeStamp PInvLogItemTimeStamp 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.

-- Log of Warehouse Physical Inventory Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_PINVDOCITEMLOG (
    PHYSICALINVENTORYDOCUMENTUUID,
    PHYSICALINVENTORYITEMNUMBER,
    PHYSICALINVENTORYREFDOCNUMBER,
    PHYSICALINVENTORYLOGBYUSERNAME,
    PHYSICALINVENTORYPROCESSTYPE,
    PHYSICALINVENTORYREFDOCTYPE,
    PINVLOGITEMTIMESTAMP,
    PRIMARY KEY (PHYSICALINVENTORYDOCUMENTUUID, PHYSICALINVENTORYITEMNUMBER, PHYSICALINVENTORYREFDOCNUMBER)
);

Learn More