R_RESettlementAmountTP

DDL: R_RESETTLEMENTAMOUNTTP Type: view_entity TRANSACTIONAL Package: RAP_RE_CS
45 Fields 1 Data Sources

RE Settlement Amount - TP

R_RESettlementAmountTP is a Transactional CDS View that provides data about "RE Settlement Amount - TP" in SAP S/4HANA. It reads from 1 data source (I_RESettlementAmount) and exposes 45 fields with key field RESettlementAmountUUID. Part of development package RAP_RE_CS.

Data Sources (1)

SourceAliasJoin Type
I_RESettlementAmount I_RESettlementAmount from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label RE Settlement Amount - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY RESettlementAmountUUID RESettlementAmountUUID
RESettlementProcessUUID RESettlementProcessUUID
RESettlementLineItemType RESettlementLineItemType
RESettlementUUID RESettlementUUID
Ledger Ledger Ledger
RESettlementRulePeriodUUID RESettlementRulePeriodUUID Settl. Period GUID
REServiceGroupUUID REServiceGroupUUID
REArchitectureObjectUUID REArchitectureObjectUUID UUID Architecture Object
REServiceGroupTargetUUID REServiceGroupTargetUUID
RealEstateRentableObjectUUID RealEstateRentableObjectUUID UUID GO
REContractIntRealEstateNumber REContractIntRealEstateNumber RE Key
RERentableObjectIsOccupied RERentableObjectIsOccupied
RECostCategory RECostCategory Cost Category
REParticipationType REParticipationType Participation Type
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
RETotalNumberOfSettlementDays RETotalNumberOfSettlementDays
RENumberOfSettlementDays RENumberOfSettlementDays
RECostSettlmtClassfctnUUID RECostSettlmtClassfctnUUID Classification GUID
RETermType RETermType Term Category
RETermNumber RETermNumber Number
REConditionUUID REConditionUUID Condition
REConditionType REConditionType Condition Type
RESettlementAmount RESettlementAmount Value Amount
Currency Currency Valuation Crcy
RESettlmtDataRetrievalStatus RESettlmtDataRetrievalStatus
RESettlementStatus RESettlementStatus
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
_RESettlementProcess _RESettlementProcess
_Currency _Currency
_Ledger _Ledger
_RECondition _RECondition
_REConditionType _REConditionType
_REContract _REContract
_REContractTerm _REContractTerm
_RECostCategory _RECostCategory
_RECostSettlmtClassfctnItem _RECostSettlmtClassfctnItem
_REArchitectureObject _REArchitectureObject
_RERentableObject _RERentableObject
_REParticipationType _REParticipationType
_REServiceGroup _REServiceGroup
_REServiceGroupTarget _REServiceGroupTarget
_REServiceGroupTerm _REServiceGroupTerm
_RESrvcGrpSettlmtRulePeriod _RESrvcGrpSettlmtRulePeriod

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 R_RESettlementAmountTP.
-- 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 R_RESettlementAmountTP AS
SELECT
  RESettlementAmountUUID,
  RESettlementProcessUUID,
  RESettlementLineItemType,
  RESettlementUUID,
  Ledger,
  RESettlementRulePeriodUUID,
  REServiceGroupUUID,
  REArchitectureObjectUUID,
  REServiceGroupTargetUUID,
  RealEstateRentableObjectUUID,
  REContractIntRealEstateNumber,
  RERentableObjectIsOccupied,
  RECostCategory,
  REParticipationType,
  ValidityStartDate,
  ValidityEndDate,
  RETotalNumberOfSettlementDays,
  RENumberOfSettlementDays,
  RECostSettlmtClassfctnUUID,
  RETermType,
  RETermNumber,
  REConditionUUID,
  REConditionType,
  RESettlementAmount,
  Currency,
  RESettlmtDataRetrievalStatus,
  RESettlementStatus,
  CreationDateTime,
  LastChangeDateTime
FROM I_RESettlementAmount
;

Learn More