07-08-2008 2:56 PM
Hello,
Very Good evening!
Is it possible to extarct the data dependent upon the country....
NA(North America) uses VBAP-EAN11 and all other countries use VBAP-MATNR.
If there any way that we can extract the data in this way....
Please provide me any way to extract the data in this manner.
As of now I found a field in the table VKDFS-LLAND...
Please suggest any best way to extract the data from the field VBAP-EAN11.
Any suggestions would be apprecaiated.
Regards,
Kittu
07-09-2008 5:34 AM
Hi,
From the MARA table we can find- HERKL the origin of the material form this we can find.
We can also find this in MARC, MARD etc .
What you hav mentioned from VKDFS-LLAND is Destiantion country.
U need to refer to table T005 for countries list for HERKl field.
from that try to get the materials by country wise from MARA or MARC.
Reward if helpful.
Best Wishes,
Chandralekha
Edited by: Chandralekha on Jul 9, 2008 6:34 AM
Edited by: Chandralekha on Jul 9, 2008 6:36 AM
07-09-2008 5:34 AM
Hi,
From the MARA table we can find- HERKL the origin of the material form this we can find.
We can also find this in MARC, MARD etc .
What you hav mentioned from VKDFS-LLAND is Destiantion country.
U need to refer to table T005 for countries list for HERKl field.
from that try to get the materials by country wise from MARA or MARC.
Reward if helpful.
Best Wishes,
Chandralekha
Edited by: Chandralekha on Jul 9, 2008 6:34 AM
Edited by: Chandralekha on Jul 9, 2008 6:36 AM
07-09-2008 5:52 AM
Hi,
Pass VBPA slaes order numer and item u get Country details.
VBPA-LAND1
Reward if useful....
Thanks,
Durai.V
07-16-2008 3:20 PM
Hello Leka & Durai,
Thank you for your response,
Your suggestion was helpful....
Points rewarded
Regards
Kittu