P_REIntegObjectOccpcyCalc7

DDL: P_REINTEGOBJECTOCCPCYCALC7 SQL: PREINTOBJOCCCAL7 Type: view COMPOSITE Package: VDM_RE_IP
9 Fields 2 Data Sources

Real Estate Integ Occpy Calc 7

P_REIntegObjectOccpcyCalc7 is a Composite CDS View that provides data about "Real Estate Integ Occpy Calc 7" in SAP S/4HANA. It reads from 2 data sources (P_REIntegObjectOccpcyCalc6, I_REIntegrationObject) and exposes 9 fields. Part of development package VDM_RE_IP.

Data Sources (2)

SourceAliasJoin Type
P_REIntegObjectOccpcyCalc6 _REIntegObjectOccpcyCalc inner
I_REIntegrationObject _REIntegrationObject from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PREINTOBJOCCCAL7 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (9)

KeyFieldSource TableSource FieldDescription
REIntegObjectStatusObject I_REIntegrationObject REStatusObject Val. Obj. No.
REIntegObjectInternalNumber I_REIntegrationObject InternalRealEstateNumber RE Key
REIntegObjectValidityStartDate I_REIntegrationObject ValidityStartDate Validity Start Date
REIntegObjectValidityEndDate I_REIntegrationObject ValidityEndDate ValidTo
REOccupancyValidFromDate REOccupancyFromDate
REOccupancyValidToDate REOccupancyToDate
REOccupancyFromDate
REOccupancyToDate
IsVacant

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 P_REIntegObjectOccpcyCalc7.
-- 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: PREINTOBJOCCCAL7

CREATE VIEW P_REIntegObjectOccpcyCalc7 AS
SELECT
  _REIntegrationObject.REStatusObject AS REIntegObjectStatusObject,
  _REIntegrationObject.InternalRealEstateNumber AS REIntegObjectInternalNumber,
  _REIntegrationObject.ValidityStartDate AS REIntegObjectValidityStartDate,
  _REIntegrationObject.ValidityEndDate AS REIntegObjectValidityEndDate,
  REOccupancyFromDate AS REOccupancyValidFromDate,
  REOccupancyToDate AS REOccupancyValidToDate,
  max(RENextOccupancyToDate) AS REOccupancyFromDate,
  min(REPrevOccupancyFromDate2) AS REOccupancyToDate,
  'X' AS IsVacant
FROM I_REIntegrationObject AS _REIntegrationObject
INNER JOIN P_REIntegObjectOccpcyCalc6 AS _REIntegObjectOccpcyCalc ON /* join condition not captured in parsed metadata */
;

Learn More