I_IncomingPaymentFile
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)
| Source | Alias | Join Type |
|---|---|---|
| far_ipf_header | far_ipf_header | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA