FAC_DART_Z3_WIP_LINEITEM_FP0

DART Z3 Production Lot Line Item | view: FAC_DZWIPLNITMP0 | 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
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
  • Journal Entry Type
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T003.MANDT
Business Area
  • Business Area
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.BUSINESSAREA == TGSB.GSBER
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T004.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T001.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.COMPANYCODECURRENCY == TCURC.WAERS
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == TCURC.MANDT
Controlling Area
  • Client
  • Controlling Area
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == TKA01.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == CSKS.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.COSTCENTER == CSKS.KOSTL
  • FAC_DART_Z3_WIP_LINEITEM_FP0.[column in domain "DATBI"] == CSKS.DATBI
  • FAC_DART_Z3_WIP_LINEITEM_FP0.CONTROLLINGAREA == CSKS.KOKRS
Cost Source Unit
  • Client
  • Cost Source Unit
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T006.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Client
  • Customer Number
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == KNA1.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == TVTW.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.FISCALYEARVARIANT == T009.PERIV
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T009.MANDT
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • Client
  • ?
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MASTERFIXEDASSET == ANLA.ANLN1
  • FAC_DART_Z3_WIP_LINEITEM_FP0.FIXEDASSET == ANLA.ANLN2
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == ANLA.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.[column in domain "BUKRS"] == ANLA.BUKRS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == SKB1.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_WIP_LINEITEM_FP0.COMPANYCODE == SKB1.BUKRS
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Material Number
  • Material Number
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MATERIAL == MARA.MATNR
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T023.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MATERIALGROUP == T023.MATKL
Order ID
  • Order ID
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.ORDERID == AUFK.AUFNR
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == AUFK.MANDT
Division
  • Client
  • Division
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == TSPA.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T001W.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.PLANT == T001W.WERKS
Profit Center
  • Client
  • ?
  • Controlling Area
  • Profit Center
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == CEPC.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.[column in domain "DATBI"] == CEPC.DATBI
  • FAC_DART_Z3_WIP_LINEITEM_FP0.CONTROLLINGAREA == CEPC.KOKRS
  • FAC_DART_Z3_WIP_LINEITEM_FP0.PROFITCENTER == CEPC.PRCTR
Reference Document Type FAC_DART_Z3_WIP_LINEITEM_FP0.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == TVKO.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.SEGMENT == FAGL_SEGM.SEGMENT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == FAGL_SEGM.MANDT
Service Document ID
  • ?
  • Client
  • Service Document ID
  • Service Document Type
  • FAC_DART_Z3_WIP_LINEITEM_FP0.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == FCO_SRVDOC.MANDT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • FAC_DART_Z3_WIP_LINEITEM_FP0.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == CRMC_PROC_TYPE.CLIENT
  • FAC_DART_Z3_WIP_LINEITEM_FP0.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
Source Ledger
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Supplier
  • Supplier
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.SUPPLIER == LFA1.LIFNR
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == LFA1.MANDT
Valuation area
  • Valuation area
  • Client
  • FAC_DART_Z3_WIP_LINEITEM_FP0.VALUATIONAREA == T001K.BWKEY
  • FAC_DART_Z3_WIP_LINEITEM_FP0.MANDT == T001K.MANDT