Order Export of Plan values to M3

It is now possible to specify an export order for the plan values to export in a staging table. When an order is specified in the BOI, the M3_EXECUTE_EXPORT SCV program exports the records in that specified order.
This new structure is introduced in M3 BOIs to specify the export order:
<EXPORT_ORDER>
    <COLUMN_NAME SEQUENCE='1' SORT='ASC'>order_number</COLUMN_NAME>
    <COLUMN_NAME SEQUENCE='2' SORT='ASC'>operation_number</COLUMN_NAME>
    <COLUMN_NAME SEQUENCE='3' SORT='DESC'>start_date</COLUMN_NAME>
</EXPORT_ORDER>

In the BOI:

  • EXPORT_ORDER must be specified after any RETURN_VALUE and before any RETRY tags.
  • EXPORT_ORDER tag is only available where direction=Export.
  • EXPORT_ORDER tag can occur 0 or 1 time.
  • COLUMN_NAME tag can occur 1 or n times within EXPORT_ORDER.
  • SORT attribute can be ASC or DESC.
  • SEQUENCE and SORT attributes must be in uppercase.
Note: This feature is available on update. You do not require to do anything to enable this feature.