P_ProjSettlmtRuleWBSElement

DDL: P_PROJSETTLMTRULEWBSELEMENT Type: view_entity COMPOSITE
32 Fields 1 Data Sources

Settlement Rule for WBS Element

P_ProjSettlmtRuleWBSElement is a Composite CDS View that provides data about "Settlement Rule for WBS Element" in SAP S/4HANA. It reads from 1 data source (I_WBSElementBasicData) and exposes 32 fields with key field WBSElementInternalID.

Data Sources (1)

SourceAliasJoin Type
I_WBSElementBasicData I_WBSElementBasicData from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Settlement Rule for WBS Element view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY WBSElementInternalID WBSElementInternalID WBS Internal ID
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementObject WBSElementObject Object number
ProjectInternalID ProjectInternalID Project Def.
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
EntProjIsSettlmtRuleInherited EntProjIsSettlmtRuleInherited Sttle Rule Inherited
FunctionalArea FunctionalArea Sendr Fctl Area
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
Plant Plant Valuation Area
ProfitCenter ProfitCenter Profit Center
ProjectCurrency _Project ProjectCurrency Project Currency
ProjectType ProjectType Project Type
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
WBSDescription WBSDescription WBS Element Name
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
_CompanyCode _CompanyCode
_ControllingObjectType _ControllingObjectType
system_date
_FunctionalArea _FunctionalArea
_Project _Project
_ProjectCurrency _ProjectCurrency
_ProjectData_2 _ProjectData_2
system_date
_CtrlgObjectSettlementRule _CtrlgObjectSettlementRule
_WBSElementData_2 _WBSElementData_2

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 P_ProjSettlmtRuleWBSElement.
-- 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 P_ProjSettlmtRuleWBSElement AS
SELECT
  WBSElementInternalID,
  WBSElementExternalID,
  WBSElementObject,
  ProjectInternalID,
  CompanyCode,
  ControllingArea,
  CostCenter,
  CreatedByUser,
  CreationDate,
  EntProjIsSettlmtRuleInherited,
  FunctionalArea,
  LastChangedByUser,
  LastChangeDate,
  Plant,
  ProfitCenter,
  _Project.ProjectCurrency AS ProjectCurrency,
  ProjectType,
  ResponsibleCostCenter,
  WBSDescription,
  WBSElementIsBillingElement,
  WBSIsAccountAssignmentElement,
  WBSIsStatisticalWBSElement,
  _CostCenter[ ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date ] AS system_date
FROM I_WBSElementBasicData
;

Learn More