C_REContractObjAssgmtTP

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_REContractObjAssgmtTP.
-- 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_REContractObjAssgmtTP AS
SELECT
  REStatusObjectSource,
  REObjectAssignmentType,
  REStatusObjectTarget,
  ValidityStartEndDateValue,
  InternalRealEstateNumber,
  ValidityStartDate,
  ValidityEndDate,
  REObjectTypeTarget,
  REStatusObjectTargetForEdit,
  REIdentification,
  REOnlyInfoAssgmt,
  _REObjectAssgmtAddl.REStatusObjectSourceIsArchived AS REStatusObjectSourceIsArchived,
  _REObjectAssgmtAddl.REGenerationType AS REGenerationType,
  _REObjectAssgmtAddl.REIsMainAsset AS REIsMainAsset,
  _REObjectAssgmtAddl.REAssignmentHasMultiple AS REAssignmentHasMultiple,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate,
  REGroupNumber,
  REObjectGroupName,
  REContractSubjectNumber,
  REContractSubjectDescription,
  REContractSubjectType,
  REAccountingObject,
  REAccountingObjIdentification,
  REAccountingObjectType,
  InternalRealEstateNumberTarget,
  REEntryValidity,
  REEntryValidityCriticality,
  _REContract.REContractType AS REContractType,
  _REContract._REContractType.REContractUserSupplier AS REContractUserSupplier,
  _REContract.RealEstateObjectType AS RealEstateObjectType,
  virtual SemanticObject : char40 AS virtualSemanticObjectchar40,
  virtual RealEstateSemanticObject : char40 AS virtualRealEstateSemanticObjectchar40,
  virtual RealEstateExternalID : char45 AS virtualRealEstateExternalIDchar45,
  virtual REIdentificationType : recaidenttype AS virtualREIdentificationTyperecaidenttype,
  virtual REObjectText : recnvdmobjname AS virtualREObjectTextrecnvdmobjname,
  virtual REIntegrationObjectNumber : reipionr AS virtualREIntegrationObjectNumberreipionr,
  virtual RealEstateUsableObjectOID : regooid AS virtualRealEstateUsableObjectOIDregooid,
  virtual CostCenter : kostl AS virtualCostCenterkostl,
  virtual ControllingArea : kokrs AS virtualControllingAreakokrs,
  virtual InternalOrder : fins_int_aufnr AS virtualInternalOrderfins_int_aufnr,
  virtual WBSElementExternalID : ps_posid_edit AS virtualWBSElementExternalIDps_posid_edit,
  virtual CompanyCode : bukrs AS virtualCompanyCodebukrs,
  virtual REBusinessEntity : rebdvdmbeno AS virtualREBusinessEntityrebdvdmbeno,
  virtual RealEstateBuilding : rebdvdmbuno AS virtualRealEstateBuildingrebdvdmbuno,
  virtual RealEstateProperty : rebdvdmprno AS virtualRealEstatePropertyrebdvdmprno,
  virtual RERentalObject : rebdvdmrono AS virtualRERentalObjectrebdvdmrono,
  virtual RealEstateContract : recnvdmcnnr AS virtualRealEstateContractrecnvdmcnnr,
  virtual REMeasurementIsHidden : recabool AS virtualREMeasurementIsHiddenrecabool,
  virtual NoteUUID : /bobf/conf_key AS virtualNoteUUIDbobfconf_key,
  _REContract.CompanyCode AS REContractCompanyCode
FROM R_REContrObjAssgmtTP
LEFT OUTER JOIN C_REContractObjAssgmtMsmt_2 AS _REContractObjAssgmtMsmt ON REStatusObjectTarget = _REContractObjAssgmtMsmt.REStatusObject AND ValidityStartDate = _REContractObjAssgmtMsmt.ValidityEndDate AND ValidityEndDate = _REContractObjAssgmtMsmt.ValidityStartDate  -- association [0..*]
LEFT OUTER JOIN C_REObjectAssgmtMsmtChart_2 AS _REObjectAssgmtMsmtChart ON REStatusObjectTarget = _REObjectAssgmtMsmtChart.REStatusObject AND ValidityStartDate = _REObjectAssgmtMsmtChart.ValidityEndDate AND ValidityEndDate = _REObjectAssgmtMsmtChart.ValidityStartDate  -- association [0..*]
;