fac_cds_hrrp_convert_sdm

DDL: FAC_CDS_HRRP_CONVERT_SDM SQL: HRRPNDCONV Type: view
12 Fields 2 Data Sources

SDM CDS for HRRP new design convert

fac_cds_hrrp_convert_sdm is a CDS View that provides data about "SDM CDS for HRRP new design convert" in SAP S/4HANA. It reads from 2 data sources (hrrp_directory, hrrp_dir_n) and exposes 12 fields with key fields mandt, HRYID, HRYVER, HRYVALTO.

Data Sources (2)

SourceAliasJoin Type
hrrp_directory dir from
hrrp_dir_n dir_n left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName HRRPNDCONV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label SDM CDS for HRRP new design convert view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY mandt hrrp_directory mandt Editing Client
KEY HRYID hrrp_directory hryid Hierarchy ID
KEY HRYVER hrrp_directory hryver Version: Structures
KEY HRYVALTO hrrp_directory hryvalto Valid To
HRYVALFROM hrrp_directory hryvalfrom Valid From
hrytyp hrrp_directory hrytyp Hierarchy Type
UPDTIME hrrp_directory updtime Updated At
UPDUSER hrrp_directory upduser Changed By
HRYSOURCE hrrp_directory hrysource Source
HRYSID hrrp_directory hrysid Hierarchy ID
HRYCLS hrrp_directory hrycls Hierarchy Class
ISPRIVATE hrrp_directory isprivate Private Hierarchy

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_convert_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: HRRPNDCONV

CREATE VIEW fac_cds_hrrp_convert_sdm AS
SELECT
  dir.mandt AS mandt,
  dir.hryid AS HRYID,
  dir.hryver AS HRYVER,
  dir.hryvalto AS HRYVALTO,
  dir.hryvalfrom AS HRYVALFROM,
  dir.hrytyp AS hrytyp,
  dir.updtime AS UPDTIME,
  dir.upduser AS UPDUSER,
  dir.hrysource AS HRYSOURCE,
  dir.hrysid AS HRYSID,
  dir.hrycls AS HRYCLS,
  dir.isprivate AS ISPRIVATE
FROM hrrp_directory AS dir
LEFT OUTER JOIN hrrp_dir_n AS dir_n ON /* join condition not captured in parsed metadata */
;

Learn More