A_REContrObjAssgmt

DDL: A_RECONTROBJASSGMT Type: view_entity CONSUMPTION Package: ODATA_RE_CN
24 Fields 1 Data Sources 1 OData Services

Object Assignments

A_REContrObjAssgmt is a Consumption CDS View that provides data about "Object Assignments" in SAP S/4HANA. It reads from 1 data source (R_REContrObjAssgmtTP) and exposes 24 fields with key fields REStatusObjectSource, REObjectAssignmentType, REStatusObjectTarget, ValidityStartEndDateValue, InternalRealEstateNumber. It is exposed through 1 OData service (API_RECONTRACT). Part of development package ODATA_RE_CN.

Data Sources (1)

SourceAliasJoin Type
R_REContrObjAssgmtTP R_REContrObjAssgmtTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Object Assignments view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name REContrObjAssgmt_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_RECONTRACT API_REAL_ESTATE_CONTRACT V4 C2 C1

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY REStatusObjectSource REStatusObjectSource Object Number
KEY REObjectAssignmentType REObjectAssignmentType Assignment Type
KEY REStatusObjectTarget REStatusObjectTarget Object Number
KEY ValidityStartEndDateValue ValidityStartEndDateValue Validity Period
KEY InternalRealEstateNumber InternalRealEstateNumber RE Key
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REObjectTypeTarget REObjectTypeTarget BusObjType
REOnlyInfoAssgmt REOnlyInfoAssgmt Informational
REStatusObjectSourceIsArchived _REObjectAssgmtAddl REStatusObjectSourceIsArchived
REGenerationType _REObjectAssgmtAddl REGenerationType
REIsMainAsset _REObjectAssgmtAddl REIsMainAsset
REAssignmentHasMultiple _REObjectAssgmtAddl REAssignmentHasMultiple
REObjectPossessionStartDate REObjectPossessionStartDate Possession From
REObjectPossessionEndDate REObjectPossessionEndDate Possession To
REGroupNumber REGroupNumber Group Number
REObjectGroupName REObjectGroupName Object Group
REContractSubjectNumber REContractSubjectNumber Contract Object Number
REContractSubjectDescription REContractSubjectDescription Contract Object
REContractSubjectClass REContractSubjectClass CO Class
REContractSubjectType REContractSubjectType Object Type
ExternalId ExternalId SRM Reference
REAccountingObject REAccountingObject Object Number Account Assignment
REAccountingObjectType REAccountingObjectType Object Type

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 A_REContrObjAssgmt.
-- 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 A_REContrObjAssgmt AS
SELECT
  REStatusObjectSource,
  REObjectAssignmentType,
  REStatusObjectTarget,
  ValidityStartEndDateValue,
  InternalRealEstateNumber,
  ValidityStartDate,
  ValidityEndDate,
  REObjectTypeTarget,
  REOnlyInfoAssgmt,
  _REObjectAssgmtAddl.REStatusObjectSourceIsArchived AS REStatusObjectSourceIsArchived,
  _REObjectAssgmtAddl.REGenerationType AS REGenerationType,
  _REObjectAssgmtAddl.REIsMainAsset AS REIsMainAsset,
  _REObjectAssgmtAddl.REAssignmentHasMultiple AS REAssignmentHasMultiple,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate,
  REGroupNumber,
  REObjectGroupName,
  REContractSubjectNumber,
  REContractSubjectDescription,
  REContractSubjectClass,
  REContractSubjectType,
  ExternalId,
  REAccountingObject,
  REAccountingObjectType
FROM R_REContrObjAssgmtTP
;

Learn More