08-06-2007 4:02 AM
Hi,
I have requirement that not recommend from SAP. External system will be directly insert into the customize table from database level.
but then i cannot check the data from se16 / se11 because the data not inserted through SAP environment (direct db to db).
any way to process the data through ABAP program ?
Please help me.
Thank you and Best Regards
Fernand
08-06-2007 4:41 AM
I have done this before - create the Z custom table in the SAP repository using SE11, and then insert / delete / update data directly into it via external SQL outside of SAP. If client dependant, then external SQL needs to fill MANDT field to get correct key.
The table can then be read and processed in ABAP, and can be viewed in SE16 the same as any other table.
To ensure completeness of data, you can define a second "control" table where the external SQL updates a status once it has finished updates to the main table - this prevents ABAP processing before the external SQL finishes.
When creating in SE11 you may want to set the technical parameters so it uses a USER data class that Basis can link to a separate tablespace to control size and security aspects.
08-06-2007 4:39 AM
08-06-2007 4:41 AM
I have done this before - create the Z custom table in the SAP repository using SE11, and then insert / delete / update data directly into it via external SQL outside of SAP. If client dependant, then external SQL needs to fill MANDT field to get correct key.
The table can then be read and processed in ABAP, and can be viewed in SE16 the same as any other table.
To ensure completeness of data, you can define a second "control" table where the external SQL updates a status once it has finished updates to the main table - this prevents ABAP processing before the external SQL finishes.
When creating in SE11 you may want to set the technical parameters so it uses a USER data class that Basis can link to a separate tablespace to control size and security aspects.
08-06-2007 4:51 AM
Thank you Andrew,
Finally, i can retrieved the data from se11 because of the MANDT value.
Best Regards
Fernand