cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SD TABLES??

Former Member
0 Kudos

HI

SAP GURUS

Can any send pdf. Or document on SAP SD common tables

At chandrakanth.nami@gmail.com

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

SENT MAIL REWARD IF HELPS

Answers (7)

Answers (7)

Former Member
0 Kudos

email sent.

Regards,

Rajesh Banka

reward suitable points.

Former Member
0 Kudos

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

Topic: Free ABAP eBook Download

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

Regards,

Rajesh Banka

Reward suitable points.

  • How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

Former Member
0 Kudos

Dear Chandrakanth,

Tables:

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

KNA1 General Data in Customer Master

KNAS Customer master (VAT registration numbers

KNAT Customer Master Record (Tax Groupings)

KNB1 Customer Master (Company Code)

KNB4 Customer Payment History

KNB5 Customer master (dunning data)

KNBK Customer Master (Bank Details)

KNBW Customer master record (withholding tax ty

KNC1 Customer master (transaction figures)

KNC3 Customer master (special G/L transaction f

MARA General Material Data

MARC Plant Data for Material

MARD Storage Location Data for Material

KONA Rebate Agreements

KONAIND Index: Groups of Conditions/Header Record

KONBBYH Bonus Buys: Header

KONBBYPRQ Bonus Buys: Prerequisites

KONBBYT Bonus Buys: Text

KOND Conditions (Data)

KOND3 Conditions: Campaign Determination - Data

KONDD Material Substitution - Data Division

KONDDP Conditions: Additional Materials for Mater

KONDH Conditions: Batch Strategy - Data Division

KONDI Conditions: Data part for certificates

KONDIND General Document Index for Conditions

KONDN Conditions: Free goods - Data section

KONDNS Conditions: Free goods determination - sca

KONDP Conditions: Packing Object Data Section

KONDR Conditions: Derivation strategy - data par

KONDRPR Conditions: Derivation strategy - recipien

KONDRPS Conditions: Derivation strategy - sender i

KONDV Conditions: Data part for certificates

KONH Conditions (Header)

KONHM Portfolio Determination - Data Part

KONM Conditions (1-Dimensional Quantity Scale)

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

Tables, Programs, TCodes:

http://www.erpgenie.com/saptech/transactions.htm

Reports:

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

Hope this will help.

Regards,

Naveen.

Former Member
0 Kudos

please send it to my mail id suseelarao_bl@yahoo.com

Former Member
0 Kudos

Hi Chandrakanth,

In addition to above pl find some more stuff on this:

KONAIND Index: Groups of Conditions/Header Record Conditions

KOND Conditions (Data)

KOND3 Conditions: Campaign Determination - Data Part

KONDD Material Substitution - Data Division

KONDDP Conditions: Additional Materials for Material Determination

KONDH Conditions: Batch Strategy - Data Division

KONDI Conditions: Data part for certificates

KONDIND General Document Index for Conditions

KONDN Conditions: Free goods - Data section

KONDNS Conditions: Free goods determination - scales

KONDP Conditions: Packing Object Data Section

KONDR Conditions: Derivation strategy - data part

KONDRPR Conditions: Derivation strategy - recipient item data

KONDRPS Conditions: Derivation strategy - sender item data

KONDV Conditions: Data part for certificates

KONH Conditions (Header)

KONM Conditions (1-Dimensional Quantity Scale)

KONP Conditions (Item)

KONV Conditions (Transaction Data)

KONW Conditions (1-Dimensional Value Scale)

KOTN900 LSI Free Goods Condition Table

Please Reward If Really Helpful,

Thanks and Regards,

Sateesh.Kandula

Former Member
0 Kudos

Hi chandrakanth,

PL go thr below links:

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

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

Reward points if it helps

Regards

Srini

Former Member
0 Kudos

hi,

Important Tables for SAP SD

Sales and Distribution:

Table Description

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

regards

Former Member
0 Kudos

hi

chk the link below.. u can get all the info of SAP Tables

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

Reward If Useful

Thanx... Naren