I_PRAProcessTypeVH

DDL: I_PRAPROCESSTYPEVH Type: view_entity BASIC
11 Fields 1 Data Sources 1 Associations

PRA Process 2 Type

I_PRAProcessTypeVH is a Basic CDS View that provides data about "PRA Process 2 Type" in SAP S/4HANA. It reads from 1 data source (oiue2_proc_type) and exposes 11 fields with key field PRAProcessType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
oiue2_proc_type oiue2_proc_type from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PRAProcessTypeText _Text $projection.PRAProcessType = _Text.PRAProcessType

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PRA Process 2 Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
Search.searchable true view
ObjectModel.representativeKey PRAProcessType view
ObjectModel.dataCategory #VALUE_HELP view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PRAProcessType proc_type Transaction Type
PRAProcessTypeClassName proc_type_class Type Name
PRAProcessTypeSelectionProgram selection_prog Program Name
PRAProcessTypeSelectionScreen selection_dynnr Screen number
PRAProcessTypeCreationProgram creation_prog Program Name
PRAProcessTypeCreationScreen creation_dynnr Screen number
PRAProcessTypeRunHeaderProgram run_hdr_prog Program Name
PRAProcessTypeRunHeaderScreen run_hdr_dynnr Screen number
PRAProcTypeAdminProgram admin_prog Program Name
PRAProcTypeAdminScreen admin_dynnr Screen number
_Text _Text

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 I_PRAProcessTypeVH.
-- 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.

CREATE VIEW I_PRAProcessTypeVH AS
SELECT
  proc_type AS PRAProcessType,
  proc_type_class AS PRAProcessTypeClassName,
  selection_prog AS PRAProcessTypeSelectionProgram,
  selection_dynnr AS PRAProcessTypeSelectionScreen,
  creation_prog AS PRAProcessTypeCreationProgram,
  creation_dynnr AS PRAProcessTypeCreationScreen,
  run_hdr_prog AS PRAProcessTypeRunHeaderProgram,
  run_hdr_dynnr AS PRAProcessTypeRunHeaderScreen,
  admin_prog AS PRAProcTypeAdminProgram,
  admin_dynnr AS PRAProcTypeAdminScreen
FROM oiue2_proc_type
LEFT OUTER JOIN I_PRAProcessTypeText AS _Text ON PRAProcessType = _Text.PRAProcessType  -- association [0..*]
;

Learn More