P_SchedAgrmtOverdueQtyCalc

DDL: P_SCHEDAGRMTOVERDUEQTYCALC SQL: PSAOVERDUEQTY Type: view CONSUMPTION
3 Fields 2 Data Sources

Calculation of Overdue Quantity in SA

P_SchedAgrmtOverdueQtyCalc is a Consumption CDS View that provides data about "Calculation of Overdue Quantity in SA" in SAP S/4HANA. It reads from 2 data sources (I_SchedgAgrmtItm, I_Schedgline) and exposes 3 fields with key fields SchedulingAgreement, SchedulingAgreementItem.

Data Sources (2)

SourceAliasJoin Type
I_SchedgAgrmtItm SchedgAgrmtItm from
I_Schedgline ScheduleLine inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PSAOVERDUEQTY view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Calculation of Overdue Quantity in SA view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement I_SchedgAgrmtItm SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem I_SchedgAgrmtItm SchedulingAgreementItem Schedule Item Number
SchedgAgrmtItmOverdueQty

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_SchedAgrmtOverdueQtyCalc.
-- 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: PSAOVERDUEQTY

CREATE VIEW P_SchedAgrmtOverdueQtyCalc AS
SELECT
  SchedgAgrmtItm.SchedulingAgreement AS SchedulingAgreement,
  SchedgAgrmtItm.SchedulingAgreementItem AS SchedulingAgreementItem,
  sum(ScheduleLineOpenQuantity) AS SchedgAgrmtItmOverdueQty
FROM I_SchedgAgrmtItm AS SchedgAgrmtItm
INNER JOIN I_Schedgline AS ScheduleLine ON /* join condition not captured in parsed metadata */
;

Learn More