P_REOccupancyValidityCalc2

DDL: P_REOCCUPANCYVALIDITYCALC2 Type: view_entity COMPOSITE
2 Fields 2 Data Sources

P_REOccupancyValidityCalc2 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_REOccupancyValidityCalc1, P_REOccupancyValidityCalc1) and exposes 2 fields.

Data Sources (2)

SourceAliasJoin Type
P_REOccupancyValidityCalc1 P_REOccupancyValidityCalc1 from
P_REOccupancyValidityCalc1 P_REOccupancyValidityCalc1 union_all

Parameters (2)

NameTypeDefault
P_ValidFrom vdm_validitystart
P_ValidTo vdm_validityend

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (2)

KeyFieldSource TableSource FieldDescription
InternalRealEstateNumberLvl3 InternalRealEstateNumberLvl3 RE Key
ValidityStartDate

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_REOccupancyValidityCalc2.
-- 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.
-- Parameters: P_ValidFrom : vdm_validitystart, P_ValidTo : vdm_validityend

CREATE VIEW P_REOccupancyValidityCalc2 AS
SELECT
  InternalRealEstateNumberLvl3,
  dats_add_days(ValidityEndDate,1,'UNCHANGED') AS ValidityStartDate
FROM P_REOccupancyValidityCalc1
-- UNION ALL with additional select branch(es): P_REOccupancyValidityCalc1
;

Learn More