Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Delete and insert the data into database

Dear Experts,

I have a requairement to delete old data and insert the new data in to data base through PI.

kindly let me know how to create the DATA type for this requairement.

below are the fields in the database side.

MailID

Name

company

sal

address

any one kindly help me on this

Regards

Kiran

Tags:
Former Member
Former Member replied

Hi Kiran,

you can create the DT like below, we have a same requairement and developed the same.

DT_Kiran....

- > Statementname

   ->TableName

      action  - Delete

      Table  -- Maintain the Tablename

- > Statementname1  - 1 to unbound

   ->TableName

      action  - Insert

      Table  -- Maintain the Tablename

      ->Access    1 to unbound

       MailID

      Name

      company

      sal

      address

Regards

Srinivas

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question