FAC_DART_Z3_MI_BALANCE_GB_BCF

Material Inventory - Balance Summary | view: FAC_DZMIBSGBCF | 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
NextFiscalYear Fiscal Year GJAHR
PostingFiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
MaterialGroup Product Group MATKL
Plant Plant WERKS
Master Data Relations Join Conditions
Cost Source Unit
  • Client
  • Cost Source Unit
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MANDT == T006.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Client
  • Chart of Accounts
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MANDT == T004.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MANDT == T001.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MANDT == TCURC.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.COMPANYCODECURRENCY == TCURC.WAERS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MANDT == T009.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.FISCALYEARVARIANT == T009.PERIV
G/L Account
  • G/L Account
  • Client
  • Company Code
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MANDT == SKB1.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.COMPANYCODE == SKB1.BUKRS
Ledger
  • Ledger
  • Client
Material Number
  • Client
  • Material Number
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MANDT == MARA.MANDT
  • FAC_DART_Z3_MI_BALANCE_GB_BCF.MATERIAL == MARA.MATNR