I_FHC_HCAL_RUNTIME

DDL: I_FHC_HCAL_RUNTIME SQL: VFHCHCALRUN Type: view Package: S_FHC_RUNTIME

Holiday Calendar runtime view

I_FHC_HCAL_RUNTIME is a CDS View that provides data about "Holiday Calendar runtime view" in SAP S/4HANA. It reads from 2 data sources (fhc_c_hcal_assgn, fhc_c_hcal) and exposes 5 fields with key field holiday_id. Part of development package S_FHC_RUNTIME.

Data Sources (2)

SourceAliasJoin Type
fhc_c_hcal_assgn assignment left_outer
fhc_c_hcal holidaycalendar from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFHCHCALRUN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Holiday Calendar runtime view view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY holiday_id fhc_c_hcal_assgn holiday_id Holiday ID
valid_from fhc_c_hcal valid_from Validity Start Time
valid_to fhc_c_hcal valid_to Validity End Time
changer fhc_c_hcal changer Last Changed By
changed fhc_c_hcal changed Time Stamp

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_FHC_HCAL_RUNTIME.
-- 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: VFHCHCALRUN

CREATE VIEW I_FHC_HCAL_RUNTIME AS
SELECT
  assignment.holiday_id AS holiday_id,
  holidaycalendar.valid_from AS valid_from,
  holidaycalendar.valid_to AS valid_to,
  holidaycalendar.changer AS changer,
  holidaycalendar.changed AS changed
FROM fhc_c_hcal AS holidaycalendar
LEFT OUTER JOIN fhc_c_hcal_assgn AS assignment ON /* join condition not captured in parsed metadata */
;