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

72 columns | Print definition?ERP 6.0  | CNT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GEOE/CONFIG_22GIS Field Mapping6CNTCounternvarchar40
2OCS_CP_PAT08TLOGO PAT08 für Correction Package Erwtrte. Patch-Attribute3CNTPAT07/PAT08/PAT13: Reihenfolgenvarchar30
3TTS_WCCJTTS: Selection Fields for Creation with Template5CNTDisplay Sequencenvarchar80
TOPCost Center Accounting
4T811HAllocations Data Field Descriptions13CNTCounter valuenvarchar10
TOPEngineering Desktop
5EDESK_INSTDatabase Table for Instance Mgmt in Engineering Desktop3CNTCounter of Length 4nvarchar40
TOPFinancials Basis
6UBC_TB_ACTAccount Assignment Fields for each Organizational Unit3CNTNumber of Account Assignment Fieldtinyint30
7UBC_TB_ACTVValues for Account Assignment Fields3CNTNumber of Account Assignment Fieldtinyint30
8UBC_TB_BILDVALAccount Assignment Default Values on Level of Biller4CNTNumber of Account Assignment Fieldtinyint30
9UBC_TB_INVHACTAccount Assignments on Bill Header4CNTNumber of Account Assignment Fieldtinyint30
10UBC_TB_INVPACTAccount Assignments on Level of Item5CNTNumber of Account Assignment Fieldtinyint30
11UBC_TB_ORGDVALAccount Assignment Default Values on Level of Biller3CNTNumber of Account Assignment Fieldtinyint30
12UBC_TB_RADVALAccount Assignment Default Values on Level of Bill Type5CNTNumber of Account Assignment Fieldtinyint30
13UBC_TB_RPADVALAccount Assignment Default Values on Level of Bill Item Type5CNTNumber of Account Assignment Fieldtinyint30
14UBC_TB_SAPFIField Assignments for Creating BI Sessions7CNTNumber of Account Assignment Fieldtinyint30
15UBC_TT_ACTTexts for Account Assignment Fields3CNTNumber of Account Assignment Fieldtinyint30
16UBC_TT_ACTVTexts for Values of Account Assignment Fields3CNTNumber of Account Assignment Fieldtinyint30
TOPHR Information Systems
17HRSEL_GROUPINGSelection Grouping4CNTSequence Numbernvarchar30
18HRSEL_RANGESSelection Condition Ranges5CNTSequence Numbernvarchar30
TOPInformation System
19T804BReport Writer: Key figures13CNTCounter valuenvarchar10
TOPIntegrated Product and Process Engineering
20PPESCMPViPPE Status, BOM-Specific Data3CNTCounter for Multiple Usage of a Statusnvarchar20
21PPESGENNiPPE Status, GEN Node-Specific Data3CNTCounter for Multiple Usage of a Statusnvarchar20
TOPKnowledge Warehouse
22IWTESTUSERKEN: KEN user in test mode4CNTnvarchar40
TOPLink to Geographic Information System
23GCCBGBC: Field Allocations6CNTVal. Conversionnvarchar60
TOPLogistical Requirements
24/ISDFPS/PPESMPANiPPE Status of Material Package3CNTCounter for Multiple Usage of a Statusnvarchar20
TOPMaterial Categories
25/ISDFPS/PPESMPOAiPPE Status of MPO Component3CNTCounter for Multiple Usage of a Statusnvarchar20
26/ISDFPS/PPESMPONiPPE Status of Material Planning Object3CNTCounter for Multiple Usage of a Statusnvarchar20
TOPMonitoring
27SWNCCOLLPERFPerformance Data of the Workload Collector6CNTSAP Workload NW Collector: Whole Number Value up to 2^16-1int100
28SWNCCOLLPERFTOTPerformance Data of the Workload Collector8CNTSAP Workload NW Collector: Whole Number Value up to 2^16-1int100
TOPOLAP Technology
29RSCURTRACETrace: Currency Translation3CNTSequence Numbernvarchar100
30RSDDSTATDATAUSEFilter vals during query execution for selected InfoObjects3CNTint100
31RSDDTPSFMLVARVariables for CKF/RKF2CNTnvarchar100
32RSRQPROV_TST_FLDPosition Table: Test Runs4CNTCounternvarchar80
33RSRQPROV_TST_HDRHeader Table: Test Runs2CNTCounternvarchar80
TOPOnline Correction Support Support Package and Add-On Tools
34PAT08Extended Support Package Attributes3CNTPAT07/PAT08/PAT13: Sequencenvarchar30
35PAT08_ACPExtended Attributes for Packages Referenced by ACP4CNTPAT07/PAT08/PAT13: Sequencenvarchar30
36PAT08_SDAExtended Support Package Attributes3CNTNumeric valuenvarchar30
37PATLOGLogging Table for Transaction SPAM/SAINT3CNTCounternvarchar30
38PATLOG3New Logging Table for TA SPAM/SAINT5CNTCounternvarchar30
TOPProcess Management
39TCOOPC_EVTSDAOPC: Event Subscription Definition (Event Areas)4CNTOPC: Counternvarchar40
40TCOOPC_EVTSDCOPC: Event Subscription Definition (Event Category)4CNTOPC: Counternvarchar40
41TCOOPC_EVTSDSOPC: Event Subscription Definition (Event Sources)4CNTOPC: Counternvarchar40
TOPResourcen Management
42RMSAT_STD_PARA_HRMS-ATL: Header Table Parameter Standardization3CNTCounternvarchar80
43RMSAT_STD_PARA_IRMS-ATL: Variable Item Table Parameter Standardization3CNTCounternvarchar80
44RMSAT_STD_PARA_PRMS-ATL: Item Table Parameter Standardization3CNTCounternvarchar80
TOPRuntime WorkbenchMonitoring
45SXMSPMIRAWIntegration Engine: Performance Data Extracted from PMI3CNTNatural Numberint100
TOPSAP Business Workflow
46OJDEFSObjects in the SAP System: definition source2CNTObjects in SAP System: line counternvarchar40
TOPSAP System Log
47SLGSKSystem Log Statistics by Log Type3CNTSystem log statisticsint100
48SLGSMSystem Log Statistics by Message3CNTSystem log statisticsint100
49SLGSRSystem Log Statistics by Reports3CNTSystem log statisticsint100
50SLGSTSystem Log Statistics by Transaction3CNTSystem log statisticsint100
TOPService Data Download
51/SDF/RBE_CS3_AAttributes for SQL Check Steps in SDA Analysis5CNTSingle-Character Indicatornvarchar10
TOPSystem Landscape DirectoryComponent Repository
52SLDAGDIDSLD Agent: Data with ID2CNTSLD Agent: Counter for Data for a Data IDint100
TOPTranslation Tools
53LXETXTCNT1Text Table13CNTNatural Numberint100
54LXE_LISTLocal Lists3CNTint100
55LXE_LIST_SRLocal Lists3CNTint100
56LXE_LIST_SXLocal Lists3CNTint100
57LXE_PC2_HSHash2CNTNumbernvarchar50
58LXE_PC2_KEYHeader Data for PC* Objects5CNTNumbernvarchar50
TOPTransport Management System
59TMSALOGTMS Alert: Logging Table1CNTCI: Counternvarchar80
60TMSALOGARTMS: Archived ALOG1CNTCI: Counternvarchar80
TOPWork Clearance Management
61WCABQWCM: Log (Valuation)4CNTInternal Counter (8 Characters)nvarchar80
62WCACGQWCM: Log (WCM Object <-> Catalog)4CNTCounter for differentiation 6-digitnvarchar60
63WCACNQWCM: Log (Operational Tag)10CNTInternal Counter (8 Characters)nvarchar80
64WCACQWCM: Log for Tagging/Untagging (Conflict Check)3CNTInternal Counter (8 Characters)nvarchar80
65WCADQWCM: Log (Approval Group)8CNTCounter for differentiation 6-digitnvarchar60
66WCAEQWCM: Log (Order Operation <-> Approval Group)4CNTCounter for differentiation 6-digitnvarchar60
67WCAFQWCM: Log (Order Operation <-> Work Clearance Document)5CNTCounter for differentiation 6-digitnvarchar60
68WCALQWCM: Log (WCM Object <-> WCM Object)4CNTCounter for differentiation 6-digitnvarchar60
69WCASQWCM: Log (Application <-> Order Operation)5CNTCounter for differentiation 6-digitnvarchar60
70WCCJWCM: Selection Fields for Creation with Template5CNTDisplay Sequencenvarchar80
71WCCNWCM: Valuation4CNTDisplay Sequencenvarchar80
72WCCPNWCM: Approval Group6CNTDisplay Sequencenvarchar80