P_PaymentCardRefundable
P_PaymentCardRefundable is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (bsegc) and exposes 54 fields with key fields Bukrs, Gjahr, Audat, Belnr. It has 5 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| bsegc | AcctgDoc | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_JournalEntry | _JournalEntry | AcctgDoc.bukrs = _JournalEntry.CompanyCode and AcctgDoc.gjahr = _JournalEntry.FiscalYear and AcctgDoc.belnr = _JournalEntry.AccountingDocument |
| [0..1] | I_OperationalAcctgDocItem | _AcctgDocItem | AcctgDoc.bukrs = _AcctgDocItem.CompanyCode and AcctgDoc.belnr = _AcctgDocItem.AccountingDocument and AcctgDoc.gjahr = _AcctgDocItem.FiscalYear and AcctgDoc.rfzei = _AcctgDocItem.PaymentCardItem |
| [0..1] | P_PaymentCardRefundableTotal | _RefundableTotal | AcctgDoc.aunum = _RefundableTotal.Aunum |
| [0..1] | P_PaymentCardRefundableMM | _RefundableMM | AcctgDoc.aunum = _RefundableMM.Aunum |
| [0..1] | I_Customer | _Customer | $projection.Kunnr = _Customer.Customer |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #BLOCKED_DATA_EXCLUDED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view |
Fields (54)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | Bukrs | bukrs | ||
| KEY | Gjahr | gjahr | ||
| KEY | Audat | audat | ||
| KEY | Belnr | belnr | ||
| Rfzei | rfzei | |||
| Aunum | aunum | |||
| Ccins | ccins | |||
| Ccnum | ccnum | |||
| Ccfol | ccfol | |||
| Datab | datab | |||
| Datbi | datbi | |||
| Ccname | ccname | |||
| Csour | csour | |||
| Autwr | autwr | |||
| Ccwae | ccwae | |||
| Settl | settl | |||
| Autra | autra | |||
| Autim | autim | |||
| Merch | merch | |||
| Locid | locid | |||
| Trmid | trmid | |||
| Ccbtc | ccbtc | |||
| Cctyp | cctyp | |||
| Ccard_Guid | ccard_guid | |||
| Payment_Amount | payment_amount | |||
| Dp_Token | dp_token | |||
| Dp_Psp | dp_psp | |||
| Dp_Payid | dp_payid | |||
| Dp_Psp_Transid | dp_psp_transid | |||
| Dp_Trans_Id | dp_trans_id | |||
| Dp_Merchant_Alias | dp_merchant_alias | |||
| Dp_Auth_Rel_Id | dp_auth_rel_id | |||
| Dp_Fraud_Risk | dp_fraud_risk | |||
| Dp_Charge_Trans_Id | dp_charge_trans_id | |||
| Setra | setra | |||
| Rcavr | rcavr | |||
| Rcava | rcava | |||
| Rcavz | rcavz | |||
| Rcrsp | rcrsp | |||
| Rtext | rtext | |||
| React | react | |||
| Kunnr | kunnr | |||
| Opbel | opbel | |||
| Dp_Advref | dp_advref | |||
| _Dataaging | _dataaging | |||
| Dp_Rtext_Long | dp_rtext_long | |||
| Dp_L2l3_Sent | dp_l2l3_sent | |||
| AuthorizationGroup | _Customer | AuthorizationGroup | ||
| TransactionCurrency | _JournalEntry | TransactionCurrency | ||
| _AcctgDocItem | _AcctgDocItem | |||
| _RefundableTotal | _RefundableTotal | |||
| _JournalEntry | _JournalEntry | |||
| _RefundableMM | _RefundableMM | |||
| _Customer | _Customer |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
//@EndUserText.label: 'Refundable payments with Credit Card'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #XL,
dataClass: #MIXED
}
define view entity P_PaymentCardRefundable
as select from bsegc as AcctgDoc
association [0..1] to I_JournalEntry as _JournalEntry on AcctgDoc.bukrs = _JournalEntry.CompanyCode
and AcctgDoc.gjahr = _JournalEntry.FiscalYear
and AcctgDoc.belnr = _JournalEntry.AccountingDocument
association [0..1] to I_OperationalAcctgDocItem as _AcctgDocItem on AcctgDoc.bukrs = _AcctgDocItem.CompanyCode
and AcctgDoc.belnr = _AcctgDocItem.AccountingDocument
and AcctgDoc.gjahr = _AcctgDocItem.FiscalYear
and AcctgDoc.rfzei = _AcctgDocItem.PaymentCardItem
association [0..1] to P_PaymentCardRefundableTotal as _RefundableTotal on AcctgDoc.aunum = _RefundableTotal.Aunum //AuthorizationByPaytSrvcPrvdr
association [0..1] to P_PaymentCardRefundableMM as _RefundableMM on AcctgDoc.aunum = _RefundableMM.Aunum
association [0..1] to I_Customer as _Customer on $projection.Kunnr = _Customer.Customer
{
key bukrs as Bukrs,
key gjahr as Gjahr,
key audat as Audat,
key belnr as Belnr,
rfzei as Rfzei,
aunum as Aunum,
ccins as Ccins,
ccnum as Ccnum,
ccfol as Ccfol,
datab as Datab,
datbi as Datbi,
ccname as Ccname,
csour as Csour,
@Semantics: { amount : {currencyCode: 'Ccwae'} }
autwr as Autwr,
ccwae as Ccwae,
settl as Settl,
autra as Autra,
// audat as Audat,
autim as Autim,
merch as Merch,
locid as Locid,
trmid as Trmid,
ccbtc as Ccbtc,
cctyp as Cctyp,
ccard_guid as Ccard_Guid,
@Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
payment_amount as Payment_Amount,
dp_token as Dp_Token,
dp_psp as Dp_Psp,
dp_payid as Dp_Payid,
dp_psp_transid as Dp_Psp_Transid,
dp_trans_id as Dp_Trans_Id,
dp_merchant_alias as Dp_Merchant_Alias,
dp_auth_rel_id as Dp_Auth_Rel_Id,
dp_fraud_risk as Dp_Fraud_Risk,
dp_charge_trans_id as Dp_Charge_Trans_Id,
setra as Setra,
rcavr as Rcavr,
rcava as Rcava,
rcavz as Rcavz,
rcrsp as Rcrsp,
rtext as Rtext,
react as React,
kunnr as Kunnr,
opbel as Opbel,
dp_advref as Dp_Advref,
_dataaging as _Dataaging,
dp_rtext_long as Dp_Rtext_Long,
dp_l2l3_sent as Dp_L2l3_Sent,
_Customer.AuthorizationGroup as AuthorizationGroup,
_JournalEntry.TransactionCurrency as TransactionCurrency,
_AcctgDocItem,
_RefundableTotal,
_JournalEntry,
_RefundableMM,
_Customer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_JOURNALENTRY",
"BSEGC"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_JOURNALENTRY",
"I_OPERATIONALACCTGDOCITEM",
"P_PAYMENTCARDREFUNDABLEMM",
"P_PAYMENTCARDREFUNDABLETOTAL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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