C_CACollectionSuccess

DDL: C_CACOLLECTIONSUCCESS SQL: CCACOLLSUCCESS Type: view CONSUMPTION
33 Fields 1 Data Sources

Analyse des Collection Erfolgs

C_CACollectionSuccess is a Consumption CDS View that provides data about "Analyse des Collection Erfolgs" in SAP S/4HANA. It reads from 1 data source (P_CADunningSuccess) and exposes 33 fields.

Data Sources (1)

SourceAliasJoin Type
P_CADunningSuccess P_CADunningSuccess from

Parameters (3)

NameTypeDefault
P_Currency waers_kk
P_Date sydatum
P_Language sylangu

Annotations (9)

NameValueLevelField
EndUserText.label Analyse des Collection Erfolgs 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 CCACOLLSUCCESS view

Fields (33)

KeyFieldSource TableSource FieldDescription
CAMassRunDate DunSuccess CAMassRunDate Date ID
CAMassRunID DunSuccess CAMassRunID Run ID
BusinessPartner DunSuccess BusinessPartner Issuing Authority
ContractAccount DunSuccess ContractAccount Contract Acct
CADunningCounter DunSuccess CADunningCounter Dunning counter
CAContract DunSuccess CAContract Contract
CASubApplication DunSuccess CASubApplication Subapplication
CompanyCodeName CompanyCodeName Company Name
BusinessArea BusinessArea Business Area
Division Division Internal Division ID
CAIssueDate DunSuccess CAIssueDate
CACollectionStrategy CACollectionStrategy Coll. Strategy
CACollectionStrategyName CACollectionStrategyName
CACollectionStep CACollectionStep
CACollectionStepName CACollectionStepName
TransactionCurrency DunSuccess TransactionCurrency Transaction Currency
CADunBalanceInDspCrcy DunSuccess CADunningBalance
CADunBalanceOfSuccessInDspCrcy DunSuccess CADunningBalanceOfSuccess
CADunAmountInDspCrcy DunSuccess CADunningAmount
CADunAmountOfSuccessInDspCrcy DunSuccess CADunningAmountOfSuccess
DisplayCurrency
Segment Segment Segment number
SegmentName SegmentName Segment Name
CADocumentType CADocumentType Document Type
CAAccountDeterminationCode CAAccountDeterminationCode Acct Determ. ID
CAMainTransaction CAMainTransaction Main Trans.
CASubTransaction CASubTransaction Subtransaction
FirstName FirstName First Name
LastName LastName Last Name
PostalCode PostalCode Postal Code
ContractAccountCategory ContractAccountCategory Cont. Acct Cat.
CAAuthorizationGroup CAAuthorizationGroup AuthorizGroup
CAProviderContractAuthznGroup CAProviderContractAuthznGroup

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_CACollectionSuccess.
-- 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: CCACOLLSUCCESS
-- Parameters: P_Currency : waers_kk, P_Date : sydatum, P_Language : sylangu

CREATE VIEW C_CACollectionSuccess AS
SELECT
  DunSuccess.CAMassRunDate AS CAMassRunDate,
  DunSuccess.CAMassRunID AS CAMassRunID,
  DunSuccess.BusinessPartner AS BusinessPartner,
  DunSuccess.ContractAccount AS ContractAccount,
  DunSuccess.CADunningCounter AS CADunningCounter,
  DunSuccess.CAContract AS CAContract,
  DunSuccess.CASubApplication AS CASubApplication,
  CompanyCodeName,
  BusinessArea,
  Division,
  DunSuccess.CAIssueDate AS CAIssueDate,
  CACollectionStrategy,
  CACollectionStrategyName,
  CACollectionStep,
  CACollectionStepName,
  DunSuccess.TransactionCurrency AS TransactionCurrency,
  DunSuccess.CADunningBalance AS CADunBalanceInDspCrcy,
  DunSuccess.CADunningBalanceOfSuccess AS CADunBalanceOfSuccessInDspCrcy,
  DunSuccess.CADunningAmount AS CADunAmountInDspCrcy,
  DunSuccess.CADunningAmountOfSuccess AS CADunAmountOfSuccessInDspCrcy,
  $parameters.P_Currency AS DisplayCurrency,
  Segment,
  SegmentName,
  CADocumentType,
  CAAccountDeterminationCode,
  CAMainTransaction,
  CASubTransaction,
  FirstName,
  LastName,
  PostalCode,
  ContractAccountCategory,
  CAAuthorizationGroup,
  CAProviderContractAuthznGroup
FROM P_CADunningSuccess
;

Learn More