File to File using BPM & value mapping

[former_member200267]

Hi,

I have the following scenario to do. sample file structure is given below.

source:

HDR 13052008INDIA

BDY 123456

BDY 1234567

EOF

Target:

HDR 2IN BDY 123456 EOF

HDR 2IN BDY 1234567 EOF

for the above mentioned source and target mapping. we have to use BPM and value mapping.

In the HDR row 13052008 is the date value this has to be passed to RFC function module and it will return 2, this value has to be mapped to target

And INDIA has to be mapped to IN using the value mapping option. similarly we have many coutry code.

could anyone let me know the step by step procedure to achieve this, I followed the blog https://weblogs.sdn.sap.com/pub/wlg/1926. [original link is broken] [original link is broken] [original link is broken] but it does not fit to my scenario.

help is appreciated.

Regards

RDS

[Former Member · Accepted solution]

Hey,

This is a normal file to file scenario.

You need to use RFC look up instead of value mapping.(as you need to extract 2 and IN from an RFC)

There is no need for a BPM.

refer to this blog(for RFC look up)

/people/sravya.talanki2/blog/2005/12/21/use-this-crazy-piece-for-any-rfc-mapping-lookups

this will solve your problem.

Output of RFC look up will be 2 and IN . So use the concat function.

Other values map them directly from source to target.

Also, set the occurence for the target structure as 0 to unbounded in the mapping.(this is to be done in order to have one file for each record of the source)

You also need to configure file content conversion.(both at sender and reciever side) to convert the text file to XML on the sender side and then XML to text at the reciever side.

refer to this link for FCC.

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

This is for sender file content conversion.

http://help.sap.com/saphelp_nw04/helpdata/en/44/79973cc73af456e10000000a114084/frameset.htm

This is for reciever FCC.

http://help.sap.com/saphelp_nw04/helpdata/en/44/79973cc73af456e10000000a114084/frameset.htm

reward points if useful.

regards,

Milan

[Former Member]

Hi,

File to file using BPM.

/people/krishna.moorthyp/blog/2005/06/09/walkthrough-with-bpm

and also this blog

/people/community.user/blog/2007/01/08/valuemapping-using-the-graphical-mapping-tool

Please reward points if it helps

Thanks

Vikranth

[Former Member]

Refer these

File-to-File Using BPM

/people/krishna.moorthyp/blog/2005/06/09/walkthrough-with-bpm

You can use RFC lookups for calling RFC's

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a03e7b02-eea4-2910-089f-8214c6d1...

Value Mapping for country codes

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/00ee347e-aabb-2a10-b298-d15a1ebf...

Edited by: Anand Torgal on Jun 5, 2008 10:11 AM

[Former Member]

Hey,

source target

header----

---

>header

13052008--vwrite a lookup>2

and INDIA->valuemapping created->IN

concatenate des two and map to tgt.

And then the body mapping.

and one more suggestion.

If there are only few countries and the values you already know..You can go with fixed valuemapping too.

follow the blog.

/people/community.user/blog/2007/01/08/valuemapping-using-the-graphical-mapping-tool

check this for some more info..

/people/sukumar.natarajan/blog/2006/10/23/accessing-value-mapping-defined-in-directory-using-java-functions

Thanks,

Vijaya.

Edited by: Vijaya Lakshmi Palla on Jun 5, 2008 10:14 AM

Edited by: Vijaya Lakshmi Palla on Jun 5, 2008 10:21 AM