FAC_DART_Z3_MI_BALANCE_GB_T

Material Inventory - Balance Summary | view: FAC_DZMIBSGT | Extraction: Not supported | Component: DART (Data Retention Tool)
Column Name Description
CompanyCode FK Company Code
Ledger FK Ledger
GLAccount FK G/L Account
Material FK Material Number
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
InventoryValue null
Column Name Description
📏 Cost Source Unit (BaseUnit):
InventoryQuantity null
Column Name Description
Column Name Description
Column Name Description Domain name
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
  • Cost Source Unit
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_T.BASEUNIT == T006.MSEHI
  • FAC_DART_Z3_MI_BALANCE_GB_T.MANDT == T006.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_T.CHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_MI_BALANCE_GB_T.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_T.COMPANYCODE == T001.BUKRS
  • FAC_DART_Z3_MI_BALANCE_GB_T.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_T.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_MI_BALANCE_GB_T.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_T.FISCALYEARVARIANT == T009.PERIV
  • FAC_DART_Z3_MI_BALANCE_GB_T.MANDT == T009.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_T.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_MI_BALANCE_GB_T.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_MI_BALANCE_GB_T.MANDT == SKB1.MANDT
Ledger
  • Client
  • Ledger
Material Number
  • Material Number
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_T.MATERIAL == MARA.MATNR
  • FAC_DART_Z3_MI_BALANCE_GB_T.MANDT == MARA.MANDT