C_Profitability_Q0002

DDL: C_PROFITABILITY_Q0002 SQL: CFIPROFQ0002 Type: view CONSUMPTION Package: FINS_COPA_REPORTING
20 Fields 1 Data Sources

Product Profitability

C_Profitability_Q0002 (Consumption)

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

Accounting and Financial Close

C_Profitability_Q0002 is a Consumption CDS View that provides data about "Product Profitability" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItemSemTag) and exposes 20 fields. Part of development package FINS_COPA_REPORTING.

SAP API Hub

CategoryConsumption
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-FIO-PA-2CL
CapabilitiesAnalytical Query
Extensible (Key User)Yes
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business question:</p> <p>What is the contribution margin for individual products?</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItemSemTag I_GLAccountLineItemSemTag from

Parameters (1)

NameTypeDefault
P_GLAccountHierarchy fins_sem_tag_hryid

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFIPROFQ0002 view
Analytics.query true view
VDM.viewType #CONSUMPTION view
OData.publish true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Product Profitability view
Metadata.allowExtensions true view
Analytics.settings.maxProcessingEffort #HIGH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
multipleSelectionstrue
mandatoryfalseCompanyCode
resultElementLedger
multipleSelectionsfalse
mandatoryfalseLedger
multipleSelectionstrue
mandatoryfalseFiscalYear
multipleSelectionstrue
mandatoryfalseFiscalPeriod
multipleSelectionstrue
mandatoryfalseProfitCenterSoldProduct
multipleSelectionstrue
mandatoryfalseSoldProductGroup
multipleSelectionstrue
mandatoryfalseProductGroupCustomer
multipleSelectionstrue
mandatoryfalseCustomerGroup
multipleSelectionstrue
mandatoryfalseSalesOrderSalesOrderItem
multipleSelectionstrue

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 C_Profitability_Q0002.
-- 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.
-- SQL view name: CFIPROFQ0002
-- Parameters: P_GLAccountHierarchy : fins_sem_tag_hryid

CREATE VIEW C_Profitability_Q0002 AS
SELECT
  multipleSelections: true AS multipleSelectionstrue,
  mandatory: false AS mandatoryfalseCompanyCode,
  resultElement: 'Ledger' AS resultElementLedger,
  multipleSelections: false AS multipleSelectionsfalse,
  mandatory: false AS mandatoryfalseLedger,
  mandatory: false AS mandatoryfalseFiscalYear,
  mandatory: false AS mandatoryfalseFiscalPeriod,
  mandatory: false AS mandatoryfalseProfitCenterSoldProduct,
  mandatory: false AS mandatoryfalseSoldProductGroup,
  mandatory: false AS mandatoryfalseProductGroupCustomer,
  mandatory: false AS mandatoryfalseCustomerGroup,
  mandatory: false AS mandatoryfalseSalesOrderSalesOrderItem
FROM I_GLAccountLineItemSemTag
;

Learn More