FAC_DART_Z3_MATLINVTRY_LINEITM

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
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
Column Name Description Domain name
GLAccountLongName G/L Account Long Text TEXT50
MaterialName Material Description TEXT40
MaterialGroup Product Group MATKL
MaterialGroupName Product Group Description TEXT20
PlantName Plant Name TEXT30
FiscalPeriod Fiscal Period POPER
AccountingDocumentTypeName Document Type Name TEXT20
OriginalReferenceDocument Object key AWKEY
ReferenceDocumentTypeName Name of Object Type TEXT20
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
InventoryTransactionType Transaction/Event Type VGART
AccountingDocumentHeaderText Document Header Text TEXT25
AccountingDocCreatedByUser User that created the journal entry
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == T003.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.BASEUNIT == T006.MSEHI
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == T006.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == T004.MANDT
  • FAC_DART_Z3_MATLINVTRY_LINEITM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == T001.MANDT
  • FAC_DART_Z3_MATLINVTRY_LINEITM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == TCURC.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.FISCALYEARVARIANT == T009.PERIV
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == T009.MANDT
G/L Account
  • Client
  • G/L Account
  • Company Code
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == SKB1.MANDT
  • FAC_DART_Z3_MATLINVTRY_LINEITM.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_MATLINVTRY_LINEITM.COMPANYCODE == SKB1.BUKRS
Ledger
  • Source Ledger
  • Ledger
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • FAC_DART_Z3_MATLINVTRY_LINEITM.LEDGER == FINSC_LEDGER.RLDNR
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == FINSC_LEDGER.MANDT
Material Number
  • Material Number
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MATERIAL == MARA.MATNR
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.PLANT == T001W.WERKS
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == T001W.MANDT
Reference Document Type FAC_DART_Z3_MATLINVTRY_LINEITM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Source Ledger
  • Source Ledger
  • Ledger
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • FAC_DART_Z3_MATLINVTRY_LINEITM.LEDGER == FINSC_LEDGER.RLDNR
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == FINSC_LEDGER.MANDT
Valuation area
  • Valuation area
  • Client
  • FAC_DART_Z3_MATLINVTRY_LINEITM.VALUATIONAREA == T001K.BWKEY
  • FAC_DART_Z3_MATLINVTRY_LINEITM.MANDT == T001K.MANDT