P_ChgDocItmExtnWthUUIDTblKey

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 P_ChgDocItmExtnWthUUIDTblKey.
-- 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.
-- Parameters: P_ChangeDocObjectClass : cdobjectcl, P_DatabaseTable : tabname

CREATE VIEW P_ChgDocItmExtnWthUUIDTblKey AS
SELECT
  cdpos_str.keyguid AS ChangeDocKeyGuid,
  cdpos_str.objectid AS ChangeDocObject,
  cdpos_str.objectclas AS ChangeDocObjectClass,
  cdpos_str.changenr AS ChangeDocument,
  cdpos_str.tabname AS DatabaseTable,
  cast ( substring(cdpos_str.tabkey, 1, 70) as cdtabkey preserving type) AS ChangeDocTableKey,
  cdpos_str.fname AS ChangeDocDatabaseTableField,
  cdpos_str.chngind AS ChangeDocItemChangeType,
  cast(substring(cdpos_str.value_shstr_new, 1, 254) as cdfldvaln) AS ChangeDocNewFieldValue,
  cast(substring(cdpos_str.value_shstr_old, 1, 254) as cdfldvalo) AS ChangeDocPreviousFieldValue,
  cdpos_str.value_new AS ChangeDocStringNew,
  cdpos_str.value_old AS ChangeDocStringOld,
  cdpos_str.value_rawstr_new AS ChangeDocRawStringNew,
  cdpos_str.value_rawstr_old AS ChangeDocRawStringOld,
  cdpos_str.value_shstr_new AS ChangeDocShortStringNew,
  cdpos_str.value_shstr_old AS ChangeDocShortStringOld,
  cast ( length( cdpos_str.tabkey ) as cdpos_count preserving type ) AS ChangeDocTabkeyLength
FROM cdpos_str
LEFT OUTER JOIN I_ChangeDocument AS _ChangeDocument ON ChangeDocObjectClass = _ChangeDocument.ChangeDocObjectClass AND ChangeDocObject = _ChangeDocument.ChangeDocObject AND ChangeDocument = _ChangeDocument.ChangeDocument  -- association [0..1]
;