ARS_SHIP_OBJS_SNAPSHOTS_LATEST

DDL: ARS_SHIP_OBJS_SNAPSHOTS_LATEST SQL: ARSV_OBJSNL Type: view Package: S_ARS_LM

Latest Object and snapshot data

ARS_SHIP_OBJS_SNAPSHOTS_LATEST is a CDS View that provides data about "Latest Object and snapshot data" in SAP S/4HANA. It reads from 1 data source (ars_ship_objs_snapshots) and exposes 6 fields with key fields object_type, object_name, rel_type, rel_key, saprelease. Part of development package S_ARS_LM.

Data Sources (1)

SourceAliasJoin Type
ars_ship_objs_snapshots ars_ship_objs_snapshots from

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ARSV_OBJSNL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Latest Object and snapshot data view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY object_type object_type Type
KEY object_name object_name Technical Name
KEY rel_type rel_type Rel.Ent.Type
KEY rel_key rel_key Rel.Ent.Key
KEY saprelease saprelease SAP Release
created_at

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_SHIP_OBJS_SNAPSHOTS_LATEST.
-- 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: ARSV_OBJSNL

CREATE VIEW ARS_SHIP_OBJS_SNAPSHOTS_LATEST AS
SELECT
  object_type,
  object_name,
  rel_type,
  rel_key,
  saprelease,
  max(created_at) AS created_at
FROM ars_ship_objs_snapshots
;