C_AccountingNotification

DDL: C_ACCOUNTINGNOTIFICATION Type: view_entity CONSUMPTION
32 Fields 1 Data Sources 1 Associations

Accounting Notification

C_AccountingNotification 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 32 fields with key field AccountingNotificationUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_AccountingNotificationTP R_AccountingNotificationTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_AccrEngineAccrualsOverview _test $projection.LeadingCompanyCode = _test.CompanyCode

Annotations (9)

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.allowExtensions true view
Search.searchable true view

Fields (32)

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
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.
_LeadingCompanyCode _LeadingCompanyCode
_LeadingCompanyCodeText _LeadingCompanyCodeText
_ReferenceDocumentType _ReferenceDocumentType
_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_AccountingNotification.
-- 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_AccountingNotification AS
SELECT
  AccountingNotificationUUID,
  AccountingNotificationType,
  ReferenceDocumentType,
  ReferenceDocument,
  ReferenceDocumentContext,
  ReferenceDocumentItem,
  ReferenceDocumentLogicalSystem,
  CreationDateTime,
  ReferenceDocumentOID,
  ReferenceDocumentDisplayID,
  RefDocLastChangeDateTime,
  LeadingCompanyCode,
  ProposedPostingDate,
  AcctgNotifProcessingStatus,
  LastChangeDateTime,
  CreatedByUser,
  LastChangedByUser,
  ApplicationLogHandle,
  LatestMessageClass,
  LatestMessageNumber,
  LatestMessageSeverity,
  LatestMessageVariable1Text,
  LatestMessageVariable2Text,
  LatestMessageVariable3Text,
  LatestMessageVariable4Text,
  IsReversal
FROM R_AccountingNotificationTP
LEFT OUTER JOIN C_AccrEngineAccrualsOverview AS _test ON LeadingCompanyCode = _test.CompanyCode  -- association [0..1]
;

Learn More