I_CADocumentBPItemPaymentData
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)
| Source | Alias | Join Type |
|---|---|---|
| dfkkopc | dfkkopc | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
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