P_PaymentCardRefundableVH

DDL: P_PAYMENTCARDREFUNDABLEVH Type: view_entity CONSUMPTION
20 Fields 1 Data Sources

P_PaymentCardRefundableVH is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_PaymentCardRefundable) and exposes 20 fields with key fields Bukrs, Belnr, Gjahr, Rfzei.

Data Sources (1)

SourceAliasJoin Type
P_PaymentCardRefundable P_PaymentCardRefundable from

Annotations (6)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY Bukrs Bukrs Value
KEY Belnr Belnr SD Document
KEY Gjahr Gjahr Settlement Year
KEY Rfzei Rfzei Payt Card Item
buzei _AcctgDocItem AccountingDocumentItem Posting View Item
Aunum Aunum AuthorizationNo
Ccnum Ccnum Condition Contract
Settl Settl Settled
Ccbtc Ccbtc Settlement
Dp_Psp Dp_Psp Paymnt Serv. Provid.
Dp_Payid Dp_Payid Payment ID
Dp_Psp_Transid Dp_Psp_Transid PSP Transaction ID
Dp_Trans_Id Dp_Trans_Id Transaction/Payt ID
Kunnr Kunnr Stock customer
MaxRefundableAmount _RefundableTotal MaxRefundableAmount
TransactionCurrency _RefundableTotal TransactionCurrency Transaction Currency
PendingAmount _RefundableTotal PendingAmount
CcbtcCcbtcthenXelseendasIsMinSettl
GLAccount _AcctgDocItem GLAccount General Ledger
Audat Audat Trans. Period End

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_PaymentCardRefundableVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_PaymentCardRefundableVH AS
SELECT
  Bukrs,
  Belnr,
  Gjahr,
  Rfzei,
  _AcctgDocItem.AccountingDocumentItem AS buzei,
  Aunum,
  Ccnum,
  Settl,
  Ccbtc,
  Dp_Psp,
  Dp_Payid,
  Dp_Psp_Transid,
  Dp_Trans_Id,
  Kunnr,
  _RefundableTotal.MaxRefundableAmount AS MaxRefundableAmount,
  _RefundableTotal.TransactionCurrency AS TransactionCurrency,
  _RefundableTotal.PendingAmount AS PendingAmount,
  case when _RefundableMM.Ccbtc = Ccbtc then 'X' else '' end as IsMinSettl AS CcbtcCcbtcthenXelseendasIsMinSettl,
  _AcctgDocItem.GLAccount AS GLAccount,
  Audat
FROM P_PaymentCardRefundable
;

Learn More