I_CAOverdueItem

DDL: I_CAOVERDUEITEM Type: view_entity COMPOSITE
22 Fields 1 Data Sources 8 Associations

Overdue Item

I_CAOverdueItem (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Contract Accounting

I_CAOverdueItem is a Composite CDS View (Fact) that provides data about "Overdue Item" in SAP S/4HANA. It reads from 1 data source (P_CAOverdueItemSelection) and exposes 22 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber, CAPromiseToPay. It has 8 associations to related views.

SAP Help Documentation

CategoryCDS Views for Transaction Data
Data CategoryFact
Purpose
This CDS view provides information about overdue items in Contract Accounting . Overdue items result from due document business partner items or due promises to pay. This CDS view provides the data to answer the following business questions: How many open receivables and promises to pay are overdue? What is the volume of overdue receivables for a specific business partner and/or contract account? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the F_KKKO_BUK ( Contract Accounting Company Code Authorization ) authorization object assigned.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessContract Accounting
Application ComponentFI-CA
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageContract Accounting for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides information about overdue items in Contract Accounting. Overdue items result from due document business partner items or due promises to pay.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>How many open receivables and promises to pay are overdue?</p></li> <li><p>What is the volume of overdue receivables for a specific business partner and/or contract account?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_CAOverdueItemSelection P_CAOverdueItemSelection from

Associations (8)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CADocumentBPItemPhysical _CADocumentBPItem $projection.CADocumentNumber = _CADocumentBPItem.CADocumentNumber and $projection.CARepetitionItemNumber = _CADocumentBPItem.CARepetitionItemNumber and $projection.CABPItemNumber = _CADocumentBPItem.CABPItemNumber and $projection.CASubItemNumber = _CADocumentBPItem.CASubItemNumber
[0..1] I_CADocumentHeader _CADocument $projection.CADocumentNumber = _CADocument.CADocumentNumber
[0..1] I_CAOverdueItemOrigin _CAOverdueItemOrigin $projection.CAOverdueItemOrigin = _CAOverdueItemOrigin.CAOverdueItemOrigin
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_ContractAccountHeader _ContractAccount $projection.ContractAccount = _ContractAccount.ContractAccount
[1..1] I_Currency _CompanyCodeCurrency $projection.CompanyCodeCurrency = _CompanyCodeCurrency.Currency
[1..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Overdue Item view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataCategory #FACT view
Analytics.internalName #LOCAL view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber CADocumentNumber Number of a FI-CA Document
KEY CARepetitionItemNumber CARepetitionItemNumber Repetition Item in FI-CA Document
KEY CABPItemNumber CABPItemNumber Item Number in FI-CA Document
KEY CASubItemNumber CASubItemNumber Subitem for a Partial Clearing in Document
KEY CAPromiseToPay CAPromiseToPay Identification of Promise to Pay
KEY CANetDueDate CANetDueDate Due date for net payment
CAOverdueItemOrigin CAOverdueItemOrigin Origin of Overdue Item
CompanyCode CompanyCode Receiver Company Code
BusinessPartner BusinessPartner Business Partner Number
ContractAccount ContractAccount Contract Account Number
TransactionCurrency TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency CAAmountInTransactionCurrency Amount in Transaction Currency with +/- Sign
CompanyCodeCurrency CompanyCodeCurrency Local Currency
CAAmountInLocalCurrency CAAmountInLocalCurrency Amount In Local Currency With +/- Signs
_BusinessPartner _BusinessPartner
_CADocument _CADocument
_CADocumentBPItem _CADocumentBPItem
_CAOverdueItemOrigin _CAOverdueItemOrigin
_CompanyCode _CompanyCode
_CompanyCodeCurrency _CompanyCodeCurrency
_ContractAccount _ContractAccount
_TransactionCurrency _TransactionCurrency

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_CAOverdueItem.
-- 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 I_CAOverdueItem AS
SELECT
  CADocumentNumber,
  CARepetitionItemNumber,
  CABPItemNumber,
  CASubItemNumber,
  CAPromiseToPay,
  CANetDueDate,
  CAOverdueItemOrigin,
  CompanyCode,
  BusinessPartner,
  ContractAccount,
  TransactionCurrency,
  CAAmountInTransactionCurrency,
  CompanyCodeCurrency,
  CAAmountInLocalCurrency
FROM P_CAOverdueItemSelection
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CADocumentBPItemPhysical AS _CADocumentBPItem ON CADocumentNumber = _CADocumentBPItem.CADocumentNumber AND CARepetitionItemNumber = _CADocumentBPItem.CARepetitionItemNumber AND CABPItemNumber = _CADocumentBPItem.CABPItemNumber AND CASubItemNumber = _CADocumentBPItem.CASubItemNumber  -- association [0..1]
LEFT OUTER JOIN I_CADocumentHeader AS _CADocument ON CADocumentNumber = _CADocument.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CAOverdueItemOrigin AS _CAOverdueItemOrigin ON CAOverdueItemOrigin = _CAOverdueItemOrigin.CAOverdueItemOrigin  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccount ON ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [1..1]
;

Learn More