Extractor to pul fields ...

[Former Member]

Hi all,

I am extracting data from MM domian , can u please help me to find out which extractor pulls folling fields from ECC to BW .

Vendor group,Contract number,Number of Material Groups,Product number,Invoice number,Invoice due date,Invoice amount net,Invoice amount gross,Invoice enter date,Invoice pay date,Credit note,Invoice line number,Invoice Line amount net,Invoice Line amount gross,Invoice quan,Payment Terms,Payment method

Thanks

[Former Member]

hi,

line item depending details will be available ON one of the table called

J_1IEXCHDR, if you want to know some other details regarding invoices

search in J_1I*, tables

if helpful provide points

regards

harikrishna.N

[dielom]

Hi Prafful,

You can get some fields from 2lis_02_itm, 2lis_02_scl and 2lis_02_hdr.

Also, there is a table in ECC where you can find the invoices number assigned to purchase orders, I don't remember the name, ask a FI analyst for the table or the transaction where to see that so you can get the table name.

Hope this helps.

Regards,

Regards,

Diego