INA1_DETAILS

DDL: INA1_DETAILS SQL: INA1_DETAILS_V Type: view
10 Fields 3 Data Sources

InA Service Details

INA1_DETAILS is a CDS View that provides data about "InA Service Details" in SAP S/4HANA. It reads from 3 data sources (ina1_header, ina1_rt_items, ina1_header_t) and exposes 10 fields with key fields service_name, version.

Data Sources (3)

SourceAliasJoin Type
ina1_header head from
ina1_rt_items items left_outer
ina1_header_t text left_outer

Parameters (1)

NameTypeDefault
p_language lang

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName INA1_DETAILS_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label InA Service Details view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY service_name ina1_header service_id Web Service ID
KEY version ina1_header version XML Vers.
changed_by ina1_header changed_by User Name
changed_on ina1_header changed_on Variant Changed on
changed_at ina1_header changed_at Timestamp
language ina1_header_t language Report Text Language
description ina1_header_t description Well Code Des.
srvdname ina1_rt_items srvdname Name of SRVD Source
item_name ina1_rt_items item_name Obj. Name
item_alias ina1_rt_items exposed_alias Exposed Actifact 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 INA1_DETAILS.
-- 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: INA1_DETAILS_V
-- Parameters: p_language : lang

CREATE VIEW INA1_DETAILS AS
SELECT
  head.service_id AS service_name,
  head.version AS version,
  head.changed_by AS changed_by,
  head.changed_on AS changed_on,
  head.changed_at AS changed_at,
  text.language AS language,
  text.description AS description,
  items.srvdname AS srvdname,
  items.item_name AS item_name,
  items.exposed_alias AS item_alias
FROM ina1_header AS head
LEFT OUTER JOIN ina1_header_t AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ina1_rt_items AS items ON /* join condition not captured in parsed metadata */
;

Learn More