Skip to Content
0
Aug 13, 2013 at 09:53 PM

Request for help at End Routine Logic at Master Data transformation

19 Views

Hi Friends,

I need to write an End routine at the transformations of Master data 0FUNCT_LOC

Scenario : I need have indicator weather a particular Functional Location is Main Equipment or not. I have created ZSTATUS attribute for 0FUNCT_LOC and need to mark ‘X’ or A, If following pattern functional locations come at the package

T0*-DSSE-301 X Main T0*-ESPS-873 X Main T0*-HOIS-312 X Main T0*-AIRS A Average T0*-DPFA-384 A Average T0*-DPFA-505 A Average T0*-ESPS-865 A Average

Below is example of 1st pattern Functional Location that come from ECC which I need to Mark as ‘X’

T0016-DSSE-301

T0019-DSSE-301

T0025-DSSE-301

T0034-DSSE-301

I have written below logic at End Routine of transformation

Could please correct below syntax, ( I gone through SDN and foynd syntax for Pattern is CP, Hence I have written)

LOOP AT RESULT_PACKAGE assigning <RESULT_FIELDS>
WHERE FUNCT_LOC CP 'T0*-DSSE-301',
'T0*-ESPS-873',
'T0*-HOIS-312'.
<RESULT_FIELDS>/BIC/ZSTATUS ='X'.

WHERE FUNCT_LOC CP 'T0*-AIRS',

'T0*-DPFA-505',

'T0*-ESPS-865'.

<RESULT_FIELDS>/BIC/ZSTATUS ='A'.


ENDLOOP.

Thanks

Sree