DDIC - Need relation

[pintoo_d]

Hi,

I need to retrieve KBETR from KONV which is cluster table. I need respective values for every invoice number from VBRK Table. I got a field which is common to both tables KNUMV. However when i check KONV, KBETR values is different for different KNUMV values. I want to retrieve specific Rate Condition for Invoice Number and KNUMV data.

KONV has other key fields like KPOSN, STUNR and ZAEHK.

I am not able to get any other relation where i can find those details.

can someone help me wth relation to retrieve particular value.

Thanks

[Former Member]

hi

Please mention you want price in item level or header level

vbrp-posnr is eq to konv-kposn

Plz chk

Edited by: Rasheed salman on Nov 26, 2008 6:38 AM

[pintoo_d]

I want price in item level.

[Former Member]

HI

POSNR of VBRP and KPOSN of KONV are same.

u just check posnr in vbrp table and copy that value of posnr.

Now u check the table entris in konv.In the kposn value just paste the value which u copied then u can find a record.

So VBRP-POSNR and KONV-KPOSN are similar.

u can write the select statement as follows.

SELECT knumv

kposn

kbetr

kwert

kschl FROM konv

INTO TABLE it_konv

WHERE kposn = wa_vbrp-posnr.

If u want to make relation between KONV and VBRK then u can write as follows:

SELECT knumv

kposn

kbetr

kwert

kschl FROM konv

INTO TABLE it_konv

WHERE knumv = wa_vbrk-knumv.

If u want further details let me know.

Regards,

Farook.

Edited by: farook shaik on Nov 26, 2008 6:57 AM

[Former Member]

Hi you need to take the KNUMv value from the VBRK table and POSNR from VBRP table and then

KONV-KNUMV = VBRK-knumv and

konv-KPOSN = vbrp-posnr.

[pintoo_d]

But POSNR of VBRP and KPOSN of KONV are different fields. How will that work ?

[Former Member]

Hi Pintoo D,

First Select data from VBRK to internal table IT_VBRK

then select data from VBRP to internal table IT_VBRP

NOW

select data from KONV to internal table IT_KONV WHERE KNUMV = IT-VBRK-KNUMV and KPOSN = IT_VBRP-POSNV.

KONV table contains item level details and KPOSN is the field which will say the data(record) contains details of which item...

Relation between KONV VBRK AND VBRP is as below..

KONV-KNUMV = VBRK-KNUMV ==> will give you header level details

KONV-KPOSN = VBRP-POSNR ==> will give you item level details..

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

[pintoo_d]

gr8

thnx for sharing important info wth me.

this resolved my issue .. however can u share with me how did you guys know that VBRP POSNR is same as KONV KPOSN and similar stuff .. for my notes purposes.

Hv nice day

[Former Member]

Hi,

This all based on some experience and if u work more on scripts/forms you will cum to know these relations

Regards