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.