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: 

abap query for KONV, EKKO and EKPO

Former Member
0 Kudos

Hi All,

I have developed an abap query for tables konv, ekko and ekpo. First I joined ekko and ekpo. For konv table, in Extras I have written as below.

http://www.erpgreat.com/abap/query-to-extract-po-specific-condition-type.htm

If I am giving only single value in STUNR and ZAEHK, I am getting the output.

I want to select STUNR between 200 to 400. How to acheive this?

Awaiting your replies.

Thanks,

Venkata

7 REPLIES 7

raymond_giuseppi
Active Contributor
0 Kudos

Additional table can only return one record, so you may have to change the order of tables in query definition. 

Else you can define this table as an "additional structure" (ZKONV, ddic KONV) , so you can code any syntax of SELECT.

Regards,

Raymond

david_carballido
Active Participant
0 Kudos

You can use the Logical Data Base ERM to get data of EKKO, EKPO and KONV

I hope this help you

Regards

DCC

0 Kudos

Hi,

If we select Logical database it will give the standard selection screen fields which doesn't suit our requirement. Unable to change the fields on selection screen.

Thanks,

Venkata

0 Kudos

Hi Venkata, I get your requirement, I hope my solution can solve your problem

1. Create the query with EKKO and EKPO tables (More tables can be incorporated)

2. Create your structure KONV as variable and not as table

3. Fill the structure with your condition and save the Code

4. Return to field groups to fill your fields

For my example I filled this fields, then generated the infoset

5. The result will be this

6. Then you have to create your Query in SQ01 and put the fields of KONV and see the results

7. Save and execute Query

8. In EKKO, EKPO and KONV I have

9. The result of Query

I hope this help you

Regards

David Carballido

0 Kudos

Hi David, 

I didn't find the radio button "Additional structure" as I am using 4.0B version.

Is there any other way to overcome this. Please help me.

Thanks,

Venkata

0 Kudos

Hi Venkata, please try with "Code", I dont remember exactly how to create your scenario in 4.0B, I hope you have solved your problem

Regard

DCC

former_member184569
Active Contributor
0 Kudos

Check this document and see if it helps.

http://scn.sap.com/docs/DOC-27049