P_EWM_PINVDOCINWHSEORD03

CDS View

Help view of warehouse orders in PI doc

P_EWM_PINVDOCINWHSEORD03 is a CDS View in S/4HANA. Help view of warehouse orders in PI doc. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_EWM_PInvDocInWhseOrd04 view from CONSUMPTION Help view of warehouse orders in PI doc

Fields (13)

KeyField CDS FieldsUsed in Views
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID 1
KEY WarehouseOrder WarehouseOrder 1
ActivityArea ActivityArea 1
EWMWarehouse EWMWarehouse 1
PhysicalInventoryArea PhysicalInventoryArea 1
PhysicalInventoryDocNumber PhysicalInventoryDocNumber 1
PhysicalInventoryDocumentType PhysicalInventoryDocumentType 1
PhysicalInventoryDocYear PhysicalInventoryDocYear 1
PhysicalInventoryLogByUserName PhysicalInventoryLogByUserName 1
PInvLogItemTimeStamp PInvLogItemTimeStamp 1
PInvPrintedTimeStamp PInvPrintedTimeStamp 1
TimeZoneID TimeZoneID 1
Warehouse Warehouse 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.

-- Help view of warehouse orders in PI doc
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EWM_PINVDOCINWHSEORD03 (
    PHYSICALINVENTORYDOCUMENTUUID,
    WAREHOUSEORDER,
    ACTIVITYAREA,
    EWMWAREHOUSE,
    PHYSICALINVENTORYAREA,
    PHYSICALINVENTORYDOCNUMBER,
    PHYSICALINVENTORYDOCUMENTTYPE,
    PHYSICALINVENTORYDOCYEAR,
    PHYSICALINVENTORYLOGBYUSERNAME,
    PINVLOGITEMTIMESTAMP,
    PINVPRINTEDTIMESTAMP,
    TIMEZONEID,
    WAREHOUSE,
    PRIMARY KEY (PHYSICALINVENTORYDOCUMENTUUID, WAREHOUSEORDER)
);