C_ProfitCenterToProject

DDL: C_PROFITCENTERTOPROJECT Type: view_entity CONSUMPTION Package: ODATA_ORGL_CHG_REPORT_MD_LR
18 Fields 1 Data Sources 2 Associations 2 OData Services

Assgmt of Profit Center to Project

C_ProfitCenterToProject is a Consumption CDS View that provides data about "Assgmt of Profit Center to Project" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToProject) and exposes 18 fields with key fields OrganizationalChangeObjectType, ProjectInternalID, 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_ProfitCenterToProject _ProfitCenterToProject from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterText _ProfitCenterBfrOrglChangeText _ProfitCenterToProject.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea and _ProfitCenterToProject.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'
[0..*] I_ProfitCenterText _ProfitCenterByOrglChangeText _ProfitCenterToProject.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea and _ProfitCenterToProject.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 Assgmt of Profit Center to Project 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 (18)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChangeObjectType
KEY ProjectInternalID ProjectInternalID Project Def.
KEY ValidityStartDate ValidityStartDate Validity Start Date
ProjectExternalID
ProjectDescription _ProjectBasicData ProjectDescription Project Name
CompanyCode CompanyCode Receiver Company Code
ValidityEndDate ValidityEndDate ValidTo
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ProfitCenterBeforeOrglChange ProfitCenterBeforeOrglChange Old Profit Center
ProfitCenterByOrglChange ProfitCenter Profit Center
OrganizationalChange OrganizationalChange Organizational Change
OrglChangeReassignmentStatus OrglChangeReassignmentStatus Status
ProfitCenterDerivationSrceType ProfitCenterDerivationSrceType Profit Center Source
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType
_ProjectBasicData _ProjectBasicData

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_ProfitCenterToProject.
-- 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_ProfitCenterToProject AS
SELECT
  'PD' AS OrganizationalChangeObjectType,
  ProjectInternalID,
  ValidityStartDate,
  _ProjectBasicData .ProjectExternalID AS ProjectExternalID,
  _ProjectBasicData.ProjectDescription AS ProjectDescription,
  CompanyCode,
  ValidityEndDate,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenterBeforeOrglChange,
  ProfitCenter AS ProfitCenterByOrglChange,
  OrganizationalChange,
  OrglChangeReassignmentStatus,
  ProfitCenterDerivationSrceType
FROM I_ProfitCenterToProject AS _ProfitCenterToProject
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterBfrOrglChangeText ON _ProfitCenterToProject.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea AND _ProfitCenterToProject.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter AND _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterByOrglChangeText ON _ProfitCenterToProject.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea AND _ProfitCenterToProject.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter AND _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
;

Learn More