P_RUNADMID

DDL: P_RUNADMID SQL: PGLERUNADMID Type: view BASIC
25 Fields 1 Data Sources

P_RUNADMID is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (gle_runadm_id) and exposes 25 fields with key fields Applk, Runid.

Data Sources (1)

SourceAliasJoin Type
gle_runadm_id gle_runadm_id from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PGLERUNADMID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Applk applk ApplicationArea
KEY Runid runid UUID
Prccat prccat Tech. Process Categ.
Runts runts Timestamp (UTC)
Runuser runuser User name
ReversedRun reversed_run Reversed Run
ReversalRun reversal_run Reversal Run ID
Repid repid Program Name
Cprog cprog Tcode/program
Tcode tcode Undefined range (can be used for patch levels)
Batch batch Lot No.
Slset slset Variant
Tzone tzone Time Zone Difference
Zonlo zonlo Time Zone
Langu langu Primary lang.
Status status Workflow Status
ArchiveStatus archive_status Archiving Status
ArchiveFlud archive_flud Resubmission Date
Progn progn Program name
Progdate progdate Program Run Date
Progno progno Program Run Number
Restart restart Restart Processng
Filename filename URL or Filenam Path
Environment environment XML Stream
Fileid fileid Phys. Document

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 P_RUNADMID.
-- 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: PGLERUNADMID

CREATE VIEW P_RUNADMID AS
SELECT
  Applk,
  Runid,
  Prccat,
  Runts,
  Runuser,
  reversed_run AS ReversedRun,
  reversal_run AS ReversalRun,
  Repid,
  Cprog,
  Tcode,
  Batch,
  Slset,
  Tzone,
  Zonlo,
  Langu,
  Status,
  archive_status AS ArchiveStatus,
  archive_flud AS ArchiveFlud,
  Progn,
  Progdate,
  Progno,
  Restart,
  Filename,
  Environment,
  Fileid
FROM gle_runadm_id
;

Learn More