topic Table T053R in Application Development and Automation Discussions

Table T053R

Former Member — Mon, 03 Nov 2008 02:56:27 GMT

Hi,

I need to get an entry from an entry in table T053R, in this table defination there is no field with TXT20,But when the entries are displayed,the field TXT20 with data appears.

I want to get the data of TXT20 from table T053R,how can i do this.?

Please help me out regarding this.

Regards

Srinivas

Re: Table T053R

Former Member — Mon, 03 Nov 2008 02:59:13 GMT

Hi Srinivas,

Use the Table


T053S            " --->Classification of Payment Differences (Texts)

Thanks,

Chidanand

Re: Table T053R

raja_narayanan2 — Mon, 03 Nov 2008 03:52:18 GMT

Hi.....

Try this query.....

SELECT A~BUKRS "company code

A~RSTGR "Reason code for Payments

B~TXT20 "Reason code short text

INTO TABLE <YOUR INTERNAL TABLE>

FROM T053R AS A INNER JOIN

T053S AS B ON A_{BUKRS EQ B}BUKRS

WHERE B~SPRAS EQ 'E'.

Hope this will help you....

Thanks & regards

Raja

Re: Table T053R

Former Member — Mon, 03 Nov 2008 04:44:31 GMT

that is coming from Text table, Just go menu Goto->Text table

and see..