Table for combination of Purchase requestition doc type and Purchase order doc type

[former_member550881]

Hi,

scenario:

Purchase requestion has document type of Direct purchase which has allowable item category "Standard, consignment, subcontracting, third party and stock transfer".

Purchase order has document type of indirect purchase which has allowable item category "standard and services".

Now i saw in Define Document type OMEC, 'Doc type-Direct purchase' of purchase requestion is being linked to 'Doc type-Indirect purchase' of purchase order.

Question:

Can you please let me know how to pull of data for combination of  'Doc type-Direct purchase' of purchase requestion and 'Doc type-Indirect purchase'  of purchase order from SE16N? (assuming that we dont know what PR is converted to PO for the above combination)

Note: Please don't delete this thread

[Former Member]

This message was moderated.

[Former Member]

You did the hardest part: finding the custo in SPRO.

Once you there, just click "table view" :

and then on "print"

Once you click, you see the table name you are looking for:

Hope it helps,

Génia.

[Former Member]

In EBAN table itself you have the PO number . For those PO you can check doc type in EKKO.

You can create simple SAP query with those tables and get the desired result

[former_member550881]

Hi Raja,

Thank you,

I did vlookup between two tables to get my data.

[raviraj_sharma]

T161A  is the Table

[Former Member]

Check in table T161P or T160