Atpc_Cds_Eket
CDS View on EKET Table for ATP
Atpc_Cds_Eket is a CDS View that provides data about "CDS View on EKET Table for ATP" in SAP S/4HANA. It reads from 1 data source (Atpc_Cds_Eket_1) and exposes 31 fields.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| Atpc_Cds_Eket_1 | eket | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ATPC_EKET | 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 on EKET Table for ATP | view |
Fields (31)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| atpcat | Atpc_Cds_Eket_1 | atpcat | MRP Elmnt Ind. | |
| mandt | Atpc_Cds_Eket_1 | mandt | Editing Client | |
| matnr | Atpc_Cds_Eket_1 | matnr | Vehicle Model | |
| werks | Atpc_Cds_Eket_1 | werks | Receiving Plant | |
| lgort | Atpc_Cds_Eket_1 | lgort | Sublocation | |
| charg | Atpc_Cds_Eket_1 | charg | Chargeable Proc. | |
| sgt_rcat | Atpc_Cds_Eket_1 | sgt_rcat | Req. Segment | |
| sgt_scat | Atpc_Cds_Eket_1 | sgt_scat | Stock Segment | |
| sobkz | Atpc_Cds_Eket_1 | sobkz | Special Stock | |
| sskey | Atpc_Cds_Eket_1 | sskey | Special Stock | |
| sskey_ext | Atpc_Cds_Eket_1 | sskey_ext | Ext. SSKEY | |
| lblkz | Atpc_Cds_Eket_1 | lblkz | SC Supplier | |
| emlif | Atpc_Cds_Eket_1 | emlif | Supplier | |
| vbeln | Atpc_Cds_Eket_1 | vbeln | SD Sched. Agmt | |
| vbelp | Atpc_Cds_Eket_1 | vbelp | Schd. Agmt Item | |
| ps_psp_pnr | Atpc_Cds_Eket_1 | ps_psp_pnr | WBS Element | |
| eindt | Atpc_Cds_Eket_1 | eindt | Initial Entry | |
| eldat | Atpc_Cds_Eket_1 | eldat | Planned dates | |
| atptime | Atpc_Cds_Eket_1 | atptime | ||
| retpo | Atpc_Cds_Eket_1 | retpo | Returns Item | |
| bstyp | Atpc_Cds_Eket_1 | bstyp | Source doc.cat. | |
| insmk | Atpc_Cds_Eket_1 | insmk | Stock Type | |
| MEINS | Atpc_Cds_Eket_1 | meins | Valuation Unit | |
| UMREZ | Atpc_Cds_Eket_1 | umrez | Numerator | |
| UMREN | Atpc_Cds_Eket_1 | umren | Denominator | |
| WEBAZ | Atpc_Cds_Eket_1 | webaz | GR Proc. Time | |
| bwtar | Atpc_Cds_Eket_1 | bwtar | Valuation Type | |
| knttp | Atpc_Cds_Eket_1 | knttp | AcctAssgnCat:CC | |
| reswk | Atpc_Cds_Eket_1 | reswk | Supplying Plant | |
| reslo | Atpc_Cds_Eket_1 | reslo | Iss. Stor. Loc. | |
| fixmg | Atpc_Cds_Eket_1 | fixmg | Planned qty |
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_Eket.
-- 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_EKET
CREATE VIEW Atpc_Cds_Eket AS
SELECT
eket.atpcat AS atpcat,
eket.mandt AS mandt,
eket.matnr AS matnr,
eket.werks AS werks,
eket.lgort AS lgort,
eket.charg AS charg,
eket.sgt_rcat AS sgt_rcat,
eket.sgt_scat AS sgt_scat,
eket.sobkz AS sobkz,
eket.sskey AS sskey,
eket.sskey_ext AS sskey_ext,
eket.lblkz AS lblkz,
eket.emlif AS emlif,
eket.vbeln AS vbeln,
eket.vbelp AS vbelp,
eket.ps_psp_pnr AS ps_psp_pnr,
eket.eindt AS eindt,
eket.eldat AS eldat,
eket.atptime AS atptime,
eket.retpo AS retpo,
eket.bstyp AS bstyp,
eket.insmk AS insmk,
eket.meins AS MEINS,
eket.umrez AS UMREZ,
eket.umren AS UMREN,
eket.webaz AS WEBAZ,
eket.bwtar AS bwtar,
eket.knttp AS knttp,
eket.reswk AS reswk,
eket.reslo AS reslo,
eket.fixmg AS fixmg
FROM Atpc_Cds_Eket_1 AS eket
;
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