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

123 columns | Print definition?ERP 6.0  | SPRACHE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEP/T_VARIANTSTGraphischer Leitstand: EinstellungenTexttabelle6SPRACHESprachenschlüsselnvarchar10
2DSH_MEALTDictionary Search Helps: Text Table for Meals4SPRACHELanguage Keynvarchar10
3TDM12Attribute Short/Long Name1SPRACHELanguage Keynvarchar10
4TDM26Specialization Category: Short/Long Name1SPRACHELanguage Keynvarchar10
5TERMUTerminology Data Base Users2SPRACHELanguage Keynvarchar10
6TFM02Process Long Name1SPRACHELanguage Keynvarchar10
7TFM08Event Type Long Name1SPRACHELanguage Keynvarchar10
8TQ27TRM-QSS: Text table for TQ272SPRACHELanguage Keynvarchar10
9ZTR2Zuordnung Übersetzer - Bereich2SPRACHEZielsprachenvarchar10
TOPABAP Authorization and Role Management
10SSM_VARTText and Variable definations for URL2SPRACHELanguage Keynvarchar10
TOPABAP Workbench, Java IDE and Infrastructure
11SMEALTInflight meal/Description4SPRACHELanguage Keynvarchar10
TOPActive Quality Control
12QDEBTAllowed combinations of procedures/dynamic mod. rules: texts2SPRACHELanguage Keynvarchar10
13QDPKTSampling scheme: texts2SPRACHELanguage Keynvarchar10
TOPAuthentication and SSO
14USR41User master: Additional data6SPRACHELogon Languagenvarchar10
TOPBasic Data
15QMTTInspection Method Texts5SPRACHELanguage Keynvarchar10
16QPMTMaster Inspection Characteristics Texts5SPRACHELanguage Keynvarchar10
TOPBasic Data for Certificates
17QCVMTCertificate profile characteristic level: texts7SPRACHELanguage Keynvarchar10
18TQ61TOrigin of result values for certificates: texts3SPRACHELanguage Keynvarchar10
19TQ62TOutput strategy for skip characteristics: texts3SPRACHELanguage Keynvarchar10
20TQ63TOrigin of inspection specifications for certificates: texts3SPRACHELanguage Keynvarchar10
21TQ64TOrigin of characteristic short text for certificates: texts3SPRACHELanguage Keynvarchar10
22TQ681TDesc. for Text Element4SPRACHELanguage Keynvarchar10
23TQ68TText for Configuration of Characteristics Field3SPRACHELanguage Keynvarchar10
TOPBusiness Navigator
24TFM04Function Long Name1SPRACHELanguage Keynvarchar10
25TFM14Hierarchy - Short and Long Name1SPRACHELanguage Keynvarchar10
TOPCatalog
26QPCTCode texts5SPRACHELanguage Keynvarchar10
27QPGTCode group texts4SPRACHELanguage Keynvarchar10
28TQ07TLanguage-dependent texts for Table TQ072SPRACHELanguage Keynvarchar10
29TQ15TLanguage-dependent texts for table TQ152SPRACHELanguage Keynvarchar10
30TQ17TLanguage-dependent texts for table TQ172SPRACHELanguage Keynvarchar10
TOPClient Copy
31CCOPTTClient Copy Option Texts1SPRACHELanguage Keynvarchar10
TOPClientServer Technology
32D345TTable for Long GUI Objects (Texts)2SPRACHEGUI: Language keynvarchar10
TOPCross-Application Components
33J_8A3SZENTscenario texts - Old Version, don't use3SPRACHELanguage Keynvarchar10
34J_8A3T0011scenario texts3SPRACHElanguagenvarchar10
TOPCustomer Enhancements
35MODWRDKey words of changed DE1SPRACHELanguage Keynvarchar10
TOPData Modeler
36DM02TDM Entity Type Short Text1SPRACHELanguage Keynvarchar10
37DM40TDM Data Model Short Text1SPRACHELanguage Keynvarchar10
38DM42TDM Relationship Short Text1SPRACHELanguage Keynvarchar10
39DM43TDM Entity Type Aliases1SPRACHELanguage Keynvarchar10
40DM45TDM Short text for specialization type1SPRACHELanguage Keynvarchar10
41DM48TDM Area Short Text1SPRACHELanguage Keynvarchar10
42DM50TDM ADW Text on Entity Type1SPRACHELanguage Keynvarchar10
43TDM03Entity Short/Long Name1SPRACHELanguage Keynvarchar10
44TDM05Data Model Short/Long Name1SPRACHELanguage Keynvarchar10
45TDM22Entity Specialization Category Text1SPRACHELanguage Keynvarchar10
46TDM27EDM Cluster: Short/Long Name1SPRACHELanguage Keynvarchar10
TOPData Staging
47RSMOCALLERCaller master data1SPRACHELanguage Keynvarchar10
TOPDigital Signature
48TC82Short Text for Authorization Group for Digital Signatures2SPRACHELanguage Keynvarchar10
49TC84Short Text for Individual Signature2SPRACHELanguage Keynvarchar10
50TC86Short Text for Signature Strategy2SPRACHELanguage Keynvarchar10
TOPEnhancements SD
51ESDADFDMaintenance of Additional Fields for Scheduling Agreement3SPRACHELanguage Keynvarchar10
TOPGraphical User Interface
52CNTLSTRINFAttributes of a stream7SPRACHESingle-Character Indicatornvarchar10
TOPInformation System
53TQ56TText table for the definition of quality score classes2SPRACHELanguage Keynvarchar10
TOPInspection Lot Completion
54TQ06TLanguage-specific texts for Table TQ062SPRACHELanguage Keynvarchar10
TOPInspection Planning
55TQ72TTexts for type of share calculation2SPRACHELanguage Keynvarchar10
56TQ75KShort text for Table TQ75F2SPRACHELanguage Keynvarchar10
57TQ75TDescription of formula parameters2SPRACHELanguage Keynvarchar10
TOPOutput Determination
58LEDPROFILTDefinition of Print Profile Names and their Usage3SPRACHELanguage Keynvarchar10
TOPPool Asset Management
59PAMS_VARITGraphical Planning Board: Field Settings - Text Tab.6SPRACHELanguage Keynvarchar10
TOPQM Control in Procurement
60QINFQM-info record for material and vendor17SPRACHELanguage Keynvarchar10
61TQ04SQM block functions : texts2SPRACHELanguage Keynvarchar10
62TQ05TQM: text table for certificate types2SPRACHELanguage Keynvarchar10
63TQ08TQM: text for QM procurement keys2SPRACHELanguage Keynvarchar10
64TQ09TQM: agreement of QM document types2SPRACHELanguage Keynvarchar10
TOPQuality Inspection
65QALSInspection lot record137SPRACHELanguage Keynvarchar10
66TQ30TTexts for inspection types2SPRACHELanguage Keynvarchar10
67TQ31TDescriptions of Inspection Lot Origins1SPRACHELanguage Keynvarchar10
68TQ32C_TTexts for lot creation indicator1SPRACHELanguage Keynvarchar10
69TQ45TDescriptions of Primary Packaging (Stability Study)2SPRACHELanguage Keynvarchar10
70TQ79TKey words for inspeciton point user fields2SPRACHELanguage Keynvarchar10
TOPQuality Management
71TQ01CTexts for material authorization group in QM2SPRACHELanguage Keynvarchar10
72TQ16TLanguage-dependent short texts for the valuation2SPRACHELanguage Keynvarchar10
73TQ17ULanguage-dependent texts for table TQ17A2SPRACHELanguage Keynvarchar10
74TQ29TRM-QSS: Text table for TQ292SPRACHELanguage Keynvarchar10
75TQ39LText table for TQ39A1SPRACHELanguage Keynvarchar10
76TQ39TText table for dynamic modification criteria1SPRACHELanguage Keynvarchar10
TOPQuality Notifications
77TQ85_TAction box text table4SPRACHELanguage Keynvarchar10
TOPReport Tree
78SLSSTTexts of sort criteria for form tree structure1SPRACHELanguage Keynvarchar10
79SRPSTSort Criteria Texts for Tree Structure1SPRACHELanguage Keynvarchar10
TOPResults Recording
80QIMTHTTexts for evaluation methods: QM STI interface2SPRACHELanguage Keynvarchar10
81QISTPTTexts for evaluation steps2SPRACHELanguage Keynvarchar10
82QISUBTText table subsystems for recording measured val. data in QM2SPRACHELanguage Keynvarchar10
83TQ12TTexts for the ind. for ext. numbering of units to be insp.2SPRACHELanguage Keynvarchar10
84TQ76TTexts for the processing status of insp. characteristics1SPRACHELanguage Keynvarchar10
85TQ77TText Tables for Attributes2SPRACHELanguage Keynvarchar10
86TQ78TTexts for the status-specific proc. table for insp. char.4SPRACHELanguage Keynvarchar10
TOPSample Management
87QPRVKTHeader for sample drawing procedure texts4SPRACHELanguage Keynvarchar10
88QPRVPTItems for sample drawing procedure texts5SPRACHELanguage Keynvarchar10
89TQ41TTexts for storage locations4SPRACHELanguage Keynvarchar10
90TQ42TTexts for phys. sample containers3SPRACHELanguage Keynvarchar10
91TQ44TDescriptions of Physical-Sample Categories1SPRACHELanguage Keynvarchar10
92TQ46TDescriptions of Screen Control Keys for Phys.-Sample Type1SPRACHELanguage Keynvarchar10
TOPSamples and SPC
93QDBMTValuation Mode: Texts2SPRACHELanguage Keynvarchar10
94QDDRTDynamic modification rule: texts2SPRACHELanguage Keynvarchar10
95QDEPTAllowed Inspection Severities: Texts2SPRACHELanguage Keynvarchar10
96QDFBTFunction Modules for Procedure: Texts2SPRACHELanguage Keynvarchar10
97QDFMTFunction Modules for Valuation Mode: Texts2SPRACHELanguage Keynvarchar10
98QDPSTInspection Stages: Texts2SPRACHELanguage Keynvarchar10
99QDSATSampling Type: Texts2SPRACHELanguage Keynvarchar10
100QDSVTSampling Procedure: Texts2SPRACHELanguage Keynvarchar10
101QPSHTTexts for control chart types2SPRACHELanguage Keynvarchar10
102QPSPTTexts for SPC criteria2SPRACHELanguage Keynvarchar10
103QPSTTTexts for control chart tracks2SPRACHELanguage Keynvarchar10
TOPSyntax, Compiler, Runtime
104SABAP_ALV_CHECKSTable for Collecting Dynamic ALV Check Data6SPRACHELanguage Keynvarchar10
105SABAP_GUI_CHECKSTable for Collecting the Created Dynamic GUI Check Data6SPRACHELanguage Keynvarchar10
106SABAP_LIST_ACCAccessibility Error Messages of the List Heuristic6SPRACHELanguage Keynvarchar10
TOPTerminologyGlossary
107TERM9Terminology Authorizations3SPRACHELanguage Keynvarchar10
TOPTranslation Tools
108LANGGRUTShort text for table LANGGRU1SPRACHELanguage Keynvarchar10
109LANGTR1Assignment: Language - translator - development class1SPRACHEData Element for Domain SPRASnvarchar10
110LANGTR2Translation exclusions1SPRACHEData Element for Domain SPRASnvarchar10
111LANGUSRObsolete table -> do not use1SPRACHEData Element for Domain SPRASnvarchar10
112LANGZUSAssignment: Language - group - date1SPRACHEData Element for Domain SPRASnvarchar10
113LANG_MANDTObsolete table; do not use1SPRACHELanguage Keynvarchar10
114LXE_LZUSAssignment: Language - Object Group - Date1SPRACHETranslation Languagenvarchar40
TOPTravel Planning
115TA23APIS1APIS ( Advanced Passenger Information System ) - sprachabh.3SPRACHELanguage Keynvarchar10
116TA23APIS_TEXT3SPRACHEnvarchar10
TOPUser and Authorization Management
117USARC_CDREDReloaded Archived Change Documents for User Data15SPRACHELanguage Keynvarchar10
118USRFLDTCUA: Text Table to Define Logical Fields1SPRACHELanguage Keynvarchar10
119USSETTINGTText table for USSETTINGS2SPRACHELanguage Keynvarchar10
TOPWaste Management
120EHSWAC_EAOPTYPEDApplication Functions: Descriptions2SPRACHELanguage Keynvarchar10
121EHSWAC_ENTAMFOFDFunctions for Disposal Processing: Texts2SPRACHELanguage Keynvarchar10
122EHSWAC_MNFOFDFunctions for Disposal Processing: Texts2SPRACHELanguage Keynvarchar10
TOPWorkbench Tools Editors, Painters, Modelers
123TPARATMemory ID Short Texts2SPRACHELanguage key for an ABAP/4 Dictionary objectnvarchar10