C_CAPaymentLotSearch

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 C_CAPaymentLotSearch.
-- 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.
-- SQL view name: CCAPAYTSEARCHLOT

CREATE VIEW C_CAPaymentLotSearch AS
SELECT
  CAPaymentLot,
  CAPaymentLotItem,
  _DocumentHeader._DocOriginCode._Text[1: Language=$session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName,
  _DocumentHeader.CADocumentOriginCode AS CADocumentOriginCode,
  CAPaymentTransIsToBeClarified,
  CABankAccountHolderName,
  IBAN,
  PaymentCardType,
  cast ( PaymentCardType as ccnum_ccins_kk ) AS PaymentCardData,
  CANoteToPayeeInPayment,
  CADocumentNumber,
  ValueDate,
  CAPaymentAmountInTransCurrency,
  TransactionCurrency,
  CompanyCode,
  _PaymentLotHeader._CompCode.CompanyCodeName AS CompanyCodeName,
  BusinessArea,
  CAClarificationDocument,
  CAClarificationAccount,
  _CAClarificationAccount._Text[1: Language=$session.system_language].GLAccountName AS CAClarificationAccountName,
  CABankClearingAccount,
  _CABankClearingAccount._Text[1: Language=$session.system_language].GLAccountName AS CABankClearingAccountName,
  _DocType._Text[1:Language = $session.system_language].CADocumentTypeName AS CADocumentTypeName,
  CADocumentType,
  DocumentDate,
  _ClearingReason._Text[1:Language = $session.system_language].CAClearingReasonName AS CAClearingReasonName,
  CAClearingReason,
  CACheque,
  BankCountry,
  _PayeeCountry._Text[1: Language=$session.system_language].CountryName AS PayeeCountryName,
  BankNumber,
  cast (BankAccount as farp_bankn preserving type ) AS BankAccount,
  SWIFTCode,
  _DocumentHeader.CreationDate AS CreationDate,
  _DocumentHeader.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _CardType.CardHolder AS CardHolder
FROM I_CAPaymentLotItem
LEFT OUTER JOIN I_CAPaymentLot AS _PaymentLotHeader ON CAPaymentLot = _PaymentLotHeader.CAPaymentLot  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _DocumentHeader ON CADocumentNumber = _DocumentHeader.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_Country AS _PayeeCountry ON BankCountry = _PayeeCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_Paymentcardtype AS _CardType ON PaymentCardType = _CardType.PaymentCardType AND CardNumber = _CardType.PaymentCardNumber  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _CAClarificationAccount ON CAClarificationAccount = _CAClarificationAccount.GLAccount AND CompanyCode = _CAClarificationAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _CABankClearingAccount ON CABankClearingAccount = _CABankClearingAccount.GLAccount AND CompanyCode = _CABankClearingAccount.CompanyCode  -- association [0..1]
;