Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Get Ship to

Go to solution
VikasB
Active Participant

‎2008 Apr 22 7:13 AM

0 Likes
554

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.

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2008 Apr 22 7:27 AM

0 Likes
534

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

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.

Reply
3 REPLIES 3
Read only

Go to solution
Former Member

‎2008 Apr 22 7:27 AM

0 Likes
535

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

Read only

Go to solution
Former Member

‎2008 Apr 22 7:33 AM

0 Likes
534

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

Read only

Go to solution
Former Member

‎2008 Apr 22 7:42 AM

0 Likes
534

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