SD TABLES

[Former Member]

hi friends,

Can anybody tell me the SD Table process Flow???

thanks

manu

[Former Member · Accepted solution]

Hi Manu,

sales order - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Delivery - Transaction VL01N - Tables LIKP, LIPS, VBUK, VBUP.

Goods issue - Transaction VL02N - Tables MKPF, MSEG

Billing document - Transaction VF01 - Tables VBRK, VBRP.

Customer is returning...

Return order - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Returns delivery - Transaction VL01N - Tables LIKP, LIPS, VBUK, VBUP.

Goods Receipt - Transaction VL02N - Tables MKPF, MSEG

Credit memo - Transaction VF01 - Tables VBRK, VBRP.

Customer wants some money back.

Credit memo request - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Credit memo - Transaction VF01 - Tables VBRK, VBRP.

Customer was charged less money ..Meaning we want some money back from customer..

Debit memo request - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

Debit memo - Transaction VF01 - Tables VBRK, VBRP.

Also please check this links.

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

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

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

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

Transaction Codes:

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)

Also please check this links.

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

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

Reward points if helpful,

Phani.

[jatin_singhal · Accepted solution]

Basic but still Nice Information. It helps.

[Former Member]

Hi,

just to add, try to understand the in a normal sales process what happens.... like a customer makes an inquiry for which we have IN- inquiry doc, then we give a quote - QT followed by the actual sales process. So the VBAK / VBAP / VBEP play an imp role here. foloowed by delivery LIKP, LIPS then billing VBRK, VBRP.

regards

sadhu kishore

[Former Member]

This might help:

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

Cheers.

[Former Member]

Hello,

The tables for Sales order process are:-

VBAK - Sales order Header

VBAP - Sales order Item

VBEP - sales order Schedule lines

KNA1 - Customer

KONV Conditions Pricing

KONP Conditions for Items

Delivery Processing:

LIKP Delivery Header Data

LIPS Delivery: Item data

Invoice Processing:

VBRK Billing: Header Data

VBRP Billing: Item Data

Prase

[Former Member]

hello, friend.

there are a minimum of 3 sets of tables involved in SD:

1. sales order header and item - VBAK and VBAP, respectively

2. delivery header and item - LIPS and LIKP, respectively

3. billing header and item - VBRK and VBRP, respectively

after SD billing is posted to accounting, look for table BSEG

table VBFA is for you to track the transaction flow (via created doc and subsequent doc, or if you wish an existing doc and referenced doc)

regards.

[Former Member]

Hello,

Could you please elaborate your question??? are you asking for SD tables?

Prase