I_ProjSettlmtRule

DDL: I_PROJSETTLMTRULE Type: view_entity COMPOSITE
55 Fields 1 Data Sources

Settlement Rule for Project

I_ProjSettlmtRule is a Composite CDS View that provides data about "Settlement Rule for Project" in SAP S/4HANA. It reads from 1 data source (P_ProjSettlmtRuleWBSElement) and exposes 55 fields with key field ControllingObject.

Data Sources (1)

SourceAliasJoin Type
P_ProjSettlmtRuleWBSElement P_ProjSettlmtRuleWBSElement from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Settlement Rule for Project view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject WBSElementObject Object number
ControllingObjectExternalID WBS Element External ID
ControllingObjectType ControllingObjectType Object Type
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
ActualPostedCostCenter CostCenter Cost Center
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
CompanyCode CompanyCode Receiver Company Code
SenderCreatedByUser CreatedByUser User Name
SenderCreationDate CreationDate Time Stamp
SenderLastChangedByUser LastChangedByUser User Name
SenderLastChangedDate LastChangeDate Time Stamp
FunctionalArea FunctionalArea Sendr Fctl Area
WBSDescription WBSDescription WBS Element Name
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSElementInternalID WBSElementInternalID WBS Internal ID
ProjectCurrency ProjectCurrency Project Currency
ProjectInternalID Project Def.
ProjectType ProjectType Project Type
Plant Plant Valuation Area
AllocationStructure _CtrlgObjectSettlementRule AllocationStructure Alloc.Structure
ControllingSettlementProfile _CtrlgObjectSettlementRule ControllingSettlementProfile Settlement Profile
ProfitabilityAcctgTransfStruc _CtrlgObjectSettlementRule ProfitabilityAcctgTransfStruc
CtrlgObjectSettlementRuleName _CtrlgObjectSettlementRule CtrlgObjectSettlementRuleName
AssetValueDate _CtrlgObjectSettlementRule AssetValueDate Reference date
SettlementSourceStructure _CtrlgObjectSettlementRule SettlementSourceStructure
SettlmtWithFreeDefinedCurrency _CtrlgObjectSettlementRule SettlmtWithFreeDefinedCurrency
SettlmtRuleProcessingSequence _CtrlgObjectSettlementRule SettlmtRuleProcessingSequence
SettlmtRuleAutoGnrtnStrgySqnc _CtrlgObjectSettlementRule SettlmtRuleAutoGnrtnStrgySqnc
CreatedByUser _CtrlgObjectSettlementRule CreatedByUser User Name
LastChangedByUser _CtrlgObjectSettlementRule LastChangedByUser User Name
CreationDate _CtrlgObjectSettlementRule CreationDate Time Stamp
LastChangeDate _CtrlgObjectSettlementRule LastChangeDate Time Stamp
PlannedStartDate _Project PlannedStartDate Latest Planned Start
PlannedEndDate _Project PlannedEndDate Ltst Planned Finish
ProjectDescription _Project ProjectDescription Project Name
ProjectExternalID _Project ProjectExternalID Project def.
ProjectProfileCode _Project ProjectProfileCode Project Profile
WBSElementIsPlanningElement _WBSElementData_2 WBSElementIsPlanningElement
_SenderCreatedByUser _SenderCreatedByUser
_SenderLastChangedByUser _SenderLastChangedByUser
_CostCenter _CostCenter
_CompanyCode _CompanyCode
_ResponsibleCostCenter _ResponsibleCostCenter
_ControllingObjectType _ControllingObjectType
_FunctionalArea _FunctionalArea
_ProjectCurrency _ProjectCurrency
_CtrlgObjectSettlementRule _CtrlgObjectSettlementRule
_CreatedByUser _CtrlgObjectSettlementRule _CreatedByUser
_LastChangedByUser _CtrlgObjectSettlementRule _LastChangedByUser
_RootWBSElement _RootWBSElement
_Project _Project

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 I_ProjSettlmtRule.
-- 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 I_ProjSettlmtRule AS
SELECT
  WBSElementObject AS ControllingObject,
  cast( WBSElementExternalID as fco_psr_object_name ) AS ControllingObjectExternalID,
  ControllingObjectType,
  WBSElementIsBillingElement,
  WBSIsAccountAssignmentElement,
  WBSIsStatisticalWBSElement,
  CostCenter AS ActualPostedCostCenter,
  ResponsibleCostCenter,
  ControllingArea,
  ProfitCenter,
  CompanyCode,
  CreatedByUser AS SenderCreatedByUser,
  CreationDate AS SenderCreationDate,
  LastChangedByUser AS SenderLastChangedByUser,
  LastChangeDate AS SenderLastChangedDate,
  FunctionalArea,
  WBSDescription,
  WBSElementExternalID,
  WBSElementInternalID,
  ProjectCurrency,
  cast( ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  ProjectType,
  Plant,
  _CtrlgObjectSettlementRule.AllocationStructure AS AllocationStructure,
  _CtrlgObjectSettlementRule.ControllingSettlementProfile AS ControllingSettlementProfile,
  _CtrlgObjectSettlementRule.ProfitabilityAcctgTransfStruc AS ProfitabilityAcctgTransfStruc,
  _CtrlgObjectSettlementRule.CtrlgObjectSettlementRuleName AS CtrlgObjectSettlementRuleName,
  _CtrlgObjectSettlementRule.AssetValueDate AS AssetValueDate,
  _CtrlgObjectSettlementRule.SettlementSourceStructure AS SettlementSourceStructure,
  _CtrlgObjectSettlementRule.SettlmtWithFreeDefinedCurrency AS SettlmtWithFreeDefinedCurrency,
  _CtrlgObjectSettlementRule.SettlmtRuleProcessingSequence AS SettlmtRuleProcessingSequence,
  _CtrlgObjectSettlementRule.SettlmtRuleAutoGnrtnStrgySqnc AS SettlmtRuleAutoGnrtnStrgySqnc,
  _CtrlgObjectSettlementRule.CreatedByUser AS CreatedByUser,
  _CtrlgObjectSettlementRule.LastChangedByUser AS LastChangedByUser,
  _CtrlgObjectSettlementRule.CreationDate AS CreationDate,
  _CtrlgObjectSettlementRule.LastChangeDate AS LastChangeDate,
  _Project.PlannedStartDate AS PlannedStartDate,
  _Project.PlannedEndDate AS PlannedEndDate,
  _Project.ProjectDescription AS ProjectDescription,
  _Project.ProjectExternalID AS ProjectExternalID,
  _Project.ProjectProfileCode AS ProjectProfileCode,
  _WBSElementData_2.WBSElementIsPlanningElement AS WBSElementIsPlanningElement,
  _CtrlgObjectSettlementRule._CreatedByUser AS _CreatedByUser,
  _CtrlgObjectSettlementRule._LastChangedByUser AS _LastChangedByUser
FROM P_ProjSettlmtRuleWBSElement
;

Learn More