Purchase Info Record List Display in ALV format

 

Normally if we run the  Purchase Info Record List (PIR) List reports, the screen displays individual Purchase info record for each part.

ME1L     Info Records per Vendor

ME1M   Info Records per Material

If we  need the records display in table format for exporting into excel sheet, please follow the below solution:

Solution:

In our user parameter (PID) add the following PID

ME_USE_GRID and enter X

Run ME1M again this will now be in ALV.

Transaction: SU3 for user parameter

Purchasing Info Records

The  info record  contains information on a specific material and a vendor supplying the material.

For example, the vendor's current pricing is stored in the info record.

 

The info record allows buyers to quickly determine:

Which materials have been previously offered or supplied by a specific vendor which vendors have offered or supplied a specific material

Information from an information record is defaulted (copied) during the purchase order creation process. We can maintain the following data in purchasing information records:

Ø Current and future prices and conditions (gross price, freight, and discounts)

Ø  Delivery data (planned delivery time and tolerances)

Ø  Vendor data (vendor material number, vendor material group, etc.)

Ø  Text

Ø  The info record contains quotation and ordering data. The data in the info record (prices for example) is also used as default data for purchase orders.

Ø  For instance, we can store the current and future quotation conditions (discounts, fixed costs etc.) in the info record, in order to be able to copy them into Pos. we can also maintain the vendor’s conditions directly in the info record.

Information records can be maintained at different organizational levels:

• The client level
• The purchasing organization level
• The plant level.

Purchasing information records contains the following:

1 ) General Data: Vendor’s material number, Reminder data, Order unit, etc.

2 ) Purchasing Organization Data: Delivery time, Minimum quantity, Gross price, Freight, Discounts, Price history  and Text

3)  Purchasing organization/Plant Data: Delivery time, Minimum quantity, Gross price, Freight, Discounts, Price history and  text

        When you create a PO, the system searches for a valid information record for the purchasing organization/plant combination. If no such information record exists, the system searches for the purchasing organization only.

Ø  Purchasing info records contain concise information on a vendor and the material we procure from this vendor.

Ø  The purchasing info record is an important source of information for the buyer, enabling him or her to determine via list displays which vendors offer a particular material, or which materials can be procured from a particular vendor.

 

Ø  When we create purchasing documents (for example, purchase orders or contracts), the system displays data maintained in info records as default values.

Ø  We can maintain info records manually or automatically from quotations, purchase orders outline agreements.

Standard purchasing information record

The Standard type of purchasing information record contains information supplied by the vendor for a specific material, service, or group of materials or services.

Subcontracting purchasing information record

The Subcontracting purchasing information record can be used when the order is a subcontracting order. In manufacturing plants, a material being produced may require some outside service, such as enameling or partial assembly. The work may be performed by a subcontractor, and the price that the subcontractor charges for the work is included in a subcontracting purchasing information record.

Pipeline purchasing information record

Pipeline materials, such as electricity, water, and oil, are supplied by utility vendors and are used by the customer through pipeline withdrawals. The Pipeline purchasing information record reflects the information for this vendor/material combination. With pipeline materials, the system assumes that material will always be available, and the company will only pay for what it consumes.

Consignment purchasing information record

When a vendor supplies material to be stored at a customer’s site for customer withdrawal, the purchasing department can create a Consignment purchasing information record for that material.

Mass change in Purchasing Info Records

Mass change in Purchasing Info Records in one field

          We can change data in a number of different purchasing info records quickly and straightforwardly, in a single step. For example, you can change the vendor Mat.Group or the reminder levels in all selected info records for a certain material simultaneously.

Transaction Code: MEMASSIN

Path:

Steps:

1) Transaction Code:MEMASSIN

Select object type as BUS3003.

Select the data to be changed.

2) In the next step, select the records to be changed.

Select the changed value.

3)  Then select the field value to be changed and Click on Excute

     Enter the purchase order number range

Click On Execute

Apply changes and save it. 

Purchasing Info Records or The Types of Info Records

The  info record  contains information on a specific material and a vendor supplying the material.

For example, the vendor's current pricing is stored in the info record.

The info record allows buyers to quickly determine:

Which materials have been previously offered or supplied by a specific vendor which vendors have offered or supplied a specific material

Content of an Info Record

The info record contains:

Ø   Data such as prices and conditions that you can store for the relevant purchasing organization or plant.

Ø   Number of the last purchase order

Ø  Tolerance limits for overdeliveries and underdeliveries

Ø   Planned delivery time (lead time required by the vendor to deliver the material)

Ø   Vendor evaluation data

Ø  Indicator showing whether the vendor counts as the regular vendor for the material

Ø  Vendor sub-range to which the material belongs

Ø  Availability period during which the vendor can supply the material

Ø  The info record contains quotation and ordering data. The data in the info record (prices for example) is also used as default data for purchase orders.

Ø  For instance, you can store the current and future quotation conditions (discounts, fixed costs etc.) in the info record, in order to be able to copy them into Pos. You can also maintain the vendor’s conditions directly in the info record.

Organizational Levels:

An info record can apply to the following organizational levels:

Purchasing organization

Plant

Types of Info Records:

Standard : A standard info record contains information for standard purchase orders. The info records can be created for materials and services with and without master records.

Subcontracting : A subcontractor info record contains ordering information for subcontract orders. For example, if you subcontract the assembly of a component, the subcontractor info record would include the vendor's (subcontractor's) price of assembling the component.

Pipeline : A pipeline info record contains information on a vendor's commodity that is supplied through a pipeline or pipes (oil or water) or by similar means (electricity through the mains). The info record contains the vendor's price for the consumption of such commodities by the buyer ("pipeline withdrawals"). You can store withdrawal/usage prices for different validity periods.

Consignment : A consignment info record contains information on a material that vendors keep available at their own cost on the orderer's premises. The info record contains the vendor's price for withdrawals by the orderer from consignment stock. As in the case of the pipeline info record, you can store prices for different validity periods.