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

50 columns | Print definition?ERP 6.0  | SCREEN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSONAS/C_CLOVPersonas : Control ID overwrite rules4SCREENScreen numbernvarchar40
2/PERSONAS/C_SCOVPersonas : Screen ID overwrite rules4SCREENScreen numbernvarchar40
3/PERSONAS/FLVSCRPersonas : Flavor to Program Screen mappings4SCREENScreen numbernvarchar40
4/PERSONAS/MIGMAPStorage of mappings necessary for migration.3SCREENScreen numbernvarchar40
5BBPC_PDC_UI_EXTExternal Screen Objects in SRM Applications12SCREENDynpro Numbernvarchar40
6BBP_CUF_SCR_GENAssignment of Generated Dynpros to CUF Tables2SCREENDynpro Numbernvarchar40
7T496FCIM order: Form description of the list11SCREENIndicator: Display print layoutnvarchar10
8TICL002_MCScreen Selection for Multiple Contract Handling7SCREENScreen for 'Multiple Contract Handling'nvarchar40
TOPBasic Functions
9T800AFI-SL tables28SCREENScreen number for summary record displaynvarchar40
TOPBasis-Related Help Functions, Appl. Log, Formula Intepreter
10TALV_GRIDALV Grid IDs5SCREENScreen on Which the ALV Grid Is Displayednvarchar40
TOPBatches
11TBICFSelection Fields for Batch Information Cockpit - Standard -3SCREENSelection tab titles for Batch Information Cockpitnvarchar40
12TBICFUSelection Fields for Batch Information Cockpit6SCREENSelection tab titles for Batch Information Cockpitnvarchar40
13TBICSSelection Tab Titles for Batch Info. Cockpit - Standard -1SCREENSelection tab titles for Batch Information Cockpitnvarchar40
14TBICSTTexts for BIC Selection Tab Titles - Standard -2SCREENSelection tab titles for Batch Information Cockpitnvarchar40
15TBICSUSelection Tab Titles for Batch Information Cockpit4SCREENSelection tab titles for Batch Information Cockpitnvarchar40
16TBICSUTTexts for Batch Information Cockpit Selection Tab Titles5SCREENSelection tab titles for Batch Information Cockpitnvarchar40
TOPBusiness Consolidation
17UCSSCR10Assignments of Cons Area + Task Category to Sel. Screen5SCREENScreen numbernvarchar40
18UCSSCR15Assignments of Cons Area + Task Type to Sel. Screen7SCREENDynpro Numbernvarchar40
19UCSSCR20Assignment of Cons Area to Generated Programs/Screens6SCREENDynpro Numbernvarchar40
20UCSSCR25Assignment of Data Stream to Generated Screens (Source DBs)5SCREENDynpro Numbernvarchar40
21UCSSCR30Screen Directory for Printing Master Data Characteristics6SCREENDynpro Numbernvarchar40
22UCSSCR35Assignment of Data Basis to Generated Programs/Screens6SCREENDynpro Numbernvarchar40
23UCSSCR40Asgt of Cons Area + Method Category and Program + Sel.Screen6SCREENScreen numbernvarchar40
TOPCross-Application Components
24/IXOS/DC61_CRESCCM: Create Screen settings6SCREENCM: Create Screennvarchar100
TOPDocument Management System
25TDWODScreen for DMS Object Link3SCREENScreen numbernvarchar40
TOPGlobal Trade Services
26/SAPSLL/USRORGAssignment of Organizational Unit to User5SCREENCharacter field, length 32nvarchar320
TOPGovernance, Risk and Compliance
27GRFNOBJSCRMap between object type and WD screen2SCREENUI Identifiernvarchar400
28GRFNSCRIdentifier for WD screen1SCREENUI Identifiernvarchar400
TOPMaterial Master
29WER_ACT_CCustomizing action types4SCREENDynpro Numbernvarchar40
30WER_ACT_SStandard action types3SCREENStandard Screennvarchar40
31WER_EXP_CCustomizing expression types4SCREENDynpro Numbernvarchar40
32WER_EXP_SStandard expression types3SCREENStandard Screennvarchar40
TOPMedia Product Sales and Distribution
33TJKSDAPPLIS-M: Application Table for Programs4SCREENDynpro Numbernvarchar40
34TJKSDTOOLBARANWToolbar Functions for Applications3SCREENView Name for Toolbar Functionnvarchar40
35TJKSDTOOLBARFUNCIS-M: Toolbar Functions3SCREENView Name for Toolbar Functionnvarchar40
36TJKSDTOOLBARFUNTIS-M: Text Table for Toolbar Functions3SCREENView Name for Toolbar Functionnvarchar40
TOPNetwork and Activity
37TCNTSPermissible subscrrens per object3SCREENDynpro Numbernvarchar40
TOPPayment Item
38TBKKI_06Field Modifications for Payment Order3SCREENScreen Number for Field Controlnvarchar40
TOPPayment Transactions
39FPRL_TABSTab Attributes3SCREENTab Screennvarchar40
TOPPurchasing
40MPNCL1Dynamic Calls During Processing of Sub-Items5SCREENNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPSAP Internet Transaction Server
41ITSTESTITS Test: Who has carried out which transaction3SCREENDynpro Numbernvarchar40
42ITSTESTMOBITS Mobile Test Screens1SCREENDynpro Numbernvarchar40
43ITSTESTRBXITS Test: Who has carried out which transaction3SCREENDynpro Numbernvarchar40
TOPSpecification
44/PLMI/SPC_IDLIDSpec-UI: Define IDLID3SCREENScreen for Identification Listingnvarchar100
TOPSyntax, Compiler, Runtime
45TTPDACARRIERIDADtpda: System Settings - Container Screens - Technic. Details4SCREENCHAR04 data element for SYSTnvarchar40
TOPTraders and Schedulers Workbench
46TOIJ_NOMV_CAPTCCustomized screen sequence for tabstrip captions5SCREENAvailable screensnvarchar40
47TOIJ_NOMV_CAPTCTCustomized screen sequence for tabstrip captions6SCREENAvailable screensnvarchar40
48TOIJ_NOMV_CAPTSAvailable screens for tabstrip captions3SCREENAvailable screensnvarchar40
49TOIJ_NOMV_CAPTSTAvailable screens for tabstrip captions4SCREENAvailable screensnvarchar40
TOPWeb Service Tools - ABAP
50ESD_ADD_DATA_REGobsolete, - not used any more but already delivered4SCREENDynpro Numbernvarchar40