C_PhysInvtryProposal

Column Name Description
Plant Plant
StorageLocation Storage Location
Material Material Number
Batch Batch Number
Supplier Vendor's account number
SalesOrder Sales Order Number
SalesOrderItem Item Number in Sales Order
WBSElement Work Breakdown Structure Element (WBS Element)
Customer Account number of customer
StockOwner Owner of Stock
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
InventorySpecialStockType Special Stock Type
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
InventoryPrice Physical Inventory Inventory Price
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlWrhsStkQtyInMatlBaseUnit Current Book Quantity
PInvDiffQtyPerYearInBaseUnit Adjusted Quantity Last 12 Months
GdsRcptQtySinceLastCtInBsUnt Received Quantity Since Last Count
AvgStkQtySinceLastCountInBsUnt Average Book Quantity
GdsIssQtySinceLastCountInBsUnt Issued Quantity Since Last Count
Column Name Description
PhysicalInventoryLastCountDate Physical Inventory Last Count Date
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
IsMarkedForDeletion Deletion Indicator Show values
PhysicalInventoryItemIsCounted Item has been counted Show values
Column Name Description Domain name
CycleCountType Physical Inventory Indicator for Cycle Counting ABCIN
NmbrOfPhysInvtryPerFiscalYear No. of Phys. Inventories per Fiscal Year for Cycle Counting NUM3
PhysInvtryIntvlForCycCounting Physical Inventory Interval (in Workdays) for Cycle Counting NUM3
PhysInvtryFloatTimeCycCounting Float Time (in Workdays) for Cycle Counting NUM2
WBSElementInternalID Valuated Sales Order Stock WBS Element PS_POSNR
WBSDescription WBS Element Name TEXT40
ProductType null
ProductGroup null
SerialIdentifierAssgmtProfile Serial Number Profile SERAIL
WarehouseStorageBin Storage Bin CHAR10
MaterialPriceUnitQty Price Unit PACK3
NumberOfPhysInventoryCounts Number of PI Counts in the current Fiscal Year
NumberOfPInvAdjustmentsPerYear Count Adjustments Last 12 Months
NmbrOfDaysSinceLastPInvCount null
NrOfGdsRcptSinceLastPInvCount Goods Receipts Since Last Count
InvtryTurnoverSinceLastCnt Turnover Since Last Count
NrOfGoodsIssSinceLastPInvCount Goods Issues Since Last Count
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • C_PHYSINVTRYPROPOSAL.MANDT == TCURC.MANDT
  • C_PHYSINVTRYPROPOSAL.COMPANYCODECURRENCY == TCURC.WAERS