topic Re: SD tables in Application Development and Automation Discussions

SD tables

Former Member — Fri, 27 Apr 2007 18:13:27 GMT

hello all,

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

thanks in advance

seenu

sreeramkumar_madisetty — Fri, 27 Apr 2007 18:18:05 GMT

The Relation is :

konv -KNUMV = vbak-vbeln.

Regards,

Sreeram

amit_khare — Fri, 27 Apr 2007 18:18:18 GMT

Check A090 table.

Regards,

Amit

Former Member — Fri, 27 Apr 2007 18:18:26 GMT

Hi,

you can use the condition number..

VBAK-KNUMV = KONV-KNUMV

Thanks,

Naren

Former Member — Fri, 27 Apr 2007 18:20:13 GMT

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 — Fri, 27 Apr 2007 18:29:43 GMT

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