I_DARTMatlInvtryBalanceCube

Matl Invtry Balance Interface for DART | view: IDZMIBALSUMC | TRAN | Extraction: Not supported | Component: DART (Data Retention Tool)
Column Name Description
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
📏 Cost Source Unit (BaseUnit):
InventoryQty Inventory Quantity
Column Name Description
Column Name Description
IsLIFOAndFIFORelevant LIFO/FIFO-Relevant Show values
Column Name Description Domain name
SAPClient 3-Byte field CHAR3
FiscalYear Fiscal Year GJAHR
FiscalPeriod null
InventoryValuationCategoryName Inventory Valuation Category Name BTBEZ
MaterialUsabilityProfileName Description of valuation class TEXT25
GLAccountLongName G/L Account Long Text TEXT50
MaterialGroup Product Group MATKL
MaterialGroupName Product Group Description TEXT20
MaterialName Material Description TEXT40
Plant Plant WERKS
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Cost Source Unit
  • Client
  • Cost Source Unit
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == T006.MANDT
  • I_DARTMATLINVTRYBALANCECUBE.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == T001.MANDT
  • I_DARTMATLINVTRYBALANCECUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == TCURC.MANDT
  • I_DARTMATLINVTRYBALANCECUBE.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_DARTMATLINVTRYBALANCECUBE.GLACCOUNT == SKB1.SAKNR
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == SKB1.MANDT
  • I_DARTMATLINVTRYBALANCECUBE.COMPANYCODE == SKB1.BUKRS
Valuation area/valuation category
  • Valuation Category
  • Valuation area
  • Client
  • I_DARTMATLINVTRYBALANCECUBE.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • I_DARTMATLINVTRYBALANCECUBE.VALUATIONAREA == T149.BWKEY
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == T149.MANDT
Valuation Type
  • Valuation Type
  • Client
  • I_DARTMATLINVTRYBALANCECUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == T149D.MANDT
Ledger
  • Ledger
  • Client
LIFO valuation key/pool number
  • Pool number for LIFO valuation
  • Client
  • ?
  • I_DARTMATLINVTRYBALANCECUBE.LIFOVALUATIONPOOLNUMBER == TPOOL.MYPOOL
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == TPOOL.MANDT
  • I_DARTMATLINVTRYBALANCECUBE.[column in domain "MYKEY"] == TPOOL.MYKEY
Material Number
  • Material Number
  • Client
  • I_DARTMATLINVTRYBALANCECUBE.MATERIAL == MARA.MATNR
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == MARA.MANDT
Valuation Class
  • Valuation Class
  • Client
  • I_DARTMATLINVTRYBALANCECUBE.MATERIALVALUATIONCLASS == T025.BKLAS
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == T025.MANDT
Valuation area
  • Client
  • Valuation area
  • I_DARTMATLINVTRYBALANCECUBE.MANDT == T001K.MANDT
  • I_DARTMATLINVTRYBALANCECUBE.VALUATIONAREA == T001K.BWKEY