I_DunHistLineItem

DDL: I_DUNHISTLINEITEM SQL: IDUNHISTLINEITEM Type: view BASIC
10 Fields 1 Data Sources

Dunning History for Line Item

I_DunHistLineItem is a Basic CDS View that provides data about "Dunning History for Line Item" in SAP S/4HANA. It reads from 1 data source (fkkmaze) and exposes 10 fields with key fields CAMassRunDate, CAMassRunID, BusinessPartner, ContractAccount, CADunningCounter.

Data Sources (1)

SourceAliasJoin Type
fkkmaze fkkmaze from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IDUNHISTLINEITEM view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.clientSafe true view
EndUserText.label Dunning History for Line Item view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate laufd Run On
KEY CAMassRunID laufi Settlement ID
KEY BusinessPartner gpart Tech. BPartner
KEY ContractAccount vkont Tech. CtrAcct
KEY CADunningCounter mazae Dunning counter
KEY CADocumentNumber opbel Reopen
KEY CARepetitionItemNumber opupw Repetition Item
KEY CABPItemNumber opupk Item
KEY CASubItemNumber opupz Subitem
CAContract vtref Contract

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_DunHistLineItem.
-- 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: IDUNHISTLINEITEM

CREATE VIEW I_DunHistLineItem AS
SELECT
  laufd AS CAMassRunDate,
  laufi AS CAMassRunID,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  mazae AS CADunningCounter,
  opbel AS CADocumentNumber,
  opupw AS CARepetitionItemNumber,
  opupk AS CABPItemNumber,
  opupz AS CASubItemNumber,
  vtref AS CAContract
FROM fkkmaze
;

Learn More