Skip to Content
avatar image
Former Member

Invoice Without Ship to Partner

Hello experts,


I have an requirement to extract customer and sales related data along with billing . I have some scenarios where we have Invoices without ship to partner. I need to provide the address in the reports in this case How to fill the ship to address?


Thanks,

Amy

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Mar 15, 2012 at 03:18 PM

    Not sure whether you are aware of this.  Normally, as per standard logic, in billing document, at header level, SH will not flow and I presume, you are looking at header level only.

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 15, 2012 at 12:44 PM

    Hi,

    you can find out the customer and sales related data along with billing using the tables VBAK, ABAP, VBFA and VBRK, you can make query in SQVI

    And regarding ship to address if you not maintaining ship to Party means if your sold to part and ship to party is same then use address from table KNA1 or KNVS. Or you can have specific plant or storage location used for that customer then you can take address from that for reporting purpose.

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 15, 2012 at 02:35 PM

    For the billing document, find the value of reference document number using the table field VBRP-VGBEL. I assume this carries delivery number. Use this delivery number in the table VBPA-VBELN and partner function as SH (or WE) in the field VBPA-PARVW to find the address number from the field VBPA-ADRNR. Then use this number in table ADRC to find the address.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 21, 2012 at 06:41 AM

    Do you have ship-to partner at item level? Get it from 1st itemw with VBPA.

    If not, check VBFA table on document flow for its outbound delivery number and then get shipto address from VBPA.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 21, 2012 at 06:49 AM

    Hello Amy,

    Ship-to-party os not available at Invoice Header Level. As you may have Line Items from multiple Ship to Party in single Invoice.

    So you will have to go at Invoice Item Level Partners & look for Ship-to-Party for each Line Item.

    Should you need address of Ship-to-Party, it is available in ADRC table.

    Thanks,

    Jignesh Mehta

    Add comment
    10|10000 characters needed characters exceeded