I_RESrvcGrpToContractAssgmt

DDL: I_RESRVCGRPTOCONTRACTASSGMT SQL: IRESGCONTASSG Type: view_entity COMPOSITE
22 Fields 2 Data Sources 1 Associations

Service Group Contract Assignment

I_RESrvcGrpToContractAssgmt is a Composite CDS View that provides data about "Service Group Contract Assignment" in SAP S/4HANA. It reads from 2 data sources (I_REObjectAssgmt, I_REServiceGroup) and exposes 22 fields with key fields REStatusObjectSource, REObjectAssignmentType, CompanyCode, RealEstateContract, ValidityStartEndDateValue. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_REObjectAssgmt _REObjectAssgmt from
I_REServiceGroup _REServiceGroup inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REContract _REContract $projection.REStatusObjectTarget = _REContract.REStatusObject

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
EndUserText.label Service Group Contract Assignment view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource I_REObjectAssgmt REStatusObjectTarget Object Number
KEY REObjectAssignmentType I_REObjectAssgmt REObjectAssignmentType Assignment Type
KEY CompanyCode _REContract CompanyCode Receiver Company Code
KEY RealEstateContract _REContract RealEstateContract Real Estate Contract
KEY ValidityStartEndDateValue
KEY REServiceGroupUUID I_REServiceGroup REServiceGroupUUID UUID GO
KEY InternalRealEstateNumber I_REServiceGroup InternalRealEstateNumber RE Key
ContractStartDateendasValidityStartDate
REStatusObjectTarget I_REObjectAssgmt REStatusObjectSource Object Number
ContractEndDateendasValidityEndDate
REOnlyInfoAssgmt I_REObjectAssgmt REOnlyInfoAssgmt Informational
REStatusObjectSourceIsArchived I_REObjectAssgmt REStatusObjectSourceIsArchived Archived
REGenerationType I_REObjectAssgmt REGenerationType GenTyp
REIsMainAsset I_REObjectAssgmt REIsMainAsset Leading Asset
REAssignmentHasMultiple I_REObjectAssgmt REAssignmentHasMultiple MultAsgn.Entry
REObjectPossessionStartDate I_REObjectAssgmt REObjectPossessionStartDate Possession From
REObjectPossessionEndDate I_REObjectAssgmt REObjectPossessionEndDate Possession To
_REObjectTypeDetails I_REObjectAssgmt _REObjectTypeDetails
_REObjectAssignmentType I_REObjectAssgmt _REObjectAssignmentType
_REGenerationType I_REObjectAssgmt _REGenerationType
_CompanyCode _REContract _CompanyCode
_REContract _REContract

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_RESrvcGrpToContractAssgmt.
-- 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.
-- SQL view name: IRESGCONTASSG

CREATE VIEW I_RESrvcGrpToContractAssgmt AS
SELECT
  _REObjectAssgmt.REStatusObjectTarget AS REStatusObjectSource,
  _REObjectAssgmt.REObjectAssignmentType AS REObjectAssignmentType,
  _REContract.CompanyCode AS CompanyCode,
  _REContract.RealEstateContract AS RealEstateContract,
  cast(concat(_REObjectAssgmt.ValidityStartDate, _REObjectAssgmt.ValidityEndDate) as recadateperiod) AS ValidityStartEndDateValue,
  _REServiceGroup.REServiceGroupUUID AS REServiceGroupUUID,
  _REServiceGroup.InternalRealEstateNumber AS InternalRealEstateNumber,
  case when _REObjectAssgmt.ValidityStartDate > _REContract.ContractStartDate then cast(coalesce(_REObjectAssgmt.ValidityStartDate, '00000000') as rebdvdmvalidfrom) when _REObjectAssgmt._REObjectTypeDetails._REServiceGroup.ValidityStartDate > _REContract.ContractStartDate then _REObjectAssgmt._REObjectTypeDetails._REServiceGroup.ValidityStartDate else _REContract.ContractStartDate end as ValidityStartDate AS ContractStartDateendasValidityStartDate,
  _REObjectAssgmt.REStatusObjectSource AS REStatusObjectTarget,
  case when _REObjectAssgmt.ValidityEndDate < _REContract.ContractEndDate then cast(coalesce(_REObjectAssgmt.ValidityEndDate, '99991231') as rebdvdmvalidto) when _REObjectAssgmt._REObjectTypeDetails._REServiceGroup.ValidityEndDate < _REContract.ContractEndDate then _REObjectAssgmt._REObjectTypeDetails._REServiceGroup.ValidityEndDate else _REContract.ContractEndDate end as ValidityEndDate AS ContractEndDateendasValidityEndDate,
  _REObjectAssgmt.REOnlyInfoAssgmt AS REOnlyInfoAssgmt,
  _REObjectAssgmt.REStatusObjectSourceIsArchived AS REStatusObjectSourceIsArchived,
  _REObjectAssgmt.REGenerationType AS REGenerationType,
  _REObjectAssgmt.REIsMainAsset AS REIsMainAsset,
  _REObjectAssgmt.REAssignmentHasMultiple AS REAssignmentHasMultiple,
  _REObjectAssgmt.REObjectPossessionStartDate AS REObjectPossessionStartDate,
  _REObjectAssgmt.REObjectPossessionEndDate AS REObjectPossessionEndDate,
  _REObjectAssgmt._REObjectTypeDetails AS _REObjectTypeDetails,
  _REObjectAssgmt._REObjectAssignmentType AS _REObjectAssignmentType,
  _REObjectAssgmt._REGenerationType AS _REGenerationType,
  _REContract._CompanyCode AS _CompanyCode
FROM I_REObjectAssgmt AS _REObjectAssgmt
INNER JOIN I_REServiceGroup AS _REServiceGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_REContract AS _REContract ON REStatusObjectTarget = _REContract.REStatusObject  -- association [1..1]
;

Learn More