P_CAPaymentLotAnalysis

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_CAPaymentLotAnalysis.
-- 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: PCAPAYLOTANLYS

CREATE VIEW P_CAPaymentLotAnalysis AS
SELECT
  CAPaymentLot,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCodeML.MchnLrngIsActvForPaytAssgmt AS MchnLrngIsActvForPaytAssgmt,
  CADocumentOriginCode,
  _CADocumentOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName,
  CAPaymentLotStatus,
  _PaymentLotStatus._Text[1:Language = $session.system_language].CAPaymentLotStatusName AS CAPaymentLotStatusName,
  case CAPaymentLotStatus when '3' then cast('2' as abap.numc(1)) when '4' then cast('2' as abap.numc(1)) when '6' then cast('0' as abap.numc(1)) when '9' then cast('2' as abap.numc(1)) when '5' then cast('3' as abap.numc(1)) else cast('1' as abap.numc(1)) end as CAPaymentLotStatusCriticality AS numc1endasCAPaymentLotStatusCriticality,
  HouseBank,
  _HouseBank._Bank.BankName AS HouseBankName,
  HouseBankAccount,
  _HouseBankAccount._Text[1: Language=$session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  BankStatementShortID,
  CANumberOfPaymentLotItems,
  CreationDate,
  TotalDebitAmount,
  TotalAmountCurrency,
  _CAPaymentLotOpenItems.CANumberOfPaymentLotOpenItems AS CANumberOfPaymentLotOpenItems,
  _CAPaymentLotOpenItems.CAOpenItemsAmountInTC AS CAOpenItemsAmountInTC,
  _CAPaymentLotAutoCleared.CAAutomlyClearedItemsAmtInTC AS CAAutomlyClearedItemsAmtInTC,
  _CAPaymentLotAutoCleared.CANrOfPaytLotAutomlyClrdItems AS CANrOfPaytLotAutomlyClrdItems,
  _CAPaymentLotMnlClrPrcntg.OpenItemRateInPercent AS OpenItemRateInPercent
FROM I_CAPaymentLot
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CADocumentOriginCode AS _CADocumentOriginCode ON CADocumentOriginCode = _CADocumentOriginCode.CADocumentOriginCode  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentLotStatus AS _PaymentLotStatus ON CAPaymentLotStatus = _PaymentLotStatus.CAPaymentLotStatus  -- association [1..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON CompanyCode = _HouseBank.CompanyCode AND HouseBank = _HouseBank.HouseBank  -- association [0..1]
LEFT OUTER JOIN I_HouseBankAccount AS _HouseBankAccount ON CompanyCode = _HouseBankAccount.CompanyCode AND HouseBank = _HouseBankAccount.HouseBank AND HouseBankAccount = _HouseBankAccount.HouseBankAccount  -- association [0..1]
LEFT OUTER JOIN I_CACompanyCode AS _CompanyCodeML ON CompanyCode = _CompanyCodeML.CompanyCode  -- association [1..1]
LEFT OUTER JOIN P_CAPaymentLotOpenItems AS _CAPaymentLotOpenItems ON CAPaymentLot = _CAPaymentLotOpenItems.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaymentLotAutoCleared AS _CAPaymentLotAutoCleared ON CAPaymentLot = _CAPaymentLotAutoCleared.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaymentLotManualClrPrcntg AS _CAPaymentLotMnlClrPrcntg ON CAPaymentLot = _CAPaymentLotMnlClrPrcntg.CAPaymentLot  -- association [1..1]
;