R_REServiceGroupTP

DDL: R_RESERVICEGROUPTP Type: view_entity TRANSACTIONAL
46 Fields 1 Data Sources 8 Associations

Real Estate ServiceGroup TP

R_REServiceGroupTP is a Transactional CDS View that provides data about "Real Estate ServiceGroup TP" in SAP S/4HANA. It reads from 1 data source (I_REServiceGroup) and exposes 46 fields with key field InternalRealEstateNumber. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_REServiceGroup I_REServiceGroup from

Associations (8)

CardinalityTargetAliasCondition
[1..1] E_REServiceGroup _Extension $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber
[0..*] R_RESrvcGrpLdngCostObjAssgmtTP _RESrvcGrpLdngCostObjAssgmtTP
[0..*] R_RESrvcGrpAddlCostObjAssgmtTP _RESrvcGrpAddlCostObjAssgmtTP
[0..*] R_RESrvcGrpObjectRelationTP _RESrvcGrpObjectRelationTP
[0..*] R_RESrvcGrpSettlementRuleTP _RESrvcGrpSettlementRuleTP
[0..*] R_RESrvcGrpApportionmentRuleTP _RESrvcGrpApportionmentRuleTP
[0..*] R_RESrvcGrpDenominatorRuleTP _RESrvcGrpDenominatorRuleTP
[0..*] R_RESrvcGrpContractAssgmtTP _RESrvcGrpContractAssgmtTP

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey InternalRealEstateNumber view
ObjectModel.lifecycle.enqueue.expiryInterval PT15M view
ObjectModel.sapObjectNodeType.name RealEstateServiceGroup view
EndUserText.label Real Estate ServiceGroup TP view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SGH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 2040 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
REStatusObject REStatusObject Val. Obj. No.
RealEstateServiceGroupNumber RealEstateServiceGroupNumber Service Group
REServiceGroupNumberForEdit RealEstateServiceGroupNumber Service Group
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REServiceGroupType REServiceGroupType Service Group Type
REServiceGroupCategory REServiceGroupCategory Service Group Category
REServiceGroupName REServiceGroupName Service Group Name (Short)
REServiceGroupLongName REServiceGroupLongName Service Group Name (Long)
REParentIntRealEstateNumber REParentIntRealEstateNumber Parent Number
REParentIntegObjectNumber _REParentIntegrationObject REIntegrationObjectNumber
CompanyCode CompanyCode Receiver Company Code
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
RESourceOfCreation RESourceOfCreation Source.In.Entry
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
RESourceOfChange RESourceOfChange Editing Source
Responsible Responsible User Name
REAuthorizationGroup REAuthorizationGroup Authoriz. Group
_ChangedByUser _ChangedByUser
_CompanyCode _CompanyCode
_CreatedByUser _CreatedByUser
_REAuthorizationGroup _REAuthorizationGroup
_REKeyAssgmt _REKeyAssgmt
_REObjectAssgmt _REObjectAssgmt
_REPartnerAssgmt _REPartnerAssgmt
_REReminderRule _REReminderRule
_REServiceGroupType _REServiceGroupType
_REServiceGroupCategory _REServiceGroupCategory
_ResponsibleUser _ResponsibleUser
_StatusObject _StatusObject
_StatusObjectStatus _StatusObjectStatus
_REParentIntegrationObject _REParentIntegrationObject
_RESrvcGrpToContractAssgmt _RESrvcGrpToContractAssgmt
_REServiceGroupAcctObjAssgmt _REServiceGroupAcctObjAssgmt
_RESrvcGrpLdngCostObjAssgmtTP _RESrvcGrpLdngCostObjAssgmtTP
_RESrvcGrpAddlCostObjAssgmtTP _RESrvcGrpAddlCostObjAssgmtTP
_RESrvcGrpObjectRelationTP _RESrvcGrpObjectRelationTP
_RESrvcGrpSettlementRuleTP _RESrvcGrpSettlementRuleTP
_RESrvcGrpApportionmentRuleTP _RESrvcGrpApportionmentRuleTP
_RESrvcGrpDenominatorRuleTP _RESrvcGrpDenominatorRuleTP
_RESrvcGrpContractAssgmtTP _RESrvcGrpContractAssgmtTP

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_REServiceGroupTP.
-- 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_REServiceGroupTP AS
SELECT
  InternalRealEstateNumber,
  REStatusObject,
  RealEstateServiceGroupNumber,
  RealEstateServiceGroupNumber AS REServiceGroupNumberForEdit,
  ValidityStartDate,
  ValidityEndDate,
  REServiceGroupType,
  REServiceGroupCategory,
  REServiceGroupName,
  REServiceGroupLongName,
  REParentIntRealEstateNumber,
  _REParentIntegrationObject.REIntegrationObjectNumber AS REParentIntegObjectNumber,
  CompanyCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  RESourceOfCreation,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  RESourceOfChange,
  Responsible,
  REAuthorizationGroup
FROM I_REServiceGroup
LEFT OUTER JOIN E_REServiceGroup AS _Extension ON InternalRealEstateNumber = _Extension.InternalRealEstateNumber  -- association [1..1]
LEFT OUTER JOIN R_RESrvcGrpLdngCostObjAssgmtTP AS _RESrvcGrpLdngCostObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RESrvcGrpAddlCostObjAssgmtTP AS _RESrvcGrpAddlCostObjAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RESrvcGrpObjectRelationTP AS _RESrvcGrpObjectRelationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RESrvcGrpSettlementRuleTP AS _RESrvcGrpSettlementRuleTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RESrvcGrpApportionmentRuleTP AS _RESrvcGrpApportionmentRuleTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RESrvcGrpDenominatorRuleTP AS _RESrvcGrpDenominatorRuleTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_RESrvcGrpContractAssgmtTP AS _RESrvcGrpContractAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More