A_Allergen

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 A_Allergen.
-- 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: AALLERGEN
-- Parameters: P_KeyDate : sydate

CREATE VIEW A_Allergen AS
SELECT
  AllergenInternalID,
  cast(Allergen as /plmb/spc_alg_ext_id_api preserving type ) AS Allergen,
  AllergenCreationDate,
  AllergenCreatedByUser,
  AllergenChangeDate,
  AllergenChangedByUser,
  cast( _SpecificationLastChange.SpecificationLastChangeDate as /plmb/spc_vrsn_indep_lstchg_d preserving type ) AS AllergenVersIndepLstChgDate,
  cast( _SpecificationLastChange.SpecificationLastChangeTime as /plmb/spc_vrsn_indep_lstchg_t preserving type ) AS AllergenVersIndepLstChgTime,
  SpecificationValidityStartDate AS AllergenValidityStartDate,
  SpecificationValidityEndDate AS AllergenValidityEndDate,
  _SpecListedSubstanceLink( P_KeyDate: $parameters.P_KeyDate ).ListedSubstance AS ListedSubstance,
  AllergenAuthznGroup,
  AllergenType
FROM I_Allergen
LEFT OUTER JOIN A_AllergenDescription AS _AllergenDescription ON _AllergenDescription.AllergenInternalID = AllergenInternalID  -- association [0..*]
;