on 09-07-2007 1:46 PM
TABLES IN SD
http://www.erpgenie.com/abap/tables_sd.htm
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 Document
LIPS 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
I need to capture data thats stored in the Sales delivery document header text for a report. In which table in SD is this stored.
Thank you
Kind regards
Prema
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
<b>customer related tables:</b>
KNA1 Customer master General Data
KNB1 Customer Master Co. Code Data
KNKK Customer Master Credit Control Area Data
KNVV Sales Area Data
KNVI Customer Master Tax Indicator
KNVP Partner Function
KNVD Output type
KNVS Customer Master Ship Data
KLPA Customer/Vendor Link
<b>Sales Documents</b>
VBAK Sales Document - Header Data
VBAP Sales Document - Item Data
VBUK Header Status and Administrative Data
VBKD Sales Document - Business Data
VBUP Item Status
VBPA Partners
VBFA Document Flow
VBEP Sales Document Schedule Line
VBBE Sales Requirements: Individual Records
<b>Delivery Document</b>
LIKP Delivery header table
LIPS Delivery item table
<b>Billing document:</b>
VBRK Billing document header table
VBRP Billing Document Item table
<b>Shipping</b>
VEKP Shipping Header Table
VEPO Shipping Item Table
<REMOVED>.
Regards,
Allabaqsh G. Patil
Message was edited by:
Yathish K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
Refer to the link below .. can get all the tables..
http://www.erpgenie.com/sap/abap/tables.htm
Reward if Useful
Thanx & regards.
Naren.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
dear kiran
 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
 MM - Tables
Material
MARA Material Master: General Data
MARC Material Master: C Segment
MARD Material Master: Storage Location/Batch Segment
MAKT Material Descriptions
MAPL Allocation of task lists to materials
MARV Material Control Record
MARM Units of Measure
MBEW Material Valuation
MOFF Outstanding Material Master Records
MSTA Material Master Status
MVER Material consumption
MVKE Material Master: Sales Data
MAPR Material Index for Forecast
PROP Forecast parameters
Logical databases: MSM
Material document
MKPF Header: Material Document
MSEG Document Segment: Material
BSIM Secondary Index, Documents for Material
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
 Purchasing - Tables
Purchasing 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
Purchase Requisition
PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data
PRTE Scheduling Data for Project Item
Logical databases: CNJ, PSJ, IMA
Purchasing info record
EINA Purchasing Info Record - General Data
EINE Purchasing Info Record - Purchasing Organization Data
EIPA Order Price History, Info Record
EIKP Export/import header data
EIPO Export/Import Item Data
KONH Conditions (Header)
KONP Conditions (Item)
KONM Conditions (1 Dimensional Quantity Scales)
KONW Conditions (1 Dimensional Value Scales)
Logical databases: IFM, ILM
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
<REMOVED>
siva
Message was edited by:
Yathish K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kiran,
Tables used in SD are
VBFA Document flow (alg.)
VTFA Flow shipping documents
VBAK Sales Header data
VBAP SAles Item data
VBPA Partners in sales order
VBKD Sales district data
VBEP Data related to line items, delivery lines
KNA1 Customer master
KNB1 Customer / company
KNVV Customer sales data
KNBK Bank details
KNVH Customer hierarchy
KNVP Customer partners
KNVS Shipment data for customer
KNVK Contact persons
KNVI Customer master tax indicator
VBRK Billing Header data
VBRP Billing Item data
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)
LIKP Delivery header
LIPS Delivery item
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
NAST Output Types
LFA1 Vendor master
LFB1 Vendor per company code
LFB5 Vendor dunning data
LFM1 Purchasing organization data
LFM2 Purchasing data
LFBK Bank details
KNMT Customer material info record
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
<REMOVED>.
Regards,
Priyanka
Message was edited by:
Yathish K
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Refer below
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.