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

53 columns | Print definition?ERP 6.0  | FRG_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPM_PRGENERALProduct - Purchasing Set2FRG_GUIDSet GUIDvarbinary160
2BBPM_PRGENERALHGeneral Purchasing Data on Product (History)2FRG_GUIDSet GUIDvarbinary160
3COMM_PR_TTCODESet type for tax details in service2FRG_GUIDSet GUIDvarbinary160
4COMM_PR_TTCODEHSet type for tax details in service2FRG_GUIDSet GUIDvarbinary160
5ISPS_MARAProduct Master MARA2FRG_GUIDSet GUIDvarbinary160
6ISPS_MARAHProduct Master MARA2FRG_GUIDSet GUIDvarbinary160
TOPCentral Part of Product Master
7COMM_PROD_VARAssignment of Product Variants to Configurable Product2FRG_GUIDSet GUIDvarbinary160
8COMM_PROD_VARHHistory: Assignment of Variants to Configurable Product2FRG_GUIDSet GUIDvarbinary160
9COMM_PR_PUR_1Purchasing2FRG_GUIDSet GUIDvarbinary160
10COMM_PR_PUR_1HPurchasing2FRG_GUIDSet GUIDvarbinary160
11COMM_SETTPH_TEMPTemplate XXXX (History)2FRG_GUIDSet GUIDvarbinary160
12COMM_SETTP_TEMPTemplate XXXX2FRG_GUIDSet GUIDvarbinary160
13PRREFPermitted Object Categories2FRG_GUIDSet GUIDvarbinary160
14PRREFHPermitted Object Categories2FRG_GUIDSet GUIDvarbinary160
TOPClassification System New
15CHARACTERTEXTDML Text Object2FRG_GUIDSet GUIDvarbinary160
16CHARACTERTEXTHDML Text Object2FRG_GUIDSet GUIDvarbinary160
17CME_ST_CHARATRCharacteristic: Global Attributes2FRG_GUIDSet GUIDvarbinary160
18CME_ST_CHARATRHCharacteristic: Global Attributes2FRG_GUIDSet GUIDvarbinary160
19CME_ST_FORMATCME Data Type: Format Details2FRG_GUIDSet GUIDvarbinary160
20CME_ST_FORMAT1CME-Datentyp: Formatangaben2FRG_GUIDSet-GUIDvarbinary160
21CME_ST_FORMATHCME Data Type: Format Details2FRG_GUIDSet GUIDvarbinary160
22CME_ST_ISO_AT1CME Characteristic: ISO Attributes2FRG_GUIDSet GUIDvarbinary160
23CME_ST_ISO_AT1HCME Characteristic: ISO Attributes2FRG_GUIDSet GUIDvarbinary160
24CME_ST_ISO_ATACME Characteristic: ISO Attributes2FRG_GUIDSet GUIDvarbinary160
25CME_ST_ISO_ATAHCME Characteristic: ISO Attributes2FRG_GUIDSet GUIDvarbinary160
26CME_ST_ISO_ATBCME Characteristic: ISO Attributes2FRG_GUIDSet GUIDvarbinary160
27CME_ST_ISO_ATBHCME Characteristic: ISO Attributes2FRG_GUIDSet GUIDvarbinary160
28CME_ST_R3_ATTRCME Characteristic: R/3 Attributes2FRG_GUIDSet GUIDvarbinary160
29CME_ST_R3_ATTRHCME Characteristic: R/3 Attributes2FRG_GUIDSet GUIDvarbinary160
30CME_ST_R3_DEPCME Characteristic: Object Dependencies for R/3 Characterstc2FRG_GUIDSet GUIDvarbinary160
31CME_ST_R3_DEPHCME Characteristic: Object Dependencies for R/3 Characterstc2FRG_GUIDSet GUIDvarbinary160
32CME_ST_REFCharacteristic: Data Reference2FRG_GUIDSet GUIDvarbinary160
33CME_ST_REFHCharacteristic: Data Reference2FRG_GUIDSet GUIDvarbinary160
34CME_ST_VALUECME Data Type: Values2FRG_GUIDSet GUIDvarbinary160
35CME_ST_VALUEHCME Data Type: Values2FRG_GUIDSet GUIDvarbinary160
36CME_ST_VAL_TXTDML Text Object2FRG_GUIDSet GUIDvarbinary160
37CME_ST_VAL_TXTHDML Text Object2FRG_GUIDSet GUIDvarbinary160
38DEFSCOPETEXTDML Text Object2FRG_GUIDSet GUIDvarbinary160
39DEFSCOPETEXTHDML Text Object2FRG_GUIDSet GUIDvarbinary160
40DTYPETEXTDML Text Object2FRG_GUIDSet GUIDvarbinary160
41DTYPETEXTHDML Text Object2FRG_GUIDSet GUIDvarbinary160
TOPMaster Data Framework
42DML_DELIVERY_TXTMDF Text Object2FRG_GUIDObject Version Keynvarchar320
43DML_ST_TEXTDML Text Object2FRG_GUIDSet GUIDvarbinary160
44DML_ST_TEXTHDML Text Object2FRG_GUIDSet GUIDvarbinary160
TOPSet Types and Attributes
45COMT_SETTMaster Data of Set Type <SETTYPE_ID>2FRG_GUIDSet GUIDvarbinary160
46COMT_SETT_HHistory of Set Type <SETTYPE_ID>2FRG_GUIDSet GUIDvarbinary160
47COMT_SETT_MLMaster Data of Set Type <SETTYPE_ID>2FRG_GUIDSet GUIDvarbinary160
48COMT_SETT_ML_HHistory of Set Type <SETTYPE_ID>2FRG_GUIDSet GUIDvarbinary160
49COMT_TEMPLATESet Type Template2FRG_GUIDSet GUIDvarbinary160
50COMT_TEMPLATEHSet Type History Template2FRG_GUIDSet GUIDvarbinary160
51COMT_TEMP_MRSet Type Template2FRG_GUIDSet GUIDvarbinary160
52COMT_TEMP_MRHSet Type History Template2FRG_GUIDSet GUIDvarbinary160
53COMT_TEMP_MR_DBSet Type Template for Multi-Value Set Types2FRG_GUIDSet GUIDvarbinary160