10 Replies Latest reply: Sep 17, 2007 1:05 PM by bollapalli suseelarao RSS

SAP SD TABLES??

Currently Being Moderated

HI

SAP GURUS

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

At chandrakanth.nami@gmail.com

  • Re: SAP SD TABLES??
    Currently Being Moderated

    SENT MAIL REWARD IF HELPS

  • Re: SAP SD TABLES??
    Dasari Narendra
    Currently Being Moderated

    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

  • Re: SAP SD TABLES??
    ravi tagore
    Currently Being Moderated

    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

  • Re: SAP SD TABLES??
    Dittakavi Srinivas
    Currently Being Moderated

    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

  • Re: SAP SD TABLES??
    VijayaSateeshKumar Kandula
    Currently Being Moderated

    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

  • Re: SAP SD TABLES??
    Naveen Bathini
    Currently Being Moderated

    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.

  • Re: SAP SD TABLES??
    Rajesh Banka
    Currently Being Moderated

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

     

  • Re: SAP SD TABLES??
    Rajesh Banka
    Currently Being Moderated

    email sent.

     

    Regards,

    Rajesh Banka

     

    reward suitable points.

  • Re: SAP SD TABLES??
    ravi tagore
    Currently Being Moderated

    its a little strange and surprising always to find that you always give points to the person immediately next to you ( Sheshagiri ). Always award him " 10 " points" mmmm

     

    <b>this is some thing really disturbing. This is a forum where people contribute with interest and enthu.. pl dont spoil it.</b>

     

    I have checked already most of your questions being awarded 10 points and he is immediately next to you. And dont force me to paste the links of all those questions.

     

    Its to safeguard the interest and enthu of many SDN admirers that i had to resort to this.

Actions