I_ActualPlanJrnlEntryItemCube

Actual Plan of Journal Entry Item - Cube | view: IFIACTPLNJEIC | TRAN | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, MARA, T003, T003T, TGSB, TGSBT, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, 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, AUFK, T001W, MARA, T023T, T023, CRTX, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, T016T, PRPS, PRPS, CRHD, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
SourceLedger FK Source Ledger
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
FinancialPlanningReqTransSqnc Financial Planning Request Transaction Sequence Number
FinancialPlanningDataPacket Financial Planning Data Packet Number
ActualPlanJournalEntryItem Actual Plan Journal Entry Item
Column Name Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
ActualAmountInTransactionCrcy Actual Amount in Transaction Currency
PlanAmountInTransactionCrcy Plan Amount in Transaction Currency
PlanPriceInTransactionCurrency Price in Transaction Currency
ActlPlnDiffAmtInTransCrcy Actual plan difference in transaction currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
FixedAmountInCoCodeCrcy Fixed Amount in Company Currency
ActualAmountInCompanyCodeCrcy Actual Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy Plan Amount in Company Code Currency
PlanPriceInCompanyCodeCurrency Price in Company Code Currency
ActlPlnDiffAmtInCoCodeCrcy Actual plan difference in company code currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
ActualAmountInGlobalCurrency Actual Amount in Global Currency
PlanAmountInGlobalCurrency Plan Amount in Global Currency
PlanPriceInGlobalCurrency Price in Global Currency
ActlPlnDiffAmtInGlobalCrcy Actual plan difference in global currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
ActualAmountInFreeDfndCrcy1 Actual Amount in Freely Defined Currency 1
PlanAmountInFreeDefinedCrcy1 Plan Amount in Freely Defined Currency 1
ActlPlnDiffAmtInFreeDfndCrcy1 Actual plan difference in freely defined currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
ActualAmountInFreeDfndCrcy2 Actual Amount in Freely Defined Currency 2
PlanAmountInFreeDefinedCrcy2 Plan Amount in Freely Defined Currency 2
ActlPlnDiffAmtInFreeDfndCrcy2 Actual plan difference in freely defined currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
ActualAmountInFreeDfndCrcy3 Actual Amount in Freely Defined Currency 3
PlanAmountInFreeDefinedCrcy3 Plan Amount in Freely Defined Currency 3
ActlPlnDiffAmtInFreeDfndCrcy3 Actual plan difference in freely defined currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
ActualAmountInFreeDfndCrcy4 Actual Amount in Freely Defined Currency 4
PlanAmountInFreeDefinedCrcy4 Plan Amount in Freely Defined Currency 4
ActlPlnDiffAmtInFreeDfndCrcy4 Actual plan difference in freely defined currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
ActualAmountInFreeDfndCrcy5 Actual Amount in Freely Defined Currency 5
PlanAmountInFreeDefinedCrcy5 Plan Amount in Freely Defined Currency 5
ActlPlnDiffAmtInFreeDfndCrcy5 Actual plan difference in freely defined currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
ActualAmountInFreeDfndCrcy6 Actual Amount in Freely Defined Currency 6
PlanAmountInFreeDefinedCrcy6 Plan Amount in Freely Defined Currency 6
ActlPlnDiffAmtInFreeDfndCrcy6 Actual plan difference in freely defined currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
ActualAmountInFreeDfndCrcy7 Actual Amount in Freely Defined Currency 7
PlanAmountInFreeDefinedCrcy7 Plan Amount in Freely Defined Currency 7
ActlPlnDiffAmtInFreeDfndCrcy7 Actual plan difference in freely defined currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
ActualAmountInFreeDfndCrcy8 Actual Amount in Freely Defined Currency 8
PlanAmountInFreeDefinedCrcy8 Plan Amount in Freely Defined Currency 8
ActlPlnDiffAmtInFreeDfndCrcy8 Actual plan difference in freely defined currency 8
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in Object Currency
ActualAmountInObjectCurrency Actual Amount in Object Currency
PlanAmountInObjectCurrency Plan Amount in Object Currency
ActlPlnDiffAmtInObjectCrcy Actual plan difference in object currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation quantity
ActualValuationQuantity Actual Valuation Quantity
PlanValuationQuantity Plan Valuation Quantity
ActlPanDiffValuationQuantity Actual Plan Difference Valuation Quantity
📏 Unit of Measure for Reference Quantity (ReferenceQuantityUnit):
ReferenceQuantity Reference quantity
ActualReferenceQuantity Actual Reference Quantity
PlanReferenceQuantity Plan Reference Quantity
ActlPlanDiffReferenceQuantity Actual Plan Difference Reference Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
ServicesRenderedDate Date on which services are rendered
PubSecBudgetCnsmpnDate Budget Consumption Date
JointVentureProductionDate Joint Venture Production Date
SettlementReferenceDate Settlement Reference Date
Column Name Description
ActualPlanCode Actual Plan Code Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
FinancialAccountType Account Type 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
IsCommitment Indicator: Is Commitment Show values
PubSecBudgetIsRelevant Budget-Relevant Indicator Show values
PubSecBudgetCnsmpnAmtType Budget Consumption Amount Type Show values
Column Name Description Domain name
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
FinancialPlanningEntryItem Financial Planning Entry Item RSNUMRECORD
LedgerFiscalYear Ledger Fiscal Year GJAHR
LedgerName Ledger Name TEXT30
CompanyCodeName Company Code Name TEXT25
ControllingAreaName Controlling Area Name TEXT25
GLAccountName G/L Account Name CHAR30
GLAccountLongName G/L Account Long Name CHAR50
Project Project FIS_PROJECT
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
PartnerProjectExternalID Partner Project External ID FIS_PROJECTEXT_NO_CONV
WBSElement WBS Element FIS_WBS
WBSElementInternalID WBS Element Internal ID FIS_WBSINT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
PartnerWBSElementInternalID Partner WBS Element Internal ID FIS_WBSINT_NO_CONV
PartnerWBSElementExternalID Partner WBS Element External ID FIS_WBSEXT_NO_CONV
WorkPackage Plan Item /CPD/PLAN_ITEM_ID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
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
CostCtrActivityTypeName Activity Type Name DDTEXT
WBSElementDescription WBS Element Name TEXT40
ProjectDescription Project Name TEXT40
PartnerProject Partner Project FIS_PROJECT
PartnerWBSElement Partner WBS Element FIS_WBS
PartnerProjectNetworkActivity Partner Project Network Activity VORNR
ReferenceDocumentContext Reference Document Context AWORG
ReferenceDocument Reference document number AWREF
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
PlanningCategory Plan Category FCOM_CATEGORY
PersonnelNumber Personnel Number PERNR
BusinessTransactionTypeName Business Transaction Type Description TEXT30
AccountingDocumentTypeName Document Type Name TEXT20
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
SalesOrderItem Sales Order Item POSNR
SalesDocumentItem Sales Document Item POSNR
CustomerSupplierCorporateGroup Customer Supplier Corporate Group KONZS
OrderOperation Operation/Activity Number VORNR
OrderItem Order item number CO_POSNR
SourceReferenceDocumentCntxt Source Reference Document Context AWORG
SourceReferenceDocument Source Reference Document AWREF
SourceReferenceDocumentItem Source Reference Document Item NUMC6
SourceReferenceDocSubitem Source Reference Document Subitem NUMC6
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
SponsoredProgram Sponsored Program GM_SPONSORED_PROG
SponsoredClass Sponsored Class GM_SPONSORED_CLASS
GteeMBudgetValidityNumber Budget Validity Number GM_BDGT_VLDTY_NBR
BudgetProcess Budget Process Type BUDGET_PROCESS
BudgetingType Budget Type (Subcategory) BUDGET_SUBCATEGORY
JointVentureAccountingActivity Joint Venture Accounting Activity
REBusinessEntity RE Business Entity REBDVDMBENO
RealEstateBuilding Real Estate Building REBDVDMBUNO
RealEstateProperty Real Estate Property REBDVDMPRNO
RERentalObject RE Rental Object REBDVDMRONO
RealEstateContract Real Estate Contract RECNVDMCNNR
REServiceChargeKey RE Service Charge Key RESCVDMSCKEY
RESettlementUnitID RE Settlement Unit RESCVDMSUID
BillToPartyName Name of Bill-to Party TEXT80
CustomerName Name of Customer TEXT80
CustomerGroupName Name of Customer Group TEXT30
CustomerSupplierCountryName Country/Region Name of Customer/Supplier TEXT15
CustomerSupplierIndustryName Customer Supplier Industry Name 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
SoldMaterialName Sold Material Name TEXT40
SoldProductName Sold Material Name TEXT40
SoldProductGroupName 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
SalesDistrictName Name of the district TEXT20
SalesOrganizationName Sales Organization Name TEXT20
ShipToPartyName Name of Ship-to Party TEXT80
WorkCenterText Work Center Text TEXT40
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
YearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
YearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
YearWeek 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
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
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T003.MANDT
Transaction Type Category I_ACTUALPLANJRNLENTRYITEMCUBE.ASSETACCTTRANSCLASSFCTN == FAAI_MOVCAT.MOVCAT
Asset Class
  • Asset Class
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ASSETCLASS == ANKA.ANLKL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == ANKA.MANDT
Billable Control
  • Billable Control
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.BILLABLECONTROL == TBMOT.BEMOT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TBMOT.MANDT
Billing Type
  • Billing Type
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.BILLINGDOCUMENTTYPE == TVFK.FKART
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TVFK.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.BILLTOPARTY == KNA1.KUNNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == KNA1.MANDT
Budget Period
  • Fund
  • Budget Period
  • Client
  • Financial Management Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FUND == FMFUNDBPD.FINCODE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.BUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FMFUNDBPD.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
Business Area
  • Business Area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.BUSINESSAREA == TGSB.GSBER
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TGSB.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FINSC_BTTYPE.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Cash Origin Account
  • Chart of Accounts
  • Client
  • Cash Origin Account
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == SKA1.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CASHLEDGERACCOUNT == SKA1.SAKNR
Cash Origin Company Code
  • Client
  • Cash Origin Company Code
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T001.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CASHLEDGERCOMPANYCODE == T001.BUKRS
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CHARTOFACCOUNTS == T004.KTOPL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T001.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TKA01.MANDT
CO Object Currency
  • Client
  • CO Object Currency
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Analysis Resource
  • ?
  • Controlling Area
  • Client
  • Cost Analysis Resource
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CSKR.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CSKR.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CSKR.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.COSTANALYSISRESOURCE == CSKR.RESRC
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.COSTCENTER == CSKS.KOSTL
Activity Type
  • Activity Type
  • ?
  • Controlling Area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CSLA.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.COSTSOURCEUNIT == T006.MSEHI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T006.MANDT
Customer Number
  • Customer Number
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CUSTOMER == KNA1.KUNNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T151.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CUSTOMERGROUP == T151.KDGRP
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T005.MANDT
Customer Supplier Industry
  • Client
  • Customer Supplier Industry
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T016.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
Distribution Channel
  • Distribution Channel
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • Organization Division
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TSPA.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.DIVISION == TSPA.SPART
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Financial Management Area
  • Client
  • Financial Management Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FM01.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FM01.FIKRS
Financial Transaction Type
  • Financial Transaction Type
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALTRANSACTIONTYPE == T856.TRTYP
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T856.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FISCALYEARVARIANT == T009.PERIV
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T009.MANDT
Asset Subnumber
  • ?
  • Fixed Asset
  • Client
  • Asset Subnumber
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MASTERFIXEDASSET == ANLA.ANLN1
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == ANLA.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FIXEDASSET == ANLA.ANLN2
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Freely Defined Currency 6
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Functional Area
  • Functional Area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FUNCTIONALAREA == TFKB.FKBER
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TFKB.MANDT
Functional Currency
  • Client
  • Functional Currency
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FUNCTIONALCURRENCY == TCURC.WAERS
Fund
  • Fund
  • Client
  • Financial Management Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FUND == FMFINCODE.FINCODE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FMFINCODE.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
Funded Program
  • Funded Program
  • Client
  • Financial Management Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FUNDEDPROGRAM == FMMEASURE.MEASURE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FMMEASURE.CLIENT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMMEASURE.FMAREA
Funds Management Center
  • ?
  • Client
  • Financial Management Area
  • Funds Management Center
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "FM_DATBIS"] == FMFCTR.DATBIS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FMFCTR.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFCTR.FIKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FUNDSCENTER == FMFCTR.FICTR
G/L Account
  • G/L Account
  • Client
  • Company Code
  • I_ACTUALPLANJRNLENTRYITEMCUBE.GLACCOUNT == SKB1.SAKNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == SKB1.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Global Currency
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.GLOBALCURRENCY == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Joint venture
  • ?
  • Client
  • Joint venture
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "BUKRS"] == T8JV.BUKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T8JV.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.JOINTVENTURE == T8JV.VNAME
Joint Venture Cost Recovery Code
  • Joint Venture Cost Recovery Code
  • ?
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.JOINTVENTURECOSTRECOVERYCODE == T8JJ.RECID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "BUKRS"] == T8JJ.BUKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T8JJ.MANDT
Joint Venture Equity Group
  • ?
  • Client
  • Joint Venture Equity Group
  • Joint venture
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "BUKRS"] == T8JF.BUKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T8JF.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.JOINTVENTUREEQUITYGROUP == T8JF.EGRUP
  • I_ACTUALPLANJRNLENTRYITEMCUBE.JOINTVENTURE == T8JF.VNAME
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FINSC_LEDGER.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.LEDGER == FINSC_LEDGER.RLDNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOURCELEDGER == FINSC_LEDGER.RLDNR
Material Number
  • Material Number
  • Product Number
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MATERIAL == MARA.MATNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PRODUCT == MARA.MATNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOLDPRODUCTGROUP == T023.MATKL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T023.MANDT
Order ID
  • Order ID
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ORDERID == AUFK.AUFNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == AUFK.MANDT
Organization Division
  • Client
  • Division
  • Organization Division
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TSPA.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.DIVISION == TSPA.SPART
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ORGANIZATIONDIVISION == TSPA.SPART
Origin Cost Center
  • ?
  • Controlling Area
  • Client
  • Origin Cost Center
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CSKS.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ORIGINCOSTCENTER == CSKS.KOSTL
Origin Cost Center Activity Type
  • ?
  • Controlling Area
  • Client
  • Origin Cost Center Activity Type
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CSLA.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Origin Profit Center
  • Origin Profit Center
  • ?
  • Controlling Area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.ORIGINPROFITCENTER == CEPC.PRCTR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CEPC.MANDT
FM: Partner Budget Period
  • Partner Fund
  • Client
  • FM: Partner Budget Period
  • Financial Management Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERFUND == FMFUNDBPD.FINCODE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FMFUNDBPD.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERBUDGETPERIOD == FMFUNDBPD.BUDGET_PD
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFUNDBPD.FIKRS
Partner Business Area
  • Client
  • Partner Business Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TGSB.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERBUSINESSAREA == TGSB.GSBER
Partner Business Process
  • Partner Business Process
  • ?
  • Controlling Area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CBPR.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CBPR.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CBPR.MANDT
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T880.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERCOMPANY == T880.RCOMP
Partner Company Code
  • Partner Company Code
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERCOMPANYCODE == T001.BUKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T001.MANDT
Partner Cost Center
  • ?
  • Controlling Area
  • Partner Cost Center
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CSKS.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CSKS.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERCOSTCENTER == CSKS.KOSTL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CSKS.MANDT
Partner Cost Center Activity Type
  • ?
  • Controlling Area
  • Client
  • Partner Cost Center Activity Type
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CSLA.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CSLA.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CSLA.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Partner Cost Object
  • ?
  • Partner Cost Object
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CKPH.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERCOSTOBJECT == CKPH.KSTRG
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CKPH.MANDT
Partner Functional Area
  • Client
  • Partner Functional Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TFKB.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Fund
  • Partner Fund
  • Client
  • Financial Management Area
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERFUND == FMFINCODE.FINCODE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FMFINCODE.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.FINANCIALMANAGEMENTAREA == FMFINCODE.FIKRS
Partner Order
  • Partner Order
  • Partner Order
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERORDER_2 == AUFK.AUFNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERORDER == AUFK.AUFNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == AUFK.MANDT
Partner Order
  • Partner Order
  • Partner Order
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERORDER_2 == AUFK.AUFNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERORDER == AUFK.AUFNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == AUFK.MANDT
Partner Profit Center
  • Partner Profit Center
  • ?
  • Controlling Area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERPROFITCENTER == CEPC.PRCTR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CEPC.MANDT
Partner Project Internal ID
  • Partner Project Internal ID
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERPROJECTINTERNALID == PROJ.PSPNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == PROJ.MANDT
Partner Project Network
  • Partner Project Network
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERPROJECTNETWORK == AUFK.AUFNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == AUFK.MANDT
Partner Segment for Segmental Reporting
  • Partner Segment for Segmental Reporting
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PARTNERSEGMENT == FAGL_SEGM.SEGMENT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
Plant
  • Client
  • Plant
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T001W.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PLANT == T001W.WERKS
Product Number
  • Material Number
  • Product Number
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MATERIAL == MARA.MATNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PRODUCT == MARA.MATNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PRODUCTGROUP == T023.MATKL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T023.MANDT
Profit Center
  • ?
  • Controlling Area
  • Client
  • Profit Center
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CEPC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PROFITCENTER == CEPC.PRCTR
Project Internal ID
  • Project Internal ID
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PROJECTINTERNALID == PROJ.PSPNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == PROJ.MANDT
Budget Account
  • Budget Account
  • Chart of Accounts
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PUBSECBUDGETACCOUNT == SKA1.SAKNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.CHARTOFACCOUNTS == SKA1.KTOPL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == SKA1.MANDT
Budget Account Company Code
  • Budget Account Company Code
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PUBSECBUDGETACCOUNTCOCODE == T001.BUKRS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T001.MANDT
Budget Consumption Type
  • Budget Consumption Type
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.PUBSECBUDGETCNSMPNTYPE == PSM_D_BDGTCNSTY.BDGT_CNSMPN_TYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == PSM_D_BDGTCNSTY.CLIENT
Reference Document Type I_ACTUALPLANJRNLENTRYITEMCUBE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Unit of Measure for Reference Quantity
  • Unit of Measure for Reference Quantity
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.REFERENCEQUANTITYUNIT == T006.MSEHI
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T006.MANDT
Sales District
  • Client
  • Sales District
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T171.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SALESDISTRICT == T171.BZIRK
Sales Organization
  • Sales Organization
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FAGL_SEGM.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SEGMENT == FAGL_SEGM.SEGMENT
Service Contract ID
  • Service Contract ID
  • Service Contract Type
  • Service Contract Item ID
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
Service Contract Item ID
  • Service Contract ID
  • Service Contract Type
  • Service Contract Item ID
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICECONTRACT == FCO_SRVDOC.SERVICE_DOC_ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICECONTRACTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICECONTRACTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
Service Contract Type
  • Service Contract Type
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICECONTRACTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CRMC_PROC_TYPE.CLIENT
Service Document ID
  • Service Document Item ID
  • Service Document Type
  • Client
  • Service Document ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Item ID
  • Service Document Item ID
  • Service Document Type
  • Client
  • Service Document ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICEDOCUMENTITEM == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FCO_SRVDOC.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Type
  • Service Document Type
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SERVICEDOCUMENTTYPE == CRMC_PROC_TYPE.PROCESS_TYPE
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CRMC_PROC_TYPE.CLIENT
Ship-to Party
  • Ship-to Party
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SHIPTOPARTY == KNA1.KUNNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == KNA1.MANDT
Sold Material
  • Client
  • Sold Material
  • Product Sold
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == MARA.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOLDMATERIAL == MARA.MATNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOLDPRODUCT == MARA.MATNR
Product Sold
  • Client
  • Sold Material
  • Product Sold
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == MARA.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOLDMATERIAL == MARA.MATNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Product Sold Group
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MATERIALGROUP == T023.MATKL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOLDPRODUCTGROUP == T023.MATKL
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T023.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == FINSC_LEDGER.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.LEDGER == FINSC_LEDGER.RLDNR
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SOURCELEDGER == FINSC_LEDGER.RLDNR
Source Logical System I_ACTUALPLANJRNLENTRYITEMCUBE.SOURCELOGICALSYSTEM == TBDLS.LOGSYS
Source Reference Document Type I_ACTUALPLANJRNLENTRYITEMCUBE.SOURCEREFERENCEDOCUMENTTYPE == TTYP.AWTYP
Subledger-Specific Line Item Type I_ACTUALPLANJRNLENTRYITEMCUBE.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE
Supplier
  • Client
  • Supplier
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == LFA1.MANDT
  • I_ACTUALPLANJRNLENTRYITEMCUBE.SUPPLIER == LFA1.LIFNR
Transaction Currency
  • Transaction Currency
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == TCURC.MANDT
Valuation area
  • Valuation area
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.VALUATIONAREA == T001K.BWKEY
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == T001K.MANDT
Object ID of the resource
  • ?
  • Object ID of the resource
  • Client
  • I_ACTUALPLANJRNLENTRYITEMCUBE.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • I_ACTUALPLANJRNLENTRYITEMCUBE.WORKCENTERINTERNALID == CRID.OBJID
  • I_ACTUALPLANJRNLENTRYITEMCUBE.MANDT == CRID.MANDT