C_ProfitCenterToWBSElement

DDL: C_PROFITCENTERTOWBSELEMENT Type: view_entity CONSUMPTION
28 Fields 1 Data Sources 4 Associations 1 OData Services

Assgmt of PrftCtr to WBS Element

C_ProfitCenterToWBSElement is a Consumption CDS View that provides data about "Assgmt of PrftCtr to WBS Element" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenterToWBSElement) and exposes 28 fields with key fields OrganizationalChangeObjectType, WBSElementInternalID, ValidityStartDate. It has 4 associations to related views. It is exposed through 1 OData service (ORGL_CHANGE_REPORT_MD_LIST).

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenterToWBSElement _ProfitCenterToWBSElement from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterText _ProfitCenterBfrOrglChangeText _ProfitCenterToWBSElement.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea and _ProfitCenterToWBSElement.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter and _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'
[0..*] I_ProfitCenterText _ProfitCenterByOrglChangeText _ProfitCenterToWBSElement.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea and _ProfitCenterToWBSElement.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter and _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'
[0..1] I_WBSElementBasicData _SourceWBSElement _ProfitCenterToWBSElement.SourceWBSElementInternalID = _SourceWBSElement.WBSElementInternalID
[0..1] I_ProjectBasicData _SourceProjectBasicData _ProfitCenterToWBSElement.SourceProjectInternalID = _SourceProjectBasicData.ProjectInternalID

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 PrftCtr to WBS Element view

OData Services (1)

ServiceBindingVersionContractRelease
ORGL_CHANGE_REPORT_MD_LIST ORGL_CHANGE_RPT_MD_LIST_O4 V4 C1 NOT_TO_BE_RELEASED_STABLE

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY OrganizationalChangeObjectType
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
KEY ValidityStartDate ValidityStartDate Validity Start Date
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
WBSDescription _WBSElement WBSDescription WBS Element 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
SourceWBSElementExternalID _SourceWBSElement WBSElementExternalID WBS Element External ID
SourceWBSElementDescription _SourceWBSElement WBSDescription WBS Element Name
SourceProjectInternalID SourceProjectInternalID
SourceProjectExternalID _SourceProjectBasicData ProjectExternalID Project def.
SourceProjectDescription _SourceProjectBasicData ProjectDescription Project Name
_OrglChgReassignmentStatus _OrglChgReassignmentStatus
_ProfitCtrDerivationSrceType _ProfitCtrDerivationSrceType
_WBSElement _WBSElement
_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_ProfitCenterToWBSElement.
-- 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_ProfitCenterToWBSElement AS
SELECT
  'PR' AS OrganizationalChangeObjectType,
  WBSElementInternalID,
  ValidityStartDate,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  CompanyCode,
  ValidityEndDate,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  ProfitCenterBeforeOrglChange,
  ProfitCenter AS ProfitCenterByOrglChange,
  OrganizationalChange,
  OrglChangeReassignmentStatus,
  ProfitCenterDerivationSrceType,
  _SourceWBSElement.WBSElementExternalID AS SourceWBSElementExternalID,
  _SourceWBSElement.WBSDescription AS SourceWBSElementDescription,
  SourceProjectInternalID,
  _SourceProjectBasicData.ProjectExternalID AS SourceProjectExternalID,
  _SourceProjectBasicData.ProjectDescription AS SourceProjectDescription
FROM I_ProfitCenterToWBSElement AS _ProfitCenterToWBSElement
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterBfrOrglChangeText ON _ProfitCenterToWBSElement.ControllingArea = _ProfitCenterBfrOrglChangeText.ControllingArea AND _ProfitCenterToWBSElement.ProfitCenterBeforeOrglChange = _ProfitCenterBfrOrglChangeText.ProfitCenter AND _ProfitCenterBfrOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterByOrglChangeText ON _ProfitCenterToWBSElement.ControllingArea = _ProfitCenterByOrglChangeText.ControllingArea AND _ProfitCenterToWBSElement.ProfitCenter = _ProfitCenterByOrglChangeText.ProfitCenter AND _ProfitCenterByOrglChangeText.ValidityEndDate = '99991231'  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _SourceWBSElement ON _ProfitCenterToWBSElement.SourceWBSElementInternalID = _SourceWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProjectBasicData AS _SourceProjectBasicData ON _ProfitCenterToWBSElement.SourceProjectInternalID = _SourceProjectBasicData.ProjectInternalID  -- association [0..1]
;

Learn More