FAC_AUDIT_Z3_MATERIAL_ITEM_B

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
UnplannedDeliveryCosts Unplanned delivery costs
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
Column Name Description
Column Name Description Domain name
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
MaterialDocumentItem Item in Material Document MBLPO
FiscalPeriod Fiscal Period POPER
AccountingDocumentHeaderText Document Header Text TEXT25
ReferenceDocument Reference document number AWREF
LogicalSystem Logical System LOGSYS
ObjectKey Object key AWKEY
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.MANDT == T003.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.COMPANYCODE == T001.BUKRS
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.MANDT == T001.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.COMPANYCODE == SKB1.BUKRS
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.MANDT == SKB1.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.GLACCOUNT == SKB1.SAKNR
Ledger
  • Source Ledger
  • Ledger
  • Client
Material Number
  • Client
  • Material Number
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.MANDT == MARA.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.MATERIAL == MARA.MATNR
Reference Document Type
  • Reference Document Type
  • Reference Document Type
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.REFERENCEDOCUMENTTYPE2 == TTYP.AWTYP
Reference Document Type
  • Reference Document Type
  • Reference Document Type
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.REFERENCEDOCUMENTTYPE2 == TTYP.AWTYP
Source Ledger
  • Client
  • Source Ledger
  • Ledger
Valuation area
  • Client
  • Valuation area
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.MANDT == T001K.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM_B.VALUATIONAREA == T001K.BWKEY