FAC_DART_Z3_AR_OPENITEM

Audit Z3 Account Receivable - Open Items | view: FAC_DZAROPITM | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: BKPF, BSEG, T001, T014, FINSC_LD_CMP, FINSC_PERIOD
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
TaxAmountInCoCodeCrcy Signed Tax Amount in Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
TaxBrkdwnAmount1InCoCodeCrcy Tax Breakdown Amount in Company Code Currency (1)
TaxBrkdwnAmount2InCoCodeCrcy Tax Breakdown Amount in Company Code Currency (2)
TaxBrkdwnAmount3InCoCodeCrcy Tax Breakdown Amount in Company Code Currency (3)
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
BalanceAmountInCoCodeCrcy Amount in Company Code Currency
TaxBaseAmountInCoCodeCrcy Tax Base Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
InvoiceAmtInCoCodeCrcy Invoice Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
TaxAmount Tax Amount in Transaction Currency
CashDiscountAmount Cash Discount Amount
TaxBrkdwnAmount1InTransCrcy Tax Breakdown Amount in Transaction Currency (1)
TaxBrkdwnAmount2InTransCrcy Tax Breakdown Amount in Transaction Currency (2)
TaxBrkdwnAmount3InTransCrcy Tax Breakdown Amount in Transaction Currency (3)
WithholdingTaxBaseAmount Withholding Tax Base Amount
WithholdingTaxAmount Withholding Tax Amount
WithholdingTaxExemptionAmt Withholding Tax-Exemption Amount
DebitAmountInTransCrcy Amount in Transaction Currency
CreditAmountInTransCrcy null
OriginalTaxBaseAmount Original Tax Base Amount in Transaction Currency
TaxBaseAmountInTransCrcy Tax Base Amount in Transaction Currency
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
CashDiscountBaseAmount Cash Discount Base Amount
NetPaymentAmount Net Payment Amount
InvoiceAmountInFrgnCurrency Invoice Amount in Foreign Currency
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment 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
💲 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
ClearingDate Clearing Date
PostingDate Posting Date
DocumentDate Journal Entry Date
AccountingDocumentCreationDate Accounting Document Entry Date
DueCalculationBaseDate Due Calculation Base Date
ValueDate Value date
ClearingCreationDate Clearing Creation Date
AssetValueDate Asset Value Date
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference Date for Settlement
TaxDeterminationDate Date for Determination of Tax Rates
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
FixedCashDiscount Fixed Cash Discount Show values
NetAmountIsPosted Net Amount Is Posted Show values
DownPaymentIsNetProcedure Indicator: Down Payment in Net Procedure? Show values
AddressAndBankIsSetManually Address and Bank Data is Set Manually Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
IsEUTriangularDeal Is EU Triangular Deal Show values
AccountingDocumentCategory Journal Entry Category 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
IsBalanceSheetAccount Is Balance Sheet Account 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
CompanyCodeCurrencyDetnMethod Company Code Currency Determination Method Show values
ClearingIsReversed Clearing Is Reversed 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
ClearingAccountingDocument Clearing Journal Entry BELNR
AssignmentReference Assignment Reference ZUONR
DocumentReferenceID Document Reference ID
FiscalPeriod Fiscal Period POPER
DocumentItemText Item Text TEXT50
BranchAccount Branch Account MAXKK
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
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
PaytSlipWthRefSubscriber ISR Subscriber Number ESRNR
PaytSlipWthRefReference ISR Reference Number ESRRE
PaytSlipWthRefCheckDigit ISR Check Digit CHAR2
FollowOnDocumentType Follow-On Document Type REBZT
VATRegistration VAT Registration STCEG
WithholdingTaxCertificate Withholding Tax Certificate CHAR10
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
CostCenter Cost Center KOSTL
AlternativePayeePayer Alternative Payee/Payer MAXKK
ProfitCenter Profit Center PRCTR
PaymentReference Payment Reference CHAR30
FunctionalArea Functional Area FKBER
BillingDocument Billing Document VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
OriginalReferenceDocument Original Reference Document AWKEY
ReferenceDocumentType Reference Document Type AWTYP
DebitCreditCodeName Debit/Credit Code Name DDTEXT
AccountingDocumentItemType Identification of the Line Item CHAR1
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
CorporateGroupAccount Corporate Group Account SAKNR
Project Project definition PS_PSPID
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
ProfitLossAccountType Profit Loss Account Type CHAR2
SpecialGLAccountAssignment Assignment Number for Special G/L Accounts ZUONR
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
InvoiceList Invoice List SAMNR
DunningLevel Dunning Level MAHNS
AccountAssignmentNumber Sequential Number of Account Assignment NUM02
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
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
CostOriginGroup Origin Group as Subdivision of Cost Element HRKFT
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
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Card Payment Settlement CCBTC
DataExchangeInstruction1 Data Exchange Instruction 1 DTWSX
DataExchangeInstruction2 Data Exchange Instruction 2 DTWSX
DataExchangeInstruction3 Data Exchange Instruction 3 DTWSX
DataExchangeInstruction4 Data Exchange Instruction 4 DTWSX
ClearingItem Clearing Item AGZEI
CostCtrActivityType Activity Type LSTAR
BusinessProcess Business Process CO_PRZNR
GrantID Grant GM_GRANT_NBR
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
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
  • Journal Entry Type
  • Client
  • FAC_DART_Z3_AR_OPENITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T003.MANDT
Accounts Receivable Is Pledged
  • Company Code
  • Accounts Receivable Is Pledged
  • Client
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == TCESSION.COMPANY
  • FAC_DART_Z3_AR_OPENITEM.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TCESSION.CLIENT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • FAC_DART_Z3_AR_OPENITEM.ASSETTRANSACTIONTYPE == TABW.BWASL
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TABW.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TCURC.MANDT
  • FAC_DART_Z3_AR_OPENITEM.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • FAC_DART_Z3_AR_OPENITEM.BASEUNIT == T006.MSEHI
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T006.MANDT
Business Area
  • Client
  • Business Area
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TGSB.MANDT
  • FAC_DART_Z3_AR_OPENITEM.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • FAC_DART_Z3_AR_OPENITEM.CHARTOFACCOUNTS == T004.KTOPL
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == T001.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • FAC_DART_Z3_AR_OPENITEM.CONTROLLINGAREA == TKA01.KOKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TKA01.MANDT
Credit Control Area
  • Client
  • Credit Control Area
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T014.MANDT
  • FAC_DART_Z3_AR_OPENITEM.CREDITCONTROLAREA == T014.KKBER
Credit Control Area Currency
  • Client
  • Credit Control Area Currency
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TCURC.MANDT
  • FAC_DART_Z3_AR_OPENITEM.CREDITCONTROLAREACURRENCY == TCURC.WAERS
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • FAC_DART_Z3_AR_OPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.CREDITTRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.DEBITTRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TCURC.MANDT
Customer Number
  • Customer Number
  • Client
  • FAC_DART_Z3_AR_OPENITEM.CUSTOMER == KNA1.KUNNR
  • FAC_DART_Z3_AR_OPENITEM.MANDT == KNA1.MANDT
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • FAC_DART_Z3_AR_OPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.CREDITTRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.DEBITTRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TCURC.MANDT
Country/Region of Destination for Delivery of Goods
  • Client
  • Country/Region of Destination for Delivery of Goods
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T005.MANDT
  • FAC_DART_Z3_AR_OPENITEM.DELIVOFGOODSDESTCOUNTRY == T005.LAND1
Dunning Area
  • Dunning Area
  • Company Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.DUNNINGAREA == T047M.MABER
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == T047M.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T047M.MANDT
Dunning Blocking Reason
  • Dunning Blocking Reason
  • Client
  • FAC_DART_Z3_AR_OPENITEM.DUNNINGBLOCKINGREASON == T040S.MANSP
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T040S.MANDT
Dunning Key
  • Client
  • Dunning Key
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T040.MANDT
  • FAC_DART_Z3_AR_OPENITEM.DUNNINGKEY == T040.MSCHL
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • FAC_DART_Z3_AR_OPENITEM.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T856.MANDT
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T009.MANDT
  • FAC_DART_Z3_AR_OPENITEM.FISCALYEARVARIANT == T009.PERIV
G/L Account
  • G/L Account
  • Company Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.GLACCOUNT == SKB1.SAKNR
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == SKB1.MANDT
Unit of entry
  • Unit of entry
  • Client
  • FAC_DART_Z3_AR_OPENITEM.GOODSMOVEMENTENTRYUNIT == T006.MSEHI
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T006.MANDT
House Bank Key
  • Client
  • ?
  • House Bank Key
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T012.MANDT
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "BUKRS"] == T012.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.HOUSEBANK == T012.HBKID
House Bank Account
  • Client
  • ?
  • House Bank Key
  • House Bank Account
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T012K.MANDT
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "BUKRS"] == T012K.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.HOUSEBANK == T012K.HBKID
  • FAC_DART_Z3_AR_OPENITEM.HOUSEBANKACCOUNT == T012K.HKTID
Valuation Type
  • Valuation Type
  • Client
  • FAC_DART_Z3_AR_OPENITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T149D.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.JOINTVENTURE == T8JV.VNAME
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == T8JV.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T8JV.MANDT
Recovery Indicator
  • Recovery Indicator
  • Company Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == T8JJ.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T8JJ.MANDT
Equity group
  • Equity group
  • Joint venture
  • Company Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • FAC_DART_Z3_AR_OPENITEM.JOINTVENTURE == T8JF.VNAME
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == T8JF.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T8JF.MANDT
Equity type
  • Company Code
  • Equity type
  • Client
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == T8JE.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T8JE.MANDT
Material Number
  • Client
  • Product Number
  • Material Number
  • FAC_DART_Z3_AR_OPENITEM.MANDT == MARA.MANDT
  • FAC_DART_Z3_AR_OPENITEM.PRODUCT == MARA.MATNR
  • FAC_DART_Z3_AR_OPENITEM.MATERIAL == MARA.MATNR
Operational General Ledger Account
  • Company Code
  • Client
  • Operational General Ledger Account
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == SKB1.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == SKB1.MANDT
  • FAC_DART_Z3_AR_OPENITEM.OPERATIONALGLACCOUNT == SKB1.SAKNR
Order ID
  • Order ID
  • Client
  • FAC_DART_Z3_AR_OPENITEM.ORDERID == AUFK.AUFNR
  • FAC_DART_Z3_AR_OPENITEM.MANDT == AUFK.MANDT
Partner Business Area
  • Partner Business Area
  • Client
  • FAC_DART_Z3_AR_OPENITEM.PARTNERBUSINESSAREA == TGSB.GSBER
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TGSB.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T880.MANDT
  • FAC_DART_Z3_AR_OPENITEM.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • ?
  • Partner Profit Center
  • ?
  • Client
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • FAC_DART_Z3_AR_OPENITEM.PARTNERPROFITCENTER == CEPC.PRCTR
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "DATBI"] == CEPC.DATBI
  • FAC_DART_Z3_AR_OPENITEM.MANDT == CEPC.MANDT
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T008.MANDT
  • FAC_DART_Z3_AR_OPENITEM.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Currency for Automatic Payment
  • Client
  • FAC_DART_Z3_AR_OPENITEM.PAYMENTCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TCURC.MANDT
Payment Difference Reason
  • Payment Difference Reason
  • Company Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.PAYMENTDIFFERENCEREASON == T053R.RSTGR
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == T053R.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T053R.MANDT
Payment Method
  • ?
  • Payment Method
  • Client
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "LAND1"] == T042Z.LAND1
  • FAC_DART_Z3_AR_OPENITEM.PAYMENTMETHOD == T042Z.ZLSCH
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T042Z.MANDT
Payment Method Supplement
  • Payment Method Supplement
  • Client
  • FAC_DART_Z3_AR_OPENITEM.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T042F.MANDT
Planning Level
  • Client
  • Planning Level
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T036.MANDT
  • FAC_DART_Z3_AR_OPENITEM.PLANNINGLEVEL == T036.EBENE
Plant
  • Client
  • Plant
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T001W.MANDT
  • FAC_DART_Z3_AR_OPENITEM.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • FAC_DART_Z3_AR_OPENITEM.POSTINGKEY == TBSL.BSCHL
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TBSL.MANDT
Product Number
  • Client
  • Product Number
  • Material Number
  • FAC_DART_Z3_AR_OPENITEM.MANDT == MARA.MANDT
  • FAC_DART_Z3_AR_OPENITEM.PRODUCT == MARA.MATNR
  • FAC_DART_Z3_AR_OPENITEM.MATERIAL == MARA.MATNR
Order Price Unit (Purchasing)
  • Order Price Unit (Purchasing)
  • Client
  • FAC_DART_Z3_AR_OPENITEM.PURCHASINGDOCUMENTPRICEUNIT == T006.MSEHI
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T006.MANDT
Region (State, Province, County)
  • ?
  • Client
  • Region (State, Province, County)
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "LAND1"] == T005S.LAND1
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T005S.MANDT
  • FAC_DART_Z3_AR_OPENITEM.REGION == T005S.BLAND
Special G/L Indicator
  • ?
  • Special G/L Indicator
  • Client
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "KOART"] == T074U.KOART
  • FAC_DART_Z3_AR_OPENITEM.SPECIALGLCODE == T074U.UMSKZ
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T074U.MANDT
State Central Bank Indicator
  • State Central Bank Indicator
  • Client
  • FAC_DART_Z3_AR_OPENITEM.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T015L.MANDT
Supplier
  • Supplier
  • Client
  • FAC_DART_Z3_AR_OPENITEM.SUPPLIER == LFA1.LIFNR
  • FAC_DART_Z3_AR_OPENITEM.MANDT == LFA1.MANDT
Supplying Country/Region
  • Client
  • Supplying Country/Region
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T005.MANDT
  • FAC_DART_Z3_AR_OPENITEM.SUPPLYINGCOUNTRY == T005.LAND1
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • FAC_DART_Z3_AR_OPENITEM.TAXCODE == T007A.MWSKZ
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T007A.MANDT
Tax Code 1 for Distribution
  • ?
  • Tax Code 1 for Distribution
  • Client
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_AR_OPENITEM.TAXDISTRIBUTIONCODE1 == T007A.MWSKZ
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T007A.MANDT
Tax Code 2 for Distribution
  • ?
  • Client
  • Tax Code 2 for Distribution
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T007A.MANDT
  • FAC_DART_Z3_AR_OPENITEM.TAXDISTRIBUTIONCODE2 == T007A.MWSKZ
Tax Code 3 for Distribution
  • ?
  • Client
  • Tax Code 3 for Distribution
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "KALSM_D"] == T007A.KALSM
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T007A.MANDT
  • FAC_DART_Z3_AR_OPENITEM.TAXDISTRIBUTIONCODE3 == T007A.MWSKZ
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • FAC_DART_Z3_AR_OPENITEM.TAXJURISDICTION == TTXJ.TXJCD
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TTXJ.MANDT
Tax Section
  • Company Code
  • Client
  • Tax Section
  • FAC_DART_Z3_AR_OPENITEM.COMPANYCODE == SECCODE.BUKRS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == SECCODE.MANDT
  • FAC_DART_Z3_AR_OPENITEM.TAXSECTION == SECCODE.SECCODE
Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Transaction Currency
  • Client
  • FAC_DART_Z3_AR_OPENITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.CREDITTRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.DEBITTRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_DART_Z3_AR_OPENITEM.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • FAC_DART_Z3_AR_OPENITEM.VALUATIONAREA == T001K.BWKEY
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T001K.MANDT
Withholding Tax Code
  • ?
  • Withholding Tax Code
  • Client
  • FAC_DART_Z3_AR_OPENITEM.[column in domain "LAND1"] == T059Q.LAND1
  • FAC_DART_Z3_AR_OPENITEM.WITHHOLDINGTAXCODE == T059Q.QSSKZ
  • FAC_DART_Z3_AR_OPENITEM.MANDT == T059Q.MANDT