Application Development 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: 

Material Master Extract with some fields in legacy shorter then SAP

former_member585060
Active Contributor
0 Kudos

Hi ,

I need to Extract Material master data and send to Material Management System(MMS), i am able to fetch the data into internal table with fields of MMS structure. My problem is SAP has 18 characters for MATNR field and MMS has only 6 characters, like wise some fields are shorter length in MMS then in SAP. How can i truncate all the values of the corresponding fields in my output internal table so that i can download the file to MMS system.

Regards

Krishna

1 ACCEPTED SOLUTION

ian_maxwell2
Active Participant
0 Kudos

There won't be any sort of one step transformation that you can do.

You will have to loop through the records in your internal table and for each record:

- Map your fields accross to a structure defined with the lenghts as you need them for the external system. Do any truncating or transformation that you require.

- Append the new record to a second internal table

You will then use this second internal table to extract and send.

~Ian

1 REPLY 1

ian_maxwell2
Active Participant
0 Kudos

There won't be any sort of one step transformation that you can do.

You will have to loop through the records in your internal table and for each record:

- Map your fields accross to a structure defined with the lenghts as you need them for the external system. Do any truncating or transformation that you require.

- Append the new record to a second internal table

You will then use this second internal table to extract and send.

~Ian