To define customer defined fields for mapping
You can use customer defined fields for ledger mapping, dimension mapping, and reconciliation.
Customer defined fields defined for mapping are used to create the business object attributes of the mapping elements for an integration mapping scheme.
Customer defined fields of data type string or enumerated that are defined for these business objects and related tables are available for mapping:
If a customer defined field is used in the mapping scheme for the purchase order or general costs (for purchase order and purchase requisition), the customer defined fields must have the same label code for purchase orders and purchase requisitions.
| Business object | Tables |
|---|---|
| Tdsls040 (Sales Order) | Tdsls400, tdsls401 |
| Bpmdm010 (Employee) | Tccom001 |
| Tdpur040 (Purchase Order) | Tdpur400, tdpur401 |
| Whwmd200 (Warehouse) | Tcmcs003 |
| Tssoc200 (Service Order) | Tssoc200, tssoc210, tssoc220, tssoc240, tssoc240 |
| Tsmsc100 (Maintenance Sales Order) | Tsmsc100, tsmsc110, tsmsc120 |
| Tswcs200 (Maintenance Work Order) | Tswcs200, tswcs210, tswcs410, tswcs420, tswcs430, tswcs450, tswcs451 |
| Tdpur020 (Purchase Requisition) | Tdpur200, Tdpur201 |
For example, a customer defined field titled Profit Center is added to the tcmcs003 table, which is part of the Warehousing master data. This customer defined field is used as an element for dimension mapping of integration document types related to warehouse movements.
To define mapping elements based on customer defined fields, complete these steps:
- Activate customer defined fields in the Customer Defined Fields Parameters (ttadv4590m000) session.
- Define customer defined fields in the Customer Defined Fields (ttadv4591m000) session.
- In the Customer Defined Fields for Mapping (tcfin0190m000) session, complete these steps:
- In the Business Object Name field, select the appropriate business object.
- In the Table field, select the appropriate table from the available tables of the selected business object.
- In the Table field field, select the appropriate customer defined field from the available customer defined fields defined for the selected table.
- In the Code and Reconciliation Element Start Code fields, select the element code and the reconciliation start code, respectively.
- Run the Initialize Mapping Scheme Data (tcfin0210m000) session.
- Run the Check and Correct Customer Defined Fields for Mapping (tcfin0290m000) session.
Check and correct customer defined fields
The Check and Correct Customer Defined Fields for Mapping (tcfin0290m000) session is used to ensure that the properties of the customer defined fields defined in the Customer Defined Fields for Mapping (tcfin0190m000) session still match those of the Customer Defined Fields (ttadv4591m000) session.
This is because changes made to customer defined fields in the Customer Defined Fields (ttadv4591m000) session are not updated to the Customer Defined Fields for Mapping (tcfin0190m000) session.
Therefore, if a customer defined field is changed or deleted in the Customer Defined Fields (ttadv4591m000) session, you must also change or delete the customer defined field in the Customer Defined Fields for Mapping (tcfin0190m000) session.
In the Check and Correct Customer Defined Fields for Mapping (tcfin0290m000) session, the records in the Customer Defined Fields (ttadv4591m000) session are compared with those of the Customer Defined Fields for Mapping (tcfin0190m000) session.
If discrepancies occur, in the Customer Defined Fields for Mapping (tcfin0190m000) session, the records are set to expired and a reason is provided, or the records are automatically updated. This depends on the type of discrepancy. See the online help of the Check and Correct Customer Defined Fields for Mapping (tcfin0290m000) session for details.