Pricing Tables

[Former Member]

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

[former_member227476 · Accepted solution]

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

[Former Member]

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

[Manoj_Mahajan78]

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

[Former Member]

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

[Former Member]

Hi

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

KOND

[Former Member]

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.

[Former Member]

hi,

pricing tables are KOMK,KOMV,KOMP.

sales-order-VBAK,VBAP.

delivery-LIKP,LIPS.

billing-VBRK,VBRP.

reward points

sriram.

[Former Member]

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.