I_EWM_PHYSICALINVENTORYDOCITEM

CDS View
36 Fields 9 CDS Views

Whse Physical Inventory Document Items

I_EWM_PHYSICALINVENTORYDOCITEM is a CDS View in S/4HANA. Whse Physical Inventory Document Items. It contains 36 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
P_EWM_PhysicalInventoryDocItem view from COMPOSITE Warehouse PI Document Items
P_EWM_PhysicalInventoryItem01 view_entity from COMPOSITE Helper view 01 of I_EWM_PhysicalInventoryItem
P_ewm_physInventorydoccntitem view_entity from COMPOSITE Helper View for Phys. Inv. Count Item
P_EWM_PhysInventoryItemRow01 view_entity from COMPOSITE Private view 01 for Row of PInv Item with Quantity in Whse
P_EWM_PhysInvtryDocItem_2 view_entity from COMPOSITE Warehouse PI Document Items
P_EWM_PhysInvtryItemIndicator view_entity inner COMPOSITE Aggregated indicator for physical inventory item
P_EWM_PhysInvtryStorBinIsEmpty view_entity from COMPOSITE Private view to check if bin is empty
P_EWM_PInvCountItem01 view_entity from CONSUMPTION Help view of PInv Items filter
P_EWM_PInvItemRow_Diff view_entity from COMPOSITE Private view for Row of PInv Item with Quantity in Whse

Fields (36)

KeyField CDS FieldsUsed in Views
KEY LineIndexOfPInvItem LineIndexOfPInvItem 1
KEY PhysicalInventoryChangeVersion PhysicalInventoryChangeVersion 1
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID 4
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber 5
KEY PInvDocumentItemType PInvDocumentItemType 2
CountryOfOrigin CountryOfOrigin 2
DocumentReltdStockDocCat EWMStockReferenceDocCategory 1
DocumentReltdStockDocItemUUID EWMStockRefDocItemUUID 1
DocumentReltdStockDocUUID EWMStockRefDocumentUUID 1
EWMPhysicalInventoryPriority EWMPhysicalInventoryPriority 2
EWMPhysInventoryCountDateTime EWMPhysInventoryCountDateTime 1
EWMPhysInvtryDifferenceReason EWMPhysInvtryDifferenceReason,EWMPhysInvtryReason 2
EWMPhysInvtryReason EWMPhysInvtryReason 1
EWMWarehouse EWMWarehouse 1
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 1
PhysicalInventoryAreaUUID PhysicalInventoryAreaUUID 1
PhysicalInventoryCountUserName PhysicalInventoryCountUserName 3
PhysicalInventoryCreateDate PhysInventoryCrtnUTCDateTime 3
PhysicalInventoryDocumentType PhysicalInventoryDocumentType 4
PhysicalInventoryIsBlock PhysicalInventoryIsBlock 1
PhysicalInventoryPostDate EWMPhysInvtryPostingDateTime 1
PhysicalInventoryStatusText EWMPhysicalInventoryStatus,PhysicalInventoryStatusText 4
PhysicalInventoryStockUUID PhysicalInventoryStockUUID 1
PInvBookQuantityIsFreeze PInvBookQuantityIsFreeze 1
PInvDocumentItemIsPrinted PInvDocumentItemIsPrinted 1
PInvItemParentType PInvItemParentType 1
PInvItemParentUUID PInvItemParentUUID 1
PriorityCode PriorityCode 1
QualityInspectionDocUUID QualityInspectionDocUUID 1
ReasonForPhysInvtryDifference ReasonForPhysInvtryDifference 1
SequenceOfPInvDocumentItems EWMPhysInvtryItemSequenceValue,SequenceOfPInvDocumentItems 2
ShelfLifeExpirationDate ShelfLifeExpirationDate 2
StockIdentificationNumber StockIdentificationNumber 1
Warehouse Warehouse 1
WhseQualityInspectionType WhseQualityInspectionType 1
WhseTaskGoodsReceiptDateTime EWMGoodsReceiptDateTime,WhseTaskGoodsReceiptDateTime 2

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.

-- Whse Physical Inventory Document Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EWM_PHYSICALINVENTORYDOCITEM (
    LINEINDEXOFPINVITEM,
    PHYSICALINVENTORYCHANGEVERSION,
    PHYSICALINVENTORYDOCUMENTUUID,
    PHYSICALINVENTORYITEMNUMBER,
    PINVDOCUMENTITEMTYPE,
    COUNTRYOFORIGIN,
    DOCUMENTRELTDSTOCKDOCCAT,
    DOCUMENTRELTDSTOCKDOCITEMUUID,
    DOCUMENTRELTDSTOCKDOCUUID,
    EWMPHYSICALINVENTORYPRIORITY,
    EWMPHYSINVENTORYCOUNTDATETIME,
    EWMPHYSINVTRYDIFFERENCEREASON,
    EWMPHYSINVTRYREASON,
    EWMWAREHOUSE,
    MATLBATCHISINRSTRCDUSESTOCK,
    PHYSICALINVENTORYAREAUUID,
    PHYSICALINVENTORYCOUNTUSERNAME,
    PHYSICALINVENTORYCREATEDATE,
    PHYSICALINVENTORYDOCUMENTTYPE,
    PHYSICALINVENTORYISBLOCK,
    PHYSICALINVENTORYPOSTDATE,
    PHYSICALINVENTORYSTATUSTEXT,
    PHYSICALINVENTORYSTOCKUUID,
    PINVBOOKQUANTITYISFREEZE,
    PINVDOCUMENTITEMISPRINTED,
    PINVITEMPARENTTYPE,
    PINVITEMPARENTUUID,
    PRIORITYCODE,
    QUALITYINSPECTIONDOCUUID,
    REASONFORPHYSINVTRYDIFFERENCE,
    SEQUENCEOFPINVDOCUMENTITEMS,
    SHELFLIFEEXPIRATIONDATE,
    STOCKIDENTIFICATIONNUMBER,
    WAREHOUSE,
    WHSEQUALITYINSPECTIONTYPE,
    WHSETASKGOODSRECEIPTDATETIME,
    PRIMARY KEY (LINEINDEXOFPINVITEM, PHYSICALINVENTORYCHANGEVERSION, PHYSICALINVENTORYDOCUMENTUUID, PHYSICALINVENTORYITEMNUMBER, PINVDOCUMENTITEMTYPE)
);

Learn More