10-29-2007 3:27 PM
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
10-29-2007 9:06 PM
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