HRS1000_M

DDL: HRS1000_M SQL: HRS1000_TERM_SQL Type: view Package: SP00
9 Fields 1 Data Sources

Text Verticalization: Replacement View for HRS1000

HRS1000_M is a CDS View that provides data about "Text Verticalization: Replacement View for HRS1000" in SAP S/4HANA. It reads from 1 data source (hrs1000) and exposes 9 fields with key fields otype, objid, langu. Part of development package SP00.

Data Sources (1)

SourceAliasJoin Type
hrs1000 orig from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName HRS1000_TERM_SQL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
EndUserText.label Text Verticalization: Replacement View for HRS1000 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY otype hrs1000 otype Type of Val.
KEY objid hrs1000 objid Work Center
KEY langu hrs1000 langu Primary lang.
aedtm hrs1000 aedtm Changed On
uname hrs1000 uname User Name
short
stext
mc_short
mc_stext

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 HRS1000_M.
-- 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: HRS1000_TERM_SQL

CREATE VIEW HRS1000_M AS
SELECT
  orig.otype AS otype,
  orig.objid AS objid,
  orig.langu AS langu,
  orig.aedtm AS aedtm,
  orig.uname AS uname,
  coalesce(delta.short, orig.short) AS short,
  coalesce(delta.stext, orig.stext) AS stext,
  coalesce(delta.mc_short, orig.mc_short) AS mc_short,
  coalesce(delta.mc_stext, orig.mc_stext) AS mc_stext
FROM hrs1000 AS orig
;

Learn More