I_CADocumentBPItemPaymentData

DDL: I_CADOCUMENTBPITEMPAYMENTDATA Type: view_entity BASIC Package: FKK_DOCUMENT

Document BP Item Payment Data

I_CADocumentBPItemPaymentData is a Basic CDS View that provides data about "Document BP Item Payment Data" in SAP S/4HANA. It reads from 1 data source (dfkkopc) and exposes 38 fields with key fields CADocumentNumber, CAGroupingForPayment. It has 5 associations to related views. Part of development package FKK_DOCUMENT.

Data Sources (1)

SourceAliasJoin Type
dfkkopc dfkkopc from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_CAAuthorizationType _CAAuthorizationType $projection.CAAuthorizationType = _CAAuthorizationType.CAAuthorizationType
[1..1] I_CADocument _CADocument $projection.CADocumentNumber = _CADocument.CADocumentNumber
[0..1] I_CACreditPostingOrigin _CACreditPostingOrigin $projection.OriginalSourceOfCredit = _CACreditPostingOrigin.OriginalSourceOfCredit
[1..1] I_Currency _AuthorizationCurrency $projection.AuthorizationCurrency = _AuthorizationCurrency.Currency
[1..1] I_PaytServiceProviderIdn _PaymentServiceProvider $projection.PaymentServiceProvider = _PaymentServiceProvider.PaymentServiceProvider

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Document BP Item Payment Data view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber opbel
KEY CAGroupingForPayment pygrp
PaymentCardType ccins
PaytCardByDigitalPaymentSrvc ccnum
PaymentCardSequenceNumber ccfol
PaymentCardValidityStartDate datab
PaymentCardValidityEndDate datbi
PaymentCardHolderName ccname
PaymentCardMaskedNumber masked_id
CAAuthznByDigitalPaytSrvc aunum
CAAuthorizationByAcquirer autra
AuthorizationDate audat
AuthorizationTime autim
CAAuthorizationType auart
AuthorizedAmountInAuthznCrcy autwr
AuthorizationCurrency ccwae
CAPaytServiceProviderMerchant merch
AuthorizationExpirationDate expdt
AuthorizationExpirationTime exptm
CAPaymentIDAuthznWithBilling aucid
CASettlementPaymentAdviceRef avref
PaymentCardAuthznRelationID dp_auth_rel_id
DigitalPaymentFraudRisk dp_fraud_risk
PaymentCardUUID cguid
EncryptionType enctp
CAKeyForPaymentCardSupplement xguid
PaymentServiceProvider pays_prov
PaymentRefByPaytSrvcProvider pays_tran
OriglPaytRefByPaytSrvcProvider orig_pays_tran
OriginalSourceOfCredit orig_credit
DigitalPaymentType dp_payment_type
PaymentByDigitalPaymentService dp_trans_id
_AuthorizationCurrency _AuthorizationCurrency
_CAAuthorizationType _CAAuthorizationType
_CACreditPostingOrigin _CACreditPostingOrigin
_CADocument _CADocument
_PaymentServiceProvider _PaymentServiceProvider
MerchantByClearingHouse merch
@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Document BP Item Payment Data'

@ObjectModel: { modelingPattern: #NONE,
                //sapObjectNodeType.name: 'ContrAcctgDocBusPartItmPaytDta',

                supportedCapabilities: [ #CDS_MODELING_ASSOCIATION_TARGET,
                                         #CDS_MODELING_DATA_SOURCE,
                                         #SQL_DATA_SOURCE ],
                usageType: { dataClass: #TRANSACTIONAL,
                             serviceQuality: #A,
                             sizeCategory: #XL } }

@VDM.viewType: #BASIC

define view entity I_CADocumentBPItemPaymentData
  as select from dfkkopc

  association [0..1] to I_CAAuthorizationType    as _CAAuthorizationType    on $projection.CAAuthorizationType = _CAAuthorizationType.CAAuthorizationType
  association [1..1] to I_CADocument             as _CADocument             on $projection.CADocumentNumber = _CADocument.CADocumentNumber
  association [0..1] to I_CACreditPostingOrigin  as _CACreditPostingOrigin  on $projection.OriginalSourceOfCredit = _CACreditPostingOrigin.OriginalSourceOfCredit
  association [1..1] to I_Currency               as _AuthorizationCurrency  on $projection.AuthorizationCurrency = _AuthorizationCurrency.Currency
  association [1..1] to I_PaytServiceProviderIdn as _PaymentServiceProvider on $projection.PaymentServiceProvider = _PaymentServiceProvider.PaymentServiceProvider

{
      @ObjectModel.foreignKey.association: '_CADocument'
  key opbel           as CADocumentNumber,
  key pygrp           as CAGroupingForPayment,

      ccins           as PaymentCardType,
      ccnum           as PaytCardByDigitalPaymentSrvc,
      ccfol           as PaymentCardSequenceNumber,
      datab           as PaymentCardValidityStartDate,
      datbi           as PaymentCardValidityEndDate,
      ccname          as PaymentCardHolderName,
      masked_id       as PaymentCardMaskedNumber,
      //cvval,

      //cvvct,

      //cvvst,


      aunum           as CAAuthznByDigitalPaytSrvc,
      autra           as CAAuthorizationByAcquirer,
      audat           as AuthorizationDate,
      autim           as AuthorizationTime,
      @ObjectModel.foreignKey.association: '_CAAuthorizationType'
      auart           as CAAuthorizationType,
      @Semantics.amount.currencyCode: 'AuthorizationCurrency'
      autwr           as AuthorizedAmountInAuthznCrcy,
      @ObjectModel.foreignKey.association: '_AuthorizationCurrency'
      ccwae           as AuthorizationCurrency,
      merch           as CAPaytServiceProviderMerchant,
      expdt           as AuthorizationExpirationDate,
      exptm           as AuthorizationExpirationTime,
      //extmp,

      //autmp,

      aucid           as CAPaymentIDAuthznWithBilling,
      avref           as CASettlementPaymentAdviceRef,
      dp_auth_rel_id  as PaymentCardAuthznRelationID,
      dp_fraud_risk   as DigitalPaymentFraudRisk,

      cguid           as PaymentCardUUID,
      enctp           as EncryptionType,
      xguid           as CAKeyForPaymentCardSupplement,
      //srqid,


      @ObjectModel.foreignKey.association: '_PaymentServiceProvider'
      pays_prov       as PaymentServiceProvider,
      pays_tran       as PaymentRefByPaytSrvcProvider,
      orig_pays_tran  as OriglPaytRefByPaytSrvcProvider,
      @ObjectModel.foreignKey.association: '_CACreditPostingOrigin'
      orig_credit     as OriginalSourceOfCredit,

      dp_payment_type as DigitalPaymentType,
      dp_trans_id     as PaymentByDigitalPaymentService,
      //_dataaging,


      //iban         as SEPAMandateSenderIBAN,

      //swift        as SEPAMandateSenderBankSWIFTCode,

      //koinh_ip,

      //txtvw,

      //meref_ip,

      //bkref_ip,

      //pyref_ip,


      _AuthorizationCurrency,
      _CAAuthorizationType,
      _CACreditPostingOrigin,
      _CADocument,
      _PaymentServiceProvider,

      /* deprecated fields */
      @API.element.releaseState: #DEPRECATED
      @API.element.successor: 'CAPaytServiceProviderMerchant'
      merch           as MerchantByClearingHouse      
}