topic Re: field mapping in Application Development and Automation Discussions

field mapping

Former Member — Tue, 16 Oct 2007 11:00:16 GMT

Hai,

what is meant by field mapping of the legacy data and how do we proceed in uploading the flat file through bdc.

Re: field mapping

Former Member — Tue, 16 Oct 2007 11:06:49 GMT

u need to build a internal table as per the the arrangements of columns in legacy file ........consider each and every field and its field length matching with database fields or not then use gui upload to place all the fields in the internal table this is how u have to do field mapping from flatfile to sap................

through bdc we use to post the data in flat file to database..........

reward points if helpful

Re: field mapping

Former Member — Tue, 16 Oct 2007 11:21:33 GMT

Maintain source fields

In the step ‘Maintain Source Fields’, fields are created and maintained for the source structure defined in the preceding step

Use source fieldnames with the same names as the target fieldnames as much as possible, because it allows you to use the ‘auto-field mapping’ function in step 5 ‘Maintain field mapping and conversion rules’.

Different possible ways of defining and maintaining the source fields:

Make sure that you are in change mode and the cursor is positioned on a source structure or an existing source field

Create Individual source fields - By clicking on the button ‘Create source field’ you can specify the field name, field label, field length and field type

During data read, you can specify whether date values are converted into the internal date format (YYYYMMDD) and amount fields are converted into the calculation format (1234.56)

‘Selection Parameter’ can be set during Read/Convert data. If you select this indicator, the corresponding field is made available as selection parameter when reading or converting data.

2. Maintain Source Fields in Table Form – Clicking on the ‘Table Maintenance’ button displays the fields in a tabular format.

Reward if usefull

Re: field mapping

Former Member — Tue, 16 Oct 2007 12:19:44 GMT

by field maaping we simply means which data is required or send by legacy and how this be utilized and used by SAP

reagrds