P_CAExtCollsVolAnalysis

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_CAExtCollsVolAnalysis.
-- 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.
-- Parameters: P_DisplayCurrency : waers_kk

CREATE VIEW P_CAExtCollsVolAnalysis AS
SELECT
  _CollAgencyItem.CADocumentNumber AS CADocumentNumber,
  _CollAgencyItem.CAGrpgCodeForTransfToCollAgcy AS CAGrpgCodeForTransfToCollAgcy,
  _CollItemTyp.CAExternalCollItemType AS CAExternalCollItemType,
  _CollAgencyItem.CACollectionAgency AS CACollectionAgency,
  _CollAgencyItem.ContractAccount AS ContractAccount,
  _CollAgencyItem.BusinessPartner AS BusinessPartner,
  _CollAgencyItem.CompanyCode AS CompanyCode,
  _CollAgencyItem.CADateOfTransferToCollAgcy AS CADateOfTransferToCollAgcy,
  _CollAgencyItem.CAReasonForTransferToCollAgcy AS CAReasonForTransferToCollAgcy,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  _CollAgencyItem.TransactionCurrency AS TransactionCurrency,
  _AmountOpen.OpenAmountInTransCrcy AS CAAmountInTransactionCurrency,
  cast (1 as abap.int4) AS NumberOfOpenItems,
  _CollAgencyItem.CAReferenceDocument AS CAReferenceDocument,
  _CollAgencyItem.CATransferToCollAgcyStatus AS CATransferToCollAgcyStatus,
  _CollAgencyItem.CAPaymentFormNumber AS CAPaymentFormNumber,
  _CollAgencyItem.CAReceivableRecallDate AS CAReceivableRecallDate,
  _CollAgencyItem.CAReceivableRecallReason AS CAReceivableRecallReason,
  _CollAgencyItem.CACollectionExternalReference AS CACollectionExternalReference,
  _LastWorkItem( P_CAInternalAppCode : 'F2402', P_Language : $session.system_language ).WorklistItemCreationDate AS WorklistItemCreationDate,
  _LastWorkItem( P_CAInternalAppCode : 'F2402', P_Language : $session.system_language ).CAClrfctnStatus AS CAClrfctnStatus,
  _LastWorkItem( P_CAInternalAppCode : 'F2402', P_Language : $session.system_language ).CAClrfctnStatusName AS CAClrfctnStatusName,
  _CollAgencyItem._CAPartner AS _CAPartner,
  _CollAgencyItem._CAHeader AS _CAHeader,
  _CollAgencyItem._CollAgcy AS _CollAgcy,
  _CollAgencyItem._Status AS _Status,
  _CollAgencyItem._RblRecallRsn AS _RblRecallRsn,
  _CollAgencyItem._TransfRsn AS _TransfRsn
FROM I_CATransferToCollAgency AS _CollAgencyItem
LEFT OUTER JOIN P_CAExtCollItemOpenAmount AS _AmountOpen ON _CollAgencyItem.CADocumentNumber = _AmountOpen.CADocumentNumber AND _CollAgencyItem.CAGrpgCodeForTransfToCollAgcy = _AmountOpen.CAGrpgCodeForTransfToCollAgcy  -- association [1]
LEFT OUTER JOIN I_CALastWorklistItem AS _LastWorkItem ON _CollAgencyItem.BusinessPartner = _LastWorkItem.BusinessPartner  -- association [0..1]
-- UNION ALL with additional select branch(es): I_CATransferToCollAgency
;