P_CADunningVolume

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_CADunningVolume.
-- 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: PCADUNVOLUME
-- Parameters: P_Date : sydatum, P_Language : sylangu

CREATE VIEW P_CADunningVolume AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  BusinessPartner,
  ContractAccount,
  CADunningCounter,
  CAContract,
  CASubApplication,
  _CompCode[1:Language = :P_Language].CompanyCodeName AS CompanyCodeName,
  BusinessArea,
  Division,
  CAIssueDate,
  CADunningProcedure,
  _DunningProcedure._Text[1:Language = :P_Language].CADunningProcedureName AS CADunningProcedureName,
  CADunningLevel,
  _DunningLevel._Text[1:Language = :P_Language].CADunningLevelName AS CADunningLevelName,
  TransactionCurrency,
  CADunningBalance,
  CADunningChargeAmount,
  CADunningInterestAmount,
  _DunItem.CADunningAmount AS CADunningAmount,
  _DunItem._DocBPItem.CAClearingStatus AS CAClearingStatus,
  _DunItem.Segment AS Segment,
  _DunItem._Segment._Text[1:Language = :P_Language].SegmentName AS SegmentName,
  _DunItem._DocBPItem.CADocumentType AS CADocumentType,
  _DunItem._DocBPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _DunItem._DocBPItem.CAMainTransaction AS CAMainTransaction,
  _DunItem._DocBPItem.CASubTransaction AS CASubTransaction,
  _BusinessPartner.FirstName AS FirstName,
  _BusinessPartner.LastName AS LastName,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _CAHeader.ContractAccountCategory AS ContractAccountCategory,
  case _DunItem._DocBPItem.CAClearingStatus when '9' then case when _DunItem._DocBPItem.CAValueDateForClearing <> '00000000' then _DunItem._DocBPItem.CAValueDateForClearing when _DunItem._DocBPItem.CAPostingDateOfClearingDoc <> '00000000' then _DunItem._DocBPItem.CAPostingDateOfClearingDoc else cast( concat(:P_Date, '') as abap.dats) end else cast( concat(:P_Date, '') as abap.dats) end as ExchangeRateDate AS datsendasExchangeRateDate,
  _CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup
FROM I_CADunningHistory
;