FAC_CDS_HRRP_ATTR_DIR_SDM

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_HRRP_ATTR_DIR_SDM.
-- 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: HRRPATTRDIRSMD

CREATE VIEW FAC_CDS_HRRP_ATTR_DIR_SDM AS
SELECT
  directory.mandt AS mandt,
  cast( directory.hryid as vhrid ) AS hryid,
  directory.hryver AS hryver,
  directory.hryvalto AS hryvalto,
  directory.hryvalfrom AS hryvalfrom,
  source.hryattrvalue AS source
FROM hrrp_directory AS directory
LEFT OUTER JOIN hrrp_attr_dir AS source ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrrp_attr_dir AS sdm_status_assets ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrrp_attr_dir AS sdm_status_liability ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrrp_attr_dir AS sdm_status_netloss ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrrp_attr_dir AS sdm_status_netprofit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrrp_attr_dir AS sdm_status_plresult ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrrp_attr_dir AS sdm_status_fsnote ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN hrrp_attr_dir AS sdm_status_notassgnd ON /* join condition not captured in parsed metadata */
;