P_ChgDocItmWithUUIDTableField

DDL: P_CHGDOCITMWITHUUIDTABLEFIELD Type: view_entity BASIC Package: PAL_COMMON
7 Fields 1 Data Sources

Change Document Item with UUID Table Field

P_ChgDocItmWithUUIDTableField is a Basic CDS View that provides data about "Change Document Item with UUID Table Field" in SAP S/4HANA. It reads from 1 data source (cdpos) and exposes 7 fields with key fields ChangeDocObject, ChangeDocObjectClass, ChangeDocument, DatabaseTable, ChangeDocTableKey. Part of development package PAL_COMMON.

Data Sources (1)

SourceAliasJoin Type
cdpos cdpos from

Parameters (3)

NameTypeDefault
P_ChangeDocObjectClass cdobjectcl
P_DatabaseTable tabname
P_DatabaseTableField fieldname

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Change Document Item with UUID Table Field view
VDM.viewType #BASIC view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ChangeDocObject cdpos objectid Object Value
KEY ChangeDocObjectClass cdpos objectclas Change Doc. Object
KEY ChangeDocument cdpos changenr Document Number
KEY DatabaseTable cdpos tabname Table/Constant Value
KEY ChangeDocTableKey cdpos tabkey Table Keys
KEY ChangeDocDatabaseTableField cdpos fname User
KEY ChangeDocItemChangeType cdpos chngind Change Indicator

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 P_ChgDocItmWithUUIDTableField.
-- 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.
-- Parameters: P_ChangeDocObjectClass : cdobjectcl, P_DatabaseTable : tabname, P_DatabaseTableField : fieldname

CREATE VIEW P_ChgDocItmWithUUIDTableField 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
FROM cdpos
;

Learn More