topic Re: Updating database table using function module in Application Development and Automation Discussions

Updating database table using function module

Former Member — Thu, 12 Feb 2009 06:01:20 GMT

Hi All.

I need to insert some records from report program to database table. before that Am Sending set of records to customized function module for some validation. IT_PO is a table parameter in the function module. its using to pass records from report to FM. I have to insert record from table parameter IT_PO to my ZTABLE in the FM itself. Here is getting error like The Work area IT_PO is not long enough

Please guide me.

Thanks in Advance.

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 06:05:05 GMT

chk if the structure of both the itab and the data base table are the same.

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 06:05:36 GMT

Hi Raj

Did you declare it_po as of the same TYPE as the FM parameter table?

Pushpraj

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 06:09:38 GMT

Hi Raj,

Only in one case you will got that error. That is Internal table Or Work area Structure is not Equal to Database table. So you can declare the Corresponding ITab or Work area Equal to Database table Fields list.

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 06:22:29 GMT

Hi,

The error may occur due to Internal table may not match with the database,

if not then the functional module used for validation might raise error.

It is better not use FM for inserting data into the database...

can u able tell the functional module used for validation...

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 07:08:00 GMT

Hi guys,

IT_PO like ZPO as table parameter in FM using this syntax to insert records.

INSERT ZTAB FROM IT_PO .

COMMIT WORK.

ZPO and ZTAB both are same structre.

Please guide me.

Thanks.

Re: Updating database table using function module

former_member222860 — Thu, 12 Feb 2009 07:33:17 GMT

Hi,

Check in the Debug mode, whether values are getting into IT_PO.

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 11:24:25 GMT

Hi Mahesh,

i am getting the values in itab while debugging it..

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 11:27:58 GMT

after getting the entries to ur itab. jus modify ur database table from this itab transporting the fields.

any error u r gettin here?

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 11:31:29 GMT

Hi,

Yes getting error like The Work area IT_PO is not long enough.

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 11:34:56 GMT

i mean r u getting this at modify statement? chk sy-subrc after the fm and also at modify.

else try: u jus loop at itab.

fetch value to a wa.

modify the database table from wa.

endloop.

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 11:39:40 GMT

Hi,

You import parameter IT_ PO in the FM, instead of that

create table type for the ZTABLE (ztable-table_type),

change it_po type ztable to

IT_PO TYPE ZTABLE-TABLE_TYPE.

Hope it helps u...

Re: Updating database table using function module

Former Member — Thu, 12 Feb 2009 11:48:23 GMT

Hi Rajkumar,

What problem are you facing to declare , IT_PO like ZTAB.

Do this change , it'll work.

and Press F1 on INSERT, MODIFY and UPDATE statement, U'll get lot of inputs.

Re: Updating database table using function module

former_member222860 — Thu, 12 Feb 2009 12:24:45 GMT

Hi,

Declare your IT_PO like ZTAB

and the stmt. as

INSERT ZTAB FROM TABLE IT_PO.

Pl. check .

thanks

Re: Updating database table using function module

former_member653066 — Fri, 16 Oct 2015 12:12:31 GMT

hi,

dear experts, i have an typical issue. plz get me out this.

details are below,

we all are familiar with ME9K , this is used to print the purchase documents which is released,

customer wants to see the po docs which is not released, i tried to create a z## prog but enhancements is not going to copy as per sap standards, no enhancements were found in my side..

plz help me this,,,