C_ProjSettlmtRuleTP

DDL: C_PROJSETTLMTRULETP Type: view_entity CONSUMPTION
75 Fields 1 Data Sources

Settlement Rule for Project

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

Data Sources (1)

SourceAliasJoin Type
R_ProjSettlmtRuleTP R_ProjSettlmtRuleTP projection

Annotations (8)

NameValueLevelField
Metadata.allowExtensions true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.query.implementedBy ABAP:CL_PROJSETTLMTRULEHIERQUERY view
EndUserText.label Settlement Rule for Project view

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject ControllingObject Object number
ProjSettlmtRuleCtrlgObjPar ProjSettlmtRuleCtrlgObjPar
ControllingObjectExternalID ControllingObjectExternalID WBS Element
ControllingObjectDescription ControllingObjectDescription
WBSElementExternalID WBSElementExternalID WBS Element External ID
WBSDescription WBSDescription WBS Element Name
ProjectExternalID ProjectExternalID Project def.
ProjectDescription ProjectDescription Project Name
ControllingObjectType ControllingObjectType Object Type
ControllingObjectTypeNamelocalized
ControllingSettlementProfile ControllingSettlementProfile Settlement Profile
CtrlgSettlementProfileNamelocalized
CtrlgObjectSettlementRuleName CtrlgObjectSettlementRuleName
PrjSettlmtRuleDistrRuleIsCrted PrjSettlmtRuleDistrRuleIsCrted
AllocationStructureTextlocalized
AllocationStructure AllocationStructure Alloc.Structure
PrftbltyAcctgTransfStrucNamelocalized
ProfitabilityAcctgTransfStruc ProfitabilityAcctgTransfStruc
AssetValueDate AssetValueDate Reference date
ControllingStructureNamelocalized
SettlementSourceStructure SettlementSourceStructure
SettlmtWithFreeDefinedCrcyNamelocalized
SettlmtWithFreeDefinedCurrency SettlmtWithFreeDefinedCurrency
SettlmtRuleProcessingSequence SettlmtRuleProcessingSequence
SettlmtRuleGnrtnStrgySqncNamelocalized
SettlmtRuleAutoGnrtnStrgySqnc SettlmtRuleAutoGnrtnStrgySqnc
ProjSettlmtRuleSettlmtIsAllwd ProjSettlmtRuleSettlmtIsAllwd
CreatedByUser CreatedByUser User Name
CreatedByUserName
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
LastChangeDate LastChangeDate Time Stamp
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
WBSIsAccountAssignmentElement WBSIsAccountAssignmentElement
WBSElementIsPlanningElement WBSElementIsPlanningElement
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
CostCenterNamelocalized
ActualPostedCostCenter ActualPostedCostCenter Cost Center for Actual Costs Posting
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
CompanyCodeName _CompanyCode CompanyCodeName Company Name
CompanyCode CompanyCode Receiver Company Code
HierarchyNode HierarchyNode Node
HierarchyParentNode HierarchyParentNode Hier.node
HierarchyDistanceFromRoot HierarchyDistanceFromRoot Dist. From Root
HierarchyDescendantCount HierarchyDescendantCount Desc. Count
HierarchyDrillState HierarchyDrillState Drill State
HierarchyNodeOrdinalNumber HierarchyNodeOrdinalNumber Node Number
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
HistoryPerLedgerIsHidden HistoryPerLedgerIsHidden
SenderDetailsWBSElmntIsHidden SenderDetailsWBSElmntIsHidden
SenderDetailsProjectIsHidden SenderDetailsProjectIsHidden
SenderCreatedByUser SenderCreatedByUser User Name
SenderCreatedByUserName _SenderCreatedByUser FullName Name
SenderCreationDate SenderCreationDate
SenderLastChangedByUser SenderLastChangedByUser
SenderLastChangedByUserName _SenderLastChangedByUser FullName Name
SenderLastChangedDate SenderLastChangedDate
FunctionalAreaNamelocalized
FunctionalArea FunctionalArea Sendr Fctl Area
CurrencyNamelocalized
ProjectCurrency ProjectCurrency Project Currency
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ProjectInternalID ProjectInternalID Project Def.
ProjectProfileCode ProjectProfileCode Project Profile
Plant Plant Valuation Area
ProjectType ProjectType Project Type
_SenderCreatedByUser _SenderCreatedByUser
_SenderLastChangedByUser _SenderLastChangedByUser
_CreatedByUser _CreatedByUser
_LastChangedByUser _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 C_ProjSettlmtRuleTP.
-- 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_ProjSettlmtRuleTP AS
SELECT
  ControllingObject,
  ProjSettlmtRuleCtrlgObjPar,
  ControllingObjectExternalID,
  ControllingObjectDescription,
  WBSElementExternalID,
  WBSDescription,
  ProjectExternalID,
  ProjectDescription,
  ControllingObjectType,
  _ControllingObjectType._Text.ControllingObjectTypeName: localized AS ControllingObjectTypeNamelocalized,
  ControllingSettlementProfile,
  _CtrlgObjectSettlementRule._ControllingSettlementProfile._Text.CtrlgSettlementProfileName : localized AS CtrlgSettlementProfileNamelocalized,
  CtrlgObjectSettlementRuleName,
  PrjSettlmtRuleDistrRuleIsCrted,
  _CtrlgObjectSettlementRule._AllocationStructure._Text.AllocationStructureText : localized AS AllocationStructureTextlocalized,
  AllocationStructure,
  _CtrlgObjectSettlementRule._PrftbltyAcctgTransfStructure._Text.PrftbltyAcctgTransfStrucName : localized AS PrftbltyAcctgTransfStrucNamelocalized,
  ProfitabilityAcctgTransfStruc,
  AssetValueDate,
  _CtrlgObjectSettlementRule._SourceStructure._Text.ControllingStructureName : localized AS ControllingStructureNamelocalized,
  SettlementSourceStructure,
  _CtrlgObjectSettlementRule._SettlmtWithFreeDfndCurrency._Text.SettlmtWithFreeDefinedCrcyName : localized AS SettlmtWithFreeDefinedCrcyNamelocalized,
  SettlmtWithFreeDefinedCurrency,
  SettlmtRuleProcessingSequence,
  _CtrlgObjectSettlementRule._SettlmtAutomGnrtnStrgySqnc._Text.SettlmtRuleGnrtnStrgySqncName : localized AS SettlmtRuleGnrtnStrgySqncNamelocalized,
  SettlmtRuleAutoGnrtnStrgySqnc,
  ProjSettlmtRuleSettlmtIsAllwd,
  CreatedByUser,
  _CtrlgObjectSettlementRule._CreatedByUser.FullName AS CreatedByUserName,
  CreationDate,
  LastChangedByUser,
  _CtrlgObjectSettlementRule._LastChangedByUser.FullName AS LastChangedByUserName,
  LastChangeDate,
  WBSElementIsBillingElement,
  WBSIsAccountAssignmentElement,
  WBSElementIsPlanningElement,
  WBSIsStatisticalWBSElement,
  _CostCenter[ 1: ValidityEndDate >= $session.system_date and ValidityStartDate <= $session.system_date ]._Text.CostCenterName : localized AS CostCenterNamelocalized,
  ActualPostedCostCenter,
  ResponsibleCostCenter,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  CompanyCode,
  HierarchyNode,
  HierarchyParentNode,
  HierarchyDistanceFromRoot,
  HierarchyDescendantCount,
  HierarchyDrillState,
  HierarchyNodeOrdinalNumber,
  ControllingArea,
  ProfitCenter,
  HistoryPerLedgerIsHidden,
  SenderDetailsWBSElmntIsHidden,
  SenderDetailsProjectIsHidden,
  SenderCreatedByUser,
  _SenderCreatedByUser.FullName AS SenderCreatedByUserName,
  SenderCreationDate,
  SenderLastChangedByUser,
  _SenderLastChangedByUser.FullName AS SenderLastChangedByUserName,
  SenderLastChangedDate,
  _FunctionalArea._Text.FunctionalAreaName : localized AS FunctionalAreaNamelocalized,
  FunctionalArea,
  _ProjectCurrency._Text.CurrencyName : localized AS CurrencyNamelocalized,
  ProjectCurrency,
  PlannedStartDate,
  PlannedEndDate,
  ProjectInternalID,
  ProjectProfileCode,
  Plant,
  ProjectType
FROM R_ProjSettlmtRuleTP
;

Learn More