POS-R/3 Integration

[swatantra_vijay3]

Hi Guys

We are doing POS-R/3 Integration through XI , POS server generates a flat file for sales as attached, this flat file is to be posted as idoc msg type WPUUMS, which creates billing doc

Do we require any Java modules to conversion

Regards

Swatantra

0101:001:060715:040217:7730:004:S:101:0009:   6281104114822+00010010*000001350
0101:001:060715:040228:7730:005:S:101:0001:   3017760015004+00010010*000000695
0101:001:060715:040232:7730:006:S:101:0005:    208092000001+00010010*000000395
0101:001:060715:040233:7730:007:S:101:0001:   6281006471481+00010010*000000195
0101:001:060715:040235:7730:008:S:101:0009:    055773319019+00010010*000001075
0101:001:060715:040236:7730:009:S:101:0001:   9556331910958+00010010*000000140
0101:001:060715:040237:7730:010:S:101:0009:    055773319026+00010010*000001075
0101:001:060715:040239:7730:011:S:101:0001:   8008920654329+00010010*000001095
0101:001:060715:040240:7730:012:S:101:0001:   9310006411221+00010010*000000375
0101:001:060715:040241:7730:013:S:101:0001:   7612500001215+00010010*000000450

[bhavesh_kantilal]

Hi,

Like mentioned by moothry , the choice between suing an Adapter Module to do the content conversion and the File Adapter's content conversion depends on the File Strucutre.

If it is possible to do the content conversion on the File Adapter itself, then use the File Adapter's Content Conversion itself.

More ,

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm">Converting Content in A Sender File Adapter</a>

<a href="/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file Conversion (Pattern/Random content in input file)</a>

<a href="/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns Content Conversion for Unequal Number of Columns</a>

<a href="/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter to send a flat file with fixed lengths to XI 3.0 using a Central File Adapter</a>

Regards,

Bhavesh

[Former Member]

Hi,

From what I can see from the file you have pasted it's just one kind of record structure with colon seperated data.

Please check on this weblog:

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

Regards

Vijaya

[moorthy]

Hi,

<i>Do we require any Java modules to conversion</i>

>>>It depends on the requirement

Is your flat file contain : as a delimiter ? Or something else ?

If you have only one delimiter say :, then you can do the file content conversion and go ahead with normal mapping.

One more option is pick the fila full recordwise and then in the mapping, split into Specific fields and then map it with Idoc structure. Or this splitting you can do in the adapter module.

Btw are do you have plans file validations ? If so it is better to do in the Adapter Modules.

/people/sravya.talanki2/blog/2005/08/16/configuring-generic-sender-file-cc-adapter

Regd. Adapter Modules-

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3bdc14e1-0901-0010-b5a9-a01...

Now you can think of which one is required.

REgards,

moorthy

[swatantra_vijay3]

Hi Moorthy , thx for the answer

Yes : is the delimeter . Now for the mapping i have to convert this file into three level idoc structure (WPUUMS)and do some compuation also , can i do the abap mapping or do i require XSLT for that ..

Regards

Swatantra

[bhavesh_kantilal]

Hi Swatantra,

GO for ABAP / XSLT mapping only when your mapping cannot be done using Graphical Mapping.

Can you let us know your mapping requirements beforethe option for which mapping to be choosen can be decided.

Regards,

Bhavesh

[swatantra_vijay3]

Thanks Bhavesh for the reply

Actually the source file is flat file which contains all the sales data for the day recored by record as attached . i have to do some compuations like summation and convert into three level IDOC format as below

MSG type- WPUUMS

Segment- -E1WPU01

-E1WPU02

-E1WPU03

Regards

Swatantra

[bhavesh_kantilal]

Swatantra,

These are the steps you should follow,

1. Convert the Flat File into an XML using Content Conversion on the Sender File Adapter. This will convert your Flat file into a XML strcutre.

2. The Source XML of step 1 can now be used in Graphical Mapping to do all the manipluation you wnat to map it to the target Strcutre.

If you are not convinced that you want to do Content COnversion in the File adapter using the FIle adapter Content COnversion , then you can use a Adapter Module to read the File Content ( Flat File ) into an XMl strcuture.

If you do not want to do either of the two, then I guess you can do the mapping as JAVA / ABAP which will take the Flat file as its Inputstream and then do the mapping to form the XML output of the IDOC strucutre. the choice rests with you.

But using File adapters or Adapter Module for Content conversion and then doing Simple graphical mapping is the best way to do it.

Regards,

Bhavesh

[swatantra_vijay3]

Thanks Bhavesh

I'm little bit skeptical about the graphical mapping as i need to do to lot of manipulations to convert the source file to the target idoc structure , Is there any limitations of abap mapping that it can not convert into more than two level of target structure

Regards

Swatantra

[bhavesh_kantilal]

Swatantra,

<i>Is there any limitations of abap mapping that it can not convert into more than two level of target structure</i>

None that I am aware of. From personal experience, I think there isnt much which cannot be achieved using graphical mapping. But, you can always go for ABAP if that is what you want.

Just a note : XSLT mapping has a serious perfromance bottleneck and so, if the choice is bettween XSLT and ABAP, then ABAP mapping is the better option.

Regards,

Bhavesh