How to convert EDI to XML in SAP CPI?

[dineshhome1361_7]

Hello Team,

I have an EDI file which is ANSI X12 invoice

File taken from below website:

https://www.astera.com/type/edi-transaction-set/edi-810-invoice/

Now I want to convert this EDI file into XML in CPI, Let me know what are the ways of doing this.

I have used standard palette, EDI to XML converter. Problem now here is this is asking for XSD schema to convert the data.

Now, please help me understand how do I get a XSD schema for any EDI scenario(In this case, ANSI X12 invoice).

Please suggest a solution with respect to CPI

Thanks,

Dinesh

[RobertJancich]

Hello, I think you are searching for this

https://help.sap.com/viewer/368c481cd6954bdfa5d0435479fd4eaf/Cloud/en-US/6a3d12b4075a424080aee47d256...

it's EDI to XML converter, there is also X12 example (but order, not invoice).

Tricky thing is that for making all happen, you need those schemas (XSD). The schema is telling what is wished target structure of XML, so if you can find some or write down exactly the XML file manually, how you want it to look like after conversion, than you can use even some free tools like

https://www.liquid-technologies.com/online-xml-to-xsd-converter

to create XSD out of the example... for first case you need to do the job manually, but for any other invoice it will just follow the XSD

[dineshhome1361_7]

Hi Robert,

Everyone knows if we have XML it is easier to get XSD using online converters as you highlighted

I have clearly mentioned to suggest ways of getting XSD for any EDI schema as cpi converter palette requires the schema for converting data

Since EDI is coming in plain text format, it is difficult to write schema manually for EDI data as we need to spend hours to understand the layout itself to get proper schema out of it and this is really a bad idea as each time we get different structure 997as well (say for X12, it is 810 for invoice and 850 for orders)

I hope since these structures are standard & we don't have to write schemas manually like u suggested and all the standard schemas should be present somewhere (Like PO we have B2B ADD-ON)

If you see the SAP Link as well, they have mentioned "The file name of the xml schema for ASC-X12 should have the following format: ASC-X12_810_004010.xsd"

I'm expecting does SAP have this schema stored somewhere for CPI developers where we can access it and put it back to CPI Iflow!!? Please let me know

Thanks,

Dinesh