Skip to Content
author's profile photo
Former Member

Hi

Posted on May 05, 2011 at 10:11 AM 6 Views

Hi SAP Experts,

I have Business Requirement where I want to Filter Sales Orders based on SHIP-TO party.

I can get the Sales Order Numbers from VBAK table,but this has SOLD-TO party and does not have SHIP-TO party,

Where and how can I get the SHIP-TO party field of Sales Order ??

Appreciating your quick response.

Thanks and Regards,

Umesh Karane.

SD (Sales and Distribution) SAP ERP
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Posted on May 05, 2011 at 10:16 AM

    Hi,

    You can the values by using the table "VBPA".

    Goto the T.Code "SE16/SE16n"

    Enter the table Name as "VBPA".

    Here Enter the Partner Function as "WE"/"SH".

    Enter your Customer Number in the field "Customer".

    Execute.

    It will give you all Sales Orders and Invoices generated by using this Custoemr as "Ship-To-Party".

    Regards,

    Krishna.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Lakshmipathi Ganesan
    Posted on May 05, 2011 at 10:21 AM

    Go to IMG --> Sales and Distribution --> Sales --> Lists --> Set Updating of Partner Index. Here, maintain the following values.

    Transaction Group      Partner Function
 
          0                 SP      
          0                 SH
          0                 PY
          0                 BP

    Now execute VA05 where you click "Partner function" tab from top. Maintain your ship to party code and execute so that system will list out all sale orders based on that ship to party.

    Last but not least, please make use of the subject effectively.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Shiva Ram
    Posted on May 05, 2011 at 02:39 PM

    Check OSS 1453670 - Transaction VA05: Selection by partner function type not working

    Regards,

    Add comment
    10|10000 characters needed characters exceeded