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

30 columns | Print definition?ERP 6.0  | USER_STATUS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ORS/USERMAPOptura User Mapping Object3USER_STATUSUser Mapping Object Statusnvarchar10
2/SAPF15/ELKOHKR1F15 ELKO Daten aus HKR 138USER_STATUSnvarchar10
3/SAPF15/ELKOHKR2F15 ELKO Daten aus HKR 2 Satzart 2 + HKR 647USER_STATUSnvarchar10
4/SAPF15/ELKOHKR4F15 ELKO Daten aus HKR 429USER_STATUSnvarchar10
5/SAPF15/ELKOHKR5F15 ELKO Daten aus HKR 533USER_STATUSnvarchar10
6/SAPF15/ELKOHKRZF15 ELKO Daten aus HKR 2 Satzart 322USER_STATUSnvarchar10
7/SAPF15/ELKOZM_VF15 Daten aus ZÜV 101, alte Versionen29USER_STATUSnvarchar10
8/SAPF15/ELKOZUV1F15 ELKO Daten aus ZÜV 10028USER_STATUSnvarchar10
9/SAPF15/ELKOZUV2F15 ELKO Daten aus ZÜV 20025USER_STATUSnvarchar10
10/SAPF15/ELKOZUV5F15 ELKO Daten aus ZÜV 50024USER_STATUSnvarchar10
11/SAPF15/ELKOZUV6F15 ELKO Daten aus ZÜV 60022USER_STATUSnvarchar10
12/SAPF15/ELKOZUV9F15 ELKO Daten aus ZÜV 90018USER_STATUSnvarchar10
13/SAPF15/ELKOZUVMF15 Daten aus ZÜV 10128USER_STATUSnvarchar10
14/SMERP/STG_PM001Data staging - Equipment complex table181USER_STATUSDisplay lines for user statusnvarchar400
15/SMERP/STG_PM002Data staging - Functional Location complex table112USER_STATUSDisplay lines for user statusnvarchar400
16/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab175USER_STATUSDisplay lines for user statusnvarchar400
17/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab115USER_STATUSDisplay lines for user statusnvarchar400
TOPBasis Components
18/XFT/INV_C4Possible User Status2USER_STATUSUser statusnvarchar100
19/XFT/INV_QInvoice receipt queue: Header120USER_STATUSUser statusnvarchar100
20/XFT/INV_Q_SInvoice receipt queue: Header120USER_STATUSUser statusnvarchar100
TOPEvaluations
21DPR_DASHBOARDDashboard Data for Project16USER_STATUSUser Status for an Objectntext10737418230
TOPMaster Data
22GMFGC_1Obsolete - do not use4USER_STATUSUser-Defined Statenvarchar50
23GMFGC_USERField group criteria (Grants) system+user status5USER_STATUSUser-Defined Statenvarchar50
24GMGRGrant Master45USER_STATUSUser Statusnvarchar50
25GMSMVALUETYPEValue type control by grant type and status4USER_STATUSUser-Defined Statenvarchar50
26GMSTATNETGrants Management Status Network5USER_STATUSUser-Defined Statenvarchar50
27GMSTATNETHISTORYHistorical status information Sponsored Programs Mgmt5USER_STATUSUser-Defined Statenvarchar50
28GMWFGRANTMGM Workflow Grant Master6USER_STATUSUser Statusnvarchar50
TOPRecipe
29RCPC_SPEC_USTATECustomizing User Status5USER_STATUSUser Statusnvarchar50
TOPWork Clearance Management
30WCCPWCM: WCM Object <-> Approvals17USER_STATUSControlled User Status for Issuing Approvalnvarchar50