C_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 C_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: CCAPAYLOTANLYS

CREATE VIEW C_CAPaymentLotAnalysis AS
SELECT
  CAPaymentLot,
  CompanyCode,
  cast(CompanyCodeName as bukrs_text_gfn_kk preserving type) AS CompanyCodeName,
  CADocumentOriginCode,
  CADocumentOriginCodeName,
  CAPaymentLotStatus,
  CAPaymentLotStatusCriticality,
  CAPaymentLotStatusName,
  HouseBank,
  cast(HouseBankName as hbkid_text_gfn_kk preserving type ) AS HouseBankName,
  HouseBankAccount,
  HouseBankAccountDescription,
  cast (BankStatementShortID as kukey_kk preserving type) AS BankStatementShortID,
  _CAPaymentLotAnalysis.CANumberOfPaymentLotOpenItems AS CANumberOfPaymentLotOpenItems,
  case when _CAPaymentLotAnalysis.CANumberOfPaymentLotOpenItems is null then cast('3' as abap.numc(1)) when _CAPaymentLotAnalysis.CANumberOfPaymentLotOpenItems >= 1 then cast('1' as abap.numc(1)) else cast('0' as abap.numc(1)) end as CANrOfPaytLotOpenItemsCritlty AS numc1endasCANrOfPaytLotOpenItemsCritlty,
  cast(CANumberOfPaymentLotItems as abap.int4 ) AS CANumberOfPaymentLotItems,
  CreationDate,
  cast (TotalDebitAmount as summs_gfn preserving type) AS TotalDebitAmount,
  TotalAmountCurrency,
  CAOpenItemsAmountInTC,
  CANrOfPaytLotAutomlyClrdItems,
  _CAPaymentLotManualClr.CANrOfPaytLotMnllyClearedItems AS CANrOfPaytLotMnllyClearedItems,
  _CAPaymentLotClearedWithML.CANrOfPaytLotMaLrnClearedItems AS CANrOfPaytLotMaLrnClearedItems,
  cast('%' as unit) AS CAPercentageUnit,
  OpenItemRateInPercent,
  case when CANrOfPaytLotAutomlyClrdItems > 0 then division( CANrOfPaytLotAutomlyClrdItems, cast(CANumberOfPaymentLotItems as abap.int4), 4) *100 else cast(0 as abap.int4) end as AutomlyClrdItemRateInPercent AS int4endasAutomlyClrdItemRateInPercent,
  case when _CAPaymentLotManualClr.CANrOfPaytLotMnllyClearedItems > 0 then division( _CAPaymentLotManualClr.CANrOfPaytLotMnllyClearedItems, cast(CANumberOfPaymentLotItems as abap.int4), 4) *100 else cast(0 as abap.int4) end as MnllyClearedItemRateInPercent AS int4endasMnllyClearedItemRateInPercent,
  case when _CAPaymentLotClearedWithML.CANrOfPaytLotMaLrnClearedItems > 0 then division(_CAPaymentLotClearedWithML.CANrOfPaytLotMaLrnClearedItems, cast(CANumberOfPaymentLotItems as abap.int4), 4) *100 else cast(0 as abap.int4) end as MaLrnClearedItemRateInPercent AS int4endasMaLrnClearedItemRateInPercent,
  case when _CAPaytLotItmHighCnfAutoML.CANrOfItemsWithHighCnfAutoML > 0 then division(_CAPaytLotItmHighCnfAutoML.CANrOfItemsWithHighCnfAutoML,_CAPaymentLotItemsWithML.NumberOfAllItemsWithML, 4) *100 else cast(0 as abap.fltp) end as MaLrnHighCnfdncAutomRateInPct AS fltpendasMaLrnHighCnfdncAutomRateInPct,
  case when _CAPaytLotItmHighCnfPrpslML.CANrOfItemsWithHighCnfPrpslML > 0 then division(_CAPaytLotItmHighCnfPrpslML.CANrOfItemsWithHighCnfPrpslML,_CAPaymentLotItemsWithML.NumberOfAllItemsWithML, 4) *100 else cast(0 as abap.fltp) end as MaLrnHighCnfdncPrpslRateInPct AS fltpendasMaLrnHighCnfdncPrpslRateInPct,
  case when _CAPaytLotItmGoodCnfPrpslML.CANrOfItemsWithGoodCnfPrpslML > 0 then division(_CAPaytLotItmGoodCnfPrpslML.CANrOfItemsWithGoodCnfPrpslML,_CAPaymentLotItemsWithML.NumberOfAllItemsWithML, 4) *100 else cast(0 as abap.fltp) end as MaLrnGoodCnfdncPrpslRateInPct AS fltpendasMaLrnGoodCnfdncPrpslRateInPct,
  case when _CAPaytLotItmLowCnfPrpslML.CANrOfItemsWithLowCnfPrpslML > 0 then division(_CAPaytLotItmLowCnfPrpslML.CANrOfItemsWithLowCnfPrpslML,_CAPaymentLotItemsWithML.NumberOfAllItemsWithML, 4) *100 else cast(0 as abap.fltp) end as MaLrnLowCnfdncPrpslRateInPct AS fltpendasMaLrnLowCnfdncPrpslRateInPct,
  case when _CAPaytLotItmNoPrpslML.CANrOfItemsWithNoPrpslML > 0 then division(_CAPaytLotItmNoPrpslML.CANrOfItemsWithNoPrpslML,_CAPaymentLotItemsWithML.NumberOfAllItemsWithML, 4) *100 else cast(0 as abap.fltp) end as MchnLrngWithoutPrpslRateInPct AS fltpendasMchnLrngWithoutPrpslRateInPct,
  MchnLrngIsActvForPaytAssgmt
FROM P_CAPaymentLotAnalysis AS _CAPaymentLotAnalysis
LEFT OUTER JOIN P_CAPaymentLotManualClr AS _CAPaymentLotManualClr ON CAPaymentLot = _CAPaymentLotManualClr.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaymentLotClearedWithML AS _CAPaymentLotClearedWithML ON CAPaymentLot = _CAPaymentLotClearedWithML.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaymentLotItemsWithML AS _CAPaymentLotItemsWithML ON CAPaymentLot = _CAPaymentLotItemsWithML.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaytLotItmHighCnfAutoML AS _CAPaytLotItmHighCnfAutoML ON CAPaymentLot = _CAPaytLotItmHighCnfAutoML.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaytLotItmHighCnfPrpslML AS _CAPaytLotItmHighCnfPrpslML ON CAPaymentLot = _CAPaytLotItmHighCnfPrpslML.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaytLotItmGoodCnfPrpslML AS _CAPaytLotItmGoodCnfPrpslML ON CAPaymentLot = _CAPaytLotItmGoodCnfPrpslML.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaytLotItmLowCnfPrpslML AS _CAPaytLotItmLowCnfPrpslML ON CAPaymentLot = _CAPaytLotItmLowCnfPrpslML.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN P_CAPaytLotItmNoPrpslML AS _CAPaytLotItmNoPrpslML ON CAPaymentLot = _CAPaytLotItmNoPrpslML.CAPaymentLot  -- association [1..1]
LEFT OUTER JOIN C_CAPaytLotAnlysPaytUsge AS _CAPaytLotAnlysPaytUsge ON CAPaymentLot = _CAPaytLotAnlysPaytUsge.CAPaymentLot  -- association [0..*]
LEFT OUTER JOIN C_CAPaytLotAnlysClrfctnDurn AS _CAPaytLotAnlysClrfctnDurn ON CAPaymentLot = _CAPaytLotAnlysClrfctnDurn.CAPaymentLot  -- association [0..*]
;