topic Re: How to update database table using report program in Application Development and Automation Discussions

How to update database table using report program

Former Member — Sat, 07 Sep 2013 09:13:49 GMT

Hi guys,

i have a requirement to update customer data in table knvv, here i have enhanced tcode XD01 with extra tab

having 2 fields. no i m trying to update customer master based on division using LSMW.but in recording i am

unable to see the custom tab.

now i m trying to update database table KNVV directly through report program,unable to change the records.

please suggest any solution.

Thanks,

Umakant.

Re: How to update database table using report program

Arun_Prabhu_K — Sat, 07 Sep 2013 10:35:49 GMT

Hello Umakant.

Check if a BAPI is available for your requirement using tcode BAPI.

Regards.

Re: How to update database table using report program

vinoth_kumar7 — Sat, 07 Sep 2013 11:08:34 GMT

This message was moderated.

Re: How to update database table using report program

Former Member — Sat, 07 Sep 2013 11:55:14 GMT

Hi arun,

there is no such BAPI to update record in KNVV table.

regards,

umakant

Re: How to update database table using report program

Former Member — Sun, 08 Sep 2013 06:27:44 GMT

This message was moderated.

Re: How to update database table using report program

Former Member — Sun, 08 Sep 2013 16:49:38 GMT

This message was moderated.

Re: How to update database table using report program

Former Member — Mon, 09 Sep 2013 05:29:30 GMT

This message was moderated.

Re: How to update database table using report program

Former Member — Mon, 09 Sep 2013 05:55:47 GMT

Hi,

Please check whether custom fields are added in SE11 customer master table using append structure with all required Z fields. If not, please add Z fields in the customer master respective tables, then u could see those fields in LSMW BDC recording method.

Best Regards,

Abirami

Re: How to update database table using report program

Former Member — Mon, 09 Sep 2013 07:40:13 GMT

Hi Umakant,

use function module sd_customer_maintain_all for updating knvv.

Re: How to update database table using report program

Former Member — Mon, 09 Sep 2013 08:38:06 GMT

HI Umakant,

Try with Class cmd_ei_api

http://scn.sap.com/message/7998944

Re: How to update database table using report program

Former Member — Mon, 09 Sep 2013 13:56:49 GMT

Hi,

You can use INSERT statement to update the database. But we should always use BAPI to update database.

Regards,

Supratik

Re: How to update database table using report program

Former Member — Mon, 16 Sep 2013 09:25:06 GMT

the query is solved,

thanks guys for all u r inputs.

Thanks,

umakant.

Re: How to update database table using report program

Former Member — Mon, 16 Sep 2013 09:33:45 GMT

Hi Umakant,

Can you share the sloution.

Thanks,

S.Rajendranath Rapathi.

Re: How to update database table using report program

Former Member — Wed, 09 Oct 2013 07:15:34 GMT

Hi Umakant,

You can use the following method in LSMW:-

=> Direct input method

Object :- 0050

Method :-0000

Program name :- RFBIDE00

Program type :- B

Just fill KN00 and KNVV structure in the program.

Hope this helps you.

Regards,

Somesh

Re: How to update database table using report program

Former Member — Wed, 09 Oct 2013 07:26:40 GMT

Hi Umakant,

Try to check the bellow link for your solution:

http://scn.sap.com/thread/88361

Thanks & Regards,

Goutam Kolluru.

Re: How to update database table using report program

SujeetMishra — Wed, 09 Oct 2013 08:35:47 GMT

Hi Umakant,

These BAPIs are used in Transaction Code XD01.

BAPI_CUSTOMER_GETCONTACTLIST

BAPI_CUSTOMER_CREATE

BAPI_ATTENDEE_PREBOOK_LIST'

Regards,

Sujeet