ARS_V_FLP_SNAP_BALLOG_BASE

DDL: ARS_V_FLP_SNAP_BALLOG_BASE SQL: ARS_V_FLP_BALLB Type: view
2 Fields 1 Data Sources

API Snapshot: Ballog

ARS_V_FLP_SNAP_BALLOG_BASE is a CDS View that provides data about "API Snapshot: Ballog" in SAP S/4HANA. It reads from 1 data source (ars_l_snap_sta_h) and exposes 2 fields with key field counter.

Data Sources (1)

SourceAliasJoin Type
ars_l_snap_sta_h ars_l_snap_sta_h from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ARS_V_FLP_BALLB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label API Snapshot: Ballog view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY counter counter Version
clientNULLelse0endastimestamp

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 ARS_V_FLP_SNAP_BALLOG_BASE.
-- 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: ARS_V_FLP_BALLB

CREATE VIEW ARS_V_FLP_SNAP_BALLOG_BASE AS
SELECT
  counter,
  case when last_changed_on is not null and last_changed_at is not null then dats_tims_to_tstmp( last_changed_on, last_changed_at, 'UTC', $session.client, 'NULL' ) else 0 end as timestamp AS clientNULLelse0endastimestamp
FROM ars_l_snap_sta_h
;

Learn More