FAC_DART_Z3_AP_LINEITEM_BASE

Account Payables/Recievables - Line Items Base view | view: FAC_DZAPLNITMB | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: BKPFBSEGT001TKA02LFA1LFB1T001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
TaxBrkdwnAmount2InCoCodeCrcy Tax Breakdown Amount in Company Code Currency (2)
TaxBrkdwnAmount1InCoCodeCrcy Tax Breakdown Amount in Company Code Currency (1)
TaxBrkdwnAmount3InCoCodeCrcy Tax Breakdown Amount in Company Code Currency (3)
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
InvoiceAmtInCoCodeCrcy Invoice Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxBrkdwnAmount3InTransCrcy Tax Breakdown Amount in Transaction Currency (3)
TaxBrkdwnAmount1InTransCrcy Tax Breakdown Amount in Transaction Currency (1)
TaxBrkdwnAmount2InTransCrcy Tax Breakdown Amount in Transaction Currency (2)
OriginalTaxBaseAmount Original Tax Base Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
WithholdingTaxBaseAmount Withholding Tax Base Amount
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
CashDiscountBaseAmount Cash Discount Base Amount
CashDiscountAmount Cash Discount Amount
NetPaymentAmount Net Payment Amount
WithholdingTaxAmount Withholding Tax Amount
WithholdingTaxExemptionAmt Withholding Tax-Exemption Amount
InvoiceAmountInFrgnCurrency Invoice Amount in Foreign Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Additional Currency 1 (AdditionalCurrency1):
ValuationDiffAmtInAddlCrcy1 Valuation Difference Amount in Additional Currency 1
AmountInAdditionalCurrency1 Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuationDiffAmtInAddlCrcy2 Valuation Difference Amount in Additional Currency 2
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment Currency
💲 Credit Control Area Currency (CreditControlAreaCurrency):
HedgedAmount Credit Management: Hedged Amount
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
📏 Unit of entry (GoodsMovementEntryUnit):
QuantityInEntryUnit Quantity in Entry Unit
📏 Order Price Unit (Purchasing) (PurchasingDocumentPriceUnit):
PurchaseOrderQty Purchase Order Quantity
Column Name Description
PostingDate Posting Date
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation Date
AccountingDocumentCreationDate Accounting Document Entry Date
ValueDate Value date
AssetValueDate Asset Value Date
DueCalculationBaseDate Due Calculation Base Date
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference Date for Settlement
TaxDeterminationDate Date for Determination of Tax Rates
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
NetAmountIsPosted Net Amount Is Posted Show values
FinancialAccountType Account Type Show values
TaxType Tax Type Show values
IsSalesRelated Is Sales Related Show values
LineItemDisplayIsEnabled Indicator: Can Line Items Be Displayed by Account? Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
IsNotCashDiscountLiable Is Not Cash Discount Liable Show values
IsAutomaticallyCreated Is Automatically Created Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
IsBalanceSheetAccount Is Balance Sheet Account Show values
FixedCashDiscount Fixed Cash Discount Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
IsCompletelyDelivered Is completely delivered Show values
MaterialPriceControl Price control indicator Show values
TreasuryContractType Treasury Contract Type Show values
IsEUTriangularDeal Is EU Triangular Deal Show values
CompanyCodeCurrencyDetnMethod Company Code Currency Determination Method Show values
ClearingIsReversed Clearing Is Reversed Show values
DownPaymentIsNetProcedure Indicator: Down Payment in Net Procedure? Show values
AddressAndBankIsSetManually Address and Bank Data is Set Manually Show values
IsNegativePosting Is Negative Posting Show values
HasPaymentOrder Indicator: Payment Order Exists for this Item Show values
CustomerIsInExecution Customer Is In Execution Show values
OffsettingAccountType Offsetting Account Type Show values
Column Name Description Domain name
SystemClient Client
SupplierName Name of Supplier TEXT80
FiscalPeriod Fiscal Period POPER
ClearingAccountingDocument Clearing Journal Entry BELNR
OriginalReferenceDocument Original Reference Document AWKEY
DocumentItemText Item Text TEXT50
AccountingDocumentItemType Identification of the Line Item CHAR1
DocumentReferenceID Document Reference ID XBLNR1
SpecialGLTransactionType Special G/L Transaction Type UMSKS
TaxCountry Tax Reporting Country/Region LAND1
TaxItemGroup Group Indicator for Tax Line Items NUM03
TransactionTypeDetermination Transaction Key CHAR3
AssignmentReference Assignment Reference ZUONR
CorporateGroupAccount Corporate Group Account SAKNR
CostCenter Cost Center KOSTL
Project Project definition PS_PSPID
BillingDocument Billing Document VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ServiceDocumentType Service Document Type CRM_PROCESS_TYPE
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
AssetClass Asset Class ANLKL
PersonnelNumber Personnel Number PERNR
BranchAccount Branch Account MAXKK
ProfitLossAccountType Profit Loss Account Type CHAR2
SpecialGLAccountAssignment Assignment Number for Special G/L Accounts ZUONR
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceList Invoice List SAMNR
DunningLevel Dunning Level MAHNS
WithholdingTaxCertificate Withholding Tax Certificate CHAR10
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
VATRegistration VAT Registration STCEG
ProfitCenter Profit Center PRCTR
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
RealEstateObject Internal Key for Real Estate Object IMKEY
CommitmentItem Commitment Item FIPOS
CostObject Cost Object KSTRG
ProjectNetwork Network Number for Account Assignment AUFNR
OrderInternalBillOfOperations Order Internal Bill of Operations ID AUFPL
OrderIntBillOfOperationsItem Order Internal Bill of Operations Item CO_APLZL
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
CostOriginGroup Origin Group as Subdivision of Cost Element HRKFT
PaytSlipWthRefSubscriber ISR Subscriber Number ESRNR
PaytSlipWthRefReference ISR Reference Number ESRRE
PaytSlipWthRefCheckDigit ISR Check Digit CHAR2
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
FundsCenter Funds Management Center FISTL
Fund Fund BP_GEBER
Reference1IDByBusinessPartner ID of Reference 1 by Business Partner CHAR12
Reference2IDByBusinessPartner ID of Reference 2 by Business Partner CHAR12
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Card Payment Settlement CCBTC
AlternativePayeePayer Alternative Payee/Payer MAXKK
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
DataExchangeInstruction1 Data Exchange Instruction 1 DTWSX
DataExchangeInstruction2 Data Exchange Instruction 2 DTWSX
DataExchangeInstruction3 Data Exchange Instruction 3 DTWSX
DataExchangeInstruction4 Data Exchange Instruction 4 DTWSX
PaymentReference Payment Reference CHAR30
ClearingItem Clearing Item AGZEI
CostCtrActivityType Activity Type LSTAR
BusinessProcess Business Process CO_PRZNR
GrantID Grant GM_GRANT_NBR
FunctionalArea Functional Area FKBER
FundedProgram Funded Program FM_MEASURE
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
Segment Segment for Segmental Reporting FB_SEGMENT
PartnerSegment Partner Segment for Segmental Reporting FB_SEGMENT
PartnerFunctionalArea Partner Functional Area FKBER
CostElement Cost Element KSTAR
PaymentServiceProvider Payment Service Provider COM_WEC_PAYMENT_SRV_PROVIDER
PaymentRefByPaytSrvcProvider Payment Reference by Payment Service Provider COM_WEC_PSP_TRANSACTION_ID
SEPAMandate Unique Reference to Mandate for each Payee ID035
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
AccountingDocumentItemRef Journal Entry Line Item Reference POSNR_ACC
OffsettingAccount Offsetting Account GKONT
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
PartnerFund Partner Fund BP_GEBER
PartnerGrant Partner Grant GM_GRANT_NBR
BudgetPeriod Budget Period FM_BUDGET_PERIOD
PartnerBudgetPeriod FM: Partner Budget Period FM_BUDGET_PERIOD
BranchCode Branch Code BCODE
MaterialPriceUnitQty Price unit PACK3
NumberOfItems Number of Items DEC12
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T003.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Accounts Receivable Is Pledged
  • Client
  • Company Code
  • Accounts Receivable Is Pledged
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TCESSION.CLIENT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == TCESSION.COMPANY
  • FAC_DART_Z3_AP_LINEITEM_BASE.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
Asset Transaction Type
  • Client
  • Asset Transaction Type
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TABW.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.ASSETTRANSACTIONTYPE == TABW.BWASL
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TCURC.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T006.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TGSB.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_AP_LINEITEM_BASE.CHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T001.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TKA01.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.CONTROLLINGAREA == TKA01.KOKRS
Credit Control Area
  • Credit Control Area
  • Client
  • FAC_DART_Z3_AP_LINEITEM_BASE.CREDITCONTROLAREA == T014.KKBER
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T014.MANDT
Credit Control Area Currency
  • Client
  • Credit Control Area Currency
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TCURC.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.CREDITCONTROLAREACURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • FAC_DART_Z3_AP_LINEITEM_BASE.CUSTOMER == KNA1.KUNNR
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == KNA1.MANDT
Country/Region of Destination for Delivery of Goods
  • Client
  • Country/Region of Destination for Delivery of Goods
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T005.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.DELIVOFGOODSDESTCOUNTRY == T005.LAND1
Dunning Area
  • Client
  • Company Code
  • Dunning Area
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T047M.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == T047M.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.DUNNINGAREA == T047M.MABER
Dunning Blocking Reason
  • Client
  • Dunning Blocking Reason
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T040S.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Client
  • Dunning Key
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T040.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.DUNNINGKEY == T040.MSCHL
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • FAC_DART_Z3_AP_LINEITEM_BASE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T856.MANDT
G/L Account
  • Client
  • G/L Account
  • Company Code
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == SKB1.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == SKB1.BUKRS
Unit of entry
  • Client
  • Unit of entry
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T006.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.GOODSMOVEMENTENTRYUNIT == T006.MSEHI
House Bank Key
  • House Bank Key
  • Client
  • ?
  • FAC_DART_Z3_AP_LINEITEM_BASE.HOUSEBANK == T012.HBKID
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T012.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • Client
  • ?
  • House Bank Account
  • FAC_DART_Z3_AP_LINEITEM_BASE.HOUSEBANK == T012K.HBKID
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T012K.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "BUKRS"] == T012K.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.HOUSEBANKACCOUNT == T012K.HKTID
Valuation Type
  • Client
  • Valuation Type
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T149D.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.INVENTORYVALUATIONTYPE == T149D.BWTAR
Joint venture
  • Client
  • Company Code
  • Joint venture
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T8JV.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == T8JV.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.JOINTVENTURE == T8JV.VNAME
Recovery Indicator
  • Client
  • Recovery Indicator
  • Company Code
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T8JJ.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == T8JJ.BUKRS
Equity group
  • Client
  • Company Code
  • Joint venture
  • Equity group
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T8JF.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == T8JF.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.JOINTVENTURE == T8JF.VNAME
  • FAC_DART_Z3_AP_LINEITEM_BASE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
Equity type
  • Client
  • Company Code
  • Equity type
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T8JE.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == T8JE.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Material Number
  • Client
  • Product Number
  • Material Number
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == MARA.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PRODUCT == MARA.MATNR
  • FAC_DART_Z3_AP_LINEITEM_BASE.MATERIAL == MARA.MATNR
Operational General Ledger Account
  • Client
  • Company Code
  • Operational General Ledger Account
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == SKB1.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.OPERATIONALGLACCOUNT == SKB1.SAKNR
Order ID
  • Client
  • Order ID
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == AUFK.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.ORDERID == AUFK.AUFNR
Partner Business Area
  • Client
  • Partner Business Area
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TGSB.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T880.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • Client
  • Partner Profit Center
  • ?
  • ?
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == CEPC.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PARTNERPROFITCENTER == CEPC.PRCTR
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "DATBI"] == CEPC.DATBI
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "KOKRS"] == CEPC.KOKRS
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T008.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TCURC.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PAYMENTCURRENCY == TCURC.WAERS
Payment Difference Reason
  • Client
  • Company Code
  • Payment Difference Reason
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T053R.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == T053R.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Payment Method
  • Client
  • Payment Method
  • ?
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T042Z.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PAYMENTMETHOD == T042Z.ZLSCH
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "LAND1"] == T042Z.LAND1
Payment Method Supplement
  • Client
  • Payment Method Supplement
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T042F.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Planning Level
  • Client
  • Planning Level
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T036.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PLANNINGLEVEL == T036.EBENE
Plant
  • Client
  • Plant
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T001W.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TBSL.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.POSTINGKEY == TBSL.BSCHL
Product Number
  • Client
  • Product Number
  • Material Number
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == MARA.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PRODUCT == MARA.MATNR
  • FAC_DART_Z3_AP_LINEITEM_BASE.MATERIAL == MARA.MATNR
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T006.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.PURCHASINGDOCUMENTPRICEUNIT == T006.MSEHI
Reconciliation Account in General Ledger
  • Client
  • Company Code
  • Reconciliation Account in General Ledger
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == SKB1.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.RECONCILIATIONACCOUNT == SKB1.SAKNR
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • ?
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T005S.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.REGION == T005S.BLAND
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "LAND1"] == T005S.LAND1
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • ?
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T074U.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.SPECIALGLCODE == T074U.UMSKZ
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "KOART"] == T074U.KOART
State Central Bank Indicator
  • Client
  • State Central Bank Indicator
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T015L.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
Supplier
  • Client
  • Supplier
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == LFA1.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.SUPPLIER == LFA1.LIFNR
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T005.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.SUPPLYINGCOUNTRY == T005.LAND1
Tax on Sales/Purchases Code
  • Client
  • ?
  • Tax on Sales/Purchases Code
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T007A.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_AP_LINEITEM_BASE.TAXCODE == T007A.MWSKZ
Tax Code 1 for Distribution
  • Client
  • ?
  • Tax Code 1 for Distribution
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T007A.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_AP_LINEITEM_BASE.TAXDISTRIBUTIONCODE1 == T007A.MWSKZ
Tax Code 2 for Distribution
  • Client
  • Tax Code 2 for Distribution
  • ?
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T007A.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.TAXDISTRIBUTIONCODE2 == T007A.MWSKZ
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "KALSM_D"] == T007A.KALSM
Tax Code 3 for Distribution
  • Client
  • ?
  • Tax Code 3 for Distribution
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T007A.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_AP_LINEITEM_BASE.TAXDISTRIBUTIONCODE3 == T007A.MWSKZ
Tax Jurisdiction
  • Client
  • ?
  • Tax Jurisdiction
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TTXJ.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FAC_DART_Z3_AP_LINEITEM_BASE.TAXJURISDICTION == TTXJ.TXJCD
Tax Section
  • Client
  • Company Code
  • Tax Section
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == SECCODE.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.COMPANYCODE == SECCODE.BUKRS
  • FAC_DART_Z3_AP_LINEITEM_BASE.TAXSECTION == SECCODE.SECCODE
Transaction Currency
  • Transaction Currency
  • Client
  • FAC_DART_Z3_AP_LINEITEM_BASE.TRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • FAC_DART_Z3_AP_LINEITEM_BASE.VALUATIONAREA == T001K.BWKEY
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T001K.MANDT
Withholding Tax Code
  • Client
  • ?
  • Withholding Tax Code
  • FAC_DART_Z3_AP_LINEITEM_BASE.MANDT == T059Q.MANDT
  • FAC_DART_Z3_AP_LINEITEM_BASE.[column in domain "LAND1"] == T059Q.LAND1
  • FAC_DART_Z3_AP_LINEITEM_BASE.WITHHOLDINGTAXCODE == T059Q.QSSKZ