on 10-22-2012 12:48 PM
Hi SDNer,
My scenario: RFC--> PI --> MySQL Database
Name of Database: forSAP
Name of Table: TableA
Table Structure:
- VKORG (Primary Key)
- KUNNR (Primary Key)
- ANRED
- NAME
- PSTLZ
- SPRAS
- ORT01
- STRAS
- TELF1
- STATUS
Requrirement:
Before writing, the following condition must be checked and the conrresponding behaviour would be executed:
If the dataset does not exit, the new dataset should be inserted and the STATUS is set to N.
If the dataset exits and the STATUS is empty, the dataset would be updated and the STATUS is set to N.
If the dataset exits and the STATUS is with other characters, the dataset should be updated and set the STATUS to U.
I have read the help doc:
http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm
But I have no idea, how to realise the above requirements. If...Then is allowed in DLM? or it must be implemented through stored proc?
Any idea would be welcome.
Thanks a lot!
Regards
Rene
Hi Rene,
Ask your DB team to create one more new table in data base and using PI insert data in to new table,then request you DB team write a stored procedure at data base level to insert/update data in to maintable from new table.
Regards.
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.