cancel
Showing results for 
Search instead for 
Did you mean: 

Hi, which table could find the country key of delivering plant?

Former Member
0 Kudos

Hi,

Do you know which table field could i find the country key of delivering plant??

And which table could i find the country key of ship-to party?

The purpose of finding above 2 is to determine whether the delivery order/Sales order is export process or not.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

Lakshmipathi
Active Contributor
0 Kudos

You can find the both in Table A510 and the fields are

- Departure country:::::ALAND

- Destination country:::LAND1

May be if you can brief the exact requirement as to why you want to see this, a suitable suggestion can be given.

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi Lakshmipathi,

My scenario is to send picking request IDOC to warehouse upon delivery creation , and in IDOC filling FM, we need the logic to determine the export process then decide corresponding export related segments to be filled and sent.

So i dont know in my case, whether i need check delivering plant from sales order level or delivery order level??

For example:

For checking delivering plant code, then i need check from VBAP-WERKS(Sales order lvl) or LIPS-WERKS(Delivery level)??

This is where i am coming from. I need the logic to be coded in picking request IDOC processing FM.

Thanks.

Former Member
0 Kudos

Dear,

Just Go-through:

[IDOC to SAP Mapping|http://www.erpgenie.com/sapgenie/docs/sapedi/delinsin.xls]

Hope, this may help you.

Best Regards,

Amit

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Plant - T001W- LAND1

Ship to party KNA1-LAND1

Regards,

Chandra

Former Member
0 Kudos

Hi Chandra,

According to your experience, if i want to identify an order whehter it is Export or not, as I should check the ship-to party and delivering plant from delivery order or sales order??? My scenario is to send picking request IDOC to warehouse upon delivery creation, and in IDOC filling FM, we need the logic to determine the export process then decide corresponding segments being filled.

But i dont know in my case, whether i need check from sales order level or delivery order level??

For example:

For checking delivering plant code, then i need check from VBAP-WERKS(Sales order lvl) or LIPS-WERKS(Delivery level)??

Then i will check the country key accordingly from T001w and KNA1.

Thanks.

Edited by: Hoo Laa on Dec 23, 2008 12:19 PM