SAP EWM Drive for Consultants

SAP EWM Drive for Consultants
SAP EWM Drive for Consultants, Also SAP server access for MM/SD/PP/QM/EWM/S4 Hana - Technical and Functional

SAP MM / EWM Content

Wednesday 23 October 2019

Important Table in SAP-MM- Reporting SE16N

Important Table Names in SAP-MM

·      Material Master:

MATNR-Material Number
MARA- Material master General Data
MARC-Material master plant data
MARD-Material master storage location data
MAKT-Material master description
MARM-Material master UOM
MBEW-Material Valuation
MVKE-Sales data for material
STKO-BOM Header details
STOP-BOM Item details
MAST- Material to BOM link
T023- Material Groups
WERKS- Plant

·      Vendor Mater:

LFA1-vendor master general selection
LFB1-Vendor master Company code data
LFC1-Vendor master transaction figures
LFBK-Vendor master Bank details
LFM1-vendor master purchasing organization data
LFM2-Vendor master purchasing data
WYT1-Vendor Sub-range
WYT1T- Vendor Sub-range description
WYT5-Changes to vendor master record

·      PIR-Purchase Info record:

EINA-Purchase info record-general data
EINE-PIR-purchase organization data
EIPA-PIR-price history
KONP-Condition Item
KONH-Condition Header
QINF-QM Infor record for Material/vendor
DRAT-Texts-Info record

·      Source list

EORD- Source list

·       Purchase requisition

EBAN- Purchase requisition
EBKN- Purchase requisition account assinmentt report

·      Purchase Order

EKKO – PO Header report
EKPO – PO Item report
EKKN- PO Account assignment report
EKBE- History for the PO
KONV- Condition value storage
EKO- PO delivery dates

·      Quota Arrangement

EQUK- Quota arrangement header data
EQUP- Quota arrangement Item data
Important T-codes
MEQ1- Create Quota
MEQ2- Change Quota
MEQ3-Display Quota
MEQ4-Chnages done in Quota
MEQ6- Analyze Quota
MEQ7- Delete Quota
MEQ8- Monitoring Quota

·      Inventory Management tables

MSEG- Material document
MKPF- Material document header information
MARD- Material stock
MBEW- Material stock valuation
MSKA- stock balance for sales
MKOL- Special stocks like consignment

·      Invoice tables

RBKP- Invoice document header
RSEG- Invoice document item

Wednesday 16 October 2019

ASAP Methodology process for SAP Consultants- ALL Modules mandatory concept

                        ASAP Methodology


ASAP stands for Accelerated SAP methodology, where it’s an important SDLC (Software development life cycle) software to be used to implementation of projects.

who ever is using SAP they should follow the ASAP methodology process for the implementation process, its an SAP own and best methodology to follow to cutdown the costs.

SAP implementation process takes long time and it requires many department manpower along with lot of efforts to understand the AS-IS and TO-BE process to implement and satisfy the clients.

It will be very risky if the proper plan is not determined to implement, as this purpose starting all the managers and department heads will involve making sure everything is I proper way by following ASAP methodology process.

ASAP methodology is a roadmap for the process, where consultant/managers should follow there guidelines as per ASAP methodology, Project management team will be taking care of smooth functionality of the process by updating to clients. ASAP methodology consists several phases that included in SDLC as mentioned above, here it divides the ASAP methodology phases and marks time for each phase and it divides the work as per the modules (SD/MM/PP/QM)

Each phase will be called as Milestone and every milestone needs documents that we have done and gets that approved from clients accordingly.

ASAP methodology provides guidelines and roadmap for implementation/Enhancement /Customization that requires as per the project support.

Phases of ASAP Methodology:

1.Project Preparation
2.Business Blueprint
4.Final Preparation
5.Go Live
6.Production support/Post-production

We have all the 6 phases, which are important to implement as per the process, we are discuss in detail of all the phases.

Introduction to client and bidding for project:

Before all these 6 phases, whoever is interested to move to SAP software, then they will be approaching the software company directly to buy the software.

Note: Once they have bought the software after that client use to bid for the project implementation with several companies, bidding happens in terms of price and time taking to finish the project.

Note 2: There will be one more bidding with service companies for production support, here Implementation and production support clients are different by 90%, because of some privacy and quality purpose 2 biddings and 2 clients will get selected and given the project as per that.

1.Project Preparation:

Once the client has been decided on this implementation partner, this 1st phase will start and here they will decide on Landscape requirements first.

Kick of meetings, Scope and out of scope modules will be discussed for implementation.

Maintain on server Information like how many servers required and how many test clients required in each server like we have unit test and integration testing.

Even in quality and production we can have different clients as per the requirements, suppose big MNC company they may have 6 production clients in production server and accordingly they will have 6 clients in development server, so that independent requirements can be enabled as per the client and no need to depend on other clients.

Project cost and resources required from how many modules are there for your requirements and each module contains members to complete the whole process.

All the above requirements will be discussed by the higher management (managers and business members) where few from client and few from organization who is implementing.

Project management team (PM) will studies the organization requirements with respect to interfaces, how many interfaces required and present process and requirement of interfaces. Here we will study all possible things and their process called as AS-IS.

Timeline will be for this process in 2-3 Months

2.Business Blueprint

This is very important phase in the business, where functional consultants will take care of gaps by finding as-is process to to-be process and complications that is possible with SAP if not interacting with ABAP to develop those configurations, so all these things are handled in this phase.

If any requirement is not possible with SAP then ABAP’er will try to do enhancement and this scenario will be in GAP analysis, same like this there will be many cases where GAP analysis will come into picture to fill the process and mention the client that this is the gap between your process and to-be process.

What are the integrations required with other departments like with MM-FI, MM-SD, MM-PP and MM-QM

Interfaces/what kind of interfaces is present, so as per that what methodology should be used for processing.

Functional consultants will work first with all functional requirements and once this is done then if any gaps and development required the technical consultant will come into picture.

Testing team will be testing all the configurations prepared.

Based on As-Is and To-be documents we will create BBP document and get it signed from clients.
This phase will take 2-3 months.

Example: in the old process, if you are Oracle tool then there will be price indicator increase or decrease option shown by the system but in SAP we don’t have that functionality.

So, this will be maintained in as GAP and mentioned in the BBP document and gets signed that -by ABAP we will do this customization (Refer FRICWE concept)

3.Realization phase:

This is phase where all functional consultants carry out there customization and even development also done if required for customization, so all the customizations/integrations/interfaces are completed- all back end SPRO settings and everything will be moved to quality server by basis team- All testing’s for the TR’s will be done in Quality server.

All the integration testing and unit testing takes place in this phase.

BPP -Business process procedure has been created in this phase

UAT will be taken from superuser with signed.

This phase will take 2 months.

4.Final Preparation phase:

Final preparation is the phase where we will move all the TR’s will be moved to production and user manuals are created by taking UAT from super users and cut over activities like master data uploading for material and vendor and initial entry of stock in inventory.

UAT-User acceptance test- which will be done by power users like is it working, or any issues related to configuration.

Training to the end users related to the process.

After the final preparation phase, we should make sure only production activities running smoothly without major interruptions.

Testing of every phase and UAT manuals/ cut over plans needs to be approved in this phase where data uploading by using LSMW and BAPI

Knowledge transfer and documentation of all process with UAT documents.

This phase will take 2-3 months

5.Pre-Golive Phase:

Legacy system should be stopped to use in this phase

Preparing all the data and ensuring all the data has been migrated and if anything, pending from LSMW to BAPI, should be completed and inventory data and defining class/characteristics for release procedure, number ranges for the document types and everything will be done in production server.

Ensure all the TR’s are moved to production and interfaces are working properly for the monitoring purpose.

This will take 1-2 months to complete

6.Postproduction support:

In this phase we will be resolving queries related to purchasing and if required giving trainings to end users.

This Completes the ASAP methodology and any doubts please comment in the comment areas to respond back.

Video will be uploaded to YouTube channelStudyuuu (Please subscribe to channel)

Friday 11 October 2019

SAP MM-QM Integration (Materials Management and Quality Management Integration)

Materials Management and Quality Management Integration (SAP MM-QM)

MM-QM Integration:


We all know that Quality management plays a key role in any manufacturing sector and without Quality management the material will not get certified to use for production activities and vendor will not be paid up to the verification of quality management.

For example, all materials in plant cannot be done for Quality management and only few materials we can do QM like critical parts or end- product.

So, while maintaining material master if there is a quality management tabs in Material master then its an QM part and needs to be moved for quality management.



Material master- Quality management tabs (QM tabs will be updated by QM team)

Material master-QM slide-Inspection-01(Goods receipt inspection for orders)

Once we maintain these view in Material master, then when ever we procure this material to that plant then Material will be moved to Quality inspection automatically.

QM team should release the material from Quality to Unrestricted Use.


Once we maintain material master view-QM tabs (Mandatory).

We cannot control these delivery place in PR/PO/GR- once these settings are done then automatically Quality management will comes into picture.

Material – With QM view


PIR- Quality info record (Mandatory)-QI02

PR- Mention the material and plant which we maintained QM view.

PO- Create PO and once the supplier delivered the goods.

MIGO- once we do MIGO, goods will be moved automatically to Quality Management in the company for Quality check.

Note 2: QA32

Clear Inspection lot- Input data like plant or Material

Then execute- select the stock and do-UD (Usage decision)

Do the certification by going to Go to and do the certificate.

Then click on accept and select the move to – Unrestricted.

MM-QM Video will be uploaded to YouTube- Studyuuu SAPMM, Please visit and subscribe to Channel for more videos

Wednesday 9 October 2019

ERP- Enterprise Resource Planning- SAP(ERP)

                  ERP- Enterprise Resource Planning

Enterprise- Any Company (Small/Medium/Large)

Resource- kind of resource to the Company (Manufacturing/HR/Plannin/Supply-Chain/Procurement/Warehouse/Costing)

Planning- Software Planning (Automatic or Simple business)- Any Automation/Process can be implemented.


ERP is a software where the business activities/Functionalities will take place daily in the company/Organization.

Any Company which are having sales then obviously they will use any ERP, to know the sales percentage

Sales Company

Sales/Accounting/APAY/Account receivables/Purchasing/Supply chain/ HR.

One sales company is having different modules of business to run their company in profits, so to run the company for all the above modules should be linked as per the business requirements.

Because accounting details should be linked to supply chain and these details should be linked to purchasing and that to HR and Sales.

All these linking/Integrations will be done in ERP- Enterprise resource planning.

We can make the integration as per the company standards and requirements.

SAP is the leading ERP tool in current generation.

It Contains only one database and shares the information to all modules in the organization.

Benefits of an ERP system.

1.     Improves Efficiency of any business.
2.     Automate the routine tasks
3.     Relationship with other resources through interface
4.     Handling all department details in one tool
5.     Analytics and reporting will be very fast
6.     Monitoring cash inflow/outflow will be very easy.
7.     Inventory-IN/OUT
Now a days all ERP database are moving to Cloud.

Benefits of Cloud-

·       Performance of system.
·       Support will be 24/7
·       Costs will vary
·       Access from anywhere
·       Low upfront costs

What is SAP – ERP?

SAP- ERP is integrated with all modules in the business.

Almost of all modules has been covered with integration part with SAP and data exchange is easy.

Inventory will be analyzed and controlled from anywhere.

Centralized system will be possible with this SAP.

Inter-connected of data between all the departments in industry.

It Controls the whole business to increase the profits.

Payments will be made faster and reminded by the system automatically and process legally by this data

For SAP MM Videos, Please Visit YouTube- Studyuuu

Sunday 6 October 2019

Procurement Life Cycle: - Simple Explanation

Procurement Cycle: - Simple Explanation

For Video Explanation, please go to YouTube-  Studyuuu SAPMM


Procurement cycle always starts with the requirements of the company and based on that next process will starts.

if we are starting any new business or Manufacturing industry, then first we will think about requirements like is this machine really required or is it helpful for production.

Eg: What is required to start- Machining tools, cutting tools, brushing tools'

Funds related to Equipment- Capital cost- which will be based on physical equipment
Gathering of all requirements and spend will be done in the first phase of procurement cycle.

DOA- Spend Approvals:

Cost will be decided by the company and higher or lower prices should be approved by stakeholders (Clients)

Any rejection/Approval process will be done in this phase.

Suppliers Selection:

Once the spend is approved/ rejected then next phase will be supplier selection

RFQ process will help to find the correct suppliers with less cost and remaining terms as per the company.

Price/Payment terms/Lead time

Supplier rejection/Acceptance will be done in this phase- RFQ process helps to accept or reject the supplier.


Normally sourcing will do all these activities, whereas buyer will create PO based on vendor selected in RFQ process.

For full RFQ process- kindly go through and search for RFQ


Maximum of 3 vendor to send for RFQ process

Mention deadline for quotation and evaluate the terms like price/net terms/lead time

System automatically calculates all the conditions and gives the correct supplier to procure goods.
Send the rejection or approval to vendor


Based on the selection from vendor- we need to create the contract/PO

PO/Contract should be created based on the quotation from supplier and depends on the requirements we need to decide Contract/PO.

Net terms/Lead time/Price needs to be updated as per the quote provided by vendor at the time of vendor selection

Order Delivery/Follow Up:

Once PO is created then PO copy should be shared to vendor/Supplier

Delivery follow up should be done with supplier.

Any delay/shipping problems needs to be discussed with vendor.

We should ensure shipping takes place very safely without any delays.

Goods receipt:

Once the delivery is done, then GR needs to be posted with respect to the quantity received.
Normally plant-Stakeholder persons will be posting GR

Any defect/damaged quantity needs to be rejected from the vendor and appropriate action should be taken care by buyer.

Communication takes place between stakeholders and buyers regarding this shipment.

Invoice receipt:

Once GR is done, Invoice should be posted with respect to GR

Invoice will be sent by vendor to APAY team in every company, depends on the tools you were using they need to post in respective PO.

3-Way Match:

3- way match will be for material
PO/Goods receipt/Invoice receipt
Price and quantity should be seen in PO for verification
Goods receipt: Quantity will be main issue/ should be equal to PO.
Invoice receipt: Price in invoice should be equal to PO price.

2-Way match:

2- Way match will be for service
PO price needs to be checked with invoice.

For Video Explanation, please go to YouTube-  Studyuuu SAPMM

Featured post

What is IDOC? Explanation for Interview Purpose

What is IDOC? Explanation for Interview Purpose: Overview Explanation for Interview purpose Question: What is IDOC ? IDOC i...

Popular Posts