P_POItmSchdLnLastPostgDteEnhcd

DDL: P_POITMSCHDLNLASTPOSTGDTEENHCD SQL: PPOISCLDATEENH Type: view CONSUMPTION Package: APPL_MM_PUR_DLVPRED_ML
35 Fields 1 Data Sources 2 Associations

PO Item Schd Line Last Posting Date

P_POItmSchdLnLastPostgDteEnhcd is a Consumption CDS View that provides data about "PO Item Schd Line Last Posting Date" in SAP S/4HANA. It reads from 1 data source (I_PurOrdScheduleLineEnhanced) and exposes 35 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine, ProcurementHubSourceSystem. It has 2 associations to related views. Part of development package APPL_MM_PUR_DLVPRED_ML.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdScheduleLineEnhanced ScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderScheduleLine _ScheduleLine _ScheduleLine.PurchaseOrder = ScheduleLine.PurchaseOrder and _ScheduleLine.PurchaseOrderItem = ScheduleLine.PurchaseOrderItem and _ScheduleLine.ScheduleLine = ScheduleLine.ScheduleLine
[0..1] I_CalendarDate _Calendar $projection.PurchaseOrderDate = _Calendar.CalendarDate

Annotations (7)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PPOISCLDATEENH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurOrdScheduleLineEnhanced PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurOrdScheduleLineEnhanced PurchaseOrderItem Purchasing Document Item
KEY ScheduleLine I_PurOrdScheduleLineEnhanced ScheduleLine Schedule Line
KEY ProcurementHubSourceSystem I_PurOrdScheduleLineEnhanced ProcurementHubSourceSystem Connected System ID
AccountAssignmentCategory I_PurOrdScheduleLineEnhanced AccountAssignmentCategory Acct Assgmt Cat
ScheduleLineOrderQuantity I_PurOrdScheduleLineEnhanced ScheduleLineOrderQuantity Scheduled Qty
SchedLineStscDeliveryDate I_PurOrdScheduleLineEnhanced SchedLineStscDeliveryDate Stat. Del. Date
LastPostingDate I_PurOrdScheduleLineEnhanced PostingDate Posting Date for GR
PurchaseOrderDate I_PurOrdScheduleLineEnhanced PurchaseOrderDate PO Date
OrderQuantityUnit I_PurOrdScheduleLineEnhanced OrderQuantityUnit Sales Unit
PostingDateendasdiff_create_giposting
PostingDateendasdiff_giposting
SystemDate
PurchaseOrderQuantityUnit _ScheduleLine PurchaseOrderQuantityUnit Order Unit
Supplier
SupplyingPlant
POIncotermsClassification
POIncotermsTransferLocation
POIncotermsLocation1
POIncotermsLocation2
PurchaseOrderItemQty
Plant
MaterialGroup
Material
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
GoodsReceiptMaterialDocYear _Calendar CalendarYear Year
PreviousWeekDate
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_POItmSchdLnLastPostgDteEnhcd.
-- 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: PPOISCLDATEENH

CREATE VIEW P_POItmSchdLnLastPostgDteEnhcd AS
SELECT
  ScheduleLine.PurchaseOrder AS PurchaseOrder,
  ScheduleLine.PurchaseOrderItem AS PurchaseOrderItem,
  ScheduleLine.ScheduleLine AS ScheduleLine,
  ScheduleLine.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  ScheduleLine.AccountAssignmentCategory AS AccountAssignmentCategory,
  ScheduleLine.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  ScheduleLine.SchedLineStscDeliveryDate AS SchedLineStscDeliveryDate,
  ScheduleLine.PostingDate AS LastPostingDate,
  ScheduleLine.PurchaseOrderDate AS PurchaseOrderDate,
  ScheduleLine.OrderQuantityUnit AS OrderQuantityUnit,
  case when ScheduleLine.PostingDate is initial or ScheduleLine.PostingDate = ' ' then 0 else dats_days_between(_ScheduleLine.ScheduleLineOrderDate,ScheduleLine.PostingDate) end as diff_create_giposting AS PostingDateendasdiff_create_giposting,
  case when ScheduleLine.PostingDate is initial or ScheduleLine.PostingDate = ' ' or ScheduleLine.SchedLineStscDeliveryDate is initial or ScheduleLine.SchedLineStscDeliveryDate = ' ' then 0 else dats_days_between(ScheduleLine.SchedLineStscDeliveryDate,ScheduleLine.PostingDate) end as diff_giposting AS PostingDateendasdiff_giposting,
  $session.system_date AS SystemDate,
  _ScheduleLine.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  _ScheduleLine._PurchaseOrder.Supplier AS Supplier,
  _ScheduleLine._PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  _ScheduleLine._PurchaseOrder.IncotermsClassification AS POIncotermsClassification,
  _ScheduleLine._PurchaseOrder.IncotermsTransferLocation AS POIncotermsTransferLocation,
  _ScheduleLine._PurchaseOrder.IncotermsLocation1 AS POIncotermsLocation1,
  _ScheduleLine._PurchaseOrder.IncotermsLocation2 AS POIncotermsLocation2,
  _ScheduleLine._PurchaseOrderItem.OrderQuantity AS PurchaseOrderItemQty,
  _ScheduleLine._PurchaseOrderItem.Plant AS Plant,
  _ScheduleLine._PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  _ScheduleLine._PurchaseOrderItem.Material AS Material,
  _ScheduleLine._PurchaseOrderItem.IncotermsClassification AS ItemIncotermsClassification,
  _ScheduleLine._PurchaseOrderItem.IncotermsTransferLocation AS ItemIncotermsTransferLocation,
  _ScheduleLine._PurchaseOrderItem.IncotermsLocation1 AS ItemIncotermsLocation1,
  _ScheduleLine._PurchaseOrderItem.IncotermsLocation2 AS ItemIncotermsLocation2,
  _Calendar.YearWeek AS YearWeek,
  _Calendar.YearMonth AS YearMonth,
  _Calendar.CalendarWeek AS CalendarWeek,
  _Calendar.CalendarMonth AS CalendarMonth,
  _Calendar.CalendarYear AS GoodsReceiptMaterialDocYear,
  dats_add_days(ScheduleLine.PurchaseOrderDate,-7,'INITIAL') AS PreviousWeekDate,
  dats_add_months(ScheduleLine.PurchaseOrderDate,-1,'INITIAL') AS PreviousMonthDate
FROM I_PurOrdScheduleLineEnhanced AS ScheduleLine
LEFT OUTER JOIN I_PurchaseOrderScheduleLine AS _ScheduleLine ON _ScheduleLine.PurchaseOrder = ScheduleLine.PurchaseOrder AND _ScheduleLine.PurchaseOrderItem = ScheduleLine.PurchaseOrderItem AND _ScheduleLine.ScheduleLine = ScheduleLine.ScheduleLine  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _Calendar ON PurchaseOrderDate = _Calendar.CalendarDate  -- association [0..1]
;

Learn More