upov_pr_proctype_fixfieldname

DDL: UPO_INT_V_PROCTYP_FIXFIELDNAME SQL: UPOS_FIXFLDPRTYP Type: view

Fixed fieldnames for Process type

upov_pr_proctype_fixfieldname is a CDS View that provides data about "Fixed fieldnames for Process type" in SAP S/4HANA. It reads from 2 data sources (gho_ppa_request, upots_int_ppnlbl) and exposes 6 fields with key fields PlanningNr, ProcessType, SeqNr.

Data Sources (2)

SourceAliasJoin Type
gho_ppa_request ppa_data from
upots_int_ppnlbl ppn_labels left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_FIXFLDPRTYP view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Fixed fieldnames for Process type view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PlanningNr gho_ppa_request planchngnr Plan document number
KEY ProcessType gho_ppa_request process_type Type of Data
KEY SeqNr upots_int_ppnlbl seq_no Value Number
Tabname
LabelDesc upots_int_ppnlbl text User Group
fieldname upots_int_ppnlbl fieldname UI Group FieldName

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 upov_pr_proctype_fixfieldname.
-- 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: UPOS_FIXFLDPRTYP

CREATE VIEW upov_pr_proctype_fixfieldname AS
SELECT
  ppa_data.planchngnr AS PlanningNr,
  ppa_data.process_type AS ProcessType,
  ppn_labels.seq_no AS SeqNr,
  cast(' ' as tabname) AS Tabname,
  ppn_labels.text AS LabelDesc,
  ppn_labels.fieldname AS fieldname
FROM gho_ppa_request AS ppa_data
LEFT OUTER JOIN upots_int_ppnlbl AS ppn_labels ON /* join condition not captured in parsed metadata */
;