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

48 columns | Print definition?ERP 6.0  | SEQUENCE_NUMBER

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X152OPENTEXT: Approval Diagnostic Program Units3SEQUENCE_NUMBEROpentext: sequence number data elementnvarchar30
2/OPT/Y152OPENTEXT: Approval Diagnostic Program Units3SEQUENCE_NUMBEROpentext: sequence number data elementnvarchar30
3/OPT/Z152OPENTEXT: Approval Diagnostic Program Units3SEQUENCE_NUMBEROpentext: sequence number data elementnvarchar30
4/ORS/DIAG_PUNITSOPENTEXT: Approval Diagnostic Program Units3SEQUENCE_NUMBEROpentext: sequence number data elementnvarchar30
5/UIF/LREPDATTRLRep content table3SEQUENCE_NUMBERDummy for B20 int1 (Local Everywhere)tinyint30
6/UIF/LREPDATTRCDLRep content table - client-dependent4SEQUENCE_NUMBERDummy for B20 int1 (Local Everywhere)tinyint30
7/UIF/LREPDATTRULRep content table - user-dependent5SEQUENCE_NUMBERDummy for B20 int1 (Local Everywhere)tinyint30
8CIAP_D_SUSPCIAP Records that were manually suspended3SEQUENCE_NUMBERSuspension Numbernvarchar30
9LTR_EXITCustomizable exit for LTR objects4SEQUENCE_NUMBERSequence Numbernvarchar50
10TN1MCI_STEPProcessing Steps of a Communication Process5SEQUENCE_NUMBERProcessing Step Sequencenvarchar30
TOPBack Office
11TRST_RECON_TXTText for the Editor3SEQUENCE_NUMBERSequence Number for Text Editor Tableint100
TOPBRFplus - ABAP-Based Business Rules
12FDT_EXPR_1910FDT/BRF: Expression - Select for table request4SEQUENCE_NUMBERFDT/BRF: Sequence numbernvarchar40
13FDT_EXPR_1910AFDT/BRF: Expression - Select for table request4SEQUENCE_NUMBERFDT/BRF: Sequence numbernvarchar40
14FDT_EXPR_1910SFDT/BRF: Expression - Select for table request3SEQUENCE_NUMBERFDT/BRF: Sequence numbernvarchar40
15FDT_EXPR_1910TFDT/BRF: Expression - Select for table request3SEQUENCE_NUMBERFDT/BRF: Sequence numbernvarchar40
16FDT_EXPR_4003FDT: BRMS Connector Call Parameters4SEQUENCE_NUMBERFDT: Sequence numbernvarchar100
17FDT_EXPR_4003AFDT: BRMS Connector Call Parameters4SEQUENCE_NUMBERFDT: Sequence numbernvarchar100
18FDT_EXPR_4003SFDT: BRMS Connector Call Parameters3SEQUENCE_NUMBERFDT: Sequence numbernvarchar100
19FDT_EXPR_4003TFDT: BRMS Connector Call Parameters3SEQUENCE_NUMBERFDT: Sequence numbernvarchar100
TOPBusiness Rule Framework
20FDT_EXPR_1960FDT/BRF: Expression - Select for table request4SEQUENCE_NUMBERFDT/BRF: Sequence Numbernvarchar40
21FDT_EXPR_1960AFDT/BRF: Expression - Select for table request4SEQUENCE_NUMBERFDT/BRF: Sequence Numbernvarchar40
22FDT_EXPR_1960SFDT/BRF: Expression - Select for table request3SEQUENCE_NUMBERFDT/BRF: Sequence Numbernvarchar40
23FDT_EXPR_1960TFDT/BRF: Expression - Select for table request3SEQUENCE_NUMBERFDT/BRF: Sequence Numbernvarchar40
24TBRF128BRF: Logical Operators - Operands8SEQUENCE_NUMBERSequence Numbernvarchar40
25TBRF133BRF: Range - Statement Select-Option Data6SEQUENCE_NUMBERSequence Numbernvarchar40
26TBRF171BRF: Subactions17SEQUENCE_NUMBERSequence Numbernvarchar40
27TBRF210BRF: Assignment of Event, Expression, Action25SEQUENCE_NUMBERSequence Numbernvarchar40
28TBRF211Obsolete - BRF: Assignment of Event, Expression, Action25SEQUENCE_NUMBERSequence Numbernvarchar40
29TBRF270BRF: Actions in Expressions13SEQUENCE_NUMBERSequence Numbernvarchar40
30TBRF310BRF: Rule Set/Event/Expression/Action Assignment22SEQUENCE_NUMBERSequence Numbernvarchar40
31TBRF311BRF: Rule Set/Event/Expression/Action Assignment21SEQUENCE_NUMBERSequence Numbernvarchar40
32TBRF800BRF: Demo: Assignment Event, Function, Action21SEQUENCE_NUMBERSequence Numbernvarchar40
TOPCapacity and Resource Planning
33/MRSS/C_RM_QK_CCustomizing table for Quick Close / Book4SEQUENCE_NUMBERStatus Order Numbernvarchar20
TOPClaims Management
34TICL928For BRF: Tasks/Prompting Action21SEQUENCE_NUMBERSequence Numbernvarchar40
35TICL941Line of an "Old Rule"6SEQUENCE_NUMBERSequence Numbernvarchar40
36TICL943Rules in Claims Management System10SEQUENCE_NUMBERSequence Numbernvarchar40
37TICL944Rules in Rule Sets in Claims Management System10SEQUENCE_NUMBERSequence Numbernvarchar40
38TICL961BRF/ICLE: Rules in Events - Only Through 47215SEQUENCE_NUMBERSequence Numbernvarchar40
39TICL963BRF/ICLE: Rules in Events12SEQUENCE_NUMBERSequence Numbernvarchar40
TOPClinical System
40N2GL_TM_STEPpathways Step of Patient Pathway8SEQUENCE_NUMBERSequence Numberint100
TOPControlling
41QISRSCENARIOACTActivities for Scenario5SEQUENCE_NUMBERSequence Numbernvarchar30
TOPDevelopment Workbench
42BSPWD_WB_SETUPWorkbench setup definitions3SEQUENCE_NUMBER2 byte integer (signed)smallint50
TOPEnterprise Search Integration
43CRMD_ES_LOGSStores logs per template4SEQUENCE_NUMBERSequence numbernvarchar20
TOPFinland
44T7FIVACWage types, constants and rules for Vacation Statement4SEQUENCE_NUMBERSequence numbernvarchar20
TOPJoint Venture und Production Sharing Accounting
45T8JOH_COMPLEX_FTable of Complex Formulas in Overhead Organizer5SEQUENCE_NUMBERJV Sequence Numbernvarchar20
TOPPerishables Procurement
46FIP_D_MR_ITEMMaterial Range Item4SEQUENCE_NUMBERSequence number of the material in priority.int100
TOPProvisioning
47SPCIPSPLMNTSPEC2000: Stores Additional/Long/MultipleOccurance fields15SEQUENCE_NUMBERSPEC2000: Sequence Numbernvarchar30
TOPWeb Dynpro ABAP Rendering
48WDR_ADP_AGR_P_MPWeb Dynpro Runtime: Parameter of Adapter Aggregations4SEQUENCE_NUMBERNatural Numberint100