Skip to Content
author's profile photo
Former Member

Pricing Tables

Hi,

Can any one help me in providing sutiable answers

What are all the tables used in Pricing.

The tables used in Sales, delivery, Billing and Shipping related tables.

Regards,

M.Kannan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

8 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:26 AM

    dear kannan

     SD - Tables

    Customer

    KNA1 Customer Master (General Data)

    KNB1 Customer master (company code)

    KNC1 Customer master (transaction figures)

    KNVV Customer Master (Sales Data )

    KNVA Customer Master Loading Points

    KNVI Customer Master Tax Indicator

    KNAS Customer master (VAT registration numbers general section)

    KNB4 Customer payment history

    KNB5 Customer master (dunning data)

    KNBK Customer master (bank details)

    KNC3 Customer master (special G/L transaction figures)

    KNKA Customer master credit management: Central data

    KNKK Customer master credit management: Control area data

    KNMT Customer-Material Info Record Data Table

    KNMTK Customer-Material Info Record Header Table

    KNVD Customer master record sales request form

    KNVK Customer Master Contact Partner

    KNVL Customer Master Licenses

    KNVP Customer Master Partner Functions

    KNVS Customer Master Shipping Data

    KNVT Customer Master Record Texts for Sales

    Logical databases: DDF

    Sales Document

    VBAK Header Data

    VBAP Item Data

    VBEP Schedule Line Data

    LIKP Delivery Header Data

    LIPS Delivery: Item data

    VBRK Billing: Header Data (invoice)

    VBRP Billing: Item Data (invoice)

    VBAG Release Data by Schedule Line in Sch.Agrmt.

    VBUK Header Status and Administrative Data

    VBUP Item Status

    VBRL SD Document: Invoice List

    VBPA partner

    VBKD Business Data

    VBKA Sales activities

    VBFA Sales Document Flow

    Logical databases: AAV, AKV, ARV, VFV

    Sales requirements

    VBBE Sales Requirements: Individual Records

    VBBS Sales Requirement Totals Record

    Logical databases:

    Other

    KONV Conditions

    KONH Conditions Header

    KONP Conditions Items

    KOND

    rewards pls

    siva

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 09:59 AM

    Hi,

    pricing tables:

    konh-conditions header

    kond-condition data

    konm-conditions(dimentionality sclae)

    konp-conditions item

    konv-conditions trasactional data

    Sales documents:

    sales header:vbak

    sales item :vbap

    schedulines:vbep

    delivery doc:

    delivery header:vblk

    delivery item:vblp

    billing doc:

    billing header:vbrk

    billing item:vbrp

    if it helps pls do reward points.

    thanks&regards

    veera.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:02 AM

    hi,

    pricing tables are KOMK,KOMV,KOMP.

    sales-order-VBAK,VBAP.

    delivery-LIKP,LIPS.

    billing-VBRK,VBRP.

    reward points

    sriram.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:08 AM

    Hi Kannan,

    KONV Conditions for Transaction Data

    KONP Conditions for Items

    KOND Conditions (Data)

    KONH Conditions (Header)

    KONM Conditions

    A000 Condition Table for Pricing $

    T684 Condition Exclusion Groups

    T684G Condition Exclusion Groups: Condition Types

    T684S Condition Exclusion: Procedure Assignment

    T689 Download Profile for the Conditions

    T689K Reference: Download Profile - Pricing Procedures

    Reward points pls.

    Regards,

    Govind.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:10 AM

    Hi

    KONH Conditions header

    KONP Conditions items

    KONV Procedure ( billing doc or sales order)

    KOND

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:14 AM

    hi

    1.KONH Conditions header

    2.KOND condition data

    3.KONP Conditions items

    4.KONV Procedure ( billing doc or sales order)

    5.Axxx- condition record tabel

    eg: A304- is table for condition record for material with release status

    A305, a306,a074....it goes on

    regards,

    Arun prasad

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 28, 2007 at 10:20 AM

    Kannan,

    Pricing Tables are-

    KOMK,KOMV,KOMP

    KONV Conditions for Transaction Data

    KONP Conditions for Items

    KOND Conditions (Data)

    KONH Conditions (Header)

    KONM Conditions

    T684 Condition Exclusion Groups

    T684G Condition Exclusion Groups: Condition Types

    T684S Condition Exclusion: Procedure Assignment

    T689 Download Profile for the Conditions

    T689K Reference: Download Profile - Pricing Procedures

    REWARD IF U FINDS THIS AS USEFUL...

    Regds

    MM

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 12:20 PM

    Hi Kannan,

    Please find below the Tables Related to SD, MM and FI/CO :

    SD TABLES:

    Important Tables for SAP SD

    Sales and Distribution:

    Customers : Table Description

    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

    Material Master:

    MARA Material master

    MAKT Material text

    MARC Material per plant / stock

    MVKE Material master, sales data

    MARD Storage location / stock

    MSKA Sales order stock

    MSPR Project stock

    MARM Units of measure

    MEAN International article number

    PGMI Planning material

    PROP Forecast parameters

    MAPR Link MARC <=> PROP

    MBEW Material valuation

    MVER Material consumption

    MLGN Material / Warehouse number

    MLGT Material / Storage type

    MPRP Forecast profiles

    MDTB MRP table

    MDKP Header data for MRP document

    MLAN Tax data material master

    MTQSS Material master view: QM

    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

    VBKA Sales activities

    VBFA Sales Document Flow

    Logical databases: AAV, AKV, ARV, VFV

    Sales requirements

    VBBE Sales Requirements: Individual Records

    VBBS Sales Requirement Totals Record

    SD Delivery Documents:

    LIPS Delivery Document item data, includes referencing PO

    LIKP Delivery Document Header data

    Shipping:

    VTTK Shipment header

    VTTP Shipment item

    VTTS Stage in transport

    VTSP Stage in transport per shipment item

    VTPA Shipment partners

    VEKP Handling Unit - Header Table

    VEPO Packing: Handling Unit Item (Contents)

    VTFA Flow shipping documents

    Billing Document:

    VBRK Billing Document Header

    VBRP Billing Document Item

    SD Shipping Unit VEKP Shipping Unit Item (Content)

    VEPO Shipping Unit Header.

    Pricing:

    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

    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

    Bill of Material:

    MAST Material to BOM Link

    EQST Equipment to BOM Link

    STAS BOMs header

    STKO BOM header

    STPN BOM follow-Up control

    STPO BOM item

    STPU BOM sub-item

    STST Standard BOM link

    STVB Bills of material - Serialization of posting

    STZU Permanent BOM data

    MM Tables:

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

    PURCHASE DOCUMENT:

    EKAN Vendor Address: Purchasing Document

    EKBE History of Purchasing Document

    EKBZ History of Purchasing Document - Delivery Costs

    EKET Delivery Schedules

    EKKN Account Assignment in Purchasing Document

    EKKO Purchasing Document Header

    EKPO Purchasing Document Item

    EKPB "Material Provided" Item in Purchasing Document

    EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item

    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

    Vendor master:

    LFA1 General section

    LFAS VAT registration numbers general section

    LFB1 Company code

    LFB5 Dunning data

    LFBK Bank details

    LFC1 Transaction figures

    LFC3 Special G/L transaction figures

    LFM1 Record purchasing organization data

    Logical databases: KDF

    FI/CO - Tables

    Profit center hierarchy

    CEPC Profit Center Master Data Table

    Accounting

    BSAD Accounting: Secondary index for customers (cleared items)

    BSID Accounting: Secondary index for customers

    BSIW Index table for customer bills of exchange used

    BSIX Index table for customer bills of exchange used

    BSAK Accounting: Secondary index for vendors (cleared items)

    BSIK Accounting: Secondary index for vendors

    BSIP Index for vendor validation of double documents

    BSAS Accounting: Secondary index for G/L accounts (cleared items)

    Accounting documents

    BKPF Accounting document header

    BSEG Accounting document segment

    BSET Tax data document segment

    BSEC One-time account data document segment

    Logical databases: BRM

    Cost elements, centers, activities

    CSKA Cost elements (data dependent on chart of accounts)

    CSKB Cost elements (data dependent on controlling area)

    CSKS Cost center master

    CSKT Cost center texts

    CSKU Cost element texts

    CSLA Activity master

    CSLT Activity type texts

    CSSK Cost center /cost element

    CSSL Cost center / activity

    Logical databases: -

    General ledger accounts

    SKA1 G/L accounts master (chart of accounts)

    SKAS G/L account master (chart of accounts: key word list)

    SKAT G/L account master record (chart of accounts: description)

    SKB1 G/L account master (company code)

    SKM1 Sample G/L accounts

    SKMT Sample account names

    SKPF Header Data: Inventory Sampling

    Tables:

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

    SD Tables:

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

    Please Reward If Really Helpful,

    Thanks and Regards,

    Sateesh.Kandula

    Add comment
    10|10000 characters needed characters exceeded