on 09-25-2008 11:43 AM
hi every body,
i want to know what is the tables in SAP and what its function and its mean
Hi Asmaa,
In general talk you can say table is a database where all the information you create get saved.
So whenever you use your master data like customer master, organization data & document data its's fetch from that database.
Every field has table & every table have number field.
There are thousond of table in sap.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Asmaa
Table Name Description
TVSWZ Shipping Point for Plant
TVKWZ Sales area for Plant
T001L Sloc Creation
TSTC Transaction name
T001W Create Plant
J_1ITEXCDTL Excise Detail
J_1IRG23D Excise Register exc. Stock updation
J_1ISRGRPS Series Groups
J_1IEXGRPS Excise Groups
KNA1 Customer master data without company code
KNVV Customer master data without company code
KNB1 Customer master data with company code
KNVP Customer sales area relationship
KNVK Customer license validation
KNVA Customer unloading point
TRKREGTIMECHECK Truck Register Time Check
TRUKVAL Truck capacity check
FRIEGHT INV Pre printed frieght invoice
J_1IEXCHDR Header detail for excise invoice
J_1IMOCOMP Plant Excise data
SE10 Transport to ABAP Request
J_1IMOCUST ZCME data store
ADRC Change adress at Company code
RSTXPDFT4 PDF Program in SE38
VBAK & VBAP Order Checking
VBRK & VBRP Billing ( Hearder & iterm )
TNAPR View program & form type for invoice printing
T683 / T683S Pricing procedure
T001W Internal customer assign to plant
J_1IEXCHDR Header Details
J_1IEXCDTL Item detail
TM01 Truck Master ( Create )
XK01-02-03 Create / displ./ change vendore
T001 Compny Code detail
LIPS Delivery detail
LIPS 01 & 02 Delivery
EKKO Sto related
EKPO Sto related
A947 Condition type
J_1IEXCDIL To see del. Bill. Inv. Table
MARA Genaral detail plant against mat. & profit center
MBEW Material valution area
MARD Material plant sloc
MARC Material plant combination with sloc.
T683V pricing procedure
KNB1 Company code data
KNVV Sales Area Data
MCH1 to find batches of material
MCHA Material -Plant -Batch- Valuation Type
MCHB Material- S.Loc. - Stock
EKKO To View Perchasing Document
J_1IMTCHID Material Chapter Id Combination
j_1IMOCOMP Excise tax indicator for Plant
J_1IMOCUST Excise tax indicator for Costomer
J_1IVTXRAT excise tax rate
J_1IEXESTA Excise indicator Determination
TVKOS Assign division to sales organization
TVTA Set up sales area
TVKBZ Assign sales office to sales area
V_T683V Pricing Procedure Assgnment to Sales Area
V_TVKD Costomer Pricing procedure
V_TVKV Document Pricing Procedure
V_TVAK_PR Assign Priging procedure to Sales Doc. Type
J_1IMTCHID Material Chapter Id Combination
_1IMOCOMP Excise tax indicator for Plant
J_1IMOCUST Excise tax indicator for Costomer
J_1IVTXRAT excise tax rate
J_1IEXESTA Excise indicator Determination
UST12 For authorisation profile
AGR_1016 Authorisation list
T030 G/L account maintain
J_1IWRKCUS maintain excise registration id to plant
TSTC To see transaction & programe
NRIV Excise setting
T683 create batch search procedure----
-
Logistics - General-Batch Management-Batch Determination and Batch Check-Batch Search Procedure Definition-Define Sales and Distribution Search Procedure
T683S batch search procedure----
-
Logistics - General-Batch Management-Batch Determination and Batch Check-Batch Search Procedure Definition-Define Sales and Distribution Search Procedure
T683T PRICI.PROCE. AGAINST CONDI TYPE DESCRIPTION-for batch search----
-
Logistics - General-Batch Management-Batch Determination and Batch Check-Batch Search Procedure Definition-Define Sales and Distribution Search Procedure
T683C PLANT ,, SALES AREA AGAINST BATCH TICKMARK
T683V ASSIN SALES AREA TO PRICING PROCEDURE
T683U MAINTAIN PRICI.PROCEDURE $ LANGUAGE----
-
Logistics - General-Batch Management-Batch Determination and Batch Check-Batch Search Procedure Definition-Define Sales and Distribution Search Procedure
TVCPF COPY CONTROL DELIVERY DOCUT, TYPE TOBILLING TYPE----
-
Sales and Distribution-Billing-Billing Documents-Maintain Copying Control For Billing Documents
TVCPL COPY CONTROL SALES DOCUT, TYPE TODELIVERY TYPE----
-
Sales and Distribution-Billing-Billing Documents-Maintain Copying Control For Billing Documents
T184 SALES DOCU. TYPE AGAINST ITEM CATEGORY TYPE & GROUP ASSIGN
TVAKZ ASSIGN SALES.DOCU.TYPE TO SALES AREA.
TVAP CREATE ITEM CATEGORY.
TPTM CREATE ITEM CATEGORY GROUP
TVAPT CREATE ITEM CATEGORY.
TVCPA COPY CONTROL SALES DOCUT, TYPE TO SALES DOCUT
TVEP CREATE SCHEDULING CATEGORY -
-
Sales and Distribution-Sales-Sales Documents-Schedule Lines-DEFINE Schedule Line Categories
TVEPZ ITEM CATEGORY AGAINST MRP TYPE,& SCHEDULE LINE TYPE assign----
-
Sales and Distribution-Sales-Sales Documents-Schedule Lines-Assign Schedule Line Categories
TVKWZ SALES AREA ASSIGN TO PLANT
TVSWZ PLANT AGAINST SHIPPING POINT
T685 CREATE CONDITION TYPE
T685A CREATE CONDITION TYPE IN DETAIL
T685T CREATE CONDITION TYPE IN DETAIL WITH LANGUAGE
TVAK SALES DOCU TYPE MAINTAIN IN DETAIL
TVAKT SALES DOCU TYPE MAINTAIN WITH LANGUAGE
TVAPT CREATE ITEM CATEGORY WITH DETAIL
T001 COMPANY CODE TABLE
T001W PLANT TABLE
T001L PLANT AGAINST STORAGE LOCATION -
-
MBSC
ADRC COMPANY ADDRESS IN INVOICE
TVLP Logistics - General-Batch Management-Batch Determination and Batch Check-Batch Search Procedure Allocation and Check Activation-Activate Automatic Batch Determination in SD-
T134 DEFAULT VALUE MATERIAL TYPE TO ITEM CATEGORY GROUP
TVST SHIPPING POINT ADDRESS
TVSTT SHIPPING POINT CREATE
TVSTZ SHIPPING POINT DETERMINATION
CEPC PROFIT CENTER (FM)
TVLP delivery item category table
TPAKD For Pd, Sh. Gp, Sp Agains Account Group
MCHA Expiry date in Invoice & batches
TVZBT Terms of Payment in invoice
J_1IREGSET REG23D Setting for duty LIKE CESS.H.EDU.CESS
VBPA to view partner function
SADR Address Detail
VBRL Item Invoice List
TVKO Sales organisation detail
T001K Valuation area
TVSBT Shipping Conditions: Texts
T005T Country Names
T005U Taxes Region Key
VBFA Sales Document flow
NAST Message Status
KONV Condition Transaction Data
CEPC CO AREA AGAINST PROFIT CENTER
KNVP SALES ORG. AGAINST CUSTOMER
J_1IEXESTA custo. & plant excise indi.
J_1IEXCACC EXCISE GROUP AGAINST G/L ACCOUNT
MVKE SALES AREA AGAINST MATERIAL
MARV Change closing period
T161W supplying & receiving plant maint. During STO
J_1IEXCTAX Excise tax rate maintain against C.I.
T005G Country code region & city code
Sales Documents
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
Customers KNA1 General Data
KNB1 Customer Master u2013 Co. Code Data (payment method, reconciliation acct)
KNB4 Customer Payment History
KNB5 Customer Master u2013 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
Hope this will help you.
Thx
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Tabular array of data in the ABAP Dictionary is called Table.
In general talk you can say table is a database where all the information you create get saved.
So whenever you use your master data like customer master, organization data & document data its's fetch from that database.
Every field has table & every table have number field.
There are thousond of table in sap.
Click on the below link for different Tables in SAP
http://www.sap-img.com/general/sap-r3-tables.htm
Regards,
PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Tabular array of data in the ABAP Dictionary is called Table.
A table consists of columns (data values of the same type) and rows (data records). Each record can be identified uniquely by one or several fields.
The data (Organisational, master and transactional data) in SAP is stored in tables
Eg: Some SD tables: VBAK, VBAP, VBBE, VBEP...etc
Prase
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
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.