Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to get Outline Agreement of a Purchase Order?

walkerist
Participant
0 Kudos

Hi, I'm trying to get the outline agreement of a purchase order. I have checked the EKKO,EKPO via se16 but the outline agreement is not being displayed.

My outline agreement is stored in RM06E but I'm not sure if I can use RM06E in Select SQL statement. The common fields between EKPO and RM06E is the vendor.ab

3 REPLIES 3

xiswanto
Active Participant
0 Kudos

The 'Outline Agreement' field in PO item should be the EKPO-KONNR, isn't it? the RM06E you mentioned should be a structure instead of a table.

0 Kudos

It's possible that the outline agreement is stored in a different table than EKKO and EKPO. From what you've mentioned, it looks like the outline agreement may be stored in table RM06E.

To retrieve the data from table RM06E using a SQL select statement, you can try the following steps:

  1. Go to transaction code SE11 and enter the table name RM06E in the "Table/Structure" field.
  2. Click on the "Display" button to view the table structure.
  3. Take note of the fields you want to retrieve data for.
  4. Go to transaction code SE16 and enter table name RM06E in the "Table" field.
  5. Enter the relevant selection criteria, such as vendor.ab, to narrow down the data you want to retrieve.
  6. Click on the "Execute" button to view the data.
  7. Once you have verified that the data is correct, you can create a SQL select statement to retrieve the data programmatically.

Here is an example SQL select statement that you can use as a starting point:

SELECT field1, field2, field3

FROM RM06E

WHERE vendor.ab = 'your_vendor_id'

Replace field1, field2, and field3 with the actual field names you want to retrieve data for. Also, replace 'your_vendor_id' with the relevant vendor ID.

raymond_giuseppi
Active Contributor
0 Kudos

RM06E is a structure, not a database table.

  • Perform a where-used search on this structure from SE11.
  • Look at tables EKET/EKES, but some code may be required
    (e.g. RM06E-OBMNG = EKET-MENGE - EKET-WEMNG)
  • Trace/Debug a standard transaction
    (e.g. ME38, item overview screen, select an item click the Delivery Schedule (F2) icon.)