ARS_SHIP_OBJECT_UNION

DDL: ARS_SHIP_OBJECT_UNION SQL: ARSV_OBJU Type: view Package: S_ARS_LM
16 Fields 3 Data Sources

APIs w and w/o extraction

ARS_SHIP_OBJECT_UNION is a CDS View that provides data about "APIs w and w/o extraction" in SAP S/4HANA. It reads from 3 data sources (ars_ship_api2, ars_ship_api, ars_ship_wo_api) and exposes 16 fields with key fields object_type, object_name, rel_type, rel_key, api_extract. Part of development package S_ARS_LM.

Data Sources (3)

SourceAliasJoin Type
ars_ship_api2 api_root from
ars_ship_api api_root_old union
ars_ship_wo_api wo_api_root union

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ARSV_OBJU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label APIs w and w/o extraction view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY object_type ars_ship_api2 object_type Type
KEY object_name ars_ship_api2 object_name Technical Name
KEY rel_type ars_ship_api2 rel_type Rel.Ent.Type
KEY rel_key ars_ship_api2 rel_key Rel.Ent.Key
KEY api_extract
object_type Type
KEY object_name ars_ship_api object_name Technical Name
KEY rel_type Rel.Ent.Type
KEY rel_key Rel.Ent.Key
KEY api_extract
object_type Type
KEY object_name ars_ship_wo_api object_name Technical Name
KEY rel_type Rel.Ent.Type
KEY rel_key Rel.Ent.Key
KEY api_extract
package_name ars_ship_wo_api package_name Package Name

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_OBJECT_UNION.
-- 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_OBJU

CREATE VIEW ARS_SHIP_OBJECT_UNION AS
SELECT
  api_root.object_type AS object_type,
  api_root.object_name AS object_name,
  api_root.rel_type AS rel_type,
  api_root.rel_key AS rel_key,
  'X' AS api_extract,
  wo_api_root.package_name AS package_name
FROM ars_ship_api2 AS api_root
-- UNION with additional select branch(es): ars_ship_api, ars_ship_wo_api
;

Learn More