Foreign trade data in SD

[#1]

Hi experts,

There is a need of reporting on foreign trade data in SD.

In R/3

According to my knowledge foreign trade data present in table EIKP and EIPO. when I see in document level of SD delivery and billing, I find that the corresponding foreign data comes from Material Master records.

Now I don't find EIKP and EIPO tables fields(like commodity code, office of exit, mode of transport) for Material Master data in BW as well as in R/3. Even I don't find that Material master data is based on these tables?

How can I extract the foreign trade data from ECC to BW?

Can anyone help me?

Rakesh

[dennis_scoville4]

You have a couple of possibilities here. If you want your SD DataSources for billings and deliveries to have this data, you can append the fields needed to the extract structure and create a User Exit for those respective DataSources through CMOD to lookup on the EIKP and EIPO tables. The other choice would be to create generic DataSources for each table, or if possible create a view of these two tables and create one generic DataSource from that view.

[Former Member]

Thanks Dennis,

Yes you're right. I could enhance the datasource and using CMOD or create generic datasource. But I was looking standard datasource. I guess, I have to do the CMOD.

Ok, thanks.

Anzar

[Former Member]

Hi Dennis,

Please tell me if there is any Standard Extractor available for the above requirement.

Regards,

Prabhu M.

[Former Member]

Hi Rakesh,

Sorry, have you found the answer for this? if you don't mind, can you share it with me?

Thank you.

Anzar