P_PHYSINVTRYDOCITEM

CDS View
70 Fields 6 CDS Views

P_PHYSINVTRYDOCITEM is a CDS View in S/4HANA. It contains 70 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_PhysInvtryDocItemObjPage view from CONSUMPTION PI Document Item Object Page
P_MappedPhysInvtryItem view from COMPOSITE
P_PhysInventorySituation view from COMPOSITE
P_PhysInventorySituation view left_outer COMPOSITE
P_PhysInvtryCountSitnInstOfDoc view from CONSUMPTION Physical Inv count Situation Instances
P_PhysInvtryDocItmCreateTP view from CONSUMPTION

Fields (70)

KeyField CDS FieldsUsed in Views
KEY FiscalYear FiscalYear 2
KEY PhysicalInventoryDocument PhysicalInventoryDocument 2
KEY PhysicalInventoryDocumentItem PhysicalInventoryDocumentItem 2
_CrossPlantConfigurableMatl _CrossPlantConfigurableMatl 1
_Currency _Currency 1
_Customer _Customer 2
_CustomerCompanyByPlant _CustomerCompanyByPlant 2
_GoodsMovementType _GoodsMovementType 1
_InventorySpecialStockType _InventorySpecialStockType 1
_Material _Material 1
_MaterialBaseUnit _MaterialBaseUnit 1
_PhysicalInventoryStockType _PhysicalInventoryStockType 1
_PhysInvtryReasonCode _PhysInvtryReasonCode 1
_Plant _Plant 1
_ProductCategory _ProductCategory 1
_StorageLocation _StorageLocation 1
_Supplier _Supplier 2
_SupplierCompanyByPlant _SupplierCompanyByPlant 2
_UnitOfEntry _UnitOfEntry 1
Batch Batch 2
BookQtyAmountInCoCodeCrcy BookQtyAmountInCoCodeCrcy 1
BookQtyBfrCountInMatlBaseUnit BookQtyBfrCountInMatlBaseUnit 1
CrossPlantConfigurableMaterial CrossPlantConfigurableMaterial 1
Currency Currency 1
Customer Customer 2
CycleCountType CycleCountType 1
DiffCountedBookAmtInCoCodeCry DiffCountedBookAmtInCoCodeCry 1
DifferenceAmountInCoCodeCrcy DifferenceAmountInCoCodeCrcy 1
DifferenceQuantityInBaseUnit DifferenceQuantityInBaseUnit 1
EnteredSlsAmtInCoCodeCrcy EnteredSlsAmtInCoCodeCrcy 1
GoodsMovementType GoodsMovementType 1
InventorySpecialStockType InventorySpecialStockType 1
IsHandledInAltvUnitOfMsr IsHandledInAltvUnitOfMsr 1
IsValueOnlyMaterial IsValueOnlyMaterial 1
LastChangeDate LastChangeDate 1
Material Material 2
MaterialBaseUnit MaterialBaseUnit 1
MaterialDocument MaterialDocument 1
MaterialDocumentItem MaterialDocumentItem 1
MaterialDocumentYear MaterialDocumentYear 1
NmbrOfPhysInvtryPerFiscalYear NmbrOfPhysInvtryPerFiscalYear 1
PhysicalInventoryItemIsCounted PhysicalInventoryItemIsCounted 1
PhysicalInventoryItemIsZero PhysicalInventoryItemIsZero 1
PhysicalInventoryLastCountDate PhysicalInventoryLastCountDate 1
PhysicalInventoryStockType PhysicalInventoryStockType 2
PhysInvtryCtAmtInCoCodeCrcy PhysInvtryCtAmtInCoCodeCrcy 1
PhysInvtryDifferenceIsPosted PhysInvtryDifferenceIsPosted 1
PhysInvtryDiffIsDistributed PhysInvtryDiffIsDistributed 1
PhysInvtryFloatTimeCycCounting PhysInvtryFloatTimeCycCounting 1
PhysInvtryIntvlForCycCounting PhysInvtryIntvlForCycCounting 1
PhysInvtryItemIsDeleted PhysInvtryItemIsDeleted 1
PhysInvtryItemIsRecounted PhysInvtryItemIsRecounted 1
PhysInvtrySitnID PhysInvtrySitnID 1
Plant Plant 2
PostingDate PostingDate 1
ProductCategory ProductCategory 1
Quantity Quantity 1
QuantityInUnitOfEntry QuantityInUnitOfEntry 1
RealProductBatch RealProductBatch 1
ReasonForPhysInvtryDifference ReasonForPhysInvtryDifference 1
SalesOrder SalesOrder 2
SalesOrderItem SalesOrderItem 2
ScheduleLine ScheduleLine 1
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy 1
StockOwner StockOwner 2
StorageLocation StorageLocation 1
Supplier Supplier 2
UnitOfEntry UnitOfEntry 1
ValuationType ValuationType 1
WBSElementInternalID WBSElementInternalID 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_PHYSINVTRYDOCITEM (
    FISCALYEAR,
    PHYSICALINVENTORYDOCUMENT,
    PHYSICALINVENTORYDOCUMENTITEM,
    _CROSSPLANTCONFIGURABLEMATL,
    _CURRENCY,
    _CUSTOMER,
    _CUSTOMERCOMPANYBYPLANT,
    _GOODSMOVEMENTTYPE,
    _INVENTORYSPECIALSTOCKTYPE,
    _MATERIAL,
    _MATERIALBASEUNIT,
    _PHYSICALINVENTORYSTOCKTYPE,
    _PHYSINVTRYREASONCODE,
    _PLANT,
    _PRODUCTCATEGORY,
    _STORAGELOCATION,
    _SUPPLIER,
    _SUPPLIERCOMPANYBYPLANT,
    _UNITOFENTRY,
    BATCH,
    BOOKQTYAMOUNTINCOCODECRCY,
    BOOKQTYBFRCOUNTINMATLBASEUNIT,
    CROSSPLANTCONFIGURABLEMATERIAL,
    CURRENCY,
    CUSTOMER,
    CYCLECOUNTTYPE,
    DIFFCOUNTEDBOOKAMTINCOCODECRY,
    DIFFERENCEAMOUNTINCOCODECRCY,
    DIFFERENCEQUANTITYINBASEUNIT,
    ENTEREDSLSAMTINCOCODECRCY,
    GOODSMOVEMENTTYPE,
    INVENTORYSPECIALSTOCKTYPE,
    ISHANDLEDINALTVUNITOFMSR,
    ISVALUEONLYMATERIAL,
    LASTCHANGEDATE,
    MATERIAL,
    MATERIALBASEUNIT,
    MATERIALDOCUMENT,
    MATERIALDOCUMENTITEM,
    MATERIALDOCUMENTYEAR,
    NMBROFPHYSINVTRYPERFISCALYEAR,
    PHYSICALINVENTORYITEMISCOUNTED,
    PHYSICALINVENTORYITEMISZERO,
    PHYSICALINVENTORYLASTCOUNTDATE,
    PHYSICALINVENTORYSTOCKTYPE,
    PHYSINVTRYCTAMTINCOCODECRCY,
    PHYSINVTRYDIFFERENCEISPOSTED,
    PHYSINVTRYDIFFISDISTRIBUTED,
    PHYSINVTRYFLOATTIMECYCCOUNTING,
    PHYSINVTRYINTVLFORCYCCOUNTING,
    PHYSINVTRYITEMISDELETED,
    PHYSINVTRYITEMISRECOUNTED,
    PHYSINVTRYSITNID,
    PLANT,
    POSTINGDATE,
    PRODUCTCATEGORY,
    QUANTITY,
    QUANTITYINUNITOFENTRY,
    REALPRODUCTBATCH,
    REASONFORPHYSINVTRYDIFFERENCE,
    SALESORDER,
    SALESORDERITEM,
    SCHEDULELINE,
    SLSPRICEAMOUNTINCOCODECRCY,
    STOCKOWNER,
    STORAGELOCATION,
    SUPPLIER,
    UNITOFENTRY,
    VALUATIONTYPE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (FISCALYEAR, PHYSICALINVENTORYDOCUMENT, PHYSICALINVENTORYDOCUMENTITEM)
);

Learn More