P_CADunningSuccess

DDL: P_CADUNNINGSUCCESS SQL: PCADUNSUCCESS Type: view CONSUMPTION
36 Fields 1 Data Sources

P_CADunningSuccess is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_CADunningHeader) and exposes 36 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter.

Data Sources (1)

SourceAliasJoin Type
I_CADunningHeader DunHeader from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (8)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PCADUNSUCCESS view

Fields (36)

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
CAIssueDate I_CADunningHeader CAIssueDate Dunning Date
CAContract I_CADunningHeader CAContract Contract
CASubApplication I_CADunningHeader CASubApplication Subapplication
CompanyCodeName
BusinessArea I_CADunningHeader BusinessArea Business Area
Division I_CADunningHeader Division Internal Division ID
CADunningProcedure I_CADunningHeader CADunningProcedure Dunning Proc.
CADunningProcedureName
CADunningLevel I_CADunningHeader CADunningLevel Old Dunn.Level
CADunningLevelName
CACollectionStrategy I_CADunningHeader CACollectionStrategy Coll. Strategy
CACollectionStrategyName
CACollectionStep I_CADunningHeader CACollectionStep Step Number
CACollectionStepName
CADunningBalance CADunningBalance Dunning Balance
CADunningBalanceOfSuccess
CADunningAmount _DunItem CADunningAmount
CADunningAmountOfSuccess
TransactionCurrency I_CADunningHeader TransactionCurrency Transaction Currency
Segment _DunItem Segment Segment number
SegmentName
CADocumentType
CAAccountDeterminationCode
CAMainTransaction
CASubTransaction
FirstName
LastName
PostalCode
ContractAccountCategory
CAAuthorizationGroup
CAProviderContractAuthznGroup

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 P_CADunningSuccess.
-- 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: PCADUNSUCCESS
-- Parameters: P_Language : sylangu

CREATE VIEW P_CADunningSuccess AS
SELECT
  DunHeader.CAMassRunDate AS CAMassRunDate,
  DunHeader.CAMassRunID AS CAMassRunID,
  DunHeader.BusinessPartner AS BusinessPartner,
  DunHeader.ContractAccount AS ContractAccount,
  DunHeader.CADunningCounter AS CADunningCounter,
  DunHeader.CAIssueDate AS CAIssueDate,
  DunHeader.CAContract AS CAContract,
  DunHeader.CASubApplication AS CASubApplication,
  DunHeader._CompCode[1:Language = :P_Language].CompanyCodeName AS CompanyCodeName,
  DunHeader.BusinessArea AS BusinessArea,
  DunHeader.Division AS Division,
  DunHeader.CADunningProcedure AS CADunningProcedure,
  DunHeader._DunningProcedure._Text[1:Language = :P_Language].CADunningProcedureName AS CADunningProcedureName,
  DunHeader.CADunningLevel AS CADunningLevel,
  DunHeader._DunningLevel._Text[1:Language = :P_Language].CADunningLevelName AS CADunningLevelName,
  DunHeader.CACollectionStrategy AS CACollectionStrategy,
  DunHeader._CollectionStrategy._Text[1:Language = :P_Language].CACollectionStrategyName AS CACollectionStrategyName,
  DunHeader.CACollectionStep AS CACollectionStep,
  DunHeader._CollectionStep._Text[1:Language = :P_Language].CACollectionStepName AS CACollectionStepName,
  CADunningBalance,
  cast(division(CASuccessPercentage * CADunningBalance ,100,2) as abap.curr( 13, 2 )) AS CADunningBalanceOfSuccess,
  _DunItem.CADunningAmount AS CADunningAmount,
  cast(division(CASuccessPercentage * _DunItem.CADunningAmount ,100,2) as abap.curr( 13, 2 )) AS CADunningAmountOfSuccess,
  DunHeader.TransactionCurrency AS TransactionCurrency,
  _DunItem.Segment AS Segment,
  _DunItem._Segment._Text[1:Language = :P_Language].SegmentName AS SegmentName,
  _DunItem._DocBPItem.CADocumentType AS CADocumentType,
  _DunItem._DocBPItem.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  _DunItem._DocBPItem.CAMainTransaction AS CAMainTransaction,
  _DunItem._DocBPItem.CASubTransaction AS CASubTransaction,
  DunHeader._BusinessPartner.FirstName AS FirstName,
  DunHeader._BusinessPartner.LastName AS LastName,
  DunHeader._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  DunHeader._CAHeader.ContractAccountCategory AS ContractAccountCategory,
  DunHeader._CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _DunItem._ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM I_CADunningHeader AS DunHeader
;

Learn More