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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

44 columns | Print definition?ERP 6.0  | STATUS_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/MRSS/C_BUND_STAUser Status Exclusion table for Bundling2STATUS_TYPEType of Abstract MRS Statusnvarchar100
2/MRSS/C_LN_SGRSIndividual Status of Status Group3STATUS_TYPEType of Abstract MRS Statusnvarchar100
3/MRSS/C_SGX_PRBKPre Booking2STATUS_TYPEType of Abstract MRS Statusnvarchar100
4/MRSS/C_SGX_WDGSDmenad Status table4STATUS_TYPEType of Abstract MRS Statusnvarchar100
5/MRSS/M_AUT_ASGNMirror for Control table for automatic assignment creation14STATUS_TYPEType of ERP Statusnvarchar100
6/MRSS/M_MAPSTATMirror for Mapping of R/3 status4STATUS_TYPEType of ERP Statusnvarchar100
7/MRSS/M_PREV_DELMirror for Prevent Deletion of Operations9STATUS_TYPEType of ERP Statusnvarchar100
8/MRSS/M_STAT_CTRMirror for Status Control for Assignment Operations9STATUS_TYPEType of Abstract MRS Statusnvarchar100
9WBCPM_C_IVTY_ICPM Calc Types per Status Type (for Item)2STATUS_TYPEStatus Type in Contract Processing Monitornvarchar40
10WBCPM_C_STATUSCPM Status (of an item in the Status List)2STATUS_TYPEStatus Type in Contract Processing Monitornvarchar40
11WBCPM_C_STATUS_TCPM Status Description3STATUS_TYPEStatus Type in Contract Processing Monitornvarchar40
12WBCPM_C_STA_TPCPM Calc Types per Status Type (for Header)2STATUS_TYPEStatus Type in Contract Processing Monitornvarchar40
13WBCPM_C_STA_TP_TCPM Status Type Description3STATUS_TYPEStatus Type in Contract Processing Monitornvarchar40
14WBCPM_C_VIEW_STPCPM Status Types per View Type3STATUS_TYPEStatus Type in Contract Processing Monitornvarchar40
TOPCapacity and Resource Planning
15/MRSS/C_MAPASTXTStatus texts for assignments2STATUS_TYPEType of R/3 statusnvarchar100
16/MRSS/C_MAPSTATMapping of R/3 status2STATUS_TYPEType of ERP statusnvarchar100
17/MRSS/C_STAT_CTRStatus Control for Assignment Operations7STATUS_TYPEType of Abstract MRS Statusnvarchar100
TOPClinical System
18TN2COM_STATTYPESStatus for Document Dispatch4STATUS_TYPEStatus Type in Dispatch Lognvarchar10
TOPERP related topics
19/MRSS/C_SNO_CTRLMRS: Resource Planning Relevance for Notifications4STATUS_TYPEType of ERP statusnvarchar100
20/MRSS/C_SNO_STCRControl Assignment Processing Based on Notification status4STATUS_TYPEType of Abstract MRS Statusnvarchar100
TOPGlobal Organization Customizing
21/MRSS/C_RQ_WK_STmap abstract status to portal drop down status5STATUS_TYPEstatus typetinyint30
TOPMaintenance Orders
22/MRSS/C_ABSTATAbstract Status2STATUS_TYPEType of Abstract MRS Statusnvarchar100
23/MRSS/C_ABSTAT_TAbstract Status: Texts2STATUS_TYPEType of Abstract MRS Statusnvarchar100
24/MRSS/C_AUT_ASGNControl table for automatic assignment creation12STATUS_TYPEType of ERP statusnvarchar100
25/MRSS/C_AUT_ASGSControl Automatic Asssignment Creation Based on Status Type4STATUS_TYPEType of Abstract MRS Statusnvarchar100
26/MRSS/C_NW_MAPSTMapping of Standard Status2STATUS_TYPEType of Abstract MRS Statusnvarchar100
27/MRSS/C_NW_STCTRStatus Control for Assignment Operations(Netweaver)4STATUS_TYPEType of Abstract MRS Statusnvarchar100
28/MRSS/C_PREV_DELPrevent Deletion of Operations7STATUS_TYPEType of ERP statusnvarchar100
29/MRSS/C_SGE_SINDDemand status individualization for assignments3STATUS_TYPEType of Abstract MRS Statusnvarchar100
30/MRSS/C_SGU_SGDSIndividual status in status groups4STATUS_TYPEType of Abstract MRS Statusnvarchar100
31/MRSS/C_SGU_SGRSIndividual status in status groups6STATUS_TYPEType of Abstract MRS Statusnvarchar100
32/MRSS/C_STATUSESPushbutton for User Status5STATUS_TYPEType of Abstract MRS Statusnvarchar100
33/MRSS/C_STAT_ACTMRS: Customizing for mapping of Status to Action on Assignm.2STATUS_TYPEType of Abstract MRS Statusnvarchar100
34/MRSS/C_STAT_PRGAssignments in Progress3STATUS_TYPEType of Abstract MRS Statusnvarchar100
35/MRSS/C_SYMSTATMapping Symbolic Status to Abstract Status3STATUS_TYPEType of Abstract MRS Statusnvarchar100
36/MRSS/C_WL_CSTATCustomer Status in Demand4STATUS_TYPEType of Abstract MRS Statusnvarchar100
37/MRSS/D_DEM_STATStatus of demand items3STATUS_TYPEType of Abstract MRS Statusnvarchar100
TOPMaintenance Processing
38/MRSS/C_DPR_STATTo store the status for CPRO2STATUS_TYPEType of Abstract MRS Statusnvarchar100
TOPPersonnel Time Management
39PTREQ_STATUS_CHKCheck Methods for Status Transitions1STATUS_TYPEStatus Transfer Typenvarchar40
40PTREQ_STATUS_TRAStatus Transfers1STATUS_TYPEStatus Transfer Typenvarchar40
41PTREQ_TYPERequest Types2STATUS_TYPEStatus Transfer Typenvarchar40
42PTREQ_XFEREVENTSPermitted Status Transitions1STATUS_TYPEStatus Transfer Typenvarchar40
TOPRuntime WorkbenchMonitoring
43SXMSMSTATExchange Infrastructure: Message Status9STATUS_TYPEXI: Type of a Statusnvarchar20
TOPSAP Multiresource Scheduling
44/MRSS/C_SGX_WSGSIndividual Status Allocation to Status Group4STATUS_TYPEType of Abstract MRS Statusnvarchar100