Skip to Content
0
Former Member
Feb 25, 2009 at 07:01 PM

Need to get tax description from TTXJT based on costing sheet KALSM field

135 Views

Hi,

I want to get description of tax from table TTXJT, the field is TEXT1. This is pooled table whic has KALSM field which is also in KOMK and KOMG tables. But when I am doing below code , nothing is coming in komk-txjcd. How can I retrieve data from komk structure? Please help me with this.

if komk-txjcd ne space and komk-kappl = 'TX'.

if ttxjt-kalsm ne komk-kalsm or ttxjt-txjcd ne komk-txjcd.

clear ttxjt.

select single * from ttxjt where spras = sy-langu.

and kalsm = komk-kalsm

and txjcd = komk-txjcd.

endif.

if sy-subrc = 0.

ttxjt-text1 = ttxjt-text1 .

endif.

endif.

Thank you very much in advance.