I_OperationalAcctgDocCube

Operational Journal Entry Item - Cube | view: IFIOPACCTGDOCCUB | TRAN | Extraction: Not supported | Component: Information System
Tables used: BKPF, BSEG, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSKS, CSKT, KNA1, TFKB, TFKBT, SKA1, CEPC, CEPC, CEPCT, PROJ, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, PRPS, T001, T014, SKAT, T004
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
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
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
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
ClearingDate Clearing Date
ClearingCreationDate Clearing Creation 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
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
CashDiscount2DueDate Cash Discount 2 Due Date
AccountingDocumentCreationDate Accounting Document Entry Date
CreationTime Creation Time
LastChangeDate Last Change Date
ExchangeRateDate Exchange Rate Date
PlannedReversalDate Planned Date for the Reversal Posting
InvoiceReceiptDate Invoice Receipt Date
TaxReportingDate Tax Reporting Date
Column Name Description
IsCleared Clearing Status: Is Cleared Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code 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
IsNegativePosting Is Negative Posting Show values
HasPaymentOrder Indicator: Payment Order Exists for this Item Show values
CustomerIsInExecution Customer Is In Execution Show values
AccountingDocumentCategory Journal Entry Category Show values
OffsettingAccountType Offsetting Account Type Show values
ReversalIsPlanned Indicator: Reversal Is Planned for Document Show values
TaxIsCalculatedAutomatically Tax Is Automatically Calculated Show values
TaxBaseAmountIsNetAmount Tax Base Amount is Net Amount Show values
AccountingDocumentClass Accounting Document Class Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
Column Name Description Domain name
CompanyCodeName Company Code Name TEXT25
AccountingDocumentItemType Identification of the Line Item CHAR1
ClearingAccountingDocument Clearing Journal Entry BELNR
SpecialGLTransactionType Special G/L Transaction Type UMSKS
BusinessAreaName Business Area Name CHAR30
TransactionTypeDetermination Transaction Key CHAR3
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
CorporateGroupAccount Corporate Group Account SAKNR
ControllingAreaName Controlling Area Name TEXT25
CostCenter Cost Center KOSTL
CostCenterName Cost Center Name TEXT20
Project Project FIS_PROJECT
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
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
PersonnelNumber Personnel Number PERNR
GLAccountName G/L Account Name CHAR30
GLAccountLongName G/L Account Long Name CHAR50
CustomerName Name of Customer TEXT80
SupplierName Name of Supplier TEXT80
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
ProfitCenterName Description of Profit Center TEXT20
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
RealEstateObject Internal Key for Real Estate Object IMKEY
CommitmentItem Commitment Item FIPOS
CommitmentItemShortID Commitment Item ShortID FIS_FIPOS_SHORTID
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
WBSElement WBS Element FIS_WBS
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
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
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Card Payment Settlement CCBTC
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
FunctionalAreaName Functional Area Name CHAR30
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
SegmentName Segment Name TEXT50
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
OriginalReferenceDocument Original Reference Document AWKEY
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
AccountingDocumentItemRef Journal Entry Line Item Reference POSNR_ACC
FiscalPeriod Fiscal Period POPER
AccountingDocumentCategoryName Journal Entry Category Name DDTEXT
AccountingDocumentTypeName Document Type Name TEXT20
OffsettingAccount Offsetting Account GKONT
OffsettingAccountName Name of Offsetting Account TEXT80
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
CashLedgerCompanyCode Cash Origin Company Code BUKRS
CashLedgerAccount Cash Origin Account SAKNR
PubSecBudgetAccountCoCode Budget Account Company Code BUKRS
PubSecBudgetAccount Budget Account SAKNR
MaterialPriceUnitQty Price unit PACK3
NumberOfItems Number of Items DEC12
AccountingDocCreatedByUser User that created the journal entry
TransactionCode Transaction Code TCODE
IntercompanyTransaction Intercompany Transaction Number BVORG
DocumentReferenceID Document Reference ID XBLNR1
RecurringAccountingDocument Recurring Journal Entry BELNR
ReverseDocument Reverse Document BELNR
ReverseDocumentFiscalYear Reverse Document Fiscal Year GJAHR
AccountingDocumentHeaderText Document Header Text TEXT25
ExchangeRate Exchange Rate UKURS
BusinessTransactionType Business Transaction Category FINS_BTTYPE
BatchInputSession Batch Input Session CHAR12
FinancialManagementArea Financial Management Area FIKRS
LogicalSystem Logical System LOGSYS
TaxExchangeRate Tax Exchange Rate KURSF
Reference1InDocumentHeader Internal ID of Reference Key 1 in Document Header CHAR20
Reference2InDocumentHeader Internal ID of Reference Key 2 in Document Header CHAR20
AlternativeReferenceDocument Alternative Reference Document XBLNR_ALT
LatePaymentReason Late Payment Reason CHAR2
SalesDocumentCondition Sales Document Condition KNUMV
GLAccountAuthorizationGroup Authorization Group BRGRU
SupplierBasicAuthorizationGrp Authorization Group BRGRU
CustomerBasicAuthorizationGrp Authorization Group BRGRU
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
OrderType Order Type AUFART
SalesOrderType Sales Document Type AUART
AssetClass Asset Class ANLKL
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T003.MANDT
  • I_OPERATIONALACCTGDOCCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Accounts Receivable Is Pledged
  • Client
  • Company Code
  • Accounts Receivable Pledging Code
  • Accounts Receivable Is Pledged
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TCESSION.CLIENT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == TCESSION.COMPANY
  • I_OPERATIONALACCTGDOCCUBE.ACCTSRECEIVABLEPLEDGINGCODE == TCESSION.CESSION_KZ
  • I_OPERATIONALACCTGDOCCUBE.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
Accounts Receivable Pledging Code
  • Client
  • Company Code
  • Accounts Receivable Pledging Code
  • Accounts Receivable Is Pledged
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TCESSION.CLIENT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == TCESSION.COMPANY
  • I_OPERATIONALACCTGDOCCUBE.ACCTSRECEIVABLEPLEDGINGCODE == TCESSION.CESSION_KZ
  • I_OPERATIONALACCTGDOCCUBE.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • I_OPERATIONALACCTGDOCCUBE.ASSETTRANSACTIONTYPE == TABW.BWASL
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TABW.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • I_OPERATIONALACCTGDOCCUBE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TCURC.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T006.MANDT
  • I_OPERATIONALACCTGDOCCUBE.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TGSB.MANDT
  • I_OPERATIONALACCTGDOCCUBE.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_OPERATIONALACCTGDOCCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T001.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TKA01.MANDT
  • I_OPERATIONALACCTGDOCCUBE.CONTROLLINGAREA == TKA01.KOKRS
Credit Control Area
  • Credit Control Area
  • Client
  • I_OPERATIONALACCTGDOCCUBE.CREDITCONTROLAREA == T014.KKBER
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T014.MANDT
Credit Control Area Currency
  • Client
  • Credit Control Area Currency
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TCURC.MANDT
  • I_OPERATIONALACCTGDOCCUBE.CREDITCONTROLAREACURRENCY == TCURC.WAERS
Customer Number
  • Customer Number
  • Client
  • I_OPERATIONALACCTGDOCCUBE.CUSTOMER == KNA1.KUNNR
  • I_OPERATIONALACCTGDOCCUBE.MANDT == KNA1.MANDT
Country/Region of Destination for Delivery of Goods
  • Country/Region of Destination for Delivery of Goods
  • Client
  • I_OPERATIONALACCTGDOCCUBE.DELIVOFGOODSDESTCOUNTRY == T005.LAND1
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T005.MANDT
Dunning Area
  • Dunning Area
  • Client
  • Company Code
  • I_OPERATIONALACCTGDOCCUBE.DUNNINGAREA == T047M.MABER
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T047M.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == T047M.BUKRS
Dunning Blocking Reason
  • Client
  • Dunning Blocking Reason
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T040S.MANDT
  • I_OPERATIONALACCTGDOCCUBE.DUNNINGBLOCKINGREASON == T040S.MANSP
Dunning Key
  • Client
  • Dunning Key
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T040.MANDT
  • I_OPERATIONALACCTGDOCCUBE.DUNNINGKEY == T040.MSCHL
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_OPERATIONALACCTGDOCCUBE.EXCHANGERATETYPE == TCURV.KURST
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TCURV.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_OPERATIONALACCTGDOCCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T856.MANDT
G/L Account
  • Client
  • Company Code
  • G/L Account
  • I_OPERATIONALACCTGDOCCUBE.MANDT == SKB1.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == SKB1.BUKRS
  • I_OPERATIONALACCTGDOCCUBE.GLACCOUNT == SKB1.SAKNR
Unit of entry
  • Unit of entry
  • Client
  • I_OPERATIONALACCTGDOCCUBE.GOODSMOVEMENTENTRYUNIT == T006.MSEHI
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T006.MANDT
House Bank Key
  • House Bank Key
  • Client
  • ?
  • I_OPERATIONALACCTGDOCCUBE.HOUSEBANK == T012.HBKID
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T012.MANDT
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "BUKRS"] == T012.BUKRS
House Bank Account
  • House Bank Key
  • Client
  • House Bank Account
  • ?
  • I_OPERATIONALACCTGDOCCUBE.HOUSEBANK == T012K.HBKID
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T012K.MANDT
  • I_OPERATIONALACCTGDOCCUBE.HOUSEBANKACCOUNT == T012K.HKTID
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "BUKRS"] == T012K.BUKRS
Valuation Type
  • Valuation Type
  • Client
  • I_OPERATIONALACCTGDOCCUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T149D.MANDT
Joint venture
  • Client
  • Joint venture
  • Company Code
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T8JV.MANDT
  • I_OPERATIONALACCTGDOCCUBE.JOINTVENTURE == T8JV.VNAME
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == T8JV.BUKRS
Recovery Indicator
  • Client
  • Company Code
  • Recovery Indicator
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T8JJ.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == T8JJ.BUKRS
  • I_OPERATIONALACCTGDOCCUBE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
Equity group
  • Client
  • Joint venture
  • Equity group
  • Company Code
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T8JF.MANDT
  • I_OPERATIONALACCTGDOCCUBE.JOINTVENTURE == T8JF.VNAME
  • I_OPERATIONALACCTGDOCCUBE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == T8JF.BUKRS
Equity type
  • Client
  • Company Code
  • Equity type
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T8JE.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == T8JE.BUKRS
  • I_OPERATIONALACCTGDOCCUBE.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Ledger Group
  • Client
  • Ledger Group
  • I_OPERATIONALACCTGDOCCUBE.MANDT == FAGL_TLDGRP.MANDT
  • I_OPERATIONALACCTGDOCCUBE.LEDGERGROUP == FAGL_TLDGRP.LDGRP
Material Number
  • Material Number
  • Product Number
  • Client
  • I_OPERATIONALACCTGDOCCUBE.MATERIAL == MARA.MATNR
  • I_OPERATIONALACCTGDOCCUBE.PRODUCT == MARA.MATNR
  • I_OPERATIONALACCTGDOCCUBE.MANDT == MARA.MANDT
Operational General Ledger Account
  • Operational General Ledger Account
  • Client
  • Company Code
  • I_OPERATIONALACCTGDOCCUBE.OPERATIONALGLACCOUNT == SKB1.SAKNR
  • I_OPERATIONALACCTGDOCCUBE.MANDT == SKB1.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == SKB1.BUKRS
Order ID
  • Order ID
  • Client
  • I_OPERATIONALACCTGDOCCUBE.ORDERID == AUFK.AUFNR
  • I_OPERATIONALACCTGDOCCUBE.MANDT == AUFK.MANDT
Partner Business Area
  • Client
  • Partner Business Area
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TGSB.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T880.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PARTNERCOMPANY == T880.RCOMP
Partner Profit Center
  • Client
  • Partner Profit Center
  • ?
  • ?
  • I_OPERATIONALACCTGDOCCUBE.MANDT == CEPC.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "KOKRS"] == CEPC.KOKRS
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "DATBI"] == CEPC.DATBI
Payment Blocking Reason
  • Client
  • Payment Blocking Reason
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T008.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TCURC.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PAYMENTCURRENCY == TCURC.WAERS
Payment Difference Reason
  • Client
  • Company Code
  • Payment Difference Reason
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T053R.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == T053R.BUKRS
  • I_OPERATIONALACCTGDOCCUBE.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Payment Method
  • Client
  • Payment Method
  • ?
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T042Z.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PAYMENTMETHOD == T042Z.ZLSCH
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "LAND1"] == T042Z.LAND1
Payment Method Supplement
  • Client
  • Payment Method Supplement
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T042F.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Planning Level
  • Planning Level
  • Client
  • I_OPERATIONALACCTGDOCCUBE.PLANNINGLEVEL == T036.EBENE
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T036.MANDT
Plant
  • Client
  • Plant
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T001W.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PLANT == T001W.WERKS
Posting Key
  • Posting Key
  • Client
  • I_OPERATIONALACCTGDOCCUBE.POSTINGKEY == TBSL.BSCHL
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TBSL.MANDT
Product Number
  • Material Number
  • Product Number
  • Client
  • I_OPERATIONALACCTGDOCCUBE.MATERIAL == MARA.MATNR
  • I_OPERATIONALACCTGDOCCUBE.PRODUCT == MARA.MATNR
  • I_OPERATIONALACCTGDOCCUBE.MANDT == MARA.MANDT
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T006.MANDT
  • I_OPERATIONALACCTGDOCCUBE.PURCHASINGDOCUMENTPRICEUNIT == T006.MSEHI
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • ?
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T005S.MANDT
  • I_OPERATIONALACCTGDOCCUBE.REGION == T005S.BLAND
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "LAND1"] == T005S.LAND1
Reason for Reversal or Inverse Posting
  • Client
  • Reason for Reversal or Inverse Posting
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T041C.MANDT
  • I_OPERATIONALACCTGDOCCUBE.REVERSALREASON == T041C.STGRD
Source Company Code
  • Source Company Code
  • Client
  • I_OPERATIONALACCTGDOCCUBE.SOURCECOMPANYCODE == T001.BUKRS
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T001.MANDT
Special G/L Indicator
  • Client
  • ?
  • Special G/L Indicator
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T074U.MANDT
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "KOART"] == T074U.KOART
  • I_OPERATIONALACCTGDOCCUBE.SPECIALGLCODE == T074U.UMSKZ
State Central Bank Indicator
  • Client
  • State Central Bank Indicator
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T015L.MANDT
  • I_OPERATIONALACCTGDOCCUBE.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
Supplier
  • Supplier
  • Client
  • I_OPERATIONALACCTGDOCCUBE.SUPPLIER == LFA1.LIFNR
  • I_OPERATIONALACCTGDOCCUBE.MANDT == LFA1.MANDT
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • I_OPERATIONALACCTGDOCCUBE.SUPPLYINGCOUNTRY == T005.LAND1
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T005.MANDT
Tax on Sales/Purchases Code
  • Client
  • Tax on Sales/Purchases Code
  • ?
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T007A.MANDT
  • I_OPERATIONALACCTGDOCCUBE.TAXCODE == T007A.MWSKZ
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "KALSM_D"] == T007A.KALSM
Tax Code 1 for Distribution
  • Tax Code 1 for Distribution
  • Client
  • ?
  • I_OPERATIONALACCTGDOCCUBE.TAXDISTRIBUTIONCODE1 == T007A.MWSKZ
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T007A.MANDT
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "KALSM_D"] == T007A.KALSM
Tax Code 2 for Distribution
  • Client
  • ?
  • Tax Code 2 for Distribution
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T007A.MANDT
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • I_OPERATIONALACCTGDOCCUBE.TAXDISTRIBUTIONCODE2 == T007A.MWSKZ
Tax Code 3 for Distribution
  • Client
  • ?
  • Tax Code 3 for Distribution
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T007A.MANDT
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • I_OPERATIONALACCTGDOCCUBE.TAXDISTRIBUTIONCODE3 == T007A.MWSKZ
Tax Jurisdiction
  • Client
  • ?
  • Tax Jurisdiction
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TTXJ.MANDT
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • I_OPERATIONALACCTGDOCCUBE.TAXJURISDICTION == TTXJ.TXJCD
Tax Section
  • Client
  • Company Code
  • Tax Section
  • I_OPERATIONALACCTGDOCCUBE.MANDT == SECCODE.MANDT
  • I_OPERATIONALACCTGDOCCUBE.COMPANYCODE == SECCODE.BUKRS
  • I_OPERATIONALACCTGDOCCUBE.TAXSECTION == SECCODE.SECCODE
Transaction Currency
  • Client
  • Transaction Currency
  • I_OPERATIONALACCTGDOCCUBE.MANDT == TCURC.MANDT
  • I_OPERATIONALACCTGDOCCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
Valuation area
  • Client
  • Valuation area
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T001K.MANDT
  • I_OPERATIONALACCTGDOCCUBE.VALUATIONAREA == T001K.BWKEY
Withholding Tax Code
  • Client
  • Withholding Tax Code
  • ?
  • I_OPERATIONALACCTGDOCCUBE.MANDT == T059Q.MANDT
  • I_OPERATIONALACCTGDOCCUBE.WITHHOLDINGTAXCODE == T059Q.QSSKZ
  • I_OPERATIONALACCTGDOCCUBE.[column in domain "LAND1"] == T059Q.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Ledger
  • Client
  • Ledger
  • Company Code