I_IncomingPaymentFile

DDL: I_INCOMINGPAYMENTFILE SQL: IINCPMNTFILE Type: view BASIC

Incoming Payment File

I_IncomingPaymentFile is a Basic CDS View that provides data about "Incoming Payment File" in SAP S/4HANA. It reads from 1 data source (far_ipf_header) and exposes 22 fields with key field IncomingPaymentFile. It has 8 associations to related views.

Data Sources (1)

SourceAliasJoin Type
far_ipf_header far_ipf_header from

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_UserContactCard _UserContactCard $projection.UploadedByUser = _UserContactCard.ContactCardID
[1..1] I_IncomingPaymentFileStatus _IncomingPaymentFileStatus $projection.IncomingPaymentFileStatus = _IncomingPaymentFileStatus.IncomingPaymentFileStatus
[1..1] I_ElectronicBankStmntFormat _ElectronicBankStmntFormat $projection.ElectronicBankStatementFormat = _ElectronicBankStmntFormat.ElectronicBankStatementFormat
[1..1] I_IncomingPaytFileUploadType _IncomingPaytFileUploadType $projection.IncomingPaymentFileUploadType = _IncomingPaytFileUploadType.IncomingPaymentFileUploadType
[1..1] I_IncomingPaytFileType _IncomingPaytFileType $projection.IncomingPaymentFileType = _IncomingPaytFileType.IncomingPaymentFileType
[1..1] I_IncomingPaymentFileFormat _IncomingPaymentFileFormat $projection.ElectronicBankStatementFormat = _IncomingPaymentFileFormat.ElectronicBankStatementFormat and $projection.ElectronicBankStmntLongFormat = _IncomingPaymentFileFormat.ElectronicBankStmntLongFormat and $projection.PaymentTransactionTypeGroup = _IncomingPaymentFileFormat.PaymentTransactionTypeGroup
[1..1] I_PaymentRejectionFormat _PaymentRejectionFormat $projection.ElectronicBankStatementFormat = _PaymentRejectionFormat.ElectronicBankStatementFormat and $projection.ElectronicBankStmntLongFormat = _PaymentRejectionFormat.ElectronicBankStmntLongFormat and $projection.PaymentTransactionTypeGroup = _PaymentRejectionFormat.PaymentTransactionTypeGroup
[0..*] I_IncomingPaymentFileLine _IncomingPaymentFileLine $projection.IncomingPaymentFile = _IncomingPaymentFileLine.IncomingPaymentFile

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName IINCPMNTFILE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Incoming Payment File view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY IncomingPaymentFile incomingpaymentfileid
IncomingPaymentFileType incomingpaymentfiletype
ElectronicBankStatementFormat bankstatementformat
ElectronicBankStmntLongFormat bankstatementformatlong
PaymentTransactionTypeGroup paymenttransactiontypegroup
IncomingPaymentFileStatus incomingpaymentfilestatus
IncgPaytFileTotalNumberOfItems incomingpaymentfiletotalitems
IncomingPaymentFileName incomingpaymentfilename
UploadedByUser uploadedbyuser
IncomingPaymentFileUploadType uploadtype
IncomingPaytFileUploadDateTime uploaddatetime
SAPOfficeDocument documentid
BankStmntImprtParamSet parametersetid
IncomingPaymentFileConverter converterid
_UserContactCard _UserContactCard
_IncomingPaymentFileLine _IncomingPaymentFileLine
_IncomingPaymentFileStatus _IncomingPaymentFileStatus
_ElectronicBankStmntFormat _ElectronicBankStmntFormat
_IncomingPaytFileUploadType _IncomingPaytFileUploadType
_IncomingPaymentFileFormat _IncomingPaymentFileFormat
_IncomingPaytFileType _IncomingPaytFileType
_PaymentRejectionFormat _PaymentRejectionFormat
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@AbapCatalog.sqlViewName: 'IINCPMNTFILE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Incoming Payment File'
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view I_IncomingPaymentFile as select from far_ipf_header
association [1..1] to I_UserContactCard           as _UserContactCard       on  $projection.UploadedByUser = _UserContactCard.ContactCardID 
association [1..1] to I_IncomingPaymentFileStatus as _IncomingPaymentFileStatus
                      on $projection.IncomingPaymentFileStatus = _IncomingPaymentFileStatus.IncomingPaymentFileStatus
                      
association [1..1] to I_ElectronicBankStmntFormat as _ElectronicBankStmntFormat
                      on $projection.ElectronicBankStatementFormat = _ElectronicBankStmntFormat.ElectronicBankStatementFormat
                      
association [1..1] to I_IncomingPaytFileUploadType as _IncomingPaytFileUploadType
                      on $projection.IncomingPaymentFileUploadType = _IncomingPaytFileUploadType.IncomingPaymentFileUploadType
                      
association [1..1] to I_IncomingPaytFileType as _IncomingPaytFileType
                      on $projection.IncomingPaymentFileType = _IncomingPaytFileType.IncomingPaymentFileType
                      
association [1..1] to I_IncomingPaymentFileFormat as _IncomingPaymentFileFormat
                      on  $projection.ElectronicBankStatementFormat = _IncomingPaymentFileFormat.ElectronicBankStatementFormat
                      and $projection.ElectronicBankStmntLongFormat = _IncomingPaymentFileFormat.ElectronicBankStmntLongFormat
                      and $projection.PaymentTransactionTypeGroup = _IncomingPaymentFileFormat.PaymentTransactionTypeGroup
                      
association [1..1] to I_PaymentRejectionFormat as _PaymentRejectionFormat
                      on  $projection.ElectronicBankStatementFormat = _PaymentRejectionFormat.ElectronicBankStatementFormat
                      and $projection.ElectronicBankStmntLongFormat = _PaymentRejectionFormat.ElectronicBankStmntLongFormat
                      and $projection.PaymentTransactionTypeGroup = _PaymentRejectionFormat.PaymentTransactionTypeGroup
                      
association [0..*] to I_IncomingPaymentFileLine   as _IncomingPaymentFileLine   
                      on $projection.IncomingPaymentFile = _IncomingPaymentFileLine.IncomingPaymentFile  {
                      
  key incomingpaymentfileid as IncomingPaymentFile,

  incomingpaymentfiletype as IncomingPaymentFileType,
  
  @ObjectModel.foreignKey.association: '_ElectronicBankStmntFormat'
  bankstatementformat as ElectronicBankStatementFormat,
  
  bankstatementformatlong as ElectronicBankStmntLongFormat,
  
  paymenttransactiontypegroup as PaymentTransactionTypeGroup,
  
  @ObjectModel.foreignKey.association: '_IncomingPaymentFileStatus'
  incomingpaymentfilestatus as IncomingPaymentFileStatus,
    
  incomingpaymentfiletotalitems as IncgPaytFileTotalNumberOfItems,
  
  incomingpaymentfilename as IncomingPaymentFileName,
  uploadedbyuser as UploadedByUser,
  
  @ObjectModel.foreignKey.association: '_IncomingPaytFileUploadType'
  uploadtype as IncomingPaymentFileUploadType,
  
  uploaddatetime as IncomingPaytFileUploadDateTime,
  
  documentid as SAPOfficeDocument,
  
  parametersetid as BankStmntImprtParamSet,
  
  converterid as IncomingPaymentFileConverter,
  
  _UserContactCard,
  _IncomingPaymentFileLine,
  _IncomingPaymentFileStatus,
  _ElectronicBankStmntFormat,
  _IncomingPaytFileUploadType,
  _IncomingPaymentFileFormat,
  _IncomingPaytFileType,
  _PaymentRejectionFormat  
  
}