I_AccountingDocumentJournal

Journal | view: IFIACCDOCJRNL | TRAN | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCA, BKPF, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, T001W, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
Ledger FK Ledger in General Ledger Accounting
FiscalYear Fiscal Year
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
💲 Functional Currency (FunctionalCurrency):
DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
💲 Transaction Currency (TransactionCurrency):
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Balance Transaction Currency (BalanceTransactionCurrency):
CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
Column Name Description
Column Name Description
PostingDate Posting Date
CreationDate Creation Date
AssetValueDate Asset Value Date
ClearingDate Clearing Date
DocumentDate Journal Entry Date
SettlementReferenceDate Settlement Reference Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
ControllingObjectClass Object Class Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
GLAccountType Type of a General Ledger Account Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
IsReversal Indicator: Item is Reversing Another Item Show values
IsReversed Indicator: Item is Reversed Show values
IsSettlement Indicator: Item is Settling or Transferring Another Item Show values
IsSettled Indicator: Line Item is Settled or Transferred Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
OffsettingAccountType Offsetting Account Type Show values
OrderCategory Order category Show values
OriginObjectType Type of Origin Object Show values
PartnerControllingObjectClass Partner object class Show values
PartnerOrderCategory Partner Order Category Show values
QuantityIsIncomplete Indicator: Quantity Is Incomplete Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
GLAccountName G/L Account Short Text TEXT20
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AccountAssignmentNumber Account Assignment Number NUM02
AccountAssignment Account Assignment ACCAS
AssignmentReference Assignment Reference ZUONR
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CostEstimate Cost Estimate CK_KALNR
DocumentItemText Item Text TEXT50
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FollowOnDocumentType Follow-On Document Type REBZT
GrantID Grant GM_GRANT_NBR
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
InvoiceItemReference Invoice Item Reference BUZEI
InventorySpecialStockType Inventory Special Stock Type SOBKZ
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InventorySpclStockWBSElement Inventory Special Stock WBS Element FIS_WBS
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
LedgerFiscalYear Ledger Fiscal Year GJAHR
OffsettingAccount Offsetting Account GKONT
PersonnelNumber Personnel Number PERNR
Project Project FIS_PROJECT
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProject Partner Project FIS_PROJECT
PartnerAccountAssignment Partner Account Assignment ACCAS
PartnerProjectNetworkActivity Partner Project Network Activity VORNR
PredecessorReferenceDocCntxt Predecessor Reference Document Context AWORG
PredecessorReferenceDocument Predecessor Reference Document AWREF
PredecessorReferenceDocItem Predecessor Reference Document Item NUMC6
PartnerGrant Partner Grant GM_GRANT_NBR
RelatedNetworkActivity Network activity VORNR
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
ReferenceDocumentItem Reference Document Item NUMC6
ReferenceDocumentItemGroup Reference Document Item Group NUMC6
ReversalReferenceDocumentCntxt Reversal Reference Document Context AWORG
ReversalReferenceDocument Reversal Reference Document AWREF
SenderGLAccount Sender G/L Account CHAR10
SenderAccountAssignment Sender Account Assignment ACCAS
SalesOrderItem Sales Order Item POSNR
SegmentName Segment Name TEXT50
AccountingDocumentTypeName Document Type Name TEXT20
TransactionTypeDetermination Transaction Key CHAR3
WBSElement WBS Element FIS_WBS
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocumentHeaderText Document Header Text TEXT25
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T003.MANDT
Alternative G/L Account Number In Company Code
  • Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == SKA1.MANDT
Transaction Type Category I_ACCOUNTINGDOCUMENTJOURNAL.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.ASSETTRANSACTIONTYPE == TABW.BWASL
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TABW.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TCURC.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T006.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.BASEUNIT == T006.MSEHI
Billing Type
  • Billing Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TVFK.MANDT
Budget Period
  • Fund
  • Financial Management Area
  • Budget Period
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FUND == FMFUNDBPD.FINCODE
  • I_ACCOUNTINGDOCUMENTJOURNAL.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == FMFUNDBPD.MANDT
Business Area
  • Client
  • Business Area
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TGSB.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.BUSINESSAREA == TGSB.GSBER
Business Process
  • Business Process
  • ?
  • Controlling Area
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.BUSINESSPROCESS == CBPR.PRZNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CBPR.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CBPR.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CBPR.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.CHARTOFACCOUNTS == T004.KTOPL
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T001.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TCURC.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == TKA01.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.COSTCENTER == CSKS.KOSTL
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CSKS.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CSKS.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CSKS.MANDT
Activity Type
  • ?
  • Controlling Area
  • Activity Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CSLA.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CSLA.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CSLA.MANDT
Cost Object
  • ?
  • Client
  • Cost Object
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CKPH.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CKPH.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.COSTOBJECT == CKPH.KSTRG
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T004.MANDT
Customer Number
  • Customer Number
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.CUSTOMER == KNA1.KUNNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.CUSTOMERGROUP == T151.KDGRP
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T151.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TVTW.MANDT
Elimination Profit Center
  • ?
  • Controlling Area
  • Client
  • Elimination Profit Center
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CEPC.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CEPC.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CEPC.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.ELIMINATIONPROFITCENTER == CEPC.PRCTR
Financial Management Area
  • Financial Management Area
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == FM01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FISCALYEARVARIANT == T009.PERIV
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T009.MANDT
Asset Subnumber
  • ?
  • Asset Subnumber
  • Client
  • Fixed Asset
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.FIXEDASSET == ANLA.ANLN2
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == ANLA.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.MASTERFIXEDASSET == ANLA.ANLN1
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TCURC.MANDT
Functional Area
  • Client
  • Functional Area
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TFKB.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Client
  • Functional Currency
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TCURC.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.FUNCTIONALCURRENCY == TCURC.WAERS
Fund
  • Fund
  • Financial Management Area
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FUND == FMFINCODE.FINCODE
  • I_ACCOUNTINGDOCUMENTJOURNAL.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == FMFINCODE.MANDT
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_ACCOUNTINGDOCUMENTJOURNAL.GLACCOUNT == SKB1.SAKNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == SKB1.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.COMPANYCODE == SKB1.BUKRS
Group Asset Subnumber
  • ?
  • Group Asset Subnumber
  • Client
  • Group Asset
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.GROUPFIXEDASSET == ANLA.ANLN2
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == ANLA.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.GROUPMASTERFIXEDASSET == ANLA.ANLN1
House Bank Key
  • ?
  • House Bank Key
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == T012.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.HOUSEBANK == T012.HBKID
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T012.MANDT
House Bank Account
  • ?
  • House Bank Key
  • House Bank Account
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == T012K.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.HOUSEBANK == T012K.HBKID
  • I_ACCOUNTINGDOCUMENTJOURNAL.HOUSEBANKACCOUNT == T012K.HKTID
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T012K.MANDT
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T149D.MANDT
Joint venture
  • ?
  • Client
  • Joint venture
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == T8JV.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T8JV.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.JOINTVENTURE == T8JV.VNAME
Joint Venture Cost Recovery Code
  • ?
  • Joint Venture Cost Recovery Code
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == T8JJ.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T8JJ.MANDT
Joint Venture Equity Group
  • ?
  • Client
  • Joint Venture Equity Group
  • Joint venture
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T8JF.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_ACCOUNTINGDOCUMENTJOURNAL.JOINTVENTURE == T8JF.VNAME
Joint Venture Equity Type
  • ?
  • Joint Venture Equity Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "BUKRS"] == T8JE.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T8JE.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Logical System I_ACCOUNTINGDOCUMENTJOURNAL.LOGICALSYSTEM == TBDLS.LOGSYS
Material Number
  • Material Number
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.MATERIAL == MARA.MATNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.MATERIALGROUP == T023.MATKL
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T023.MANDT
Operating concern
  • Operating concern
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.OPERATINGCONCERN == TKEB.ERKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TKEB.MANDT
Order ID
  • Order ID
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.ORDERID == AUFK.AUFNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.ORGANIZATIONDIVISION == TSPA.SPART
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TSPA.MANDT
Origin Cost Center
  • ?
  • Controlling Area
  • Client
  • Origin Cost Center
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CSKS.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CSKS.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CSKS.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.ORIGINCOSTCENTER == CSKS.KOSTL
Origin Cost Center Activity Type
  • ?
  • Controlling Area
  • Client
  • Origin Cost Center Activity Type
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CSLA.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CSLA.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CSLA.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
FM: Partner Budget Period
  • FM: Partner Budget Period
  • Financial Management Area
  • Client
  • Partner Fund
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_ACCOUNTINGDOCUMENTJOURNAL.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == FMFUNDBPD.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERFUND == FMFUNDBPD.FINCODE
Partner Business Area
  • Partner Business Area
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERBUSINESSAREA == TGSB.GSBER
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TGSB.MANDT
Partner Business Process
  • ?
  • Controlling Area
  • Partner Business Process
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CBPR.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CBPR.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CBPR.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERCOMPANY == T880.RCOMP
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T880.MANDT
Partner Company Code
  • Partner Company Code
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERCOMPANYCODE == T001.BUKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T001.MANDT
Partner Cost Center
  • Partner Cost Center
  • ?
  • Controlling Area
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CSKS.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CSKS.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CSKS.MANDT
Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CSLA.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CSLA.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CSLA.MANDT
Partner Cost Object
  • Partner Cost Object
  • ?
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERCOSTOBJECT == CKPH.KSTRG
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CKPH.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CKPH.MANDT
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TFKB.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Fund
  • Financial Management Area
  • Client
  • Partner Fund
  • I_ACCOUNTINGDOCUMENTJOURNAL.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == FMFINCODE.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERFUND == FMFINCODE.FINCODE
Partner Order
  • Partner Order
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERORDER == AUFK.AUFNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == AUFK.MANDT
Partner Profit Center
  • ?
  • Controlling Area
  • Partner Profit Center
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CEPC.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CEPC.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CEPC.MANDT
Partner Project Network
  • Partner Project Network
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERPROJECTNETWORK == AUFK.AUFNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == AUFK.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == FAGL_SEGM.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Plant
  • Plant
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PLANT == T001W.WERKS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T001W.MANDT
Posting Key
  • Client
  • Posting Key
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TBSL.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.POSTINGKEY == TBSL.BSCHL
Predecessor Reference Document Type I_ACCOUNTINGDOCUMENTJOURNAL.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "DATBI"] == CEPC.DATBI
  • I_ACCOUNTINGDOCUMENTJOURNAL.CONTROLLINGAREA == CEPC.KOKRS
  • I_ACCOUNTINGDOCUMENTJOURNAL.PROFITCENTER == CEPC.PRCTR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == CEPC.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.PROJECTNETWORK == AUFK.AUFNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == AUFK.MANDT
Reference Document Type I_ACCOUNTINGDOCUMENTJOURNAL.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales Organization
  • Client
  • Sales Organization
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TVKO.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == FAGL_SEGM.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.SEGMENT == FAGL_SEGM.SEGMENT
Sold Material
  • Sold Material
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.SOLDMATERIAL == MARA.MATNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == MARA.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Special G/L Indicator
  • Account Type
  • Special G/L Indicator
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.FINANCIALACCOUNTTYPE == T074U.KOART
  • I_ACCOUNTINGDOCUMENTJOURNAL.SPECIALGLCODE == T074U.UMSKZ
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T074U.MANDT
Supplier
  • Supplier
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.SUPPLIER == LFA1.LIFNR
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • Client
  • ?
  • I_ACCOUNTINGDOCUMENTJOURNAL.TAXCODE == T007A.MWSKZ
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T007A.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.[column in domain "KALSM_D"] == T007A.KALSM
Transaction Currency
  • Transaction Currency
  • Client
  • I_ACCOUNTINGDOCUMENTJOURNAL.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == TCURC.MANDT
Valuation area
  • Client
  • Valuation area
  • I_ACCOUNTINGDOCUMENTJOURNAL.MANDT == T001K.MANDT
  • I_ACCOUNTINGDOCUMENTJOURNAL.VALUATIONAREA == T001K.BWKEY