What is P_POItemClosedScheduleLines in SAP S/4HANA?

P_POItemClosedScheduleLines is a consumption CDS view in SAP S/4HANA. PO Item Closed Schedule Line It contains 66 fields.

What VDM layer is P_POItemClosedScheduleLines?

P_POItemClosedScheduleLines is classified as a Consumption view optimized for specific business scenarios and reporting.

P_POItemClosedScheduleLines

Q: Which tables does P_POItemClosedScheduleLines read from?

P_POItemClosedScheduleLines reads data from: I_PurgAnalyticsConfiguration, I_PurgAnalyticsConfiguration, P_POItemSchdLnLastPostgDate, P_POItmSchdLnLastPostgDteEnhcd.

DDL: P_POITEMCLOSEDSCHEDULELINES SQL: PPOICLSL Type: view CONSUMPTION Package: APPL_MM_PUR_DLVPRED_ML

66 Fields 4 Data Sources 1 Associations

PO Item Closed Schedule Line

P_POItemClosedScheduleLines is a Consumption CDS View that provides data about "PO Item Closed Schedule Line" in SAP S/4HANA. It reads from 4 data sources (I_PurgAnalyticsConfiguration, I_PurgAnalyticsConfiguration, P_POItemSchdLnLastPostgDate, P_POItmSchdLnLastPostgDteEnhcd) and exposes 66 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, PurchaseOrderItem, ScheduleLine. It has 1 association to related views. Part of development package APPL_MM_PUR_DLVPRED_ML.

Data Sources (4)

Source	Alias	Join Type
I_PurgAnalyticsConfiguration	AnalyticalConfiguration	from
I_PurgAnalyticsConfiguration	AnalyticalConfiguration	union_all
P_POItemSchdLnLastPostgDate	ScheduleLine	inner
P_POItmSchdLnLastPostgDteEnhcd	ScheduleLine	inner

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_CalendarDate	_Calendar	`$projection.PurchaseOrderDate = _Calendar.CalendarDate`

Annotations (6)

Name	Value	Level
AbapCatalog.sqlViewName	PPOICLSL	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.private	true	view
VDM.viewType	#CONSUMPTION	view

Fields (66)

Key	Field	Source Table	Source Field	Description
KEY	PurchaseOrder	P_POItmSchdLnLastPostgDteEnhcd	PurchaseOrder	Purchasing Document
KEY	PurchaseOrderItem	P_POItmSchdLnLastPostgDteEnhcd	PurchaseOrderItem	Purchasing Document Item
KEY	ScheduleLine	P_POItmSchdLnLastPostgDteEnhcd	ScheduleLine	Schedule Line
	PurgDocMigrtnIsCmpltdForAnlyts
	AccountAssignmentCategory	P_POItmSchdLnLastPostgDteEnhcd	AccountAssignmentCategory	Acct Assgmt Cat
	ScheduleLineOrderQuantity	P_POItmSchdLnLastPostgDteEnhcd	ScheduleLineOrderQuantity	Scheduled Qty
	PurchaseOrderQuantityUnit			Order Unit
	SchedLineStscDeliveryDate	P_POItmSchdLnLastPostgDteEnhcd	SchedLineStscDeliveryDate	Stat. Del. Date
	LastPostingDate	P_POItmSchdLnLastPostgDteEnhcd	LastPostingDate	Posting Date for GR
	LastPostingDateendasActualNoOfDays
	LastPostingDateendasDelayInNoOfDays
	PurchaseOrderDate	P_POItmSchdLnLastPostgDteEnhcd	PurchaseOrderDate	PO Date
	Supplier			Supplier
	SupplyingPlant			Supplying Plant
	POIncotermsClassification
	POIncotermsTransferLocation
	POIncotermsLocation1
	POIncotermsLocation2
	OrderQuantity
	Plant			Valuation Area
	MaterialGroup			Product Group
	Material			Vehicle Model
	ItemIncotermsClassification
	ItemIncotermsTransferLocation
	ItemIncotermsLocation1
	ItemIncotermsLocation2
	YearWeek	_Calendar	YearWeek	Year and Calendar Week
	YearMonth	_Calendar	YearMonth	Year Month
	CalendarWeek	_Calendar	CalendarWeek	Calendar Week
	CalendarMonth	_Calendar	CalendarMonth	Calendar Month
	CalendarYear	_Calendar	CalendarYear	Year
	PreviousWeekDate
	PurchaseOrder			Purchasing Document
KEY	PurchaseOrderItem	P_POItmSchdLnLastPostgDteEnhcd	PurchaseOrderItem	Purchasing Document Item
KEY	ScheduleLine	P_POItmSchdLnLastPostgDteEnhcd	ScheduleLine	Schedule Line
	PurgDocMigrtnIsCmpltdForAnlyts
	AccountAssignmentCategory	P_POItmSchdLnLastPostgDteEnhcd	AccountAssignmentCategory	Acct Assgmt Cat
	ScheduleLineOrderQuantity	P_POItmSchdLnLastPostgDteEnhcd	ScheduleLineOrderQuantity	Scheduled Qty
	PurchaseOrderQuantityUnit	P_POItmSchdLnLastPostgDteEnhcd	PurchaseOrderQuantityUnit	Order Unit
	SchedLineStscDeliveryDate	P_POItmSchdLnLastPostgDteEnhcd	SchedLineStscDeliveryDate	Stat. Del. Date
	LastPostingDate	P_POItmSchdLnLastPostgDteEnhcd	LastPostingDate	Posting Date for GR
	ExpectedNoOfDays	P_POItmSchdLnLastPostgDteEnhcd	diff_create
	ActualNoOfDays	P_POItmSchdLnLastPostgDteEnhcd	diff_create_giposting
	DelayInNoOfDays	P_POItmSchdLnLastPostgDteEnhcd	diff_giposting
	PurchaseOrderDate	P_POItmSchdLnLastPostgDteEnhcd	PurchaseOrderDate	PO Date
	Supplier	P_POItmSchdLnLastPostgDteEnhcd	Supplier	Supplier
	SupplyingPlant	P_POItmSchdLnLastPostgDteEnhcd	SupplyingPlant	Supplying Plant
	POIncotermsClassification	P_POItmSchdLnLastPostgDteEnhcd	POIncotermsClassification
	POIncotermsTransferLocation	P_POItmSchdLnLastPostgDteEnhcd	POIncotermsTransferLocation
	POIncotermsLocation1	P_POItmSchdLnLastPostgDteEnhcd	POIncotermsLocation1
	POIncotermsLocation2	P_POItmSchdLnLastPostgDteEnhcd	POIncotermsLocation2
	OrderQuantity	P_POItmSchdLnLastPostgDteEnhcd	PurchaseOrderItemQty
	Plant	P_POItmSchdLnLastPostgDteEnhcd	Plant	Valuation Area
	MaterialGroup	P_POItmSchdLnLastPostgDteEnhcd	MaterialGroup	Product Group
	Material	P_POItmSchdLnLastPostgDteEnhcd	Material	Vehicle Model
	ItemIncotermsClassification	P_POItmSchdLnLastPostgDteEnhcd	ItemIncotermsClassification
	ItemIncotermsTransferLocation	P_POItmSchdLnLastPostgDteEnhcd	ItemIncotermsTransferLocation
	ItemIncotermsLocation1	P_POItmSchdLnLastPostgDteEnhcd	ItemIncotermsLocation1
	ItemIncotermsLocation2	P_POItmSchdLnLastPostgDteEnhcd	ItemIncotermsLocation2
	YearWeek	_Calendar	YearWeek	Year and Calendar Week
	YearMonth	_Calendar	YearMonth	Year Month
	CalendarWeek	_Calendar	CalendarWeek	Calendar Week
	CalendarMonth	_Calendar	CalendarMonth	Calendar Month
	CalendarYear	_Calendar	CalendarYear	Year
	PreviousWeekDate	P_POItmSchdLnLastPostgDteEnhcd	PreviousWeekDate
	PreviousMonthDate	P_POItmSchdLnLastPostgDteEnhcd	PreviousMonthDate

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_POItemClosedScheduleLines.
-- 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: PPOICLSL

CREATE VIEW P_POItemClosedScheduleLines AS
SELECT
  ScheduleLine.PurchaseOrder AS PurchaseOrder,
  ScheduleLine.PurchaseOrderItem AS PurchaseOrderItem,
  ScheduleLine.ScheduleLine AS ScheduleLine,
  cast (' ' as migration_completed) AS PurgDocMigrtnIsCmpltdForAnlyts,
  ScheduleLine.AccountAssignmentCategory AS AccountAssignmentCategory,
  ScheduleLine.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  ScheduleLine._ScheduleLine.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  ScheduleLine.SchedLineStscDeliveryDate AS SchedLineStscDeliveryDate,
  ScheduleLine.LastPostingDate AS LastPostingDate,
  case when ScheduleLine.LastPostingDate is initial or ScheduleLine.LastPostingDate = ' ' or ScheduleLine.LastPostingDate is null then 0 else dats_days_between(ScheduleLine.PurchaseOrderDate,ScheduleLine.LastPostingDate) end as ActualNoOfDays AS LastPostingDateendasActualNoOfDays,
  case when ScheduleLine.LastPostingDate is initial or ScheduleLine.LastPostingDate = ' ' or ScheduleLine.SchedLineStscDeliveryDate is initial or ScheduleLine.SchedLineStscDeliveryDate = ' ' or ScheduleLine.SchedLineStscDeliveryDate is null or ScheduleLine.LastPostingDate is null then 0 else dats_days_between(ScheduleLine.SchedLineStscDeliveryDate,ScheduleLine.LastPostingDate) end as DelayInNoOfDays AS LastPostingDateendasDelayInNoOfDays,
  ScheduleLine.PurchaseOrderDate AS PurchaseOrderDate,
  ScheduleLine._ScheduleLine._PurchaseOrder.Supplier AS Supplier,
  ScheduleLine._ScheduleLine._PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  ScheduleLine._ScheduleLine._PurchaseOrder.IncotermsClassification AS POIncotermsClassification,
  ScheduleLine._ScheduleLine._PurchaseOrder.IncotermsTransferLocation AS POIncotermsTransferLocation,
  ScheduleLine._ScheduleLine._PurchaseOrder.IncotermsLocation1 AS POIncotermsLocation1,
  ScheduleLine._ScheduleLine._PurchaseOrder.IncotermsLocation2 AS POIncotermsLocation2,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.Plant AS Plant,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.Material AS Material,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.IncotermsClassification AS ItemIncotermsClassification,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.IncotermsTransferLocation AS ItemIncotermsTransferLocation,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.IncotermsLocation1 AS ItemIncotermsLocation1,
  ScheduleLine._ScheduleLine._PurchaseOrderItem.IncotermsLocation2 AS ItemIncotermsLocation2,
  _Calendar.YearWeek AS YearWeek,
  _Calendar.YearMonth AS YearMonth,
  _Calendar.CalendarWeek AS CalendarWeek,
  _Calendar.CalendarMonth AS CalendarMonth,
  _Calendar.CalendarYear AS CalendarYear,
  dats_add_days(ScheduleLine.PurchaseOrderDate,-7,'INITIAL') AS PreviousWeekDate,
  ScheduleLine.diff_create AS ExpectedNoOfDays,
  ScheduleLine.diff_create_giposting AS ActualNoOfDays,
  ScheduleLine.diff_giposting AS DelayInNoOfDays,
  ScheduleLine.PreviousMonthDate AS PreviousMonthDate
FROM I_PurgAnalyticsConfiguration AS AnalyticalConfiguration
INNER JOIN P_POItemSchdLnLastPostgDate AS ScheduleLine ON /* join condition not captured in parsed metadata */
INNER JOIN P_POItmSchdLnLastPostgDteEnhcd AS ScheduleLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON PurchaseOrderDate = _Calendar.CalendarDate  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PurgAnalyticsConfiguration
;

Depth:

P_POItemClosedScheduleLines view

P_POItemClsdSchedLinesCalc view