topic Re: Simple Select Help in Application Development and Automation Discussions

Simple Select Help

Former Member — Tue, 11 Mar 2014 20:46:41 GMT

I have the below code and it's not pulling the chart of accounts. What could I be doing wrong? It looks fine to me...

PARAMETERS: d_cc TYPE bukrs OBLIGATORY.

DATA: wa TYPE t001.

SELECT ktopl FROM t001 INTO wa WHERE bukrs EQ d_cc.

IF wa-ktopl IS NOT INITIAL.

WRITE: 'Company Code ', d_cc, ' uses Chart of Accounts ', wa-ktopl.

ELSE. WRITE: 'Company Code ', d_cc, ' has not been assigned a Chart of Accounts.'.

ENDIF.

ENDSELECT.

Former Member — Tue, 11 Mar 2014 20:53:12 GMT

Hello,

Change your select query as below.

SELECT ktopl FROM t001 INTO wa-KTOPL WHERE bukrs EQ d_cc.

Regards,

Sameer

Former Member — Tue, 11 Mar 2014 20:57:08 GMT

Thank you! Duh!