Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

transporter name

Former Member
0 Kudos

hi all

can u give me table name and link between sales billing documents and transporter name.

thanks in advance.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Dear Prashant,

go to LIPS-VGBEL WITH VBRP-AUBEL THEN GO TO VTTP-VBELN WITH LIPS-VBELN AND IN LAST JOIN VTTK-TKNUM WITH VTTP-TKNUM.

ENJOY.

GIVE POINTS IF USEFUL

REGARDS,

NAVIN

4 REPLIES 4

Former Member
0 Kudos

Check vbrp and vbrk for billing document heade and item data

Former Member
0 Kudos

Dear Prashant,

go to LIPS-VGBEL WITH VBRP-AUBEL THEN GO TO VTTP-VBELN WITH LIPS-VBELN AND IN LAST JOIN VTTK-TKNUM WITH VTTP-TKNUM.

ENJOY.

GIVE POINTS IF USEFUL

REGARDS,

NAVIN

Former Member
0 Kudos

1) First all required data from VBRP.

2) SELECT traty traid

FROM likp

WHERE vbeln = vbrp-vgbel.

3) SELECT lifnr

FROM vbpa

wHERE vbeln = vbrp-vgbel.

4) SELECT name1

FROM lfa1

WHERE lifnr = vbpa-lifnr.

Also LIKP-TRATY is Means-of-Transport Type

and LFA1-Name1 is transporter name.

reward if useful

Former Member
0 Kudos

Hi ,

There is table called VBFA ,

goto that table see there billing and delivery detail information .