Zum Inhalt springen
Die Codezentrale
Programmierung, Tipps, Tricks, Snippets, Links (.Net, Java, JavaScript, C++, PHP, Python, SQL, SAP, ABAP, SAPUI5)
Zum Inhalt springen
  • Home
  • Links
    • Kachelmannwetter
    • MrLeehs Blog
    • Deskmodder
    • winfuture.de
    • Tricktresor
    • Python Online Compiler
    • [Raspberry Pi] Wichtige Terminal-Kommandos für Raspian
    • CodeSandbox JS Vanilla
  • Datenschutzerklärung
  • Impressum
Startseite SAP ABAP CDS-Views [CDS-Views] Einfachen CDS-View erstellen und Daten anzeigen

[CDS-Views] Einfachen CDS-View erstellen und Daten anzeigen

admin 5. Oktober 2017 27. Januar 2019CDS-Views

Anlegen des CDS-Views in Eclipse (ab ABAP 7.4 SP8)

* Menü -> File -> New -> Other -> Core Data Services -> Data Definition

* CDS-View als DDIC Objekt erstellen
@AbapCatalog.sqlViewName: 'ZCDS_MATNR_VIEW'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MATNR lesen'
@Metadata.allowExtensions: true

define view ZCDS_MATNR as select from mara as ma
  inner join makt as kt on ma.matnr = kt.matnr
{
  key ma.matnr as matnr,
  
  ma.ernam as ersteller,
  
  ma.vpsta as pflegestatus,
  
  case ma.lvorm
    when 'X' then 'gelöscht'
    else 'aktiv'
  end as loeschvormerkung,
  
  kt.maktx as kurztext
};

ABAP-Quellcode zum Auslesen des CDS-Views

* Variante 1 (SELECT)
DATA: it_matnr TYPE STANDARD TABLE OF zcds_matnr.

SELECT * FROM zcds_matnr INTO TABLE @it_matnr.

LOOP AT it_matnr ASSIGNING FIELD-SYMBOL(<mat>).
  WRITE: / <mat>-matnr, <mat>-ersteller, <mat>-pflegestatus, <mat>-loeschvormerkung, <mat>-kurztext.
ENDLOOP.

* Variante 2 (SALV TABLE IDA)
TRY.
    cl_salv_gui_table_ida=>create_for_cds_view( CONV #( 'ZCDS_MATNR' ) )->fullscreen( )->display( ).
  CATCH cx_root INTO DATA(e_txt).
    WRITE: / e_txt->get_text( ).
ENDTRY.

Links

  • https://help.sap.com/viewer/f2e545608079437ab165c105649b89db/7.51.3/en-US/4ed1f2e06e391014adc9fffe4e204223.html
  • https://blogs.sap.com/2017/09/09/abap-core-data-services-introduction-abap-cds-view/
  • https://itpsap.com/dont-try-coding-abap-core-data-services-without-reading-this-first-2/
  • http://www.saplearners.com/how-to-create-abap-cds-views-with-paramertes/
  • http://www.sapyard.com/abap-on-sap-hana-part-v/
  • http://www.sapyard.com/abap-on-sap-hana-part-xv-expose-cds-views-as-odata-service-through-annotation/
  • http://www.cadaxo.com/high-class-development/abap-cds-views-6-schritte-zum-verstaendnis/
  • https://blogs.sap.com/2016/03/10/my-cds-view-self-study-tutorial-part-1-how-to-test-odata-service-generated-by-cds-view/
  • https://blogs.sap.com/2015/07/20/cds-one-model-two-flavors/
  • https://blogs.sap.com/2018/07/03/performance-optimization-for-abap-cds-view/
  • https://blogs.sap.com/2017/09/22/data-filtration-options-and-performance-analysis-in-abap-cds-views/
  $metadata, AccessControl, as select from, CDS-View, cl_salv_gui_table_ida, create_for_cds_view, define view, display, EndUserText, fullscreen, INNER JOIN. Lesezeichen.
[CDS-Views] CDS-View mit Parametern erstellen und anzeigen
[ABAP] Fluchtsymbol – spezielle Kennzeichnung, dass Bezeichner kein ABAP-Schlüsselwort ist
  • Kategorien

    aufklappen | zuklappen
  • Neueste Beiträge

    • [SAP] IDOC-Verarbeitung
    • [SAP] Analyse der Performance von ABAP CDS Views
    • [SAP] ABAP CDS Views und Verwendung von Annotations
    • [SAP] Adobe Forms Administration
    • [Raspberry Pi] ZigBee USB-Sticks im Vergleich
    • [Raspberry Pi] ZigBee: zigbee2mqtt einrichten, mosquitto broker installieren
    • [ABAP] Leistungstammsatz anlegen
    • [ABAP] Leistungstammsatz lesen
    • [Raspberry Pi] Betriebsystemfunktionen ausführen
    • [SAP] Übersichten zum ABAP Programming Model
  • Archiv

  • Meta

    • Anmelden
    • Feed der Einträge
    • Kommentare-Feed
    • WordPress.org
  • Related Posts

    • [CDS-Views] CDS-View mit Parametern erstellen und anzeigen
  • Tags

    ABAP (871) Android (18) CLASS (20) cl_abap_list_layout (18) cl_abap_matcher (13) cl_bcs_convert (16) cl_gui_alv_grid (23) cl_gui_container (34) cl_gui_docking_container (23) cl_gui_frontend_services (35) cl_salv_table (52) cntl_simple_event (15) create (28) DataGridView (13) Date (15) default_screen (27) display (14) EWM (16) get_column (13) get_columns (22) gui_download (14) HTML (15) JavaScript (78) JSON (20) MIME (17) NEW (20) OData (28) ole2_object (13) OpenSQL (21) Python (23) Raspberry Pi (50) Raspberry Pi 2 (27) Raspberry Pi 4 (23) Raspian (22) RegEx (17) SAP (347) SAPUI5 (27) SELECT (25) String (33) stringtab (15) suppress_toolbar (19) UTF-8 (14) Value (26) XML (25) xstring (20)
(W) 2022 by codezentrale.de
Powered by Tempera & WordPress.