VFCLM_BAM_DDL_CDPOS_WITHDESP

DDL: FCLM_BAM_CDPOS_WITHDESP SQL: VFCLM_BAM_CDPDP Type: view Package: FCLM_BAM
14 Fields 3 Data Sources

Change Position With Description

VFCLM_BAM_DDL_CDPOS_WITHDESP is a CDS View that provides data about "Change Position With Description" in SAP S/4HANA. It reads from 3 data sources (VFCLM_BAM_DDL_CDPOS, dd04t, VFCLM_BAM_DDL_CHGIND) and exposes 14 fields with key fields AccountID, changenr, tabname, tabkey, fname. Part of development package FCLM_BAM.

Data Sources (3)

SourceAliasJoin Type
VFCLM_BAM_DDL_CDPOS cdpos from
dd04t dataelementtxt left_outer
VFCLM_BAM_DDL_CHGIND vfclm_bam_ddl_chgind left_outer

Parameters (1)

NameTypeDefault
plang abap.lang

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName VFCLM_BAM_CDPDP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY AccountID VFCLM_BAM_DDL_CDPOS AccountID Account no.
KEY changenr VFCLM_BAM_DDL_CDPOS changenr Document Number
KEY tabname VFCLM_BAM_DDL_CDPOS tabname Table/Constant Value
KEY tabkey VFCLM_BAM_DDL_CDPOS tabkey Table Keys
KEY fname VFCLM_BAM_DDL_CDPOS fname User
KEY chngind VFCLM_BAM_DDL_CDPOS chngind Change Indicator
text_case VFCLM_BAM_DDL_CDPOS text_case Text flag
unit_old VFCLM_BAM_DDL_CDPOS unit_old Unit
unit_new VFCLM_BAM_DDL_CDPOS unit_new Unit
cuky_old VFCLM_BAM_DDL_CDPOS cuky_old CUKY
cuky_new VFCLM_BAM_DDL_CDPOS cuky_new CUKY
value_new VFCLM_BAM_DDL_CDPOS value_new New Value
value_old VFCLM_BAM_DDL_CDPOS value_old Old Value
fnamedesp dd04t ddtext Short text

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 VFCLM_BAM_DDL_CDPOS_WITHDESP.
-- 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: VFCLM_BAM_CDPDP
-- Parameters: plang : abap.lang

CREATE VIEW VFCLM_BAM_DDL_CDPOS_WITHDESP AS
SELECT
  cdpos.AccountID AS AccountID,
  cdpos.changenr AS changenr,
  cdpos.tabname AS tabname,
  cdpos.tabkey AS tabkey,
  cdpos.fname AS fname,
  cdpos.chngind AS chngind,
  cdpos.text_case AS text_case,
  cdpos.unit_old AS unit_old,
  cdpos.unit_new AS unit_new,
  cdpos.cuky_old AS cuky_old,
  cdpos.cuky_new AS cuky_new,
  cdpos.value_new AS value_new,
  cdpos.value_old AS value_old,
  dataelementtxt.ddtext AS fnamedesp
FROM VFCLM_BAM_DDL_CDPOS AS cdpos
LEFT OUTER JOIN dd04t AS dataelementtxt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN VFCLM_BAM_DDL_CHGIND AS vfclm_bam_ddl_chgind ON /* join condition not captured in parsed metadata */
;

Learn More