P_EWM_PINVCOUNTITEM02

CDS View
34 Fields 2 CDS Views

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EWM_PINVCOUNTITEM03 view from CONSUMPTION
P_EWM_PINVCOUNTITEM04 view from CONSUMPTION

Fields (34)

KeyField CDS FieldsUsed in Views
KEY LineIndexOfPInvItem LineIndexOfPInvItem 2
KEY PhysicalInventoryChangeVersion PhysicalInventoryChangeVersion 2
KEY PhysicalInventoryDocumentUUID PhysicalInventoryDocumentUUID 2
KEY PhysicalInventoryItemNumber PhysicalInventoryItemNumber 2
KEY PInvDocumentItemType PInvDocumentItemType 2
BatchUUID BatchUUID 1
BookQtyOfPInvItemInBookQtyUoM BookQtyOfPInvItemInBookQtyUoM 1
BookQuantityUnitOfMeasure BookQuantityUnitOfMeasure 1
CountryOfOrigin CountryOfOrigin 1
EntitledToDisposeParty EntitledToDisposeParty 1
EWMStockOwner EWMStockOwner 1
EWMStockType EWMStockType 1
EWMStockUsage EWMStockUsage 1
EWMWarehouse EWMWarehouse 1
HandlingUnitNumber HandlingUnitNumber 2
ParentHandlingUnitNumber ParentHandlingUnitNumber 1
ParentStorageBin ParentStorageBin 1
PhysicalInventoryDocumentType PhysicalInventoryDocumentType 1
PhysicalInventoryStatusText PhysicalInventoryStatusText 1
PhysicalInventoryStockUUID PhysicalInventoryStockUUID 1
PInvItemParentType PInvItemParentType 1
PInvItemParentUUID PInvItemParentUUID 1
ProducedMaterial ProducedMaterial 1
ProductUUID ProductUUID 1
SequenceOfPInvDocumentItems SequenceOfPInvDocumentItems 1
ShelfLifeExpirationDate ShelfLifeExpirationDate 1
StockDocumentCategory StockDocumentCategory 1
StockDocumentNumber StockDocumentNumber 1
StockItemNumber StockItemNumber 1
StockOwner StockOwner 1
StockType StockType 1
StockUsage StockUsage 1
Warehouse Warehouse 1
WhseTaskGoodsReceiptDateTime WhseTaskGoodsReceiptDateTime 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_EWM_PINVCOUNTITEM02 (
    LINEINDEXOFPINVITEM,
    PHYSICALINVENTORYCHANGEVERSION,
    PHYSICALINVENTORYDOCUMENTUUID,
    PHYSICALINVENTORYITEMNUMBER,
    PINVDOCUMENTITEMTYPE,
    BATCHUUID,
    BOOKQTYOFPINVITEMINBOOKQTYUOM,
    BOOKQUANTITYUNITOFMEASURE,
    COUNTRYOFORIGIN,
    ENTITLEDTODISPOSEPARTY,
    EWMSTOCKOWNER,
    EWMSTOCKTYPE,
    EWMSTOCKUSAGE,
    EWMWAREHOUSE,
    HANDLINGUNITNUMBER,
    PARENTHANDLINGUNITNUMBER,
    PARENTSTORAGEBIN,
    PHYSICALINVENTORYDOCUMENTTYPE,
    PHYSICALINVENTORYSTATUSTEXT,
    PHYSICALINVENTORYSTOCKUUID,
    PINVITEMPARENTTYPE,
    PINVITEMPARENTUUID,
    PRODUCEDMATERIAL,
    PRODUCTUUID,
    SEQUENCEOFPINVDOCUMENTITEMS,
    SHELFLIFEEXPIRATIONDATE,
    STOCKDOCUMENTCATEGORY,
    STOCKDOCUMENTNUMBER,
    STOCKITEMNUMBER,
    STOCKOWNER,
    STOCKTYPE,
    STOCKUSAGE,
    WAREHOUSE,
    WHSETASKGOODSRECEIPTDATETIME,
    PRIMARY KEY (LINEINDEXOFPINVITEM, PHYSICALINVENTORYCHANGEVERSION, PHYSICALINVENTORYDOCUMENTUUID, PHYSICALINVENTORYITEMNUMBER, PINVDOCUMENTITEMTYPE)
);

Learn More