I_CATransferToCollAgency

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 I_CATransferToCollAgency.
-- 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: ICATRCOLLAGCY

CREATE VIEW I_CATransferToCollAgency AS
SELECT
  opbel AS CADocumentNumber,
  inkps AS CAGrpgCodeForTransfToCollAgcy,
  inkgp AS CACollectionAgency,
  cast(cast(vkont as abap.char(12)) as corr_vkont_kk) AS ContractAccount,
  cast(gpart as bu_partner) AS BusinessPartner,
  cast(bukrs as fis_bukrs) AS CompanyCode,
  agdat AS CADateOfTransferToCollAgcy,
  aggrd AS CAReasonForTransferToCollAgcy,
  cast(waers as fis_rwcur) AS TransactionCurrency,
  betrw AS CAAmountInTransactionCurrency,
  betrz AS CAPaymentAmountInTransCurrency,
  ninkb AS CANoncollectableAmount,
  intbt AS CAIntrstReceivableFromCollAgcy,
  charb AS CAChargeReceivableFromCollAgcy,
  xblnr AS CAReferenceDocument,
  agsta AS CATransferToCollAgcyStatus,
  nrzas AS CAPaymentFormNumber,
  rudat AS CAReceivableRecallDate,
  rugrd AS CAReceivableRecallReason,
  collcase_id AS CACollectionExternalReference
FROM dfkkcoll
LEFT OUTER JOIN I_CompanyCode AS _CompCode ON CompanyCode = _CompCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _CAHeader ON ContractAccount = _CAHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_CACollectionAgency AS _CollAgcy ON CACollectionAgency = _CollAgcy.CACollectionAgency  -- association [1..1]
LEFT OUTER JOIN I_CATransfToCollAgcyStatus AS _Status ON CATransferToCollAgcyStatus = _Status.CATransferToCollAgcyStatus  -- association [1..1]
LEFT OUTER JOIN I_CAReceivableRecallReason AS _RblRecallRsn ON CAReceivableRecallReason = _RblRecallRsn.CAReceivableRecallReason  -- association [1..1]
LEFT OUTER JOIN I_CAReasonForTransfToCollAgcy AS _TransfRsn ON CAReasonForTransferToCollAgcy = _TransfRsn.CAReasonForTransferToCollAgcy  -- association [1..1]
;