I_IL_CreditCardTransactionLog

DDL: I_IL_CREDITCARDTRANSACTIONLOG Type: view_entity COMPOSITE Package: GLO_FIN_CASH_IL
18 Fields 1 Data Sources

IL Credit Card Transaction Log

I_IL_CreditCardTransactionLog is a Composite CDS View that provides data about "IL Credit Card Transaction Log" in SAP S/4HANA. It reads from 1 data source (I_IL_CrdtCardTransacLogRaw) and exposes 18 fields with key field IL_CreditCardReference. Part of development package GLO_FIN_CASH_IL.

Data Sources (1)

SourceAliasJoin Type
I_IL_CrdtCardTransacLogRaw CCLog from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label IL Credit Card Transaction Log view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY IL_CreditCardReference I_IL_CrdtCardTransacLogRaw IL_CreditCardReference Reference Number
IL_CreditCardTransactionType TransTypeMap IL_CreditCardTransactionType Transactn Type
TransactionDate I_IL_CrdtCardTransacLogRaw TransactionDate Value Date
IL_CreditCardBrand CreditCardBrand IL_CreditCardCompanyCode
IL_ClearingCreditCardCompany ClearingCompany IL_CreditCardCompanyCode
CreditCardNumber I_IL_CrdtCardTransacLogRaw CreditCardNumber Card Number
IL_CrdtCardValdThroughValue I_IL_CrdtCardTransacLogRaw IL_CrdtCardValdThroughValue validity Date (YYMM)
NumberOfInstallments I_IL_CrdtCardTransacLogRaw NumberOfInstallments Installments
IL_PaytItmAmountInDocCrcy I_IL_CrdtCardTransacLogRaw IL_PaytItmAmountInDocCrcy Value Amount
IL_CrdtCard1stPaymentAmtInTC I_IL_CrdtCardTransacLogRaw IL_CrdtCard1stPaymentAmtInTC First Payment Amount
IL_CrdtCardNextPaymentAmtInTC I_IL_CrdtCardTransacLogRaw IL_CrdtCardNextPaymentAmtInTC Rest Payment Amount
Currency I_IL_CrdtCardTransacLogRaw Currency Valuation Crcy
IL_CreditCardAcknowledgeNumber I_IL_CrdtCardTransacLogRaw IL_CreditCardAcknowledgeNumber Acknowledge Number
PaymentCardTerminal I_IL_CrdtCardTransacLogRaw PaymentCardTerminal Terminal Number
IL_IdentifierCashPaymentItem PaymentItem IL_IdentifierCashPaymentItem
_TransactionTypeText TransTypeMap _TransactionTypeText
_CreditCardBrandText CreditCardBrand _CreditCardCompanyText
_ClearingCompanyText ClearingCompany _CreditCardCompanyText

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_CreditCardTransactionLog.
-- 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_CreditCardTransactionLog AS
SELECT
  CCLog.IL_CreditCardReference AS IL_CreditCardReference,
  TransTypeMap.IL_CreditCardTransactionType AS IL_CreditCardTransactionType,
  CCLog.TransactionDate AS TransactionDate,
  CreditCardBrand.IL_CreditCardCompanyCode AS IL_CreditCardBrand,
  ClearingCompany.IL_CreditCardCompanyCode AS IL_ClearingCreditCardCompany,
  CCLog.CreditCardNumber AS CreditCardNumber,
  CCLog.IL_CrdtCardValdThroughValue AS IL_CrdtCardValdThroughValue,
  CCLog.NumberOfInstallments AS NumberOfInstallments,
  CCLog.IL_PaytItmAmountInDocCrcy AS IL_PaytItmAmountInDocCrcy,
  CCLog.IL_CrdtCard1stPaymentAmtInTC AS IL_CrdtCard1stPaymentAmtInTC,
  CCLog.IL_CrdtCardNextPaymentAmtInTC AS IL_CrdtCardNextPaymentAmtInTC,
  CCLog.Currency AS Currency,
  CCLog.IL_CreditCardAcknowledgeNumber AS IL_CreditCardAcknowledgeNumber,
  CCLog.PaymentCardTerminal AS PaymentCardTerminal,
  PaymentItem.IL_IdentifierCashPaymentItem AS IL_IdentifierCashPaymentItem,
  TransTypeMap._TransactionTypeText AS _TransactionTypeText,
  CreditCardBrand._CreditCardCompanyText AS _CreditCardBrandText,
  ClearingCompany._CreditCardCompanyText AS _ClearingCompanyText
FROM I_IL_CrdtCardTransacLogRaw AS CCLog
;

Learn More