What is P_OverdueAccountsReceivables2 in SAP S/4HANA?

P_OverdueAccountsReceivables2 is a composite CDS view in SAP S/4HANA. Overdue Accounts Receivables Smart Business App 2 It contains 56 fields.

Which tables does P_OverdueAccountsReceivables2 read from?

P_OverdueAccountsReceivables2 reads data from: P_OverdueAccountsReceivables1a, P_ReceivablesItem, P_ReceivablesItem, P_ReceivablesItem, P_ReceivablesItem and more.

What VDM layer is P_OverdueAccountsReceivables2?

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

P_OverdueAccountsReceivables2

DDL: P_OVERDUEACCOUNTSRECEIVABLES2 SQL: POVRDUEACCTRBLS2 Type: view COMPOSITE Package: FINS_FIS_APAR_APPS

56 Fields 6 Data Sources

Overdue Accounts Receivables Smart Business App 2

P_OverdueAccountsReceivables2 is a Composite CDS View that provides data about "Overdue Accounts Receivables Smart Business App 2" in SAP S/4HANA. It reads from 6 data sources and exposes 56 fields with key fields CompanyCode, Customer, NetDueDate, SpecialGLCode, GLAccount. Part of development package FINS_FIS_APAR_APPS.

Data Sources (6)

Source	Alias	Join Type
P_OverdueAccountsReceivables1a	P_OverdueAccountsReceivables1a	union_all
P_ReceivablesItem	P_ReceivablesItem	from
P_ReceivablesItem	P_ReceivablesItem	union_all
P_ReceivablesItem	P_ReceivablesItem	union_all
P_ReceivablesItem	P_ReceivablesItem	union_all
P_ReceivablesItem	P_ReceivablesItem	union_all

Parameters (4)

Name	Type	Default
P_KeyDate	sydate
P_NetDueInterval1InDays	farp_net_due_interval1
P_NetDueInterval2InDays	farp_net_due_interval2
P_NetDueInterval3InDays	farp_net_due_interval3

Annotations (5)

Name	Value	Level
AbapCatalog.sqlViewName	POVRDUEACCTRBLS2	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (56)

Key	Field	Source Field	Description
KEY	CompanyCode	CompanyCode	Receiver Company Code
KEY	Customer	Debtor	Sold-to Party
KEY	NetDueDate		Net Due Date
KEY	SpecialGLCode	SpecialGLCode	Special G/L Ind
KEY	GLAccount	GLAccount	General Ledger
KEY	CreditControlArea	CreditControlArea	Credit Control Area
KEY	NetOverdueDays
KEY	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	MaxNetDueIntervallInDays
	AmountInCompanyCodeCurrency		Local Crcy Amt
KEY	Customer	Debtor	Sold-to Party
KEY	NetDueDate		Net Due Date
KEY	SpecialGLCode	SpecialGLCode	Special G/L Ind
KEY	GLAccount	GLAccount	General Ledger
KEY	CreditControlArea	CreditControlArea	Credit Control Area
KEY	NetOverdueDays
KEY	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	MaxNetDueIntervallInDays
	AmountInCompanyCodeCurrency		Local Crcy Amt
KEY	Customer	Debtor	Sold-to Party
KEY	NetDueDate		Net Due Date
KEY	SpecialGLCode	SpecialGLCode	Special G/L Ind
KEY	GLAccount	GLAccount	General Ledger
KEY	CreditControlArea	CreditControlArea	Credit Control Area
KEY	NetOverdueDays
KEY	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	MaxNetDueIntervallInDays
	AmountInCompanyCodeCurrency		Local Crcy Amt
KEY	Customer	Debtor	Sold-to Party
KEY	NetDueDate		Net Due Date
KEY	SpecialGLCode	SpecialGLCode	Special G/L Ind
KEY	GLAccount	GLAccount	General Ledger
KEY	CreditControlArea	CreditControlArea	Credit Control Area
KEY	NetOverdueDays
KEY	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	MaxNetDueIntervallInDays
	AmountInCompanyCodeCurrency		Local Crcy Amt
KEY	Customer	Debtor	Sold-to Party
KEY	NetDueDate		Net Due Date
KEY	SpecialGLCode	SpecialGLCode	Special G/L Ind
KEY	GLAccount	GLAccount	General Ledger
KEY	CreditControlArea	CreditControlArea	Credit Control Area
KEY	NetOverdueDays
KEY	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	MaxNetDueIntervallInDays
	AmountInCompanyCodeCurrency		Local Crcy Amt
KEY	Customer	Customer	Sold-to Party
KEY	NetDueDate	NetDueDate	Net Due Date
KEY	SpecialGLCode	SpecialGLCode	Special G/L Ind
KEY	GLAccount	GLAccount	General Ledger
KEY	CreditControlArea	CreditControlArea	Credit Control Area
KEY	NetOverdueDays	NetOverdueDays
KEY	CompanyCodeCurrency	CompanyCodeCurrency	Local Currency
	MaxNetDueIntervallInDays
	AmountInCompanyCodeCurrency	AmountInCompanyCodeCurrency	Local Crcy Amt
	NumberOfOpenItems	NumberOfOpenItems

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_OverdueAccountsReceivables2.
-- 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: POVRDUEACCTRBLS2
-- Parameters: P_KeyDate : sydate, P_NetDueInterval1InDays : farp_net_due_interval1, P_NetDueInterval2InDays : farp_net_due_interval2, P_NetDueInterval3InDays : farp_net_due_interval3

CREATE VIEW P_OverdueAccountsReceivables2 AS
SELECT
  CompanyCode,
  Debtor AS Customer,
  '00000000' AS NetDueDate,
  SpecialGLCode,
  GLAccount,
  CreditControlArea,
  cast( 0 as abap.int4 ) AS NetOverdueDays,
  CompanyCodeCurrency,
  cast( 99999 as abap.int4 ) AS MaxNetDueIntervallInDays,
  cast( 0 as abap.curr(23,2) ) AS AmountInCompanyCodeCurrency,
  NumberOfOpenItems
FROM P_ReceivablesItem
-- UNION ALL with additional select branch(es): P_ReceivablesItem, P_OverdueAccountsReceivables1a
;

Depth:

P_OverdueAccountsReceivables2 view

P_OverdueAccountsReceivables3 view