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

40 columns | Print definition?ERP 6.0  | OTYPE_NAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/GBT/W_WRKLST_IWorklist Item4OTYPE_NAMEObject Typenvarchar100
2/PLMB/CGOS_PARAMAdditional Settings for PLM Objects2OTYPE_NAMEObject Typenvarchar100
3/PLMB/CGOS_PARATAdditional Settings for PLM Objects2OTYPE_NAMEObject Typenvarchar100
4/PLMB/OSET_OPLM Object Set - Object Assingment4OTYPE_NAMEObject Typenvarchar100
5/PLMB/PR_OBJSRVHHeader of PR Object Type Background Service Assignment2OTYPE_NAMEObject Typenvarchar100
6/PLMB/PR_OBJSRVIItem of PR Object Type Background Service Assignment2OTYPE_NAMEObject Typenvarchar100
7/PLMB/PR_STA_DETProcess Route Status Determination2OTYPE_NAMEObject Typenvarchar100
8/PLMB/PR_TMP_DETProcess Route Template Determination2OTYPE_NAMEObject Typenvarchar100
9/PLMB/PR_TMP_STAProcess Route Template Determination Based on Status2OTYPE_NAMEObject Typenvarchar100
TOPEngineering Change Record
10/PLMB/PR_OBJ_ACTActivities for GOS Objects2OTYPE_NAMEObject Typenvarchar100
11/PLMI/ECR_OBJFLDChange Record - object type fieldnames2OTYPE_NAMEObject Typenvarchar100
12/PLMI/ECR_OTYPECR - Object Types customizing table2OTYPE_NAMEObject Typenvarchar100
13/PLMI/ECR_VV_FLDECR - Field details for view varinats3OTYPE_NAMEObject Typenvarchar100
TOPObject Navigator
14/PLMB/NAV_HETCOLNAV - Additional Columns of Heterogeneous List2OTYPE_NAMEObject Typenvarchar100
15/PLMB/NAV_LAYOUTNAV - Layout definition per object type customizing table2OTYPE_NAMEObject Typenvarchar100
16/PLMB/NAV_OTYPNAV - Object Types customizing table2OTYPE_NAMEObject Typenvarchar100
17/PLMB/NAV_USR_TPNAV: User Specific Layouts3OTYPE_NAMEObject Typenvarchar100
18/PLMB/NAV_XOTObject Type and External system Object type details2OTYPE_NAMEObject Typenvarchar100
19/PLMB/NAV_XOTSExternal Systems RFC destination for Object type2OTYPE_NAMEObject Typenvarchar100
20/PLMB/NAV_XOTSTRIn non feeder class scenario, Key and Attributes Structures2OTYPE_NAMEObject Typenvarchar100
TOPStatus and Action Management
21/PLMB/SAM_EDGEPLM Status management - status definition2OTYPE_NAMEObject Typenvarchar100
22/PLMB/SAM_FCPLM Status Management - OType, Status, Struc, Field, Propert2OTYPE_NAMEObject Typenvarchar100
23/PLMB/SAM_ND_APLM Status management - status action assignments3OTYPE_NAMEObject Typenvarchar100
24/PLMB/SAM_ND_FPLM Status management - status fieldvalue assignments3OTYPE_NAMEObject Typenvarchar100
25/PLMB/SAM_NODEPLM Status management - status definition2OTYPE_NAMEObject Typenvarchar100
26/PLMB/SAM_NODE_TPLM Status management - status definition text table2OTYPE_NAMEObject Typenvarchar100
27/PLMB/SAM_OBJACPLM Status management - object type fieldnames2OTYPE_NAMEObject Typenvarchar100
28/PLMB/SAM_OBJACTPLM Status management - object type fieldnames2OTYPE_NAMEObject Typenvarchar100
29/PLMB/SAM_OBJFLDPLM Status management - object type fieldnames2OTYPE_NAMEObject Typenvarchar100
30/PLMB/SAM_OBJPRCPLM Status management - Otype, Status, Pre Condition2OTYPE_NAMEObject Typenvarchar100
31/PLMB/SAM_OBJSTPLM Status management - Otype Schema,Status, Date And User2OTYPE_NAMEObject Typenvarchar100
32/PLMB/SAM_OBJTPPLM Status management - object type description2OTYPE_NAMEObject Typenvarchar100
33/PLMB/SAM_SCHEMPLM Status management - status definition2OTYPE_NAMEObject Typenvarchar100
34/PLMB/SAM_SCHEMTPLM Status management - status definition2OTYPE_NAMEObject Typenvarchar100
35/PLMB/SAM_SUBOTPLM SAM - sub object type level schema assignment2OTYPE_NAMEObject Typenvarchar100
TOPTools, UI Framework, Navigation, Web Access
36/PLMB/GOSX_OTYPEObject Types customizing table1OTYPE_NAMEObject Typenvarchar100
TOPUI Framework Service Provider Infrastructure
37/PLMB/GOS_OTYPEObject Types customizing table1OTYPE_NAMEObject Typenvarchar100
38/PLMB/GOS_OTYPETText table for Object Types1OTYPE_NAMEObject Typenvarchar100
39/PLMB/GOS_PADATMaintain user specific data4OTYPE_NAMEObject Typenvarchar100
40/PLMB/GOS_PAMAXMaintain number of entries in the personal area4OTYPE_NAMEObject Typenvarchar100