C_CADunningNoticeCollectionCFO

DDL: C_CADUNNINGNOTICECOLLECTIONCFO SQL: CCADUNNOTCOLCFO Type: view CONSUMPTION
18 Fields 1 Data Sources

Mahnungen aus Collection-Strategie

C_CADunningNoticeCollectionCFO is a Consumption CDS View that provides data about "Mahnungen aus Collection-Strategie" in SAP S/4HANA. It reads from 1 data source (I_CADunningHistory) and exposes 18 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter.

Data Sources (1)

SourceAliasJoin Type
I_CADunningHistory _CADunningHistory from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCADUNNOTCOLCFO view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mahnungen aus Collection-Strategie view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate I_CADunningHistory CAMassRunDate Date ID
KEY CAMassRunID I_CADunningHistory CAMassRunID Run ID
KEY BusinessPartner I_CADunningHistory BusinessPartner Issuing Authority
KEY ContractAccount I_CADunningHistory ContractAccount Contract Acct
KEY CADunningCounter I_CADunningHistory CADunningCounter Dunning counter
CADunningCounterasCADunningNoticeUUID
CAIssueDate I_CADunningHistory CAIssueDate
CACollectionStep I_CADunningHistory CACollectionStep
CACollectionStepName
CADunningBalance I_CADunningHistory CADunningBalance
TransactionCurrency I_CADunningHistory TransactionCurrency Transaction Currency
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CASubApplicationText
CACollectionStrategy I_CADunningHistory CACollectionStrategy Coll. Strategy
CACollectionStrategyName
_CollectionStep _CollectionStep
_CollectionStrategy _CollectionStrategy

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_CADunningNoticeCollectionCFO.
-- 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: CCADUNNOTCOLCFO

CREATE VIEW C_CADunningNoticeCollectionCFO AS
SELECT
  _CADunningHistory.CAMassRunDate AS CAMassRunDate,
  _CADunningHistory.CAMassRunID AS CAMassRunID,
  _CADunningHistory.BusinessPartner AS BusinessPartner,
  _CADunningHistory.ContractAccount AS ContractAccount,
  _CADunningHistory.CADunningCounter AS CADunningCounter,
  concat ( concat ( concat( concat( _CADunningHistory.BusinessPartner, _CADunningHistory.ContractAccount), _CADunningHistory.CAMassRunDate ), _CADunningHistory.CAMassRunID ), _CADunningHistory.CADunningCounter ) as CADunningNoticeUUID AS CADunningCounterasCADunningNoticeUUID,
  _CADunningHistory.CAIssueDate AS CAIssueDate,
  _CADunningHistory.CACollectionStep AS CACollectionStep,
  _CADunningHistory._CollectionStep._Text[1:Language = $session.system_language].CACollectionStepName AS CACollectionStepName,
  _CADunningHistory.CADunningBalance AS CADunningBalance,
  _CADunningHistory.TransactionCurrency AS TransactionCurrency,
  CAContract,
  CASubApplication,
  _SubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  _CADunningHistory.CACollectionStrategy AS CACollectionStrategy,
  _CADunningHistory._CollectionStrategy._Text[1:Language = $session.system_language].CACollectionStrategyName AS CACollectionStrategyName
FROM I_CADunningHistory AS _CADunningHistory
;

Learn More