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: 

REPORT

Former Member
0 Kudos

This is lalitha,

In my program i have to show delivery block,billing block in my output.

In vbak there is lafsk field as delivery block, in tvlst table there is vtext as delivery block

primary key in vbak is vbeln and in tvlst the fields are mandt,spras,lifsp,vtext. and in tvfst table the fields are mandt,spras,faksp,vtext .

How can i link these tables and write a select statements for getting delivery block& billing block in my output.

ThankU.

with regards

1 REPLY 1

Former Member
0 Kudos

Hi

You can fetch the texts of the delivery block and Billing block by equating the fields

VBAK-LIFSK = TVLSt-LIFSP (actually VBAK-LIFSK = TVLS-LIFSP)

(TVLS and TVLST are same tables)

similarly

VBAK-FAKSK = TVFST-FAKSP (same as above)

(tvfs-faksp = tvfst-faksp)

Write the select Single statements where lifsp = vbak-lifsk like that

You will get it and use it

Regards

Anji