How to update database table using report program

[Former Member]

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.

[Arun_Prabhu_K]

Hello Umakant.

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

Regards.

[Former Member]

Hi arun,

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

regards,

umakant

[vinoth_kumar7]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

Hi Umakant,

use function module sd_customer_maintain_all for updating knvv.

[Former Member]

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

[Former Member]

HI Umakant,

Try with Class cmd_ei_api

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

[Former Member]

Hi,

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

Regards,

Supratik

[Former Member]

the query is solved,

thanks guys for all u r inputs.

Thanks,

umakant.

[Former Member]

Hi Umakant,

Can you share the sloution.

Thanks,

S.Rajendranath Rapathi.

[Former Member]

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

[Former Member]

Hi Umakant,

Try to check the bellow link for your solution:

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

Thanks & Regards,

Goutam Kolluru.

[SujeetMishra]

Hi Umakant,

These BAPIs are used in Transaction Code XD01.

BAPI_CUSTOMER_GETCONTACTLIST

BAPI_CUSTOMER_CREATE

BAPI_ATTENDEE_PREBOOK_LIST'

Regards,

Sujeet