Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Insert same primary key to custom table not dump

former_member660488
Participant
42,778

Hi experts,

As I am trying to insert same primary key to a custom table ,there is no dump and the data is normally saved to the custom table,not dump.Why is this happening?

INSERT zhx_ficot015i FROM TABLE gt_tb_di.

The same data exists in gt_tb_di and zhx_ficot015i ,but sy-subrc return 0.

codes:

DATA:gw_ficot015i TYPE zhx_ficot015i,
gt_ficot015i TYPE TABLE OF zhx_ficot015i.

gw_ficot015i-mandt = '500'.
gw_ficot015i-od_type = '02'.
gw_ficot015i-receno = 'F510320220420004'.
gw_ficot015i-itemno = '000001'.
APPEND gw_ficot015i TO gt_ficot015i.

INSERT zhx_ficot015i FROM TABLE gt_ficot015i ACCEPTING DUPLICATE KEYS.
IF SY-SUBRC = 0.

ENDIF.
BREAK-POINT.

I fully agree to sandra.rossi. Feel free to contact me via email (see my profile > About).

52 REPLIES 52
Read only

former_member660488
Participant
0 Likes
3,452

Logs of the transport request

Read only

jmodaal
Active Contributor
0 Likes
3,452

I meant the contents of the logs, especially the Export and the Import log. And again I strongly recommend to involve the basis team - support in this way is very tedious and cumbersome.

Read only

former_member660488
Participant
0 Likes
3,452

If having a basis, I don't think this kind of problem should be considered by me.I am a abap,the knowledge of the system is very limited

Read only

jmodaal
Active Contributor
0 Likes
3,452

Operating an SAP system without a basis admin sounds to me like trying to drive a car without wheels. Who else takes care of the TMS, set up of the clients, implementing support packages etc. etc.?

However, the export log should show lines like
88987 lines of ZHX_FICOT015I exported

And the import log should similar lines with "...imported".

Read only

former_member660488
Participant
0 Likes
3,452

Attached is the complete log I exported

Read only

jmodaal
Active Contributor
0 Likes
3,452

Hello,

most relevant part seems to be this:

1 entry from ZZGBDT_MARA exported (500*).

So there was 1 entry of this table from client 500 written out into the datafile. When importing the transport request into any client this 1 record would be inserted resp. updated.

Read only

former_member660488
Participant
0 Likes
3,452

Having imported the request into client that the log shows

Read only

jmodaal
Active Contributor
0 Likes
3,452

Then in the import log a similar entry can be expected

1 entry from ZZGBT_MARA imported (500*).

If the entry already existed, the record from the datafile of the transport has overwritten the already existing one and you can see no difference in the data before / after the import.

Read only

former_member660488
Participant
0 Likes
3,452

the entry have changed after releaseing and before importing,after importing into client ,there should be difference in the data before / after the import.

Read only

jmodaal
Active Contributor
0 Likes
3,452

Did you check the import log?

There also might be some latency depending on buffer synchronization (typically up to 2 minutes max.).

However, if the import log shows that records have been imported, I would tend to believe that - the technique behind it works quite reliable since lots of years.

Read only

Sandra_Rossi
Active Contributor
3,452

When it's about a thread with multiple questions, I guess direct chat is the best solution to solve efficiently.

Read only

jmodaal
Active Contributor
0 Likes
3,452

I fully agree to sandra.rossi. Feel free to contact me via email (see my profile > About).

Read only

former_member660488
Participant
0 Likes
3,452

I've sent an email. Please check it. Thank you