I_FHC_HOL_M

DDL: I_FHC_HOL_M Type: view_entity Package: S_FHC_MAINTENANCE

Holiday root BO

I_FHC_HOL_M is a CDS View that provides data about "Holiday root BO" in SAP S/4HANA. It reads from 1 data source (I_FHC_HOL) and exposes 14 fields with key field holiday_id. It has 9 associations to related views. It is exposed through 1 OData service (UI_FHC_HCAL_M). Part of development package S_FHC_MAINTENANCE.

Data Sources (1)

SourceAliasJoin Type
I_FHC_HOL I_FHC_HOL from

Associations (9)

CardinalityTargetAliasCondition
[0..*] I_FHC_HOL_TYPE_T _hol_type_t $projection.type = _hol_type_t.hol_type
[0..*] I_FHC_CONFESSION_T _confession_t $projection.confession = _confession_t.confession
[0..*] I_FHC_CLASS_T _class_t $projection.class = _class_t.class
[0..1] I_FHC_HOL_FIXED_M _fixed
[0..1] I_FHC_HOL_EASTER_M _easter
[0..1] I_FHC_HOL_WKDAY_M _wkday
[0..1] I_FHC_HOL_FLOAT_M _float
[0..*] I_FHC_HOL_FLDATE_M _fldate
[0..*] I_FHC_HOL_T_M _text

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Holiday root BO view

OData Services (1)

ServiceBindingVersionContractRelease
UI_FHC_HCAL_M UI_FHC_HCAL_M_O4 V4 C1 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY holiday_id holiday_id Holiday ID
type type Worklist Type
confession confession Religion
class class User Group
changer changer Last Changed By
changed changed Time Stamp
_fixed _fixed
_float _float
_fldate _fldate
_easter _easter
_wkday _wkday
_text _text
_hol_type_t _hol_type_t
_class_t _class_t

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_M.
-- 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.

CREATE VIEW I_FHC_HOL_M AS
SELECT
  holiday_id,
  type,
  confession,
  class,
  changer,
  changed
FROM I_FHC_HOL
LEFT OUTER JOIN I_FHC_HOL_TYPE_T AS _hol_type_t ON type = _hol_type_t.hol_type  -- association [0..*]
LEFT OUTER JOIN I_FHC_CONFESSION_T AS _confession_t ON confession = _confession_t.confession  -- association [0..*]
LEFT OUTER JOIN I_FHC_CLASS_T AS _class_t ON class = _class_t.class  -- association [0..*]
LEFT OUTER JOIN I_FHC_HOL_FIXED_M AS _fixed ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_FHC_HOL_EASTER_M AS _easter ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_FHC_HOL_WKDAY_M AS _wkday ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_FHC_HOL_FLOAT_M AS _float ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_FHC_HOL_FLDATE_M AS _fldate ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FHC_HOL_T_M AS _text ON /* condition not available in parsed metadata */  -- association [0..*]
;