topic Re: writeing SQl statement in Application Development and Automation Discussions

writeing SQl statement

Former Member — Thu, 19 Jan 2006 07:54:01 GMT

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

Re: writeing SQl statement

Former Member — Thu, 19 Jan 2006 08:01:21 GMT

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

Re: writeing SQl statement

Former Member — Thu, 19 Jan 2006 08:27:10 GMT

Hi Kumar,

Just check the function module - 'RV_KONV_SELECT'

Re: writeing SQl statement

Former Member — Thu, 19 Jan 2006 08:50:36 GMT

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

Re: writeing SQl statement

Former Member — Thu, 19 Jan 2006 08:57:09 GMT

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