12/4/22, 18:32 Select using work area inline declaration ABAP 7.4 - ABAP 7.
sing work area inline declaration ABAP 7.4 - ABAP 7.4 Select Statements OPEN SQL | [Link]
We have moved our domain from [Link] to [Link], please bookmark and share.
You are here →
/ [Link]
/ Courses
/ SAP ABAP 7.4
/ ABAP 7.4 Select Statements OPEN SQL
/
Select using work area inline declaration ABAP 7.4
Select using work area inline Search Sapnuts Search
declaration ABAP 7.4 Learn SAP Courses online, SAP Certification
mock exams and SAP tutorials
Last Updated: April 3rd 2018 by Ashok Kumar Reddy
SAP ABAP Tutorials, SAP ABAP Online Training,
SAP Webdynpro for ABAP, Webdynpro for ABAP
How to declare work area inline in OPEN SQL Select ABAP 7.4 ? Work Area tutorials, Webdynpro for ABAP online training,
inline declaration with ABAP 7.4 SAP Workflow training, SAP Online Training, SAP
Certification, SAP Training, SAP mock exams, SAP
A+
A-
Exams, SAP ERP, SAP Interview questions, SAP
In NetWeaver 7.4 version SAP has simplified OPEN SQL statements, now developers can use inline declarations
ABAP interview Questions
in OPEN SQL select statements.
Example Select statement to read Single record from database table using ABAP 7.4 Open SAP ABAP 7.4 Course Content
SQL.
Using work area in Select Statements before ABAP 7.4 Introduction to ABAP 7.4 and Inline
Declarations
DATA: WA_MARA TYPE MARA.
ABAP 7.4 Select Statements OPEN SQL
SELECT SINGLE *
FROM MARA
Internal Table Operations with ABAP 7.4
INTO WA_MARA WHERE MATNR = '0001'.
Conditional Statements ABAP 7.4
WRITE:/ wa_mara-matnr, wa_mara-mtart.
Working with Strings and Output
Reports Using Inline Declarations ABAP 7.4
REGISTER FOR PREMIUM SAP TRAINING
Training will be provided through online
platform ex: gotomeetings
SK 64 ports SMS gateway modem company manufacture
Name *
SK 64 ports SMS gateway modem Name
SKYLINE
Email *
Work Area inline declaration in Select Open SQL in ABAP 7.4
Email
Mobile *
10 digit mobile number
Your privacy will be protected always
Select Courses *
SAP ABAP
Web Dynpro ABAP
SK 64 ports SMS gateway modem company manufacture
SK 64 ports SMS gateway modem Object Oriented ABAP
SKYLINE
SAP Cross Apps (RFC,BAPI,IDOC)
We use @DATA() in select statement for inline declaration in ABAP 7.4
Comments
SELECT SINGLE * FROM MARA
Comments
INTO @DATA(wa_MARA) WHERE MATNR = '0001'.
WRITE:/ wa_mara-matnr, wa_mara-mtart.
Submit
Below is the select statement to read single record with specific fields from database table
using ABAP 7.4 .
Before ABAP 7.4
[Link] 1/2
12/4/22, 18:32 Select using work area inline declaration ABAP 7.4 - ABAP 7.4 Select Statements OPEN SQL | [Link]
TYPES: BEGIN OF TY_MARA,
MATNR TYPE MARA-MATNR,
MTART TYPE MARA-MTART,
END OF TY_MARA.
DATA: WA_MARA TYPE TY_MARA.
SELECT MATNR MTART
FROM MARA
INTO WA_MARA WHERE MATNR = '0001'.
WRITE:/ wa_mara-matnr, wa_mara-mtart.
Work Area with user defined fields in Select Open SQL in ABAP 7.4
Note: You need to use comma "," separator between fields in Select
SELECT SINGLE MATNR, MTART FROM MARA
INTO @DATA(wa_MARA) WHERE MATNR = '0001'.
WRITE:/ wa_mara-matnr, wa_mara-mtart.
LEARNER QUESTIONS
No Questions by learners, be first one to ask ..!!
Please Sign in to ask a question
Was this lesson helpful to you? Yes No 3 People out of 3 think this lesson helpful
Lesson Navigation
Introduction to ABAP 7.4 and Inline Declarations ← Previous Lesson Next Chapter → Select using internal table inline declaration ABAP 7.4
? Support About Feedback Privacy Terms & Conditions Report Abuse Google Twitter Facebook Version: V.2.1
© zapnuts, publisher of zapnuts. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate
company) in Germany and other countries.
All other product and service names mentioned are the trademarks of their respective companies. [Link] is not affiliated with SAP SE or any of the SAP
SE group of companies.
[Link] 2/2