C_RESrvcGrpSettlementRuleTP

DDL: C_RESRVCGRPSETTLEMENTRULETP Type: view_entity CONSUMPTION
16 Fields 1 Data Sources 1 Associations 1 OData Services

Settlement Rule

C_RESrvcGrpSettlementRuleTP is a Consumption CDS View that provides data about "Settlement Rule" in SAP S/4HANA. It reads from 1 data source (R_RESrvcGrpSettlementRuleTP) and exposes 16 fields with key field RESettlementRuleUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_RESERVICEGROUP).

Data Sources (1)

SourceAliasJoin Type
R_RESrvcGrpSettlementRuleTP R_RESrvcGrpSettlementRuleTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_RESrvcGrpSettlmtPerdPerRule _RESrvcGrpSettlmtPerdPerRule $projection.InternalRealEstateNumber = _RESrvcGrpSettlmtPerdPerRule.InternalRealEstateNumber and $projection.RESettlementRuleUUID = _RESrvcGrpSettlmtPerdPerRule.RESettlementRuleUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Settlement Rule view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_RESERVICEGROUP UI_RESERVICEGROUP V4 C1 NOT_RELEASED

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY RESettlementRuleUUID RESettlementRuleUUID Settl. Rule GUID
InternalRealEstateNumber InternalRealEstateNumber RE Key
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality
RESettlementProcedure RESettlementProcedure Settlement Procedure
RESettlementFrequencyStart RESettlementFrequencyStart
NumberOfREFrequencyUnits NumberOfREFrequencyUnits
RESettlementFrequencyUnit RESettlementFrequencyUnit
RESettlmtPerdCalculationMethod RESettlmtPerdCalculationMethod
RESettlementProcedureText
RESettlementFrequencyStartName
RESettlementFrequencyUnitName
RESettlmtPerdCalcMethodName
_RESrvcGrpSettlmtPerdPerRule _RESrvcGrpSettlmtPerdPerRule

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_RESrvcGrpSettlementRuleTP.
-- 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_RESrvcGrpSettlementRuleTP AS
SELECT
  RESettlementRuleUUID,
  InternalRealEstateNumber,
  ValidityStartDate,
  ValidityEndDate,
  REEntryValidity,
  REEntryValidityCriticality,
  RESettlementProcedure,
  RESettlementFrequencyStart,
  NumberOfREFrequencyUnits,
  RESettlementFrequencyUnit,
  RESettlmtPerdCalculationMethod,
  _RESettlementProcedure._Text[1:Language = $session.system_language ].RESettlementProcedureText AS RESettlementProcedureText,
  _RESettlementFrequencyStart._Text[1:Language = $session.system_language ].RESettlementFrequencyStartName AS RESettlementFrequencyStartName,
  _RESettlementFrequencyUnit._Text[1:Language = $session.system_language ].RESettlementFrequencyUnitName AS RESettlementFrequencyUnitName,
  _RESettlmtPerdCalcMethod._Text[1:Language = $session.system_language ].RESettlmtPerdCalcMethodName AS RESettlmtPerdCalcMethodName
FROM R_RESrvcGrpSettlementRuleTP
LEFT OUTER JOIN C_RESrvcGrpSettlmtPerdPerRule AS _RESrvcGrpSettlmtPerdPerRule ON InternalRealEstateNumber = _RESrvcGrpSettlmtPerdPerRule.InternalRealEstateNumber AND RESettlementRuleUUID = _RESrvcGrpSettlmtPerdPerRule.RESettlementRuleUUID  -- association [0..*]
;

Learn More