Skip to Content
0
Jan 12, 2012 at 08:28 PM

Mapping based on field positions

49 Views

Hi All,

It is a file to IDOC scenario

i am getting a file with Multiple H1 , AM records and the field positions of these records as 01,02,03 as given below.

01 02 03

H1 C

AM U 00000002

AM X 00000012

AM U 00000002

AM X 00000020

AM G 00000003

AM T 00000005

H1 S

AM U 00000002

AM X 00000030

AM U 00000002

AM X 00000040

AM G 00000005

AM T 00000006

and based on the this H1-02 record( C & S) i need to pick AM-03 values when ever AM-02 is "X".

ie., when ever the H1-02 = "C" then in target field i need to have AM-03 values as -ve whenever AM-02 = "X".

and when ever the H1-02 = "S" then in target field i need to have AM-03 values whenever AM-02 = "X".

output : IDOC fields Target C and TargetS.

1) TargetC : when H1-02 = C

-00000012

-00000020

2) TargetS : when H1-02 = S

00000030

00000040

Please provide help on this requirement.

Thanks

Sai_SHA

Edited by: sai_SHA on Jan 13, 2012 10:55 AM