C_ProductUnitOfMeasureProcTP

DDL: C_PRODUCTUNITOFMEASUREPROCTP Type: view_entity CONSUMPTION
43 Fields 1 Data Sources

C_ProductUnitOfMeasureProcTP is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ProductUnitOfMeasureProcTP) and exposes 43 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AlternativeUnit.

Data Sources (1)

SourceAliasJoin Type
I_ProductUnitOfMeasureProcTP I_ProductUnitOfMeasureProcTP projection

Annotations (6)

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

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Source ID
KEY AlternativeUnit AlternativeUnit Base UoM
UnitOfMeasureNamelocalized
QuantityNumerator QuantityNumerator Units / Quantity - Base Unit of Measure
QuantityDenominator QuantityDenominator Units / Quantity - Alt Unit of Measure
GlobalTradeItemNumber GlobalTradeItemNumber GTIN
GlobalTradeItemNumberCategory GlobalTradeItemNumberCategory GTIN Category
UnitSpecificProductLength UnitSpecificProductLength Length
UnitSpecificProductWidth UnitSpecificProductWidth Width
UnitSpecificProductHeight UnitSpecificProductHeight Height
ProductMeasurementUnit ProductMeasurementUnit Unit
MaterialVolume MaterialVolume Volume
VolumeUnit VolumeUnit Volume Unit
GrossWeight GrossWeight Total Weight
WeightUnit WeightUnit Weight unit
LowerLevelPackagingUnit LowerLevelPackagingUnit Lower-lev. unit
MaximumStackingFactor MaximumStackingFactor Max. Stack Fact
CapacityUsage CapacityUsage Capac. Usage
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
_RecordMessages _RecordMessages
_Changes _Changes

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_ProductUnitOfMeasureProcTP.
-- 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_ProductUnitOfMeasureProcTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AlternativeUnit,
  _AlternativeUnitOfMeasure._Text.UnitOfMeasureName : localized AS UnitOfMeasureNamelocalized,
  QuantityNumerator,
  QuantityDenominator,
  GlobalTradeItemNumber,
  GlobalTradeItemNumberCategory,
  UnitSpecificProductLength,
  UnitSpecificProductWidth,
  UnitSpecificProductHeight,
  ProductMeasurementUnit,
  MaterialVolume,
  VolumeUnit,
  GrossWeight,
  WeightUnit,
  LowerLevelPackagingUnit,
  MaximumStackingFactor,
  CapacityUsage,
  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_ProductUnitOfMeasureProcTP
;

Learn More