This document describes methods for the creation of custom list transactions over any M3 standard or customer-built M3 table with no coding required. If data is only needed from one single table, we recommend that you use MDBREADMI instead. MDBREADMI provides better performance but less functionality.
When creating a new transaction ID, most of the settings are retrieved from an information browser category or an ad hoc report definition. The field 'Ad hoc report definition' on (CMS015/E) controls if the prompt on the 'Information browser category' field is used for 'Ad Hoc Report Group. Open' (AHS100), instead of 'Information Browser Category. Open' (CMS010). Either an existing one is selected, or a new one created, in (CMS010), or in 'Ad Hoc Report Group. Open' (AHS100).
A sorting of the list is based on the sorting option selected for the sorting order. All system-defined and user-defined sorting options (indexes) for the master table are available.
Use 'Browse' in the 'Sorting order' field to launch 'Sorting Order. Open' (CRS022).
The view defines the 'Output' fields. Use 'Browse' in the 'View' field to launch 'View. Open' (CRS020). Fields can be added or deleted.
A filter is used for selections. Filter fields are used as mandatory input fields. A value must be specified in the filter field and only records containing the same value as the filter are then displayed. The filters are selected starting from the first sorting field and then field by field throughout the sorting definition.
Any field from the master table can be used as a 'From' and 'To' selection field. A maximum of three selection fields can be used simultaneously. Selection fields are used as optional input fields.
A search query can be used as an input field. The SQRY field is then used as a mandatory input field. A search query cannot be used in combination with filter or selection fields.
Bookmark fields can be included as 'Output' fields. The YPGM (Browse program) and KSTR (key string) fields are added as the final output fields. The Browse program is retrieved from (MNS120) based on the master table.
Aggregation is used to accumulate several records into one record. Aggregation levels are used to indicate how records in the list will be aggregated. Key fields that are not included in the aggregation level will be aggregated. Aggregation levels are selected starting from the first key field and then field by field throughout the sorting option definition.
This is used to insert a subtotal record if the value in a specific key field is updated. Any key field in the selected sorting option can be used as break level for subtotal.