A_CntrlPurContrDistrMessages

DDL: A_CNTRLPURCONTRDISTRMESSAGES SQL: ADISTRMSGS Type: view BASIC
15 Fields 1 Data Sources 1 Associations

Distribution Message

A_CntrlPurContrDistrMessages is a Basic CDS View that provides data about "Distribution Message" in SAP S/4HANA. It reads from 1 data source (I_ExtendedPurgDocDistrMessages) and exposes 15 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
[1..1] A_CentralPurchaseContract _CentralPurchaseContract $projection.PurchasingDocument = _CentralPurchaseContract.CentralPurchaseContract

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ADISTRMSGS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Distribution Message view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API 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
Metadata.ignorePropagatedAnnotations true view

Fields (15)

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
SystemMessageText SystemMessageText Message Text
_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 A_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: ADISTRMSGS

CREATE VIEW A_CntrlPurContrDistrMessages AS
SELECT
  SequenceNumber,
  DistrResponseMessageUUID,
  PurchasingDocument,
  PurchasingDocumentCategory,
  ExtContractForPurg,
  LogicalSystem,
  SystemMessageType,
  SystemMessageIdentification,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  SystemMessageText
FROM I_ExtendedPurgDocDistrMessages
LEFT OUTER JOIN A_CentralPurchaseContract AS _CentralPurchaseContract ON PurchasingDocument = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
;

Learn More