I_DFS_OrglMeasureChangeDocItem

DDL: I_DFS_ORGLMEASURECHANGEDOCITEM SQL: IDFSORGMCDPOS Type: view BASIC
18 Fields 1 Data Sources 5 Associations 1 OData Services

Change document items

I_DFS_OrglMeasureChangeDocItem is a Basic CDS View that provides data about "Change document items" in SAP S/4HANA. It reads from 1 data source (cdpos) and exposes 18 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. It has 5 associations to related views. It is exposed through 1 OData service (UI_DFS_MEASURE).

Data Sources (1)

SourceAliasJoin Type
cdpos cdpos from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_DFS_OrglMeasureChangeDoc _ChangeDocument $projection.ChangeDocObjectClass = _ChangeDocument.ChangeDocObjectClass and $projection.ChangeDocObject = _ChangeDocument.ChangeDocObject and $projection.ChangeDocument = _ChangeDocument.ChangeDocument
[0..1] I_ChangeDocLongTableKey _ChangeDocLongTableKey $projection.ChangeDocTableKey = _ChangeDocLongTableKey.ChangeDocKeyGuid
[0..1] I_ChangeDocumentItemExtension _ChangeDocumentItemExtension $projection.ChangeDocTableKey = _ChangeDocumentItemExtension.ChangeDocKeyGuid
[0..1] I_ChangeDocFieldNames _ChangeDocFieldNames $projection.DatabaseTable = _ChangeDocFieldNames.DatabaseTable and $projection.ChangeDocDatabaseTableField = _ChangeDocFieldNames.Value
[0..1] I_ChangeDocTable _ChangeDocTable $projection.DatabaseTable = _ChangeDocTable.Value

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName IDFSORGMCDPOS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Change document items view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view

OData Services (1)

ServiceBindingVersionContractRelease
UI_DFS_MEASURE UI_NBD_DFS_MEASURE V2 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject cdpos objectid Object Value
KEY ChangeDocObjectClass cdpos objectclas Change Doc. Object
KEY ChangeDocument cdpos changenr Change Document
KEY DatabaseTable cdpos tabname Table/Constant Value
KEY ChangeDocTableKey cdpos tabkey Table Keys
KEY ChangeDocDatabaseTableField cdpos fname User
KEY ChangeDocItemChangeType cdpos chngind Change Indicator
DatabaseTableText _ChangeDocTable Text Database Table
TextendasABAPDataElementDescription Database Table Field
ChangeDocPreviousUnit cdpos unit_old Unit
ChangeDocNewUnit cdpos unit_new Unit
ChangeDocPreviousCurrency cdpos cuky_old CUKY
ChangeDocNewCurrency cdpos cuky_new CUKY
ChangeDocNewFieldValue cdpos value_new New Value
ChangeDocPreviousFieldValue cdpos value_old Old Value
_ChangeDocument _ChangeDocument
_ChangeDocLongTableKey _ChangeDocLongTableKey
_ChangeDocumentItemExtension _ChangeDocumentItemExtension

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_DFS_OrglMeasureChangeDocItem.
-- 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: IDFSORGMCDPOS

CREATE VIEW I_DFS_OrglMeasureChangeDocItem AS
SELECT
  cdpos.objectid AS ChangeDocObject,
  cdpos.objectclas AS ChangeDocObjectClass,
  cdpos.changenr AS ChangeDocument,
  cdpos.tabname AS DatabaseTable,
  cdpos.tabkey AS ChangeDocTableKey,
  cdpos.fname AS ChangeDocDatabaseTableField,
  cdpos.chngind AS ChangeDocItemChangeType,
  _ChangeDocTable.Text AS DatabaseTableText,
  case when( cdpos.fname = 'FORCEELEMENTORGSRCEUUID') then 'Force Element Source UUID' when( cdpos.fname = 'FORCEELEMENTORGSRCEID') then 'Force Element Source ID' when( cdpos.fname = 'FORCEELEMENTORGTARGETUUID') then 'Force Element Target UUID' when( cdpos.fname = 'FORCEELEMENTORGTARGETID') then 'Force Element Target ID' when( cdpos.fname = 'DFSASSGMTSTATUSOBJECT') then 'Status Object ID' when( cdpos.fname = 'DFSASSGMTUSAGETYPE') then 'Force Element Usage Type' else _ChangeDocFieldNames.Text end as ABAPDataElementDescription AS TextendasABAPDataElementDescription,
  cdpos.unit_old AS ChangeDocPreviousUnit,
  cdpos.unit_new AS ChangeDocNewUnit,
  cdpos.cuky_old AS ChangeDocPreviousCurrency,
  cdpos.cuky_new AS ChangeDocNewCurrency,
  cdpos.value_new AS ChangeDocNewFieldValue,
  cdpos.value_old AS ChangeDocPreviousFieldValue
FROM cdpos
LEFT OUTER JOIN I_DFS_OrglMeasureChangeDoc AS _ChangeDocument ON ChangeDocObjectClass = _ChangeDocument.ChangeDocObjectClass AND ChangeDocObject = _ChangeDocument.ChangeDocObject AND ChangeDocument = _ChangeDocument.ChangeDocument  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocLongTableKey AS _ChangeDocLongTableKey ON ChangeDocTableKey = _ChangeDocLongTableKey.ChangeDocKeyGuid  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocumentItemExtension AS _ChangeDocumentItemExtension ON ChangeDocTableKey = _ChangeDocumentItemExtension.ChangeDocKeyGuid  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocFieldNames AS _ChangeDocFieldNames ON DatabaseTable = _ChangeDocFieldNames.DatabaseTable AND ChangeDocDatabaseTableField = _ChangeDocFieldNames.Value  -- association [0..1]
LEFT OUTER JOIN I_ChangeDocTable AS _ChangeDocTable ON DatabaseTable = _ChangeDocTable.Value  -- association [0..1]
;

Learn More