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  | USED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/D_DAG_ASGDemand Agr. Graph for Demand that is planned7USEDUsed Demand Aggregationdecimal1510
2/MRSS/D_DAG_DEMDemand Agr. Graph for Total and Attribute specific Demand7USEDUsed Demand Aggregationdecimal1510
3/MRSS/D_DAG_MOBOBSOLETE DB Table - NOT IN USE7USEDUsed Demand Aggregationdecimal1510
4/MRSS/D_DAG_PASDemand Agr. Graph for Preparation/Warp-up of Assignments7USEDUsed Demand Aggregationdecimal1510
5/MRSS/D_DAG_PDEDemand Agr. Graph for expected Prep/Warp-up of unpl. Dem.7USEDUsed Demand Aggregationdecimal1510
6/MRSS/D_DAG_RSBDemand Agr. Graph for virtual Reserve Base(non existing Dem)7USEDUsed Demand Aggregationdecimal1510
7/MRSS/D_DAG_RSVDemand Agr. Graph for virtual Reservation (non existing Dem)7USEDUsed Demand Aggregationdecimal1510
8/MRSS/D_DAG_TASDemand Agr. Graph for Travel Times of Assignments7USEDUsed Demand Aggregationdecimal1510
9/MRSS/D_DAG_TDEDemand Agr. Graph for expected Travel Times of unpl. Dem.7USEDUsed Demand Aggregationdecimal1510
10/MRSS/D_DAG_TRVOBSOLETE DB Table - NOT IN USE7USEDUsed Demand Aggregationdecimal1510
11/MRSS/D_DAG_UNADemand Agr. Graph for Demand that is not planned yet7USEDUsed Demand Aggregationdecimal1510
12DITAT_D_GRAPHAuto-created graphs2USEDBooleannvarchar10
TOPAerospace Defence Industry Solution
13ADTCF_MASTERADTCF - User Profile Master6USEDADTCF : Last used Profilenvarchar10
TOPCCMS Database Monitors for Oracle
14DBASPALMemory Allocation12USEDUsed memory space (kB) in reserved memorynvarchar120
TOPCheck Write
15OIUCW_LOTCONTROLCheck Lot Control Master3USEDOIUH_CHAR1nvarchar10
TOPCollaboration Folders
16CFX_NTF_TEMPLATETable for storing information about Notification Templates11USEDNatural Numberint100
TOPData Conversion
17DMC_WSTPTTemplates for Processing Steps6USEDDMC: Flag if work step is necessarynvarchar10
TOPData Staging
18RSSDBATCHTable for batch run scheduler (new)6USEDSingle-Character Indicatornvarchar10
19RSSDBATCHHISTTable for Background Run of Scheduler - Changes/History7USEDSingle-Character Indicatornvarchar10
20RSSDBATCHSHTable for Batch Run Scheduler (New)5USEDSingle-Character Indicatornvarchar10
TOPEngineering Change Management
21ECM_OBJADMObject Mgmt Records10USEDObject Management Record Is Usednvarchar10
TOPFinancial Accounting
22J_1GATFI-SL Activity: Transfer method in A/L4USEDIndicator: Used or notnvarchar10
TOPIncentive and Commission Management ICM
23TCACS_TMPL_EBExclude Field Groups for Contract Bundle Template6USEDFlag: Field Group in Contract Template to be Filled?nvarchar10
24TCACS_TMPL_EXExclude Field Groups for Contract Template6USEDFlag: Field Group in Contract Template to be Filled?nvarchar10
TOPIndustry Solution Catch Weight Management
25/FMP/D_MP_HISTMaterial Price History15USEDPrice Has Been Used for Price Changenvarchar10
26/FMP/D_MP_PRICMaterial Prices14USEDPrice Has Been Used for Price Changenvarchar10
TOPMicrosoft SQL Server
27DBSTATTMSSTable sizes11USEDMS SQL Server number of used pages of a tableint100
TOPPayroll
28T7SIBUBank Units Slovenia17USEDEnomestna oznakanvarchar10
TOPPlanning
29RSPLS_CR_STEPSRelationships Between Characteristics in Basic InfoProvider19USEDRelationship Is Being Used 'X' or Ignored ' 'nvarchar10
30RSPLS_DSData Slices6USEDData Slice Is Being Used 'X' or Ignores ' 'nvarchar10
TOPService Data Download
31/BDL/BDLFUPIMPService Definition, import parameters for interface13USEDOptional parametersnvarchar10
32BDLFUPIMPDefinition of import parameters for one function version12USEDParameter usednvarchar10
TOPSmart Forms
33STXSCHARSmart Styles: Character Formats27USEDSAP Smart Forms: General Indicatornvarchar10
34STXSHEADSmart Styles: Style Header24USEDSAP Smart Forms: General Indicatornvarchar10
35STXSPARASmart Styles: Paragraph Formats50USEDSAP Smart Forms: General Indicatornvarchar10
TOPStatus and Action Management
36SAMDT_SCHEMASS&AM Schemas13USEDSingle-Character Indicatornvarchar10
TOPTransaction Manager
37TCORFTS_MAP_PRMParameter Groups in Mapping5USEDField Group of Sourcenvarchar150
TOPTreasury
38JBDT56PReference interest rate table dependent on exact time6USEDAccess indicator for ref. int. rates depend. on exact timenvarchar10