C_CAExternalCollectionVolume

DDL: C_CAEXTERNALCOLLECTIONVOLUME SQL: CCAEXTCOLLVOLUME Type: view CONSUMPTION
35 Fields 1 Data Sources 5 Associations

Analyse der externen Forderungsabgabe

C_CAExternalCollectionVolume is a Consumption CDS View that provides data about "Analyse der externen Forderungsabgabe" in SAP S/4HANA. It reads from 1 data source (I_CATransferToCollAgency) and exposes 35 fields with key fields CADocumentNumber, CAGrpgCodeForTransfToCollAgcy. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CATransferToCollAgency I_CATransferToCollAgency from

Parameters (4)

NameTypeDefault
P_Currency waers_kk
P_CAInternalAppCode tileid_kk
P_Date sydatum
P_Language sylangu

Associations (5)

CardinalityTargetAliasCondition
[1] P_CAExternalCollectionVolume _AmountOpen $projection.CADocumentNumber = _AmountOpen.CADocumentNumber and $projection.CAGrpgCodeForTransfToCollAgcy = _AmountOpen.CAGrpgCodeForTransfToCollAgcy
[0..1] I_CALastWorklistItem _LastWorkItem $projection.BusinessPartner = _LastWorkItem.BusinessPartner
[0..1] I_CABPTotalSeparatedAmtsInDC _DebitsCredits $projection.BusinessPartner = _DebitsCredits.BusinessPartner
[0..1] I_ContractAccountPartner _ContractAccount $projection.BusinessPartner = _ContractAccount.BusinessPartner and $projection.ContractAccount = _ContractAccount.ContractAccount
[1] I_CAContractPartner _CAPartner $projection.BusinessPartner = _CAPartner.BusinessPartner

Annotations (9)

NameValueLevelField
EndUserText.label Analyse der externen Forderungsabgabe view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName CCAEXTCOLLVOLUME view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Document Number
KEY CAGrpgCodeForTransfToCollAgcy CAGrpgCodeForTransfToCollAgcy Collection item
CACollectionAgency CACollectionAgency CollsAgency BP
CACollectionAgencyName
CADateOfTransferToCollAgcy CADateOfTransferToCollAgcy Submission Date
CAReasonForTransferToCollAgcy CAReasonForTransferToCollAgcy Subm. Reason
CARsnNameForTransferToCollAgcy
CAReceivableRecallDate CAReceivableRecallDate Reply
CAReceivableRecallReason CAReceivableRecallReason Callback Reason
CAReceivableRecallReasonName
BusinessPartner BusinessPartner Issuing Authority
LastName
FirstName
BusinessPartnerName
ContractAccountCategory _CAHeader ContractAccountCategory Cont. Acct Cat.
PostalCode
CompanyCode CompanyCode Receiver Company Code
ContractAccount ContractAccount Contract Acct
CATransferToCollAgcyStatus CATransferToCollAgcyStatus Subm. Status
CATransferToCollAgcyStatusName
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount
OpenAmountInTransCrcy _AmountOpen OpenAmountInTransCrcy Open Amt Trans Crcy
CAPaymentAmountInTransCurrency CAPaymentAmountInTransCurrency Payment Amount
CANoncollectableAmount CANoncollectableAmount Uncollectable
CAIntrstReceivableFromCollAgcy CAIntrstReceivableFromCollAgcy Interest rec.
CAChargeReceivableFromCollAgcy CAChargeReceivableFromCollAgcy Charge receivb.
TransactionCurrency TransactionCurrency Transaction Currency
DisplayCurrency
CAAuthorizationGroup _ContractAccount CAAuthorizationGroup AuthorizGroup
CreditAmountInDisplayCrcy
DebitAmountInDisplayCrcy
WorklistItemCreationDate
CAClrfctnStatus
CAClrfctnStatusName
_CAPartner _CAPartner

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_CAExternalCollectionVolume.
-- 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: CCAEXTCOLLVOLUME
-- Parameters: P_Currency : waers_kk, P_CAInternalAppCode : tileid_kk, P_Date : sydatum, P_Language : sylangu

CREATE VIEW C_CAExternalCollectionVolume AS
SELECT
  CADocumentNumber,
  CAGrpgCodeForTransfToCollAgcy,
  CACollectionAgency,
  _CollAgcy._BusinessPartner.BusinessPartnerName AS CACollectionAgencyName,
  CADateOfTransferToCollAgcy,
  CAReasonForTransferToCollAgcy,
  _TransfRsn._Text[1:Language = :P_Language].CARsnNameForTransferToCollAgcy AS CARsnNameForTransferToCollAgcy,
  CAReceivableRecallDate,
  CAReceivableRecallReason,
  _RblRecallRsn._Text[1:Language = :P_Language].CAReceivableRecallReasonName AS CAReceivableRecallReasonName,
  BusinessPartner,
  _CAPartner._BusinessPartner.LastName AS LastName,
  _CAPartner._BusinessPartner.FirstName AS FirstName,
  _CAPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CAHeader.ContractAccountCategory AS ContractAccountCategory,
  _CAPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  CompanyCode,
  ContractAccount,
  CATransferToCollAgcyStatus,
  _Status._Text[1:Language = :P_Language].CATransferToCollAgcyStatusName AS CATransferToCollAgcyStatusName,
  CAAmountInTransactionCurrency,
  _AmountOpen.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  CAPaymentAmountInTransCurrency,
  CANoncollectableAmount,
  CAIntrstReceivableFromCollAgcy,
  CAChargeReceivableFromCollAgcy,
  TransactionCurrency,
  $parameters.P_Currency AS DisplayCurrency,
  _ContractAccount.CAAuthorizationGroup AS CAAuthorizationGroup,
  _DebitsCredits( P_DisplayCurrency : $parameters.P_Currency, P_ExchangeRateDate : $parameters.P_Date ).OpenPayablesAmountInDspCrcy AS CreditAmountInDisplayCrcy,
  _DebitsCredits( P_DisplayCurrency : $parameters.P_Currency, P_ExchangeRateDate : $parameters.P_Date ).OpenReceivablesAmountInDspCrcy AS DebitAmountInDisplayCrcy,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).WorklistItemCreationDate AS WorklistItemCreationDate,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatus AS CAClrfctnStatus,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatusName AS CAClrfctnStatusName
FROM I_CATransferToCollAgency
LEFT OUTER JOIN P_CAExternalCollectionVolume AS _AmountOpen ON CADocumentNumber = _AmountOpen.CADocumentNumber AND CAGrpgCodeForTransfToCollAgcy = _AmountOpen.CAGrpgCodeForTransfToCollAgcy  -- association [1]
LEFT OUTER JOIN I_CALastWorklistItem AS _LastWorkItem ON BusinessPartner = _LastWorkItem.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CABPTotalSeparatedAmtsInDC AS _DebitsCredits ON BusinessPartner = _DebitsCredits.BusinessPartner  -- 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_CAContractPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner  -- association [1]
;

Learn More