C_ProductClassAssignmentProcTP

DDL: C_PRODUCTCLASSASSIGNMENTPROCTP Type: view_entity CONSUMPTION
33 Fields 1 Data Sources

Product Class Assignment Process

C_ProductClassAssignmentProcTP is a Consumption CDS View that provides data about "Product Class Assignment Process" in SAP S/4HANA. It reads from 1 data source (I_ProductClassAssignmentProcTP) and exposes 33 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, ClfnObjectType.

Data Sources (1)

SourceAliasJoin Type
I_ProductClassAssignmentProcTP I_ProductClassAssignmentProcTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
EndUserText.label Product Class Assignment Process view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY ClfnObjectType ClfnObjectType Object/Class
KEY ClassType ClassType X Flag
KEY TimeIntervalNumber TimeIntervalNumber Int. counter
KEY MDChgProcSrceObjClass MDChgProcSrceObjClass Int class no.
Class Class User Group
ClassInternalID ClassInternalID Int class no.
ClassPositionNumber ClassPositionNumber Pos.
ClfnStatus ClfnStatus Status
ClassIsStandardClass ClassIsStandardClass Class Is Standard Class
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
MDChgProcessSourceModified MDChgProcessSourceModified Modified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
Product _Product Product Product Sold
ProductDescriptionlocalized
RecordIdentificationText _Product Product Product Sold
MDChgProcKPIUpdateStatusText _KPIUpdateStatusText MDChangeProcKPIValueKeyDesc
MDChgProcKPIUpdateStatus MDChgProcKPIUpdateStatus
MDChgProcKPIRecordTypeText
MDChgProcKPIRecordType
MDChgProcKPIRecordStatusText
MDChgProcessValidationStatus _Product MDChgProcessValidationStatus
sstring260
virtualMDChangeProcessMessageTypesymsgty Message Type
virtualMDChangeProcessMessageIDmsgid Log Message Class
virtualMDChangeProcessMessageNumbermsgno Log Message Number
MDChgProcessActivationTarget _Product MDChgProcessActivationTarget Activation Result
MDChgProcKPIRecordTargetText
MDChgProcessReplicationStatus _Product MDChgProcessReplicationStatus
MDChgProcReplicationStatusText

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 C_ProductClassAssignmentProcTP.
-- 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 C_ProductClassAssignmentProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  ClfnObjectType,
  ClassType,
  TimeIntervalNumber,
  MDChgProcSrceObjClass,
  Class,
  ClassInternalID,
  ClassPositionNumber,
  ClfnStatus,
  ClassIsStandardClass,
  MDChgProcSrceLastChgdDateTime,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  _Product.Product AS Product,
  _Product._ProductDescription.ProductDescription : localized AS ProductDescriptionlocalized,
  _Product.Product AS RecordIdentificationText,
  _KPIUpdateStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIUpdateStatusText,
  MDChgProcKPIUpdateStatus,
  _Product._RecordType._KPIRecordTypeText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTypeText,
  _Product._RecordType.MDChgProcKPIRecordType AS MDChgProcKPIRecordType,
  _Product._KPIRecordStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordStatusText,
  _Product.MDChgProcessValidationStatus AS MDChgProcessValidationStatus,
  virtual MDChgProcModifdObjectsCount : abap.sstring( 260 ) AS sstring260,
  virtual MDChangeProcessMessageType : symsgty AS virtualMDChangeProcessMessageTypesymsgty,
  virtual MDChangeProcessMessageID : msgid AS virtualMDChangeProcessMessageIDmsgid,
  virtual MDChangeProcessMessageNumber : msgno AS virtualMDChangeProcessMessageNumbermsgno,
  _Product.MDChgProcessActivationTarget AS MDChgProcessActivationTarget,
  _Product._RecordTargetText.MDChangeProcKPIValueKeyDesc AS MDChgProcKPIRecordTargetText,
  _Product.MDChgProcessReplicationStatus AS MDChgProcessReplicationStatus,
  _Product._ReplicationStatusText.MDChangeProcKPIValueKeyDesc AS MDChgProcReplicationStatusText
FROM I_ProductClassAssignmentProcTP
;

Learn More