I_JournalEntryItemCube

Journal Entry Item - Cube | view: IFIDOCJRNLCUBE | 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
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Balance Transaction Currency (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
DebitAmountInBalanceTransCrcy Debit Amount in Balance Transaction Currency
CreditAmountInBalanceTransCrcy Credit Amount in Balance Transaction Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
DebitAmountInTransCrcy Debit Amount in Transaction Currency
CreditAmountInTransCrcy Credit Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
FixedAmountInCoCodeCrcy Fixed Amount in Company Currency
DebitAmountInCoCodeCrcy Debit Amount in Company Code Currency
CreditAmountInCoCodeCrcy Credit Amount in Company Code Currency
GLDebitAmountInCoCodeCrcy G/L Account - Debit Amount in Company Code Currency
AssetDebitAmtInCoCodeCrcy Asset - Debit Amount in Company Code Currency
MaterialDebitAmtInCoCodeCrcy Material - Debit Amount in Company Code Currency
DebtorDebitAmtInCoCodeCrcy Customer - Debit Amount in Company Code Currency
CreditorDebitAmtInCoCodeCrcy Supplier - Debit Amount in Company Code Currency
GLCreditAmountInCoCodeCrcy G/L Account - Credit Amount in Company Code Currency
AssetCreditAmtInCoCodeCrcy Asset - Credit Amount in Company Code Currency
MaterialCreditAmtInCoCodeCrcy Material - Credit Amount in Company Code Currency
DebtorCreditAmtInCoCodeCrcy Customer - Credit Amount in Company Code Currency
CreditorCreditAmtInCoCodeCrcy Supplier - Credit Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
GrpValnFixedAmtInGlobCrcy Group Valuation Fixed Amount in Global Currency
PrftCtrValnFxdAmtInGlobCrcy Profit Center Valuation Fixed Amount in Global Currency
TotalPriceVarcInGlobalCrcy Total Price Variance in Global Currency
GrpValnTotPrcVarcInGlobCrcy Group Valuation Total Price Variance in Global Currency
PrftCtrValnTotPrcVarcInGlbCrcy Profit Center Valuation Total Price Variance in Global Cur.
FixedPriceVarcInGlobalCrcy Fixed Price Variance in Global Currency
GrpValnFixedPrcVarcInGlobCrcy Group Valuation Fixed Price Variance in Global Currency
PrftCtrValnFxdPrcVarcInGlbCrcy Profit Center Valuation Fixed Price Variance in Global Cur.
DebitAmountInGlobalCrcy Debit Amount in Global Currency
CreditAmountInGlobalCrcy Credit Amount in Global Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
DebitAmountInFreeDefinedCrcy1 Debit Amount in Free Defined Currency 1
CreditAmountInFreeDefinedCrcy1 Credit Amount in Free Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
DebitAmountInFreeDefinedCrcy2 Debit Amount in Free Defined Currency 2
CreditAmountInFreeDefinedCrcy2 Credit Amount in Free Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
DebitAmountInFreeDefinedCrcy3 Debit Amount in Free Defined Currency 3
CreditAmountInFreeDefinedCrcy3 Credit Amount in Free Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
DebitAmountInFreeDefinedCrcy4 Debit Amount in Free Defined Currency 4
CreditAmountInFreeDefinedCrcy4 Credit Amount in Free Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
DebitAmountInFreeDefinedCrcy5 Debit Amount in Free Defined Currency 5
CreditAmountInFreeDefinedCrcy5 Credit Amount in Free Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
DebitAmountInFreeDefinedCrcy6 Debit Amount in Free Defined Currency 6
CreditAmountInFreeDefinedCrcy6 Credit Amount in Free Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
DebitAmountInFreeDefinedCrcy7 Debit Amount in Free Defined Currency 7
CreditAmountInFreeDefinedCrcy7 Credit Amount in Free Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
DebitAmountInFreeDefinedCrcy8 Debit Amount in Free Defined Currency 8
CreditAmountInFreeDefinedCrcy8 Credit Amount in Free Defined Currency 8
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
FixedQuantity Fixed Quantity
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
ValuationFixedQuantity Valuation Fixed Quantity
📏 Additional Quantity 1 Unit (AdditionalQuantity1Unit):
AdditionalQuantity1 Additional Quantity 1
📏 Additional Quantity 2 Unit (AdditionalQuantity2Unit):
AdditionalQuantity2 Additional Quantity 2
📏 Additional Quantity 3 Unit (AdditionalQuantity3Unit):
AdditionalQuantity3 Additional Quantity 3
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
CreationDate Creation Date
ServicesRenderedDate Date on which services are rendered
ClearingDate Clearing Date
ValueDate Value date
AssetValueDate Asset Value Date
PubSecBudgetCnsmpnDate Budget Consumption Date
JointVentureProductionDate Joint Venture Production Date
JointVentureBillingDate Joint Venture Billing Date
JointVentureOperationalDate Joint Venture Operational Date
SettlementReferenceDate Settlement Reference Date
AccrualValueDate Accrual Value Date
NetDueDate Net Due Date
Column Name Description
GLRecordType Record 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
IsCommitment Indicator: Is Commitment Show values
DebitCreditCode Debit/Credit Code Show values
AccountingDocumentCategory Journal Entry Category Show values
OriginObjectType Type of Origin Object Show values
GLAccountType Type of a General Ledger Account Show values
ReferencePurchaseOrderCategory Category of Reference Purchase Order Show values
FinancialAccountType Account Type Show values
IsOpenItemManaged Managed on an Open Item Basis Show values
IsCleared Indicator: Has the Item Been Cleared? Show values
DepreciationFiscalPeriod Fiscal Period of Depreciation Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
ControllingObjectDebitType Controlling Object Debit Type Show values
QuantityIsIncomplete Indicator: Quantity Is Incomplete Show values
OffsettingAccountType Offsetting Account Type Show values
LineItemIsCompleted Indicator: Line Item is Completed Show values
ControllingObjectClass Object Class Show values
PartnerControllingObjectClass Partner object class Show values
OrderCategory Order category Show values
PartnerOrderCategory Partner Order Category Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
MaintenanceOrderPlanningCode Maintenance order planning indicator Show values
MaintenanceOrderIsPlanned Planned Parts/Work Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
IsStatisticalSalesDocument Sales Document is statistical Show values
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerName Ledger Name TEXT30
CompanyCodeName Company Code Name TEXT25
ControllingAreaName Controlling Area Name TEXT25
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
PredecessorReferenceDocCntxt Predecessor Reference Document Context AWORG
PredecessorReferenceDocument Predecessor Reference Document AWREF
PredecessorReferenceDocItem Predecessor Reference Document Item NUMC6
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
GLAccountName G/L Account Name CHAR30
GLAccountLongName G/L Account Long Name CHAR50
CostCenterName Cost Center Name TEXT20
ProfitCenterName Description of Profit Center TEXT20
FunctionalAreaName Functional Area Name CHAR30
BusinessAreaName Business Area Name CHAR30
SegmentName Segment Name TEXT50
DebitCreditCodeName Debit/Credit Code Name DDTEXT
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
AccountingDocumentTypeName Document Type Name TEXT20
AccountingDocumentItem Journal Entry Posting View Item BUZEI
AssignmentReference Assignment Reference ZUONR
TransactionTypeDetermination Transaction Key CHAR3
LastChangeDateTime Time Stamp of Last Change TZNTSTMPS
CreationDateTime Time Stamp of Creation TZNTSTMPS
InvoiceReference Invoice Reference BELNR
InvoiceReferenceFiscalYear Invoice Reference Fiscal Year GJAHR
FollowOnDocumentType Follow-On Document Type REBZT
InvoiceItemReference Invoice Item Reference BUZEI
AccountAssignmentNumber Account Assignment Number NUM02
DocumentItemText Item Text TEXT50
SalesOrderItem Sales Order Item POSNR
SalesDocumentItem Sales Document Item POSNR
SupplierName Name of Supplier TEXT80
CustomerName Name of Customer TEXT80
ConditionContract Condition Contract WCB_COCO_NUM
ClearingAccountingDocument Clearing Journal Entry BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CostEstimate Cost Estimate CK_KALNR
InventorySpecialStockType Inventory Special Stock Type SOBKZ
InventorySpclStkSalesDocument Inventory Special Stock Sales Document VBELN
InventorySpclStkSalesDocItm Inventory Special Stock Sales Document Item POSNR
InvtrySpclStockWBSElmntIntID Inventory Special Stock WBS Element Internal ID FIS_WBSINT_NO_CONV
InvtrySpclStockWBSElmntExtID Inventory Special Stock WBS Element External ID FIS_WBSEXT_NO_CONV
InventorySpclStockWBSElement Inventory Special Stock WBS Element FIS_WBS
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
SenderGLAccount Sender G/L Account CHAR10
SenderAccountAssignment Sender Account Assignment ACCAS
OffsettingAccount Offsetting Account GKONT
OffsettingAccountName Name of Offsetting Account TEXT80
OffsettingChartOfAccounts Offsetting Chart of Accounts KTOPL
PersonnelNumber Personnel Number PERNR
AccountAssignment Account Assignment ACCAS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID Partner WBS Element External ID FIS_WBSEXT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
WBSElement WBS Element FIS_WBS
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
PartnerProjectExternalID Partner Project External ID FIS_PROJECTEXT_NO_CONV
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
Project Project FIS_PROJECT
RelatedNetworkActivity Network activity VORNR
PartnerServiceDocumentItem Partner Service Document Item
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
TimeSheetOvertimeCategory Overtime Category CATS_OVERTIME_CATEGORY
PartnerAccountAssignment Partner Account Assignment ACCAS
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProject Partner Project FIS_PROJECT
PartnerProjectNetworkActivity Partner Project Network Activity VORNR
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
GrantID Grant GM_GRANT_NBR
PartnerGrant Partner Grant GM_GRANT_NBR
PubSecBudgetCnsmpnFsclPeriod CC Fiscal Period for Budget Consumption Date POPER
PubSecBudgetCnsmpnFsclYear CC Fiscal Year for Budget Consumption Date GJAHR
CutbackRun Cutback Run TZNTSTMPL
JointVentureAccountingActivity Joint Venture Accounting Activity
PartnerVenture Partner Venture JV_NAME
PartnerEquityGroup Partner Equity Group JV_EGROUP
SenderCostRecoveryCode Sender Cost Recovery Code JV_RECIND
CutbackAccount Cutback Account SAKNR
CutbackCostObject Cutback Cost Object J_OBJNR
OrderOperation Operation/Activity Number VORNR
OrderItem Order item number CO_POSNR
AccrualObject Identifier of the Accrual Object ACR_OBJ_ID
AccrualSubobject Identifier of the Accrual Subobject ACR_SUBOBJ_ID
AccrualItemType Type of the Item of the Accrual Subobject ACR_ITEM_TYPE
FinancialValuationObject Financial Valuation Object VAL_OBJ_ID
FinancialValuationSubobject Financial Valuation Subobject VAL_SUBOBJ_ID
OrderSuboperation Suboperation VORNR
NumberOfItems Number of Items DEC12
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
SenderAccountingDocument Sender Journal Entry BELNR
SenderCompanyCode Company Code in Sender System CHAR4
SenderFiscalYear Fiscal Year of an Accounting Document in the Sender System GJAHR
SenderLogicalSystem Logical System of the Sender LOGSYS
EmployeeFullName Full Name TEXT80
BillToPartyName Name of Bill-to Party TEXT80
CostCtrActivityTypeName Activity Type Name DDTEXT
CustomerGroupName Name of Customer Group TEXT30
CustomerSupplierCountryName Country/Region Name TEXT50
CustomerSupplierIndustryName Description of the Industry Key TEXT20
DistributionChannelName Distribution Channel Name TEXT20
DivisionName Name of Division TEXT30
MaterialName Material Description TEXT40
MaterialGroupName Product Group Description TEXT20
ProductName Product Description TEXT40
ProductGroupName Product Group Description TEXT20
PartnerBusinessAreaName Partner Business Area Name CHAR30
PartnerCompanyName Company Name TEXT30
PartnerCompanyCodeName Partner Company Code Name TEXT25
PartnerCostCenterName Partner Cost Center Name TEXT20
PartnerCostCtrActivityTypeName Partner Activity Type Name DDTEXT
PartnerFunctionalAreaName Partner Functional Area Name CHAR30
PartnerProfitCenterName Partner Profit Center Name CHAR50
PartnerProjectDescription Partner Project Description (1st text line) TEXT40
PartnerSegmentName Partner Segment Name CHAR50
PartnerWBSElementDescription Partner WBS Element Description TEXT40
PlantName Plant Name TEXT30
ProjectDescription Project Description TEXT40
SalesDistrictName Name of the district TEXT20
SalesOrganizationName Sales Organization Name TEXT20
ShipToPartyName Name of Ship-to Party TEXT80
SoldMaterialName Sold Material Name TEXT40
SoldProductName Sold Material Name TEXT40
SoldProductGroupName Product Group Description TEXT20
WBSElementDescription WBS Element Name TEXT40
GLAccountAuthorizationGroup G/L Account Authorization Group BRGRU
SupplierBasicAuthorizationGrp Supplier Basic Authorization Group BRGRU
CustomerBasicAuthorizationGrp Customer Basic Authorization Group BRGRU
AcctgDocTypeAuthorizationGroup Accounting Document Type Authorization Group BRGRU
OrderType Order Type AUFART
SalesOrderType Sales Document Type AUART
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_JOURNALENTRYITEMCUBE.MANDT == T003.MANDT
  • I_JOURNALENTRYITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Type of the Accrual Object
  • Type of the Accrual Object
  • Client
Additional Quantity 1 Unit
  • Additional Quantity 1 Unit
  • Client
  • I_JOURNALENTRYITEMCUBE.ADDITIONALQUANTITY1UNIT == T006.MSEHI
  • I_JOURNALENTRYITEMCUBE.MANDT == T006.MANDT
Additional Quantity 2 Unit
  • Additional Quantity 2 Unit
  • Client
  • I_JOURNALENTRYITEMCUBE.ADDITIONALQUANTITY2UNIT == T006.MSEHI
  • I_JOURNALENTRYITEMCUBE.MANDT == T006.MANDT
Additional Quantity 3 Unit
  • Additional Quantity 3 Unit
  • Client
  • I_JOURNALENTRYITEMCUBE.ADDITIONALQUANTITY3UNIT == T006.MSEHI
  • I_JOURNALENTRYITEMCUBE.MANDT == T006.MANDT
Alternative G/L Account Number In Company Code
  • Alternative Chart of Accounts for Country/Region
  • Alternative G/L Account Number In Company Code
  • Client
  • I_JOURNALENTRYITEMCUBE.COUNTRYCHARTOFACCOUNTS == SKA1.KTOPL
  • I_JOURNALENTRYITEMCUBE.ALTERNATIVEGLACCOUNT == SKA1.SAKNR
  • I_JOURNALENTRYITEMCUBE.MANDT == SKA1.MANDT
Assembly
  • Client
  • Assembly
  • I_JOURNALENTRYITEMCUBE.MANDT == MARA.MANDT
  • I_JOURNALENTRYITEMCUBE.ASSEMBLY == MARA.MATNR
Transaction Type Category I_JOURNALENTRYITEMCUBE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Class
  • Asset Class
  • Client
  • I_JOURNALENTRYITEMCUBE.ASSETCLASS == ANKA.ANLKL
  • I_JOURNALENTRYITEMCUBE.MANDT == ANKA.MANDT
Asset Transaction Type
  • Asset Transaction Type
  • Client
  • I_JOURNALENTRYITEMCUBE.ASSETTRANSACTIONTYPE == TABW.BWASL
  • I_JOURNALENTRYITEMCUBE.MANDT == TABW.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_JOURNALENTRYITEMCUBE.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_JOURNALENTRYITEMCUBE.MANDT == T006.MANDT
  • I_JOURNALENTRYITEMCUBE.BASEUNIT == T006.MSEHI
Billable Control
  • Client
  • Billable Control
  • I_JOURNALENTRYITEMCUBE.MANDT == TBMOT.MANDT
  • I_JOURNALENTRYITEMCUBE.BILLABLECONTROL == TBMOT.BEMOT
Billing Type
  • Billing Type
  • Client
  • I_JOURNALENTRYITEMCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_JOURNALENTRYITEMCUBE.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_JOURNALENTRYITEMCUBE.BILLTOPARTY == KNA1.KUNNR
  • I_JOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
Budget Period
  • Financial Management Area
  • Budget Period
  • Fund
  • Client
  • I_JOURNALENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_JOURNALENTRYITEMCUBE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_JOURNALENTRYITEMCUBE.FUND == FMFUNDBPD.FINCODE
  • I_JOURNALENTRYITEMCUBE.MANDT == FMFUNDBPD.MANDT
Business Area
  • Client
  • Business Area
  • I_JOURNALENTRYITEMCUBE.MANDT == TGSB.MANDT
  • I_JOURNALENTRYITEMCUBE.BUSINESSAREA == TGSB.GSBER
Business Process
  • Business Process
  • Controlling Area
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.BUSINESSPROCESS == CBPR.PRZNR
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CBPR.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == CBPR.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CBPR.DATBI
Business Transaction Category
  • Business Transaction Category
  • Client
  • I_JOURNALENTRYITEMCUBE.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE
  • I_JOURNALENTRYITEMCUBE.MANDT == FINSC_BTTYPE.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Cash Origin Account
  • Chart of Accounts
  • Client
  • Cash Origin Account
  • I_JOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_JOURNALENTRYITEMCUBE.MANDT == SKA1.MANDT
  • I_JOURNALENTRYITEMCUBE.CASHLEDGERACCOUNT == SKA1.SAKNR
Cash Origin Company Code
  • Client
  • Cash Origin Company Code
  • I_JOURNALENTRYITEMCUBE.MANDT == T001.MANDT
  • I_JOURNALENTRYITEMCUBE.CASHLEDGERCOMPANYCODE == T001.BUKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_JOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_JOURNALENTRYITEMCUBE.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_JOURNALENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_JOURNALENTRYITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == TKA01.MANDT
CO Object Currency
  • CO Object Currency
  • Client
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Cost Analysis Resource
  • Controlling Area
  • Cost Analysis Resource
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKR.KOKRS
  • I_JOURNALENTRYITEMCUBE.COSTANALYSISRESOURCE == CSKR.RESRC
  • I_JOURNALENTRYITEMCUBE.MANDT == CSKR.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKR.DATBI
Cost Center
  • Controlling Area
  • Cost Center
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_JOURNALENTRYITEMCUBE.COSTCENTER == CSKS.KOSTL
  • I_JOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
Activity Type
  • Controlling Area
  • Activity Type
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_JOURNALENTRYITEMCUBE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_JOURNALENTRYITEMCUBE.MANDT == CSLA.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
Cost Object
  • Cost Object
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.COSTOBJECT == CKPH.KSTRG
  • I_JOURNALENTRYITEMCUBE.MANDT == CKPH.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CKPH.DATBI
Origin Group as Subdivision of Cost Element
  • Origin Group as Subdivision of Cost Element
  • Controlling Area
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.COSTORIGINGROUP == TKKH1.HRKFT
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == TKKH1.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == TKKH1.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "HRKTYP"] == TKKH1.KOATY
Cost Source Unit
  • Cost Source Unit
  • Client
  • I_JOURNALENTRYITEMCUBE.COSTSOURCEUNIT == T006.MSEHI
  • I_JOURNALENTRYITEMCUBE.MANDT == T006.MANDT
Alternative Chart of Accounts for Country/Region
  • Alternative Chart of Accounts for Country/Region
  • Client
  • I_JOURNALENTRYITEMCUBE.COUNTRYCHARTOFACCOUNTS == T004.KTOPL
  • I_JOURNALENTRYITEMCUBE.MANDT == T004.MANDT
Credit Risk Class
  • Credit Risk Class
  • Client
  • I_JOURNALENTRYITEMCUBE.CREDITRISKCLASS == UKM_RISK_CL.RISK_CLASS
  • I_JOURNALENTRYITEMCUBE.MANDT == UKM_RISK_CL.CLIENT
Customer Number
  • Customer Number
  • Client
  • I_JOURNALENTRYITEMCUBE.CUSTOMER == KNA1.KUNNR
  • I_JOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_JOURNALENTRYITEMCUBE.CUSTOMERGROUP == T151.KDGRP
  • I_JOURNALENTRYITEMCUBE.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_JOURNALENTRYITEMCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_JOURNALENTRYITEMCUBE.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • I_JOURNALENTRYITEMCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_JOURNALENTRYITEMCUBE.MANDT == T016.MANDT
Distribution Channel
  • Client
  • Distribution Channel
  • I_JOURNALENTRYITEMCUBE.MANDT == TVTW.MANDT
  • I_JOURNALENTRYITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Elimination Profit Center
  • Controlling Area
  • Client
  • ?
  • Elimination Profit Center
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == CEPC.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_JOURNALENTRYITEMCUBE.ELIMINATIONPROFITCENTER == CEPC.PRCTR
Equipment Number
  • Equipment Number
  • Client
  • I_JOURNALENTRYITEMCUBE.EQUIPMENT == EQUI.EQUNR
  • I_JOURNALENTRYITEMCUBE.MANDT == EQUI.MANDT
Financial Management Area
  • Financial Management Area
  • Client
  • I_JOURNALENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == FM01.MANDT
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_JOURNALENTRYITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_JOURNALENTRYITEMCUBE.MANDT == T856.MANDT
Financial Valuation Object Type
  • Client
  • Financial Valuation Object Type
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_JOURNALENTRYITEMCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_JOURNALENTRYITEMCUBE.MANDT == T009.MANDT
Asset Subnumber
  • Fixed Asset
  • Asset Subnumber
  • ?
  • Client
  • I_JOURNALENTRYITEMCUBE.MASTERFIXEDASSET == ANLA.ANLN1
  • I_JOURNALENTRYITEMCUBE.FIXEDASSET == ANLA.ANLN2
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == ANLA.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 1 Role (Currency Type)
  • Client
  • Freely Defined Currency 1 Role (Currency Type)
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 2 Role (Currency Type)
  • Freely Defined Currency 2 Role (Currency Type)
  • Client
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 3 Role (Currency Type)
  • Client
  • Freely Defined Currency 3 Role (Currency Type)
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 4 Role (Currency Type)
  • Client
  • Freely Defined Currency 4 Role (Currency Type)
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 5 Role (Currency Type)
  • Client
  • Freely Defined Currency 5 Role (Currency Type)
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 6 Role (Currency Type)
  • Freely Defined Currency 6 Role (Currency Type)
  • Client
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 7 Role (Currency Type)
  • Client
  • Freely Defined Currency 7 Role (Currency Type)
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • I_JOURNALENTRYITEMCUBE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 8 Role (Currency Type)
  • Client
  • Freely Defined Currency 8 Role (Currency Type)
Functional Area
  • Client
  • Functional Area
  • I_JOURNALENTRYITEMCUBE.MANDT == TFKB.MANDT
  • I_JOURNALENTRYITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
Functional Currency
  • Functional Currency
  • Client
  • I_JOURNALENTRYITEMCUBE.FUNCTIONALCURRENCY == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Functional Location
  • Functional Location
  • Client
  • I_JOURNALENTRYITEMCUBE.FUNCTIONALLOCATION == IFLOT.TPLNR
  • I_JOURNALENTRYITEMCUBE.MANDT == IFLOT.MANDT
Fund
  • Financial Management Area
  • Fund
  • Client
  • I_JOURNALENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_JOURNALENTRYITEMCUBE.FUND == FMFINCODE.FINCODE
  • I_JOURNALENTRYITEMCUBE.MANDT == FMFINCODE.MANDT
Funded Program
  • Financial Management Area
  • Funded Program
  • Client
  • I_JOURNALENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMMEASURE.FMAREA
  • I_JOURNALENTRYITEMCUBE.FUNDEDPROGRAM == FMMEASURE.MEASURE
  • I_JOURNALENTRYITEMCUBE.MANDT == FMMEASURE.CLIENT
Funds Management Center
  • Financial Management Area
  • Funds Management Center
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_JOURNALENTRYITEMCUBE.FUNDSCENTER == FMFCTR.FICTR
  • I_JOURNALENTRYITEMCUBE.MANDT == FMFCTR.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_JOURNALENTRYITEMCUBE.COMPANYCODE == SKB1.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == SKB1.MANDT
  • I_JOURNALENTRYITEMCUBE.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Global Currency
  • Client
  • I_JOURNALENTRYITEMCUBE.GLOBALCURRENCY == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Global Currency Role
  • Global Currency Role
  • Client
Group Asset Subnumber
  • Group Asset Subnumber
  • Group Asset
  • ?
  • Client
  • I_JOURNALENTRYITEMCUBE.GROUPFIXEDASSET == ANLA.ANLN2
  • I_JOURNALENTRYITEMCUBE.GROUPMASTERFIXEDASSET == ANLA.ANLN1
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == ANLA.MANDT
House Bank Key
  • House Bank Key
  • ?
  • Client
  • I_JOURNALENTRYITEMCUBE.HOUSEBANK == T012.HBKID
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == T012.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == T012.MANDT
House Bank Account
  • House Bank Key
  • ?
  • Client
  • House Bank Account
  • I_JOURNALENTRYITEMCUBE.HOUSEBANK == T012K.HBKID
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == T012K.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == T012K.MANDT
  • I_JOURNALENTRYITEMCUBE.HOUSEBANKACCOUNT == T012K.HKTID
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • I_JOURNALENTRYITEMCUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_JOURNALENTRYITEMCUBE.MANDT == T149D.MANDT
Joint venture
  • ?
  • Client
  • Joint venture
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == T8JV.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == T8JV.MANDT
  • I_JOURNALENTRYITEMCUBE.JOINTVENTURE == T8JV.VNAME
Joint Venture Billing Type
  • Joint Venture Billing Type
  • Client
  • I_JOURNALENTRYITEMCUBE.JOINTVENTUREBILLINGTYPE == T8JA.BILIND
  • I_JOURNALENTRYITEMCUBE.MANDT == T8JA.MANDT
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • ?
  • Client
  • I_JOURNALENTRYITEMCUBE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == T8JJ.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == T8JJ.MANDT
Joint Venture Equity Group
  • ?
  • Joint Venture Equity Group
  • Client
  • Joint venture
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_JOURNALENTRYITEMCUBE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_JOURNALENTRYITEMCUBE.MANDT == T8JF.MANDT
  • I_JOURNALENTRYITEMCUBE.JOINTVENTURE == T8JF.VNAME
Joint Venture Equity Type
  • ?
  • Client
  • Joint Venture Equity Type
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == T8JE.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == T8JE.MANDT
  • I_JOURNALENTRYITEMCUBE.JOINTVENTUREEQUITYTYPE == T8JE.ETYPE
Joint Venture Partner
  • Client
  • Joint Venture Partner
  • I_JOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
  • I_JOURNALENTRYITEMCUBE.JOINTVENTUREPARTNER == KNA1.KUNNR
Ledger in General Ledger Accounting
  • Client
  • Source Ledger
  • Ledger in General Ledger Accounting
Logical System I_JOURNALENTRYITEMCUBE.LOGICALSYSTEM == TBDLS.LOGSYS
Maintenance activity type
  • Maintenance activity type
  • Client
  • I_JOURNALENTRYITEMCUBE.MAINTENANCEACTIVITYTYPE == T353I.ILART
  • I_JOURNALENTRYITEMCUBE.MANDT == T353I.MANDT
Priority
  • Priority Type
  • Client
  • Priority
  • I_JOURNALENTRYITEMCUBE.MAINTPRIORITYTYPE == T356.ARTPR
  • I_JOURNALENTRYITEMCUBE.MANDT == T356.MANDT
  • I_JOURNALENTRYITEMCUBE.MAINTPRIORITY == T356.PRIOK
Priority Type
  • Priority Type
  • Client
  • I_JOURNALENTRYITEMCUBE.MAINTPRIORITYTYPE == T356A.ARTPR
  • I_JOURNALENTRYITEMCUBE.MANDT == T356A.MANDT
Material Number
  • Material Number
  • Product Number
  • Client
  • I_JOURNALENTRYITEMCUBE.MATERIAL == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.PRODUCT == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • I_JOURNALENTRYITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_JOURNALENTRYITEMCUBE.SOLDPRODUCTGROUP == T023.MATKL
  • I_JOURNALENTRYITEMCUBE.MANDT == T023.MANDT
Operating concern
  • Operating concern
  • Client
  • I_JOURNALENTRYITEMCUBE.OPERATINGCONCERN == TKEB.ERKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == TKEB.MANDT
Order ID
  • Order ID
  • Client
  • I_JOURNALENTRYITEMCUBE.ORDERID == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
Organizational Change
  • Organizational Change
  • Client
Division
  • Client
  • Division
  • I_JOURNALENTRYITEMCUBE.MANDT == TSPA.MANDT
  • I_JOURNALENTRYITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Origin Cost Center
  • Controlling Area
  • Client
  • ?
  • Origin Cost Center
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_JOURNALENTRYITEMCUBE.ORIGINCOSTCENTER == CSKS.KOSTL
Origin Cost Center Activity Type
  • Origin Cost Center Activity Type
  • Controlling Area
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == CSLA.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
Origin Product
  • Origin Product
  • Client
  • I_JOURNALENTRYITEMCUBE.ORIGINPRODUCT == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.MANDT == MARA.MANDT
Origin Profit Center
  • Origin Profit Center
  • Controlling Area
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.ORIGINPROFITCENTER == CEPC.PRCTR
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == CEPC.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
FM: Partner Budget Period
  • Financial Management Area
  • Client
  • FM: Partner Budget Period
  • Partner Fund
  • I_JOURNALENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == FMFUNDBPD.MANDT
  • I_JOURNALENTRYITEMCUBE.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_JOURNALENTRYITEMCUBE.PARTNERFUND == FMFUNDBPD.FINCODE
Partner Business Area
  • Client
  • Partner Business Area
  • I_JOURNALENTRYITEMCUBE.MANDT == TGSB.MANDT
  • I_JOURNALENTRYITEMCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Partner Business Process
  • Partner Business Process
  • Controlling Area
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CBPR.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == CBPR.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CBPR.DATBI
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_JOURNALENTRYITEMCUBE.MANDT == T880.MANDT
  • I_JOURNALENTRYITEMCUBE.PARTNERCOMPANY == T880.RCOMP
Partner Company Code
  • Client
  • Partner Company Code
  • I_JOURNALENTRYITEMCUBE.MANDT == T001.MANDT
  • I_JOURNALENTRYITEMCUBE.PARTNERCOMPANYCODE == T001.BUKRS
Partner Cost Center
  • Controlling Area
  • Partner Cost Center
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_JOURNALENTRYITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_JOURNALENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
Partner Cost Center Activity Type
  • Controlling Area
  • Partner Cost Center Activity Type
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_JOURNALENTRYITEMCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_JOURNALENTRYITEMCUBE.MANDT == CSLA.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
Partner Cost Object
  • Partner Cost Object
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.PARTNERCOSTOBJECT == CKPH.KSTRG
  • I_JOURNALENTRYITEMCUBE.MANDT == CKPH.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CKPH.DATBI
Partner Functional Area
  • Partner Functional Area
  • Client
  • I_JOURNALENTRYITEMCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
  • I_JOURNALENTRYITEMCUBE.MANDT == TFKB.MANDT
Partner Fund
  • Financial Management Area
  • Client
  • Partner Fund
  • I_JOURNALENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == FMFINCODE.MANDT
  • I_JOURNALENTRYITEMCUBE.PARTNERFUND == FMFINCODE.FINCODE
Partner Order
  • Partner Order
  • Partner Order
  • Client
  • I_JOURNALENTRYITEMCUBE.PARTNERORDER_2 == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.PARTNERORDER == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
Partner Order
  • Partner Order
  • Partner Order
  • Client
  • I_JOURNALENTRYITEMCUBE.PARTNERORDER_2 == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.PARTNERORDER == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
Partner Profit Center
  • Controlling Area
  • Client
  • ?
  • Partner Profit Center
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == CEPC.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_JOURNALENTRYITEMCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
Partner Project Internal ID
  • Client
  • Partner Project Internal ID
  • I_JOURNALENTRYITEMCUBE.MANDT == PROJ.MANDT
  • I_JOURNALENTRYITEMCUBE.PARTNERPROJECTINTERNALID == PROJ.PSPNR
Partner Project Network
  • Partner Project Network
  • Client
  • I_JOURNALENTRYITEMCUBE.PARTNERPROJECTNETWORK == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
Partner Segment for Segmental Reporting
  • Client
  • Partner Segment for Segmental Reporting
  • I_JOURNALENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_JOURNALENTRYITEMCUBE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
Partner Service Document
  • Partner Service Document
  • Partner Service Document Type
  • Partner Service Document Item
  • Client
  • I_JOURNALENTRYITEMCUBE.PARTNERSERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_JOURNALENTRYITEMCUBE.PARTNERSERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_JOURNALENTRYITEMCUBE.PARTNERSERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_JOURNALENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
Partner Service Document Type
  • Partner Service Document Type
  • Client
Plant
  • Plant
  • Client
  • I_JOURNALENTRYITEMCUBE.PLANT == T001W.WERKS
  • I_JOURNALENTRYITEMCUBE.MANDT == T001W.MANDT
Posting Key
  • Posting Key
  • Client
  • I_JOURNALENTRYITEMCUBE.POSTINGKEY == TBSL.BSCHL
  • I_JOURNALENTRYITEMCUBE.MANDT == TBSL.MANDT
Predecessor Reference Document Type I_JOURNALENTRYITEMCUBE.PREDECESSORREFERENCEDOCTYPE == TTYP.AWTYP
Product Number
  • Material Number
  • Product Number
  • Client
  • I_JOURNALENTRYITEMCUBE.MATERIAL == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.PRODUCT == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • I_JOURNALENTRYITEMCUBE.PRODUCTGROUP == T023.MATKL
  • I_JOURNALENTRYITEMCUBE.MANDT == T023.MANDT
Profit Center
  • Controlling Area
  • Profit Center
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_JOURNALENTRYITEMCUBE.PROFITCENTER == CEPC.PRCTR
  • I_JOURNALENTRYITEMCUBE.MANDT == CEPC.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
Project Internal ID
  • Client
  • Project Internal ID
  • I_JOURNALENTRYITEMCUBE.MANDT == PROJ.MANDT
  • I_JOURNALENTRYITEMCUBE.PROJECTINTERNALID == PROJ.PSPNR
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_JOURNALENTRYITEMCUBE.PROJECTNETWORK == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
Budget Account
  • Chart of Accounts
  • Client
  • Budget Account
  • I_JOURNALENTRYITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_JOURNALENTRYITEMCUBE.MANDT == SKA1.MANDT
  • I_JOURNALENTRYITEMCUBE.PUBSECBUDGETACCOUNT == SKA1.SAKNR
Budget Account Company Code
  • Client
  • Budget Account Company Code
  • I_JOURNALENTRYITEMCUBE.MANDT == T001.MANDT
  • I_JOURNALENTRYITEMCUBE.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
Budget Consumption Type
  • Budget Consumption Type
  • Client
Reference Document Type I_JOURNALENTRYITEMCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Sales District
  • Sales District
  • Client
  • I_JOURNALENTRYITEMCUBE.SALESDISTRICT == T171.BZIRK
  • I_JOURNALENTRYITEMCUBE.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_JOURNALENTRYITEMCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_JOURNALENTRYITEMCUBE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_JOURNALENTRYITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • I_JOURNALENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
Service Contract ID
  • Service Contract Item ID
  • Service Contract Type
  • Client
  • Service Contract ID
  • I_JOURNALENTRYITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_JOURNALENTRYITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_JOURNALENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_JOURNALENTRYITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
Service Contract Item ID
  • Service Contract Item ID
  • Service Contract Type
  • Client
  • Service Contract ID
  • I_JOURNALENTRYITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_JOURNALENTRYITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_JOURNALENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_JOURNALENTRYITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
Service Contract Type
  • Service Contract Type
  • Client
Service Document ID
  • Service Document Item ID
  • Client
  • Service Document ID
  • Service Document Type
  • I_JOURNALENTRYITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_JOURNALENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_JOURNALENTRYITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_JOURNALENTRYITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Item ID
  • Service Document Item ID
  • Client
  • Service Document ID
  • Service Document Type
  • I_JOURNALENTRYITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_JOURNALENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_JOURNALENTRYITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_JOURNALENTRYITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
Service Document Type
  • Client
  • Service Document Type
Ship-to Party
  • Client
  • Ship-to Party
  • I_JOURNALENTRYITEMCUBE.MANDT == KNA1.MANDT
  • I_JOURNALENTRYITEMCUBE.SHIPTOPARTY == KNA1.KUNNR
Sold Material
  • Sold Material
  • Product Sold
  • Client
  • I_JOURNALENTRYITEMCUBE.SOLDMATERIAL == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.SOLDPRODUCT == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.MANDT == MARA.MANDT
Product Sold
  • Sold Material
  • Product Sold
  • Client
  • I_JOURNALENTRYITEMCUBE.SOLDMATERIAL == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.SOLDPRODUCT == MARA.MATNR
  • I_JOURNALENTRYITEMCUBE.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • I_JOURNALENTRYITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_JOURNALENTRYITEMCUBE.SOLDPRODUCTGROUP == T023.MATKL
  • I_JOURNALENTRYITEMCUBE.MANDT == T023.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Source Logical System I_JOURNALENTRYITEMCUBE.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_JOURNALENTRYITEMCUBE.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Special G/L Indicator
  • Client
  • Special G/L Indicator
  • Account Type
  • I_JOURNALENTRYITEMCUBE.MANDT == T074U.MANDT
  • I_JOURNALENTRYITEMCUBE.SPECIALGLCODE == T074U.UMSKZ
  • I_JOURNALENTRYITEMCUBE.FINANCIALACCOUNTTYPE == T074U.KOART
Subledger-Specific Line Item Type I_JOURNALENTRYITEMCUBE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Number of Superior Order
  • Number of Superior Order
  • Client
  • I_JOURNALENTRYITEMCUBE.SUPERIORORDER == AUFK.AUFNR
  • I_JOURNALENTRYITEMCUBE.MANDT == AUFK.MANDT
Supplier
  • Supplier
  • Client
  • I_JOURNALENTRYITEMCUBE.SUPPLIER == LFA1.LIFNR
  • I_JOURNALENTRYITEMCUBE.MANDT == LFA1.MANDT
Tax on Sales/Purchases Code
  • Tax on Sales/Purchases Code
  • ?
  • Client
  • I_JOURNALENTRYITEMCUBE.TAXCODE == T007A.MWSKZ
  • I_JOURNALENTRYITEMCUBE.[column in domain "KALSM_D"] == T007A.KALSM
  • I_JOURNALENTRYITEMCUBE.MANDT == T007A.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • I_JOURNALENTRYITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_JOURNALENTRYITEMCUBE.MANDT == TCURC.MANDT
Valuation area
  • Client
  • Valuation area
  • I_JOURNALENTRYITEMCUBE.MANDT == T001K.MANDT
  • I_JOURNALENTRYITEMCUBE.VALUATIONAREA == T001K.BWKEY
Origin G/L Account of a Variance
  • ?
  • Client
  • Origin G/L Account of a Variance
  • I_JOURNALENTRYITEMCUBE.[column in domain "BUKRS"] == SKB1.BUKRS
  • I_JOURNALENTRYITEMCUBE.MANDT == SKB1.MANDT
  • I_JOURNALENTRYITEMCUBE.VARIANCEORIGINGLACCOUNT == SKB1.SAKNR
Object ID of the resource
  • Object ID of the resource
  • Client
  • ?
  • I_JOURNALENTRYITEMCUBE.WORKCENTERINTERNALID == CRID.OBJID
  • I_JOURNALENTRYITEMCUBE.MANDT == CRID.MANDT
  • I_JOURNALENTRYITEMCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY