FAC_DART_Z3_WIP_LINEITEM

DART Z3 Production Lot Line Item | view: FAC_DZWIPLNITM | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: SCAL_TT_DATE, ACDOCA, BKPF, T003, T003T, T004, KNA1, SKA1, MARA, MAKT, T001W, T023, T023T, TTYP, TTYPT, LFA1, SKAT, T004, FCOC_EBW_ASSG_CC, FCOC_EBW_ASSG_IT, TKKAB, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_PERIOD
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
Column Name Description
PostingDate Posting Date
Column Name Description
OffsettingAccountType Offsetting Account Type Show values
FinancialAccountType Account Type Show values
Column Name Description Domain name
PlantName Plant Name TEXT30
AccountingDocumentTypeName Document Type Name TEXT20
GLAccountLongName G/L Account Long Text TEXT50
OffsettingAccount Offsetting Account GKONT
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
OffsettingAccountName Name of Offsetting Account TEXT80
MaterialName Material Description TEXT40
OriginalReferenceDocument Object key
ReferenceDocument Reference document number AWREF
ReferenceDocumentTypeName Name of Object Type
MaterialGroupName Product Group Description TEXT20
WBSElement WBS Element FIS_WBS
Project Project FIS_PROJECT
FiscalPeriod Fiscal Period POPER
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T003.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Asset Class
  • Client
  • Asset Class
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == ANKA.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.ASSETCLASS == ANKA.ANLKL
Business Area
  • Client
  • Business Area
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == TGSB.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T004.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T001.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == TCURC.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • FAC_DART_Z3_WIP_LINEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • FAC_DART_Z3_WIP_LINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == CSKS.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.COSTCENTER == CSKS.KOSTL
  • FAC_DART_Z3_WIP_LINEITEM.[column in domain "DATBI"] == CSKS.DATBI
Cost Source Unit
  • Client
  • Cost Source Unit
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T006.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Customer Number
  • Client
  • FAC_DART_Z3_WIP_LINEITEM.CUSTOMER == KNA1.KUNNR
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == KNA1.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == TVTW.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T009.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Client
  • Asset Subnumber
  • Fixed Asset
  • ?
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == ANLA.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.FIXEDASSET == ANLA.ANLN2
  • FAC_DART_Z3_WIP_LINEITEM.MASTERFIXEDASSET == ANLA.ANLN1
  • FAC_DART_Z3_WIP_LINEITEM.[column in domain "BUKRS"] == ANLA.BUKRS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == SKB1.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_WIP_LINEITEM.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Material Number
  • Client
  • Material Number
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == MARA.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Product Group
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T023.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.MATERIALGROUP == T023.MATKL
Order ID
  • Order ID
  • Client
  • FAC_DART_Z3_WIP_LINEITEM.ORDERID == AUFK.AUFNR
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == TSPA.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T001W.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.PLANT == T001W.WERKS
Profit Center
  • Controlling Area
  • Client
  • Profit Center
  • ?
  • FAC_DART_Z3_WIP_LINEITEM.CONTROLLINGAREA == CEPC.KOKRS
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == CEPC.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.PROFITCENTER == CEPC.PRCTR
  • FAC_DART_Z3_WIP_LINEITEM.[column in domain "DATBI"] == CEPC.DATBI
Reference Document Type FAC_DART_Z3_WIP_LINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == TVKO.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == FAGL_SEGM.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.SEGMENT == FAGL_SEGM.SEGMENT
Service Document ID
  • Client
  • Service Document ID
  • ?
  • Service Document Type
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == FCO_SRVDOC.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • FAC_DART_Z3_WIP_LINEITEM.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FAC_DART_Z3_WIP_LINEITEM.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Client
  • Supplier
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == LFA1.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.SUPPLIER == LFA1.LIFNR
Valuation area
  • Client
  • Valuation area
  • FAC_DART_Z3_WIP_LINEITEM.MANDT == T001K.MANDT
  • FAC_DART_Z3_WIP_LINEITEM.VALUATIONAREA == T001K.BWKEY