Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Open SQL Array select, the output table is too small

Former Member
0 Likes
634

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

1 ACCEPTED SOLUTION
Read only

huseyindereli
Active Contributor
0 Likes
502

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 .

2 REPLIES 2
Read only

huseyindereli
Active Contributor
0 Likes
503

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 .

Read only

0 Likes
502

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