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

78 columns | Print definition?ERP 6.0  | HISTEX

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPM_PRGENERALProduct - Purchasing Set10HISTEXHistory Existsnvarchar10
2COMM_PR_TTCODESet type for tax details in service6HISTEXHistory Existsnvarchar10
3ISPS_MARAProduct Master MARA6HISTEXHistory Existsnvarchar10
TOPAuto-ID Infrastructure
4AIN_PROD_TGRAIGRAI-Global Returnable Asset Identifier6HISTEXHistory Existsnvarchar10
TOPBasic functions
5COMM_IL_PRDBPMaster Data of Relationship Type Partner16HISTEXIndicates That History Records Existnvarchar10
TOPCentral Part of Product Master
6COMC_MINITP_RELMini-Template Grouping Without Differentiation Key (REL)8HISTEXHistory Existsnvarchar10
7COMM_ATTR_ALIASAttribute Alias9HISTEXHistory Existsnvarchar10
8COMM_CATEGORYCategory10HISTEXHistory Existsnvarchar10
9COMM_CATEGORYDELCategories To Be Deleted (Temporary) in Download10HISTEXHistory Existsnvarchar10
10COMM_CATEGORYTCategory Description9HISTEXHistory Existsnvarchar10
11COMM_CATFRGRCategory Set-Type Assignment8HISTEXHistory Existsnvarchar10
12COMM_HIERARCHYHierarchy12HISTEXHistory Existsnvarchar10
13COMM_HIERARCHYTHierarchy Description9HISTEXHistory Existsnvarchar10
14COMM_IL_ACCESSMaster Data of Relationship Type Accessories10HISTEXIndicates That History Records Existnvarchar10
15COMM_IL_COMPETAssignment of Own Products to Competitor Products9HISTEXIndicates That History Records Existnvarchar10
16COMM_IL_PRDCPNMaster Data of Relationship Type Customers11HISTEXIndicates That History Records Existnvarchar10
17COMM_IL_PRDCTPMaster Data of Relationship Type Content Provider11HISTEXIndicates That History Records Existnvarchar10
18COMM_IL_PRDMPNMaster Data of Relationship Type Manufacturer11HISTEXIndicates That History Records Existnvarchar10
19COMM_IL_PRDMRKMarketing Material9HISTEXIndicates That History Records Existnvarchar10
20COMM_IL_PRDVNDMaster Data of Relationship Type Vendors11HISTEXIndicates That History Records Existnvarchar10
21COMM_IL_PROREFMaster Data of Relationship Type Reference Product11HISTEXIndicates That History Records Existnvarchar10
22COMM_IL_SERVIMaster Data of Relationship Type Services10HISTEXIndicates That History Records Existnvarchar10
23COMM_IL_SPAREMaster Data of Relationship Type Spare Parts10HISTEXIndicates That History Records Existnvarchar10
24COMM_IPRODUCTInactive Product13HISTEXHistory Existsnvarchar10
25COMM_PRCATProduct Category18HISTEXHistory Existsnvarchar10
26COMM_PRCATFRGRAssignment Product Category - Set Type11HISTEXHistory Existsnvarchar10
27COMM_PRCAT_ILProduct Category - Relationship Type Assignment9HISTEXHistory Existsnvarchar10
28COMM_PRFREEATTRFree Attributes for a Product7HISTEXHistory Existsnvarchar10
29COMM_PRODUCTProduct13HISTEXHistory Existsnvarchar10
30COMM_PROD_VARAssignment of Product Variants to Configurable Product9HISTEXHistory Existsnvarchar10
31COMM_PRPRDCATRProduct - Product Category Assignment9HISTEXHistory Existsnvarchar10
32COMM_PRSHTEXTProduct Description9HISTEXHistory Existsnvarchar10
33COMM_PRVIEWProduct View7HISTEXHistory Existsnvarchar10
34COMM_PRVIEWTProduct View Description8HISTEXHistory Existsnvarchar10
35COMM_PR_FRG_REGProduct-Set Assignment (Gen. Link-Handler)12HISTEXHistory Existsnvarchar10
36COMM_PR_FRG_RELProduct - Set - Assignment10HISTEXHistory Existsnvarchar10
37COMM_PR_GTINGTIN - Global Trade Item Number12HISTEXHistory Existsnvarchar10
38COMM_PR_PUR_1Purchasing6HISTEXHistory Existsnvarchar10
39COMM_PR_UNITProduct Unit of Measurement21HISTEXHistory Existsnvarchar10
40COMM_SCHEMENumbering Scheme8HISTEXHistory Existsnvarchar10
41COMM_SETTP_TEMPTemplate XXXX6HISTEXHistory Existsnvarchar10
42COM_COMMERCIALBusiness data6HISTEXHistory Existsnvarchar10
43CRMM_PR_TAXProduct Sales Tax13HISTEXHistory Existsnvarchar10
44PRREFPermitted Object Categories7HISTEXHistory Existsnvarchar10
TOPClassification System New
45CHARACTERTEXTDML Text Object13HISTEXHistory Existsnvarchar10
46CME_ST_CHARATRCharacteristic: Global Attributes6HISTEXHistory Existsnvarchar10
47CME_ST_FORMATCME Data Type: Format Details6HISTEXHistory Existsnvarchar10
48CME_ST_FORMAT1CME-Datentyp: Formatangaben6HISTEXHistorie vorhandennvarchar10
49CME_ST_ISO_AT1CME Characteristic: ISO Attributes6HISTEXHistory Existsnvarchar10
50CME_ST_ISO_ATACME Characteristic: ISO Attributes6HISTEXHistory Existsnvarchar10
51CME_ST_ISO_ATBCME Characteristic: ISO Attributes7HISTEXHistory Existsnvarchar10
52CME_ST_R3_ATTRCME Characteristic: R/3 Attributes6HISTEXHistory Existsnvarchar10
53CME_ST_R3_DEPCME Characteristic: Object Dependencies for R/3 Characterstc7HISTEXHistory Existsnvarchar10
54CME_ST_REFCharacteristic: Data Reference9HISTEXHistory Existsnvarchar10
55CME_ST_VALUECME Data Type: Values11HISTEXHistory Existsnvarchar10
56CME_ST_VAL_TXTDML Text Object13HISTEXHistory Existsnvarchar10
57COMM_IL_DSCOPEDefinition Scope17HISTEXIndicates That History Records Existnvarchar10
58COMM_IL_DTYPEEngineering Change Management: Change Graph17HISTEXIndicates That History Records Existnvarchar10
59COMM_IL_SCPCHRDefinition Scope -> Characteristic23HISTEXIndicates That History Records Existnvarchar10
60DEFSCOPETEXTDML Text Object13HISTEXHistory Existsnvarchar10
61DTYPETEXTDML Text Object13HISTEXHistory Existsnvarchar10
TOPEngineering Change Management
62COMM_IL_ECMCHGEngineering Change Management: Change Graph20HISTEXIndicates That History Records Existnvarchar10
TOPMaster Data Framework
63DML_LH_FRG_REGProduct-Set Assignment (Gen. Link-Handler)12HISTEXHistory Existsnvarchar10
64DML_ST_TEXTDML Text Object13HISTEXHistory Existsnvarchar10
TOPObjects
65COM_TA_MANUFACManufacturer Information6HISTEXHistory Existsnvarchar10
66COM_TA_R3_IDR3 Identification6HISTEXHistory Existsnvarchar10
TOPSet Types and Attributes
67COMT_EXT_TEMPTemplate for Extension Tables7HISTEXHistory Existsnvarchar10
68COMT_EXT_TEMP_DBTemplate for Extension Tables7HISTEXHistory Existsnvarchar10
69COMT_SETTMaster Data of Set Type <SETTYPE_ID>6HISTEXHistory Existsnvarchar10
70COMT_SETT_MLMaster Data of Set Type <SETTYPE_ID>7HISTEXHistory Existsnvarchar10
71COMT_SETT_XMaster Data of Set Type <SETTYPE_ID>6HISTEXHistory Existsnvarchar10
72COMT_SETT_XMLMaster Data of Set Type <SETTYPE_ID>7HISTEXHistory Existsnvarchar10
73COMT_TEMPLATESet Type Template6HISTEXHistory Existsnvarchar10
74COMT_TEMP_MRSet Type Template6HISTEXHistory Existsnvarchar10
75COMT_TEMP_MR_DBSet Type Template for Multi-Value Set Types7HISTEXHistory Existsnvarchar10
TOPTemplates
76COMC_MINITP_DATAMini-Template Data for Set Types (Generic Store)13HISTEXHistory Existsnvarchar10
77COMC_MINITP_DATSShadow Table Mini-Template Data for Set Types (Generic)13HISTEXHistory Existsnvarchar10
78COMC_MINITP_REGWrapping of Several Mini-Templates by a Key GUID (REG)9HISTEXHistory Existsnvarchar10