Field-Mapping Workbook

Parent Previous Next

The Field-Mapping Workbook is one of the key deliverables produced by MDA Workbench.


The list of fields that appear on each worksheet of the Field-Level Mapping Workbook can be configured using Field Manager, which is available on the View Ribbon of the main toolbar.  


Using Field Manager to maintain the configuration for Field-Mapping Workbook serves two purposes:



There is only one Field Manager mapping to be maintained for both purposes.


Here are the relevant Field Manager Objects:


Worksheet

Field Manager Object(s)


MapSgements

MapFields


StagingTableSchemaProject

StagingTable

StagingTableSchemaSegment

StagingTableSchemaField

StagingTableSchemaSQL


ValidationTest



For each Field Manager Objects, for each Property there is a Behavior property.


Object Property

Comment

Behavior

  • Display Only
  • Editable
  • Hidden



Publish Field-Mapping Workbook


Option 1 - Verbose (No Longer Available as of version 1.0.0.118)


The Field-Mapping Workbook contains the following worksheets:


Worksheet

Comment

PROJECT

  • Project comments

Sap Field Map

  • Mapping document of all selected segments and fields.
  • Columns are created for properties where Behavior <> Hidden.
  • Columns are created for Field Manager Objects in this order:
    • MapSegments
    • MapFields

SCHEMA

  • One worksheet per Staging Table.
  • Columns are created for properties where Behavior <> Hidden.
  • Columns are created for Field Manager Objects in this order:
    • StagingTableSchemaProject
    • StagingTable
    • StagingTableSchemaSegment
    • StagingTableSchemaField
    • StagingTableSchemaSQL

DATA

  • One worksheet per Staging Table.




Option 2 - Consolidated


The Field-Mapping Workbook contains the following worksheets:


Worksheet

Comment

PROJECT

  • Project comments

Sap Field Map

  • Mapping document of all selected segments and fields.
  • Columns are created for properties where Behavior <> Hidden.
  • Columns are created for Field Manager Objects in this order:
    • StagingTableSchemaProject
    • StagingTable
    • MapSegments
    • MapFields
    • StagingTableSchemaSQL

DATA

  • One worksheet per Staging Table.
  • This is the Sample Data for each Staging Table.




Transfer Data from Field-Mapping Workbook