I_FinSGLRunIDReversal

DDL: I_FINSGLRUNIDREVERSAL Type: view_entity BASIC Package: ODATA_REVERSE_DOCUMENTS
7 Fields 1 Data Sources

Run ID Details

I_FinSGLRunIDReversal is a Basic CDS View that provides data about "Run ID Details" in SAP S/4HANA. It reads from 1 data source (P_RUNADMID) and exposes 7 fields with key fields FinSGLApplicationKey, FinSGLRunID. Part of development package ODATA_REVERSE_DOCUMENTS.

Data Sources (1)

SourceAliasJoin Type
P_RUNADMID P_RUNADMID from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Run ID Details view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FinSGLApplicationKey Applk ApplicationArea
KEY FinSGLRunID UUID
FinSGLRunIDDateTime Timestamp (UTC)
CurrentDateTime
CreatedByUserName Runuser User name
CreationTimeZone Zonlo Time Zone
FinSGLRunStatus Status Workflow Status

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_FinSGLRunIDReversal.
-- 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_FinSGLRunIDReversal AS
SELECT
  Applk AS FinSGLApplicationKey,
  cast(Runid as gle_runadm_dte_runid preserving type) AS FinSGLRunID,
  cast( substring(cast(Runts as abap.sstring( 28 )),1,14) as timestampl ) AS FinSGLRunIDDateTime,
  cast( tstmp_current_utctimestamp() as timestamp preserving type ) AS CurrentDateTime,
  Runuser AS CreatedByUserName,
  Zonlo AS CreationTimeZone,
  Status AS FinSGLRunStatus
FROM P_RUNADMID
;

Learn More