sd mm reports

[Former Member]

I WANT SOME SD MM REPORTS FOR PRACTISE WITH CODING ,AS I M NEW IN THIS FIELD

[Former Member]

Hi Surinder,

Use the search option in this forum. Also check these links. You will get many exapmles.

http://www.sap-img.com/

http://erpgenie.com/

Thanks

Aneesh.

[Former Member]

Hi,

FIRST GO THROUGH THE LIST OF TABLES AND TRANSACTIONS RELATED TO SD, THEN START WORKING ON THE REPORTS BY TAKING FEW TABLES

SD FLOW

SD Flow Cycle and T Codes:

INQUIRY ( VA11)

|

QUOTATION (VA21)

|

PURCHASE ORDER (ME21)

|

ORDER CONFIRMATION (VA01)

|

PICKING LIST – (VL36)

|

PACKING LIST - (VL02, VL01)

|

SHIPPING – (VT01)

|

INVOICE – (VF21, VF01)

|

AR

Explantion with relavent tables:

Enquiry - Customer enquires about the Products services that were sold by a company - VA11

Quotation - Company Gives a Quotation for the products and Services to a Customer

Sales Order - Customer gives a Purchase order to the company agaionst which a Sales order will be raised to Customer in SAP.

VBAK: Sales Document(Header Data) (VBELN)

VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)

Enquiry, Quotation, Sales Order are differentiated based on Doc.

Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,

for Quotation 'B' & for Order it is 'C'.)

Delivery(Picking, Packing, Post Goods Issue and Shipment)->

Company sends the material after picking it from Godown and Packing it in a Handling Unit(box) and Issues the goods

LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)

LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)

(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)

Billing - Also company bills to the customer for those deliveries

And in FI against this billing Accounting doc is created.

VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)

VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)

(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)

Apart from these tables there are lot of other tables which starts with

‘V’, but we use the following tables frequently.

Links for sd:

http://www.sapgenie.com/abap/tables_sd.htm

Please check this SD online documents.

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCSD/CAARCSD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_SD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMSD/BCBMTWFMSD.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLISPLN/LOLISPLN.pdf

Also please check this SD links as well.

http://help.sap.com/saphelp_47x200/helpdata/en/92/df293581dc1f79e10000009b38f889/frameset.htm

http://help.sap.com/saphelp_erp2005/helpdata/en/dd/55f33e545a11d1a7020000e829fd11/frameset.htm

http://www.sap-basis-abap.com/sapsd.htm

http://www.sap-img.com/sap-sd.htm

http://www.sapgenie.com/abap/tables_sd.htm

http://searchsap.techtarget.com/featuredTopic/0,290042,sid21_gci961718,00.html

http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/SD_tutorial.html

All help ebooks are in PDF format here

http://www.easymarketplace.de/online-pdfs.php

MM Cycle:

Purchase Requisition-> STaff in an orgn places Pur requisition for want of some goods/products - ME51

Request for Quotation(RFQ)-> The Purchase dept in the orgn calls/requests for the quotation for the products against which PR was raised. - ME41

Vendor Evaluation->After receving the RFQ's, after comparison a Vendor is finalised based on the terms and conditions.

Purchase Order(PO)-> Pur order was issued to that vendor asking him to supply the goods/products -ME21N

Goods Receipt Note(GRN)->Vendor supplies the material/Products to the orgn-

MB01

Goods Issue (GI) -> People receives their respective itesm for which they have placed the Requisitions

Invoice Verification-> ALong with the Material Vendor submits a Invoice for which the Company Pays the amount - .MIRO

Data to FI -> data will be posted to FI as per the vendor invoices

you better go through all these links u will get all the info what ever u need

for mm

http://www.sapgenie.com/abap/tables_mm.htm

http://www.sap-img.com/sap-download/sap-tables.zip

http://www.allsaplinks.com/material_management.html

http://www.training-classes.com/course_hierarchy/courses/2614_SAP_R_3_MM_Invoice_Verification_-_Rel_...

http://www.sapfriends.com/sapstuff.html

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PSMAT/PSMAT.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCMM/CAARCMM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_MM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOMDMM/LOMDMM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMMM/BCBMTWFMMM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MMIVMVAL/MMIVMVAL.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MMWMLVS/MMWMLVS.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MMISVE/MMISVE.pdf

Reward points for useful Answers

Regards

Anji

[Former Member]

hi,

PR >Release the PR>RFQ>Quotation>Quotation Comparison>PO>Release the PO>GR>Invoice Verification

MM Process flow:

Process Flow

The typical procurement cycle for a service or material consists of the following phases:

1. Determination of Requirements

Materials requirements are identified either in the user departments or via materials planning and control. (This can cover both MRP proper and the demand-based approach to inventory control. The regular checking of stock levels of materials defined by master records, use of the order-point method, and forecasting on the basis of past usage are important aspects of the latter.) You can enter purchase requisitions yourself, or they can be generated automatically by the materials planning and control system.

2. Source Determination

The Purchasing component helps you identify potential sources of supply based on past orders and existing longer-term purchase agreements. This speeds the process of creating requests for quotation (RFQs), which can be sent to vendors electronically via SAP EDI, if desired.

3. Vendor Selection and Comparison of Quotations

The system is capable of simulating pricing scenarios, allowing you to compare a number of different quotations. Rejection letters can be sent automatically.

4. Purchase Order Processing

The Purchasing system adopts information from the requisition and the quotation to help you create a purchase order. As with purchase requisitions, you can generate Pos yourself or have the system generate them automatically. Vendor scheduling agreements and contracts (in the SAP System, types of longer-term purchase agreement) are also supported.

5. Purchase Order Follow-Up

The system checks the reminder periods you have specified and - if necessary - automatically prints reminders or expediters at the predefined intervals. It also provides you with an up-to-date status of all purchase requisitions, quotations, and purchase orders.

6. Goods Receiving and Inventory Management

Goods Receiving personnel can confirm the receipt of goods simply by entering the Po number. By specifying permissible tolerances, buyers can limit over- and underdeliveries of ordered goods.

7. Invoice Verification

The system supports the checking and matching of invoices. The accounts payable clerk is notified of quantity and price variances because the system has access to PO and goods receipt data. This speeds the process of auditing and clearing invoices for payment.

Common Tables used by SAP MM

Below are few important Common Tables used in Materials Management Modules:

EINA Purchasing Info Record- General Data

EINE Purchasing Info Record- Purchasing Organization Data

MAKT Material Descriptions

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

MAST Material to BOM Link

MBEW Material Valuation

MKPF Header- Material Document

MSEG Document Segment- Material

MVER Material Consumption

MVKE Sales Data for materials

RKPF Document Header- Reservation

T023 Mat. groups

T024 Purchasing Groups

T156 Movement Type

T157H Help Texts for Movement Types

MOFF Lists what views have not been created

A501 Plant/Material

EBAN Purchase Requisition

EBKN Purchase Requisition Account Assignment

EKAB Release Documentation

EKBE History per Purchasing Document

EKET Scheduling Agreement Schedule Lines

EKKN Account Assignment in Purchasing Document

EKKO Purchasing Document Header

EKPO Purchasing Document Item

IKPF Header- Physical Inventory Document

ISEG Physical Inventory Document Items

LFA1 Vendor Master (General section)

LFB1 Vendor Master (Company Code)

NRIV Number range intervals

RESB Reservation/dependent requirements

T161T Texts for Purchasing Document Types

Tcodes:

RFQ to Vendor - ME41

Raising Quotation - ME47

Comparison of Price - ME49

Creation of PO - ME21N

Goods Receipt - MIGO

Invoice (Bill PAssing) - MIRO

Goods Issue - MB1A

Physical Inventory - MI01( Create doc)

MI04 (Enter Count)

MI07 (Post)

http://www.sapgenie.com/abap/tables_mm.htm

http://www.sap-img.com/sap-download/sap-tables.zip

http://www.allsaplinks.com/material_management.html

http://www.training-classes.com/course_hierarchy/courses/2614_SAP_R_3_MM_Invoice_Verification_-_Rel_...

http://www.sapfriends.com/sapstuff.html

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PSMAT/PSMAT.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCMM/CAARCMM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_MM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOMDMM/LOMDMM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMMM/BCBMTWFMMM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MMIVMVAL/MMIVMVAL.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MMWMLVS/MMWMLVSpdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MMISVE/MMISVE.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/PSMAT/PSMAT.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCMM/CAARCMM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_MM.pdf

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_MM.pdf

MM Process flow

The typical procurement cycle for a service or material consists of the following phases:

1. Determination of Requirements

Materials requirements are identified either in the user departments or via materials planning and control. (This can cover both MRP proper and the demand-based approach to inventory control. The regular checking of stock levels of materials defined by master records, use of the order-point method, and forecasting on the basis of past usage are important aspects of the latter.) You can enter purchase requisitions yourself, or they can be generated automatically by the materials planning and control system.

2. Source Determination

The Purchasing component helps you identify potential sources of supply based on past orders and existing longer-term purchase agreements. This speeds the process of creating requests for quotation (RFQs), which can be sent to vendors electronically via SAP EDI, if desired.

3. Vendor Selection and Comparison of Quotations

The system is capable of simulating pricing scenarios, allowing you to compare a number of different quotations. Rejection letters can be sent automatically.

4. Purchase Order Processing

The Purchasing system adopts information from the requisition and the quotation to help you create a purchase order. As with purchase requisitions, you can generate Pos yourself or have the system generate them automatically. Vendor scheduling agreements and contracts (in the SAP System, types of longer-term purchase agreement) are also supported.

5. Purchase Order Follow-Up

The system checks the reminder periods you have specified and - if necessary - automatically prints reminders or expediters at the predefined intervals. It also provides you with an up-to-date status of all purchase requisitions, quotations, and purchase orders.

6. Goods Receiving and Inventory Management

Goods Receiving personnel can confirm the receipt of goods simply by entering the Po number. By specifying permissible tolerances, buyers can limit over- and underdeliveries of ordered goods.

7. Invoice Verification

The system supports the checking and matching of invoices. The accounts payable clerk is notified of quantity and price variances because the system has access to PO and goods receipt data. This speeds the process of auditing and clearing invoices for payment.

SD:

Please check this links perhaps they may help.

http://www.sapgenie.com/sapfunc/sd.htm

http://www.sap-basis-abap.com/sapsd.htm

http://www.sapgenie.com/abap/tables_sd.htm

SD:

Inquiry -> Quotation ->Sales Order ->Delivery ->Invoice ->Return -> Credit memo

VA01 Create Sales/Returns Order

VA02 Change Order

VA03 Display Sales Order

VA11 Create Inquiry

VA12 Change Inquiry

VA13 Display Inquiry

VA21 Create Quotation

VA22 Change Quotation

VA23 Display Quotation

VA41 Create Contract

VA41 Change Contract

VA43 Display Contract

VF01 Create Billing Document

VF02 Change Billing Document

VF03 Display Billing Document

VF11 Cancel Billing Document

VF21 Create Invoice List

VF22 Change Invoice List

VF22 Display Invoice List

VK11 Maintain Pricing

VK15 Create Condition Records, Transaction used to enter multiple sales conditions (most will be entered here)

VL01N Create Delivery

VL02N Change Delivery

VL03N Display Delivery

Also check...