Skip to Content
-3

relationship between VBRP and VTTP

Is there any relationship between table VBRP Billing document and VTTP to get the shipment no., for the delivery in VBRP-VGBEL where vgtyp = 'J', but that doesn't work for credit notes where the reference is of the reference, and if its a cancellation, its the reference of the reference of the reference.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 21 at 07:35 AM
    -1

    Hi

    VTTP table is mainly for maintaining Shipment Item details and shipment only happens in the case of Invoicing so in your case you can pass the delivery or OBD no in VTTP and fetch the desired record .

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 29, 2017 at 04:51 AM

    Hi,

    Document number- VBELN is the Link between the two tables

    as VBELN delivery number is refered to create a Billing document

    Add comment
    10|10000 characters needed characters exceeded

    • yes VBELN is the document number of the Billing document, and VBELN is the delivery number reference. but where is the table that joins these two together? I looked in VBFA but there i no link in there between VBRP and VTTP

  • May 21 at 06:45 AM

    Your post is not clear. Probably, you need to explain with an example what exactly you were trying to achieve. In VBRP, you can see fields like AUBEL, AUTYP, VGBEL & VGTYP from which you can very well take the Order and delivery references. If you table join VBRP & VTTP, you can get the required data and not sure, whether you have already tried this.

    Add comment
    10|10000 characters needed characters exceeded