Skip to content

Setting up a XSD Data Mapping

In XSD by Simova we have the possibility to reproduce the XML structure for the formats XInvoice and ZUGFeRD with individual nodes. In these nodes we define from which tables the values should come. Data Value and Data Mapping are be the two options to get the values from the tables.

The following steps need to be completed to create a new data mapping for XSD by Simova.

The way to the XML schemas

  1. Navigate to the search field.
  2. Enter XSD schemas.
  3. The XSD schema list opens.
  4. Select a XSD Schema.
  5. Navigate to the lines.
  6. Select the line, where you want to create a new Data value.
  7. Navigate to the Value column.
  8. Click on the Assist button.
  9. Click on New.
  10. The Data Value Card opens.
  11. Now follow the next steps.

General register

  1. Enter the Code for the data value.
  2. Enter the Description for the data value.
  3. Select the Table for the data value.

Info

  • Code = A short and unique description of the Data Value.
  • Description = A definition of what value has been set up in this node.
  • Table = The table from which the value comes.

Definition register

  1. Enter the Type "Data Mapping".
  2. Navigate to the Value field.
  3. Click on the Assist button.
  4. Click on New.
  5. The Data Mapping Card opens.
  6. Enter the same Code as on the Data Value Card.
  7. Enter the same Description as on the Data Value Card.
  8. Enter the same Source Table as on the Data Value Card:
  9. Navigate to the lines.
  10. Navigate to the Type column.
  11. Select the type Field.
  12. Navigate to the Destination Table column.
  13. Enter the Destination Table.
  14. Navigate to the Destination Field column.
  15. Enter the Destination Field to make an unique match on the Source Table.
  16. Navigate to the Source Table column.
  17. Enter the Source Table (For example: Vendor or Business partner).
  18. Navigate to the Source field column.
  19. Enter the Source Field to make an unique match on the Destination Table.
  20. Switch to the next line.
  21. Navigate to the Source Table column.
  22. Enter the Source Table (The same as the line before).
  23. Navigate to the Type column.
  24. Select the type ReturnField.
  25. Navigate to Source Table column.
  26. Enter the Source Table (The same as the line before).
  27. Enter the Source Field with the value you want to return.

Data mapping test

After you create a data mapping, you can test the data mapping before using it.

  1. Navigate to the menu bar in the Data mapping card.
  2. Click on Check Data mapping.
  3. Select a document from the list.
  4. Confirm with OK.

Example: Node BuyerTradeParty - Name

  1. Select and open the XSD schema.
  2. Navigate to the Schema Data area.
  3. Open CrossIndustryInvoice.
  4. Open SupplyChainTradeTransaction.
  5. Open ApplicabeHeaderTradeAgreement.
  6. Open BuyerTradeParty.
  7. Navigate to the line Name.
  8. Click in the colum Value on the three dots.
  9. Click on New in the menu bar.
  10. Navigate to the General register.
  11. Define a P-S-I-HEADER_BILLTO_NAME for the new Data Value.
  12. Define a Posted Sales Invoice Header for Bill-to Name for the new Data Value.
  13. Define the Sales Invoice Header - 112 for the new Data Value.
  14. Navigate to the Definition register.
  15. Select the Type: DataMapping.
  16. Navigate to Value field.
  17. Click on the Three dots action.
  18. Click on New.
  19. The Data Mapping Card opens.
  20. Enter the same Code as on the Data Value Card.
  21. Enter the same Description as on the Data Value Card.
  22. Enter the same Source Table as on the Data Value Card:
  23. Navigate to the lines.
  24. Navigate to the Type column.
  25. Select the type Field.
  26. Navigate to the Destination Table column.
  27. Enter the Source Table with "Sales Invoice Header - 112".
  28. Navigate to the Destination Field column.
  29. Enter the Source Field with "No." to make an unique match on the Source Table.
  30. Navigate to the Source Table column.
  31. Enter the Source Table with "Sales Invoice Header - 112".
  32. Navigate to the Source Field column.
  33. Enter the No. to make an unique match on the Destination Table.
  34. Switch to the next line.
  35. Navigate to the Source Table column.
  36. Enter the Sales Invoice Header (The same as the line before).
  37. Enter the Source Field with "Bill-to Name".
  38. Navigate to the Type column.
  39. Select the type ReturnField.
  40. Save and close.

Data mapping test

After you create a data mapping, you can test the data mapping before using it.

  1. Navigate to the menu bar in the Data mapping card.
  2. Click on Check Data mapping.
  3. Select a document from the list.
  4. Confirm with OK.

Info

With the data mapping we can jump from table to table if we have a unique identifier of the secound table to filter down the specific record.