C_ProfitCenterToProduct

DDL: C_PROFITCENTERTOPRODUCT Type: view_entity CONSUMPTION Package: ODATA_ORGL_CHG_REPORT_MD_LR
25 Fields 1 Data Sources 2 Associations 2 OData Services

Assigmt of Profit Center to Product

C_ProfitCenterToProduct is a Consumption CDS View that provides data about "Assigmt of Profit Center to Product" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToProduct) and exposes 25 fields with key fields OrganizationalChangeObjectType, Product, Plant, ValidityStartDate. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F7047, ORGL_CHANGE_REPORT_MD_LIST). Part of development package ODATA_ORGL_CHG_REPORT_MD_LR.

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterToProduct _ProfitCenterToProduct from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterText _ProfitCenterBfrOrglChangeText _ProfitCenterToProduct.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea and _ProfitCenterToProduct.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'
[0..*] I_ProfitCenterText _ProfitCenterByOrglChangeText _ProfitCenterToProduct.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea and _ProfitCenterToProduct.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter and _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
EndUserText.label Assigmt of Profit Center to Product view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7047 ASQL_F7047 C2 NOT_RELEASED
ORGL_CHANGE_REPORT_MD_LIST ORGL_CHANGE_RPT_MD_LIST_O4 V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChangeObjectType
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY ValidityStartDate ValidityStartDate Validity Start Date
OrglChangeReassignmentStatus OrglChangeReassignmentStatus Status
ProductNameendasProductName
PlantName _Plant PlantName Plant Name
ValidityEndDate ValidityEndDate ValidTo
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange Old Profit Center
ProfitCenterByOrglChange ProfitCenter Profit Center
OrganizationalChange OrganizationalChange Organizational Change
ProfitCenterDerivationSrceType ProfitCenterDerivationSrceType Profit Center Source
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_Product _Product
_Plant _Plant
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType
_OrglChange _OrglChange
_CompanyCode _CompanyCode
_ControllingArea _ControllingArea
_ProfitCtr _ProfitCtr
_ProfitCenterBeforeOrglChange _ProfitCenterBeforeOrglChange

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_ProfitCenterToProduct.
-- 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 C_ProfitCenterToProduct AS
SELECT
  'PM' AS OrganizationalChangeObjectType,
  Product,
  Plant,
  ValidityStartDate,
  OrglChangeReassignmentStatus,
  case when _Product._Text[1:Language=$session.system_language].ProductName is null then _Product._Text[1:Language='E'].ProductName else _Product._Text[1:Language=$session.system_language].ProductName end as ProductName AS ProductNameendasProductName,
  _Plant.PlantName AS PlantName,
  ValidityEndDate,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenterBeforeOrglChange,
  ProfitCenter AS ProfitCenterByOrglChange,
  OrganizationalChange,
  ProfitCenterDerivationSrceType
FROM I_ProfitCenterToProduct AS _ProfitCenterToProduct
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterBfrOrglChangeText ON _ProfitCenterToProduct.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea AND _ProfitCenterToProduct.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter AND _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterByOrglChangeText ON _ProfitCenterToProduct.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea AND _ProfitCenterToProduct.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter AND _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
;

Learn More