What is I_CAOverdueItem in SAP S/4HANA?

I_CAOverdueItem is a composite CDS view in SAP S/4HANA. Contract Accounting Overdue Item It contains 24 fields.

Which tables does I_CAOverdueItem read from?

I_CAOverdueItem reads data from: P_CAOverdueItemSelection.

What VDM layer is I_CAOverdueItem?

I_CAOverdueItem is classified as a Composite view that combines data from multiple basic views.

I_CAOverdueItem

DDL: I_CAOVERDUEITEM Type: view_entity COMPOSITE Package: FKKB

24 Fields 1 Data Sources 10 Associations

Contract Accounting Overdue Item

I_CAOverdueItem (Composite)

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

Contract Accounting

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

SAP Help Documentation

Category	CDS Views for Transaction Data
Data Category	Fact

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 The SAP_A4C_BC_DEV_TST_FICA_PC ( Development - API Test - Contract Accounting ) business catalog needs to be assigned to a user to be able to use this CDS view.

View on SAP Help Portal →

SAP API Hub

Category	Composite
State	C1
Line of Business	Contract Accounting
Application Component	FI-CA-2CL
Capabilities	Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Contract Accounting for SAP S/4HANA Cloud Public 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

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_CAOverdueItemSelection	P_CAOverdueItemSelection	from

Associations (10)

Cardinality	Target	Alias	Condition
[1..1]	I_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[0..1]	I_CADocument	_CADocument_2	`$projection.CADocumentNumber = _CADocument_2.CADocumentNumber`
[0..1]	I_CADocumentBPItem	_CADocumentBPItem_2	`$projection.CADocumentNumber = _CADocumentBPItem_2.CADocumentNumber and $projection.CARepetitionItemNumber = _CADocumentBPItem_2.CARepetitionItemNumber and $projection.CABPItemNumber = _CADocumentBPItem_2.CABPItemNumber and $projection.CASubItemNumber = _CADocumentBPItem_2.CASubItemNumber`
[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`
[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`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
Analytics.dataCategory	#FACT	view
Analytics.internalName	#LOCAL	view
EndUserText.label	Contract Accounting Overdue Item	view
Metadata.ignorePropagatedAnnotations	true	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 (24)

Key	Field	Source Field	Description
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_2	_CADocument_2
	_CADocumentBPItem_2	_CADocumentBPItem_2
	_CAOverdueItemOrigin	_CAOverdueItemOrigin
	_CompanyCode	_CompanyCode
	_CompanyCodeCurrency	_CompanyCodeCurrency
	_ContractAccount	_ContractAccount
	_TransactionCurrency	_TransactionCurrency
	_CADocument	_CADocument
	_CADocumentBPItem	_CADocumentBPItem

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_CADocument AS _CADocument_2 ON CADocumentNumber = _CADocument_2.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN I_CADocumentBPItem AS _CADocumentBPItem_2 ON CADocumentNumber = _CADocumentBPItem_2.CADocumentNumber AND CARepetitionItemNumber = _CADocumentBPItem_2.CARepetitionItemNumber AND CABPItemNumber = _CADocumentBPItem_2.CABPItemNumber AND CASubItemNumber = _CADocumentBPItem_2.CASubItemNumber  -- 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]
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]
;

Depth:

I_CAOverdueItem view_entity

P_CAOverdueItemSelection view_entity