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

CSV Upload into DB Table - Problem with mandt or key

Former Member
0 Likes
686

Hi everybody,

I am uploading a csv. For this I defined a structure in the dictionary.

As I also need a DB-Table for the insert I created a table with

  • a ONE field = mandt
  • an .include --> wich refers to my structure

The problem is know, that the only key-field is teh field MANDT

I tried to set some other key-fields

The other fields are in the include-structure. But it is not possible to set key fields in a structure.

How can I solve this ?

Thanks

Regards

Mario

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
631

Solved; I have to create tweo structures

  1. one for the key fields
  2. another for the rest

Hi everybody,

I am uploading a csv. For this I defined a structure in the dictionary.

As I also need a DB-Table for the insert I created a table with

  • a ONE field = mandt
  • an .include --> wich refers to my structure

The problem is know, that the only key-field is teh field MANDT

I tried to set some other key-fields

The other fields are in the include-structure. But it is not possible to set key fields in a structure.

How can I solve this ?

Thanks

Regards

Mario

2 REPLIES 2
Read only

Former Member
0 Likes
632

Solved; I have to create tweo structures

  1. one for the key fields
  2. another for the rest
Read only

rosenberg_eitan
Active Contributor
0 Likes
631

Hi,

You work to hard .

See here http://wiki.scn.sap.com/wiki/display/Snippets/upload+csv+files+into+internal+table

As you can see the upload is into buffer (ITAB) and then looping and splitting.

Regards .