What is I_ActPlnCostCenterRptgCube in SAP S/4HANA?

I_ActPlnCostCenterRptgCube is a composite CDS view in SAP S/4HANA. Cost Center Review Booklet - Cube It contains 155 fields.

Which tables does I_ActPlnCostCenterRptgCube read from?

I_ActPlnCostCenterRptgCube reads data from: I_ActualPlanJournalEntryItem.

What VDM layer is I_ActPlnCostCenterRptgCube?

I_ActPlnCostCenterRptgCube is classified as a Composite view that combines data from multiple basic views.

I_ActPlnCostCenterRptgCube

DDL: I_ACTPLNCOSTCENTERRPTGCUBE Type: view_entity COMPOSITE Package: FINS_CO_ANALYTICS

155 Fields 1 Data Sources 4 Associations

Cost Center Review Booklet - Cube

I_ActPlnCostCenterRptgCube (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Accounting and Financial Close

I_ActPlnCostCenterRptgCube is a Composite CDS View (Cube) that provides data about "Cost Center Review Booklet - Cube" in SAP S/4HANA. It reads from 1 data source (I_ActualPlanJournalEntryItem) and exposes 155 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. It has 4 associations to related views. Part of development package FINS_CO_ANALYTICS.

SAP Help Documentation

Category	CDS Views for Overhead Accounting
Data Category	Cube

Purpose
This CDS view is designed to provide a comprehensive analytical cube for reviewing cost center data, including actual and planned financial transactions. It aggregates financial data across various dimensions such as fiscal periods, currencies, and cost centers, enabling detailed analysis and reporting. This CDS view provides the data to answer the following business questions: What are the actual and planned financial amounts for each cost center within a specific fiscal year and period? How do actual financial transactions compare to planned transactions in different currencies? What are the differences between actual and planned amounts for cost centers, and how do these differences impact financial planning? How are financial transactions distributed across different dimensions such as profit centers, projects, and functional areas? What is the valuation quantity and fixed quantity for transactions in various units of measure? How do financial transactions vary across different calendar and fiscal periods, including months, quarters, and years? What are the detailed account assignments for general ledger transactions, including cost centers, profit centers, and other financial dimensions? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Restriction Type ID Restriction Type BEGRU_BKPF_BEK Authorization Group for Supplier-Related Journal Entries BEGRU_BKPF_BED Authorization Group for Customer Related Journal Entries BUKRS_GLRLDNR_CATEGORY_P Company Code/Ledger/Category SEGMENT_GLRRCTY Segment for Segmental Reporting/Record Type BUKRS_GLRLDNR_GLRRCTY_GLRVERS Company Code/Ledger/Record Type/Version BUKRS_PRCTR_KSTAR Company Code/ Profit Center / Cost Element COMPANYCODE_HIERARCHY Company Code Hierarchies AUART Sales Document Type KOSTL_KSTAR Cost Center/Cost Element FKBER Functional Area F_BKPF_ORD Order Category / Order Type for Journal Entries BUKRS Company Code

Structure
Important Fields Important fields in this view include the following: Field Name Label SourceLedger Source Ledger Ledger Ledger CompanyCode Company Code FiscalYear Fiscal Year AccountingDocument Journal Entry FinancialPlanningReqTransSqnc FP Request TSN FinancialPlanningDataPacket FP Data Packet ActualPlanJournalEntryItem Actual Plan Journal Entry Item LedgerGLLineItem Journal Entry Item FinancialPlanningEntryItem FP Entry Item ControllingArea Controlling Area LedgerFiscalYear Fiscal Year of Ledger GLAccount G/L Account ChartOfAccounts Chart of Accounts ActualPlanCode Actual/Plan Code DebitCreditCode Debit/Credit Code ProfitCenter Profit Center CostCenter Cost Center ProjectExternalID Project External ID PartnerProjectInternalID Partner Project Internal ID PartnerProjectExternalID Partner Project External ID WBSElementExternalID WBS Element External ID PartnerWBSElementExternalID Partner WBS Element External ID FunctionalArea Functional Area Segment Segment CostCtrActivityType Activity Type CostAnalysisResource Cost Analysis Resource OrderID Order ID WorkPackage Plan Item PartnerAccountAssignmentType Partner Account Assignment Type PartnerCompanyCode Partner Company Code PartnerProfitCenter Partner Profit Center PartnerCostCenter Partner Cost Center PartnerFunctionalArea Partner Func. Area PartnerSegment Partner Segment PartnerCostCtrActivityType Partner Cost Center Activity Type PartnerOrder Partner Order PostingDate Posting Date DocumentDate Journal Entry Date FiscalPeriod Fiscal Period FiscalYearPeriod Fiscal Year Period FiscalYearVarian

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-OM-CCA-2CL
Capabilities	Data Provider for Analytical Queries,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Accounting and Financial Close for SAP S/4HANA Cloud Public Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_ActualPlanJournalEntryItem	APJEI	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_CalendarMonth	_CalendarMonth	`$projection.CalendarMonth = _CalendarMonth.CalendarMonth`
[1..1]	I_CalendarQuarter	_CalendarQuarter	`$projection.CalendarQuarter = _CalendarQuarter.CalendarQuarter`
[1..1]	I_YearMonth	_CalendarYearMonth	`$projection.YearMonth = _CalendarYearMonth.YearMonth`
[1..1]	E_FinancialPlanningEntryItem	_Extension_acdocp	`APJEI.FinancialPlanningReqTransSqnc = _Extension_acdocp.FinancialPlanningReqTransSqnc and APJEI.FinancialPlanningDataPacket = _Extension_acdocp.FinancialPlanningDataPacket and APJEI.FinancialPlanningEntryItem = _Extension_acdocp.FinancialPlanningEntryItem`

Annotations (17)

Name	Value	Level
AbapCatalog.entityBuffer.definitionAllowed	false	view
EndUserText.label	Cost Center Review Booklet - Cube	view
Analytics.internalName	#LOCAL	view
Analytics.dataCategory	#CUBE	view
Analytics.technicalName	IFIACTPLNCOCREPOC	view
VDM.viewType	#COMPOSITE	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
AccessControl.auditFilter	#ENABLED	view
Environment.sql.passValueForClient	true	view
Analytics.intentBasedNavigation.filterMapper	CL_FCO_RB_CUBE_EXIT	view

Fields (155)

Key	Field	Source Table	Source Field	Description
KEY	SourceLedger	I_ActualPlanJournalEntryItem	SourceLedger	Source Ledger
KEY	Ledger	I_ActualPlanJournalEntryItem	Ledger	Ledger in General Ledger Accounting
KEY	CompanyCode	I_ActualPlanJournalEntryItem	CompanyCode	Receiver Company Code
KEY	FiscalYear	I_ActualPlanJournalEntryItem	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	I_ActualPlanJournalEntryItem	AccountingDocument	Journal Entry
KEY	FinancialPlanningReqTransSqnc	I_ActualPlanJournalEntryItem	FinancialPlanningReqTransSqnc	Financial Planning Request Transaction Sequence Number
KEY	FinancialPlanningDataPacket	I_ActualPlanJournalEntryItem	FinancialPlanningDataPacket	Financial Planning Data Packet Number
KEY	ActualPlanJournalEntryItem	I_ActualPlanJournalEntryItem	ActualPlanJournalEntryItem	Actual Plan Journal Entry Item
	LedgerGLLineItem	I_ActualPlanJournalEntryItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
	FinancialPlanningEntryItem	I_ActualPlanJournalEntryItem	FinancialPlanningEntryItem	Financial Planning Entry Item
	ControllingArea	I_ActualPlanJournalEntryItem	ControllingArea	Controlling Area
	LedgerFiscalYear	I_ActualPlanJournalEntryItem	LedgerFiscalYear	Fiscal Year of Ledger
	GLAccount	I_ActualPlanJournalEntryItem	GLAccount	General Ledger
	ChartOfAccounts	I_ActualPlanJournalEntryItem	ChartOfAccounts	Chart of Accounts
	ActualPlanCode	I_ActualPlanJournalEntryItem	ActualPlanCode	Actual Plan Code
	DebitCreditCode	I_ActualPlanJournalEntryItem	DebitCreditCode	Single-Character Flag
	ProfitCenter	I_ActualPlanJournalEntryItem	ProfitCenter	Profit Center
	CostCenter	I_ActualPlanJournalEntryItem	CostCenter	Cost Center
	ProjectExternalID	I_ActualPlanJournalEntryItem	ProjectExternalID	Project External ID
	PartnerProjectInternalID	I_ActualPlanJournalEntryItem	PartnerProjectInternalID	Partner Project Internal ID
	PartnerProjectExternalID	I_ActualPlanJournalEntryItem	PartnerProjectExternalID	Partner Project External ID
	WBSElementExternalID	I_ActualPlanJournalEntryItem	WBSElementExternalID	WBS Element External ID
	PartnerWBSElementExternalID	I_ActualPlanJournalEntryItem	PartnerWBSElementExternalID	Partner WBS Element External ID
	FunctionalArea	I_ActualPlanJournalEntryItem	FunctionalArea	Sendr Fctl Area
	Segment	I_ActualPlanJournalEntryItem	Segment	Segment for Segmental Reporting
	CostCtrActivityType	I_ActualPlanJournalEntryItem	CostCtrActivityType	Activity Type
	CostAnalysisResource	I_ActualPlanJournalEntryItem	CostAnalysisResource	Cost Analysis Resource
	OrderID	I_ActualPlanJournalEntryItem	OrderID	Order ID
	WorkPackage	I_ActualPlanJournalEntryItem	WorkPackage	Plan Item
	PartnerAccountAssignmentType	I_ActualPlanJournalEntryItem	PartnerAccountAssignmentType	Partner Account Assignment Type
	PartnerCompanyCode	I_ActualPlanJournalEntryItem	PartnerCompanyCode	Partner Company Code
	PartnerProfitCenter	I_ActualPlanJournalEntryItem	PartnerProfitCenter	Partner Profit Center
	PartnerCostCenter	I_ActualPlanJournalEntryItem	PartnerCostCenter	Partner Cost Center
	PartnerFunctionalArea	I_ActualPlanJournalEntryItem	PartnerFunctionalArea	Partner Functional Area
	PartnerSegment	I_ActualPlanJournalEntryItem	PartnerSegment	Partner Segment for Segmental Reporting
	PartnerCostCtrActivityType	I_ActualPlanJournalEntryItem	PartnerCostCtrActivityType	Partner Cost Center Activity Type
	PartnerOrder	I_ActualPlanJournalEntryItem	PartnerOrder_2	Partner Order
	PostingDate	I_ActualPlanJournalEntryItem	PostingDate	Posting Date for GR
	DocumentDate	I_ActualPlanJournalEntryItem	DocumentDate	Journal Entry Date
	FiscalPeriod	I_ActualPlanJournalEntryItem	FiscalPeriod	Fiscal Period
	FiscalYearPeriod	I_ActualPlanJournalEntryItem	FiscalYearPeriod	Fiscal Year Period
	FiscalYearVariant	I_ActualPlanJournalEntryItem	FiscalYearVariant	Fiscal Year Variant
	PlanningCategory	I_ActualPlanJournalEntryItem	PlanningCategory	Plan Category
	ServicesRenderedDate	I_ActualPlanJournalEntryItem	ServicesRenderedDate	Date on which services are rendered
	AccountAssignmentType	I_ActualPlanJournalEntryItem	AccountAssignmentType	Account Assignment Type
	BusinessTransactionCategory	I_ActualPlanJournalEntryItem	BusinessTransactionCategory	Business Transaction Category
	BusinessTransactionType	I_ActualPlanJournalEntryItem	BusinessTransactionType	Business Transaction Type
	FinancialTransactionType	I_ActualPlanJournalEntryItem	FinancialTransactionType	Financial Transaction Type
	Customer	I_ActualPlanJournalEntryItem	Customer	Customer Number
	Supplier	I_ActualPlanJournalEntryItem	Supplier	Supplier
	IsStatisticalCostCenter	I_ActualPlanJournalEntryItem	IsStatisticalCostCenter	Indicator: Cost Center is Statistical Account Assignment
	IsCommitment	I_ActualPlanJournalEntryItem	IsCommitment	Indicator: Is Commitment
	TransactionCurrency	I_ActualPlanJournalEntryItem	TransactionCurrency	Transaction Currency
	CompanyCodeCurrency	I_ActualPlanJournalEntryItem	CompanyCodeCurrency	Company Code Currency
	GlobalCurrency	I_ActualPlanJournalEntryItem	GlobalCurrency	GM Billing Element: Global Currency
	FunctionalCurrency	I_ActualPlanJournalEntryItem	FunctionalCurrency	Functional Currency
	FreeDefinedCurrency1	I_ActualPlanJournalEntryItem	FreeDefinedCurrency1	Freely Defined Currency 1
	CostSourceUnit	I_ActualPlanJournalEntryItem	CostSourceUnit	Cost Source Unit
	AmountInTransactionCurrency	I_ActualPlanJournalEntryItem	AmountInTransactionCurrency	Amount in Transaction Currency
	AmountInCompanyCodeCurrency	I_ActualPlanJournalEntryItem	AmountInCompanyCodeCurrency	Amount in Company Code Currency
	AmountInGlobalCurrency	I_ActualPlanJournalEntryItem	AmountInGlobalCurrency	Amount in Global Currency
	AmountInFunctionalCurrency	I_ActualPlanJournalEntryItem	AmountInFunctionalCurrency	Amount in Functional Currency
	AmountInFreeDefinedCurrency1	I_ActualPlanJournalEntryItem	AmountInFreeDefinedCurrency1	Amount in Freely Defined Currency 1
	FixedAmountInGlobalCrcy	I_ActualPlanJournalEntryItem	FixedAmountInGlobalCrcy	Fixed Amount in Global Currency
	FixedAmountInCoCodeCrcy	I_ActualPlanJournalEntryItem	FixedAmountInCoCodeCrcy	Fixed Amount in Company Currency
	FixedAmountInTransCrcy	I_ActualPlanJournalEntryItem	FixedAmountInTransCrcy	Fixed Amount in Transaction Currency
	ValuationQuantity	I_ActualPlanJournalEntryItem	ValuationQuantity	Valuation Quantity
	ValuationFixedQuantity	I_ActualPlanJournalEntryItem	ValuationFixedQuantity	Valuation Fixed Quantity
	BaseUnit	I_ActualPlanJournalEntryItem	BaseUnit	Base Unit of Measure
	Quantity	I_ActualPlanJournalEntryItem	Quantity	Quantity
	FixedQuantity	I_ActualPlanJournalEntryItem	FixedQuantity	Fixed Quantity
	ActualAmountInTransactionCrcy	I_ActualPlanJournalEntryItem	ActualAmountInTransactionCrcy	Actual Amount in Transaction Currency
	ActualAmountInCompanyCodeCrcy	I_ActualPlanJournalEntryItem	ActualAmountInCompanyCodeCrcy	Actual Amount in Company Code Currency
	ActualAmountInGlobalCurrency	I_ActualPlanJournalEntryItem	ActualAmountInGlobalCurrency	Actual Amount in Global Currency
	ActualAmountInFreeDfndCrcy1	I_ActualPlanJournalEntryItem	ActualAmountInFreeDfndCrcy1	Actual Amount in Freely Defined Currency 1
	ActualValuationQuantity	I_ActualPlanJournalEntryItem	ActualValuationQuantity	Actual Valuation Quantity
	ActualQuantityInBaseUnit	I_ActualPlanJournalEntryItem	ActualQuantityInBaseUnit	Actual Quantity in Base Unit
	PlanAmountInTransactionCrcy	I_ActualPlanJournalEntryItem	PlanAmountInTransactionCrcy	Plan Amount in Transaction Currency
	PlanAmountInCompanyCodeCrcy	I_ActualPlanJournalEntryItem	PlanAmountInCompanyCodeCrcy	Plan Amount in Company Code Currency
	PlanAmountInGlobalCurrency	I_ActualPlanJournalEntryItem	PlanAmountInGlobalCurrency	Plan Amount in Global Currency
	PlanAmountInFreeDefinedCrcy1	I_ActualPlanJournalEntryItem	PlanAmountInFreeDefinedCrcy1	Plan Amount in Freely Defined Currency 1
	PlanValuationQuantity	I_ActualPlanJournalEntryItem	PlanValuationQuantity	Plan Valuation Quantity
	PlanPriceInGlobalCurrency	I_ActualPlanJournalEntryItem	PlanPriceInGlobalCurrency	Price in Global Currency
	PlanPriceInCompanyCodeCurrency	I_ActualPlanJournalEntryItem	PlanPriceInCompanyCodeCurrency	Price in Company Code Currency
	PlanPriceInTransactionCurrency	I_ActualPlanJournalEntryItem	PlanPriceInTransactionCurrency	Price in Transaction Currency
	ActlPlnDiffAmtInTransCrcy	I_ActualPlanJournalEntryItem	ActlPlnDiffAmtInTransCrcy	Actual plan difference in transaction currency
	ActlPlnDiffAmtInCoCodeCrcy	I_ActualPlanJournalEntryItem	ActlPlnDiffAmtInCoCodeCrcy	Actual plan difference in company code currency
	ActlPlnDiffAmtInGlobalCrcy	I_ActualPlanJournalEntryItem	ActlPlnDiffAmtInGlobalCrcy	Actual plan difference in global currency
	ActlPlnDiffAmtInFreeDfndCrcy1	I_ActualPlanJournalEntryItem	ActlPlnDiffAmtInFreeDfndCrcy1	Actual plan difference in freely defined currency 1
	ActlPanDiffValuationQuantity	I_ActualPlanJournalEntryItem	ActlPanDiffValuationQuantity	Actual Plan Difference Valuation Quantity
	CalendarYear			Calendar Year
	CalendarQuarter			Calendar Quarter
	YearQuarter			Year Quarter
	CalendarMonth			Calendar Month
	YearMonth			Year Month
	CalendarWeek			Calendar Week
	YearWeek			Year Week
	FiscalQuarter			Fiscal Quarter
	FiscalWeek			Fiscal Week
	FiscalYearQuarter			Fiscal Year + Fiscal Quarter
	FiscalYearWeek			Fiscal Year + Fiscal Week
	_JournalEntry	I_ActualPlanJournalEntryItem	_JournalEntry
	_SourceLedger	I_ActualPlanJournalEntryItem	_SourceLedger
	_ControllingArea	I_ActualPlanJournalEntryItem	_ControllingArea
	_Ledger	I_ActualPlanJournalEntryItem	_Ledger
	_CompanyCode	I_ActualPlanJournalEntryItem	_CompanyCode
	_GLAccountInChartOfAccounts	I_ActualPlanJournalEntryItem	_GLAccountInChartOfAccounts
	_ChartOfAccounts	I_ActualPlanJournalEntryItem	_ChartOfAccounts
	_LedgerFiscalYearForVariant	I_ActualPlanJournalEntryItem	_LedgerFiscalYearForVariant
	_FiscalYear	I_ActualPlanJournalEntryItem	_FiscalYear
	_FiscalPeriodForVariant	I_ActualPlanJournalEntryItem	_FiscalPeriodForVariant
	_FiscalYearPeriodForVariant	I_ActualPlanJournalEntryItem	_FiscalYearPeriodForVariant
	_DebitCreditCode	I_ActualPlanJournalEntryItem	_DebitCreditCode
	_CalendarDate	I_ActualPlanJournalEntryItem	_CalendarDate
	_FiscalCalendarDate	I_ActualPlanJournalEntryItem	_FiscalCalendarDate
	_ProfitCenter	I_ActualPlanJournalEntryItem	_ProfitCenter
	_CostCenter	I_ActualPlanJournalEntryItem	_CostCenter
	_AccountAssignmentType	I_ActualPlanJournalEntryItem	_AccountAssignmentType
	_ProjectExternalID	I_ActualPlanJournalEntryItem	_ProjectExternalID
	_PartnerProjectBasicData	I_ActualPlanJournalEntryItem	_PartnerProjectBasicData
	_PartnerProjectExternalID	I_ActualPlanJournalEntryItem	_PartnerProjectExternalID
	_WBSElementExternalID	I_ActualPlanJournalEntryItem	_WBSElementExternalID
	_PartnerWBSElementExternalID	I_ActualPlanJournalEntryItem	_PartnerWBSElementExternalID
	_FunctionalArea	I_ActualPlanJournalEntryItem	_FunctionalArea
	_Segment	I_ActualPlanJournalEntryItem	_Segment
	_CostCtrActivityType	I_ActualPlanJournalEntryItem	_CostCtrActivityType
	_CostAnalysisResource	I_ActualPlanJournalEntryItem	_CostAnalysisResource
	_Order	I_ActualPlanJournalEntryItem	_Order
	_WorkPackage	I_ActualPlanJournalEntryItem	_WorkPackage
	_PartnerCompanyCode	I_ActualPlanJournalEntryItem	_PartnerCompanyCode
	_PartnerProfitCenter	I_ActualPlanJournalEntryItem	_PartnerProfitCenter
	_PartnerCostCenter	I_ActualPlanJournalEntryItem	_PartnerCostCenter
	_PartnerFunctionalArea	I_ActualPlanJournalEntryItem	_PartnerFunctionalArea
	_PartnerSegment	I_ActualPlanJournalEntryItem	_PartnerSegment
	_PartnerCostCtrActivityType	I_ActualPlanJournalEntryItem	_PartnerCostCtrActivityType
	_PartnerOrder_2	I_ActualPlanJournalEntryItem	_PartnerOrder_2
	_FiscalYearVariant	I_ActualPlanJournalEntryItem	_FiscalYearVariant
	_BusinessTransactionCategory	I_ActualPlanJournalEntryItem	_BusinessTransactionCategory
	_BusinessTransactionType	I_ActualPlanJournalEntryItem	_BusinessTransactionType
	_FinancialTransactionType	I_ActualPlanJournalEntryItem	_FinancialTransactionType
	_Customer	I_ActualPlanJournalEntryItem	_Customer
	_Supplier	I_ActualPlanJournalEntryItem	_Supplier
	_TransactionCurrency	I_ActualPlanJournalEntryItem	_TransactionCurrency
	_CompanyCodeCurrency	I_ActualPlanJournalEntryItem	_CompanyCodeCurrency
	_GlobalCurrency	I_ActualPlanJournalEntryItem	_GlobalCurrency
	_FunctionalCurrency	I_ActualPlanJournalEntryItem	_FunctionalCurrency
	_FreeDefinedCurrency1	I_ActualPlanJournalEntryItem	_FreeDefinedCurrency1
	_BaseUnit	I_ActualPlanJournalEntryItem	_BaseUnit
	_CostSourceUnit	I_ActualPlanJournalEntryItem	_CostSourceUnit
	_PlanningCategory	I_ActualPlanJournalEntryItem	_PlanningCategory
	_CalendarMonth		_CalendarMonth
	_CalendarQuarter		_CalendarQuarter
	_CalendarYearMonth		_CalendarYearMonth
	_CurrentCostCenter		_CurrentCostCenter
	_CurrentProfitCenter		_CurrentProfitCenter

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ActPlnCostCenterRptgCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_ActPlnCostCenterRptgCube AS
SELECT
  APJEI.SourceLedger AS SourceLedger,
  APJEI.Ledger AS Ledger,
  APJEI.CompanyCode AS CompanyCode,
  APJEI.FiscalYear AS FiscalYear,
  APJEI.AccountingDocument AS AccountingDocument,
  APJEI.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  APJEI.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  APJEI.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  APJEI.LedgerGLLineItem AS LedgerGLLineItem,
  APJEI.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  APJEI.ControllingArea AS ControllingArea,
  APJEI.LedgerFiscalYear AS LedgerFiscalYear,
  APJEI.GLAccount AS GLAccount,
  APJEI.ChartOfAccounts AS ChartOfAccounts,
  APJEI.ActualPlanCode AS ActualPlanCode,
  APJEI.DebitCreditCode AS DebitCreditCode,
  APJEI.ProfitCenter AS ProfitCenter,
  APJEI.CostCenter AS CostCenter,
  APJEI.ProjectExternalID AS ProjectExternalID,
  APJEI.PartnerProjectInternalID AS PartnerProjectInternalID,
  APJEI.PartnerProjectExternalID AS PartnerProjectExternalID,
  APJEI.WBSElementExternalID AS WBSElementExternalID,
  APJEI.PartnerWBSElementExternalID AS PartnerWBSElementExternalID,
  APJEI.FunctionalArea AS FunctionalArea,
  APJEI.Segment AS Segment,
  APJEI.CostCtrActivityType AS CostCtrActivityType,
  APJEI.CostAnalysisResource AS CostAnalysisResource,
  APJEI.OrderID AS OrderID,
  APJEI.WorkPackage AS WorkPackage,
  APJEI.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  APJEI.PartnerCompanyCode AS PartnerCompanyCode,
  APJEI.PartnerProfitCenter AS PartnerProfitCenter,
  APJEI.PartnerCostCenter AS PartnerCostCenter,
  APJEI.PartnerFunctionalArea AS PartnerFunctionalArea,
  APJEI.PartnerSegment AS PartnerSegment,
  APJEI.PartnerCostCtrActivityType AS PartnerCostCtrActivityType,
  APJEI.PartnerOrder_2 AS PartnerOrder,
  APJEI.PostingDate AS PostingDate,
  APJEI.DocumentDate AS DocumentDate,
  APJEI.FiscalPeriod AS FiscalPeriod,
  APJEI.FiscalYearPeriod AS FiscalYearPeriod,
  APJEI.FiscalYearVariant AS FiscalYearVariant,
  APJEI.PlanningCategory AS PlanningCategory,
  APJEI.ServicesRenderedDate AS ServicesRenderedDate,
  APJEI.AccountAssignmentType AS AccountAssignmentType,
  APJEI.BusinessTransactionCategory AS BusinessTransactionCategory,
  APJEI.BusinessTransactionType AS BusinessTransactionType,
  APJEI.FinancialTransactionType AS FinancialTransactionType,
  APJEI.Customer AS Customer,
  APJEI.Supplier AS Supplier,
  APJEI.IsStatisticalCostCenter AS IsStatisticalCostCenter,
  APJEI.IsCommitment AS IsCommitment,
  APJEI.TransactionCurrency AS TransactionCurrency,
  APJEI.CompanyCodeCurrency AS CompanyCodeCurrency,
  APJEI.GlobalCurrency AS GlobalCurrency,
  APJEI.FunctionalCurrency AS FunctionalCurrency,
  APJEI.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  APJEI.CostSourceUnit AS CostSourceUnit,
  APJEI.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  APJEI.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  APJEI.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  APJEI.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  APJEI.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  APJEI.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  APJEI.FixedAmountInCoCodeCrcy AS FixedAmountInCoCodeCrcy,
  APJEI.FixedAmountInTransCrcy AS FixedAmountInTransCrcy,
  APJEI.ValuationQuantity AS ValuationQuantity,
  APJEI.ValuationFixedQuantity AS ValuationFixedQuantity,
  APJEI.BaseUnit AS BaseUnit,
  APJEI.Quantity AS Quantity,
  APJEI.FixedQuantity AS FixedQuantity,
  APJEI.ActualAmountInTransactionCrcy AS ActualAmountInTransactionCrcy,
  APJEI.ActualAmountInCompanyCodeCrcy AS ActualAmountInCompanyCodeCrcy,
  APJEI.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  APJEI.ActualAmountInFreeDfndCrcy1 AS ActualAmountInFreeDfndCrcy1,
  APJEI.ActualValuationQuantity AS ActualValuationQuantity,
  APJEI.ActualQuantityInBaseUnit AS ActualQuantityInBaseUnit,
  APJEI.PlanAmountInTransactionCrcy AS PlanAmountInTransactionCrcy,
  APJEI.PlanAmountInCompanyCodeCrcy AS PlanAmountInCompanyCodeCrcy,
  APJEI.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  APJEI.PlanAmountInFreeDefinedCrcy1 AS PlanAmountInFreeDefinedCrcy1,
  APJEI.PlanValuationQuantity AS PlanValuationQuantity,
  APJEI.PlanPriceInGlobalCurrency AS PlanPriceInGlobalCurrency,
  APJEI.PlanPriceInCompanyCodeCurrency AS PlanPriceInCompanyCodeCurrency,
  APJEI.PlanPriceInTransactionCurrency AS PlanPriceInTransactionCurrency,
  APJEI.ActlPlnDiffAmtInTransCrcy AS ActlPlnDiffAmtInTransCrcy,
  APJEI.ActlPlnDiffAmtInCoCodeCrcy AS ActlPlnDiffAmtInCoCodeCrcy,
  APJEI.ActlPlnDiffAmtInGlobalCrcy AS ActlPlnDiffAmtInGlobalCrcy,
  APJEI.ActlPlnDiffAmtInFreeDfndCrcy1 AS ActlPlnDiffAmtInFreeDfndCrcy1,
  APJEI.ActlPanDiffValuationQuantity AS ActlPanDiffValuationQuantity,
  APJEI._CalendarDate.CalendarYear AS CalendarYear,
  APJEI._CalendarDate.CalendarQuarter AS CalendarQuarter,
  APJEI._CalendarDate.YearQuarter AS YearQuarter,
  APJEI._CalendarDate.CalendarMonth AS CalendarMonth,
  APJEI._CalendarDate.YearMonth AS YearMonth,
  APJEI._CalendarDate.CalendarWeek AS CalendarWeek,
  APJEI._CalendarDate.YearWeek AS YearWeek,
  APJEI._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  APJEI._FiscalCalendarDate.FiscalWeek AS FiscalWeek,
  APJEI._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  APJEI._FiscalCalendarDate.FiscalYearWeek AS FiscalYearWeek,
  APJEI._JournalEntry AS _JournalEntry,
  APJEI._SourceLedger AS _SourceLedger,
  APJEI._ControllingArea AS _ControllingArea,
  APJEI._Ledger AS _Ledger,
  APJEI._CompanyCode AS _CompanyCode,
  APJEI._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  APJEI._ChartOfAccounts AS _ChartOfAccounts,
  APJEI._LedgerFiscalYearForVariant AS _LedgerFiscalYearForVariant,
  APJEI._FiscalYear AS _FiscalYear,
  APJEI._FiscalPeriodForVariant AS _FiscalPeriodForVariant,
  APJEI._FiscalYearPeriodForVariant AS _FiscalYearPeriodForVariant,
  APJEI._DebitCreditCode AS _DebitCreditCode,
  APJEI._CalendarDate AS _CalendarDate,
  APJEI._FiscalCalendarDate AS _FiscalCalendarDate,
  APJEI._ProfitCenter AS _ProfitCenter,
  APJEI._CostCenter AS _CostCenter,
  APJEI._AccountAssignmentType AS _AccountAssignmentType,
  APJEI._ProjectExternalID AS _ProjectExternalID,
  APJEI._PartnerProjectBasicData AS _PartnerProjectBasicData,
  APJEI._PartnerProjectExternalID AS _PartnerProjectExternalID,
  APJEI._WBSElementExternalID AS _WBSElementExternalID,
  APJEI._PartnerWBSElementExternalID AS _PartnerWBSElementExternalID,
  APJEI._FunctionalArea AS _FunctionalArea,
  APJEI._Segment AS _Segment,
  APJEI._CostCtrActivityType AS _CostCtrActivityType,
  APJEI._CostAnalysisResource AS _CostAnalysisResource,
  APJEI._Order AS _Order,
  APJEI._WorkPackage AS _WorkPackage,
  APJEI._PartnerCompanyCode AS _PartnerCompanyCode,
  APJEI._PartnerProfitCenter AS _PartnerProfitCenter,
  APJEI._PartnerCostCenter AS _PartnerCostCenter,
  APJEI._PartnerFunctionalArea AS _PartnerFunctionalArea,
  APJEI._PartnerSegment AS _PartnerSegment,
  APJEI._PartnerCostCtrActivityType AS _PartnerCostCtrActivityType,
  APJEI._PartnerOrder_2 AS _PartnerOrder_2,
  APJEI._FiscalYearVariant AS _FiscalYearVariant,
  APJEI._BusinessTransactionCategory AS _BusinessTransactionCategory,
  APJEI._BusinessTransactionType AS _BusinessTransactionType,
  APJEI._FinancialTransactionType AS _FinancialTransactionType,
  APJEI._Customer AS _Customer,
  APJEI._Supplier AS _Supplier,
  APJEI._TransactionCurrency AS _TransactionCurrency,
  APJEI._CompanyCodeCurrency AS _CompanyCodeCurrency,
  APJEI._GlobalCurrency AS _GlobalCurrency,
  APJEI._FunctionalCurrency AS _FunctionalCurrency,
  APJEI._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  APJEI._BaseUnit AS _BaseUnit,
  APJEI._CostSourceUnit AS _CostSourceUnit,
  APJEI._PlanningCategory AS _PlanningCategory
FROM I_ActualPlanJournalEntryItem AS APJEI
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_CalendarQuarter AS _CalendarQuarter ON CalendarQuarter = _CalendarQuarter.CalendarQuarter  -- association [1..1]
LEFT OUTER JOIN I_YearMonth AS _CalendarYearMonth ON YearMonth = _CalendarYearMonth.YearMonth  -- association [1..1]
LEFT OUTER JOIN E_FinancialPlanningEntryItem AS _Extension_acdocp ON APJEI.FinancialPlanningReqTransSqnc = _Extension_acdocp.FinancialPlanningReqTransSqnc AND APJEI.FinancialPlanningDataPacket = _Extension_acdocp.FinancialPlanningDataPacket AND APJEI.FinancialPlanningEntryItem = _Extension_acdocp.FinancialPlanningEntryItem  -- association [1..1]
;

Depth:

I_ActPlnCostCenterRptgCube view_entity

I_ActualPlanJournalEntryItem view_entity