how to find a Sales document with Certain type and having a certain Matnr ?

[Former Member]

How can I find a sales document with a certain type and having a certain materail.

is there any table to find that ??

Thanks

Venkat

[Former Member]

Hi Venkat,

I found this table interesting. Pls. check with the table VBAP_VAPMA, it has the data of the header along with the items.

Reward if it helps.

Regards,

Sreekanth

[Former Member]

Hi venkat...

Sales document type and materails you can not have in one table.. but you can join and see in ABAP Query... by joining VBAP/VBAK...

Reward if it helps

Ramki

[Former Member]

VBAK Contains sales document and doc type

VBAP contains sales document and Material number

check in SE16 transaction

[Former Member]

Hi Seshu,

Thanks for reply !!

I knew that !! I am asking for any table which contains Sales Document, Type and Material .

Regards

Venkat

[Former Member]

No table Venkat

[Former Member]

Thanks Seshu ..

Regards

Venkat