topic Re: REPORT in Application Development and Automation Discussions

REPORT

Former Member — Mon, 29 Oct 2007 15:27:30 GMT

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

Former Member — Mon, 29 Oct 2007 21:06:26 GMT

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