topic SELECT FROM BSAS in Application Development and Automation Discussions

SELECT FROM BSAS

Former Member — Tue, 10 Jul 2012 15:44:47 GMT

Hello gurus,

i'm a financial consultant that sometimes makes some programming....so at this moment i'm making a very simple program that should read both BSIS and BSAS.

but, after reading BSIS when it comes to read BSAS, i get a DUMP DBIF_RSQL_INVALID_RSQL.

I've read that we should be carefull while reading BSAS and BSiS...but as you can see the select parameters are the same..... i'm sending you the code below:

IF p_bsis = 'X'.

*DEPOIS DE DETERMINAR OS DOCUMENTOS E AS CONTAS VAI LER A BSIS.

IF r_hkont[] IS NOT INITIAL.

SELECT bukrs hkont belnr buzei gjahr fipos

INTO TABLE gt_bsis

FROM bsis "FOR ALL ENTRIES IN so_belnr

WHERE bukrs = so_bukrs

AND hkont IN r_hkont

AND belnr IN so_belnr

AND gjahr = so_gjahr

AND monat IN so_monat.

ENDIF.

ELSEIF p_bsas = 'X'.

SELECT bukrs hkont belnr buzei gjahr fipos

INTO TABLE gt_bsas

FROM bsas "FOR ALL ENTRIES IN so_belnr

UP TO 3 ROWS

WHERE bukrs = so_bukrs

AND hkont IN r_hkont

AND belnr IN so_belnr

AND gjahr = so_gjahr

AND monat IN so_monat.

ENDIF.

Can anyone help?

Thank you,

Nuno Anjos

Re: SELECT FROM BSAS

Former Member — Tue, 10 Jul 2012 16:04:02 GMT

Hi,

Could you post the content of the dump please ?

Also, is SO_GJAHR a select-options or a parameter ?

Re: SELECT FROM BSAS

Former Member — Tue, 10 Jul 2012 16:19:09 GMT

The order of fields in itab "gt_bsas" structure should be similar to the the order of the fields selected from table BSAS .Please verify this..

Also as a temporary fix try "INTO CORRESPONDING FIELDS OF TABLE gt_bsas.. Just for u'r understanding

Re: SELECT FROM BSAS

Former Member — Tue, 10 Jul 2012 17:05:51 GMT

Well what ya know... as simple as that.... i switched gjahr with belnr and it's runs great.

*SELECT bukrs hkont belnr buzei gjahr fipos

SELECT bukrs hkont gjahr belnr buzei fipos

Perfect. Thank you.

Re: SELECT FROM BSAS

Clemenss — Tue, 10 Jul 2012 21:48:43 GMT

it is an urban legend that INTO CORRESPONDING FIELDS OF TABLE costs any performance. It should be used as a default.

Do a performance analysis to see the difference

Regards

Clemens

Re: SELECT FROM BSAS

Former Member — Fri, 13 Jul 2012 08:41:06 GMT

Hello Clemens,

I already changed it. It's faster in deed. Thank's for the tips.

Best Regards,

Nuno Anjos

Re: SELECT FROM BSAS

Former Member — Fri, 13 Jul 2012 08:41:09 GMT

Hello Clemens,

I already changed it. It's faster in deed. Thank's for the tips.

Best Regards,

Nuno Anjos