rs_p_ana_umm2_trmodel

DDL: RS_P_ANA_UMM2_TR_MODEL SQL: RSPANAUMM2TRMDL Type: view
14 Fields 2 Data Sources

Local&Transportable Models(no Def&Spec)

rs_p_ana_umm2_trmodel is a CDS View that provides data about "Local&Transportable Models(no Def&Spec)" in SAP S/4HANA. It reads from 2 data sources (rsanaummmodel, rsanaummtrmodel) and exposes 14 fields with key field guid.

Data Sources (2)

SourceAliasJoin Type
rsanaummmodel rsanaummmodel union
rsanaummtrmodel rsanaummtrmodel from

Annotations (5)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName RSPANAUMM2TRMDL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Local&Transportable Models(no Def&Spec) view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY guid guid UUID 22 char.
name name Zone name
parent parent UUID
model_type model_type Model Type
adapter_id adapter_id Adapter ID
status
state state Vehicle Region
name name Zone name
parent parent UUID
model_type model_type Model Type
adapter_id adapter_id Adapter ID
status
state Vehicle Region
new_model

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 rs_p_ana_umm2_trmodel.
-- 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: RSPANAUMM2TRMDL

CREATE VIEW rs_p_ana_umm2_trmodel AS
SELECT
  guid,
  name,
  parent,
  model_type,
  adapter_id,
  cast ( 'Transportable' as rsana_umm_mv_status ) AS status,
  state,
  cast ( '' as rsana_umm3_new_model_flag ) AS new_model
FROM rsanaummtrmodel
-- UNION with additional select branch(es): rsanaummmodel
;

Learn More