Atpc_Cds_Ekub_D
CDS View used as replacement of atp_ekub
Atpc_Cds_Ekub_D is a CDS View that provides data about "CDS View used as replacement of atp_ekub" in SAP S/4HANA. It reads from 1 data source (ekko) and exposes 35 fields.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| ekko | ekko | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ATPC_EKUB_D | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| ObjectModel.usageType.sizeCategory | #XXL | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| EndUserText.label | CDS View used as replacement of atp_ekub | view |
Fields (35)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| ebeln | ekko | ebeln | Source PurchDoc | |
| ebelp | ekpo | ebelp | Item pur. doc. | |
| etenr | eket | etenr | Schedule Line | |
| bstyp | ekpo | bstyp | Source doc.cat. | |
| matnr | ekpo | matnr | Vehicle Model | |
| reswk | ekko | reswk | Supplying Plant | |
| werks | ekpo | werks | Receiving Plant | |
| reslo | ekpo | reslo | Iss. Stor. Loc. | |
| charg | eket | charg | Chargeable Proc. | |
| sgt_rcat | ekpo | sgt_rcat | Req. Segment | |
| umsok | ekpo | umsok | Special Stock | |
| lblkz | ekpo | lblkz | SC Supplier | |
| emlif | ekpo | emlif | Supplier | |
| mbdat | eket | mbdat | Mat.Avail.Date | |
| dat01 | eket | dat01 | Finish date | |
| mng02 | eket | mng02 | Scrap | |
| eindt | eket | eindt | Initial Entry | |
| uzeit | eket | uzeit | Time | |
| plifz | ekpo | plifz | Plnd Deliv.Time | |
| menge | eket | menge | WarrCountValue | |
| fls_rsto | ekpo | fls_rsto | Enh. Store Ret. | |
| wamng | eket | wamng | Issued | |
| dabmg | eket | dabmg | Qty Reduced | |
| glmng | eket | glmng | Qty Delivered | |
| fixmg | ekpo | fixmg | Planned qty | |
| retpo | ekpo | retpo | Returns Item | |
| meins | ekpo | meins | Valuation Unit | |
| umrez | ekpo | umrez | Numerator | |
| umren | ekpo | umren | Denominator | |
| loekz | ekpo | loekz | Status | |
| elikz | ekpo | elikz | Delivery Completion | |
| stapo | ekpo | stapo | Statistical | |
| uptyp | ekpo | uptyp | Subitem Cat. | |
| eglkz | ekpo | eglkz | Final Delivery | |
| druhr | ekpo | druhr | Time of Transmission |
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 Atpc_Cds_Ekub_D.
-- 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: ATPC_EKUB_D
CREATE VIEW Atpc_Cds_Ekub_D AS
SELECT
ekko.ebeln AS ebeln,
ekpo.ebelp AS ebelp,
eket.etenr AS etenr,
ekpo.bstyp AS bstyp,
ekpo.matnr AS matnr,
ekko.reswk AS reswk,
ekpo.werks AS werks,
ekpo.reslo AS reslo,
eket.charg AS charg,
ekpo.sgt_rcat AS sgt_rcat,
ekpo.umsok AS umsok,
ekpo.lblkz AS lblkz,
ekpo.emlif AS emlif,
eket.mbdat AS mbdat,
eket.dat01 AS dat01,
eket.mng02 AS mng02,
eket.eindt AS eindt,
eket.uzeit AS uzeit,
ekpo.plifz AS plifz,
eket.menge AS menge,
ekpo.fls_rsto AS fls_rsto,
eket.wamng AS wamng,
eket.dabmg AS dabmg,
eket.glmng AS glmng,
ekpo.fixmg AS fixmg,
ekpo.retpo AS retpo,
ekpo.meins AS meins,
ekpo.umrez AS umrez,
ekpo.umren AS umren,
ekpo.loekz AS loekz,
ekpo.elikz AS elikz,
ekpo.stapo AS stapo,
ekpo.uptyp AS uptyp,
ekpo.eglkz AS eglkz,
ekpo.druhr AS druhr
FROM ekko
;
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