on 07-19-2007 9:29 AM
HI
SAP GURUS
Can any send pdf. Or document on SAP SD common tables
At chandrakanth.nami@gmail.com
SENT MAIL REWARD IF HELPS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
email sent.
Regards,
Rajesh Banka
reward suitable points.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
68 | |
14 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.