SUIM_AGR_START_APPL

DDL: SUIM_AGR_START_APPL SQL: SUIM_AGR_START Type: view Package: SUSR_IS

rest

SUIM_AGR_START_APPL is a CDS View that provides data about "rest" in SAP S/4HANA. It reads from 4 data sources (agr_1016, agr_1251, agr_hier, agr_tcodes) and exposes 6 fields with key field agr_name. Part of development package SUSR_IS.

Data Sources (4)

SourceAliasJoin Type
agr_1016 agr_1016 left_outer
agr_1251 agr_1251 left_outer
agr_hier agr_hier left_outer
agr_tcodes agr_tcodes left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SUIM_AGR_START view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label rest view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY agr_name root agr_name Role
reporttype agr_hier reporttype ReportTyp
tcode agr_tcodes tcode Undefined range (can be used for patch levels)
object agr_1251 object TRFM Object
profile agr_1016 profile WBS sched. prof
pstate agr_1016 pstate Version

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 SUIM_AGR_START_APPL.
-- 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: SUIM_AGR_START

CREATE VIEW SUIM_AGR_START_APPL AS
SELECT
  root.agr_name AS agr_name,
  agr_hier.reporttype AS reporttype,
  agr_tcodes.tcode AS tcode,
  agr_1251.object AS object,
  agr_1016.profile AS profile,
  agr_1016.pstate AS pstate
LEFT OUTER JOIN agr_hier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN agr_tcodes ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN agr_1251 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN agr_1016 ON /* join condition not captured in parsed metadata */
;