C_CntrlPurContrDistrMessages

DDL: C_CNTRLPURCONTRDISTRMESSAGES SQL: CDISTRMSGS Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

View for Central Purchase Contract Distribution Messages

C_CntrlPurContrDistrMessages is a Consumption CDS View that provides data about "View for Central Purchase Contract Distribution Messages" in SAP S/4HANA. It reads from 1 data source (I_ExtendedPurgDocDistrMessages) and exposes 18 fields with key fields SequenceNumber, DistrResponseMessageUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ExtendedPurgDocDistrMessages I_ExtendedPurgDocDistrMessages from

Associations (1)

CardinalityTargetAliasCondition
[* ] C_DistrdContrForCntrlPurContr _DistrdContrForCntrlPurContr $projection.DistrResponseMessageUUID = _DistrdContrForCntrlPurContr.DistrResponseMessageUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CDISTRMSGS view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label View for Central Purchase Contract Distribution Messages view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SequenceNumber SequenceNumber Sort sequence
KEY DistrResponseMessageUUID DistrResponseMessageUUID GUID
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
ExtContractForPurg ExtContractForPurg Contract
LogicalSystem LogicalSystem Logical System
SystemMessageType SystemMessageType Message type
SystemMessageIdentification SystemMessageIdentification Message ID
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
PurgDocMsgParamName PurgDocMsgParamName Rule Parameter
PurgDocMsgParamLineVal PurgDocMsgParamLineVal Parameter line
SystemMessageText SystemMessageText Message Text
_DistrdContrForCntrlPurContr _DistrdContrForCntrlPurContr
_CentralPurchaseContract _CentralPurchaseContract

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_CntrlPurContrDistrMessages.
-- 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: CDISTRMSGS

CREATE VIEW C_CntrlPurContrDistrMessages AS
SELECT
  SequenceNumber,
  DistrResponseMessageUUID,
  PurchasingDocument,
  PurchasingDocumentCategory,
  ExtContractForPurg,
  LogicalSystem,
  SystemMessageType,
  SystemMessageIdentification,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  PurgDocMsgParamName,
  PurgDocMsgParamLineVal,
  SystemMessageText
FROM I_ExtendedPurgDocDistrMessages
LEFT OUTER JOIN C_DistrdContrForCntrlPurContr AS _DistrdContrForCntrlPurContr ON DistrResponseMessageUUID = _DistrdContrForCntrlPurContr.DistrResponseMessageUUID  -- association [* ]
;

Learn More