topic Re: insert and delete records in Application Development and Automation Discussions

insert and delete records

Former Member — Sun, 01 Jul 2007 09:37:34 GMT

hi,

my requirement is

developed a report insert and delete from kna1 tables basing customer number

Re: insert and delete records

Former Member — Sun, 01 Jul 2007 11:26:52 GMT

Hi,

To insert:

Why do you want to develop a report to entries into KNA1. The data will be inconsistent if you just insert entries in KNA1 but not in other related tables (eg. KNB1, KNC1 etc.) Anyways, you can develop a BDC/BAPI or use LSMW tool to do the same for inserting entries into KNA1.You can standard transction XD01 to do that. It will have authorization checks, validation checks etc.

To delete:

The data will be inconsistent if delete entries from KNA1 but not from other related tables. Especially if the transaction data exists for the customer.

Try to use standard transactions.

Regards,

Srilatha.

Re: insert and delete records

Clemenss — Sun, 01 Jul 2007 17:16:32 GMT

Hi priya reddy,

a responsible developer will never insert or delete records in SAP standard tables directly.

Whatever you do in the system ist object to review for a financial auditor. That means that changes must be traceable and reasonable. This is guaranteed by the use of certified SAP standard transactions.

Whoever gave you this requirement: Tell them that you are not entitled to act outside the law.

You can nark a customer for deletion. If all business processes regarding the customer are completed. you can archive the master data. That involves a physical deletion in the database.

Regards,

Clemens

Re: insert and delete records

Former Member — Sun, 01 Jul 2007 19:04:03 GMT

Hi Priya,

Never insert or delete data directly into Standard SAP tables, instead try to use transaction XD01 or VD01.

Thanks

Aneesh.