I_GHOPlanChangeDocItem

DDL: I_GHOPLANCHANGEDOCITEM Type: view_entity BASIC
14 Fields 1 Data Sources 2 Associations

Plan Change Document Items

I_GHOPlanChangeDocItem is a Basic CDS View that provides data about "Plan Change Document Items" in SAP S/4HANA. It reads from 1 data source (pcdpos) and exposes 14 fields with key fields ChangeDocObjectClass, ChangeDocObject, ChangeDocument, DatabaseTable, ChangeDocumentTableKey. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
pcdpos pcdpos from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ReadDomainFixedValues _ChngIndDesc _ChngIndDesc.SAPDataDictionaryDomain = 'CDCHNGIND' and $projection.ChangeDocumentChangeType = _ChngIndDesc.DomainValue and _ChngIndDesc.LanguageCode = $session.system_language
[0..1] I_GHOTableFields _FieldDetails $projection.DatabaseTable = _FieldDetails.DatabaseTable and $projection.DatabaseTableField = _FieldDetails.DatabaseTableFieldName

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Plan Change Document Items view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObjectClass objectclas Change Doc. Object
KEY ChangeDocObject objectid Object Value
KEY ChangeDocument changenr Document Number
KEY DatabaseTable tabname Table/Constant Value
KEY ChangeDocumentTableKey tabkey Table Keys
KEY DatabaseTableField fname User
KEY ChangeDocumentChangeType chngind Change Indicator
ChangeDocTextIsChanged text_case Text flag
ChangeDocumentOldUnit unit_old Unit
ChangeDocumentNewUnit unit_new Unit
ChangedFieldNewValue
ChangedFieldOldValue
_ChngIndDesc _ChngIndDesc
_FieldDetails _FieldDetails

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_GHOPlanChangeDocItem.
-- 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.

CREATE VIEW I_GHOPlanChangeDocItem AS
SELECT
  objectclas AS ChangeDocObjectClass,
  objectid AS ChangeDocObject,
  changenr AS ChangeDocument,
  tabname AS DatabaseTable,
  tabkey AS ChangeDocumentTableKey,
  fname AS DatabaseTableField,
  chngind AS ChangeDocumentChangeType,
  text_case AS ChangeDocTextIsChanged,
  unit_old AS ChangeDocumentOldUnit,
  unit_new AS ChangeDocumentNewUnit,
  cast( ltrim(value_new, ' ' ) as gho_de_cdfldvalnew preserving type ) AS ChangedFieldNewValue,
  cast( ltrim(value_old, ' ' ) as gho_de_cdfldvalold preserving type ) AS ChangedFieldOldValue
FROM pcdpos
LEFT OUTER JOIN I_ReadDomainFixedValues AS _ChngIndDesc ON _ChngIndDesc.SAPDataDictionaryDomain = 'CDCHNGIND' AND ChangeDocumentChangeType = _ChngIndDesc.DomainValue AND _ChngIndDesc.LanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_GHOTableFields AS _FieldDetails ON DatabaseTable = _FieldDetails.DatabaseTable AND DatabaseTableField = _FieldDetails.DatabaseTableFieldName  -- association [0..1]
;

Learn More