Introduction:

PriyankaChak · ‎11-18-2023

Introduction:

In this blog post, I will explain how to read and understand an EDI file. EDI stands for Electronic Data Interchange. There are mainly two standards: X12 and EDIFACT. X12 is primarily used in North America, especially in the United States, whereas EDIFACT is predominantly used in Europe. This blog post will focus on X12 syntax only.

Common EDI Transactions:

EDI 850: Buyer sends Purchase Order to Supplier

EDI 855: Supplier confirms to Buyer whether the order can be fulfilled

EDI 856: Supplier provides advance notice of a shipment (ASN)

EDI 810: Supplier sends invoice to Buyer

How to read an EDI File?

Each line of the file is referred to as a segment. Each EDI file starts with ISA (Interchange Control Header) segment and ends with IEA (Interchange Control Trailer) segment.

There can be 'n' number of GS/GE segment pair. Each GS segment can have 'n' number of transaction set (SE/ST segment pair) of same type.

ISA (Interchange Control Header) Segment

ISA is fixed length positional.

ISA*00*          *00*          *ZZ*SRCA           *ZZ*DSTB           *231116*1700*U*00401*000001000*0*T*>

Element Name	Usage	Sample Value
ISA01	Authorization Info Qualifier. Fixed length - 2. Code '00' indicates that no authorization information present in ISA02	00
ISA02	Authorization Information. Fixed length - 10	Ten spaces
ISA03	Security Info Qualifier. Fixed length - 2. Code '00 'indicates that no security information present in ISA04.	00
ISA04	Security Information. Fixed length - 10	Ten spaces

ISA-01 through ISA-04 are hardly used anymore and that is why these are kept as 00 and blank now-a-days.

Element Name	Usage	Sample Value
ISA05	Interchange Sender ID Qualifier. Fixed length -2 . Used to define the ID sent in the ISA06.	ZZ
ISA06	Interchange Sender ID. Fixed length - 15	SRCA
ISA07	Interchange Receiver ID Qualifier. Fixed length - 2. Used to define the ID sent in the ISA08.	ZZ
ISA08	Interchange Receiver ID. Fixed length - 15	DSTB

The commonly used qualifiers for ISA05/ISA07 are -

01 (DUNS: Dun & Bradstreet’s master Data Universal Numbering System)

12 (Telephone number)

ZZ (Mutually Defined)

Element Name	Usage	Sample Value
ISA09	Interchange Date. Fixed length - 6. Format - YYMMDD	231116
ISA10	Interchange Time. Fixed length - 4. Format - HHMM	1700
ISA11	Code to identify the agency responsible for the control standard used by the message. Fixed length - 1. 'U' stands for 'U.S. EDI Community of ASC X12'	U
ISA12	EDI Version Number. Fixed length - 5	00401
ISA13	Control number for tracking purpose. It must match with IEA02. Fixed length - 9	000001000
ISA14	Acknowledgement Requested (TA1). Code ‘0’ indicates that no acknowledgment has been requested.	0
ISA15	Usage Indicator. Code ‘P’ indicates that the interchange envelope contains production data. 'T' indicates non-prod data	T
ISA16	Component/Sub Element Separator. The delimiter used to separate component data elements within a composite data structure; this value must be different than the data element separator and the segment terminator.	>

In the above example, * is element separator.

CRLF is segment separator.

Sub element separator

PID*F****CNT HSN10201>700

PID represents product description.

PID01 = F, which means free-form

PID05 is using component separator. It has 2 parts. 1st part is CNT HSN10201, 2nd part is 700. This is just an example for showing how to use sub element separator. Always refer to partner's EDI implementation guidelines for actual usage.

IEA (Interchange Control Trailer) Segment

IEA*1*000001000

Element Name	Value
IEA01	Count of the GS segments
IEA02	Must match with ISA13

GS (Functional Group Header) Segment

GS*PO*SRCA*DSTB*20231116*1700*1000*X*004010

Element Name	Description	Sample Value
GS01	Functional Identifier Code	PO
GS02	Application Sender's Code	SRCA
GS03	Application Receiver's Code	DSTB
GS04	Date (CCYYMMDD)	20231116
GS05	Time (HHMM)	1700
GS06	Group Control Number	1000
GS07	Responsible Agency Code	X
GS08	Version / Release / Industry Identifier	004010

GE (Functional Group Trailer) Segment

GE*1*1000

Element Name	Description	Sample Value
GE01	Number of Transaction Sets Included	1
GE02	Group Control number. Must match GS06	1000

ST (Transaction Set Header) Segment

ST*850*000000010

Element Name	Description	Sample Value
ST01	Transaction Set Identifier Code	850
ST02	Transaction Set Control Number	000000010

SE (Transaction Set Trailer) Segment

SE*20*000000010

Element Name	Description	Sample Value
SE01	Total number of segments included in a transaction set including ST and SE segments	20
SE02	Transaction Set Control Number. Must Match ST02.	000000010

Understanding Sample EDI File

The below is a sample EDI 850 file.

ISA*00*          *00*          *ZZ*SRCA           *ZZ*DSTB           *231116*1700*U*00401*000001000*0*T*>

GS*PO*SRCA*DSTB*20231116*1700*1000*X*004010

ST*850*000000010

BEG*00*SA*08292233294**20231116

REF*DP*038

ITD*14*3*2**45**46

DTM*002*20231125

PKG*F*68***PALLETIZE SHIPMENT

PKG*F*66***REGULAR

TD5*A*92*P3**SEE XYZ RETAIL ROUTING GUIDE

N1*ST*XYZ RETAIL*9*0003947268292

N3*91875 SOLON RD

N4*SOLON*OH*44139*US

PO1*1*120*EA*9.25*TE*CB*065322-117*PR*RO*VN*AB3542

PID*F****SMALL WIDGET

PO4*4*4*EA*PLT94**3*LR*15*CT

PO1*2*220*EA*13.79*TE*CB*066850-116*PR*RO*VN*RD5322

PID*F****MEDIUM WIDGET

PO4*2*2*EA

PO1*3*126*EA*10.99*TE*CB*060733-110*PR*RO*VN*XY5266

PID*F****LARGE WIDGET

PO4*6*1*EA*PLT94**3*LR*12*CT

PO1*4*76*EA*4.35*TE*CB*065308-116*PR*RO*VN*VX2332

PID*F****NANO WIDGET

PO4*4*4*EA*PLT94**6*LR*19*CT

PO1*5*72*EA*7.5*TE*CB*065374-118*PR*RO*VN*RV0524

PID*F****BLUE WIDGET

PO4*4*4*EA

PO1*6*696*EA*9.55*TE*CB*067504-118*PR*RO*VN*DX1875

PID*F****ORANGE WIDGET

PO4*6*6*EA*PLT94**3*LR*10*CT

CTT*6

AMT*1*13045.94

SE*32*000000010

GE*1*1421

IEA*1*000003438

Here,

This is an original (BEG01 -> 00) and stand-alone (BEG02 -> SA) purchase order

08292233294 is the PO number (BEG03) and PO date is 16th Nov, 2023 (BEG05)

Reference Department (REF01) is 038 (REF02)

Requested delivery date (DTM01 -> 002) is 25th Nov, 2023 (DTM02)

Ship To (N101) XYZ RETAIL (N102), Ship to Address is 91875 SOLON RD (N301), SOLON (N401), Ohio (N402), ZIP code - 44139 (N403), US (N404)

6 PO line items (CTT01 - is the accumulation of the number of PO1 segments)

Qualifier List

In the above example, I have mentioned some of the qualifiers. All the list of values are present in Code list of Integration Advisor.

BEG01: 00

BEG02: SA

REF01: DP

DTM01: 002

N101: ST

How to convert EDI to XML format?

Use 'EDI to XML Converter' and the schema should be downloaded from Integration Advisor.

You can specifically select the required segments or 'Select All'.

Use the schema from the downloaded zip file in EDI to XML Converter.

Output XML:

<?xml version="1.0" encoding="ISO-8859-1"?><ns0:Interchange xmlns:ns0="urn:sap.com:typesystem:b2b:116:asc-x12:004010">

    <S_ISA>

        <D_I01>00</D_I01>

        <D_I02>          </D_I02>

        <D_I03>00</D_I03>

        <D_I04>          </D_I04>

        <D_I05_1>ZZ</D_I05_1>

        <D_I06>SRCA           </D_I06>

        <D_I05_2>ZZ</D_I05_2>

        <D_I07>DSTB           </D_I07>

        <D_I08>231116</D_I08>

        <D_I09>1700</D_I09>

        <D_I10>U</D_I10>

        <D_I11>00401</D_I11>

        <D_I12>000001000</D_I12>

        <D_I13>0</D_I13>

        <D_I14>T</D_I14>

        <D_I15>&gt;</D_I15>

    </S_ISA>

    <FunctionalGroup>

        <S_GS>

            <D_479>PO</D_479>

            <D_142>SRCA</D_142>

            <D_124>DSTB</D_124>

            <D_373>20231116</D_373>

            <D_337>1700</D_337>

            <D_28>1000</D_28>

            <D_455>X</D_455>

            <D_480>004010</D_480>

        </S_GS>

        <M_850>

            <S_ST>

                <D_143>850</D_143>

                <D_329>000000010</D_329>

            </S_ST>

            <S_BEG>

                <D_353>00</D_353>

                <D_92>SA</D_92>

                <D_324>08292233294</D_324>

                <D_373>20231116</D_373>

            </S_BEG>

            <S_REF>

                <D_128>DP</D_128>

                <D_127>038</D_127>

            </S_REF>

            <S_ITD>

                <D_336>14</D_336>

                <D_333>3</D_333>

                <D_338>2</D_338>

                <D_351>45</D_351>

                <D_386>46</D_386>

            </S_ITD>

            <S_DTM>

                <D_374>002</D_374>

                <D_373>20231125</D_373>

            </S_DTM>

            <S_PKG>

                <D_349>F</D_349>

                <D_753>68</D_753>

                <D_352>PALLETIZE SHIPMENT</D_352>

            </S_PKG>

            <S_PKG>

                <D_349>F</D_349>

                <D_753>66</D_753>

                <D_352>REGULAR</D_352>

            </S_PKG>

            <S_TD5>

                <D_133>A</D_133>

                <D_66>92</D_66>

                <D_67>P3</D_67>

                <D_387>SEE XYZ RETAIL ROUTING GUIDE</D_387>

            </S_TD5>

            <G_N1>

                <S_N1>

                    <D_98>ST</D_98>

                    <D_93>XYZ RETAIL</D_93>

                    <D_66>9</D_66>

                    <D_67>0003947268292</D_67>

                </S_N1>

                <S_N3>

                    <D_166>91875 SOLON RD</D_166>

                </S_N3>

                <S_N4>

                    <D_19>SOLON</D_19>

                    <D_156>OH</D_156>

                    <D_116>44139</D_116>

                    <D_26>US</D_26>

                </S_N4>

            </G_N1>

            <G_PO1>

                <S_PO1>

                    <D_350>1</D_350>

                    <D_330>120</D_330>

                    <D_355>EA</D_355>

                    <D_212>9.25</D_212>

                    <D_639>TE</D_639>

                    <D_235>CB</D_235>

                    <D_234>065322-117</D_234>

                    <D_235_2>PR</D_235_2>

                    <D_234_2>RO</D_234_2>

                    <D_235_3>VN</D_235_3>

                    <D_234_3>AB3542</D_234_3>

                </S_PO1>

                <G_PID>

                    <S_PID>

                        <D_349>F</D_349>

                        <D_352>SMALL WIDGET</D_352>

                    </S_PID>

                </G_PID>

                <S_PO4>

                    <D_356>4</D_356>

                    <D_357>4</D_357>

                    <D_355>EA</D_355>

                    <D_103>PLT94</D_103>

                    <D_384>3</D_384>

                    <D_355_2>LR</D_355_2>

                    <D_385>15</D_385>

                    <D_355_3>CT</D_355_3>

                </S_PO4>

            </G_PO1>

            <G_PO1>

                <S_PO1>

                    <D_350>2</D_350>

                    <D_330>220</D_330>

                    <D_355>EA</D_355>

                    <D_212>13.79</D_212>

                    <D_639>TE</D_639>

                    <D_235>CB</D_235>

                    <D_234>066850-116</D_234>

                    <D_235_2>PR</D_235_2>

                    <D_234_2>RO</D_234_2>

                    <D_235_3>VN</D_235_3>

                    <D_234_3>RD5322</D_234_3>

                </S_PO1>

                <G_PID>

                    <S_PID>

                        <D_349>F</D_349>

                        <D_352>MEDIUM WIDGET</D_352>

                    </S_PID>

                </G_PID>

                <S_PO4>

                    <D_356>2</D_356>

                    <D_357>2</D_357>

                    <D_355>EA</D_355>

                </S_PO4>

            </G_PO1>

            <G_PO1>

                <S_PO1>

                    <D_350>3</D_350>

                    <D_330>126</D_330>

                    <D_355>EA</D_355>

                    <D_212>10.99</D_212>

                    <D_639>TE</D_639>

                    <D_235>CB</D_235>

                    <D_234>060733-110</D_234>

                    <D_235_2>PR</D_235_2>

                    <D_234_2>RO</D_234_2>

                    <D_235_3>VN</D_235_3>

                    <D_234_3>XY5266</D_234_3>

                </S_PO1>

                <G_PID>

                    <S_PID>

                        <D_349>F</D_349>

                        <D_352>LARGE WIDGET</D_352>

                    </S_PID>

                </G_PID>

                <S_PO4>

                    <D_356>6</D_356>

                    <D_357>1</D_357>

                    <D_355>EA</D_355>

                    <D_103>PLT94</D_103>

                    <D_384>3</D_384>

                    <D_355_2>LR</D_355_2>

                    <D_385>12</D_385>

                    <D_355_3>CT</D_355_3>

                </S_PO4>

            </G_PO1>

            <G_PO1>

                <S_PO1>

                    <D_350>4</D_350>

                    <D_330>76</D_330>

                    <D_355>EA</D_355>

                    <D_212>4.35</D_212>

                    <D_639>TE</D_639>

                    <D_235>CB</D_235>

                    <D_234>065308-116</D_234>

                    <D_235_2>PR</D_235_2>

                    <D_234_2>RO</D_234_2>

                    <D_235_3>VN</D_235_3>

                    <D_234_3>VX2332</D_234_3>

                </S_PO1>

                <G_PID>

                    <S_PID>

                        <D_349>F</D_349>

                        <D_352>NANO WIDGET</D_352>

                    </S_PID>

                </G_PID>

                <S_PO4>

                    <D_356>4</D_356>

                    <D_357>4</D_357>

                    <D_355>EA</D_355>

                    <D_103>PLT94</D_103>

                    <D_384>6</D_384>

                    <D_355_2>LR</D_355_2>

                    <D_385>19</D_385>

                    <D_355_3>CT</D_355_3>

                </S_PO4>

            </G_PO1>

            <G_PO1>

                <S_PO1>

                    <D_350>5</D_350>

                    <D_330>72</D_330>

                    <D_355>EA</D_355>

                    <D_212>7.5</D_212>

                    <D_639>TE</D_639>

                    <D_235>CB</D_235>

                    <D_234>065374-118</D_234>

                    <D_235_2>PR</D_235_2>

                    <D_234_2>RO</D_234_2>

                    <D_235_3>VN</D_235_3>

                    <D_234_3>RV0524</D_234_3>

                </S_PO1>

                <G_PID>

                    <S_PID>

                        <D_349>F</D_349>

                        <D_352>BLUE WIDGET</D_352>

                    </S_PID>

                </G_PID>

                <S_PO4>

                    <D_356>4</D_356>

                    <D_357>4</D_357>

                    <D_355>EA</D_355>

                </S_PO4>

            </G_PO1>

            <G_PO1>

                <S_PO1>

                    <D_350>6</D_350>

                    <D_330>696</D_330>

                    <D_355>EA</D_355>

                    <D_212>9.55</D_212>

                    <D_639>TE</D_639>

                    <D_235>CB</D_235>

                    <D_234>067504-118</D_234>

                    <D_235_2>PR</D_235_2>

                    <D_234_2>RO</D_234_2>

                    <D_235_3>VN</D_235_3>

                    <D_234_3>DX1875</D_234_3>

                </S_PO1>

                <G_PID>

                    <S_PID>

                        <D_349>F</D_349>

                        <D_352>ORANGE WIDGET</D_352>

                    </S_PID>

                </G_PID>

                <S_PO4>

                    <D_356>6</D_356>

                    <D_357>6</D_357>

                    <D_355>EA</D_355>

                    <D_103>PLT94</D_103>

                    <D_384>3</D_384>

                    <D_355_2>LR</D_355_2>

                    <D_385>10</D_385>

                    <D_355_3>CT</D_355_3>

                </S_PO4>

            </G_PO1>

            <G_CTT>

                <S_CTT>

                    <D_354>6</D_354>

                </S_CTT>

                <S_AMT>

                    <D_522>1</D_522>

                    <D_782>13045.94</D_782>

                </S_AMT>

            </G_CTT>

            <S_SE>

                <D_96>32</D_96>

                <D_329>000000010</D_329>

            </S_SE>

        </M_850>

        <S_GE>

            <D_97>1</D_97>

            <D_28>1421</D_28>

        </S_GE>

    </FunctionalGroup>

    <S_IEA>

        <D_I16>1</D_I16>

        <D_I12>000003438</D_I12>

    </S_IEA>

</ns0:Interchange>

Message Headers

The below message headers are generated by EDI to XML converter step.

Reference Links:

EDI to XML Converter

Thank you for reading this blog post. Please feel free to share your feedback or thoughts in the comments section or ask any questions in the Q&A tag below.

QA link

Regards,

Priyanka Chakraborti

SatheeshG · ‎11-18-2023

Great guide for beginner Priyanka!

nkrishna · ‎11-19-2023

Thanks a lot for your efforts in writing this blog Priyanka. I am sure this blog will create enough interest to learners to pick this skill. Expecting more blogs in this topic from you.

Thanks,

Nagendra

00022111734 · ‎11-19-2023

Thanks for insightful blog

M_Kalyabin · ‎02-25-2024

Thank you!

Several month ago I tried to find a convenient way to convert text EDIFACT to XML to prepare an example for MIG creation based on my productive examples. And I missed the idea to use the Integration Advisor functionality for this. Thank you for this hint and for the link to the relevent SAP Help page.

BR, Mikhail

M_Kalyabin · ‎02-25-2024

Thank you!

Several month ago I tried to find a convenient way to convert text EDIFACT to XML to prepare an example for MIG creation based on my productive examples. And I missed the idea to use the Integration Advisor functionality for this. Thank you for this hint and for the link to the relevent SAP Help page.

BR, Mikhail

Beginner's Guide to EDI Integration

Introduction:

Common EDI Transactions:

How to read an EDI File?

ISA (Interchange Control Header) Segment

Sub element separator

IEA (Interchange Control Trailer) Segment

GS (Functional Group Header) Segment

GE (Functional Group Trailer) Segment

ST (Transaction Set Header) Segment

SE (Transaction Set Trailer) Segment

Understanding Sample EDI File

Qualifier List

How to convert EDI to XML format?

Message Headers

Reference Links:

SAP PI for Beginners

ABAP 7.40 Quick Reference

Fiori: technical installation and configuration of one app from A - Z