Skip to Content
-6

Question regarding data conversion program

May 12, 2017 at 03:59 AM

85

avatar image
Former Member

Hi ,

I am in the middle of developing a data extract program where i need to write data from ECC to a predefined excel sheet and this excel sheet has around 400 columns, none of the columns have SAP Fields as name heading.

What is the best way? any pointers

10 |10000 characters needed characters left characters exceeded

What is a specific challenge?

0
Former Member
Jelena Perfiljeva

Hi Jelena,

Sorry for late reply challenge is field mapping as there are more than 400 columns, don't want to use case statement for every columns..

0

Why would you use case statement? Sorry, obviously I'm not the only one having trouble understanding what the actual problem is. If there is a serious and specific question then provide more details.

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member May 12, 2017 at 09:19 AM
0

Not sure what is the exact requirement. more info may help to give more inputs.

If the data is simple extract from one or multiple transparent tables, also a one time activity, I suggest you to go through SE16 table extract.

If the data is simple extract from one or multiple transparent tables, NOT a one time activity, I suggest you to deploy this by a query.

For complex calculations, if you have the access to SAP BODS, you can extract, and transform the data and dump the transformed in the format as required.

if you have a requirement to extract data with complex logic within SAP viz., BOM, Routing / Inspection Plan etc., then one may choose to go with the ABAP development.

Share
10 |10000 characters needed characters left characters exceeded