C_CACollectionVol

DDL: C_CACOLLECTIONVOL SQL: CCACOLLVOL Type: view CONSUMPTION
26 Fields 1 Data Sources 3 Associations

Analyse des Collection Volumens

C_CACollectionVol is a Consumption CDS View that provides data about "Analyse des Collection Volumens" in SAP S/4HANA. It reads from 1 data source (I_CADunningHeader) and exposes 26 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADunningHeader I_CADunningHeader from

Parameters (3)

NameTypeDefault
P_Currency waers_kk
P_Date sydatum
P_Language sylangu

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_ContractAccountPartner _ContractAccount $projection.BusinessPartner = _ContractAccount.BusinessPartner and $projection.ContractAccount = _ContractAccount.ContractAccount
[1] I_CAContractPartner _CAPartner $projection.BusinessPartner = _CAPartner.BusinessPartner
[0..1] I_CASubApplication _SubApp $projection.CASubApplication = _SubApp.CASubApplication

Annotations (9)

NameValueLevelField
EndUserText.label Analyse des Collection Volumens view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName CCACOLLVOL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate CAMassRunDate Date ID
KEY CAMassRunID CAMassRunID Run ID
KEY BusinessPartner BusinessPartner Issuing Authority
KEY ContractAccount ContractAccount Contract Acct
KEY CADunningCounter CADunningCounter Dunning counter
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CASubApplicationText
CANumberOfDunningNotices
CompanyCodeName
BusinessArea BusinessArea Business Area
Division Division Internal Division ID
CAIssueDate CAIssueDate Dunning Date
CACollectionStrategy CACollectionStrategy Coll. Strategy
CACollectionStrategyName
CACollectionStep CACollectionStep Step Number
CACollectionStepName
DisplayCurrency
FirstName
LastName
BusinessPartnerName
PostalCode
ContractAccountCategory _CAHeader ContractAccountCategory Cont. Acct Cat.
CAAuthorizationGroup _ContractAccount CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup _ProviderContract CAAuthorizationGroup AuthorizGroup
_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_CACollectionVol.
-- 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: CCACOLLVOL
-- Parameters: P_Currency : waers_kk, P_Date : sydatum, P_Language : sylangu

CREATE VIEW C_CACollectionVol AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  BusinessPartner,
  ContractAccount,
  CADunningCounter,
  CAContract,
  CASubApplication,
  _SubApp._CASubApplicationText[1:Language = :P_Language].CASubApplicationText AS CASubApplicationText,
  cast(1 as abap.int4) AS CANumberOfDunningNotices,
  _CompCode[1:Language = :P_Language].CompanyCodeName AS CompanyCodeName,
  BusinessArea,
  Division,
  CAIssueDate,
  CACollectionStrategy,
  _CollectionStrategy._Text[1:Language = :P_Language].CACollectionStrategyName AS CACollectionStrategyName,
  CACollectionStep,
  _CollectionStep._Text[1:Language = :P_Language].CACollectionStepName AS CACollectionStepName,
  $parameters.P_Currency AS DisplayCurrency,
  _CAPartner._BusinessPartner.FirstName AS FirstName,
  _CAPartner._BusinessPartner.LastName AS LastName,
  _CAPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CAPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _CAHeader.ContractAccountCategory AS ContractAccountCategory,
  _ContractAccount.CAAuthorizationGroup AS CAAuthorizationGroup,
  _ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CADunningHeader
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]
LEFT OUTER JOIN I_CASubApplication AS _SubApp ON CASubApplication = _SubApp.CASubApplication  -- association [0..1]
;

Learn More