writeing SQl statement

[Former Member]

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

[Former Member]

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]

Hi Kumar,

Just check the function module - 'RV_KONV_SELECT'

[Former Member]

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

[Former Member]

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