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

34 columns | Print definition?ERP 6.0  | INSTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OTEB/SWF_TACTSxIM activities DocuLink tree selections10INSTIDKey value from DocuLink for SAP object or AL document linknvarchar1320
2/OTEB/SWF_WD_TMPTemporary storage of selected documents for Web UI workflows11INSTIDKey value from DocuLink for SAP object or AL document linknvarchar1320
3/OTEI/SWF_WD_TMPTemporary storage of selected documents for Web UI workflows11INSTIDKey value from DocuLink for SAP object or AL document linknvarchar1320
4J_3RF_TP_FL_FLKSObject keys for folders hierarchy model3INSTIDObject keynvarchar700
5PAPBSGB_HESA_CHESA Archive table for NISR Contract table9INSTIDHESA: Institution IDnvarchar40
6PAPBSGB_HESA_GRHESA Archive table for NISR Grade table9INSTIDHESA: Institution IDnvarchar40
7PAPBSGB_HESA_PHESA: Archive table for NISR Person table8INSTIDHESA: Institution IDnvarchar40
8PYD_D_ALPayroll Data Source Framework: Action Log2INSTIDPayroll Data Source Instance IDnvarchar300
9PYD_D_ALIPayroll Data Source Framework: Action Log Item2INSTIDPayroll Data Source Instance IDnvarchar300
10PYD_D_RESPayroll Data Source Result2INSTIDPayroll Data Source Instance IDnvarchar300
11PYD_D_RESOPayroll Data Source Result Object2INSTIDPayroll Data Source Instance IDnvarchar300
12PYD_D_RESOHPayroll Data Source Result Object History2INSTIDPayroll Data Source Instance IDnvarchar300
13PYD_D_RESOSPayroll Data Source Result Object Shadow2INSTIDPayroll Data Source Instance IDnvarchar300
14PYD_D_RESPPayroll Data Source Result Input Parameter2INSTIDPayroll Data Source Instance IDnvarchar300
15PYD_D_SHIPayroll Data Source Shadow Item8INSTIDPayroll Data Source Instance IDnvarchar300
16T5GPBSH_ICHESA: Institution Code2INSTIDHESA: Institution Identifiernvarchar40
17T5GPBSH_ISHESA: Institution Identifier2INSTIDHESA: Institution IDnvarchar40
18ZARIXBC2Archive Information Structure SAP_O_2_WI_0015INSTIDInstance Ident. in BOR Compat. Persistent Object Referencesnvarchar700
19ZARIXBC3Archive Information Structure WORKITEM5INSTIDInstance Ident. in BOR Compat. Persistent Object Referencesnvarchar700
20T7PIQ_GB_INST_HEHESA: Institution Codes2INSTIDHESA: HE institution last attendednvarchar40
TOPBusiness Process Engine
21SWFXIINB_TRC_DATWorkflow-Trace: Data Entries16INSTIDInstance Identification in Persistent Object Referencesnvarchar320
22SWFXIINB_TRC_SELWorkflow Trace: Selection Conditions for Trace Start11INSTIDInstance Identification in Persistent Object Referencesnvarchar320
TOPEnvironment, Health and Safety
23/TDAG/EHFNDD_GENWFF: Stored generic data of the TBO instances of the system2INSTIDInstance Identification in Persistent Object Referencesnvarchar320
24/TDAG/EHSRCD_MATable for persisting TBOs of type /TDAG/CL_TBO_MA2INSTIDInstance Identification in Persistent Object Referencesnvarchar320
25/TDAG/EHSRCD_MILTable for persisting TBOs of type /TDAG/CL_TBO_MIL2INSTIDInstance Identification in Persistent Object Referencesnvarchar320
26/TDAG/EHSRCD_RPTable for persisting TBOs of type /TDAG/CL_TBO_RP2INSTIDInstance Identification in Persistent Object Referencesnvarchar320
27/TDAG/EHSRCD_SPTable for persisting TBOs of type /TDAG/CL_TBO_SP2INSTIDInstance Identification in Persistent Object Referencesnvarchar320
TOPGeneral Object Relations
28SROBLROLCPersistent Roles of Business Classes2INSTIDInstance Identification in Persistent Object Referencesnvarchar320
TOPProcess Foundation
29EHFNDD_EVENT_HUBStorage for temp. data used by CL_EHFND_WFF_PCO_EVENT_HUB1INSTIDInstance Identification in Persistent Object Referencesnvarchar320
TOPSAP Business Workflow
30SWFPFRUNTIMEData for Runtime Collector5INSTIDInstance Identification in Persistent Object Referencesnvarchar320
31SWFRCRLINSTCorrelation Runtime: Instances7INSTIDInstance Ident. in BOR Compat. Persistent Object Referencesnvarchar700
32SWN_NOTIFWF Notif: Notifications16INSTIDInstance Identification in Persistent Object Referencesnvarchar320
33SWW_EVENTSWorkflow: Events in Workflow5INSTIDInstance Ident. in BOR Compat. Persistent Object Referencesnvarchar700
34SWW_WI2OBJWorkflow Runtime: Relation of Work Item to Object9INSTIDInstance Ident. in BOR Compat. Persistent Object Referencesnvarchar700