P_EWM_PINVITEMFLATTENEDROW06

CDS View
14 Fields 1 CDS Views

Private view 06 for Flattened Row of PI Item

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EWM_PInvItemFlattenedRow view_entity from COMPOSITE Flattened Row of PInv Item in Warehouse

Fields (14)

KeyField CDS FieldsUsed in Views
KEY LineIndexOfPInvItem LineIndexOfPInvItem 1
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber 1
CountryOfOrigin CountryOfOrigin 1
EWMGoodsReceiptDateTime EWMGoodsReceiptDateTime 1
EWMPhysicalInventoryStatus EWMPhysicalInventoryStatus 1
EWMStockRefDocItemUUID EWMStockRefDocItemUUID 1
EWMStockRefDocumentUUID EWMStockRefDocumentUUID 1
EWMStockReferenceDocCategory EWMStockReferenceDocCategory 1
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 1
PhysicalInventoryStockUUID PhysicalInventoryStockUUID 1
QualityInspectionDocUUID QualityInspectionDocUUID 1
ShelfLifeExpirationDate ShelfLifeExpirationDate 1
StockIdentificationNumber StockIdentificationNumber 1
WhseQualityInspectionType WhseQualityInspectionType 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 06 for Flattened Row of PI Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EWM_PINVITEMFLATTENEDROW06 (
    LINEINDEXOFPINVITEM,
    PHYSICALINVENTORYITEMNUMBER,
    COUNTRYOFORIGIN,
    EWMGOODSRECEIPTDATETIME,
    EWMPHYSICALINVENTORYSTATUS,
    EWMSTOCKREFDOCITEMUUID,
    EWMSTOCKREFDOCUMENTUUID,
    EWMSTOCKREFERENCEDOCCATEGORY,
    MATLBATCHISINRSTRCDUSESTOCK,
    PHYSICALINVENTORYSTOCKUUID,
    QUALITYINSPECTIONDOCUUID,
    SHELFLIFEEXPIRATIONDATE,
    STOCKIDENTIFICATIONNUMBER,
    WHSEQUALITYINSPECTIONTYPE,
    PRIMARY KEY (LINEINDEXOFPINVITEM, PHYSICALINVENTORYITEMNUMBER)
);

Learn More