FAC_DART_Z3_MI_BALANCE_GB_I

Material Inventory - Balance Summary | view: FAC_DZMIBSGI | Extraction: Not supported | Component: DART (Data Retention Tool)
Column Name Description
CompanyCode FK Company Code
Ledger FK Ledger
GLAccount FK G/L Account
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Material FK Material Number
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
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
MaterialGroup Product Group MATKL
Plant Plant WERKS
Master Data Relations Join Conditions
Cost Source Unit
  • Cost Source Unit
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_I.BASEUNIT == T006.MSEHI
  • FAC_DART_Z3_MI_BALANCE_GB_I.MANDT == T006.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_I.CHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_MI_BALANCE_GB_I.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_I.COMPANYCODE == T001.BUKRS
  • FAC_DART_Z3_MI_BALANCE_GB_I.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • FAC_DART_Z3_MI_BALANCE_GB_I.MANDT == TCURC.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_I.COMPANYCODECURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_I.FISCALYEARVARIANT == T009.PERIV
  • FAC_DART_Z3_MI_BALANCE_GB_I.MANDT == T009.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • FAC_DART_Z3_MI_BALANCE_GB_I.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_MI_BALANCE_GB_I.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_MI_BALANCE_GB_I.MANDT == SKB1.MANDT
Ledger
  • Client
  • Ledger
Material Number
  • Client
  • Material Number
  • FAC_DART_Z3_MI_BALANCE_GB_I.MANDT == MARA.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_I.MATERIAL == MARA.MATNR