Open SQL Array select, the output table is too small

Former Member — Wed, 09 Mar 2011 15:43:55 GMT

Hi All,

Im using a FORM / PERFORM within a SAP creditnote smartform. I'm using hte BDI of the associated invoice to populate the BDI table as it is on the invoice. The way this is being done is as follows:

PERFORM get_invoice_bdi TABLES GT_INVOICE_BDI

USING invoice_bdi_guid.

FORM get_invoice_bdi TABLES lt_invoice_bdi

USING lv_invoice_bdi.

SELECT * INTO table lt_invoice_bdi

FROM /1BEA/CRMB_BDI

WHERE BDI_GUID = lv_invoice_bdi.

ENDFORM.

But on running the form, i get the error above on the SELECT line, as it says the database table is 644 bytes, and the internal table is 532 wide. I've never used the TABLES parameter before in form routines, I was pointed in this direction by a colleague here on SDN, so i'm unsure as to how i specify a 'wider' table. Can anyone help? - I have already resolved my earlier post as the form compiled without errors, otherwise i would have posted there.

Thanks,

Andy

Re: Open SQL Array select, the output table is too small

huseyindereli — Wed, 09 Mar 2011 15:51:51 GMT

GT_INVOICE_BDI has to be declared exactly the same type with /1BEA/CRMB_BDI.

DATA : GT_INVOICE_BDI type table of /1BEA/CRMB_BDI .

Re: Open SQL Array select, the output table is too small

Former Member — Wed, 09 Mar 2011 15:56:53 GMT

Brilliant, thankyou! Didn't notice i'd incorrectly defined my table, thanks for the pointer - and sorry for the stupid question!

topic Re: Open SQL Array select, the output table is too small in Application Development and Automation Discussions

Open SQL Array select, the output table is too small

Re: Open SQL Array select, the output table is too small

Re: Open SQL Array select, the output table is too small