P_EWM_PHYSINVENTORYDOCCNTITEM

CDS View
43 Fields 2 CDS Views

P_EWM_PHYSINVENTORYDOCCNTITEM is a CDS View in S/4HANA. It contains 43 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EWM_PINVDOCCNTITEM01 view from COMPOSITE
P_EWM_PINVDOCCNTITEM01_2 view_entity from COMPOSITE

Fields (43)

KeyField CDS FieldsUsed in Views
KEY LineIndexOfPInvItem LineIndexOfPInvItem 2
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID 2
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber 2
KEY PInvQuantitySequence PInvQuantitySequence 2
BatchUUID BatchUUID 2
CountryOfOrigin CountryOfOrigin 2
DocumentReltdStockDocCat DocumentReltdStockDocCat 2
DocumentReltdStockDocItemUUID DocumentReltdStockDocItemUUID 2
DocumentReltdStockDocUUID DocumentReltdStockDocUUID 2
EntitledToDisposePartnerRole EntitledToDisposePartnerRole 2
EntitledToDisposeParty EntitledToDisposeParty 2
EWMStockOwner EWMStockOwner 2
EWMStockType EWMStockType 2
EWMStockUsage EWMStockUsage 2
EWMStorageBin EWMStorageBin 2
EWMWarehouse EWMWarehouse 2
HandlingUnitType HandlingUnitType 2
MatlBatchIsInRstrcdUseStock MatlBatchIsInRstrcdUseStock 2
PackagingMaterial PackagingMaterial 2
ParentHandlingUnitNumber ParentHandlingUnitNumber 2
PhysicalInventoryDocumentType PhysicalInventoryDocumentType 2
PhysicalInventoryStatusText PhysicalInventoryStatusText 2
PhysicalInventoryStockUUID PhysicalInventoryStockUUID 2
PInvDocumentItemType PInvDocumentItemType 2
PInvItemChgUTCDateTime PInvItemChgUTCDateTime 2
PInvItemParentUUID PInvItemParentUUID 2
ProductUUID ProductUUID 2
QualityInspectionDocUUID QualityInspectionDocUUID 2
RequestedQuantity RequestedQuantity 2
RequestedQuantityUnit RequestedQuantityUnit 2
ShelfLifeExpirationDate ShelfLifeExpirationDate 2
StockDocumentCategory StockDocumentCategory 2
StockDocumentNumber StockDocumentNumber 2
StockIdentificationNumber StockIdentificationNumber 2
StockItemNumber StockItemNumber 2
StockOwner StockOwner 1
StockOwnerPartnerRole StockOwnerPartnerRole 2
StockType StockType 1
StockUsage StockUsage 1
StorageBin StorageBin 1
Warehouse Warehouse 1
WhseQualityInspectionType WhseQualityInspectionType 2
WhseTaskGoodsReceiptDateTime 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EWM_PHYSINVENTORYDOCCNTITEM (
    LINEINDEXOFPINVITEM,
    PHYSICALINVENTORYDOCUMENTUUID,
    PHYSICALINVENTORYITEMNUMBER,
    PINVQUANTITYSEQUENCE,
    BATCHUUID,
    COUNTRYOFORIGIN,
    DOCUMENTRELTDSTOCKDOCCAT,
    DOCUMENTRELTDSTOCKDOCITEMUUID,
    DOCUMENTRELTDSTOCKDOCUUID,
    ENTITLEDTODISPOSEPARTNERROLE,
    ENTITLEDTODISPOSEPARTY,
    EWMSTOCKOWNER,
    EWMSTOCKTYPE,
    EWMSTOCKUSAGE,
    EWMSTORAGEBIN,
    EWMWAREHOUSE,
    HANDLINGUNITTYPE,
    MATLBATCHISINRSTRCDUSESTOCK,
    PACKAGINGMATERIAL,
    PARENTHANDLINGUNITNUMBER,
    PHYSICALINVENTORYDOCUMENTTYPE,
    PHYSICALINVENTORYSTATUSTEXT,
    PHYSICALINVENTORYSTOCKUUID,
    PINVDOCUMENTITEMTYPE,
    PINVITEMCHGUTCDATETIME,
    PINVITEMPARENTUUID,
    PRODUCTUUID,
    QUALITYINSPECTIONDOCUUID,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYUNIT,
    SHELFLIFEEXPIRATIONDATE,
    STOCKDOCUMENTCATEGORY,
    STOCKDOCUMENTNUMBER,
    STOCKIDENTIFICATIONNUMBER,
    STOCKITEMNUMBER,
    STOCKOWNER,
    STOCKOWNERPARTNERROLE,
    STOCKTYPE,
    STOCKUSAGE,
    STORAGEBIN,
    WAREHOUSE,
    WHSEQUALITYINSPECTIONTYPE,
    WHSETASKGOODSRECEIPTDATETIME,
    PRIMARY KEY (LINEINDEXOFPINVITEM, PHYSICALINVENTORYDOCUMENTUUID, PHYSICALINVENTORYITEMNUMBER, PINVQUANTITYSEQUENCE)
);

Learn More