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

85 columns | Print definition?ERP 6.0  | PROC_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/DT_BP_1BRBest Practice Framework - One time Business Rules3PROC_TYPEProcess Typenvarchar30
2/OPT/DT_BP_MODUBest Practice Framework - Logic Module4PROC_TYPEProcess Typenvarchar30
3/OPT/DT_BR_BUKRSCompany Code Excludes for Process Types2PROC_TYPEProcess Typenvarchar30
4/OPT/DT_BR_WAITProcess Types with Wait / Rerun indicator3PROC_TYPEProcess Typenvarchar30
5/OPT/VT_PTYPEProcess Type Texts3PROC_TYPEProcess Typenvarchar30
6/OPT/X068Country Specific Process Types Confugration3PROC_TYPEProcess Typenvarchar30
7/OPT/X069Document Type Definition9PROC_TYPEProcess Typenvarchar30
8/OPT/X073Document Allowed Process Types3PROC_TYPEProcess Typenvarchar30
9/OPT/X105Process Type Definition2PROC_TYPEProcess Typenvarchar30
10/OPT/X106Process Type Texts2PROC_TYPEProcess Typenvarchar30
11/OPT/X109User Process Options2PROC_TYPEProcess Typenvarchar30
12/OPT/X136Process Type Texts3PROC_TYPEProcess Typenvarchar30
13/OPT/Y068Country Specific Process Types Confugration3PROC_TYPEProcess Typenvarchar30
14/OPT/Y069Document Type Definition9PROC_TYPEProcess Typenvarchar30
15/OPT/Y073Document Allowed Process Types3PROC_TYPEProcess Typenvarchar30
16/OPT/Y105Process Type Definition2PROC_TYPEProcess Typenvarchar30
17/OPT/Y106Process Type Texts2PROC_TYPEProcess Typenvarchar30
18/OPT/Y109User Process Options2PROC_TYPEProcess Typenvarchar30
19/OPT/Y136Process Type Texts3PROC_TYPEProcess Typenvarchar30
20/OPT/Z068Country Specific Process Types Confugration3PROC_TYPEProcess Typenvarchar30
21/OPT/Z069Document Type Definition9PROC_TYPEProcess Typenvarchar30
22/OPT/Z073Document Allowed Process Types3PROC_TYPEProcess Typenvarchar30
23/OPT/Z105Process Type Definition2PROC_TYPEProcess Typenvarchar30
24/OPT/Z106Process Type Texts2PROC_TYPEProcess Typenvarchar30
25/OPT/Z109User Process Options2PROC_TYPEProcess Typenvarchar30
26/OPT/Z136Process Type Texts3PROC_TYPEProcess Typenvarchar30
27BBPC_TEXT_XMLXML Communication of Texts2PROC_TYPEBusiness Transaction Typenvarchar40
28BBPD_THRESH_CHKContains threshold values for Contract Header and Item2PROC_TYPEBusiness Transaction Typenvarchar40
29CNVMBTACTGRPActivity Groups3PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
30CNVMBTACTGRPRELActivity Group Relation table2PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
31CNVMBTCODEAPPCodeAppends4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
32CNVMBTDEXHEADDMIS PCL Data Extract Header information17PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
33CNVMBTPROCDESTMBT PCL: Required Destinations for Process Types1PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
34CNVMBTPROCDISTMaintaining the distribution of destintions1PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
35CNVMBTPROCRESTRCNV MBT Process Type restriction message1PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
36CNVMBTPROCTYPEMaster data for MBT / PCL procedure types1PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
37CNVMBTPROCTYPE_TDescriptions for MBT / PCL procedure types1PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
38CNVMBTSCAPPLScrambling Applications4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
39CNVMBTSCCDSETConditionSet4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
40CNVMBTSCCDSETTConditionSetText4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
41CNVMBTSCCUCOScramblingRule Code Customizing4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
42CNVMBTSCCUCOPARSScramble Rule Parameters4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
43CNVMBTSCFDSETFieldSet4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
44CNVMBTSCFDSETTFieldSetText4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
45CNVMBTSCGRPScramblingGroup4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
46CNVMBTSCGRPTScramblingGroupText4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
47CNVMBTSCKYSETKeySet4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
48CNVMBTSCOPRDOperands4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
49CNVMBTSCSCCUScramblingRule Customizing4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
50CNVMBTSCSCCUTScramblingRule Customizing4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
51CNVMBTSCSCRLScramblingRule4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
52CNVMBTSCSCRLTScramblingRule Text4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
53CNVMBTSCSETScramblingSet4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
54CNVMBTSCSETTScramblingSetText4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
55CNVTDMSSCR_APLNKLink Table : Connects Rules and Proc Types5PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
56CNVTDMSSCR_PROCProc Types for Scrambling.4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
57CNVTDMSSCR_PROCTProc Types Texts.4PROC_TYPEMBT PCL Type of MIgration Processnvarchar100
58CNV_MBT_SWITCH_DDetailed Table for storing values from Switch Framework2PROC_TYPEPackage Number of Transformation / Analysis Packagenvarchar50
59CNV_MBT_SWITCH_MMaster Table for storing values from Switch Framework2PROC_TYPEPackage Number of Transformation / Analysis Packagenvarchar50
60T7BREFD_INFRRAAdditional information - income received cumulatively5PROC_TYPELawsuit typenvarchar10
TOPAccounts Receivable Accounting Process Integration
61FDM_DCPROCFSCM-DM Integration: Dispute Case Processes5PROC_TYPEType of Processnvarchar100
TOPCollectionsDisbursements
62IBROSTMHISCD: Broker Report - Header Data14PROC_TYPEBroker Report: Processing Typenvarchar10
TOPData Mining
63RSDMTPN_COL_VALModel Column Values4PROC_TYPEValue processing typenvarchar100
TOPDocument Management System
64DMS_PROC01DMS - Processes4PROC_TYPEProcess Categorynvarchar50
65TDWSEXITFind Document: Function Module for User Exits3PROC_TYPEProcess Categorynvarchar50
TOPFinancial Accounting
66/OPT/VIM_T005ACharacteristic Specific Process Types Confugration3PROC_TYPEProcess Typenvarchar30
67/OPT/VIM_T100Document Type Definition9PROC_TYPEProcess Typenvarchar30
68/OPT/VIM_T102Document Allowed Process Types3PROC_TYPEProcess Typenvarchar30
69/OPT/VIM_T800Process Type Definition2PROC_TYPEProcess Typenvarchar30
70/OPT/VIM_T800TProcess Type Texts2PROC_TYPEProcess Typenvarchar30
71/OPT/VIM_T802User Process Options2PROC_TYPEProcess Typenvarchar30
72/OPT/VW_PROC_CHKTable to check Process Type for DP document3PROC_TYPEProcess Typenvarchar30
TOPIncentive and Commission Management ICM
73TCACS_BR_FLDSBusiness Rule Editor: Fields used for a particular ICM appl2PROC_TYPEBusiness Rule Editor: Process typenvarchar20
74TCACS_BR_SELBusiness Rule Editor: Selection Criteria for fields2PROC_TYPEBusiness Rule Editor: Process typenvarchar20
TOPJoint Venture und Production Sharing Accounting
75T8JFRMFarm In/Out & Re-Determination (Farm) Main Table22PROC_TYPEFarm In/Out Processing Typenvarchar10
TOPPicking
76/VSO/P_RSLT_PLTHResult of VSO: Packing Proposal (Header Data)15PROC_TYPEProcess Type of a Packing Proposal for VSOnvarchar10
TOPRevenue
77OIUE2_PROCProc 2.0 - Processes3PROC_TYPEProc 2.0 - Process Typenvarchar100
78OIUE2_PROC_TYPEProc 2.0 - Process Types2PROC_TYPEProc 2.0 - Process Typenvarchar100
79OIUE2_PROC_TYPETProc 2.0 - Process Type Texts3PROC_TYPEProc 2.0 - Process Typenvarchar100
80OIUE2_TYPE_TABProc 2.0 - Process Type Tabs2PROC_TYPEProc 2.0 - Process Typenvarchar100
81OIUE2_TYPE_TABTProc 2.0 - Process Type Tab Texts3PROC_TYPEProc 2.0 - Process Typenvarchar100
TOPService Station Retailing
82OIRC_DRREJSSR Stocks - Dip readings rejected records135PROC_TYPESSR Fuels - Process typenvarchar10
83OIRC_MRREJSSR Meters - Meter readings rejected records66PROC_TYPESSR Fuels - Process typenvarchar10
84OIRC_PRCHKSSR Pricing - Price check17PROC_TYPESSR Fuels - Process typenvarchar10
85OIRECOMPACTSSR PC: Complaint action3PROC_TYPESSR PC: Clearing House Processing Typenvarchar40