topic Extracting material from a string in Application Development and Automation Discussions

Extracting material from a string

former_member447950 — Wed, 18 Nov 2015 16:15:58 GMT

Hello everyone,

I am selecting from workflow table (swwwihead). In the field wi_text, there is a detailed description of the workflow message.

Examples:

317837-0010: US10: Ready for Dchain 03

17627 : IN10 : System Error - DChain 10 Not Set

358094-045 : AU10 : System Error - DChain 10 Not Set

If you notice, we have material numbers of all different lengths. Does anyone know if SAP has any standard functionality (FM or BAPI or built in function) to pass a string and extract the material number in that string? Or know of a workflow table other than swwwihead that may have this information?

I am currently parsing the string first assuming it is a 10 digit material.

I then am using the BAPI BAPI_MATERIAL_EXISTENCECHECK to see if the material exists in our system

If it doesn't I parse the string down 1 character and run the BAPI again, etc.

This is obviously not an ideal solution so was wondering if anyone had any better ideas.

I have searched around but haven't had any luck.

Thank you!

Re: Extracting material from a string

VenkatRamesh_V — Wed, 18 Nov 2015 16:39:43 GMT

Hi Jess,

Try.

If the material value will be stored as first in the entries then you fix the size to be 14 (mara-matnr length), separate the special symbols(:) using split or

use.

TABLES: mara.

DATA: lv_text TYPE string VALUE '317837-0010: US10: Ready for Dchain 03',

itab TYPE TABLE OF string,

wa LIKE LINE OF itab.

SPLIT lv_text AT ':' INTO TABLE itab.

loop at itab INTO wa.

CONDENSE wa NO-GAPS.

SELECT SINGLE matnr FROM mara INTO mara-matnr WHERE matnr = wa.

IF sy-subrc IS INITIAL.

MESSAGE 'Material Exit' TYPE 'S'.

EXIT.

ENDIF.

ENDLOOP.

Hope it helpful,

Regards,

Venkat.

Re: Extracting material from a string

former_member447950 — Wed, 18 Nov 2015 17:04:28 GMT

Thank you, this worked great!