topic Get Ship to in Application Development and Automation Discussions

Get Ship to

VikasB — Tue, 22 Apr 2008 06:13:18 GMT

Hi all,

I am developing one report in which I want to get the Ship-to-Party for a particular Sales Order and Sales Order Line item number.

I can see table VBPA from I can get value of KUNNAR and so on. But my concern is that can the Ship-to-Party differ for different line items for sales Order, if yes how to get that one, any table or any function module?

In my scenario i found out that ship-to-party only depend upon sales order and partner function not line item.

please help me..

regards,

vikas.

Re: Get Ship to

Former Member — Tue, 22 Apr 2008 06:27:25 GMT

hi Vikas.,

in ur select stmt in where clause just add PARVW = 'WE'.

Reward points if useful

Chandra

Edited by: Chandrasekhar Velpula on Apr 22, 2008 8:30 AM

Re: Get Ship to

Former Member — Tue, 22 Apr 2008 06:33:09 GMT

hi,

actually ship-to depends upon line item as well but in your case it is not maintained i guess.

and in your select ststement use

parvw = 'WE' for ship-to

because there is a conversion routine associated to this field.

reward if useful,

kushagra

Re: Get Ship to

Former Member — Tue, 22 Apr 2008 06:42:21 GMT

Hi Vikas,

If we look into the transaction we find that for all the line items we have one ship-to-party.

so in select statement u can fetch the kunnr so on, where as in where condition u need to give the Sales Order, Sales Order Line item number and partner function ( ship-to-party).

reward if helpful

raam