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

46 columns | Print definition?ERP 6.0  | BUS_OBJ_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/C_STSLSet Levels for Set Types2BUS_OBJ_TYPEBusiness Object Typenvarchar100
2/SAPPSSRM/MAPSRMSRM-DocBuilder field mapping3BUS_OBJ_TYPEBusiness Objectnvarchar100
3/SAPSRM/BO_TYSUBAllowed Subtypes of Business Object1BUS_OBJ_TYPEBusiness Object Typenvarchar100
4/SAPSRM/C_ACTSETAssignment of Actions to Set Type and Business Object Type3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
5/SAPSRM/C_BOITTYAssignment of Item Types to SRM Procurement Document Types1BUS_OBJ_TYPEBusiness Object Typenvarchar100
6/SAPSRM/C_MDASBMeta Data Configuration for Set Actions5BUS_OBJ_TYPEType of an object used for metadatanvarchar100
7/SAPSRM/C_MDASBCCustomer Metadata Configuration for Actions on Set Level5BUS_OBJ_TYPEType of an object used for metadatanvarchar100
8/SAPSRM/C_MDASBLLook-Up Table BO specific Restriction of Set Field Metadata5BUS_OBJ_TYPEBusiness Object Typenvarchar100
9/SAPSRM/C_MDA_H1Meta Data Configuration for Business Object Header Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
10/SAPSRM/C_MDA_HCMeta Data Configuration for Business Object Header Fields4BUS_OBJ_TYPEType of an object used for metadatanvarchar100
11/SAPSRM/C_MDA_HDMeta Data Configuration for Business Object Header Fields4BUS_OBJ_TYPEType of an object used for metadatanvarchar100
12/SAPSRM/C_MDA_I1Meta Data Configuration for Business Object Item Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
13/SAPSRM/C_MDA_ICCustomer Meta Data Configuration for BO Item Fields4BUS_OBJ_TYPEType of an object used for metadatanvarchar100
14/SAPSRM/C_MDA_ITMeta Data Configuration for Business Object Item Fields4BUS_OBJ_TYPEType of an object used for metadatanvarchar100
15/SAPSRM/C_MDA_S1Meta Data Configuration for Set Actions4BUS_OBJ_TYPEType of an object used for metadatanvarchar100
16/SAPSRM/C_MDFSBMeta Data Configuration for Set Fields4BUS_OBJ_TYPEType of an object used for metadatanvarchar100
17/SAPSRM/C_MDFSBBBO specific Restriction of Set Field Metadata4BUS_OBJ_TYPEObject Typenvarchar100
18/SAPSRM/C_MDFSBCCustomer Table for Configuration of Set Field Metadata4BUS_OBJ_TYPEType of an object used for metadatanvarchar100
19/SAPSRM/C_MDFSBLLook-Up Table BO specific Restriction of Set Field Metadata4BUS_OBJ_TYPEBusiness Object Typenvarchar100
20/SAPSRM/C_MDFSSTMetadata: Mapping Channel Logic Layer Structure to Set Type6BUS_OBJ_TYPEBusiness Transaction Categorynvarchar100
21/SAPSRM/C_MDFSTRStructures with possible Fields for Metadata Configuration2BUS_OBJ_TYPEType of an object used for metadatanvarchar100
22/SAPSRM/C_MDF_H1Meta Data Configuration for Business Object Header Fields2BUS_OBJ_TYPEType of an object used for metadatanvarchar100
23/SAPSRM/C_MDF_HCCustomer Meta Data Configuration for BO Header Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
24/SAPSRM/C_MDF_HDMeta Data Configuration for Business Object Header Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
25/SAPSRM/C_MDF_I1Meta Data Configuration for Business Object Item Fields2BUS_OBJ_TYPEType of an object used for metadatanvarchar100
26/SAPSRM/C_MDF_ICCustomer Meta Data Configuration for BO Item Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
27/SAPSRM/C_MDF_ITMeta Data Configuration for Business Object Item Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
28/SAPSRM/C_MDF_S1Meta Data Configuration for Set Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
29/SAPSRM/C_MDS_H1Meta Data Configuration for Business Object Header Fields2BUS_OBJ_TYPEType of an object used for metadatanvarchar100
30/SAPSRM/C_MDS_HCCustomer Metadata Configuration for Header Set Types3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
31/SAPSRM/C_MDS_HDMeta Data Configuration for Business Object Header Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
32/SAPSRM/C_MDS_I1Meta Data Configuration for Business Object Item Fields2BUS_OBJ_TYPEType of an object used for metadatanvarchar100
33/SAPSRM/C_MDS_ICCustomer Metadata Configuration for Item Set Types3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
34/SAPSRM/C_MDS_ITMeta Data Configuration for Business Object Item Fields3BUS_OBJ_TYPEType of an object used for metadatanvarchar100
35/SAPSRM/C_META_HMeta Data Cnofiguration for Business Object Header Fields2BUS_OBJ_TYPEObject Typenvarchar100
36/SAPSRM/C_SETSBOSet Subtypes per BO, Set Type and Set Level2BUS_OBJ_TYPEBusiness Object Typenvarchar100
37/SAPSRM/C_WD_FLDConfiguration for generic Display of Extension Fields on WD1BUS_OBJ_TYPEBusiness Trans. Cat.nvarchar100
38/SAPSRM/C_WD_TCTTexts for Table Extension Columns1BUS_OBJ_TYPEType of an object used for metadatanvarchar100
39/SAPSRM/C_WD_TESettings for Standard Display of Table Extensions on UI1BUS_OBJ_TYPEType of an object used for metadatanvarchar100
40/SAPSRM/C_WD_TECSettings for Columm Visibility of Table Extensions on UI1BUS_OBJ_TYPEType of an object used for metadatanvarchar100
41/SAPSRM/INI_METStatic metadata for fields in display mode2BUS_OBJ_TYPEType of an object used for metadatanvarchar100
42/SAPSRM/INI_METCCustomer Static metadata config for fields in display mode2BUS_OBJ_TYPEType of an object used for metadatanvarchar100
43/SAPSRM/MDF_STRUDO NOT USE!!!!!! (USE /SAPSRM/C_MDFSST and /SAPSRM/C_MDFSTR)2BUS_OBJ_TYPEBusiness Transaction Categorynvarchar100
44/SAPSRM/SEOCLASSAdditional View Fields (needs to be filled manually)5BUS_OBJ_TYPEBusiness Object Typenvarchar100
45/SAPSRM/SIDE_PANRegister for Side Panel2BUS_OBJ_TYPEnvarchar100
TOPProduction and Revenue Accounting
46OIUT2_CLUSTERSystem table INDX5BUS_OBJ_TYPEnvarchar30