Integration b/n MM and SD

[Former Member]

Hi Friends,

Please can anybody detail integration points b/n MM Module and SD Module?

(also specify the underlying databse table names and fields with detail) .

Regards

Srinivas

[Former Member · Accepted solution]

Hi Sree,

Post your mail id, i will send documentation on integration.

Regards

Ali

[Former Member · Accepted solution]

Hi Ahmad,

My mail ID:sreenivaschintam@gmail.com

Thanks in advance.

Regards

Sreenivas

[Former Member · Accepted solution]

Hi Sree,

Mail sent.

Regards

Ali

[Former Member]

Thank you.

[Former Member]

Hi,

1. In VA01 when we create the sales order the system fetches the item data from the material master which we create in MM01. Here the tables concerned are "MARA" "MARC"

2. In Availability check & TOR there is integration of SD & MM as far as availability of raw material is concerned.

3. In delivery creation we require the shipping point in which the loading group is fetched from the material master record. The shipping conditions are fetched from tne customer master data. The tables-fields effected are "MARC-LADGR", "KNVV-VSBED"

4. Movement type: For every movement of goods in SAP there is a movment type assigned for the transaction taking place. For schedule lines the tables-fields updated are V_TVEP-BWART.

Reward points if solution helps.

Regards,

Allabaqsh G. Patil

[Former Member]

The link between SD and MM: -

1. When you create sales order in SD, all the details of the items are copied from Material master of MM.

2. MRP and availability check related data is also taken from MM although you control this data in SD also.

3. While you create inbound/outbound delivery with reference to a sales order, the shipping point determination takes place with the help of the loading group, plant data, shipping conditions etc. This also refers to Material Master.

4. The material which you are entering in a sales order must be extended to the sales area of your sales order/customer otherwise you cannot transact with this material.

[Former Member]

hi,.

<b>intregration b/w SD & MM</b>

Looking at MM and SD interaction first, take the scenario of a third party order process. This process uses a purchase order (which is sent to your vendor). Also invoice verification is used further along the process to check that the invoice you send to your customer is the same material and quantity as that which the vendor sends to you (but obviously shipped directly to your customer).

The link between SD and MM :-

1. When you create sales order in SD, all the details of the items are copied from Material master of MM.

2. MRP and availibility check related data is also taken from MM although you control this data in SD also.

3. While you create inbound/outbound delivery with reference to a sales order,the shipping point determination takes place with the help of the loading group, plant data, shipping conditions etc. This also refers to Material Master.

4. The material which you are entering in a sales order must be extended to the sales area of your sales order/customer otherwise you cannot transact with this material.

There are many such links between SD and MM.

regards,

Arun prasad

[Former Member]

Hi

Refer below and pls make a search on sdn forum there are no of threads on same issue

1. When you create sales order in SD, all the details of the items are copied from Material master of MM.

2. MRP and availibility check related data is also taken from MM although you control this data in SD also.

3. While you create inbound/outbound delivery with reference to a sales order,the shipping point determination takes place with the help of the loading group, plant data, shipping conditions etc. This also refers to Material Master.

4. The material which you are entering in a sales order must be extended to the sales area of your sales order/customer otherwise you cannot transact with this material.

There are many such links between SD and MM.

SD Tables:

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

KONV Conditions for Transaction Data

KONP Conditions for Items

LIKP Delivery Header Data

LIPS Delivery: Item data

VBAK Sales Document: Header Data

VBAP Sales Document: Item Data

VBBE Sales Requirements: Individual Records

VBEH Schedule line history

VBEP Sales Document: Schedule Line Data

VBFA Sales Document Flow

VBLB Sales document: Release order data

VBLK SD Document: Delivery Note Header

VBPA Sales Document: Partner

VBRK Billing: Header Data

VBRP Billing: Item Data

VBUK Sales Document: Header Status and Administrative Data

VBUP Sales Document: Item Status

VEKP Handling Unit - Header Table

VEPO Packing: Handling Unit Item (Contents)

VEPVG Delivery Due Index

MM Tables:

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

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

Message was edited by:

SHESAGIRI.G