C_FinanceNotificationTP

DDL: C_FINANCENOTIFICATIONTP Type: view_entity CONSUMPTION
39 Fields 1 Data Sources

Finance Notification

C_FinanceNotificationTP is a Consumption CDS View that provides data about "Finance Notification" in SAP S/4HANA. It reads from 1 data source (R_FinanceNotificationTP) and exposes 39 fields with key field FinanceNotificationUUID.

Data Sources (1)

SourceAliasJoin Type
R_FinanceNotificationTP R_FinanceNotificationTP projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Finance Notification view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name FinanceNotification view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewCompositions true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Search.searchable true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY FinanceNotificationUUID FinanceNotificationUUID
FinanceNotificationType FinanceNotificationType
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocumentOID ReferenceDocumentOID
ReferenceDocumentDisplayID ReferenceDocumentDisplayID
ReferenceDocumentEventOID ReferenceDocumentEventOID
RefDocumentEventDisplayID RefDocumentEventDisplayID
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
CompanyCode CompanyCode Receiver Company Code
PostingDate PostingDate Posting Date for GR
FinanceNotifProcessingStatus FinanceNotifProcessingStatus
IsReversal IsReversal Reversal doc.
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LocalInstanceLastChangedByUser LocalInstanceLastChangedByUser
LoclInstanceLastChangeDateTime LoclInstanceLastChangeDateTime Changed On
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LogMessageText LogMessageText
ApplicationLogHandle ApplicationLogHandle Log Handle
LatestMessageClass LatestMessageClass
LatestMessageNumber LatestMessageNumber
LatestMessageSeverity LatestMessageSeverity
LatestMessageVariable1Text LatestMessageVariable1Text
LatestMessageVariable2Text LatestMessageVariable2Text
LatestMessageVariable3Text LatestMessageVariable3Text
LatestMessageVariable4Text LatestMessageVariable4Text
StatusCriticality StatusCriticality
FinanceNotificationTypeText
ReferenceDocumentTypeName
CompanyCodeName _CompanyCode CompanyCodeName Company Name
FinanceNotifProcgStatusText
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_LocalChangedByUser _LocalChangedByUser
_CompanyCode _CompanyCode
_NotificationType _NotificationType
_ReferenceDocumentType _ReferenceDocumentType
_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_FinanceNotificationTP.
-- 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_FinanceNotificationTP AS
SELECT
  FinanceNotificationUUID,
  FinanceNotificationType,
  ReferenceDocumentType,
  ReferenceDocumentOID,
  ReferenceDocumentDisplayID,
  ReferenceDocumentEventOID,
  RefDocumentEventDisplayID,
  ReferenceDocumentLogicalSystem,
  CompanyCode,
  PostingDate,
  FinanceNotifProcessingStatus,
  IsReversal,
  CreatedByUser,
  CreationDateTime,
  LocalInstanceLastChangedByUser,
  LoclInstanceLastChangeDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  LogMessageText,
  ApplicationLogHandle,
  LatestMessageClass,
  LatestMessageNumber,
  LatestMessageSeverity,
  LatestMessageVariable1Text,
  LatestMessageVariable2Text,
  LatestMessageVariable3Text,
  LatestMessageVariable4Text,
  StatusCriticality,
  _NotificationType._Text[1:Language=$session.system_language].FinanceNotificationTypeText AS FinanceNotificationTypeText,
  _ReferenceDocumentType._ReferenceDocumentTypeText[1:Language=$session.system_language].ReferenceDocumentTypeName AS ReferenceDocumentTypeName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ProcessingStatus._Text[1:Language=$session.system_language].FinanceNotifProcgStatusText AS FinanceNotifProcgStatusText
FROM R_FinanceNotificationTP
;

Learn More