FAC_DART_Z3_MI_LINEITEM_BASE

Column Name Description
SourceLedger FK Source Ledger
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
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
MaterialGroup Product Group MATKL
PlantName Plant Name TEXT30
FiscalPeriod Fiscal Period POPER
OriginalReferenceDocument Object key AWKEY
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == T003.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Cost Source Unit
  • Client
  • Cost Source Unit
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == T006.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Client
  • Chart of Accounts
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == T004.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == T001.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == TCURC.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.COMPANYCODECURRENCY == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == SKB1.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_MI_LINEITEM_BASE.COMPANYCODE == SKB1.BUKRS
Ledger
  • Client
  • Ledger
  • Source Ledger
Material Number
  • Client
  • Material Number
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == MARA.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == T001W.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.PLANT == T001W.WERKS
Reference Document Type FAC_DART_Z3_MI_LINEITEM_BASE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Source Ledger
  • Client
  • Ledger
  • Source Ledger
Valuation area
  • Client
  • Valuation area
  • FAC_DART_Z3_MI_LINEITEM_BASE.MANDT == T001K.MANDT
  • FAC_DART_Z3_MI_LINEITEM_BASE.VALUATIONAREA == T001K.BWKEY