V_Wrft_Tl_Sched_Cds
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)
| Source | Alias | Join Type |
|---|---|---|
| ekko | ekko | from |
| wrf_prct_wl_item | wl_item | left_outer |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA