topic Re: Update LFA1 in Application Development and Automation Discussions

Update LFA1

Former Member — Thu, 29 Jun 2006 14:44:57 GMT

hi friends,

i have to update LFA1 table with VAT numbers and TAX codes. Input file will contain Account group(KTOKK),country key(LAND1),Vendor(LIFNR),VAT no(STCEG) and TAX code (STCD1).

my final internal table will contain all these fields

i want to write and update statement on LFA1

UPDATE LFA1 from table ITAB.

but if i write this KTOKK and LAND1 fields will also get effected in LFA1 as LIFNR is the only key field,i want only VAT and TAX codes to get effected.

i dont want to write update in loop , pls suggest any solution , i am on 4.6c

Re: Update LFA1

Former Member — Thu, 29 Jun 2006 14:49:44 GMT

Hi,

First select all the fields from LFA1 for your list of vendor and update the fields that you wanted to in the internal table. Finally use Update statement with internal table.

Hope this helps.

Regards,

Nagaraju Chidurupalli

Re: Update LFA1

Former Member — Thu, 29 Jun 2006 14:50:06 GMT

Tra to use MASS transaction not an ABAP.

BR, Jacek

Re: Update LFA1

Former Member — Thu, 29 Jun 2006 14:59:11 GMT

Do NOT do direct updates to a core table like LFA1 !!

Use a BAPI or "heaven-forbid" a BDC to do this...

You ALWAYS want to stay within SAP data model... if you perform direct updates on a core table, you run a high risk of breaking the database's referential integrity.

In short... if you update LFA1 directly... you should also update your resume.

Re: Update LFA1

Former Member — Thu, 29 Jun 2006 16:01:49 GMT

You can probably use standard SAP program RFBIKR00 for this. The documentation says that you can use it to change vendors, but I have not tried it.

Rob

Re: Update LFA1

Former Member — Mon, 20 Jan 2014 09:43:59 GMT

Can you help me, how is possible update vendor data using net. connector with RFC function (or some another way to update vendors data from 3th party program). Up to now I read only data from LFA1 using net. connector (using RFC function RFC_READ_TABLE) and now I need update vendor data (e.g. NAME1, NAME2, ADRNR etc. from LFA1)

Our SAP system contains very much duplicate record (many LIFNR has the same STCD2, STCEG etc. but different NAME1 who contains typist's error or something like this. 6000 vendors has 1700 duplicates and incomplete record). Our Administrator don't know how set up SAP so that impossible create duplicite vendors! Because our system SAP contains very, very, very much elementary error, this system is not helpfull for our company.

Thank you