08-02-2008 3:17 PM
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
08-02-2008 10:07 PM
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
08-02-2008 10:07 PM
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