SAP IDoc FlatFile to XML converter

One of our projects is to create/change hundreds of maps and switch from SAP IDoc flat files to XML files. All of the test files are in the FlatFile format, so I decided to create a converter to translate them into XML. It’s clear that this task requires some kind of a library with the IDoc documents structures description (hierarchy, records, positions, etc). I decided to use IDoc DDFs (format used by IBM/Sterling Map Editor for creating structures – you can download them from GIS/SI or just use existing GIS/SI map) and XSLT for it, and several hours later can convert my test data from FF to XML in seconds:

Just an idea.

PS I don’t have access to SAP at the moment so I cannot use it for XML Idoc generation. Also, I have appropriate I/Os for existing IDocs so it made sense to convert these existing files.

PPS it’s clear that an XML->FF converter is easier to develop – you don’t need to care about the hierarchy.

Here is my XSLT code. It doesn’t work without appropriate DDF file so if you have no idea about XSL/DDF you won’t be able to use it. It’s for those who is experienced but lazy – just like me 🙂 Continue reading

Advertisements

Basic SAP Transaction Codes for EDI guys

Here are some basic SAP transaction codes for those who are working in the field of EDI and uses SAP ERP:

WE02 – Display IDocs
It’s a search form, you can use different filter settings to narrow down the search results:

Continue reading

SAP IDoc qualifiers (Details)

Here are some qualifiers for the details data.

E1EDL20 (INCO1)

EXW	EX WORKS
FCA	FREE CARRIER 
FAS	FREE ALONG SHIP 
FOB	FREE ON BOARD 
CFR	COST AND FREIGHT 
CIF	COST, INSURANCE AND FREIGHT 
CPT	CARRIAGE PAID TO 
CIP	CARRIAGE AND INSURANCE PAID TO 
DAF	DELIVERED AT FRONTIER 
DES	DELIVERED EX SHIP 
DEQ	DELIVERED EX QUAY 
DDU	DELIVERED DUTY UNPAID 
DDP	DELIVERED DUTY PAID

Continue reading