Skip to main content

Posts

Material Price Report

Material PO price history can be displayed to T.Code ME1P This report gives the price history of a material Material Price can be displayed through  T.Code ME1M This report gives the net price of a material. Both reports were built based on tables - EINA, EINE, and EIPA

Material List based on Creation Date

Standard SAP has provided T.Code - 'MM60' to fetch material details but this report doesn't include creation date. So in order to accomplish this SAP has provided Other T.Code - 'IH09' where we fetch material details based on creation date. Below is the screenshot of reference. Thank you.

Vendor List based on Creation Date

Ideally, Vendor list can be displayed through T.Code - MKVZ where we can fetch vendor list either at Purchase Org or Account group or Generic. Below is the list of fields we can fetch through this. Name of vendor Street Country Postal Code City Account group Search term Central purchasing block Block function Central deletion flag One-time account Purch. Organization Purch. Org. Descr. Terms of Payment Incoterms Incoterms (Part 2) Purch. block for purchasing organization Delete flag for purchasing organization Minimum order value 0 Order currency Salesperson Telephone Reference Purchasing Org. Number of Purchasing Organizations 1 But at times business requires to fetch vendor list based on creation date. This cannot be accomplished through the above T.Code instead SAP has given T.Code S_ALR_87012086 to fetch the data. Thank you.

Mass blocking of Purchase Orders

At times, business requires to mass block PO's and release whenever required. For this to accomplish, We cannnot be done through Mass Transaction as system will consider as 'L' even though we pass Value 'S' in LOEKZ field. For this to accomplish we are required to perform LSMW - Batch input method where recording need to be performed to ME22. Below is the sample LSMW export file for reference. [Recording        ] : ME22 [Recording Text   ] : po change /SAPDMC/LSGBDC                ZTEST_IMP      ME22           0001                                        0000TME22                                                                                                                                                                                                                                                                                                                                                                                                               

Material Master Fields - Basic Data

Base Unit of Measure It is the smallest unit of measure in which stocks of the material are managed. Ex. Each, Piece etc.. Alternate unit of Measure It is the unit of measure which can be available besides base unit of measure. For instance: If the sales unit of measure is different than that of the base of the unit of measure then an alternate unit of measure is being used. Gross / Net Weight  The weight of the material maintained in this field will be carried over to the sales document item-level data. Old Material Number Legacy system Material Number will be maintained in this field.We can use the old material number to systematically search for material master records via match codes (Search Help) General Item Category Group This helps the system to determine item categories during the Inbound delivery process. This field is used as one of the parameters during item type determination at sales document or inbound delivery level. Material Group  Ideally

Schedule Line Category

A schedule line consists of confirmed delivery quantities and corresponding confirmed delivery dates. This provides us info regarding when the delivery can take place. Delivery Block : A delivery block can be maintained at Sales Document level and Schedule line Category level. Delivery block maintained at schedule line category level will be proposed at schedule line level of the sales order. Movement Type  Any movement of goods both physical or logical will be captured in the form of movement type in This controls the inventory update and generation of accounting document. The SD module uses goods movement from 601 to 699. All goods issues to customer from unrestricted stock will be performed through Movement type '601' All customer returns will be captured through 651 601 GD goods issue:delvy 651 GD ret.del.  returns 653 GD returns unrestr. 655 GD returns QI 657 GD returns blocked 641 TF to stck in trans. 643 TF to cross company 645 TF cross co

Sales Item Category Controls - Part 2

Pricing Indicates whether the system automatically carries out pricing at the item level. Blank No pricing This is used for Text items and Items not relevant for pricing scenarios X         Pricing standard The system carries out pricing for standard items in a sales order. A         Pricing for empties B         Pricing for free goods (100% discount) This is used for free Goods Items Schedule Lines Allowed Schedule lines determines the delivery date and quantity. Enabling this check box, Will display schedule lines at sales order item level else schedule lines tab will not be displayed  For standard item, schedules lines exists but where as for text or service items this is not required to be enabled as schedule lines are not required. Item Relevant for Delivery This checkbox is enabled for the items which don't have schedule lines and require delivery processing. Ideally, this is used for text items and Value Items. It serves only fo