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

87 columns | Print definition?ERP 6.0  | TTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_MENUTEXTTexts for Menu Entries4TTEXTCharacter 100nvarchar1000
2CNVCMIS_A_1_TRANTransaction Analysis Table(CMIS)12TTEXTTransaction Textnvarchar360
3NWS_EXT_PROTNMessage Log, R/3 Extractor17TTEXTMessage Supplement Textnvarchar600
4T169STolerance Limit Keys3TTEXTText for tolerance limit keynvarchar400
5T169TText Table for Tolerance Limits5TTEXTText, 40 Characters Longnvarchar400
6T5C1TTexts for Withholding Tax6TTEXTWithholding tax textnvarchar400
7T801UReport Writer: Standard Layouts (Language-Independent Part)30TTEXTIndicator: Text before single valuesnvarchar10
8TZGRTName of grouping rules3TTEXTText (30 Characters)nvarchar300
9TZUNTAssignment Rule Names3TTEXTDescription of the Sort Keynvarchar200
TOPABAP Runtime Environment
10TSTCTTransaction Code Texts3TTEXTTransaction Textnvarchar360
TOPArgentina
11T7AR41Contract types in Argentina: T7AR40 texts3TTEXTDescription of type of work contract in Argentinanvarchar250
TOPBasic Data
12TNT0TIS-H: Texts for Category Table of Service Assignments5TTEXTIS-H: Description of the type of service assignmentnvarchar200
TOPBelgium
13T5BD2Local Unit ID text table.4TTEXTText Field of Length 60nvarchar600
TOPCanada
14T5KTSTax types description3TTEXTText (30 Characters)nvarchar300
TOPDistributor-Reseller-Management
15/SAPHT/DRMCGVALTText table: Active validations for inb 867/844 and staging3TTEXTDRM Validation Type textnvarchar360
16/SAPHT/DRMCRJRNTText Table : Claim Rejection Reason4TTEXTShip-and -Debit claim rejection reasonnvarchar360
17/SAPHT/DRMCSTGRTStaging Validations: Text for the rules5TTEXTDRM Validation rules textnvarchar360
18/SAPHT/DRMCXNCDTDRM Transaction Code Texts4TTEXTDescription of DRM relevant transaction codenvarchar360
19/SAPHT/DRMVALCLTStaging Validations: Text for the Class5TTEXTDRm Validation Class textnvarchar360
TOPDocumentation Tools
20TCSTCDocumentation: Copy of TSTCT3TTEXTTransaction Textnvarchar360
21THSTCDocumentation: Copy of TSTCT3TTEXTTransaction Textnvarchar360
TOPDownstream
22TOI0TWBIS-OIL Application Test dynamic modifications3TTEXTText (length 35)nvarchar350
TOPGRC Access Control Plug-In
23/VIRSA/ANALOBJTTAnalyzed authorization objects Text4TTEXTTexts in user master/authorizationsnvarchar600
24/VIRSA/ANALTRANTAnalyzed transactions Text4TTEXTTransaction Textnvarchar360
25/VIRSA/CRAUTHOBTCritical Authorization Objects Text4TTEXTTexts in user master/authorizationsnvarchar600
26/VIRSA/CRTRANC1TRestricted Transactions Text3TTEXTTransaction Textnvarchar360
27/VIRSA/ZANALOBJTAnalyzed authorization objects3TTEXTTexts in user master/authorizationsnvarchar600
28/VIRSA/ZANALTRANAnalyzed transactions3TTEXTTransaction Textnvarchar360
29/VIRSA/ZCRAUTHOBCritical Authorization Objects3TTEXTTexts in user master/authorizationsnvarchar600
30/VIRSA/ZCRTRANCritical Transactions4TTEXTRisk Descriptionnvarchar1320
31/VIRSA/ZCRTRANC1Restricted Transactions3TTEXTTransaction Textnvarchar360
32/VIRSA/ZCRTRANTCritical Transactions Text5TTEXTRisk Descriptionnvarchar1320
TOPIndonesia
33T7ID2TText For Tax Levels (Indonesia)5TTEXTText for Tax Levelsnvarchar300
TOPInformation System
34T800Report Writer: Reports114TTEXTIndicator: Text before single valuesnvarchar10
35T801GReport Writer: Sections44TTEXTIndicator: Text before single valuesnvarchar10
36T801XReport Writer: Standard Layout - Lang. Independent (new)78TTEXTIndicator: Text before single valuesnvarchar10
TOPJoint Venture und Production Sharing Accounting
37T8J6FJV JIB Subclass B Codes Text Table7TTEXTJV text for table T8J6Envarchar350
38T8J7GJV Project Type Description5TTEXTJV TEXT60nvarchar600
39T8J7HJV Cost Centre Type Description5TTEXTJV TEXT60nvarchar600
40T8J7IJV Order Type Description5TTEXTJV TEXT60nvarchar600
41T8JCGTDescription for customizing groups for authorization3TTEXTDescription of customizing group for authorizationnvarchar450
42T8JJTRecovery Indicator Description5TTEXTRecovery Indicator Descriptionnvarchar350
43T8JPATDescriptions for processes for authorization3TTEXTDescription of processe for authorizationnvarchar350
44T8JWTInternal Recovery Indicator Description4TTEXTInternal Recovery Indicator Descriptionnvarchar350
45T8PSA_PROC_A_TXTPSA Authority Process Code Descriptions3TTEXTAuthority Process Code for PSAnvarchar350
TOPLocalization
46J_1BMMNFTUMM: Allowed automatic text key description4TTEXTDescription text keynvarchar300
TOPMaintenance Orders
47/CUM/CUTYPETCU: Compatible Unit Type4TTEXTCU: CU Category Descriptionnvarchar300
TOPNetherlands
48T5N2EText: Wage Tax [Loonheffing] Table (NL)4TTEXTText for Table Typenvarchar200
TOPOrganizational Management
49T77TDTexts for Task Classification4TTEXTText for the Classification of Tasksnvarchar250
TOPPersonnel Administration
50T7PLE4TERYT municipality GUS codes texts8TTEXTDescriptionnvarchar400
51T7PLETTERYT municipality GUS codes texts7TTEXTDescriptionnvarchar400
TOPPersonnel Time Management
52T550SDaily Work Schedule Texts5TTEXTDaily Work Schedule Textnvarchar150
TOPReuse Services for Country Development
53T5F99K0TPossible configuration options descriptions5TTEXTCharacter field of length 40nvarchar400
54T5F99KMTDescription of configuration option modificators6TTEXTText, 40 Characters Longnvarchar400
55T799BPP06TTexts for Pension Periodicity Values5TTEXTText (100 characters)nvarchar1000
TOPSpain
56T5E03IA/ID and NID healthcare companies4TTEXTText length 32nvarchar320
57T5E04Registered company and work center names5TTEXTText length 32nvarchar320
58T5E2TContract type keys for Social insurance5TTEXTText length 32nvarchar320
59T5E32Healthcare company codes - Social Insurance2TTEXTText length 32nvarchar320
60T5E3TKeys for Social insurance contribution groups4TTEXTContribution group descriptionnvarchar320
61T5E4BEmployment texts4TTEXTText Field of Length 60nvarchar600
62T5E4DCNAE texts4TTEXTText Field of Length 60nvarchar600
63T5E4TDescription of Social Insurance branch-office types4TTEXTText length 32nvarchar320
64T5E5TTexts of Social Insurance contribution types4TTEXTText length 32nvarchar320
65T5E6IContract texts according to company8TTEXTText Field of Length 60nvarchar600
66T5E6JContract texts according to Social Insurance4TTEXTText Field of Length 60nvarchar600
67T5E6KContract grouper texts4TTEXTText, 40 characters longnvarchar400
68T5E6LCalculation method texts4TTEXTText (30 Characters)nvarchar300
69T5E6MContract set texts4TTEXTText Field of Length 60nvarchar600
70T5E6TTitle texts4TTEXTText Field of Length 60nvarchar600
71T5E75Work center commitment code3TTEXTText Fieldnvarchar500
72T5E76Allowance group code5TTEXTText Fieldnvarchar500
73T5E77Academic qualification according to INEM code3TTEXTText (100 characters)nvarchar1000
74T5E7ISpanish Office of Employment (INEM) branch texts4TTEXTText (30 Characters)nvarchar300
75T5EIIEmployment tax control constant texts5TTEXTText, 40 Characters Longnvarchar400
76T5EIJTexts of unemployment tax amount constants5TTEXTText, 40 Characters Longnvarchar400
77T5EMALegal application message texts, Spain4TTEXT150 character textnvarchar1500
78T5EPTForms management: Description of form5TTEXTText length 32nvarchar320
79T5ES5Processing method keys5TTEXTText Field of Length 60nvarchar600
80T5ES9Processing method keys4TTEXTText Field of Length 60nvarchar600
81T5ESTIncentive groups4TTEXTText Field of Length 60nvarchar600
TOPSwitzerland
82T5C2GTexts for Withholding Tax5TTEXTText, 40 Characters Longnvarchar400
TOPTranslation Tools
83SBRNTTTTABSBRN Test Environment3TTEXTSBRN Test Environmentnvarchar300
84TRMMAPPUser values storage table16TTEXTText of length 132nvarchar1320
TOPUser Administration
85USR08Table for user menu entries7TTEXTSAP application (function)nvarchar360
TOPUser and Authorization Management
86TOBJTShort Texts for Authorization Objects3TTEXTTexts in user master/authorizationsnvarchar600
TOPWarehouse Management
87T329TTexts for Setting Formats for Printing Transfer Orders5TTEXTDescription of forms for transfer order printingnvarchar250