I_FinanceNotifProcStepMessage

DDL: I_FINANCENOTIFPROCSTEPMESSAGE Type: view_entity COMPOSITE

Trigger object for finance notif step

I_FinanceNotifProcStepMessage is a Composite CDS View that provides data about "Trigger object for finance notif step" in SAP S/4HANA. It reads from 2 data sources (I_FinanceNotification, I_FinanceNotifProcessStep) and exposes 25 fields with key field FinanceNotifProcessStepUUID.

Data Sources (2)

SourceAliasJoin Type
I_FinanceNotification _FinanceNotif inner
I_FinanceNotifProcessStep _ProcessStep from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Trigger object for finance notif step view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY FinanceNotifProcessStepUUID I_FinanceNotifProcessStep FinanceNotifProcessStepUUID
LogMessageText I_FinanceNotifProcessStep LogMessageText Message Text
FinanceNotifMessageUniqueKey I_FinanceNotifProcessStep FinanceNotifMessageUniqueKey
FinanceNotificationUUID I_FinanceNotifProcessStep FinanceNotificationUUID
FinanceNotificationProcessStep I_FinanceNotifProcessStep FinanceNotificationProcessStep
FinanceComponent I_FinanceNotifProcessStep FinanceComponent
FinanceCompProcessingStatus I_FinanceNotifProcessStep FinanceCompProcessingStatus
FinanceCompNotificationUUID I_FinanceNotifProcessStep FinanceCompNotificationUUID
ApplicationLogHandle I_FinanceNotifProcessStep ApplicationLogHandle Log Handle
LatestMessageClass I_FinanceNotifProcessStep LatestMessageClass Message Class
LatestMessageNumber I_FinanceNotifProcessStep LatestMessageNumber Message Number
LatestMessageSeverity I_FinanceNotifProcessStep LatestMessageSeverity Message Severity
LatestMessageVariable1Text I_FinanceNotifProcessStep LatestMessageVariable1Text Message Variable 1
LatestMessageVariable2Text I_FinanceNotifProcessStep LatestMessageVariable2Text Message Variable 2
LatestMessageVariable3Text I_FinanceNotifProcessStep LatestMessageVariable3Text Message Variable 3
LatestMessageVariable4Text I_FinanceNotifProcessStep LatestMessageVariable4Text Message Variable 4
FinanceNotificationType I_FinanceNotification FinanceNotificationType
ReferenceDocumentType I_FinanceNotification ReferenceDocumentType Reference Document Type
ReferenceDocumentOID I_FinanceNotification ReferenceDocumentOID Reference Doc.OID
ReferenceDocumentDisplayID I_FinanceNotification ReferenceDocumentDisplayID Reference Document Display ID
ReferenceDocumentEventOID I_FinanceNotification ReferenceDocumentEventOID
RefDocumentEventDisplayID I_FinanceNotification RefDocumentEventDisplayID
ReferenceDocumentLogicalSystem I_FinanceNotification ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
CompanyCode I_FinanceNotification CompanyCode Receiver Company Code
PostingDate I_FinanceNotification PostingDate Posting Date for GR

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 I_FinanceNotifProcStepMessage.
-- 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 I_FinanceNotifProcStepMessage AS
SELECT
  _ProcessStep.FinanceNotifProcessStepUUID AS FinanceNotifProcessStepUUID,
  _ProcessStep.LogMessageText AS LogMessageText,
  _ProcessStep.FinanceNotifMessageUniqueKey AS FinanceNotifMessageUniqueKey,
  _ProcessStep.FinanceNotificationUUID AS FinanceNotificationUUID,
  _ProcessStep.FinanceNotificationProcessStep AS FinanceNotificationProcessStep,
  _ProcessStep.FinanceComponent AS FinanceComponent,
  _ProcessStep.FinanceCompProcessingStatus AS FinanceCompProcessingStatus,
  _ProcessStep.FinanceCompNotificationUUID AS FinanceCompNotificationUUID,
  _ProcessStep.ApplicationLogHandle AS ApplicationLogHandle,
  _ProcessStep.LatestMessageClass AS LatestMessageClass,
  _ProcessStep.LatestMessageNumber AS LatestMessageNumber,
  _ProcessStep.LatestMessageSeverity AS LatestMessageSeverity,
  _ProcessStep.LatestMessageVariable1Text AS LatestMessageVariable1Text,
  _ProcessStep.LatestMessageVariable2Text AS LatestMessageVariable2Text,
  _ProcessStep.LatestMessageVariable3Text AS LatestMessageVariable3Text,
  _ProcessStep.LatestMessageVariable4Text AS LatestMessageVariable4Text,
  _FinanceNotif.FinanceNotificationType AS FinanceNotificationType,
  _FinanceNotif.ReferenceDocumentType AS ReferenceDocumentType,
  _FinanceNotif.ReferenceDocumentOID AS ReferenceDocumentOID,
  _FinanceNotif.ReferenceDocumentDisplayID AS ReferenceDocumentDisplayID,
  _FinanceNotif.ReferenceDocumentEventOID AS ReferenceDocumentEventOID,
  _FinanceNotif.RefDocumentEventDisplayID AS RefDocumentEventDisplayID,
  _FinanceNotif.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _FinanceNotif.CompanyCode AS CompanyCode,
  _FinanceNotif.PostingDate AS PostingDate
FROM I_FinanceNotifProcessStep AS _ProcessStep
INNER JOIN I_FinanceNotification AS _FinanceNotif ON /* join condition not captured in parsed metadata */
;