Skip to Content
author's profile photo
Former Member

Help me logic

Hi,

I have one requirement

When ever an Outbound IDOC is created for product deliveres

there are three important Address information sent

1. Sold to Party (Partner Type – AG )

2. Ship to Party ( partner Type – WE )

3. Engineer Location ( ZM)

For the above when filling the IDOC Data for product we need to pick the address from Delivery instead of Customer master directly.

VBPA will store Sales order customer address number and also Delivery customer Address number.

ADRC will store the actual address.

How to write the select query for above requirement.Please help me.It is very urgent requirement.

Thanks,

srihitha

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 04:20 AM

    hi srihitha,

    Get the customer from vbpa , input it into kna1 get the ADRNR and put in adrc then u will get the address.

    regards,

    Santosh

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 04:24 AM

    Hi,

    Select kunnr adrnr parvw from VBPA

    into table gt_vbpa

    where vbeln = Delivery document number

    and Parvw = WE and AG and ZM.

    from this you will get address number for ship to party, sold to party and ZM.

    from adrc pass the address number selected in above step, to get address details.

    SELECT * from ADRC

    into table gt_adrc

    FOr all entries in gt_vbpa

    where addrnumber = gt_vbpa-adrnr

    you can use your own logic in above manner to get the details.

    Regards,

    Raghavendra

    Add comment
    10|10000 characters needed characters exceeded