on 08-07-2007 1:46 PM
Hi gurus,
Can u tell the Table name and Field name for Goods issue date in Agreement document.
thanks all.
Hi
This list of SD 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
<b>Use the site : http://www.erpgenie.com/abap/tables_sd.htm.
Reward if it helps</b>
Regards
Prasanna R
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<u><b>Enterprise structure</b></u>
<b>Definition</b>
<i><u>FI</u></i>
T880 Company
T001 Company code
<u><i>CO</i></u>
TKA01 Controlling area
<i><u>LO</u></i>
T001W Plant / sales organisation
T499S Locations
TSPA Division
<i><u>SD</u></i>
TVKO Sales organisation / company code
TVTW Distribution channel
TVBUR Sales office
TVKBT Sales office text
TVKGR Sales group
TVGRT Sales group text
T171T Sales district text
<i><u>MM</u></i>
T001L Storage locations
T024E Purchasing organization
T3001 Warehouse number
TVST Shipping point
TVLA Loading point
TTDS Transportation
<b>Assignment</b>
<i><u>CO</u></i>
TKA02 Assign company code to controlling area
<i><u>LO</u></i>
T001K Assign plant (valuation area) to company code
<i><u>SD</u></i>
TVKO Sales organisation / company code
TVKOV Distribution channel / sales organisation
TVKOS Division to sales organization
TVTA Sales aria
TVKBZ Sales office to sales area
TVBVK Sales group to sales office
TVKWZ Plants to sales organization
<i><u>MM</u></i>
T024E Purchasing organization / company code
T024W Plant to Purchase organization
T001K Link plant ( = valuation area) / company code
TVSWZ Shipping point to plant
T320 Assignment MM Storage Location to WM Warehouse
<b>Workbench</b>
TSTC Transaction codes in SAP
TSTCT Transaction codes texts
<b>Material master</b>
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
<b>Customer master data</b>
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
<u><b>Sales and Distribution (SD)</b></u> :
VBFA Document flow (alg.)
VTFA Flow shipping documents
<b>Sales order</b> :
VBAK Header data
VBAP Item data
VBPA Partners in sales order
VBKD Sales district data
VBEP Data related to line items, delivery lines
<b>Billing document</b> :
VBRK header data
VBRP Item data
<b>Shipping</b> :
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)
<b>Delivery</b> :
LIKP Delivery header
LIPS Delivery item
<b>Pricing</b> :
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
KOND
<b>contracts</b> :
VEDA Contract data
Regards,
Rajesh Banka
Reward points if helpful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
http://www.sap-img.com/abap.htm for all types of tables for sd and mm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Go through the site
Important Tables for SAP SD
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you can find out your self any such of information...
On the field press F1 and see the technical details. If it is Table you can see directly in field data in the table, if it is structure then you will require to search table in the structure.
Or you can use transaction SE16 press F4
you will get Input Help Personal Value list... Down tool bar Press on SAP Application
here you will get list of application componenets
Select appropriate Application e.g. SD and get the table details...
from the table you can get the field details..
Hope is helpfult to search your self any table name and field name.
Hi
Goods Issue. Table Name Field Name
VBEP WADAT: Planned Goods Issue.
VBAP MATNR:Material
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
WADAT - goods issue date Field name..
VBAK Header
VBAP Item
VBEP Schedule Lines
VBPA Partner Details
VBUK Header Status
VBUP Item Status
LIKP Header
LIPS Item
VBRK Header
VBRP Item
MAKT Material Descriptions
MARA General Data
MARM Units of Measure
MVKE Material Master: Sales Data
MLAH Tax Classification
KNVV Customer Master_SalesArea_Sales Data
KNVD Customer Master_SalesArea_RecordSales
KNVP Customer Master_SalesArea_Partner Functions
KNB1 Customer Master_CompanyCodeData
KNB5 Customer Master_CompanyCodeData_DunningData
KNA1 Customer Master_General Data
KNVI Customer Master Tax Indicator
AVIK Payment Advice - Header Data
AVIP Payment Advice - Item Data
BSIS Open Items - payments
BSAS Closed Items - payments
LFM1 Vendor Master_PurchasingData_OrgData
LFM2 Vendor Master_PurchasingData
LFA1 Vendor Master_General Data
LFA2 Vendor Master_General Data_BankDetails
LFB1 Vendor Master_CompanyCode
LFB2 Vendor Master_CompanyCode_DunningData
VAPMA List of All Sales Orders plantsalesareadate
-
-
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 Docume 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
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.
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.
User | Count |
---|---|
99 | |
11 | |
10 | |
6 | |
5 | |
5 | |
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.