C_CADunningNoticeCFO

DDL: C_CADUNNINGNOTICECFO SQL: CCADUNNOTCFO Type: view CONSUMPTION
19 Fields 1 Data Sources

Mahnung

C_CADunningNoticeCFO is a Consumption CDS View that provides data about "Mahnung" in SAP S/4HANA. It reads from 1 data source (I_CADunningHistory) and exposes 19 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter.

Data Sources (1)

SourceAliasJoin Type
I_CADunningHistory _CADunningHistory from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCADUNNOTCFO view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Mahnung view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view

Fields (19)

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
CADunningLevel Mahnstufe
OldDunningLevel I_CADunningHistory CADunningLevel
CADunningLevelName
CADunningBalance I_CADunningHistory CADunningBalance
TransactionCurrency I_CADunningHistory TransactionCurrency Transaction Currency
CADunningProcedure I_CADunningHistory CADunningProcedure Dunning Proc.
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CASubApplicationText
CADunningProcedureName
_DunningLevel _DunningLevel
_DunningProcedure _DunningProcedure

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_CADunningNoticeCFO.
-- 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: CCADUNNOTCFO

CREATE VIEW C_CADunningNoticeCFO 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,
  cast( _CADunningHistory.CADunningLevel as char2 ) AS CADunningLevel,
  _CADunningHistory.CADunningLevel AS OldDunningLevel,
  _CADunningHistory._DunningLevel._Text[1:Language = $session.system_language].CADunningLevelName AS CADunningLevelName,
  _CADunningHistory.CADunningBalance AS CADunningBalance,
  _CADunningHistory.TransactionCurrency AS TransactionCurrency,
  _CADunningHistory.CADunningProcedure AS CADunningProcedure,
  CAContract,
  CASubApplication,
  _SubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText,
  _CADunningHistory._DunningProcedure._Text[1:Language = $session.system_language].CADunningProcedureName AS CADunningProcedureName
FROM I_CADunningHistory AS _CADunningHistory
;

Learn More