V_Wrft_Tl_Sched_Cds

DDL: V_WRFT_TL_SCHED_CDS SQL: V_WRFT_TL_SCHED Type: view

Container Timeline-Scheduling-Report for Reactive PO-WB

V_Wrft_Tl_Sched_Cds is a CDS View that provides data about "Container Timeline-Scheduling-Report for Reactive PO-WB" in SAP S/4HANA. It reads from 2 data sources (ekko, wrf_prct_wl_item) and exposes 37 fields.

Data Sources (2)

SourceAliasJoin Type
ekko ekko from
wrf_prct_wl_item wl_item left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_WRFT_TL_SCHED view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Container Timeline-Scheduling-Report for Reactive PO-WB view

Fields (37)

KeyFieldSource TableSource FieldDescription
mandt ekko mandt Editing Client
dl_id dlit dl_id DateLine ID
date_id dlit date_id Key for Date
actual_date dlit actual_date ActWDOrderDate
monitor_date dlit monitor_date
ebeln ekko ebeln Source PurchDoc
ebelp ekpo ebelp Item pur. doc.
etenr eket etenr Schedule Line
matnr ekpo matnr Vehicle Model
ematn ekpo ematn MPN: Material
werks ekpo werks Receiving Plant
matkl ekpo matkl Product Sold Group
netwr ekpo netwr Value
bstyp ekko bstyp Source doc.cat.
bsart ekko bsart Stnd purch.ord.
lifnr ekko lifnr Vendor no.
ekorg ekko ekorg Purchasing Org.
aedat ekko aedat Obsolete
waers ekko waers Transaction Currency
ekgrp ekko ekgrp Sub. purchasing grp
bedat ekko bedat Start date
fixpo ekko fixpo Firm Deal ID
folder_id wrf_prct_wl_item folder_id Process Folder ID
ernam wrf_prct_wl_item ernam User Name
eindt wrf_prct_wl_item eindt Initial Entry
dl_status wrf_prct_wl_item dl_status Status POM React.
activity_id wrf_prct_wl_item activity_id IMG Activity
dunning_alwd wrf_prct_wl_item dunning_alwd Reminder Allwd
qty_monitor wrf_prct_wl_item qty_monitor Monitor QtyVar.
qty_overdel wrf_prct_wl_item qty_overdel Monitor Overdlv
qty_underdel wrf_prct_wl_item qty_underdel Monitor Underdl
rem_qty_auto wrf_prct_wl_item rem_qty_auto Rem.Qty Auto.
distance wrf_prct_wl_item distance Travel Distance
delayed wrf_prct_wl_item delayed Late Execution
timestamp wrf_prct_wl_item timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
uname wrf_prct_wl_item uname User Name
programm wrf_prct_wl_item programm Variant

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 V_Wrft_Tl_Sched_Cds.
-- 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: V_WRFT_TL_SCHED

CREATE VIEW V_Wrft_Tl_Sched_Cds AS
SELECT
  ekko.mandt AS mandt,
  dlit.dl_id AS dl_id,
  dlit.date_id AS date_id,
  dlit.actual_date AS actual_date,
  dlit.monitor_date AS monitor_date,
  ekko.ebeln AS ebeln,
  ekpo.ebelp AS ebelp,
  eket.etenr AS etenr,
  ekpo.matnr AS matnr,
  ekpo.ematn AS ematn,
  ekpo.werks AS werks,
  ekpo.matkl AS matkl,
  ekpo.netwr AS netwr,
  ekko.bstyp AS bstyp,
  ekko.bsart AS bsart,
  ekko.lifnr AS lifnr,
  ekko.ekorg AS ekorg,
  ekko.aedat AS aedat,
  ekko.waers AS waers,
  ekko.ekgrp AS ekgrp,
  ekko.bedat AS bedat,
  ekko.fixpo AS fixpo,
  wl_item.folder_id AS folder_id,
  wl_item.ernam AS ernam,
  wl_item.eindt AS eindt,
  wl_item.dl_status AS dl_status,
  wl_item.activity_id AS activity_id,
  wl_item.dunning_alwd AS dunning_alwd,
  wl_item.qty_monitor AS qty_monitor,
  wl_item.qty_overdel AS qty_overdel,
  wl_item.qty_underdel AS qty_underdel,
  wl_item.rem_qty_auto AS rem_qty_auto,
  wl_item.distance AS distance,
  wl_item.delayed AS delayed,
  wl_item.timestamp AS timestamp,
  wl_item.uname AS uname,
  wl_item.programm AS programm
FROM ekko
LEFT OUTER JOIN wrf_prct_wl_item AS wl_item ON /* join condition not captured in parsed metadata */
;