I_ChangeDocumentItemExtension

DDL: I_CHANGEDOCSTR SQL: IBCCHANGESTR Type: view BASIC Package: SZD

Änderungsbelege für Strings

I_ChangeDocumentItemExtension is a Basic CDS View that provides data about "Änderungsbelege für Strings" in SAP S/4HANA. It reads from 1 data source (cdpos_str) and exposes 9 fields with key field ChangeDocKeyGuid. Part of development package SZD.

Data Sources (1)

SourceAliasJoin Type
cdpos_str cdpos_str from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName IBCCHANGESTR view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Änderungsbelege für Strings view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocKeyGuid cdpos_str keyguid UUID
ChangeDocStringNew cdpos_str value_new New Value
ChangeDocStringOld cdpos_str value_old Old Value
ChangeDocRawStringNew cdpos_str value_rawstr_new CDRAWSTRING_NEW
ChangeDocRawStringOld cdpos_str value_rawstr_old CDRAWSTRING_OLD
ChangeDocShortStringNew cdpos_str value_shstr_new CDSHORTSTRING_NEW
ChangeDocShortStringOld cdpos_str value_shstr_old CDSHORTSTRING_OLD
ChangeDocTableKey cdpos_str tabkey Table Keys
ChangeDocTabkeyLength

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 I_ChangeDocumentItemExtension.
-- 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: IBCCHANGESTR

CREATE VIEW I_ChangeDocumentItemExtension AS
SELECT
  cdpos_str.keyguid AS ChangeDocKeyGuid,
  cdpos_str.value_new AS ChangeDocStringNew,
  cdpos_str.value_old AS ChangeDocStringOld,
  cdpos_str.value_rawstr_new AS ChangeDocRawStringNew,
  cdpos_str.value_rawstr_old AS ChangeDocRawStringOld,
  cdpos_str.value_shstr_new AS ChangeDocShortStringNew,
  cdpos_str.value_shstr_old AS ChangeDocShortStringOld,
  cdpos_str.tabkey AS ChangeDocTableKey,
  cast ( length( cdpos_str.tabkey ) as cdpos_count ) AS ChangeDocTabkeyLength
FROM cdpos_str
;