P_PaymentRequests

DDL: P_PAYMENTREQUESTS SQL: PPAYMENTREQUESTS Type: view BASIC

P_PaymentRequests is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (fqmc_activation) and exposes 14 fields with key field PaymentRequest. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
fqmc_activation fqmc_activation inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_RepetitiveCode _RepetitiveCode $projection.PayingCompanyCode = _RepetitiveCode.PayingCompanyCode and $projection.HouseBank = _RepetitiveCode.HouseBank and $projection.PaymentCode = _RepetitiveCode.RepetitiveCode

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PPAYMENTREQUESTS view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropogatedAnnotations true view
AbapCatalog.preserveKey true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PaymentRequest payrq keyno
PayingCompanyCode payrq zbukr
SendingCompanyCode payrq absbu
HouseBank payrq hbkid
HouseBankAccount payrq hktid
ClearingDocument payrq augbl
PaymentMethod payrq zwels
UserName payrq usnam
DocumentItemText payrq sgtxt
PaymentOrigin payrq origin
CompanyCode payrq bukrs
FinancialAccountType payrq koart
PaymentCode payrq rfttrn
_RepetitiveCode _RepetitiveCode 
@VDM.private: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PPAYMENTREQUESTS'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropogatedAnnotations: true
@AbapCatalog.preserveKey:true
define view P_PaymentRequests
  as select distinct from payrq
    inner join fqmc_activation
        on payrq.zbukr = fqmc_activation.company_code
        and fqmc_activation.activation_status = '1'
        and ( fqmc_activation.origin_application = 'FI' or fqmc_activation.origin_application = 'BKPF' )          

  association [0..1] to P_RepetitiveCode as _RepetitiveCode on  $projection.PayingCompanyCode = _RepetitiveCode.PayingCompanyCode
                                                            and $projection.HouseBank         = _RepetitiveCode.HouseBank
                                                            and $projection.PaymentCode       = _RepetitiveCode.RepetitiveCode


{
  key payrq.keyno                            as PaymentRequest,
      payrq.zbukr                            as PayingCompanyCode,
      payrq.absbu                            as SendingCompanyCode,
      payrq.hbkid                            as HouseBank,
      payrq.hktid                            as HouseBankAccount,
      payrq.augbl                            as ClearingDocument,
      payrq.zwels                            as PaymentMethod,
      payrq.usnam                            as UserName,
      payrq.sgtxt                            as DocumentItemText,
      payrq.origin                           as PaymentOrigin,
      payrq.bukrs                            as CompanyCode,
      payrq.koart                            as FinancialAccountType,
      payrq.rfttrn                           as PaymentCode,

      _RepetitiveCode


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FQMC_ACTIVATION",
"PAYRQ"
],
"ASSOCIATED":
[
"P_REPETITIVECODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More