Regarding SD

Former Member · ‎04-23-2008

Could u give me the deails of tables in SD module along with its fields.Also the tcodes in SD module.

Plz mention some of the standard sapscript layout set and smartforms layout in SD.

Any replies will be highly appreciated.

Thanks ,

Priya Ranjan

Former Member · ‎04-23-2008

Tables:

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

Topic: Free ABAP eBook Download

SAP MM, SD, FI, PS, PP, PM, HR, System Tables

Sales Order Management Transactions

SALES ORDER PROCESSING

Creating Sales Order - VA01

Maintaining a Sales Order - VA02

Displaying a Sales Order - VA03

Releasing an Order or Delivery from Credit Hold: Non-Flooring - VKM1

Display List of RMAs by Customer - VA05

Confirm RMA Goods Receipt - VL02

Generate list of open return orders for deletion - VA05

Display Customer returns eligibility - MCSI

Removing a Billing Block (Approving Credit/Debit Requests) - V.23

PRICING MASTER DATA

Create Pricing - VK11

Creating a Sales Deal - VB21

Maintaining a Sales Deal - VB22

Displaying a Sales Deal - VB23

Maintaining Prices - VK12

Displaying Prices - VK13

MATERIAL MASTER DATA

Creating Material Substitution Master Data - VB11

Maintaining/Deleting Material Substitution Master Data - VB12

Displaying Material Substitution Master Data - VB13

Creating a Bundled Master - MM01

Creating a Sales BOM - CS01

Maintaining a Sales BOM - CS02

Displaying a Sales BOM - CS03

CUSTOMER MASTER DATA

Creating Partner Records - XD01

Maintaining Customer Master Data - XD02

Displaying Customer Master Data - XD03

Deactivating a Partner - VD06

CUSTOMER CREDIT INFO

Creating/Maintaining New Customer Credit Information - FD32

Displaying Customer Credit Information - FD33

Blocking or Unblocking a Customer - VD05

SHIPPING

Creating a Delivery - VL01N

Displaying a Delivery - VL03N

Deleting a Delivery - VL02N

Shipment Inquiry / Display - VT03

Adjusting Transfer Order - Confirmation Quantity - LT12

Collectively Confirm Transfer Order - LT25

Batch Shipment Confirmation - VL19

Creating Service Provider/Carrier Master Data - XK01

Maintaining Serive Provider/Carrier Master Data - XK02

Displaying Service Provider/Carrier Master Data - XK03

Maintaining Product Master/Serial # Profile/Unit of Measure/Shipping Unit - MM02

IDoc Inquiry - WE02 / WE05

BILLING

Invoicing a Customer Shipment - VF01

Reprinting an Invoice - VF31

Releasing a Sales Order for Billing - V.23

Creating an Invoice by Using the Billing Due List - VF04

Checking Open Billing Documents - VF05

Create Credit/Debit Memo - FB01

A/R

Controlling Total Debit/Credit bkgs - F.03

Generate FI Account balance - F.08

Generate Month-to-date Inv. register - F.02

Process payments - FBZ1

Rqst Individual Customer Corresp. - FB12

Generate Customer Correspondence - F.61

Enter Batch totals under Control ttl - FB07

Display G/L Acct. totals - FBL3N

Reverse Posted Amounts - FB08

Customer Refunds - FBL6

Customer Refund to other than Payer - FB05

Clearing Debit/Credit on Cust. acct. - FB1D

Customer Balance in Local Currency - F.23

G/L Account Balance Report - F.08

Create Invoice - legal entity adjust - FB01

Generate Cust. Acct. statements - F.27

Generate Dunning Letters - F150

Generate Billing Due List - VF04

Generate Blocked Billing Doc list - VFX3

Inq. via Credit Release Screen - VKM1

List orders by partner - VA05

Past Due invoices by customer - FD11

Check number info by G/L account - FBL3N

Display customer Line items - FBL5N

The most frequently used transaction codes are as follows:

1. VS00 - Master data

2. VC00 - Sales Support

3. VA00 - Sales

4. VL00 - Shipping

5. VT00 - Transportation

6. VF00 - Billing

Others as follows:

At Configuration:

1. VOV8 - Define Sales documents type (header)

2. OVAZ - Assigning Sales area to sales documents type

3. OVAU - Order reasons

4. VOV4 - Assign Item categoreies(Item cat determination)

5. VOV6 - Scedule line categories

6. OVAL - To assign blocks to relevant sales documents type

7. OVLK - Define delivery types

8. V/06 - Pricing

9. V/08 - Maintain pricing procedure

10.OVKP - Pricing proc determination

11.V/07 - Access sequence

Enduser:

1. Customer Master Creation-VD01 and XD01 (for full inclu company code)

VD02 - Change Customer

VD03 - Display Customer

VD04 - Customer Account Changes

VD06 - Flag for Deletion Customer

XD01 - Create Customer

XD02 - Modify Customer

XD03 - Display Customer

2. Create Other material -

MM00

3. VB11- To create material determination condition record

4. CO09- Material availability Overview

5. VL01 - Create outbound delivery with ref sales order

6. VL04 - Collective processing of delivery

7. VA11 - Create Inquiry

VA12 - Change Inquiry

VA13 - Display Inquiry

Regards,

Rajesh Banka

Former Member · ‎04-23-2008

Hi Priya,

Find the fallowing some tables avail in SD

SAP SD Tables

VBAK -

(SALES DOC HEADER)

VBAP -

(SALES DOC ITEM)

VBFA -

(SALES DOC FLOW)

VBUK -

(SALES DOC HEAD. STATUS)

VBUP -

(SALES DOC ITEM STATUS)

LIKP -

(DELIVERY HEAD DATA)

LIPS -

(DELIV ITEM DATA)

MSEG -

(MAT DOC SEGMENT)

MKPF -

(MAT.DOC)

VBRK -

(INV HEADER)

VBRP -

(INV ITEM)

BSEG -

(ACC DOC SEGMENT)

BKPF -

(ACC DOC HEADER)

KNA1 --- General Data in Customer Master

KNB1 --- Customer Master (Company Code Data)

KNVV --- Customer Master Sales Data

MARA --- General Material Data

MARC --- Plant Data for Material

MVKE --- Sales Data for Material

Also check below links

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

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

http://www.sap-img.com/sap-sd/link-between-sap-sd-mm-and-fi.htm

http://www.sap-basis-abap.com/sd/sap-sd-processing-flow.htm

SD Sales Cycle :

IN - QT - OR - LF - F2

In inquiry and quotation chances of converting into order are not 100%

once sale order is done means automatically delivery is done in normal sales cycle and once delivery is done at delivery level , picking , packing - PGI will be done

once after doing PGI , inventory level will be reduced at warehouse and G/L accounts will be updated

After delivery Billing takes place , once , billing is saved a billing document and accounting document gets generated .

After saving billing document we will pass it on to FI consultants

SD Transaction Code Flow:

Inquiry / Document type IN

Tcode for creation VA11,VA12,VA13. tables VBAK,VBAP

Quotation / QT

Tcode for creation VA21,VA22,VA23. tables VBAK,VBAP

Sales Order OR

Tcode for creation VA01,VA02,VA03. tables VBAK,VBAP

Delivery LF

Tcode for creation VL01,VL02,VL03. tables LIKP,LIPS

Billing F2

Tcode for creation VF01,VF02,VF03. tables VBRK,VBRP

Please Reward If Really Helful,

Thanks and Regards,

Sateesh.Kandula

Former Member · ‎04-23-2008

Hi

Please refer below

Customers KNA1 General Data

KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master – Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

Sales Documents VBAKUK VBAK + VBUK

VBUK Header Status and Administrative Data

VBAK Sales Document - Header Data

VBKD Sales Document - Business Data

VBUP Item Status

VBAP Sales Document - Item Data

VBPA Partners

VBFA Document Flow

VBEP Sales Document Schedule Line

VBBE Sales Requirements: Individual Records

SD Delivery DocumeLIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Billing Document VBRK Billing Document Header

VBRP Billing Document Item

SD Shipping Unit VEKP Shipping Unit Item (Content)

VEPO Shipping Unit Header

Sales related

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'.)

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)

VTTK: Shipment Table (Header Data)(TKNUM)

VTTP: Shipment Table (Item Data)( TKNUM,TPNUM,VBELN)

(VTTP-VBELN = LIKP-VBELN)

VTFA: Shipping Document Flow(TKNUM,VBELV,VBELN)

VTPA: Shipping Partners data(VBELN,PARVW,KUNNR,PERNR)

VTTS: Stages in Shipment(TKNUM,TSNUM,TSTYP)

VTSP: Transport Stage/Shipment Item Allocation(TKNUM,TSNUM,TPNUM)

VEKP: Handling Unit: Header(Packing)(VENUM,VSTEL)

VEPO: Handling Unit: Item (Packing)(VENUM,VEPOS,VBELN)

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.

VBUK: All Sales Documents status & Admn. Data(Header)(VBELN,VBTYP)

VBTYP= ‘C’(Sales Order) VBTYP=’J’(Delivery) VBTYP=’M’(Invoice)

VBUP: Sales Documents status & Admn. Data(Item)(VBELN,POSNR)

VBEP: Sales Doc. Schedule Lines Data(VBELN,POSNR,EDATU,WMENG)

VBKD: To get sales related Business data like Payment terms etc.(VBELN,ZTERM)

VBFA: sales document flow data(VBELV,VBELN,POSNV,VBTYP)

VBPA: Partner functions Data(VBELN,PARVW,KUNNR,LIFNR)

VEDA: Contract Data(VBELN,VPOSN)

VEDAPO: Contract Data(VB

Material Related

MARA--Material Master-General (MATNR,MTART,MATKL)

MARC--Material Master-Plant data(MATNR,WERKS,EKGRP)

MARD--Material Master- St.Location Data(MATNR,WERKS,LGORT,LABST)

MAKT--Material Descriptions(MATNR,MATKL,MAKTX)

MBEW--Material Valuation Data(MATNR,BWTAR)

MVKE—-Material Master: Sales related Data(MATNR,VKORG,VTWEG)

Customer related tables with Important fields

KNA1: Customer Master-General(KUNNR,NAME1,LAND1)

KNB1: Customer Master(Company Code)(KUNNR,BUKRS,PERNR)

KNC1: Customer Master Data (Transaction Figures)(KUNNR,BUKRS,GJAHR)

KNVK: Customer Master Contact Partner(PARNR,KUNNR,NAME1)

KNVV: Customer Master sales data(KUNNR,VKORG,VTWEG,KDGRP)

KNBK: Customer Bank Details(KUNNR,BANKS,BANKL,BANKN)

KNVH: Customer Hierarchy (HITYP,KUNNR,VKORG,VTWEG,SPART)

KNVP: Customer Master Partner Functions(KUNNR,PARVW,KUNN2)

KNVS: Customer Shipment data(KUNNR,VSTEL,TRANS)

KNVI: Customer Tax data(KUNNR,ALAND,TATYP)

Vendor related

LFA1--Vendor Master-General (LIFNR,NAME1,ORT01)

LFB1--Vendor Master(Company Code)(LIFNR,BUKRS,PERNR)

LFC1--Vendor Master (Transaction Figures)(LIFNR,BUKRS,GJAHR)

LFM1—-Pur.Orgn. Related Vendor Data (LIFNR,EKORG)

TCodes:

VA01 Create Sales Order

VA02 Change Sales Order

VA03 Display Sales Order

VA05 List of Sales Orders

VA05N List of Sales Orders

VA07 Compare Sales - Purchasing (Order)

VA08 Compare Sales - Purchasing (Org.Dt.)

VA11 Create Inquiry

VA12 Change Inquiry

VA13 Display Inquiry

VA14L Sales Documents Blocked for Delivery

VA15 Inquiries List

VA15N Inquiries List

VA21 Create Quotation

VA22 Change Quotation

VA23 Display Quotation

VA25 Quotations List

VA25N List of quotations

VA26 Collective Processing for Quotations

VA31 Create Scheduling Agreement

VA32 Change Scheduling Agreement

VA33 Display Scheduling Agreement

VA35 List of Scheduling Agreements

VA35N List of Scheduling Agreements

VA41 Create Contract

VA42 Change Contract

Billing

VF01 Create Billing Document

VF02 Change Billing Document

VF03 Display Billing Document

VF04 Maintain Billing Due List

FBL5N Display Customer invoices by line

FBL1N Display Vendor invoices by line

Delivery

VKM5 List of deliveries

VL01N Create Outbound Dlv. with Order Ref.

VL02N Change Outbound Delivery

VL03N Display Outbound Delivery

VL04 Process Delivery Due List

VL06 Delivery Monitor

VL06C List Outbound Dlvs for Confirmation

VL06D Outbound Deliveries for Distribution

VL06F General delivery list - Outb.deliv.

VL06G List of Oubound Dlvs for Goods Issue

VL06I Inbound Delivery Monitor

VL06IC Confirmation of putaway inb. deliv.

VL06ID Inbound Deliveries for Distribution

VL06IF Selection inbound deliveries

VL06IG Inbound deliveries for goods receipt

VL06IP Inbound deliveries for putaway

VL06L Outbound Deliveries to be Loaded

VL06O Outbound Delivery Monitor

VL06P List of Outbound Dlvs for Picking

VL06T List Outbound Dlvs (Trans. Planning)

VL06U List of Uncheckd Outbound Deliveries

VL08 Confirmation of Picking Request

VL09 Cancel Goods Issue for Delivery Note

VL10 Edit User-specific Delivery List

VL10A Sales Orders Due for Delivery

VL10B Purchase Orders Due for Delivery

VL31N Create Inbound Delivery

VL32N Change Inbound Delivery

VL33N Display Inbound Delivery

VT01N Create Shipment

VT02N Change Shipment

VT03N Display Shipment

VT70 Output for shipments

General

VKM3, VKM4 List of sales documents

VKM1 List of blocked SD documents

VD52 Material Determination

Standard reports in SD are:

Sales summary - VC/2

Display Customer Hierarchy - VDH2

Display Condition record report - V/I6

Pricing Report - V/LD

Create Net Price List - V_NL

List customer material info - VD59

List of sales order - VA05

List of Billing documents - VF05

Inquiries list - VA15

Quotation List - VA25

Incomplete Sales orders - V.02

Backorders - V.15

Outbound Delivery Monitor - VL06o

Incomplete delivery - V_UC

Customer Returns-Analysis - MC+A

Customer Analysis- Sales - MC+E

Customer Analysis- Cr. Memo - MC+I

Deliveries-Due list - VL04

Billing due list - VF04

Incomplete Billing documents - MCV9

Customer Analysis-Basic List - MCTA

Material Analysis(SIS) - MCTC

Sales org analysis - MCTE

Sales org analysis-Invoiced sales - MC+2

Material Analysis-Incoming orders - MC(E

General- List of Outbound deliveries - VL06f

Material Returns-Analysis - MC+M

Material Analysis- Invoiced Sales - MC+Q

Variant configuration Analysis - MC(B

Sales org analysis-Incoming orders - MC(I

Sales org analysis-Returns - MC+Y

Sales office Analysis- Invoiced Sales - MC-E

Sales office Analysis- Returns - MC-A

Shipping point Analysis - MC(U

Shipping point Analysis-Returns - MC-O

Blocked orders - V.14

Order Within time period - SD01

Duplicate Sales orders in period - SDD1

Display Delivery Changes - VL22

Regards

Edited by: Srikkanth k on Apr 23, 2008 2:38 PM

Former Member · ‎04-23-2008

There are a lot of tables in SAP SD. Please be more specific, which partof SD tables you are looking for like Sales, Pricing, Billing, deliveries.

Please refer to this link.

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

Regarding SD

Accepted Solutions (0)

Answers (4)

Answers (4)

Re: Stock Transfer between two EWM Managed plants ...

Re: Production Schedule Gantt Chart

Re: Sales analysis report query

Link TaxGL with book GL

Re: Use of Sequence into SAP B1 / SAP Business One