Reading logical database using ABAP program

Requirement:
Read a logical database (you must have data in those tables, now LFA1), fill up an internal table. Sort the data by a given field and then display the internal table.

ABAP program Source Code:

report zldbread no standard page heading.
tables: lfa1.
data: begin of t occurs 0,
linfr like lfa1-lifnr,
name1 like lfa1-name1,
end of t.

start-of-selection.

get lfa1.
clear t.
move-corresponding lfa1 to t.
append t.
end-of-selection.
sort t by name1.
loop at t.

write: / t-name1, t-lifnr.
endloop.

Related SAP Tutorials & References
  1. ABAP program for Reading database tables using selectRequirement: Write the a report with a select statement. ABAP Source Code: report zselect1 no...
  2. ABAP program for Mass Purchase Order History DisplayThis is a customized ABAP report for mass Purchase Order history display instead of checking...
  3. ABAP program to load a database table from a UNIX fileRequirement: Write a program to load a database table from a UNIX file. ABAP Source...
  4. ABAP Program for Submitting report with selection tableSample ABAP Program for learning how to Submit report with selection tableREPORT submit_with_selection_table.TABLES QMSM.* Work...
  5. ABAP Program for MB1B Call TransactionA sample ABAP program to understand how to use MB1B call transaction in ABAP.REPORT YMBIE096...
  6. ABAP program to send a report to an external mail-idThis source code is an ABAP Program o send a report to an external mail-idREPORT...
  7. ABAP Program to Get Output in EXCELThis source code is an ABAP Program to Get Output in EXCEL REPORT YLMM015AMESSAGE-ID YL.*-----------------------------------------------------------------------**...
  8. ABAP program for Creating Extract DatasetRequirement: Write a program that lists the Vendors and their Accounting documents. Create extract dataset...
  9. Source Code of ABAP Program to Browse a file on the application serverSource Code of ABAP Program to Browse a file on the application serverREPORT ZBROWSE MESSAGE-ID...
  10. Interview Questions about SAP Logical database Preparation of the data records by the L.D.B and reading of the data records...
Google: Facebook:

This entry was posted on Wednesday, November 16th, 2011 at 1:13 pm and is filed under codes. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Submit your tip or response