SD tables

[Former Member]

hello all,

can someone let me know how to link salesdoc no(vbeln) and condition type (kschl).

thanks in advance

seenu

[sreeramkumar_madisetty]

Hi

The Relation is :

konv -KNUMV = vbak-vbeln.

Regards,

Sreeram

[amit_khare]

Check A090 table.

Regards,

Amit

[Former Member]

Hi,

you can use the condition number..

VBAK-KNUMV = KONV-KNUMV

Thanks,

Naren

[Former Member]

Hi Seenu,

You should access table VBAK with VBELN and load the field KNUMV. Then you access table KONV and you'll see all the conditions for a salesdocument.

I hope it's usefull.

Aline

[Former Member]

Hi,

Please try this.

Go to table VBFA with the following criteria to get VBFA-VBELN.

VBFA-VBELV = VBAK-VBELN

VBFA-VBTYP_N = 'M'

then go to table VBRK to get VBRK-KNUMV with the following criteria.

VBRK-VBELN = VBFA-VBELN.

Lastly go to table KONV to get KONV-KSCHL.

KONV-KNUMV = VBRK-KNUMV.

Regards,

Ferry Lianto