I_REContractSubject

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_REContractSubject.
-- 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: IRECONTRACTSUB

CREATE VIEW I_REContractSubject AS
SELECT
  intreno AS InternalRealEstateNumber,
  objnr AS REStatusObject,
  cast (xcnsubject as vibdcnvdmxcnsubject preserving type ) AS REContractSubjectDescription,
  cast (adjustnumber as vibdcnvdmsubjectobjnr preserving type ) AS REContractSubjectNumber,
  extid AS ExternalId,
  cast(substring(acctobjnr,1,2) as recaobjtype ) AS REAccountingObjectType,
  cast(acctobjnr as rebdvdmacctobjnr preserving type ) AS REAccountingObject,
  cnsubjecttype AS REContractSubjectType,
  cnsubjectclass AS REContractSubjectClass
FROM vibdcnsubject
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON REAccountingObject = _CostCenter.ObjectInternalID  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON REAccountingObject = _WBSElement.WBSElementObject  -- association [0..*]
LEFT OUTER JOIN I_InternalOrder AS _InternalOrder ON REAccountingObject = _InternalOrder.ControllingObject  -- association [0..*]
LEFT OUTER JOIN I_REContractSubjectClass AS _REContractSubjectClass ON REContractSubjectClass = _REContractSubjectClass.REContractSubjectClass  -- association [0..1]
LEFT OUTER JOIN I_REContractSubjectType AS _REContractSubjectType ON REContractSubjectType = _REContractSubjectType.REContractSubjectType  -- association [0..1]
LEFT OUTER JOIN I_REAccountingObject AS _REAccountingObject ON REAccountingObject = _REAccountingObject.REAccountingObject  -- association [0..1]
LEFT OUTER JOIN I_REContract AS _REContract ON InternalRealEstateNumber = _REContract.InternalRealEstateNumber  -- association [1..1]
;