What is I_ProfitabilityCube in SAP S/4HANA?

I_ProfitabilityCube is a composite CDS view in SAP S/4HANA. G/L Account Line Item of Profitability - Cube It contains 116 fields.

Which tables does I_ProfitabilityCube read from?

I_ProfitabilityCube reads data from: P_SemTagAndSubLedgerItem.

What VDM layer is I_ProfitabilityCube?

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

I_ProfitabilityCube

DDL: I_PROFITABILITYCUBE Type: view COMPOSITE

116 Fields 1 Data Sources 3 Associations

G/L Account Line Item of Profitability - Cube

I_ProfitabilityCube (Composite)

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

Accounting and Financial Close

I_ProfitabilityCube is a Composite CDS View (Cube) that provides data about "G/L Account Line Item of Profitability - Cube" in SAP S/4HANA. It reads from 1 data source (P_SemTagAndSubLedgerItem) and exposes 116 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. It has 3 associations to related views.

SAP Help Documentation

Category	CDS Views for Sales Accounting
Status	Released

Purpose
This CDS view provides the line item data from sales accounting with various dimensions of the journal entry. SAP also provides some predefined key figures such as BilledRevenueAmt , RevenueAdjustAmt , VarblCOGSAmt , ContrbnMargin1Amt , and so on. All of these key figures are listed in both global currency and company code currency. This CDS view provides the data to answer the following business questions: What is the profitability of products considering production variances? How do production variances impact the contribution margins of products? What are the revenue and cost figures for products in both global and company code currencies? How do different dimensions such as company code, fiscal year, and product group affect product profitability? What are the detailed components of price differences, such as input price variance and resource usage variance? How do sales deductions and revenue adjustments affect recognized revenue? What is the contribution margin per unit for products in global currency? How does the profitability of products vary across different sales organizations and customer groups? What is the margin percentage in global currency relative to recognized revenue? 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 .

Structure
Main CDS Parameters and Filters The default financial statement version (FSV) is YPS2 . Fields Used for Filtering The main filters are as follows: FSV Company Code Product Sold Group Customer Group Sales Organization Measures and Attributes Some important measures and attributes are: Billed Revenue Sales Deduction Revenue Adjustment Recognized Revenue COGS - Variable Contribution Margin I COGS – Fixed Price Differences Contribution Margin II Margin in Percentage

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	CO-FIO-PA
Capabilities	Data Provider for Analytical Queries, Data Source in SQL Select, Data Source for Defining CDS Entities
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition

Documentation

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

Data Sources (1)

Source	Alias	Join Type
P_SemTagAndSubLedgerItem	P_SemTagAndSubLedgerItem	from

Parameters (1)

Name	Type	Default
P_GLAccountHierarchy	fins_sem_tag_hryid

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_Division	_OrganizationDivision	`$projection.OrganizationDivision = _OrganizationDivision.Division`
[0..1]	I_CustomerSupplierIndustry	_CustomerSupplierIndustry	`$projection.CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry`
[1..1]	E_JournalEntryItem	_Extension	`$projection.SourceLedger = _Extension.SourceLedger and $projection.CompanyCode = _Extension.CompanyCode and $projection.FiscalYear = _Extension.FiscalYear and $projection.AccountingDocument = _Extension.AccountingDocument and $projection.LedgerGLLineItem = _Extension.LedgerGLLineItem`

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	IPROFITABIC	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
Analytics.dataCategory	#CUBE	view
Analytics.internalName	#LOCAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	LedgerGLLineItem	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
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view
EndUserText.label	G/L Account Line Item of Profitability - Cube	view

Fields (116)

Key	Field	Source Field	Description
KEY	Ledger	Ledger	Ledger in General Ledger Accounting
KEY	SourceLedger	SourceLedger	Source Ledger
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	FiscalYear	FiscalYear	G/L Fiscal Year
KEY	AccountingDocument	AccountingDocument	Journal Entry
KEY	LedgerGLLineItem	LedgerGLLineItem	General Ledger Journal Entry Line Item
KEY	SemanticTag	SemanticTag	Semantic Tag of a Hierarchy Node
	FiscalPeriod	FiscalPeriod	Fiscal Period
	ProfitCenter	ProfitCenter	Profit Center
	SoldProduct	SoldProduct	Product Sold
	SoldProductGroup	SoldProductGroup	Product Sold Group
	Customer	Customer	Customer Number
	CustomerGroup	CustomerGroup	Customer Group
	SalesDocument	SalesDocument	Sales Document
	SalesDocumentItem	SalesDocumentItem	Sales Document Item
	OrderID	OrderID	Order ID
	OrderCategory	OrderCategory	Order Category
	ChartOfAccounts	ChartOfAccounts	Chart of Accounts
	GLAccount	GLAccount	General Ledger
	SalesOrganization	SalesOrganization	Sales Organization
	CustomerSupplierCountry	CustomerSupplierCountry	Customer or Supplier Country/Region
	CustomerSupplierIndustry	CustomerSupplierIndustry	Customer Supplier Industry
	SalesDistrict	SalesDistrict	Sales District
	ShipToParty	ShipToParty	Ship-To Party (obsolete)
	BillToParty	BillToParty	Inv. Recipient
	ControllingArea	ControllingArea	Controlling Area
	DistributionChannel	DistributionChannel	Distribution Channel
	OrganizationDivision	OrganizationDivision	Org. Division
	BaseUnit	BaseUnit	Base Unit of Measure
	OrderType	OrderType	Order Type
	Segment	Segment	Segment for Segmental Reporting
	Project	Project	WBS Element
	WBSElement	WBSElement	WBS Internal ID
	ProjectNetwork	ProjectNetwork	Network Number for Account Assignment
	FunctionalArea	FunctionalArea	Sendr Fctl Area
	Plant	Plant	Valuation Area
	LineIsSemTagCalculated	LineIsSemTagCalculated	Indicator: Calculated by Semantic Tag
	CompanyCodeCurrency	CompanyCodeCurrency	Company Code Currency
	GlobalCurrency	GlobalCurrency	GM Billing Element: Global Currency
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Amount in Company Code Currency
	AmountInGlobalCurrency	AmountInGlobalCurrency	Amount in Global Currency
	BilledRevenueAmtInGlobCrcy	BilledRevenueAmtInGlobCrcy	Actual Revenue
	SalesDeductionAmountInGlobCrcy	SalesDeductionAmountInGlobCrcy	Sales Deduction
	RevenueAdjustAmtInGlobCrcy	RevenueAdjustAmtInGlobCrcy	Revenue Adjustment
	RecognizedRevnAmtInGlobCrcy	RecognizedRevnAmtInGlobCrcy	Recognized Revenue
	VarblCOGSAmtInGlobCrcy	VarblCOGSAmtInGlobCrcy	Cost of Goods Sold - Variable
	ContrbnMargin1AmtInGlobCrcy	ContrbnMargin1AmtInGlobCrcy	Contribution Margin I
	FxdCOGSAmtInGlobCrcy	FxdCOGSAmtInGlobCrcy	Cost of Goods Sold - Fixed
	PriceDifferenceAmtInGlobCrcy	PriceDifferenceAmtInGlobCrcy	Price Differences
	ContrbnMargin2AmtInGlobCrcy	ContrbnMargin2AmtInGlobCrcy	Contribution Margin II
	AdminOverheadAmtInGlobCrcy	AdminOverheadAmtInGlobCrcy	Administration Overhead
	SalesOverheadAmtInGlobCrcy	SalesOverheadAmtInGlobCrcy	Sales Overhead
	MarketingOverheadAmtInGlobCrcy	MarketingOverheadAmtInGlobCrcy	Marketing Overhead
	RnDOverheadAmtInGlobCrcy	RnDOverheadAmtInGlobCrcy	Research and Development Overhead
	ContrbnMargin3AmtInGlobCrcy	ContrbnMargin3AmtInGlobCrcy	Contribution Margin III
	InptPriceVarcAmtInGlobCrcy	InptPriceVarcAmtInGlobCrcy	Input Price Variance Amount in Global Currency
	OutpPriceVarcAmtInGlobCrcy	OutpPriceVarcAmtInGlobCrcy	Output Price Variance Amount in Global Currency
	InptQtyVarcAmtInGlobCrcy	InptQtyVarcAmtInGlobCrcy	Input Quantity Variance Amount in Global Currency
	RsceUsgeVarcAmtInGlobCrcy	RsceUsgeVarcAmtInGlobCrcy	Resource Usage Variance Amount in Global Currency
	LotSizeVarcAmtInGlobCrcy	LotSizeVarcAmtInGlobCrcy	Lot Size Variance Amount in Global Currency
	InputRmngVarcAmtInGlobCrcy	InputRmngVarcAmtInGlobCrcy	Remaining Variance Amount in Global Currency
	ScrapVarcAmtInGlobCrcy	ScrapVarcAmtInGlobCrcy	Scrap Variance Amount in Global Currency
	MixedPrcVarcAmtInGlobCrcy	MixedPrcVarcAmtInGlobCrcy	Mixed Price Variance Amount in Global Currency
	BilledRevenueAmtInCoCodeCrcy	BilledRevenueAmtInCoCodeCrcy	Billed Revenue Amount in Company Code Currency
	SalesDeductionAmtInCoCodeCrcy	SalesDeductionAmtInCoCodeCrcy	Sales Deduction Amount in Company Code Currency
	RevenueAdjustmentAmtInCCCrcy	RevenueAdjustmentAmtInCCCrcy	Revenue Adjustment Amount in Company Code Currency
	RecognizedRevnAmtInCCCrcy	RecognizedRevnAmtInCCCrcy	Recognized Revenue Amount in Company Code Currency
	VarblCOGSAmtInCCCrcy	VarblCOGSAmtInCCCrcy	COGS - Variable Amount in Company Code Currency
	ContrbnMargin1AmtInCoCodeCrcy	ContrbnMargin1AmtInCoCodeCrcy	COGS - Contribution Margin 1 Amount in Company Code Currency
	FxdCOGSAmtInCCCrcy	FxdCOGSAmtInCCCrcy	COGS - Fixed Amount in Company Code Currency
	PriceDifferenceAmtInCCCrcy	PriceDifferenceAmtInCCCrcy	COGS - Price Differences Amount in Company Code Currency
	ContrbnMargin2AmtInCoCodeCrcy	ContrbnMargin2AmtInCoCodeCrcy	COGS - Contribution Margin 2 Amount in Company Code Currency
	AdminOverheadAmtInCoCodeCrcy	AdminOverheadAmtInCoCodeCrcy	COGS - Administration Overhead Amt in Company Code Currency
	SalesOverheadAmtInCoCodeCrcy	SalesOverheadAmtInCoCodeCrcy	COGS - Sales Overhead Amount in Company Code Currency
	MarketingOvhdAmtInCoCodeCrcy	MarketingOvhdAmtInCoCodeCrcy	COGS - Marketing Overhead Amount in Company Code Currency
	RnDOverheadAmtInCCCrcy	RnDOverheadAmtInCCCrcy	COGS - Research and Dev Overhead Amount in Company Code Crcy
	ContrbnMargin3AmtInCoCodeCrcy	ContrbnMargin3AmtInCoCodeCrcy	COGS - Contribution Margin 3 Amount in Company Code Currency
	InptPriceVarcAmtInCoCodeCrcy	InptPriceVarcAmtInCoCodeCrcy	Input Price Variance Amount in Company Code Currency
	InptQtyVarcAmtInCoCodeCrcy	InptQtyVarcAmtInCoCodeCrcy	Input Quantity Variance Amount in Company Code Currency
	OutpPrVarcAmtInCoCodeCrcy	OutpPrVarcAmtInCoCodeCrcy	Output Price Variance Amount in Company Code Currency
	RsceUsgeVarcAmtInCoCodeCrcy	RsceUsgeVarcAmtInCoCodeCrcy	Resource Usage Variance Amount in Company Code Currency
	LotSizeVarcAmtInCoCodeCrcy	LotSizeVarcAmtInCoCodeCrcy	Lot Size Variance Amount in Company Code Currency
	InputRmngVarcAmtInCoCodeCrcy	InputRmngVarcAmtInCoCodeCrcy	Remaining Variance Amount in Company Code Currency
	ScrapVarcAmtInCoCodeCrcy	ScrapVarcAmtInCoCodeCrcy	Scrap Variance Amount in Company Code Currency
	MixedPrcVarcAmtInCoCodeCrcy	MixedPrcVarcAmtInCoCodeCrcy	Mixed Price Variance Amount in Company Code Currency
	CostSourceUnit	CostSourceUnit	Cost Source Unit
	BilledValnQtyInCostSourceUnit	BilledValnQtyInCostSourceUnit	Billed Quantity
	_Ledger	_Ledger
	_SourceLedger	_SourceLedger
	_JournalEntry	_JournalEntry
	_CompanyCode	_CompanyCode
	_SemanticTag	_SemanticTag
	_FiscalYear	_FiscalYear
	_Customer	_Customer
	_CustomerGroup	_CustomerGroup
	_SoldProduct	_SoldProduct
	_SoldProductGroup	_SoldProductGroup
	_ProfitCenter	_ProfitCenter
	_ControllingArea	_ControllingArea
	_CostSourceUnit	_CostSourceUnit
	_SalesDocument	_SalesDocument
	_Order	_Order
	_DistributionChannel	_DistributionChannel
	_BaseUnit	_BaseUnit
	_Segment	_Segment
	_ChartOfAccounts	_ChartOfAccounts
	_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts
	_FunctionalArea	_FunctionalArea
	_Plant	_Plant
	_SalesOrganization	_SalesOrganization
	_SalesDistrict	_SalesDistrict
	_CustomerSupplierCountry	_CustomerSupplierCountry
	_ShipToParty	_ShipToParty
	_BillToParty	_BillToParty
	_OrganizationDivision	_OrganizationDivision
	_CustomerSupplierIndustry	_CustomerSupplierIndustry

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_ProfitabilityCube.
-- 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.
-- Parameters: P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW I_ProfitabilityCube AS
SELECT
  Ledger,
  SourceLedger,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  SemanticTag,
  FiscalPeriod,
  ProfitCenter,
  SoldProduct,
  SoldProductGroup,
  Customer,
  CustomerGroup,
  SalesDocument,
  SalesDocumentItem,
  OrderID,
  OrderCategory,
  ChartOfAccounts,
  GLAccount,
  SalesOrganization,
  CustomerSupplierCountry,
  CustomerSupplierIndustry,
  SalesDistrict,
  ShipToParty,
  BillToParty,
  ControllingArea,
  DistributionChannel,
  OrganizationDivision,
  BaseUnit,
  OrderType,
  Segment,
  Project,
  WBSElement,
  ProjectNetwork,
  FunctionalArea,
  Plant,
  LineIsSemTagCalculated,
  CompanyCodeCurrency,
  GlobalCurrency,
  AmountInCompanyCodeCurrency,
  AmountInGlobalCurrency,
  BilledRevenueAmtInGlobCrcy,
  SalesDeductionAmountInGlobCrcy,
  RevenueAdjustAmtInGlobCrcy,
  RecognizedRevnAmtInGlobCrcy,
  VarblCOGSAmtInGlobCrcy,
  ContrbnMargin1AmtInGlobCrcy,
  FxdCOGSAmtInGlobCrcy,
  PriceDifferenceAmtInGlobCrcy,
  ContrbnMargin2AmtInGlobCrcy,
  AdminOverheadAmtInGlobCrcy,
  SalesOverheadAmtInGlobCrcy,
  MarketingOverheadAmtInGlobCrcy,
  RnDOverheadAmtInGlobCrcy,
  ContrbnMargin3AmtInGlobCrcy,
  InptPriceVarcAmtInGlobCrcy,
  OutpPriceVarcAmtInGlobCrcy,
  InptQtyVarcAmtInGlobCrcy,
  RsceUsgeVarcAmtInGlobCrcy,
  LotSizeVarcAmtInGlobCrcy,
  InputRmngVarcAmtInGlobCrcy,
  ScrapVarcAmtInGlobCrcy,
  MixedPrcVarcAmtInGlobCrcy,
  BilledRevenueAmtInCoCodeCrcy,
  SalesDeductionAmtInCoCodeCrcy,
  RevenueAdjustmentAmtInCCCrcy,
  RecognizedRevnAmtInCCCrcy,
  VarblCOGSAmtInCCCrcy,
  ContrbnMargin1AmtInCoCodeCrcy,
  FxdCOGSAmtInCCCrcy,
  PriceDifferenceAmtInCCCrcy,
  ContrbnMargin2AmtInCoCodeCrcy,
  AdminOverheadAmtInCoCodeCrcy,
  SalesOverheadAmtInCoCodeCrcy,
  MarketingOvhdAmtInCoCodeCrcy,
  RnDOverheadAmtInCCCrcy,
  ContrbnMargin3AmtInCoCodeCrcy,
  InptPriceVarcAmtInCoCodeCrcy,
  InptQtyVarcAmtInCoCodeCrcy,
  OutpPrVarcAmtInCoCodeCrcy,
  RsceUsgeVarcAmtInCoCodeCrcy,
  LotSizeVarcAmtInCoCodeCrcy,
  InputRmngVarcAmtInCoCodeCrcy,
  ScrapVarcAmtInCoCodeCrcy,
  MixedPrcVarcAmtInCoCodeCrcy,
  CostSourceUnit,
  BilledValnQtyInCostSourceUnit
FROM P_SemTagAndSubLedgerItem
LEFT OUTER JOIN I_Division AS _OrganizationDivision ON OrganizationDivision = _OrganizationDivision.Division  -- association [0..1]
LEFT OUTER JOIN I_CustomerSupplierIndustry AS _CustomerSupplierIndustry ON CustomerSupplierIndustry = _CustomerSupplierIndustry.Industry  -- association [0..1]
LEFT OUTER JOIN E_JournalEntryItem AS _Extension ON SourceLedger = _Extension.SourceLedger AND CompanyCode = _Extension.CompanyCode AND FiscalYear = _Extension.FiscalYear AND AccountingDocument = _Extension.AccountingDocument AND LedgerGLLineItem = _Extension.LedgerGLLineItem  -- association [1..1]
;

Depth:

I_ProfitabilityCube view

P_SemTagAndSubLedgerItem view

C_ProductProfitabilityQuery view