[EDI-L Mailing List Archive Home] [Message List] [Reply To This Message]

Help needed in Harbinger mapping

From: "Cox, Ken" <jkcedi@...>
Date: Thu Sep 18, 2003  2:52 pm
Subject: [EDI-L] Help needed in Harbinger mapping
I think this looks o.k. The EDI document is in the order the X12
standard indicates, and the SAP Idoc (based on the EDIFACT standard) is
in the order SAP requires; if you change up your output, SAP will not
like it.

Ken Cox
Brach's

Hi All,

I would like to know the steps of how to carry out the following
issue which I am facing while creating an Inbound Map for
transaction 850 version ANSI X12 - 4010.

I have the following inbound EDI

ST*850*2442
BEG*00*SA*2800163136**20021209
ITD*01*5***45
N9*KD*SPECIAL INSTRUCTIONS
MSG*PLEASE REFER TO OUR IBM PROCUREMENT WEBSITE FOR THE MOST
MSG*RECENT STANDARD PURCHASE ORDER TERMS AND CONDITIONS:
N1*BT*IBM CORPORATION
N2*NATIONAL ACCOUNTS PAYABLE SERVICE
N3*P.O. BOX 8097
N4*ENDICOTT*NY*13761
N1*BY*IBM
N2*2455 SOUTH ROAD
N4*POUGHKEEPSIE*NY*12601
PER*BD*Kathy Surico*TE*845-433-4120
N1*ST*Poughkeepsie Plant*92*992
N2*Building 006
N3*2455 South Road
N4*Poughkeepsie*NY*12601*US
PO1*00001*4*EA*0.01*PE*BP*00044P1539*EC*10000J11428*PD*IC MODULE
Sakura RBJ3
SCH*4*EA***002*20030228
CTT*1
SE*52*2442


Now the MSG segment in N9 segment which is in a loop and occurs
before N1 loop as per the EDI standards.

Now let us have a look at the translated document.

EDI_DC40 0401234567890123456 ORDERS012HL1_PROD
KUHL1_040 X4010 850
SAPHL1
KUIBMP
20020604103447ORDERSORDERS01 AG
E1EDK01 0401234567890123456000001E1EDK01 000000 0
000
ORDE2800151068

E1EDKA1 0401234567890123456000002E1EDKA1 000000 0
AG
IBMP

E1EDKA1 0401234567890123456000003E1EDKA1 000000 0
WE
992

E1EDKA1 0401234567890123456000004E1EDKA1 000000 0 LF
HALS&IC
HALS&IC

E1EDK02 0401234567890123456000005E1EDK02 000000 0
0012800151068
20020603

E1EDKT1 0401234567890123456000006E1EDKT1 000000 0
E

E1EDKT2 0401234567890123456000007E1EDKT2 000006 0 SPECIAL
INSTRUCTIONS


E1EDKT1 0401234567890123456000008E1EDKT1 000000 0
E

E1EDKT2 0401234567890123456000009E1EDKT2 000008 0 PLEASE REFER
TO OUR IBM PROCUREMENT WEBSITE FOR THE
MOST

E1EDKT2 0401234567890123456000010E1EDKT2 000008 0 RECENT
STANDARD PURCHASE ORDER TERMS AND
CONDITIONS:

E1EDP01 0401234567890123456000041E1EDP01 000000 0 00001 0
3
PCE .01

USD

E1EDP02 0401234567890123456000042E1EDP02 000041 0
0012800151068
20020603

E1EDP03 0401234567890123456000043E1EDP03 000041 0
00220020731

E1EDP19 0401234567890123456000044E1EDP19 000041 0
00100009P4542

E1EDS01 0401234567890123456000045E1EDS01 000000 0
0011

Here

1) The data from the MSG segment is written after the data from the
N1 segment has been written in the translated document.

N1 data is put after translation in line with key E1EDKA1.

Please do remember that MSG and N1 , both can occur in a loop.

This map is being created in Harbinger and I am not able to find out
a way

1) How to store the data from the MSG segment ( i.e. occurring
several times ) and write the stored data after the data from N1 loop
has been written.

2) The loop occurrence of MSG can be more than 100 , which moves away
the create table , look up table commands being taken into
consideration.

Please remember that the records have to be written one after another.

Please give any insights into this as how it can be handled in
Harbinger.

Thanks
PKM


[Non-text portions of this message have been removed]




 
EDI to XML Mapping for EDIFACT/X12 Convert EDIFACT/X12 Schemas to XML Schema Legacy Data Conversion Tools Access Relational Data as XML Visual XSLT and XQuery Mapping Tools Simplify EDI Data Integration with Stylus Studio XML Enterprise Suite - Free Download!
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2007 All Rights Reserved.