SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

47 columns | Print definition?ERP 6.0  | TEXT40

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DVKTXR/2-R/3 Link: Delivery texts R2 -> R347TEXT40Text R/2-R/3 Linknvarchar720
2TCA09TLanguage-dependent table for TCA09: Task list applications4TEXT40Text, 40 Characters Longnvarchar400
3TCA9TLanguage-dependent table for TCA09: Task list applications4TEXT40Usage area descriptionnvarchar400
TOPBasic Functions
4T059OOfficial withholding tax key - Descriptions4TEXT40Text, 40 Characters Longnvarchar400
5T059OTText table: Official withholding tax key descriptions5TEXT40Text, 40 Characters Longnvarchar400
6T059UText Table: Withholding Tax Types5TEXT40Text, 40 Characters Longnvarchar400
7T059ZTText table: Withholding tax codes6TEXT40Text, 40 Characters Longnvarchar400
8WITH_CTNCOKEYTXTTexts: Withholding tax certificate numbering concepts3TEXT40Text, 40 Characters Longnvarchar400
TOPContract Billing
9TE272TReasons for Reversal (Texts)4TEXT40Text, length 40nvarchar400
10TE304TKey: Pressure-Temperature Ratio Joule-Thomson Effect4TEXT40Text, 40 Characters Longnvarchar400
11TE307TTemperature Area (Texts)4TEXT40Text for temperature areanvarchar400
12TE309TAir Pressure Area (Txts)4TEXT40Text, length 40nvarchar400
13TE343TGas Pressure Areas (Texts)4TEXT40Text, length 40nvarchar400
14TE434TCategory of Enhanced Interval Procedure (Text)4TEXT40Text for Category of Enhanced Interval Procedurenvarchar400
15TE435TText for Type of Enhanced Interval Procedure4TEXT40Text for Type of Enhanced Interval Procedurenvarchar400
16TE453TCal.Val.Districts (Txts)4TEXT40Text, length 40nvarchar400
17TE471TRental Price Levels (Texts)4TEXT40Text, length 40nvarchar400
18TE480TText Table for TE4804TEXT40Text for IS-U Functionalitynvarchar400
19TE481TText Table for TE4814TEXT40Action Text in IS-U Functionalitynvarchar400
20TE493TCal. Val. Method (Texts)4TEXT40Text, length 40nvarchar400
21TE551TFixed Temp. (Texts)4TEXT40Text, length 40nvarchar400
22TE669TGas Procedure (Txts)4TEXT40Text, length 40nvarchar400
23TE679TCharging Ctrl for Heating Inst. (Texts)4TEXT40Text, 40 Characters Longnvarchar400
24TE685TVol. Corr. Factor Proc.(Txts)4TEXT40Text, length 40nvarchar400
TOPInteractive Drilldown Reporting
25TRSTHVTBRST Texts for hierarchies12TEXT40Long Field Labelnvarchar400
TOPInvoicing
26TE555TOn-Site Billing: Billing Groups (Texts)4TEXT40Text, 40 Characters Longnvarchar400
TOPLocalization
27J_1AT001TGTax Category Data per Company Code15TEXT40Text, 40 Characters Longnvarchar400
28J_1ATXOFFOfficial Codes per tax4TEXT40Text, 40 Characters Longnvarchar400
TOPMaintenance Program Definition
29MPDCUST_DCOTText table for text descriptions for the data collector3TEXT40MPD: BAdI Filter Textnvarchar400
30MPDCUST_RPTTText table for text descriptions for the reporting modes3TEXT40MPD: BAdI Filter Textnvarchar400
TOPMaster Data
31T438SText describing the range of coverage profile5TEXT40Text, 40 Characters Longnvarchar400
32T438WText on Period Profile for Safety Time5TEXT40Text, 40 Characters Longnvarchar400
33T438XMRP group text5TEXT40Text, 40 Characters Longnvarchar400
34T458DTexts for Selection Group4TEXT40Text, 40 Characters Longnvarchar400
35T461TPlanning strategy text4TEXT40Text, 40 Characters Longnvarchar400
36T461XPlanning strategy group text4TEXT40Text, 40 Characters Longnvarchar400
TOPMedia Product Sales and Distribution
37TJKSDRETURNCHTCheck Schema4TEXT40Descriptionnvarchar400
TOPMeter Reading
38TE436TUser-defined Meter Reading Type for Entry (Texts)4TEXT40Text, 40 Characters Longnvarchar400
39TE608TMR Reasons (Texts)3TEXT40Text, 40 Characters Longnvarchar400
40TE609TMR Reasons (Texts)3TEXT40Text, 40 Characters Longnvarchar400
41TE614TMeter Reading Categories (Texts)4TEXT40Text, 40 Characters Longnvarchar400
TOPPortioning and scheduling
42TE426TMeter Reading Center Texts4TEXT40Text for Meter Reading Centernvarchar400
TOPQuantity optimizing
43RDTXShort text describing the rounding profile5TEXT40Text, 40 Characters Longnvarchar400
TOPRegional structure
44TE217TWater Press. Areas (Texts)4TEXT40Text, 40 Characters Longnvarchar400
45TE321TWater Hard. Area (texts)4TEXT40Text, 40 Characters Longnvarchar400
TOPTime streams
46TTSTRTTexts for time stream administration table7TEXT40Time stream: Text of length 40nvarchar400
TOPUse AP-MD-BP Components
47TB004TBP Types: Texts4TEXT40Descriptionnvarchar400