I_CFinAAPurchasingMessage

DDL: I_CFINAAPURCHASINGMESSAGE Type: view_entity TRANSACTIONAL

CFinAA Purchasing Message

I_CFinAAPurchasingMessage is a Transactional CDS View that provides data about "CFinAA Purchasing Message" in SAP S/4HANA. It reads from 4 data sources (I_CFinAAPurgMngdAstCrtnMessage, I_CFinAAPurchasingValidItem, I_CFinAAMngdAstPostingMessage, I_CFinAAPurgItemUpdateMessage) and exposes 60 fields with key fields CFinAIFMessageUUID, CFinAIFMessageSerialNumber, CFinAIFMessageNamespace, CFinAIFMessageInterfaceName, CFinAIFMessageInterfaceVersion.

4 data source(s) 60 fields

Data Sources (4)

SourceAliasJoin Type
I_CFinAAPurgMngdAstCrtnMessage _AssetCreationMessage union_all
I_CFinAAPurchasingValidItem _ValidItem inner
I_CFinAAMngdAstPostingMessage I_CFinAAMngdAstPostingMessage union_all
I_CFinAAPurgItemUpdateMessage I_CFinAAPurgItemUpdateMessage from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label CFinAA Purchasing Message view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY CFinAIFMessageUUID CFinAIFMessageUUID
KEY CFinAIFMessageSerialNumber CFinAIFMessageSerialNumber
KEY CFinAIFMessageNamespace CFinAIFMessageNamespace
KEY CFinAIFMessageInterfaceName CFinAIFMessageInterfaceName
KEY CFinAIFMessageInterfaceVersion CFinAIFMessageInterfaceVersion
CFinAIFMessageProcessingStatus CFinAIFMessageProcessingStatus
CFinAIFMsgIndexCreationDate CFinAIFMsgIndexCreationDate
CFinAIFMsgIndexCreationTime CFinAIFMsgIndexCreationTime
CFinAIFMsgIdxCreationDateTime CFinAIFMsgIdxCreationDateTime
SenderLogicalSystem SenderLogicalSystem
CFinRpldPurchasingDocument CFinRpldPurchasingDocument
CFinRpldPurchasingDocumentItem CFinRpldPurchasingDocumentItem
SystemMessageType SystemMessageType
SystemMessageClass SystemMessageClass
SystemMessageNumber SystemMessageNumber
SystemMessageVariable1 SystemMessageVariable1
SystemMessageVariable2 SystemMessageVariable2
SystemMessageVariable3 SystemMessageVariable3
SystemMessageVariable4 SystemMessageVariable4
SystemMessageText SystemMessageText
CFinAIFMessageUUID
KEY CFinAIFMessageSerialNumber I_CFinAAPurgMngdAstCrtnMessage CFinAIFMessageSerialNumber
KEY CFinAIFMessageNamespace I_CFinAAPurgMngdAstCrtnMessage CFinAIFMessageNamespace
KEY CFinAIFMessageInterfaceName I_CFinAAPurgMngdAstCrtnMessage CFinAIFMessageInterfaceName
KEY CFinAIFMessageInterfaceVersion I_CFinAAPurgMngdAstCrtnMessage CFinAIFMessageInterfaceVersion
CFinAIFMessageProcessingStatus I_CFinAAPurgMngdAstCrtnMessage CFinAIFMessageProcessingStatus
CFinAIFMsgIndexCreationDate I_CFinAAPurgMngdAstCrtnMessage CFinAIFMsgIndexCreationDate
CFinAIFMsgIndexCreationTime I_CFinAAPurgMngdAstCrtnMessage CFinAIFMsgIndexCreationTime
CFinAIFMsgIdxCreationDateTime I_CFinAAPurgMngdAstCrtnMessage CFinAIFMsgIdxCreationDateTime
SenderLogicalSystem I_CFinAAPurchasingValidItem SenderLogicalSystem
CFinRpldPurchasingDocument I_CFinAAPurchasingValidItem CFinRpldPurchasingDocument
CFinRpldPurchasingDocumentItem I_CFinAAPurchasingValidItem CFinRpldPurchasingDocumentItem
SystemMessageType I_CFinAAPurgMngdAstCrtnMessage SystemMessageType
SystemMessageClass I_CFinAAPurgMngdAstCrtnMessage SystemMessageClass
SystemMessageNumber I_CFinAAPurgMngdAstCrtnMessage SystemMessageNumber
SystemMessageVariable1 I_CFinAAPurgMngdAstCrtnMessage SystemMessageVariable1
SystemMessageVariable2 I_CFinAAPurgMngdAstCrtnMessage SystemMessageVariable2
SystemMessageVariable3 I_CFinAAPurgMngdAstCrtnMessage SystemMessageVariable3
SystemMessageVariable4 I_CFinAAPurgMngdAstCrtnMessage SystemMessageVariable4
SystemMessageText I_CFinAAPurgMngdAstCrtnMessage SystemMessageText
KEY CFinAIFMessageSerialNumber CFinAIFMessageSerialNumber
KEY CFinAIFMessageNamespace CFinAIFMessageNamespace
KEY CFinAIFMessageInterfaceName CFinAIFMessageInterfaceName
KEY CFinAIFMessageInterfaceVersion CFinAIFMessageInterfaceVersion
CFinAIFMessageProcessingStatus CFinAIFMessageProcessingStatus
CFinAIFMsgIndexCreationDate CFinAIFMsgIndexCreationDate
CFinAIFMsgIndexCreationTime CFinAIFMsgIndexCreationTime
CFinAIFMsgIdxCreationDateTime CFinAIFMsgIdxCreationDateTime
SenderLogicalSystem SenderLogicalSystem
CFinRpldPurchasingDocument CFinRpldPurchasingDocument
CFinRpldPurchasingDocumentItem CFinRpldPurchasingDocumentItem
SystemMessageType SystemMessageType
SystemMessageClass SystemMessageClass
SystemMessageNumber SystemMessageNumber
SystemMessageVariable1 SystemMessageVariable1
SystemMessageVariable2 SystemMessageVariable2
SystemMessageVariable3 SystemMessageVariable3
SystemMessageVariable4 SystemMessageVariable4
SystemMessageText SystemMessageText
SystemMessageTemplateText SystemMessageTemplateText 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'CFinAA Purchasing Message'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType: #TRANSACTIONAL
define view entity I_CFinAAPurchasingMessage
  as select from I_CFinAAPurgItemUpdateMessage
{
  key  CFinAIFMessageUUID,
  key  CFinAIFMessageSerialNumber,
  key  CFinAIFMessageNamespace,
  key  CFinAIFMessageInterfaceName,
  key  CFinAIFMessageInterfaceVersion,
       CFinAIFMessageProcessingStatus,
       CFinAIFMsgIndexCreationDate,
       CFinAIFMsgIndexCreationTime,
       CFinAIFMsgIdxCreationDateTime,
       SenderLogicalSystem,
       CFinRpldPurchasingDocument,
       CFinRpldPurchasingDocumentItem,
       SystemMessageType,
       SystemMessageClass,
       SystemMessageNumber,
       SystemMessageVariable1,
       SystemMessageVariable2,
       SystemMessageVariable3,
       SystemMessageVariable4,
       SystemMessageText,
       SystemMessageTemplateText
}

union all

select from  I_CFinAAPurgMngdAstCrtnMessage as _AssetCreationMessage
  inner join I_CFinAAPurchasingValidItem    as _ValidItem on _AssetCreationMessage.CFinAIFMessageScenarioUUID = _ValidItem.CFinAAPurchasingValidItemUUID
{
  key  _AssetCreationMessage.CFinAIFMessageUUID,
  key  _AssetCreationMessage.CFinAIFMessageSerialNumber,
  key  _AssetCreationMessage.CFinAIFMessageNamespace,
  key  _AssetCreationMessage.CFinAIFMessageInterfaceName,
  key  _AssetCreationMessage.CFinAIFMessageInterfaceVersion,
       _AssetCreationMessage.CFinAIFMessageProcessingStatus,
       _AssetCreationMessage.CFinAIFMsgIndexCreationDate,
       _AssetCreationMessage.CFinAIFMsgIndexCreationTime,
       _AssetCreationMessage.CFinAIFMsgIdxCreationDateTime,
       _ValidItem.SenderLogicalSystem,
       _ValidItem.CFinRpldPurchasingDocument,
       _ValidItem.CFinRpldPurchasingDocumentItem,
       _AssetCreationMessage.SystemMessageType,
       _AssetCreationMessage.SystemMessageClass,
       _AssetCreationMessage.SystemMessageNumber,
       _AssetCreationMessage.SystemMessageVariable1,
       _AssetCreationMessage.SystemMessageVariable2,
       _AssetCreationMessage.SystemMessageVariable3,
       _AssetCreationMessage.SystemMessageVariable4,
       _AssetCreationMessage.SystemMessageText,
       _AssetCreationMessage.SystemMessageTemplateText
}

union all

select from I_CFinAAMngdAstPostingMessage
{
  key  CFinAIFMessageUUID,
  key  CFinAIFMessageSerialNumber,
  key  CFinAIFMessageNamespace,
  key  CFinAIFMessageInterfaceName,
  key  CFinAIFMessageInterfaceVersion,
       CFinAIFMessageProcessingStatus,
       CFinAIFMsgIndexCreationDate,
       CFinAIFMsgIndexCreationTime,
       CFinAIFMsgIdxCreationDateTime,
       SenderLogicalSystem,
       CFinRpldPurchasingDocument,
       CFinRpldPurchasingDocumentItem,
       SystemMessageType,
       SystemMessageClass,
       SystemMessageNumber,
       SystemMessageVariable1,
       SystemMessageVariable2,
       SystemMessageVariable3,
       SystemMessageVariable4,
       SystemMessageText,
       SystemMessageTemplateText
}

Learn More