I_FHC_HOL_RUNTIME

DDL: I_FHC_HOL_RUNTIME SQL: VFHCHOLRUN Type: view Package: S_FHC_RUNTIME

Holiday runtime interface view

I_FHC_HOL_RUNTIME is a CDS View that provides data about "Holiday runtime interface view" in SAP S/4HANA. It reads from 5 data sources (fhc_c_hol, fhc_c_hol_easter, fhc_c_hol_fixed, fhc_c_hol_float, fhc_c_hol_wkday) and exposes 5 fields with key field hol_id. Part of development package S_FHC_RUNTIME.

Data Sources (5)

SourceAliasJoin Type
fhc_c_hol fhc_c_hol from
fhc_c_hol_easter fhc_c_hol_easter left_outer
fhc_c_hol_fixed fhc_c_hol_fixed left_outer
fhc_c_hol_float fhc_c_hol_float left_outer
fhc_c_hol_wkday fhc_c_hol_wkday left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VFHCHOLRUN 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 runtime interface view view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY hol_id fhc_c_hol holiday_id Holiday ID
hol_type fhc_c_hol type Worklist Type
hol_class fhc_c_hol class User Group
hol_changer fhc_c_hol changer Last Changed By
hol_changed fhc_c_hol 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_HOL_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: VFHCHOLRUN

CREATE VIEW I_FHC_HOL_RUNTIME AS
SELECT
  fhc_c_hol.holiday_id AS hol_id,
  fhc_c_hol.type AS hol_type,
  fhc_c_hol.class AS hol_class,
  fhc_c_hol.changer AS hol_changer,
  fhc_c_hol.changed AS hol_changed
FROM fhc_c_hol
LEFT OUTER JOIN fhc_c_hol_fixed ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fhc_c_hol_easter ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fhc_c_hol_wkday ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fhc_c_hol_float ON /* join condition not captured in parsed metadata */
;