I_SupDmndPurOrderSchedLine

DDL: I_SUPDMNDPURORDERSCHEDLINE Type: view BASIC Package: VDM_ARUN_ANALYTICS
7 Fields 1 Data Sources

Basic View for PO Schedule Line

I_SupDmndPurOrderSchedLine is a Basic CDS View that provides data about "Basic View for PO Schedule Line" in SAP S/4HANA. It reads from 1 data source (eket) and exposes 7 fields with key fields PurchasingDocument, PurchasingDocumentItem, ScheduleLine. Part of development package VDM_ARUN_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
eket sched from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Basic View for PO Schedule Line view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISUPDMNDPOSL view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument eket ebeln Source PurchDoc
KEY PurchasingDocumentItem eket ebelp Item pur. doc.
KEY ScheduleLine eket etenr Schedule Line
ScheduleLineOrderQuantity eket menge WarrCountValue
ScheduleLineDeliveryDate eket eindt Initial Entry
RoughGoodsReceiptQty eket wemng Received
dabmgendasOpenSupplyQuantity

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_SupDmndPurOrderSchedLine.
-- 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_SupDmndPurOrderSchedLine AS
SELECT
  sched.ebeln AS PurchasingDocument,
  sched.ebelp AS PurchasingDocumentItem,
  sched.etenr AS ScheduleLine,
  sched.menge AS ScheduleLineOrderQuantity,
  sched.eindt AS ScheduleLineDeliveryDate,
  sched.wemng AS RoughGoodsReceiptQty,
  case when sched.wemng > sched.dabmg then ( sched.menge - sched.wemng ) else ( sched.menge - sched.dabmg ) end as OpenSupplyQuantity AS dabmgendasOpenSupplyQuantity
FROM eket AS sched
;

Learn More