insert and delete records

[Former Member]

hi,

my requirement is

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

[Former Member]

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.

[Clemenss]

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

[Former Member]

Hi Priya,

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

Thanks

Aneesh.