FAC_CDS_UH_CD

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 FAC_CDS_UH_CD.
-- 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: FACV_UH_CD

CREATE VIEW FAC_CDS_UH_CD AS
SELECT
  _cdhdr.objectclas AS ObjectClass,
  _cdhdr.objectid AS ObjectId,
  _cdhdr.changenr AS DocumentNumber,
  _cdpos_str.tabname AS TableName,
  _cdpos_str.fname AS FieldName,
  _cdpos_str.tabkey AS TableKey,
  cast( '' as cdchngt ) AS ChangeTypeText,
  cast( '' as cdobjtd ) AS ObjectTypeText,
  cast( substring( _cdpos_str.tabkey, 41, 80 ) as cdobjd ) AS ObjectText,
  cast( '' as cdfldt ) AS ObjectFieldText,
  _cdhdr.username AS UserName,
  udate AS CreatedDate,
  utime AS CreatedTime,
  cast(dats_tims_to_tstmp(udate, utime, abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL') as timestamp) AS CreatedDateTime,
  cast( _cdpos_str.value_new as cdfldvaln ) AS NewValue,
  cast( _cdpos_str.value_old as cdfldvalo ) AS OldValue,
  case when _uh_vrsn.ver_id is null then cast ( substring( _cdhdr.objectid, 1, 40 ) as vrsid ) else _uh_vrsn.ver_id end as VersionId AS ver_idendasVersionId,
  case when _uh_vrsn.ver_id is null then cast ( substring( _cdhdr.objectid, 41, 4 ) as cakey ) else _uh_vrsn.hier_catg end as HierarchyCategory AS hier_catgendasHierarchyCategory,
  _uh_catg.hrrp_hrytype AS HryType,
  case when _uh_vrsn.ver_id is null then cast ( substring( _cdhdr.objectid, 45, 20 ) as vhrid ) else _uh_vrsn.hier_hid end as HierarchyId AS hier_hidendasHierarchyId,
  case when _uh_vrsn.ver_id is null then cast ( substring( _cdhdr.objectid, 65, 8 ) as vdtfm ) else _uh_vrsn.ver_vldfm end as ValidityStartDate AS ver_vldfmendasValidityStartDate,
  case when _uh_vrsn.ver_id is null then cast ( substring( _cdhdr.objectid, 73, 8 ) as vdtto ) else _uh_vrsn.ver_vldto end as ValidityEndDate AS ver_vldtoendasValidityEndDate,
  _cdhdr.langu AS Langauge,
  _ChangeDocLanguage._Text[1:Language=$session.system_language].LanguageName AS LanguageName,
  _UserContactCard.FullName AS FullName,
  cast ( concat( _cdpos_str.tabname, concat( '-', _cdpos_str.fname ) ) as cdtabfname ) AS TabFieldName
FROM FAC_CDS_UH_CD_VERSION AS _cdhdr
LEFT OUTER JOIN fac_cds_uh_cd_tf AS _cdpos_str ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN cdpos AS _cdpos ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON _UserContactCard.ContactCardID = UserName  -- association [0..1]
LEFT OUTER JOIN I_Language AS _ChangeDocLanguage ON _ChangeDocLanguage.Language = Langauge  -- association [0..1]
-- UNION ALL with additional select branch(es): FAC_CDS_UH_CD_VERSION
;