ACMDT_DCL_ADDITIONAL_INFO

DDL: ACMDT_DCL_ADDITIONAL_INFO SQL: ACMDT_DCLADDINFO Type: view
14 Fields 3 Data Sources

ACMDT_DCL_ADDITIONAL_INFO is a CDS View in SAP S/4HANA. It reads from 3 data sources (acmdclsrc, acm_dtlogroot, acmversion) and exposes 14 fields with key field dclname.

Data Sources (3)

SourceAliasJoin Type
acmdclsrc dclsrc from
acm_dtlogroot lastlogroot inner
acmversion version inner

Parameters (2)

NameTypeDefault
p_language syLangu
p_language syst_langu

Annotations (3)

NameValueLevelField
AbapCatalog.sqlViewName ACMDT_DCLADDINFO view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientDependent false view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY dclname acmdclsrc dclname Acc. Ctrl. Name
description dclsrct ddtext Short text
devclass tadir devclass Package (Obsolete)
dcl_type metadata dcl_type Toplevel Type
switchable metadata switchable Switchable?
switch_state metadata switch_state Switch State
created_by tadir author User Name
changed_by acmdclsrc as4user Person Respons.
parentname acmdclsrc parentname Source Parent
srcsystem tadir srcsystem Source system
masterlang tadir masterlang Single-Character Flag
component tadir component Softw. Comp.
genflag tadir genflag Generation Flag
component_id df14l ps_posid WBS Element

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 ACMDT_DCL_ADDITIONAL_INFO.
-- 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: ACMDT_DCLADDINFO
-- Parameters: p_language : syLangu, p_language : syst_langu

CREATE VIEW ACMDT_DCL_ADDITIONAL_INFO AS
SELECT
  dclsrc.dclname AS dclname,
  dclsrct.ddtext AS description,
  tadir.devclass AS devclass,
  metadata.dcl_type AS dcl_type,
  metadata.switchable AS switchable,
  metadata.switch_state AS switch_state,
  tadir.author AS created_by,
  dclsrc.as4user AS changed_by,
  dclsrc.parentname AS parentname,
  tadir.srcsystem AS srcsystem,
  tadir.masterlang AS masterlang,
  tadir.component AS component,
  tadir.genflag AS genflag,
  df14l.ps_posid AS component_id
FROM acmdclsrc AS dclsrc
INNER JOIN acmversion AS version ON /* join condition not captured in parsed metadata */
INNER JOIN acm_dtlogroot AS lastlogroot ON /* join condition not captured in parsed metadata */
;

Learn More