FAC_AUDIT_Z3_MATERIAL_ITEM

Material items | view: FAC_AUDMATITM | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: EKKO, MATDOC, CKMLCR, MATDOC, MATDOC, ACDOCA, ACDOCA, ACDOCD, BKPF, FMLT_PRICE, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, T156HT, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, CKMLHD, EBEW, MBEW, OBEW, QBEW, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_LEDGER_REP, FINSC_LEDGER_REP, FINSC_LD_CMP, FINSC_FISC_DATE, FINSC_PERIOD, FMLC_TOGGLE, FMLT_CURTP_ML
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
💲 Currency Key (waers):
dmbtr Amount in Local Currency
bnbtr Delivery costs in local currency
dmbum Revaluation amount on back-posting to a previous period
salk3 Value of total valuated stock before the posting
Column Name Description
📏 Base Unit of Measure (meins):
menge Quantity
lbkum Total valuated stock before the posting
📏 Unit of entry (erfme):
erfmg Quantity in unit of entry
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
bedat Purchasing Document Date
aedat Creation Date of Purchasing Document
Column Name Description
shkzg Debit/Credit Indicator Show values
kzbew Movement Indicator Show values
shkum Debit/credit indicator in revaluation Show values
weunb Goods Receipt, Non-Valuated Show values
xruej Indicator: post to previous year Show values
xruem Allow Posting to Previous Period (Backposting) Show values
kzzug Receipt Indicator Show values
kzvbr Consumption posting Show values
Column Name Description Domain name
MaterialDocument Number of Material Document BELNR
MaterialDocumentYear Material Document Year GJAHR
InventoryTransactionType Transaction/Event Type VGART
FiscalPeriod Fiscal Period POPER
DocumentTypeofRevaluationDoc Document type of revaluation document BLART
AccountingDocumentHeaderText Document Header Text TEXT25
ReferenceDocument Reference document number AWREF
LogicalSystem Logical System LOGSYS
ObjectKey Object key AWKEY
ForeignTradeNumber Number of foreign trade data in MM and SD documents EXNUM
zeile Item in Material Document MBLPO
bwart Movement type (inventory management) BWART
GoodsMovementTypeName Movement Type Text (Inventory Management) BTEXT
werks Plant
lgort Storage location LGORT
charg Batch Number CHARG
ebeln Purchase order number EBELN
ebelp Item Number of Purchasing Document EBELP
bwtar Valuation Type BWTAR
sakto G/L Account Number SAKNR
lifnr Vendor's account number LIFNR
kunnr Account number of customer KUNNR
gsber Business Area GSBER
anln1 Main Asset Number ANLN1
anln2 Asset Subnumber ANLN2
aufnr Order Number AUFNR
emlif Supplier to be Supplied/Who is to Receive Delivery LIFNR
fkber Functional Area FKBER
grund Reason for Movement MB_GRBEW
kdauf Sales Order Number VBELN
kdein Delivery schedule for sales order NUM04
kdpos Item number in Sales Order NUM06
kokrs Controlling Area CACCD
kostl Cost Center KOSTL
nplnr Network Number for Account Assignment AUFNR
parbu Clearing company code BUKRS
pargb Trading partner's business area GSBER
pprctr Partner Profit Center PRCTR
prctr Profit Center PRCTR
projn Old: Project number : No longer used --> PS_POSNR PROJN
ps_psp_pnr Work Breakdown Structure Element (WBS Element) PS_POSNR
sgtxt Item Text TEXT50
sobkz Special Stock Indicator SOBKZ
ummat Receiving/Issuing Material MATNR
umwrk Plant WERKS
vptnr Partner account number KUNNR
inco2 Incoterms (Part 2) INCO2
logsy Logical System LOGSYS
ernam User of person who created a purchasing document USNAM
vprsv Price control indicator
vprsvText Short Text for Fixed Values
system_client 3-Byte field
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T003.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.BSART == T161.BSART
  • FAC_AUDIT_Z3_MATERIAL_ITEM.[column in domain "BSTYP"] == T161.BSTYP
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T161.MANDT
Company Code
  • Company Code
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.COMPANYCODE == T001.BUKRS
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T001.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.EKGRP == T024.EKGRP
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.EKORG == T024E.EKORG
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T024E.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.FISCALYEARVARIANT == T009.PERIV
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T009.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • FAC_AUDIT_Z3_MATERIAL_ITEM.COMPANYCODE == SKB1.BUKRS
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == SKB1.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM.GLACCOUNT == SKB1.SAKNR
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == TINC.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM.INCO1 == TINC.INCO1
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Client
  • ?
  • FAC_AUDIT_Z3_MATERIAL_ITEM.KALSM == T683.KALSM
  • FAC_AUDIT_Z3_MATERIAL_ITEM.[column in domain "KVEWE"] == T683.KVEWE
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T683.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM.[column in domain "KAPPL"] == T683.KAPPL
Field not used
  • Field not used
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.LBLIF == LFA1.LIFNR
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == LFA1.MANDT
Ledger
  • Ledger
  • Source Ledger
  • Client
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.LIFRE == LFA1.LIFNR
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == MARA.MANDT
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MATERIAL == MARA.MATNR
Reference Document Type FAC_AUDIT_Z3_MATERIAL_ITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.RESWK == T001W.WERKS
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T001W.MANDT
Source Ledger
  • Client
  • Ledger
  • Source Ledger
Valuation area
  • Valuation area
  • Client
  • FAC_AUDIT_Z3_MATERIAL_ITEM.VALUATIONAREA == T001K.BWKEY
  • FAC_AUDIT_Z3_MATERIAL_ITEM.MANDT == T001K.MANDT