Purpose The report RN2LOP07 transfers a material hierarchy table created withMicrosoft EXCEL into the system. Prerequisites The desired material hierarchy has been entered in an Excel table. Thetable must contain all rows in the specified sequence and be saved inthe format .csv. Use a semicolon as the separator. The table has thefollowing structure:
- Column A: Predecessor node of the current node. You must specify an
existing hierarchy ID in the uppermost level. You subsequently have toselect this as the hierarchy on the report selection screen. You canenter new nodes or levels of the hierarchy using the Excel table.
- Column B: Nodes in the hierarchy for the material assignment. A node
must be assigned either to a predecessor node in the material hierarchyof the Excel table or to a predecessor node in the database. If the nodeis missing from the current hierarchy, the program adds it to thematerial hierarchy if there are no errors found.
- Column C: Name of a new node. For syntax reasons, this column must not
be missing for existing nodes either.
- Column D: Plant (4-digit) for the material assignment
- Column E: Material number from MM
- Column F: Catalog ID. If the catalog ID is missing from the hitherto
existing hierarchy, it is transferred from the report.
- Column G: Medical text for the material
- Column H: Consumption quantity of the material
- Column I: Consumption unit of measure of the material. The program
checks whether the unit is permitted.
- Column J: Approval type. The program checks whether the approval type is
permitted.Features
- If the Test Run> indicator is set, the program evaluates the table
and writes the messages to a result log. You cannot transfer the data,however.
- If the Test Run> indicator is not set and if no errors have
occurred, the program activates the Save> button in the programtoolbar. If errors occur, you must correct the table data.Selection
- Institution: Required entry
- Hierarchy: Required entry; the hierarchy must be identical with the
uppermost hierarchy in column A of the first data row of the Exceltable.
- Catalog type: Is required if the report is to create a new material
catalog.
- Test run: Creates a log without transferring data.
- Name of input file: CSV table specified as path/file. We recommend you
make your selection from the value help.
|