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

62 columns | Print definition?ERP 6.0  | CTEXT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_10RES1CNVCMIS_A_RES121CTEXTShort Description of Repository Objectsnvarchar600
2CNVCMIS_A_10_SELREPOSITORY ANALYSIS SEL ECTION11CTEXTShort Description of Repository Objectsnvarchar600
3CNVCMIS_A_1_DEVCDevelopment Class Table(CMIS)27CTEXTShort Description of Repository Objectsnvarchar600
4P01E2_MELDELStAM: Notifications for the Administrator6CTEXTELStAM: Custom Text for Administrator Listntext10737418230
5SRTCM_SNAPSHOT_CSnapshot: Mapping from CTEXT to Hash3CTEXTntext10737418230
6T5FINFTYCDTText table for infotype indicators5CTEXTText (100 characters)nvarchar1000
7T5FRISKTText table for risk factor codes4CTEXTText for risk factor codenvarchar800
8T770CRestrictions4CTEXTRestriction Namenvarchar400
9T7PLZUSCTZUS RMUA code texts4CTEXTCode textnvarchar2550
10TOBCTTexts for Authorization Object Classes3CTEXTTexts in user master/authorizationsnvarchar600
11ZPS1IDES Text Pools13CTEXTCommentsnvarchar1320
12ZPS1_OLDIDES: Assign text pool to standard structure13CTEXTCommentsnvarchar1320
13ZPS2IDES: Assign text pool to standard structure8CTEXTCommentsnvarchar1320
TOPASAP AcceleratedSAP
14SQADBCATTCategory Short Texts3CTEXTQuestion category short textnvarchar1000
15SQADBCONTContext Short Texts3CTEXTContext namenvarchar1000
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
16TLSEPControl table for list separation19CTEXTText for the cover sheetnvarchar650
TOPBenefit Integration
17T7USBEN01TText for saving plans compensation4CTEXTDescription of saving plans compensation modelnvarchar400
TOPBrazil
18T7BR05Text table of circumstances5CTEXTCircumstance namenvarchar600
TOPContract Accounts Receivable and Payable
19TFK004CClearing Lock Reason Description4CTEXTText, length 40nvarchar400
TOPFinancial Accounting
20FBICRC01000Reconciliation Processes: Attributes17CTEXTGeneral Indicatornvarchar10
21FERC_C12TCost element variant texts4CTEXTCost element variant descriptionnvarchar200
22FERC_C14TClearing group texts4CTEXTClearing group descriptionnvarchar200
TOPHR Administrative Services
23T5ASRDPFCATTText for Category of Personnel Files4CTEXTText (20 Characters)nvarchar200
24T5ASRPROCGROUPTText for Grouping of Personnel Administration Processes4CTEXTText (20 Characters)nvarchar200
TOPImplementation Guide
25CUSAC1TCheck table for customer attribute 13CTEXTShort text for customer attributenvarchar400
26CUSAC2TCheck table for customer attribute 23CTEXTShort text for customer attributenvarchar400
27CUSAC3TCheck table for customer attribute 33CTEXTShort text for customer attributenvarchar400
TOPIndia
28T7INI1Investment category text3CTEXTInvestment category textnvarchar200
TOPIndonesia
29T7ID2CIndonesian Tax Deduction Constants4CTEXTText for Tax Constantsnvarchar300
TOPInformation System
30T801TReport Writer: Texts for Parallel Reports5CTEXTDescription for Report Writer objectsnvarchar350
TOPJoint Venture und Production Sharing Accounting
31T8J6BJIB/JIBE Class Text5CTEXTJIB/JIBE Textnvarchar350
32T8J6DJIB/JIBE Subclass Text6CTEXTTextnvarchar350
TOPLocalization
33J_3RFTAX_CHAINTTax chain texts4CTEXTTax chain descriptionnvarchar500
TOPOrganizational Management
34T77OTCatalog Texts4CTEXTCatalog Namenvarchar400
TOPPerformance Assessment Workbench
35SLS_CEVENTPAW - Comments for an event13CTEXTPAW - Long characterntext10737418230
36SLS_CPETPAW -Comments for an event / test / participant assignment10CTEXTPAW - Long characterntext10737418230
37SLS_CRITEMPAW - Comments for an item from a participant10CTEXTPAW - Long characterntext10737418230
38SLS_CXETPAW - Comments for an event / test assignment13CTEXTPAW - Long characterntext10737418230
TOPPersonnel Administration
39RPUCTEXXResults of the TODO Report RPUCTEXX14CTEXTShort Description of Repository Objectsnvarchar600
40T587BDetail View: Personnel Assignments - Category Text5CTEXTDetail View: Personnel Assignments - Category Textnvarchar400
TOPPersonnel Categories
41/ISDFPS/COLORTColor Code (Defense) - Text6CTEXTText (30 Characters)nvarchar300
TOPPersonnel Time Management
42T556DAbsence Counting With/Without Quotas Texts7CTEXTText Fieldnvarchar500
TOPPosition Budgeting and Control
43T77HRFPM_CIL_TDescription Legal Grounds5CTEXTName of Legal Groundsnvarchar400
TOPService Data Download
44/SDF/CMO_T_42CMO Service: Customer objects4CTEXTShort Description of Repository Objectsnvarchar600
45/SDF/CMO_T_42ACMO Service: Most frequently changed objects5CTEXTShort Description of Repository Objectsnvarchar600
46/SDF/CMO_T_42BCMO Service: Customer objects for analysis period4CTEXTShort Description of Repository Objectsnvarchar600
TOPSpain
47T5E41Payment subkeys9CTEXTText Field of Length 60nvarchar600
48T5E8SAssignation of professional categories to modifiers5CTEXTText length 32nvarchar320
49T5E8UTexts of professional categories modifiers4CTEXTText length 32nvarchar320
50T5EIAPayment keys7CTEXTText Field of Length 60nvarchar600
TOPStaffing
51T777CTexts Restrictions4CTEXTRestriction Namenvarchar400
TOPTax
52P01T_LST2ETStmt: Addnl Data on Employment Tax Statement8CTEXTETStmt: Descriptionnvarchar400
TOPTransport Management System
53TCETRALTTexts for Transport Layers4CTEXTExplanatory short textnvarchar600
TOPTransport Organizer
54DEVLTOBSOLETE: Do not use (see TCETRALT)3CTEXTShort Description of Repository Objectsnvarchar600
55TDEVCPackages4CTEXTObsolete field (do not use anymore)nvarchar600
56TDEVCTTexts for Packages3CTEXTShort Description of Repository Objectsnvarchar600
57TRESNTText Table for Table TRESN (Naming Conventions)5CTEXTShort description of reservation entries (TRESN)nvarchar600
TOPTreasury and Risk Management
58VVWKN7Charact.group - Secondary values alloc. (via the inv.no.)5CTEXTField (text) for user interface loans listsnvarchar200
TOPUSA
59T5UG3Model for Calculation of the Non-Exempt Amount3CTEXTDescription of model non-exempt amountnvarchar400
TOPUser and Authorization Management
60USRCOMBTShort Texts for Critical Combinations of Authorizations4CTEXTTexts in user master/authorizationsnvarchar600
TOPWaste Management
61TECLEANMETHODTTexts for Cleaning Methods4CTEXTText for Cleaning Methodnvarchar300
TOPWorkbench Utilities
62APADEFTObsolete3CTEXTShort Description of Repository Objectsnvarchar600