Skip to Content
-3

relationship between VBRP and VTTP

Nov 29, 2017 at 01:22 AM

62

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ravi G 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 .

Share
10 |10000 characters needed characters left characters exceeded
Siva Prasad Vasireddy Nov 29, 2017 at 04:51 AM
0

Hi,

Document number- VBELN is the Link between the two tables

as VBELN delivery number is refered to create a Billing document

Show 1 Share
10 |10000 characters needed characters left 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

0
G Lakshmipathi
May 21 at 06:45 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded