srvc_details

DDL: SRVC_DETAILS SQL: SRVC_DETAILS_V Type: view Package: SWB_ADT_SRVC_CORE
10 Fields 2 Data Sources

Service Consumption Model Details

srvc_details is a CDS View that provides data about "Service Consumption Model Details" in SAP S/4HANA. It reads from 2 data sources (srvc_content, srvc_metadata) and exposes 10 fields with key fields srvc_name, version. Part of development package SWB_ADT_SRVC_CORE.

Data Sources (2)

SourceAliasJoin Type
srvc_content content left_outer
srvc_metadata srvc_metadata from

Parameters (1)

NameTypeDefault
p_language lang

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SRVC_DETAILS_V view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
EndUserText.label Service Consumption Model Details view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY srvc_name metadata srvc_name SRVC Name
KEY version metadata version XML Vers.
changed_by metadata changed_by User Name
changed_on metadata changed_on Variant Changed on
changed_at metadata changed_at Timestamp
language metadata language Report Text Language
description metadata description Well Code Des.
source_name srvc_content source_name SRVC Source Name
source_type srvc_content source_type SRVC Source Type
file_content srvc_content file_content SRVC EDMX Content

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 srvc_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: SRVC_DETAILS_V
-- Parameters: p_language : lang

CREATE VIEW srvc_details AS
SELECT
  metadata.srvc_name AS srvc_name,
  metadata.version AS version,
  metadata.changed_by AS changed_by,
  metadata.changed_on AS changed_on,
  metadata.changed_at AS changed_at,
  metadata.language AS language,
  metadata.description AS description,
  content.source_name AS source_name,
  content.source_type AS source_type,
  content.file_content AS file_content
FROM srvc_metadata
LEFT OUTER JOIN srvc_content AS content ON /* join condition not captured in parsed metadata */
;

Learn More