R_CADunningTP

DDL: R_CADUNNINGTP Type: view_entity TRANSACTIONAL
100 Fields 1 Data Sources 1 Associations

Dunning Header - TP

R_CADunningTP is a Transactional CDS View that provides data about "Dunning Header - TP" in SAP S/4HANA. It reads from 1 data source (I_CADunningHeader) and exposes 100 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CADunningHeader I_CADunningHeader from

Associations (1)

CardinalityTargetAliasCondition
[1..*] R_CADunningItemTP _DunItem

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Dunning Header - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey BusinessPartner view

Fields (100)

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
CACompanyCodeGroup CACompanyCodeGroup Company Code Gp
BusinessArea BusinessArea Business Area
Division Division Internal Division ID
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CALeadingContractAccount CALeadingContractAccount Leading Account
CAAlternativeDunningRecipient CAAlternativeDunningRecipient Alt.dun. recip.
CADunningProcedure CADunningProcedure Dunning Proc.
CADunningNoticeGroup CADunningNoticeGroup Grouping
CADunningLevel CADunningLevel Old Dunn.Level
CADunningLevelCategory CADunningLevelCategory Dunn.Level Cat.
CAContrAcctGroupForCollMgmt CAContrAcctGroupForCollMgmt Account Group
CAContractGroupForCollMgmt CAContractGroupForCollMgmt Contract Group
CAClosedItemGroupForCollMgmt CAClosedItemGroupForCollMgmt Item Group
CAClosedItemGroupOfLastDunning CAClosedItemGroupOfLastDunning Item Group
CAGroupingFieldForCollMgmt CAGroupingFieldForCollMgmt Grouping Field
CAGroupingFieldOfLastDunning CAGroupingFieldOfLastDunning Grouping Field
CACollectionStrategy CACollectionStrategy Coll. Strategy
CACollectionStep CACollectionStep Step Number
CACollectionStepOfLastDunning CACollectionStepOfLastDunning CollStepLastDun
CAReplacedCollectionStep CAReplacedCollectionStep ReplacedCollStp
CAReplacedCollectionStrategy CAReplacedCollectionStrategy Champ.Strategy
CACollectionTestSeries CACollectionTestSeries Test Series
CACapForDunActyIsRestricted CACapForDunActyIsRestricted Restricted Cap.
CADunningNoticeMustBeReleased CADunningNoticeMustBeReleased For Release
CALatestReleaseDate CALatestReleaseDate Scheduled release
CAReleaseGroup CAReleaseGroup Release Group
CANextDunningDate CANextDunningDate Next Dunning
CAIssueDate CAIssueDate Dunning Date
DunningIssueDate DunningIssueDate Dunning Date
CADunningActivityRunDate CADunningActivityRunDate Print Date
CAPaymentTargetDate CAPaymentTargetDate Payment target
CAKeyDateForConsideredPayts CAKeyDateForConsideredPayts To Date
TransactionCurrency TransactionCurrency Transaction Currency
CADunningBalance CADunningBalance Dunning Balance
CADunningReductionAmount CADunningReductionAmount
CADunningChargesSchema CADunningChargesSchema Charges Sched.
CAAmountForDunningCharge1 CAAmountForDunningCharge1 Dun. charge 1
CADocumentForDunningCharge1 CADocumentForDunningCharge1 Doc no.charge 1
CATypeForDunningCharge1 CATypeForDunningCharge1 Charge type 1
CAPostingCodeForDunningCharge1 CAPostingCodeForDunningCharge1 Update
CAAmountForDunningCharge2 CAAmountForDunningCharge2 Dun.charge 2
CADocumentForDunningCharge2 CADocumentForDunningCharge2 Doc no C2
CATypeForDunningCharge2 CATypeForDunningCharge2 Charge type 2
CAPostingCodeForDunningCharge2 CAPostingCodeForDunningCharge2 Update
CAAmountForDunningCharge3 CAAmountForDunningCharge3 Dun.charge 3
CADocumentForDunningCharge3 CADocumentForDunningCharge3 Doc no C3
CATypeForDunningCharge3 CATypeForDunningCharge3 Charge type 3
CAPostingCodeForDunningCharge3 CAPostingCodeForDunningCharge3 Update
CADunningChargeAmount CADunningChargeAmount
CADunningInterestAmount CADunningInterestAmount Dunn.int.
CADocumentForDunningInterest CADocumentForDunningInterest Interest doc.
CACreditWorthinessBeforeDun CACreditWorthinessBeforeDun FI-CA Creditwth
CADunningNoticeIsReversed CADunningNoticeIsReversed Dunning canceled
CAPaymentFormNumber CAPaymentFormNumber Payment Form
CADunningNoticeIsInfoOnly CADunningNoticeIsInfoOnly Info item
CorrespondenceKey CorrespondenceKey Correspond. Key
CAIsSubmittedToCollAgency CAIsSubmittedToCollAgency SubmCollectAgny
CAPaymentFormExternalNumber CAPaymentFormExternalNumber Pmnt form ref.
CASubstituteDocumentCategory CASubstituteDocumentCategory Doc.Cat.
CASubstituteDocumentNumber CASubstituteDocumentNumber Sub. Doc.
CASuccessPercentage CASuccessPercentage Success
CAMaximumDeferralDate CAMaximumDeferralDate Max. Deferral
CADunningValuationRunDate CADunningValuationRunDate Determined On
CADunningValuationStatus CADunningValuationStatus Success Valuatn
_BPAltvDunRcpnt _BPAltvDunRcpnt
_BusinessArea _BusinessArea
_BusinessPartner _BusinessPartner
_CAHeader _CAHeader
_CAHeaderLeading _CAHeaderLeading
_CAPartner _CAPartner
_ChargesSchema _ChargesSchema
_ChargeType1 _ChargeType1
_ChargeType2 _ChargeType2
_ChargeType3 _ChargeType3
_CollectionStep _CollectionStep
_CollectionStrategy _CollectionStrategy
_CollStepLast _CollStepLast
_CollStepReplaced _CollStepReplaced
_CollStrategyReplaced _CollStrategyReplaced
_CompCode _CompCode
_CompCodeGroup _CompCodeGroup
_Currency _Currency
_Division _Division
_DocCharge1 _DocCharge1
_DocCharge2 _DocCharge2
_DocCharge3 _DocCharge3
_DocInterest _DocInterest
_DocSubstitute _DocSubstitute
_DunItem _DunItem
_DunningLevel _DunningLevel
_DunningLevelCat _DunningLevelCat
_DunningProcedure _DunningProcedure
_DunNoticeGroup _DunNoticeGroup
_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 R_CADunningTP.
-- 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 R_CADunningTP AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  BusinessPartner,
  ContractAccount,
  CADunningCounter,
  CACompanyCodeGroup,
  BusinessArea,
  Division,
  CAContract,
  CASubApplication,
  CALeadingContractAccount,
  CAAlternativeDunningRecipient,
  CADunningProcedure,
  CADunningNoticeGroup,
  CADunningLevel,
  CADunningLevelCategory,
  CAContrAcctGroupForCollMgmt,
  CAContractGroupForCollMgmt,
  CAClosedItemGroupForCollMgmt,
  CAClosedItemGroupOfLastDunning,
  CAGroupingFieldForCollMgmt,
  CAGroupingFieldOfLastDunning,
  CACollectionStrategy,
  CACollectionStep,
  CACollectionStepOfLastDunning,
  CAReplacedCollectionStep,
  CAReplacedCollectionStrategy,
  CACollectionTestSeries,
  CACapForDunActyIsRestricted,
  CADunningNoticeMustBeReleased,
  CALatestReleaseDate,
  CAReleaseGroup,
  CANextDunningDate,
  CAIssueDate,
  DunningIssueDate,
  CADunningActivityRunDate,
  CAPaymentTargetDate,
  CAKeyDateForConsideredPayts,
  TransactionCurrency,
  CADunningBalance,
  CADunningReductionAmount,
  CADunningChargesSchema,
  CAAmountForDunningCharge1,
  CADocumentForDunningCharge1,
  CATypeForDunningCharge1,
  CAPostingCodeForDunningCharge1,
  CAAmountForDunningCharge2,
  CADocumentForDunningCharge2,
  CATypeForDunningCharge2,
  CAPostingCodeForDunningCharge2,
  CAAmountForDunningCharge3,
  CADocumentForDunningCharge3,
  CATypeForDunningCharge3,
  CAPostingCodeForDunningCharge3,
  CADunningChargeAmount,
  CADunningInterestAmount,
  CADocumentForDunningInterest,
  CACreditWorthinessBeforeDun,
  CADunningNoticeIsReversed,
  CAPaymentFormNumber,
  CADunningNoticeIsInfoOnly,
  CorrespondenceKey,
  CAIsSubmittedToCollAgency,
  CAPaymentFormExternalNumber,
  CASubstituteDocumentCategory,
  CASubstituteDocumentNumber,
  CASuccessPercentage,
  CAMaximumDeferralDate,
  CADunningValuationRunDate,
  CADunningValuationStatus
FROM I_CADunningHeader
LEFT OUTER JOIN R_CADunningItemTP AS _DunItem ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More