I_AccountingNotificationTP

DDL: I_ACCOUNTINGNOTIFICATIONTP Type: view_entity TRANSACTIONAL

Accounting Notification - TP

I_AccountingNotificationTP is a Transactional CDS View that provides data about "Accounting Notification - TP" in SAP S/4HANA. It reads from 1 data source (R_AccountingNotificationTP) and exposes 38 fields with key field AccountingNotificationUUID.

Data Sources (1)

SourceAliasJoin Type
R_AccountingNotificationTP R_AccountingNotificationTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Accounting Notification - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.sapObjectNodeType.name AccountingNotification view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY AccountingNotificationUUID AccountingNotificationUUID
FinanceNotificationUUID FinanceNotificationUUID
AccountingNotificationType AccountingNotificationType
FinanceNotificationType FinanceNotificationType
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
ReferenceDocumentItem ReferenceDocumentItem Reference item
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
CreationDateTime CreationDateTime Timestamp
ReferenceDocumentOID ReferenceDocumentOID
ReferenceDocumentDisplayID ReferenceDocumentDisplayID
ReferenceDocumentEventOID ReferenceDocumentEventOID
RefDocumentEventDisplayID RefDocumentEventDisplayID
RefDocLastChangeDateTime RefDocLastChangeDateTime
LeadingCompanyCode LeadingCompanyCode
ProposedPostingDate ProposedPostingDate
AcctgNotifProcessingStatus AcctgNotifProcessingStatus
LastChangeDateTime LastChangeDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
ApplicationLogHandle ApplicationLogHandle Log Handle
LatestMessageClass LatestMessageClass
LatestMessageNumber LatestMessageNumber
LatestMessageSeverity LatestMessageSeverity
LatestMessageVariable1Text LatestMessageVariable1Text
LatestMessageVariable2Text LatestMessageVariable2Text
LatestMessageVariable3Text LatestMessageVariable3Text
LatestMessageVariable4Text LatestMessageVariable4Text
IsReversal IsReversal Reversal doc.
StatusCriticality StatusCriticality
_LeadingCompanyCode _LeadingCompanyCode
_LeadingCompanyCodeText _LeadingCompanyCodeText
_ReferenceDocumentType _ReferenceDocumentType
_AccountingNotificationType _AccountingNotificationType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ProcessingStatus _ProcessingStatus

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_AccountingNotificationTP.
-- 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_AccountingNotificationTP AS
SELECT
  AccountingNotificationUUID,
  FinanceNotificationUUID,
  AccountingNotificationType,
  FinanceNotificationType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentItem,
  ReferenceDocumentLogicalSystem,
  CreationDateTime,
  ReferenceDocumentOID,
  ReferenceDocumentDisplayID,
  ReferenceDocumentEventOID,
  RefDocumentEventDisplayID,
  RefDocLastChangeDateTime,
  LeadingCompanyCode,
  ProposedPostingDate,
  AcctgNotifProcessingStatus,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  ApplicationLogHandle,
  LatestMessageClass,
  LatestMessageNumber,
  LatestMessageSeverity,
  LatestMessageVariable1Text,
  LatestMessageVariable2Text,
  LatestMessageVariable3Text,
  LatestMessageVariable4Text,
  IsReversal,
  StatusCriticality
FROM R_AccountingNotificationTP
;