SAP Query

SAP QUERIES

SAP QUERIES
ABAP/4 Workbench: Utilities/ ABAP/4 Query

a) Function Areas
i) Enter Name
ii) Press Create and enter Title
(1) Select Data
(a) Enter Logical Database
(i) OPTIONAL: Press “Description” button to see PICTURE of relational layout!!!!!!!!
(b) Or Enter a Table
(i) Check “Table Join” if multiple tables are required.
1. Push “Define Join” button.
2. Enter Table name to be joined.
3. Press Define condition button.
4. In the “Join Conditions” portion of the window, press the icon on the right to view field from both tables.
5. Answer “Yes” to Proposals Requested dialog.
6. Make changes if necessary.
(2) Press “Functional Groups” button
(a) Create a code and description for multiple functional groups.
(b) Assign these codes to the fields.
(c) Double click on Tables to change the field listing.
(3) Press Save and the Generate.
(4) Go back to Function Area main window
iii) Select “Assign to User Group” button
(1) Check appropriate User Group and Save
(2) Back out of Function Area window.
b) Queries
i) Press “Other User Group” button and select User Group
ii) Enter name
iii) Select “Create”
iv) Select Function Area
v) Enter Title, Columns = 240, Display as Table
vi) Right Arrow button twice
vii) Select fields to show in query
viii) Right arrow, select fields to appear as selection criteria
ix) Press “Basic List” button
(1) Enter Line, Sequence, and Sort
x) Press Save
c) Assign User ID to User Group
i) Menu: Environment / User Group
ii) Enter UserID and hit “Assign User Group”.
d) Execute the query.

 

Return to ABAP help

[Our portfolio] [A history of Computers and Networks]
[Perl help] [ABAP help] [MySQL help]
[TCP/IP troubleshooting] [HTML help] [Feedback] [Humor]
Advertise on Golden Ink's Georgia Network


In Association with Amazon.com


[Our portfolio] [A history of Computers and Networks]
[Perl help] [ABAP help] [MySQL help]
[TCP/IP troubleshooting] [HTML help] [Feedback] [Humor]
Advertise on Golden Ink's Georgia Network


In Association with Amazon.com