I_SpecificationPhraseSet

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_SpecificationPhraseSet.
-- 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: ISPCPHRSET

CREATE VIEW I_SpecificationPhraseSet AS
SELECT
  cast( recn as /plmb/spc_phrase_set_int_id preserving type ) AS SpecPhraseSetInternalID,
  cast( actn as /plmb/spc_phrase_set_chg_state preserving type ) AS SpecPhraseSetChgIntID,
  cast( phrsel as /plmb/spc_phrase_set_no_conv preserving type ) AS SpecPhraseSet,
  valfr AS SpecPhraseSetValdtyStartDate,
  valto AS SpecPhraseSetValdtyEndDate,
  aennr AS SpecPhraseSetChangeNumber,
  delflg AS SpecPhraseSetIsDeleted,
  crdat AS SpecPhraseSetCreationDate,
  crnam AS SpecPhraseSetCreatedByUsr,
  upddat AS SpecPhraseSetChangeDate,
  updnam AS SpecPhraseSetLastChangedByUsr,
  srsid AS SpecPhraseSetSource,
  ownid AS SpecPhraseSetDataProvider,
  cast( rem as /plmb/spc_phrase_set_note preserving type ) AS SpecPhraseSetNote
FROM estps
LEFT OUTER JOIN I_SpecificationPhraseSetText AS _SpecificationPhraseSetText ON _SpecificationPhraseSetText.SpecPhraseSetInternalID = SpecPhraseSetInternalID  -- association [1..*]
LEFT OUTER JOIN I_SpecPhraseSetPhraseAssgmt AS _SpecPhraseSetPhraseAssgmt ON _SpecPhraseSetPhraseAssgmt.SpecPhraseSetInternalID = SpecPhraseSetInternalID  -- association [1..*]
;