Mode of Transport for Foreign Trade

[Former Member]

Hi,

I need to obtain the field EXPVZ(Mode of Transport for Foreign Trade). I have purcahse order number. How do i drill down to field EXPVZ using PO number. Can anybody give me the linkage of the tables and their fields to achieve this task .

Regards

Nishant

Message was edited by: Nishant Gupta

[Former Member]

Hi Nishant,

Try this... In EKKO you will get "EXNUM" for a PO. Then from table EIKP you can obtain the field - "EXPVZ".

Thanks and Regards,

Bharat Kumar Reddy.V

[Former Member]

from EXNUM in EKKO, use in EIKP n get ur field EXPVZ...

[Former Member]

Thankx guys... Got it

[former_member181962]

In EKKO you get BSTYP

BSART and RESWK.

Pass them to T161W table to get EXPVZ.

select single BSTYP

BSART

RESWK

from EKKO

into x_ekko

where ebeln = p_ebeln.

select EXPVZ

from T161W

into v_EXPVZ

where BSTYP = x_ekko-bstyp

BSART = x_ekko-BSART

RESWK = x_ekko-RESWK.

Regards,

Ravi