Mapping Sheet

[Former Member]

Hi Experts,

Good Afternoon. COuld you please help me out how to extract the fields from mapping sheets. if possible can any one send me the mapping sheet.

[Former Member · Accepted solution]

Hi,

Here I have uploaded a sample mapping sheet. Check out the following link

Download Link : http://www.freefileserver.com/download/QFTn3exZEVer.

Kindly reward points, if you find it useful.

Regards,

karthik.

[Former Member · Accepted solution]

Hi Karthik,

I am very thankful for your mapping sheet, and helpful solved problem.

If you dont mine could you please help me out in the node functions. I knew the defenitions of them. but in the realtime i am unable to predict where in which conditions should be used.

and also please give the realtime structures of them, please dont send me the blocks, i am unable to undestand, but i hope you can solve this problem also.

give me the datatype strcutures in clear pic so that i can understand.

dont mine i am giving too trouble to you.

[justin_santhanam · Accepted solution]

Amruth,

Refer all the examples here -http://www.flickr.com/photos/8764045@N06

raj.

[Former Member]

hi,

Usually mapping sheet looks like this

Source Field Name Mapping Type Mapping/Transformation Rule Target Field Name

N/A Message Constant = FIDCC2 MESTYP

Document_date Message Convert YYMMDD to YYYYMMDD BKPF-BLDAT

Posting_date Message Convert YYMMDD to YYYYMMDD BKPF-BUDAT

N/A Message Constant = ZJ BKPF-BLART Reference_number Message Direct Map BKPF-XBLNR

The mapping sheet gives you a clear picture as which source field has to be mapped to which target field and what is the ampping rule to be followed.suppose that anon of these details are not clear then we need to get it clarified from the client.

please reward with most helpful points if found useful.

regards

madhu

[Former Member]

Hi,

Can you please provide us the detailed req. for it?

Exactly for what you are looking for? Mapping sheet? Extraction of fields?

[Former Member]

Yeah thanks farooq,

As i was new to this XI environment, i dont know how the mapping sheet will be and how the fields reflect in that mapping sheet,

is there any specific way to find out the fields in mapping sheet or is what are the fields can mapping sheet posses.

could you please help me out by taking some risk.