cancel
Showing results for 
Search instead for 
Did you mean: 

tables

Former Member
0 Kudos

hi every body,

i want to know what is the tables in SAP and what its function and its mean

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (3)

Answers (3)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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