I_CADunningLetterHeader

DDL: I_CADUNNINGLETTERHEADER SQL: ICADUNLTRHEAD Type: view COMPOSITE
26 Fields 1 Data Sources 1 Associations

Mahnschreiben - Kopfdaten

I_CADunningLetterHeader is a Composite CDS View that provides data about "Mahnschreiben - Kopfdaten" 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 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADunningHeader Dunning from

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner

Annotations (8)

NameValueLevelField
EndUserText.label Mahnschreiben - Kopfdaten view
VDM.viewType #COMPOSITE 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
AbapCatalog.sqlViewName ICADUNLTRHEAD view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate I_CADunningHeader CAMassRunDate Date ID
KEY CAMassRunID I_CADunningHeader CAMassRunID Run ID
KEY BusinessPartner I_CADunningHeader BusinessPartner Issuing Authority
KEY ContractAccount I_CADunningHeader ContractAccount Contract Acct
KEY CADunningCounter I_CADunningHeader CADunningCounter Dunning counter
ContractAccountName
CAContract I_CADunningHeader CAContract Contract
CADunningChargeAmount
CADunningInterestAmount I_CADunningHeader CADunningInterestAmount Dunn.int.
CAPaymentTargetDate I_CADunningHeader CAPaymentTargetDate Payment target
CorrespondenceIssueDate Correspndc CorrespondenceIssueDate
Currency Correspndc Currency Valuation Crcy
CompanyCode Correspndc CompanyCode Receiver Company Code
CACorrespondenceType Correspndc CACorrespondenceType Corresp. Type
CACorrespondence Correspndc CACorrespondence
CADunningProcedure I_CADunningHeader CADunningProcedure Dunning Proc.
CADunningLevel I_CADunningHeader CADunningLevel Old Dunn.Level
CACollectionStrategy I_CADunningHeader CACollectionStrategy Coll. Strategy
CACollectionStep I_CADunningHeader CACollectionStep Step Number
CADunningProcedureName
CADunningLevelName
CACollectionStrategyName
CACollectionStepName
CAPaymentFormNumber I_CADunningHeader CAPaymentFormNumber Payment Form
CAPaymentFormExternalNumber I_CADunningHeader CAPaymentFormExternalNumber Pmnt form ref.
_BusinessPartner _BusinessPartner

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 I_CADunningLetterHeader.
-- 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: ICADUNLTRHEAD
-- Parameters: P_Language : sylangu

CREATE VIEW I_CADunningLetterHeader AS
SELECT
  Dunning.CAMassRunDate AS CAMassRunDate,
  Dunning.CAMassRunID AS CAMassRunID,
  Dunning.BusinessPartner AS BusinessPartner,
  Dunning.ContractAccount AS ContractAccount,
  Dunning.CADunningCounter AS CADunningCounter,
  Dunning._CAHeader.ContractAccountName AS ContractAccountName,
  Dunning.CAContract AS CAContract,
  ( Dunning.CAAmountForDunningCharge1 + Dunning.CAAmountForDunningCharge2 + Dunning.CAAmountForDunningCharge3 ) AS CADunningChargeAmount,
  Dunning.CADunningInterestAmount AS CADunningInterestAmount,
  Dunning.CAPaymentTargetDate AS CAPaymentTargetDate,
  Correspndc.CorrespondenceIssueDate AS CorrespondenceIssueDate,
  Correspndc.Currency AS Currency,
  Correspndc.CompanyCode AS CompanyCode,
  Correspndc.CACorrespondenceType AS CACorrespondenceType,
  Correspndc.CACorrespondence AS CACorrespondence,
  Dunning.CADunningProcedure AS CADunningProcedure,
  Dunning.CADunningLevel AS CADunningLevel,
  Dunning.CACollectionStrategy AS CACollectionStrategy,
  Dunning.CACollectionStep AS CACollectionStep,
  Dunning._DunningProcedure._Text[1:Language = :P_Language].CADunningProcedureName AS CADunningProcedureName,
  Dunning._DunningLevel._Text[1:Language = :P_Language].CADunningLevelName AS CADunningLevelName,
  Dunning._CollectionStrategy._Text[1:Language = :P_Language].CACollectionStrategyName AS CACollectionStrategyName,
  Dunning._CollectionStep._Text[1:Language = :P_Language].CACollectionStepName AS CACollectionStepName,
  Dunning.CAPaymentFormNumber AS CAPaymentFormNumber,
  Dunning.CAPaymentFormExternalNumber AS CAPaymentFormExternalNumber
FROM I_CADunningHeader AS Dunning
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
;

Learn More