The ABAP demo view entity DEMOSALESCDSSOIVE exposes element MAT (material number) and is the object SAP’s documentation uses in the example on line 17:

“SELECT mat FROM demosalescdssoive …”.

Because the question explicitly asks for “ABAP SQL” and the code sample is working with a CDS view entity, the only statement that can retrieve field MAT exactly as shown is option B.

Option C refers to the legacy transparent table/SQL view; options A and D reference objects that do not exist or are syntactically invalid in the SAP demo model.

A. “Material” is neither a table nor a CDS entity in the SAP demo model; statement would raise a syntax error.

C. DEMOSALESSOI is a table; the sample in line 17 targets the CDS view entity, not the table.

D. Name contains blanks and is not a valid ABAP dictionary or CDS identifier; would not compile.

1. SAP Help Portal

ABAP Keyword Documentation 7.57 – Example “SELECT – From a CDS View Entity”

code lines 14-18 show: SELECT mat FROM demosalescdssoive ... (Section path: ABAP – ABAP Keyword Documentation – ABAP SQL – SELECT

Example ID: abapselectfromcdsviewentity).

2. SAP Help Portal

ABAP Platform 2022 – Demo Data Model “Sales” → CDS View Entity DEMOSALESCDSSOIVE

Element list entry “mat type matnr” (Table “Elements of the view entity”).

3. SAP Help Portal

ABAP Platform 2022 – Transparent Table DEMOSALESSOI description (note presence of MAT field and distinction between table and CDS view entity).