I_FHC_FCAL

DDL: I_FHC_FCAL SQL: VFHCFCALCDS Type: view
9 Fields 1 Data Sources

Interface view

I_FHC_FCAL is a CDS View that provides data about "Interface view" in SAP S/4HANA. It reads from 1 data source (fhc_c_fcal) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
fhc_c_fcal c_fcal from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName VFHCFCALCDS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface view view

Fields (9)

KeyFieldSource TableSource FieldDescription
work_monday work_monday Work Monday
work_tuesday work_tuesday Work Tuesday
work_friday work_friday Work Friday
work_sunday work_sunday Work Sunday
work_holiday work_holiday Work Holiday
valid_from valid_from Validity Start Time
valid_to valid_to Validity End Time
changer changer Last Changed By
changed 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_FCAL.
-- 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: VFHCFCALCDS

CREATE VIEW I_FHC_FCAL AS
SELECT
  work_monday,
  work_tuesday,
  work_friday,
  work_sunday,
  work_holiday,
  valid_from,
  valid_to,
  changer,
  changed
FROM fhc_c_fcal AS c_fcal
;

Learn More