C_BR_ReportingInventoryCube

Column Name Description
CompanyCode Company Code
BusinessPlace FK Business Place
Column Name Description
💲 Currency Key (Currency):
InventoryPrice null
StockValueInCCCrcy Stock Value in Company Code Currency
Column Name Description
📏 Base Unit of Measure (MaterialBaseUnit):
MatlWrhsStkQtyInMatlBaseUnit Stock Quantity in Base Unit of Measure
Column Name Description
CnsmpnLatestPostgDate Date of Last Consumption Posting
MatlDocLatestPostgDate Date of Last Posting
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
Column Name Description Domain name
BR_SPEDReportRegister null
Material Material in Respect of Which Stock is Managed MATNR
Plant Plant WERKS
StorageLocation Storage location LGORT
Batch Batch Number (Stock Identifier) CHARG
Supplier Supplier for Special Stock LIFNR
SDDocument Sales order number of valuated sales order stock VBELN
SDDocumentItem Sales Order Item of Valuated Sales Order Stock NUM06
WBSElementInternalID Valuated Sales Order Stock WBS Element PS_POSNR
Customer Customer for Special Stock KUNNR
BusinessPartner null
SpecialStockIdfgStockOwner Add. Supplier for Special Stock LIFNR
InventorySpecialStockType null
CostEstimate Cost Estimate Number - Product Costing CK_KALNR
MaterialPriceUnitQty null
StockValueInCCCrcyEnd null
NumberOfDaysSinceLastCnsmpn Number of Days Since Last Consumption Posting
NumberOfDaysSinceLastMovement Number of Days Since Last Posting
MaterialGroupName Material Group Description TEXT20
MaterialTypeName Description of Material Type TEXT25
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
InventoryValuationType Valuation Type BWTAR
Note null
ReasonCode null
ResourceSortText null
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_BR_REPORTINGINVENTORYCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • C_BR_REPORTINGINVENTORYCUBE.MANDT == T004.MANDT
G/L Account Number (Debit)
  • G/L Account Number (Debit)
  • Chart of Accounts
  • Client
  • C_BR_REPORTINGINVENTORYCUBE.GLACCOUNTDETERMINATION == SKA1.SAKNR
  • C_BR_REPORTINGINVENTORYCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
  • C_BR_REPORTINGINVENTORYCUBE.MANDT == SKA1.MANDT
Valuation area/valuation category
  • Valuation area
  • Valuation Category
  • Client
  • C_BR_REPORTINGINVENTORYCUBE.VALUATIONAREA == T149.BWKEY
  • C_BR_REPORTINGINVENTORYCUBE.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • C_BR_REPORTINGINVENTORYCUBE.MANDT == T149.MANDT
Material Group
  • Material Group
  • Client
  • C_BR_REPORTINGINVENTORYCUBE.MATERIALGROUP == T023.MATKL
  • C_BR_REPORTINGINVENTORYCUBE.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • C_BR_REPORTINGINVENTORYCUBE.MATERIALTYPE == T134.MTART
  • C_BR_REPORTINGINVENTORYCUBE.MANDT == T134.MANDT
Valuation Class
  • Valuation Class
  • Client
  • C_BR_REPORTINGINVENTORYCUBE.MATERIALVALUATIONCLASS == T025.BKLAS
  • C_BR_REPORTINGINVENTORYCUBE.MANDT == T025.MANDT
Valuation area
  • Valuation area
  • Client
  • C_BR_REPORTINGINVENTORYCUBE.VALUATIONAREA == T001K.BWKEY
  • C_BR_REPORTINGINVENTORYCUBE.MANDT == T001K.MANDT