I_SpecificationPhraseItem

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_SpecificationPhraseItem.
-- 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: ISPCPHRITEM

CREATE VIEW I_SpecificationPhraseItem AS
SELECT
  cast( recn as /plmb/spc_phrase_item_int_id preserving type ) AS SpecPhraseItemInternalID,
  cast( actn as /plmb/spc_phrase_item_chgstate preserving type ) AS SpecPhraseItemChgIntID,
  cast( recnroot as /plmb/spc_phrase_int_id preserving type ) AS SpecPhraseInternalID,
  cast( ppstate as /plmb/spc_phrase_item_status preserving type ) AS SpecPhraseItemStatus,
  valfr AS SpecPhraseItemValdtyStartDate,
  valto AS SpecPhraseItemValdtyEndDate,
  aennr AS SpecPhraseItemChangeNumber,
  delflg AS SpecPhraseItemIsDeleted,
  crdat AS SpecPhraseItemCreationDate,
  crnam AS SpecPhraseItemCreatedByUsr,
  upddat AS SpecPhraseItemChangeDate,
  updnam AS SpecPhraseItemLastChangedByUsr,
  srsid AS SpecPhraseItemSource,
  ownid AS SpecPhraseItemDataProvider,
  langu AS SpecPhraseItemLanguage,
  cast( phrcode as /plmb/spc_phrase_item_code preserving type ) AS SpecPhraseItemCode,
  cast( phrtext as /plmb/spc_phrase_item_text preserving type ) AS SpecPhraseItemText,
  ltxtflg AS SpecPhraseItemHasLongtext,
  rem AS SpecPhraseItemNote,
  phrgraph AS SpecPhraseItemGraphicFileName,
  flgwrltxt AS SpecPhraseItemTextIsSAPScript
FROM estpp
LEFT OUTER JOIN I_SpecificationPhrase AS _SpecificationPhrase ON _SpecificationPhrase.SpecPhraseInternalID = SpecPhraseInternalID  -- association [1..*]
;