Create a requisition transfer - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2
  1. From the Home screen, select Other Tasks > SAP > SAP Requisition Interface.

  2. Select an Interface > Requisition Transfer Jobs.

  3. Click Add Row.

  4. Type a job name, short description, description, and then click Save.

    After successful creation of the job, the application changes the job status to NOT RUN.

  5. Select the job and then click Start Job.

    The Job Execution Statics block displays the following information:

    • The result of the job transfer in Job Summary.

    • The job start date, job end date, and the log file path.

SAP Requisitions block

After saving the job information in the Requisition Transfer Jobs block, the job status changes to NOT RUN. You can now select the requisitions to be transferred to SAP.

Only approved requisitions that have the project default ZI_SAP_INTF assigned are be displayed in this block.

All unsuccessful requisition transfers are displayed with a status NOT TRANSFERRED. In both cases, the property value must match the name of the interface (interface_code) or be Null. Otherwise, the requisition will not be shown.

In both cases, the property value must match the name of the interface (interface_code) or must be Null, else, the requisition is not displayed.

Engineering Requisition - Specifies the requisition name and includes code and number. Valid entry includes:

  • string in uppercase letters, not exceeding 50 characters.

  • must be unique in combination with the supplement, purchase indicator, and origin within a project.

Supplement - Supplement number of the engineering requisition.

Origin - Specifies the office code that is responsible for the engineering requisition and purchase orders.

Purchase - Specifies whether the line items of this engineering requisition can be used for both purchase orders and inquiries or only for inquiries. If the value is Yes, the engineering requisition can only be used for inquiries.

Plant - Specifies the SAP_PLANT property value.

Transfer of Requisitions

Intergraph Smart Materials SAP Requisition Interface 22

Purchase. This indicator shows whether the line items of this engineering requisition can be used for both purchase orders and inquiries or only for inquiries.

If this check box is not checked, the engineering requisition can only be used for inquiries.

Origin. Code for engineering requisitions and purchase orders that represents the office that is responsible for the information.

Plant. Value of the SAP_PLANT property.

Transfer to SAP. Check the check box for all requisitions you want to transfer to SAP. You can only transfer requisitions that have a valid plant (defined for the interface on SAP 10.08). The interface checks to see whether all the material inside the requisition is successfully transferred to SAP already. If not, the requisition cannot be selected for the transfer. A successful data transfer to SAP means only a successful creation of the IDocs data in either XML format or in the XI-interface tables and says nothing about the processing result by SAP.

SAP transfer using XML files

The following files are created when the transfer type XML has been selected on SAP 10.01:

PRECQR_jobnr_seqnr.XML

XML file of IDOC PRECQR

PRECQR _jobnr_seqnrN.XML

XML file of IDOC type PRECQR for SAP without line feed and leading blanks (only this file will be transmitted by ftp) The import of the XML files into SAP is described in a separate document.

SAP transfer using database tables

The SAP transfer for material and requisition data now allows you to use the following transfer modes:

  • Generation of XML files

  • Export into database tables (NEW !)

Use SAP 10.01 SAP Interface Parameter to select the desired mode.

Interface tables will be created the first time the export for database tables is started .

The tables are created in the M_SYS schema.

The system will generate a table for each segment defined on SAP 10.03 SAP IDocs for the SAP version defined on SAP 10.01. The name of the tables will be ‘XI_’+<Segmentname>.

The tables (called from now on XI-tables) will include as columns the fields defined for the segment.

Before each run of the export for database tables, a check is performed whether the table definitions still match the IDOC definitions on SAP 10.03. If this is not the case, then missing fields will be added as new columns to the table. Also, the column size will be increased accordingly.

The ID field of each table is used to identify all segments of an IDOC.

Additional fields ID1, ID2, ID3 (depending on the IDOC definition) represent the sequence and hierarchy of the IDOC because the IDOC information is distributed over different tables.

Transfer of Requisitions

Intergraph Smart Materials SAP Requisition Interface 23

The fields always start with 1 and are increased for each segment on the same hierarchy level.

Example

1

1 1

1 2

2 1

2 1 1

2 2

2 2 1

To control access to the tables, you can use the column STATUS. This is filled by default with the value ‘01’.

A new user SAP_XI is created the first time the transfer for tables is started. This user has access to all interface tables.