I_IncomingPaymentFileLine

DDL: I_INCOMINGPAYMENTFILELINE SQL: IINCPMNTFLITM Type: view BASIC

Incoming Payment File Line Item

I_IncomingPaymentFileLine is a Basic CDS View that provides data about "Incoming Payment File Line Item" in SAP S/4HANA. It reads from 1 data source (far_ipf_line) and exposes 8 fields with key fields IncomingPaymentFile, BankStatementShortID. It has 4 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
far_ipf_line far_ipf_line from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_Arbankstatement _BankStatement $projection.BankStatementShortID = _BankStatement.BankStatementShortID
[0..*] I_Arbankstatementitem _BankStatementItem $projection.BankStatementShortID = _BankStatementItem.BankStatementShortID
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_IncomingPaymentFile _IncomingPaymentFile $projection.IncomingPaymentFile = _IncomingPaymentFile.IncomingPaymentFile

Annotations (9)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY IncomingPaymentFile incomingpaymentfileid
KEY BankStatementShortID
CompanyCode companycode
IncomingPaymentFileType _IncomingPaymentFile IncomingPaymentFileType
_BankStatement _BankStatement
_BankStatementItem _BankStatementItem
_CompanyCode _CompanyCode
_IncomingPaymentFile _IncomingPaymentFile 
@AbapCatalog.sqlViewName: 'IINCPMNTFLITM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Incoming Payment File Line Item'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_IncomingPaymentFileLine as select from far_ipf_line 
association [1..1] to I_Arbankstatement     as _BankStatement       on $projection.BankStatementShortID = _BankStatement.BankStatementShortID
association [0..*] to I_Arbankstatementitem as _BankStatementItem   on $projection.BankStatementShortID = _BankStatementItem.BankStatementShortID
association [1..1] to I_CompanyCode         as _CompanyCode         on $projection.CompanyCode = _CompanyCode.CompanyCode 
association [1..1] to I_IncomingPaymentFile as _IncomingPaymentFile on $projection.IncomingPaymentFile = _IncomingPaymentFile.IncomingPaymentFile 
 {
  
  key incomingpaymentfileid as IncomingPaymentFile, 
  key cast(bankstatementshortid as kukey_eb) as BankStatementShortID,  
  @ObjectModel.foreignKey.association: '_CompanyCode'
  @Consumption.valueHelpDefinition: [{ entity: { name : 'I_CompanyCodeStdVH', element : 'CompanyCode' } }]
  companycode as CompanyCode,
  _IncomingPaymentFile.IncomingPaymentFileType,
  
  _BankStatement,
  _BankStatementItem,
  _CompanyCode,
  _IncomingPaymentFile
  
}

Learn More