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: 

writeing SQl statement

Former Member
0 Kudos

hello,

how to write teh SQl statement for table of type CLUSTER TYPE(konv) or is ther any function module to get the list of all condiiton numbers(konv-knumv) for billling document

cheers

4 REPLIES 4

Former Member
0 Kudos

this is written by Rich in other forum , dont know how to provide the link , so pasting the code

You can access them using SELECT statements, I believe that you CAN NOT use joins though.

For example, BSEG is a cluster table.

report zrich_0003 .

data: ibseg type table of bseg with header line.

parameters: p_bukrs type bseg-bukrs.

select * into table ibseg from bseg up to 100 rows where bukrs = p_bukrs.loop at ibseg.

write:/ ibseg-bukrs, ibseg-belnr.endloop.

Message was edited by: chandrasekhar jagarlamudi

Former Member
0 Kudos

Hi Kumar,

Just check the function module - 'RV_KONV_SELECT'

0 Kudos

hello,

thanks for your reply, but my requirement is if you have a billing document , how to get a corresponding condition numbers in (konv-knumv).

cheers

0 Kudos

Hi Kumar,

You can use the SELECT ...FOR ALL ENTRIES statement to get the condition nos. for the billing documents.

Ex.

SELECT KNUMV

FROM KONV

INTO TABLE TKONV

FOR ALL ENTRIES IN TVBRP

WHERE KSCHL = TVBRP-KSCHL.

Please reward suitable points.

With Regards,

Nelson