topic Re: Insert internal table into datbase table in Application Development and Automation Discussions

Insert internal table into datbase table

former_member744657 — Wed, 07 Apr 2021 14:38:42 GMT

Hi, i've got some problem,,, and would be grate if someone help me pls.

------------------------------------------------------------

DATA : GT_BKPF TYPE TABLE OF BKPF,

GS_BKPF TYPE BKPF.

GS_BKPF-BUKRS = 'MG00'.
GS_BKPF-BELNR = '1000000000'.
GS_BKPF-GJAHR = '2019'.
APPEND GS_BKPF TO GT_BKPF.

GS_BKPF-BUKRS = 'MG00'.
GS_BKPF-BELNR = '1000000001'.
GS_BKPF-GJAHR = '2020'.
APPEND GS_BKPF TO GT_BKPF.

GS_BKPF-BUKRS = 'MG00'.
GS_BKPF-BELNR = '1000000002'.
GS_BKPF-GJAHR = '2021'.
APPEND GS_BKPF TO GT_BKPF.

GS_BKPF-BUKRS = 'MG00'.
GS_BKPF-BELNR = '1000000003'.
GS_BKPF-GJAHR = '2021'.
APPEND GS_BKPF TO GT_BKPF.

INSERT BKPF FROM TABLE GT_BKPF.

-------------------------------------------------------

no problem to activate... but

this kind of problem happens. how can I Insert internal table into datbase table using Insert or Modify ?

Thank you very much to read this ��

Re: Insert internal table into datbase table

former_member34 — Wed, 07 Apr 2021 14:38:52 GMT

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with our Q&A Tutorial: https://developers.sap.com/tutorials/community-qa.html, as it provides tips for preparing questions that draw responses from our members. Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://www.youtube.com/watch?v=46bt1juWUUM

Many thanks!

Re: Insert internal table into datbase table

former_member736527 — Wed, 07 Apr 2021 14:45:36 GMT

Looks like your BKPF table already has records that have the same key (BUKRS, BELNR, GJAHR) as the ones you're trying to insert.

Re: Insert internal table into datbase table

MateuszAdamus — Wed, 07 Apr 2021 14:51:16 GMT

Hello chw0222

You should never update standard SAP tables directly. There is always a function for this purpose. In your case it's BAPI called BAPI_ACC_DOCUMENT_POST.

Kind regards,
Mateusz

Re: Insert internal table into datbase table

touzik_itc — Wed, 07 Apr 2021 19:39:33 GMT

Violation of primary key or some unique index.

Re: Insert internal table into datbase table

former_member744657 — Thu, 08 Apr 2021 14:45:06 GMT

thank you, i got it. I deleted it again! thanks

Re: Insert internal table into datbase table

former_member744657 — Thu, 08 Apr 2021 14:45:09 GMT

thank you! but it works when i use MODIFY T.T

Re: Insert internal table into datbase table

former_member736527 — Thu, 08 Apr 2021 17:14:56 GMT

That's because modify modifies existing entries. It does not create new entries. Insert on the other hand creates new entries with those primary keys, hence the dump.