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

38 columns | Print definition?ERP 6.0  | NUMB

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ARBA/PARAM_TABAriba table to store configurable parameters4NUMBABAP: Current selection numbernvarchar40
2/SAPQUERY/TEXT01Table for Texts (Headers)4NUMBNatural Numberint100
3/SAPQUERY/T_T_01Test for Texts in Headers2NUMBNatural Numberint100
4/SLOAE/EX_BATCHSelect options for batch processing6NUMBtinyint30
5/SLOAE/EX_BATCH1Select options for batch processing6NUMBint100
6CNVTDMS_06_EXCLUExcluding Table for TDMS Cross-Application8NUMBCounter for entries by objectnvarchar100
7SCMA_CONT_EL_FCCElements of Workflow Container (TVARV Variable) for FCC3NUMBNatural Numberint100
8T7RU015ZUnit in words3NUMBNumbernvarchar50
9T7RUPFBCDPFR error BCDATA3NUMBNumbernvarchar20
TOPClient-System Adapter
10MDMFDBPRKeys and other attributes of feedback messages6NUMBMessage Numbernvarchar30
TOPCondition
11BKK96Account Balancing Detail Data11NUMBSequence numbernvarchar40
TOPCross-Application Components
12ETP_PARTNERTask Partner2NUMBTask Numbernvarchar120
13ETP_TASKSEasy Task Planning: Tasks2NUMBTask Numbernvarchar120
14ETP_TEXTHEADEREasy Task Planning: Texts for Task2NUMBTask Numbernvarchar120
15ETP_TEXTLINESEasy Task Planning: Text Rows for the Task2NUMBTask Numbernvarchar120
TOPEmployee Self-Service
16T77WWW_WHO_SRDESS Who's Who: Field Selection per Country Grpg & Appl.Type7NUMBSAP Query (S): Field group namenvarchar20
TOPInterest Calculation
17T056ITime-dep.terms for interest calc.rule6NUMBSequence Numbernvarchar150
TOPJust-In-Time Processing
18JITTC1Subscreen Profile for Tree Control6NUMBNumber of Calls in a Rowint100
TOPLogical Database Builder
19RSDSQGTFunctional Group Texts in Selection Views5NUMBFunctional group IDsnvarchar20
TOPLogical DB, Selection Screens, Selection Variants
20TVARUVNIndividual Variant Variable: Assignment TVARV4NUMBNumber for building up key in TVARVnvarchar60
21TVARVTable of variables in selection criteria3NUMBABAP: Current selection numbernvarchar40
22TVARVCTable of Variant Variables (Client-Specific)4NUMBABAP: Current selection numbernvarchar40
TOPMessages
23DNOD_NOTIFNotification Header15NUMBNotification Number (External)nvarchar120
24DNOD_NOTIF_HNotification: Hierarchy10NUMBNotification Number (External)nvarchar120
TOPPeriodical Sales and Distribution
25TJY19IS-M/SD: Dynamic Maintenance of Variables in Table TVARV6NUMBABAP: Current selection numbernvarchar40
TOPPersonnel Administration
26T7GR1HR10TEmployer Department (Texts)8NUMBStreet Numbernvarchar60
TOPProfitability Analysis
27TKECHACOADP_3Copy Prof. Segments for Op. Concern Split: Administration10NUMBSingle-Character Indicatornvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
28/ISHFR/TNWFR_F21Absence Control12NUMBMaximum Number of Units That Can Be Calculatednvarchar50
TOPSAP Note Assistant
29CWB_HIST_DCorrection Workbench: History Data3NUMBVersion Management: Version Numbernvarchar50
30CWB_HIST_HCorrection Workbench: History Header2NUMBVersion Management: Version Numbernvarchar50
31CWB_HIST_OCorrection Workbench: History Object Data2NUMBVersion Management: Version Numbernvarchar50
TOPService Data Download
32/BDL/BDLSERVICEService Definition, Contract types4NUMBnvarchar80
33/SDF/BDLSERVICEContract types2NUMBnvarchar80
34/SDF/SERVSTRUCContract types3NUMBnvarchar80
35BDLSERVICEContract types3NUMBnvarchar80
TOPTraining and Event Management
36T77KFTransfer of Business Event Costs to Controlling5NUMBDocument numbernvarchar100
TOPTravel Expenses
37T706WWWHTML Links and File Paths4NUMBNumeric 1-characternvarchar10
38T706WWW_TXTText Table HTML Links and File Paths5NUMBNumeric 1-characternvarchar10