mm module sop

1.1 Article Master Creation

Article code will be generated automatically (system generated number) based on nature of Article type.

Purchase Organization Always 2000 (GWCL Local)

Sales Org 1000 (Spencer’s Retail Limited)

Dist. Channel

11 Retail POS ( In general we use this one default)

12 B2B Sales

13 Internet Sales

14 Export Sales

15 Internal Transfer

Distribution Centre Start with W* & I*(w for warehouse and I for institutional sales)

Stores Start with D*, H*, F*, X* & S*

Reference Article If user desired, user can copy from reference article code.

Views Depending upon your business requirements, user should select the view. For example, Non-trading Consumables, POS View is not significant. Usually for article creation select Basic Data, Listing, Logistics DC, Logistics Store and POS.

1.2. Basic Data View

Article Description Maximum 40 characters.

Base unit of measure For Inventory Management. Once an article is created this unit can not be changed.We should be careful while giving this,it should either be “pc” or ‘kg”.

Purchase unit of measure For Purchase Management. This is the unit in which the PO will be created. If this UOM differs from base unit then the conversion factor between base UOM and PO UOM has to be maintained. Generally we use “pal” for outer conversion.

Sales unit of measure For Sales Order (Institutional Sales). This is the unit in which the article will be sold in POS. The same conversion has to be maintained here also if necessary. Generally we use this same as base unit of measure.

Delivery unit / Issue unit For Distribution. This is the unit in which DC will supply the article to the Stores. This is same as our suf in legacy.

EAN / UPC Code The International Article Number (EAN) is assigned by the manufacturer of the article. In this case, the EAN identifies the manufacturer uniquely. A Spencer’s can assign EANs using "in-store" numbering techniques known only to the company. The no ranges for ean is given bellow.

Category Defines how the system determines an International Article Number (EAN) to be assigned internally and which check criteria (check digit, prefix, and so on) an EAN of this category must fulfil.

Product hierarchy 10 digit code identifying the manufacturer and the brand code for the article.. It is used for analyses and promotion. Here First 5 digits for manufacturer next 5 digits Brand.

Tax Class Key that identifies the tax classification of an article. For all GWCL articles it should be maintained as 1

Valuation Class Assignment of an article to a group of G/L accounts. Starting point for MM and FI integration. Use default 1010.

Trading Goods

GWCL-Free / Additional

1010

GWCL-Audio, Video & Accessories

GWCL-Fashion

GWCL-Food SLED Mandatory

GWCL-Food SLED Optional

GWCL-Hi-Tech

GWCL-Non Foods & HWP

F&V and Bakery products

Non Trading Goods

Carry Bags 2010

Stationery 2020

Repack Covers 2030

Storage Condition This field used for Stock determination (01 should be used) at the time of outbound delivery through STO. Use 01 to make an article Put Away, in case of Flow Through leave it blank.

Container This field used for Barcode Printing. For unbranded staples it is a mandatory one.

Bulk Article 10

Spilt Article(For Staples Unbranded) 20

Branded Article 30

Split Without Barcode 50

Purchase Group Each article is assigned to a particular purchase group. Like for Health & Beauty the purchase group will be HB1.the list of purchase group is given bellow. This is basically our buyer codes.

AC1 Fashion AccessoryBA1 Bakery/Chil FrozenBE1 BeveragesBF1 Bags & FootwearEL1 ElectricalEL2 ElectronicsFR1 FreshHB1 Health & BeautyHH1 HH Needs

HO1H.O.Purchase Group

HW1 HousewareKW1 KidswearLI1 LinenLW1 LadieswearMW1 MenswearPL1 PlayPR1 Processed FoodsST1 StaplesWO1 Work

Transport Group Using it for shipping point determination, use default 0001.

Loading Group Using it for shipping point determination, use default 0001.

Assortment List Type Relevant for perishables planning. These parameters used to group articles based on mode of procurement. This is mandatory for GPER article type. We run perishable planning by this field.

D DC to Store

G Groceries – Retail Store

V Vendor to Store

Old Article Number This ios sequential no to track the sap generated codes. This is followed by AC NIELSON series.

Remaining Shelf life Applicable for GBEV Article Type speciatialy. Minimum amount of time for which the article must keep upon goods receipt for the goods receipt to be accepted by the system.

Total Shelf life Applicable for GBEV Article Type only. Period for which the article will keep in total, that is, from the date of production to the shelf life expiration date.

1.2.1 Additional DataAdditional EANs

unit of measure For Additional EAN Code.it is same as base unit of measure.

EAN / UPC GWCL Legacy EAN Codes

Z1 Category (External)

13 Digits


5-6 Digits


7-11 Digits


12 Digits

If there are several EANs for each unit of measure, you must always identify one of them as the main EAN.If no EAN is provided then generate internally EAN with category Z4.

1.2.2 More Basic Data

Lab/Office This field used for nature of articleBAS BasicCOR CoreCRM Category Role MatrixEXO ExoticHWP Home - Work and PlayKVB Known Value Item - BrandedKVI Known Value ItemKVU Known Value Item – UnbrandedMOP Hi-TechNCO Non CoreNKU Non Known Value Item UnbrandedNKV Not Known Value ItemNOT Conces.Article Stock NOT maintained. For concessionaire this is an mandatory field.REG Regular

1.3 Listing View

Assortment Grade The assignment of an article to an assortment grade defines the assortment and the associated assortment users (such as retail sites) for which this article is valid. For Hyper, Super maintain SEC-B, for all category stores maintain SEC-A , for Free Goods linking assort each site to SEC-D (global) apart from main assortment SEC-A or SEC-B.

Listing procedure (Store) Procedure to be used to list articles for store assortments, default value ZS.

Listing procedure (DC)Procedure to be used to list articles for distribution centre assortments, default value ZS

Listed from Date, Month and Year

1.6 Logistics: Distribution Centre View

DC RP Parameters

RP Profile

For Min-Max RP Profile should be blank. For 91 Days RP Profile should be GWCL.

RP Type Key that determines whether and how the article is planned.

For Flow Through this is ND. For Put Away Min-Max this is VB & 91 Days Z3.

Lot Size Key that determines which lot-sizing procedure the system uses within articles planning to calculate the quantity to be procured or produced.

No need for maintain this field in Flow Through article. For 91 Days Put Away this is EX. For Put Away Min-Max this is HB.

Reorder Point If the stock falls below this quantity, the system flags the article for requirements planning i.e. the minimum stock that has to be maintained for this article.Max. Stock Level Quantity of the article in this Site that may not be exceeded.

Safety Stock The quantity whose purpose is to satisfy unexpectedly high demand in the coverage period.

Rounding Profile Key that the system uses to adjust the order proposal quantity to deliverable units. For Flow Through article no need to maintain this field. For 91 Days Put Away Rounding Profile is ZSP1.

Replenishment Parameters

Target Coverage Control parameter for dynamically calculating the target stock in replenishment planning. For 91 Days Put Away this value is 1.

Forecast ParametersPeriod Indicator The period indicator determines the time interval the system is to use to store consumption or forecast values. For Put Away and Flow Through article maintain the value T.Forecast Profile Key that allows you to store forecast parameters independently of a material master record. For 91 Days Put Away article maintain GWCL value.

RP Controller / Replenishment dataStock Planner Article planning person. For Put Away 91 Days maintain 91D and Min-Max maintain HW1.

Planning Cycle Cycle in which the planning run is performed for an article. If a vendor delivers a article on a particular week day, it is useful to plan this article according to the same cycle, while allowing for the delivery time. For Flow Through Min-Max maintain Z1W and 91 Days maintain Z2E. For Put Away 91 Days maintain Z1W and for Min-Max Z1T.

Delivery Cycle Planning calendar to define the delivery cycle for supply relationships between Sites or between Site and vendor. For Put Away 91 Days maintain Z1T.

Supply Source Restricts the search for sources of supply for this article to external (normal) or internal (stock transfer) sources of supply, and also allows you to define a search sequence.

For General article maintain 1. For DSP article maintain 2.

For Perishable article routed through DC maintain 3.

For DSP Perishable article maintain 4.

For Concessionaire article maintain 4.

Source Indicator Description1 Standard2 Stock Transfer3 Standard before Stock Transfer4 Stock transfer before StandardA Consignment

Consignment Control Controls whether an article is preferably procured for own stock or consignment stock at a Site. For Concessionaire article maintain 1.

GR Processing time Number of workdays required after receiving the article for inspection and placement into storage.

Automatic PO Defines that purchase orders are generated automatically when purchase requisitions are converted into purchase orders.

Availability Check It should be 02 always.

Negative Stock Indicates that negative stocks of the article are allowed at the Site.

Distribution Profile Control profile for Merchandise Distribution. When merchandise is procured, the recipients of the articles are defined. Articles can be distributed among the individual recipients in a Site using the processing methods cross docking and flow-through, for example.

This field should be used only for Flow through articles not for Put away articles!!

These filed is mandatory for Collective Purchase Orders generation based on Stock Transport Orders.

Storage Location For DC maintain PU01 as storage location. For Institutional Sites (i.e. I*) maintain IS01 as storage location.

1.6.7 RP / Forecast Data

Procurement:Procurement Type for 91days flow through articles,flowthrough minmax articles91days putaway articles ‘X’.For 91days put away minmax articles-‘F’Availability Check

Availability Check Always 02

1.6.9 Accounting

Current Valuation

Moving Average Price System automatically calculate based on Goods Receipts. At the time of creation of article Basic Cost should be uploaded as MAP(T Code MR21).

1.6.10 Other Logistics Data

Profit Centre Maintain the 10 digit Profit Centre. For 1st 3 digit provide the Region Code (e.g. for WB provide 301), next 4 digit will be DC code (e.g. W013), last 3 digit will be the 1st 3 digit of Merchandise Category in reverse order (i.e. if the Mer. Cat. Starts with 101 the required 3 digit will be 110). Only exception if the article is Non-Trade in nature i.e. Consumable then mainatain last 3 digit 999.

Export/import Group Maintain LIST value for this field.

1.7 Logistics: Store View

Sales Org 1000Distribution Channel 11Store RP Parameters

RP Profile Key that you can use to store MRP parameters that are independent of the article master record. In an MRP profile, user can define (a) which fields are filled with values when MRP data is entered in the article master record (b) which values these fields have (c) which of these values can be overwritten and which not.

For 91days Flow Through & Put Away articles RP Profile –GWCL.

RP Type Key that determines whether and how the article is plannedMin-Max Flow Through and Put Away articles –VB.

Lot Size Key that determines which lot-sizing procedure the system uses within articles planning to calculate the quantity to be procured or producedMin-Max Flow Through and Put Away articles –HB.

Reorder Point If the stock falls below this quantity, the system flags the article for requirements planning-minmum stock Max. Stock Level Quantity of the article in this Site that may not be exceededMaximum stock

Safety Stock System will calculate automatically for 91days Flow Through and Put Away articles.

Rounding Profile Key that the system uses to adjust the order proposal quantity to deliverable units. ZSP1 for all articles

Replenishment Parameters

Target Coverage Control parameter for dynamically calculating the target stock in replenishment planning.

For 91 days Flow Through and Put way articles 1 day

Forecast Parameters-For 91days Flow Through and Put Away articles –GWCL.

RP Controller / Replenishment dataStock Planner for 91days articles 91dOther minmax articles purchasing group.

Planning Cycle Cycle in which the planning run is performed for an article. If a vendor delivers a article on a particular week day, it is useful to plan this article according to the same cycle, while allowing for the delivery time Order schedule from stores.

Delivery Cycle Planning calendar to define the delivery cycle for supply relationships between Sites or between Site and vendor. For 91days articles delivery schedule in Stores.

Supply Source Restricts the search for sources of supply for this article to external (normal) or internal (stock transfer) sources of supply, and also allows you to define a search sequence.

For General article maintain 2. For DSP article maintain 1.

For Perishable article routed through DC maintain 4.

For DSP Perishable article maintain 3.

For Concessionaire article maintain A.

Source Indicator

Description

1 Standard2 Stock Transfer3 Standard before Stock Transfer

4 Stock transfer before standardA Consignment

Consignment Control Controls whether an article is preferably procured for own stock or consignment stock at a Site. For Concessionaire articles -1

Stock Determination Group For Concessionaire articles - Z001

General Control ParametersPurchase Group Buyer code

Site Specific Article Status The Site-specific article status restricts the usability of the article for the Site concerned, that is, it defines whether a warning or error message is displayed if you include the article in a particular function.

Automatic PO Defines that purchase orders are generated automatically when purchase requisitions are converted into purchase orders.

Availability Check always ‘02

Negative Stock Indicates that negative stocks of the article are allowed at the Site.always –marked

Storage Data:

Storage Location For every Store maintain - SH01.

SchedulingPlaned Delivery time in days.

Net Requirement CalculationService Level for 91days articles 97.0

Other Logistics Data

Profit Centre Maintain the 10 digit Profit Centre. For 1st 3 digit provide the Region Code (e.g. for WB provide 301), next 4 digit will be Store code (e.g. D070), last 3 digit will be the 1st 3 digit of Merchandise Category in reverse order (i.e. if the Mer. Cat. Starts with 101 the required 3 digit will be 110). Only exception if the article is Non-Trade in nature i.e. Consumable then mainatain last 3 digit 999.

Export/import Group Maintain LIST value for this field.

1.8 Point of Sale (POS) View

POS Control for each Distribution chain / SiteDiscount allowed Required in case of manual discount at POSPrice Required No repeat key Scales group If articles are sold at “POS” through weightiness basis (for example Kg), then this field is relevant.

POS Selling period / StatusFor sale from For sale to Distribution chain Specific Valid From

Till Receipt textLanguage Should be EnglishAlternative unit of measure It should be Base unit of measure

Till Receipt text Based on POS billing specification

LISTING OF ARTICLE WITH SITE

Use Transaction Code WSM3 for listing of article with site.

Give the Assortment Grade as per requirement e.g. SEC-A.

Select article(s) and mention Listing Procedure as ZS.

MAINTAIN INFO RECORD

Use Transaction Code ME11.

For DSP article the Info Record will be in Store Level i.e. provide the Store as Site and for other article type(s) provide DC as Site.

Provide Vendor Code and Article Code that will be linked for that particular site.

In General Data check the vendor region, order unit, conversion.

In Purch Org Data1 provide the Tax Code, use E4 if the article is Exempted else use V0 if the article is Taxable.

Maintain the Basic Cost as Net Price.

Purchase unit of measure Regular vendor Specifies that the article is to be procured from this vendor at client level,

i.e. for the entire corporate group. Purchasing group Buyer Code based on nature of articles belongs to which Family.

Planned Delivery time Number of calendar days needed to obtain the article or service if it is procured externally.

Rounding profile Key that the system uses to adjust the order proposal quantity to deliverable units.

Confirmation Control This field we mapped for GIN. If GIN required before GRN, then users should maintain 0004

Incoterm 1 EXW / C&F / CIF so on Incoterm 2 Place for above Incoterm 1

MAINTAIN INPUT TAX

Use Transaction Code FV11.

Provide Condition Type JVRD(for VAT) or ZIPC(for CST).

Use Key Combination -> Country/Tax Code/Site Region/Region/Article.

Provide Country as IN.

Use Tax Code V0.

Provide Vendor Region Code and Site Region Code.

Give Article Code in Article field and Tax % amount in Amount field and corresponding Tax Code.

Then Save the screen.

MAINTAIN OUT PUT TAX

Use Transaction Code VK11.

Provide Condition Type JIVP.

Use key Combination -> Country/Site Region/Region Article.

Provide Country as IN, proper site region code.

Use Tax Code A0.

Provide Vendor Region Code and Site Region Code.

Give Article Code in Article field and Tax % amount in Amount field and corresponding Tax Code.


MAINTAIN MARGIN

For DSP article maintain Margin at Site level i.e. provide the Store as Site and maintain Margin for each Site.

Apart from FnV article


Provide condition Type ZBAS.

Use Key Combination -> Vendor condition with site.

Provide Vendor Code, Purchase Organisation (2000), Site.

Give Article Code in Article field and MARGIN % amount in Amount field and corresponding Tax Code.


For FnV article

Use Transaction Code MEK1.

Provide condition Type ZMUP.





For Concessionaire article

Use Transaction Code Vk11.

Provide condition Type YMGN.





MAINTAIN MRP


Provide Condition Type VKP0.

Use Key Combination -> Article per site.

Provide Sales Organisation(1000) , Distribution Channel(11) , Site (the DC)

Give Article Code in Article field, Sales Unit and MARGIN % amount in Amount field and corresponding Tax Code.


Use Key Combination -> Sales Org/Dist. Channel/Price List/Article/Sales Unit

Provide Sales Organisation(1000) , Distribution Channel(11) , Price List(twice for both DAILY and HYPER)

Give Article Code in Article field , Sales Unit and MARGIN % amount in Amount field and corresponding Tax Code.

If the article(s) DSP in nature then only maintain MRP using Key Combination -> Article per site.

Repeat the process for each site where these articles are supposed be delivered.


MAINTAIN CSP


Provide Condition Type Z007.

Use Key Combination -> Customer/Article.

Provide Sales Organisation (1000), Distribution Channel (11), Hyper Site as Customer.

Give Article Code in Article field and discount % amount in Amount field. This discount % is the %age that you want to reduce from the MRP i.e. MRP – Discount % CSP.


MAINTAIN PRICE CALCULATION

Use Transaction Code VKP5.

Provide Article(s), Sales Organisation (1000), Distribution Channel (11), Site (DC for non DSP else each site), Vendor External procurement (vendor code).

Maintain Purchase Price Determ. Seq as Z5 (for non FnV article) or Z1 (for FnV article).

Maintain Sales Price determ. Seq. as 02(for non FnV article) or 01 (for FnV article).

Maintain List Group ‘B’.

Maintain List Variant as Z1.

Check the ‘Issue Update Log’ check box and execute.

After execution check the result , if everything matches press F7 then check the right side check box(s) for VAT articles . For CST articles only press F7 .

Save the screen.

UPLOADING STEPS:

JOBS REMARKS PROGRAM NAMES

BASIC VIEW UPLOADING FOR ARTICLES.

MMA HAVE TO UPLOAD HEADER AND PLANT LSMWS TO CRETAE THE ARTICLE.

YCMM30001

LISTING ARTICLES THROUGH ASSORTMENT GRADE.

MMA HAVE TO RUN WSM3 T.CODE TO LIST THE ARTICLE TO RESPECTIVE STOTRES.

WSM3(T.CODE)

PURCHASE VIEW UPLOADING. MMA HAS TO RUN THE LSMW TO CREATE INFORECORDS.

YCMM30022

SALES PRICE UPLOADING FOR DC AND STORE.

MMA HAS TO RUN THE LSMW TO MAINTAIN MRP AT DCLEVEL AND PRICE LIST LEVEL SEPARATELY.

YCMM30006

NEGOTIATION MARGIN UPLOADING.

THIS LSMW HAS TO BE RUN AT VENDOR ,SITE, ARTICLE COMBINATION LEVEL.

YCMM30015_ZBAS

OUTPUT TAX UPLOADING. THIS LSMW IS REGION SPECIFIC.

VK11_901

INPUT TAX UPLOADING. THIS LSMW IS VENDOR'S REGION SPECIFIC.

FV11_601

CREATE PRICE CALCULATION MMA HAVE TO RUN VKP5 T.CODDE TO UPDATE THE PRICE.

VKP5(T.CODE)

MAINTAIN PROFIT CENTER AND STORAGE LOC.

MMA HAVE TO RUN LSMW TO UPLOAD PROPER PROFIT CENTER AND STORAGE LOC.

PC(DC),PC_STORE2(STORE)

LOGISTIC DC VIEW UPLOAD RP PARAMETRES(FOR DC) TO BE UPLOADED THROUGH THIS LSMW.

YCMM30009_DC

LOGISTIC STORE VIEW UPLOAD RP PARAMETRES(FOR DC) TO BE UPLOADED THROUGH THIS LSMW.

YCMM30009

ADDITIONAL EAN ADDTIONAL EAN AND THE LEGACY SKU CODE HAS TO BE UPLOADED AS ADDITIONAL EAN.

YCMM30006

MARGIN CHECKING FORMULA

FOR CST (INDUSTRY KEY-F001)

NEGOTIATED MARGIN= ((PRICE BEFORE O/P VAT- NET COST(INCLUDING CST))/MRP*100

FOR VAT(VENDOR NOT REIMBURSING)( INDUSTRY KEY-N002)

NEGOTIATED MARGIN= (MRP-NET COST(WITH VAT))/MRP*100

FOR VAT(VENDOR REIMBURSING) ( INDUSTRY KEY-F001)

NEGOTIATED MARGIN= (PRICE BEFORE O/P VAT-BASIC COST(WITHOUT VAT))/MRP*100

CHECK LIST FOR MMA

ARTICLE CODE PRESENT IN SAP OR NOT

MMA SHOULD CHECK WHEATHER THROUGH LEGACY CODE ,EAN CODES,ARTICLE DESCRIPTION.FOR CONSIGNMENT ARTICLES LAB OFFICE SHOULD BE "NOT" AND FOR F&V LAB OFFICE HAS TO MAINTAINED.

CREATE ARTICLE

ARTICLE TYPE HAS TO BE ASSIGNED PROPERLY,ASSORT MENT GRADE SHOULD BE USED PROPERLY

LISTING OF ARTICLESRUN WSM3,checking the assortment grade.

INFOREC CREATION

FOR ARTICLES HAVING 0 % TAX WE SHOULD GIVE E4 IN REC.FOR CONSIGGNMENT ARTICLES INFO REC TYPE SHOULD BE CONSIGNMENT AND INFO REC SHOULD BE AT STORE LEVEL.FOR ALL DSP ALSO INFOREC SHOULD BE AT STORE LEVEL.

NEGOTIATED MARGIN LOADING

FOR ALL F&V THE MARGIN SHOULD BE MAINTAINED IN ZMUP CONDITION TYPE AT MEK1 T.CODE.FOR DSP ARTICLES MARGIN SHOULD BE AT STORE LEVEL.

MRP LOADING

MRP FOR DC TO BE LOADED AT STORE LEVEL AND STORES SHOULD BE LOADED AT PRICE LIST LEVEL.

IN PUT TAX LOADING

FOR "0" TAX ARTICLE INPUT SHOULD NOT BE LOADED.

OUTPUT TAX LOADING

E0 TO BE MAINTAINED FOR EXMPTAED ARTICLES.

MAINTAIN PROFIT CENTER AT STORES/DC

MAINTAIN 'LIST' VALUE FOR EXPORT/IMPORT GROUP FIELD

THE FIELD IS IN 'MORE BASIC DATA' VIEW

MAINTAIN COST AS 'MAP' FOR THE ARTICLETHE FIELD IS IN 'OTHER SALES DATA' VIEW

FLOW THROUGH MIN-MAXFLOW THROUGH 91 DAYS

PUT AWAY MIN-MAX

CONVERT STORAGE LOCATION IN LOGISTICS STORE FROM FLOW THROUGH TO PUT AWAY

IF PUT AWAY CONVERT STORAGE LOCATION FROM 'RA01' TO 'PU01' "& STORAGE CONDITIONS '01' IN BASIC VIEW

mm module sop

Documents