I_IL_CashRegisterReceipt

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_CashRegisterReceipt.
-- 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_CashRegisterReceipt AS
SELECT
  DocHeader.CompanyCode AS CompanyCode,
  DocHeader.FiscalYear AS FiscalYear,
  DocHeader.AccountingDocument AS AccountingDocument,
  Payment.IL_IdentifierCashPaymentItem AS IL_IdentifierCashPaymentItem,
  Payment.IL_PaymentMethod AS IL_PaymentMethod,
  _IL_PaymentMethodText.IL_PaymentMethodText AS IL_PaymentMethodText,
  Receipt.PaymentReceiptUUID AS PaymentReceiptUUID,
  DocHeader.TransactionCurrency AS TransactionCurrency,
  DocHeader.DocumentDate AS DocumentDate,
  DocHeader.PostingDate AS PostingDate,
  DocHeader.AccountingDocumentHeaderText AS AccountingDocumentHeaderText,
  $session.user AS UserName,
  replace( Company.VATRegistration, 'IL', ' ' ) AS VATRegistration,
  Receipt.Customer AS Customer,
  Receipt.Supplier AS Supplier,
  coalesce( Customer.CityName, Supplier.CityName ) AS CityName,
  coalesce( Customer.StreetName, Supplier.StreetName ) AS StreetName,
  coalesce( Customer.PostalCode, Supplier.PostalCode ) AS PostalCode,
  coalesce( Customer.BPCustomerName, Supplier.BPSupplierName ) AS CustomerName,
  Payment.IL_CreditCardReference AS IL_CreditCardReference,
  right( _CreditCardLog.CreditCardNumber, 4 ) AS CreditCardNumber,
  Payment.IL_CreditCardTransactionType AS IL_CreditCardTransactionType,
  _CreditCardLog._TransactionTypeText.TransactionTypeDescription AS TransactionTypeDescription,
  _CreditCardLog.IL_CreditCardBrand AS IL_CreditCardBrand,
  _CreditCardLog._CreditCardBrandText.CreditCardCompanyName AS CreditCardBrandDesc,
  _CreditCardLog.IL_CrdtCardValdThroughValue AS IL_CrdtCardValdThroughValue,
  _CreditCardLog.NumberOfInstallments AS NumberOfInstallments,
  _CreditCardLog.IL_CrdtCard1stPaymentAmtInTC AS IL_CrdtCard1stPaymentAmtInTC,
  _CreditCardLog.IL_CrdtCardNextPaymentAmtInTC AS IL_CrdtCardNextPaymentAmtInTC,
  Payment.PaymentMethodDescription AS PaymentMethodDescription,
  Payment.BankNumber AS BankNumber,
  Payment.BankAccount AS BankAccount,
  Payment.IL_ChequeNumber AS IL_ChequeNumber,
  Payment.IL_ChequeDueDate AS IL_ChequeDueDate,
  Payment.IL_BankTransferReferenceNumber AS IL_BankTransferReferenceNumber,
  Payment.IL_PaytItmAmountInDocCrcy AS IL_PaytItmAmountInDocCrcy
FROM I_PaymentReceipt AS Receipt
LEFT OUTER JOIN I_IL_CreditCardTransactionLog AS _CreditCardLog ON _CreditCardLog.IL_CreditCardReference = IL_CreditCardReference  -- association [0..1]
LEFT OUTER JOIN I_IL_PaymentMethodText AS _IL_PaymentMethodText ON _IL_PaymentMethodText.Language = $session.system_language AND _IL_PaymentMethodText.IL_PaymentMethod = IL_PaymentMethod  -- association [0..1]
;