C_CAOverdueItemAnalysis

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_CAOverdueItemAnalysis.
-- 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: CCAOVERDUEITMANL
-- Parameters: P_DisplayCurrency : waers_kk, P_ExchangeRateDate : syst_datum, P_Language : sylangu

CREATE VIEW C_CAOverdueItemAnalysis AS
SELECT
  BPItem.CADocumentNumber AS CADocumentNumber,
  BPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  BPItem.CABPItemNumber AS CABPItemNumber,
  BPItem.CASubItemNumber AS CASubItemNumber,
  cast(BPItem.CAAmountInTransactionCurrency as abap.curr(23,2)) AS CAAmountInTransactionCurrency,
  BPItem.TransactionCurrency AS TransactionCurrency,
  BPItem.CAAmountInTransactionCurrency AS AmountInDisplayCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  BPItem.CompanyCode AS CompanyCode,
  BPItem.Segment AS Segment,
  BPItem.Division AS Division,
  BPItem.BusinessArea AS BusinessArea,
  BPItem.BusinessPartner AS BusinessPartner,
  _CAPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _CAPartner._BusinessPartner.FirstName AS FirstName,
  _CAPartner._BusinessPartner.LastName AS LastName,
  _CAPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  BPItem.ContractAccount AS ContractAccount,
  _ContrAccHdr.ContractAccountCategory AS ContractAccountCategory,
  BPItem.CAContract AS CAContract,
  BPItem.CASubApplication AS CASubApplication,
  BPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  BPItem.CADocumentType AS CADocumentType,
  BPItem.CAMainTransaction AS CAMainTransaction,
  BPItem.CASubTransaction AS CASubTransaction,
  BPItem.CADoubtfulOrValueAdjmtCode AS CADoubtfulOrValueAdjmtCode,
  case when BPItem.CADeferralDate = '00000000' then BPItem.CANetDueDate else BPItem.CADeferralDate end as CANetDueDate AS CADeferralDateendasCANetDueDate,
  _ContractAccount.CAAuthorizationGroup AS CAAuthorizationGroup,
  _CAProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup,
  case when _LastWorkItem( P_CAInternalAppCode : 'F0860', P_Language : $parameters.P_Language ).CAClrfctnStatus is null then '' else _LastWorkItem( P_CAInternalAppCode : 'F0860', P_Language : $parameters.P_Language ).CAClrfctnStatus end as CAClrfctnStatus AS CAClrfctnStatusendasCAClrfctnStatus
FROM I_CADocumentBPItem AS BPItem
LEFT OUTER JOIN I_ContractAccountHeader AS _ContrAccHdr ON ContractAccount = _ContrAccHdr.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccount ON BusinessPartner = _ContractAccount.BusinessPartner AND ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CALastDunningForDocument AS _CADunItem ON CADocumentNumber = _CADunItem.CADocumentNumber AND CARepetitionItemNumber = _CADunItem.CARepetitionItemNumber AND CABPItemNumber = _CADunItem.CABPItemNumber AND CASubItemNumber = _CADunItem.CASubItemNumber  -- association [1]
LEFT OUTER JOIN I_CAContractPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_CALastWorklistItem AS _LastWorkItem ON BusinessPartner = _LastWorkItem.BusinessPartner  -- association [0..1]
;