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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

30 columns | Print definition?ERP 6.0  | TYPE_TEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1VFPRCC_VIEW_TTXTView Type Texts3TYPE_TEXTDescriptionnvarchar300
TOPContract Accounts Receivable and Payable
2TFKK_INT_HISTT##Text table for interaction history customizing5TYPE_TEXTText Fieldnvarchar500
TOPControlling
3DPR_PRO_TYPE_T_CTexts for Project Type4TYPE_TEXTShort Text for Typenvarchar400
TOPCross-Application Components
4ETP_TEXTHEADEREasy Task Planning: Texts for Task5TYPE_TEXTTask-Text Typenvarchar20
TOPImplementation Guide
5DSYBBProject Document Types3TYPE_TEXTObject namenvarchar600
TOPMeasuring Points and Counters
6T370CON_TOL_TPM: Tolerance for Consumption Control Check Texts4TYPE_TEXTDescription of tolerance for consumption control checknvarchar300
7T370FLD_GMOVE_TPM: Goods Movement/Account Assignmt Consumpt.Transactn Texts4TYPE_TEXTDescription for goods movement with consumption transactionnvarchar300
8T370FLD_STN_TPM: Gas Stations for Fleet Management, Texts4TYPE_TEXTGas Station Descriptionnvarchar300
TOPMessages
9DNOC_TYPE_TEXTText Segment Types3TYPE_TEXTText Segment Typenvarchar20
10DNOC_TYPE_TEXTTText Segment Types: Texts4TYPE_TEXTText Segment Typenvarchar20
11DNOC_TYPE_TEXTVTexts Visible to Creator, Central Notif. Sys., SAP,...4TYPE_TEXTText Segment Typenvarchar20
12DNOD_NOTIF_TLong Text Segment5TYPE_TEXTText Segment Typenvarchar20
TOPOccupational Health
13T7EHS00_BEFU_TYTResult Code Category (Text Table)4TYPE_TEXTDecription of Result Code Categorynvarchar200
14T7EHS00_DIAGNTYTDiagnosis Key Category (Text Table)4TYPE_TEXTDescription of Diagnosis Key Categorynvarchar200
TOPPurchasing
15WRFT_BUDG_TYPETDescription of Budget Type6TYPE_TEXTBudget Type Textnvarchar300
TOPSAP Healthcare - Industry-Specific Components for Hospitals
16TNLGGZ_PRODUCTGeisteskrankheit productkode12TYPE_TEXTGeisteskrankheit productkode type beschreibungnvarchar2550
TOPStructure
17DPR_CLH_TYPE_TTexts for Checklist Type4TYPE_TEXTShort Text for Typenvarchar400
18DPR_PHA_TYPE_TTexts for Phase Type4TYPE_TEXTShort Text for Typenvarchar400
19DPR_PRO_TYPE_TTexts for Project Type4TYPE_TEXTShort Text for Typenvarchar400
20DPR_TSK_TYPE_TTexts for Task Type4TYPE_TEXTShort Text for Typenvarchar400
TOPTechnical Objects
21T370CLC_TText for Fleet Consumption Calculation Keys4TYPE_TEXTShort text for calculation key descriptionnvarchar250
22T370CON_TShort Text For Fleet Consumption Unit Groups4TYPE_TEXTShort text for SI unit of fleet consumption unit groupnvarchar300
23T370ENG_TEngine Type: Multilingual Short Texts4TYPE_TEXTShort text for engine typenvarchar300
24T370FLD_TFluid Types: Multilingual Short Texts4TYPE_TEXTDescription of Fluid Typenvarchar300
25T370POS_TValid Measuring Point Positions (Sort Field) - Short Texts4TYPE_TEXTShort Text for Measuring Point Positionnvarchar300
26T370USG_TFleet Usage: Multilingual Short Texts4TYPE_TEXTShort text for usage indicatornvarchar300
TOPTraders and Schedulers Workbench
27TOI0EVTIS-OIL Master Data Event Type Texts5TYPE_TEXTMaster Data Event Type Textnvarchar400
28TOIGEDTTD Event Document Type Text4TYPE_TEXTTD - event document type textnvarchar400
29TOIGETTD Event Type Text4TYPE_TEXTTD - event type textnvarchar400
30TOIJNOM_EV01TNomination Event type texts4TYPE_TEXTTD - event type textnvarchar400