I_IL_RetblCreditCardPayment

DDL: I_IL_RETBLCREDITCARDPAYMENT Type: view_entity COMPOSITE Package: RAP_GLO_FIN_CASH_IL_RETURN
17 Fields 1 Data Sources

IL Returnable Credit Card Payment

I_IL_RetblCreditCardPayment is a Composite CDS View that provides data about "IL Returnable Credit Card Payment" in SAP S/4HANA. It reads from 1 data source (I_IL_PaymentItem) and exposes 17 fields with key field IL_IdentifierCashPaymentItem. Part of development package RAP_GLO_FIN_CASH_IL_RETURN.

Data Sources (1)

SourceAliasJoin Type
I_IL_PaymentItem Payment from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label IL Returnable Credit Card Payment view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY IL_IdentifierCashPaymentItem I_IL_PaymentItem IL_IdentifierCashPaymentItem Payment ID
IL_PaymentMethod I_IL_PaymentItem IL_PaymentMethod Payment Method
IL_CashNumberKey I_IL_PaymentItem IL_CashNumberKey Cash Number
IL_PaytItmAmountInDocCrcy I_IL_PaymentItem IL_PaytItmAmountInDocCrcy Value Amount
TransactionCurrency I_IL_PaymentItem TransactionCurrency Transaction Currency
IL_CreditCardReference I_IL_PaymentItem IL_CreditCardReference Reference Number
IL_CreditCardTransactionType CCLog IL_CreditCardTransactionType Credit Type
CreditCardNumber CCLog CreditCardNumber Card Number
IL_CreditCardBrand CCLog IL_CreditCardBrand
TransactionDate CCLog TransactionDate Value Date
PaymentMethod I_IL_PaymentItem PaymentMethod Pymt Meth.
PaymentMethodDescription I_IL_PaymentItem PaymentMethodDescription
CompanyCode I_IL_PaymentItem CompanyCode Receiver Company Code
Customer I_IL_PaymentItem Customer Sold-to Party
Supplier I_IL_PaymentItem Supplier Supplier
PaymentReceiptID
EntryTimestamp

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 I_IL_RetblCreditCardPayment.
-- 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 I_IL_RetblCreditCardPayment AS
SELECT
  Payment.IL_IdentifierCashPaymentItem AS IL_IdentifierCashPaymentItem,
  Payment.IL_PaymentMethod AS IL_PaymentMethod,
  Payment.IL_CashNumberKey AS IL_CashNumberKey,
  Payment.IL_PaytItmAmountInDocCrcy AS IL_PaytItmAmountInDocCrcy,
  Payment.TransactionCurrency AS TransactionCurrency,
  Payment.IL_CreditCardReference AS IL_CreditCardReference,
  CCLog.IL_CreditCardTransactionType AS IL_CreditCardTransactionType,
  CCLog.CreditCardNumber AS CreditCardNumber,
  CCLog.IL_CreditCardBrand AS IL_CreditCardBrand,
  CCLog.TransactionDate AS TransactionDate,
  Payment.PaymentMethod AS PaymentMethod,
  Payment.PaymentMethodDescription AS PaymentMethodDescription,
  Payment.CompanyCode AS CompanyCode,
  Payment.Customer AS Customer,
  Payment.Supplier AS Supplier,
  cast( Payment.AccountingDocument as paytrcpt_id preserving type ) AS PaymentReceiptID
FROM I_IL_PaymentItem AS Payment
;

Learn More