C_AccountingNotificationTP

DDL: C_ACCOUNTINGNOTIFICATIONTP Type: view_entity CONSUMPTION
36 Fields 1 Data Sources 1 OData Services

Accounting Notification

C_AccountingNotificationTP is a Consumption CDS View that provides data about "Accounting Notification" in SAP S/4HANA. It reads from 1 data source (R_AccountingNotificationTP) and exposes 36 fields with key field AccountingNotificationUUID. It is exposed through 1 OData service (UI_FIN_MNGACCNOTIF).

Data Sources (1)

SourceAliasJoin Type
R_AccountingNotificationTP R_AccountingNotificationTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Accounting Notification view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name AccountingNotification_Type view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Search.searchable true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_FIN_MNGACCNOTIF UI_FIN_MNGACCNOTIF V4 C1 NOT_RELEASED

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY AccountingNotificationUUID AccountingNotificationUUID
AccountingNotificationType AccountingNotificationType
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
RefDocLastChangeDateTime RefDocLastChangeDateTime
LeadingCompanyCode LeadingCompanyCode
ProposedPostingDate ProposedPostingDate
AcctgNotifProcessingStatus AcctgNotifProcessingStatus
AcctgNotifProcessingStatusNamelocalized
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
virtualSystemMessageTextnatxt
_LeadingCompanyCode _LeadingCompanyCode
_ReferenceDocumentType _ReferenceDocumentType
_AccountingNotificationType _AccountingNotificationType
_AcctgNotifTypeRefDocType _AcctgNotifTypeRefDocType
_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 C_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 C_AccountingNotificationTP AS
SELECT
  AccountingNotificationUUID,
  AccountingNotificationType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentItem,
  ReferenceDocumentLogicalSystem,
  CreationDateTime,
  ReferenceDocumentOID,
  ReferenceDocumentDisplayID,
  RefDocLastChangeDateTime,
  LeadingCompanyCode,
  ProposedPostingDate,
  AcctgNotifProcessingStatus,
  _ProcessingStatus._Text.AcctgNotifProcessingStatusName : localized AS AcctgNotifProcessingStatusNamelocalized,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  ApplicationLogHandle,
  LatestMessageClass,
  LatestMessageNumber,
  LatestMessageSeverity,
  LatestMessageVariable1Text,
  LatestMessageVariable2Text,
  LatestMessageVariable3Text,
  LatestMessageVariable4Text,
  IsReversal,
  StatusCriticality,
  virtual SystemMessageText : natxt AS virtualSystemMessageTextnatxt
FROM R_AccountingNotificationTP
;

Learn More