A_CADunningItem

DDL: A_CADUNNINGITEM Type: view_entity CONSUMPTION
36 Fields 1 Data Sources 2 Associations

Dunning Item

A_CADunningItem is a Consumption CDS View that provides data about "Dunning Item" in SAP S/4HANA. It reads from 1 data source (R_CADunningItemTP) and exposes 36 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_CADunningItemTP R_CADunningItemTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_ContractAccountPartner_2 _CAPartner $projection.BusinessPartner = _CAPartner.BusinessPartner and $projection.ContractAccount = _CAPartner.ContractAccount
[0..1] A_CAProviderContract _ProviderContract $projection.CASubApplication = 'P' and $projection.CAContract = _ProviderContract.CAProviderContract

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Dunning Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
OData.entityType.name CADunningItem_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

Fields (36)

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
KEY CADocumentNumber CADocumentNumber Document Number
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item
KEY CABPItemNumber CABPItemNumber Item
KEY CASubItemNumber CASubItemNumber Subitem
CompanyCode CompanyCode Receiver Company Code
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
Segment Segment Segment number
ProfitCenter ProfitCenter Profit Center
Division Division Internal Division ID
TransactionCurrency TransactionCurrency Transaction Currency
CADunningAmount CADunningAmount
CADunningInterestAmount CADunningInterestAmount
CADocumentForDunningInterest CADocumentForDunningInterest
CANetDueDate CANetDueDate Net Due Date
CADunningActivityRunDate CADunningActivityRunDate
CAIssueDate CAIssueDate
CADunningLevel CADunningLevel
CADunningLevelCategory CADunningLevelCategory
CANextDunningLevel CANextDunningLevel
CADunningLevelIsOptional CADunningLevelIsOptional
CADunningLevelIsOnlyForIntRsn CADunningLevelIsOnlyForIntRsn
CADunningNoticeIsReversed CADunningNoticeIsReversed
CADunningNoticeIsInfoOnly CADunningNoticeIsInfoOnly
ContractAccountIsNotUnique ContractAccountIsNotUnique
CADunningProcedure CADunningProcedure Dunning Proc.
CAItemHasHigherDunningLevel CAItemHasHigherDunningLevel
CAItemIsCreatedByDunActyRun CAItemIsCreatedByDunActyRun
_DunHeaderredirectedtoparentA_CADunning
_CAPartner _CAPartner
_ProviderContract _ProviderContract

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 A_CADunningItem.
-- 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.

CREATE VIEW A_CADunningItem AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  BusinessPartner,
  ContractAccount,
  CADunningCounter,
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CompanyCode,
  CAContract,
  CASubApplication,
  Segment,
  ProfitCenter,
  Division,
  TransactionCurrency,
  CADunningAmount,
  CADunningInterestAmount,
  CADocumentForDunningInterest,
  CANetDueDate,
  CADunningActivityRunDate,
  CAIssueDate,
  CADunningLevel,
  CADunningLevelCategory,
  CANextDunningLevel,
  CADunningLevelIsOptional,
  CADunningLevelIsOnlyForIntRsn,
  CADunningNoticeIsReversed,
  CADunningNoticeIsInfoOnly,
  ContractAccountIsNotUnique,
  CADunningProcedure,
  CAItemHasHigherDunningLevel,
  CAItemIsCreatedByDunActyRun
FROM R_CADunningItemTP
LEFT OUTER JOIN A_ContractAccountPartner_2 AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [1..1]
LEFT OUTER JOIN A_CAProviderContract AS _ProviderContract ON CASubApplication = 'P' AND CAContract = _ProviderContract.CAProviderContract  -- association [0..1]
;

Learn More