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

35 columns | Print definition?ERP 6.0  | TEXTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_WELCOMSupplier Collaboration: Welcome texts2TEXTIDText Type Identifiernvarchar10
2COMC_PR_TEXT_MProduct Master Key Conversion R/3 to CRM4TEXTIDProduct Master Text IDnvarchar40
3COMC_TEXT_PDDefinition of Text Determination Procedure4TEXTIDText Typenvarchar40
4COMC_TEXT_PROTLog Text - Text Types3TEXTIDText Typenvarchar40
5GRACLNGTXTLanguage Text2TEXTIDUUID of the GRC object (char32)nvarchar320
6UCONVIRTHOSTTEXTText table for virt. host5TEXTIDUnified Connectivity Text IDnvarchar100
TOPBasis Components
7/XFT/INV_Q_8Text sample6TEXTIDText ID for Text Templatenvarchar320
8/XFT/INV_Q_8_SText sample6TEXTIDText ID for Text Templatenvarchar320
TOPClaims Management
9ICLTEXTShort Texts in Claim6TEXTIDText IDnvarchar40
10ICSTEXTShort Texts in Claim6TEXTIDText IDnvarchar40
11TICL089Permitted Text ID3TEXTIDText IDnvarchar40
12TICL089TPermitted Text ID - Texts4TEXTIDText IDnvarchar40
TOPI18N Unicode
13TECHED03_RESULT2Result table for Unicode outside communication exercises5TEXTIDnvarchar50
14TECHED03_UTEXTSome Example texts1TEXTIDnvarchar50
TOPInformation system
15FMTEXTIDGültige Text-Identifikationen zum Lesen der Texte1TEXTIDTextID für den Text-Funktionsbausteinnvarchar200
16FMTEXTIDTGültige Text-Identifikationen zum Lesen der Texte1TEXTIDTextID für den Text-Funktionsbausteinnvarchar200
TOPNon Profit Organizations
17T7UN_T52C0Abrechnungsschemen10TEXTIDZeilen-Nummernvarchar30
TOPOrganizational Management
18T77TTProfiles for RHDESC20 Texts5TEXTIDText IDnvarchar40
TOPPayroll
19PA0729Personál.kmen.záznam Infotyp 072940TEXTIDID textu záznamu infotypu doplnku opatrenínvarchar250
20PB0729Personál.kmen.záznam Infotyp 072940TEXTIDID textu záznamu infotypu doplnku opatrenínvarchar250
21T5TPSTXT02Texty pro formuláre v doplncích opatrení .10TEXTIDID textu záznamu infotypu doplnku opatrenínvarchar250
TOPPayroll General Parts
22T52C0Payroll Schemas10TEXTIDLine numbernvarchar30
23T52C1Payroll Schemas (Customer)11TEXTIDLine numbernvarchar30
TOPPerformance Assessment Workbench
24SLS_RESS3PAW - Text table for results from essay's2TEXTIDPAW identifiernvarchar80
25SLS_TEXTPAW - Text Table2TEXTIDPAW identifiernvarchar80
26SLS_YESS3PAW - Text table for results from essay's2TEXTIDPAW identifiernvarchar80
TOPResourcen Management
27RMSLC_DIET_TXTIDCustomizing: Assign Text Modules to Diet Values3TEXTIDText Module IDnvarchar300
28RMSLC_TEXTCustomizing: Text Modules2TEXTIDText Module IDnvarchar300
29RMSLC_TEXTTCustomizing: Language-Dependent Texts for Text Modules3TEXTIDText Module IDnvarchar300
TOPStaffing
30T77T0Profiles for RHDESC205TEXTIDText IDnvarchar40
TOPTime streams
31TTSTRTTexts for time stream administration table9TEXTIDText IDnvarchar40
TOPTransaction Tax Engine
32TTEC_DT_TEXTSDecision Tree Texts6TEXTIDDecision Tree Text IDnvarchar100
TOPTravel Expenses
33T706ESS3Mapping table for docu in Excel sheet1TEXTIDText element key (number/selection name)nvarchar80
TOPWebClient UI
34CRMD_UIF_SNOTETransparent Table Note for Flight6TEXTIDUUID in character formnvarchar320
TOPWithout Description
35RSTT_SY_TEXTSTrace Tool:Mapping Table for Text-Relevant Object Attributes7TEXTIDTrace Tool: Text ID of Text Symbolsnvarchar100