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

86 columns | Print definition?ERP 6.0  | SEQ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ORS/RECENTUSERMost Recently Selected Users5SEQTwo digit numbernvarchar20
2/PERSOS/CONTCHNGControl Changes data5SEQSequence Number - Generated by the Personas Clientint100
3/PERSOS/CONTLOTRAlias data releted to Control changes4SEQSequence Number - Generated by the Personas Clientint100
4DMS_VEG_VSSSearch sequence for viewable file5SEQSequence Numbernvarchar30
5GRACBGNAMEVALUEName Value pairs for Background Parameter Value4SEQPPF App Param Sequence.smallint50
6GRACBGPERMISSIONName Value Pairs for Background Job Permission Parameter4SEQ2 byte integer (signed)smallint50
7GRACBGRANGERange table values for Background Job variant6SEQPPF App Param Sequence.smallint50
8GRACBGRULEGENBackground Rule Generation.3SEQPPF App Param Sequence.smallint50
9GRACBGTECHROLEStores values for Background Job Parameter Value4SEQ2 byte integer (signed)smallint50
10GRACMENUAUTHAuth mapping table for AC IA.2SEQDummy for B20 int1 (Local Everywhere)tinyint30
11GRACPPFILTERRNGGlobal Application Parameter for Risk Analysis PPF.7SEQPPF App Param Sequence.smallint50
12GRACPPOBJATTGlobal Application Parameter for Risk Analysis PPF.6SEQPPF App Param Sequence.smallint50
13GRACPPOBJDATARisk Analysis PPF Runtime Package Data.4SEQPPF App Param Sequence.smallint50
14GRACPPOBJRNGGlobal Application Parameter for Risk Analysis PPF.7SEQPPF App Param Sequence.smallint50
15GRACPPRSRNGGlobal Application Parameter for Risk Analysis PPF.5SEQPPF App Param Sequence.smallint50
16GRACPPSYSRNGGlobal Application Parameter for Risk Analysis PPF.5SEQPPF App Param Sequence.smallint50
17GRFNFDSSTGAFlexible Data Store - Storage Type Group Assignment2SEQObject Sequence Numberint100
18GRFNFDSSTGAMFFlexible Data Store - Allowed sub scenarios to use file2SEQObject Sequence Numberint100
19GRFNJOBPCTXJob Step Context4SEQObject Sequence Numberint100
20GRFNJOBPRSTCTXJob Step Result - Context4SEQObject Sequence Numberint100
21GRFNMENUPFCGPFCG Auth Mapping Table2SEQSequence Numbernvarchar50
22GRRMOBAGBUFHIERAgrregation result buffer - objects hierarchy7SEQAggregation buffer - Sequencenvarchar60
23IWP_HDB_QUERY_VContains mapping of Reporting package to Query Views7SEQint100
24T7CNREW_APRHISPayroll approval item history3SEQ2-Digit Numeric Valuenvarchar20
TOPBalanced Scorecard
25UMB_SC197Scorecard: Initiative: Milestones5SEQSequencedecimal30
26UMB_WEB_APPTable of Web Applications for Launchpad8SEQtinyint30
TOPBusiness Analytics
27UABATIMPVARSELSelection Condits in Variants for Batch Import, PDCE, EhP44SEQ2 byte integer (signed)smallint50
28UABSCEBATIMPTable to store SCE variants, PDCE, Ehp43SEQ2 byte integer (signed)smallint50
29UABXMLBATIMPtable for XML, batch import, PDCE, Ehp43SEQ2 byte integer (signed)smallint50
TOPClaims Management
30ICL_CWTHDRWSQTMaintenance: Define Sequence of Withdrawal3SEQPosition in Withdrawal Sequencenvarchar20
TOPClinical System
31N2TBS_SM_VALUEIS-H*MED LTE: Markers8SEQSequencenvarchar50
32N2TBS_SM_VAL_SETLTE: Marker Values for Sets7SEQSequencenvarchar50
33TN2_LTE_SM_VALUEIS-H*MED LTE: Marker Values4SEQSequencenvarchar50
TOPCorporate Performance Monitor
34UMR_RI141RMS: Risk-Reducing Activities - Milestones6SEQSequencedecimal30
TOPCustomer Interaction Center
35CDESTBDCFIELDOnline BDC value destination map3SEQBatch Input Session Sequencenvarchar30
36CDESTPIDOnline BDC parameter-id preset destination3SEQBatch Input Session Sequencenvarchar30
37CIMAPInput Sequence for BDC Sessions3SEQBatch Input Session Sequencenvarchar30
38COMAPOnline BDC output mapping from message table to container3SEQBatch Input Session Sequencenvarchar30
39CSRCCONSTANTOnline BDC constant value source map3SEQBatch Input Session Sequencenvarchar30
40CSRCCONTAINEROnline BDC container value source map3SEQBatch Input Session Sequencenvarchar30
41CSRCFCALLOnline BDC function call value source map3SEQBatch Input Session Sequencenvarchar30
TOPData Retention Tool
42TXX_CONControl Information: SAP Segments3SEQSequence for Segment Extractionnvarchar50
43TXX_C_CONControl Information: Customer-Specific Segments3SEQSequence for Segment Extractionnvarchar50
TOPDocument
44/PLMI/DIR_VSSPLM: search sequence for viewable file4SEQSequence Numbernvarchar20
TOPDocument Builder
45/IPRO/TA_CONFIGConfig data table4SEQOne Alphanumeric Digitnvarchar10
TOPFinland
46T7FIHPA1Customizing Table for Holiday Pay Accrual Report6SEQSequence numbernvarchar20
TOPJoint Venture und Production Sharing Accounting
47T8JFRM_ACCTJV Farm In/Out Intercompany adjustment accounts4SEQJV Sequence Numbernvarchar20
48T8JFRM_STPFarm In/Out & Re-Determination (Farm) Main Table4SEQJV Sequence Numbernvarchar20
TOPMicrosoft SQL Server
49MSSDEADLCKDatabase Deadlock Information for MSSQL Server11SEQDeadlock sequence numberint100
TOPPerformance Monitors TCC
50GVD_SESSION_WAITOracle monitoring: Copy of GV$SESSION_WAIT4SEQOracle monitoring: SEQ#decimal220
TOPProduction and Revenue Accounting
51OIUX2_DOWNLOADTax Reporting download table7SEQTax reporting sequence numbernvarchar100
52OIUY1_DOWNLOADThe intermediate table for download7SEQsequence numbernvarchar100
53OIUY1_TXDOWNLOADThe intermediate table for Texas download7SEQsequence numbernvarchar100
TOPPublic Sector Contract Accounts Receivable and Payable
54DFMCA_BRF174BRF: Message Variables (for Messages in Subactions)9SEQSequence Numbernvarchar40
55DFMCA_BRF175BRF: Literal as Message Variable (for Subactions)10SEQSequence Numbernvarchar40
56DFMCA_BRF178BRF: Message Variables (for Messages in Subactions)9SEQSequence Numbernvarchar40
57DFMCA_BRF179BRF: Literal as Message Variable (for Subactions)10SEQSequence Numbernvarchar40
TOPRecipe Development
58/PLMB/RCA_TABSView Sequence per Main View4SEQView Sequencenvarchar30
59/PLMB/RCA_TABSCView Sequence per Main View (Calculation Results)3SEQView Sequencenvarchar30
60/PLMB/RCA_TABSFView Sequence per Main View3SEQView Sequencenvarchar30
61/PLMB/RCP_SUBTYPAdditional Recipe Type4SEQSequencenvarchar40
62/PLMB/RCP_SUBUSGRecipe Customizing: Subordinated Recipe Purpose4SEQSequencenvarchar40
TOPResourcen Management
63RMXTC_T13Customizing: Assignment of Trial View to View Group4SEQView Sequenceint100
TOPRevenue
64OIUE2_PROC_STEPProc 2.0 - Process Steps4SEQProc 2.0 - Process Step Sequencenvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
65TNAFDIS-H: Outpatient Admission Fee Determination9SEQSequence Number of Admission Servicenvarchar30
TOPService Data Download
66/BDL/BDLSADATAService Definition, Definition of global variables9SEQSequential numberint100
67/BDL/BDLSAIFService Definition, Interface description6SEQSequential numberint100
68/SDF/RBE_CS3_ERRSQL Check Step Errors in SDA Analysis5SEQDummy for B20 int1 (Local Everywhere)tinyint30
69/SDF/RBE_CS3_JTable Joins of SQL Check Step in SDA Analysis3SEQ2 byte integer (signed)smallint50
70/SDF/RBE_CS3_SSQL Check Step Select Options in SDA Analysis5SEQDummy for B20 int1 (Local Everywhere)tinyint30
71BDLSADATADefinition of global variables in the Service Assistant8SEQSequential numberint100
72BDLSAIFInterface description for the service assistant5SEQSequential numberint100
73BDLTYPEDEFType pool definitions of Global Variables3SEQSequence numbernvarchar40
TOPSpecification 2
74SPCIPMAPSPEC2000: MetaData Information on IP Files4SEQSequence Numbertinyint30
75SPCIPTEISPEC2000: TEI to Explanation Code6SEQSequence in which the SPEC 2000 fields occur in the messagenvarchar20
TOPTax Reporting
76OIUX3_RPT_STEPXTax Reporting - Reporting/Step XRef4SEQReporting Step Sequencenvarchar30
TOPWork Clearance Management
77WCACHWCM: (Temporary) Log for Tagging/Untagging (Time-Frame)10SEQItemnvarchar60
78WCACIWCM: (Temporary) Log for Tagging/Untagging (Conflict Check)6SEQItemnvarchar60
79WCACNWCM: (Temporary) Log (Tag/Test Tag)12SEQItemnvarchar60
80WCACNQWCM: Log (Operational Tag)13SEQItemnvarchar60
81WCACQWCM: Log for Tagging/Untagging (Conflict Check)7SEQItemnvarchar60
82WCAITWCM: Work Clearance Document (Item)6SEQItemnvarchar60
83WCAMEWCM: (Temporary) Log of Operational Lists (Items)7SEQItemnvarchar60
84WCAMIWCM: Log of Operational Lists (Items)7SEQItemnvarchar60
85WCARWCM: Operational Step8SEQSequence of Operational Stepsnvarchar50
86WCCMSWCM: Operational Step5SEQSequence of Operational Stepsnvarchar50