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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

154 columns | Print definition?ERP 6.0  | UPNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPM_PRGENERALProduct - Purchasing Set9UPNAMEName of the User Who Last Changed the Setnvarchar120
2BBPM_PRGENERALHGeneral Purchasing Data on Product (History)9UPNAMEName of the User Who Last Changed the Setnvarchar120
3COMM_PR_TTCODESet type for tax details in service5UPNAMEName of the User Who Last Changed the Setnvarchar120
4COMM_PR_TTCODEHSet type for tax details in service5UPNAMEName of the User Who Last Changed the Setnvarchar120
5ISPS_MARAProduct Master MARA5UPNAMEName of the User Who Last Changed the Setnvarchar120
6ISPS_MARAHProduct Master MARA5UPNAMEName of the User Who Last Changed the Setnvarchar120
TOPAuto-ID Infrastructure
7AIN_PROD_TGRAIGRAI-Global Returnable Asset Identifier5UPNAMEName of the User Who Last Changed the Setnvarchar120
8AIN_PROD_TGRAIHGRAI-Global Returnable Asset Identifier5UPNAMEName of the User Who Last Changed the Setnvarchar120
TOPBasic functions
9COMM_IL_PRDBPMaster Data of Relationship Type Partner14UPNAMERelationship Last Changed Bynvarchar120
10COMM_IL_PRDBP_HHistorical Data for Relationship Type Partner15UPNAMERelationship Last Changed Bynvarchar120
TOPCentral Part of Product Master
11COMC_KEYTYPE_CSTSAP Control Table for Key Assignment Generation12UPNAMEName of the User Who Last Changed the Setnvarchar120
12COMC_KEYTYPE_PCUSAP Control Table for Key Assignment Generation10UPNAMEName of the User Who Last Changed the Setnvarchar120
13COMC_MINITP_RELMini-Template Grouping Without Differentiation Key (REL)6UPNAMEName of User Who Last Changed Data Recordnvarchar120
14COMC_MINITP_RELHHistory for Table COMC_MINITP_REL6UPNAMEName of User Who Last Changed Data Recordnvarchar120
15COMC_SETTYP_ATTRAdministrative Table for Set Type Attribute Information14UPNAMEName of the User Who Last Changed the Setnvarchar120
16COMM_ATTR_ALIASAttribute Alias8UPNAMEName of the User Who Last Changed the Setnvarchar120
17COMM_ATTR_ALIASHAttribute Alias8UPNAMEName of the User Who Last Changed the Setnvarchar120
18COMM_CATEGORYCategory9UPNAMEName of the User Who Last Changed the Setnvarchar120
19COMM_CATEGORYDELCategories To Be Deleted (Temporary) in Download9UPNAMEName of the User Who Last Changed the Setnvarchar120
20COMM_CATEGORYHCategory: History9UPNAMEName of the User Who Last Changed the Setnvarchar120
21COMM_CATEGORYTCategory Description8UPNAMEName of the User Who Last Changed the Setnvarchar120
22COMM_CATEGORYTHCategory Description: History8UPNAMEName of the User Who Last Changed the Setnvarchar120
23COMM_CATFRGRCategory Set-Type Assignment7UPNAMEName of the User Who Last Changed the Setnvarchar120
24COMM_CATFRGRHAssignment Category - Set Type: History7UPNAMEName of the User Who Last Changed the Setnvarchar120
25COMM_HIERARCHYHierarchy11UPNAMEName of the User Who Last Changed the Setnvarchar120
26COMM_HIERARCHYHHierarchy: History11UPNAMEName of the User Who Last Changed the Setnvarchar120
27COMM_HIERARCHYTHierarchy Description8UPNAMEName of the User Who Last Changed the Setnvarchar120
28COMM_HIERARCHYTHHierarchy Description: History8UPNAMEName of the User Who Last Changed the Setnvarchar120
29COMM_IL_ACCESSMaster Data of Relationship Type Accessories8UPNAMERelationship Last Changed Bynvarchar120
30COMM_IL_ACCESS_HHistorical Data of Relationship Type Accessories9UPNAMERelationship Last Changed Bynvarchar120
31COMM_IL_COMPETAssignment of Own Products to Competitor Products7UPNAMERelationship Last Changed Bynvarchar120
32COMM_IL_PRDCPNMaster Data of Relationship Type Customers9UPNAMERelationship Last Changed Bynvarchar120
33COMM_IL_PRDCPN_HHistorical Data of Relationship Type Customers10UPNAMERelationship Last Changed Bynvarchar120
34COMM_IL_PRDCTPMaster Data of Relationship Type Content Provider9UPNAMERelationship Last Changed Bynvarchar120
35COMM_IL_PRDCTP_HHistorical Data of Relationship Type Content Provider10UPNAMERelationship Last Changed Bynvarchar120
36COMM_IL_PRDMPNMaster Data of Relationship Type Manufacturer9UPNAMERelationship Last Changed Bynvarchar120
37COMM_IL_PRDMPN_HHistorical Data of Relationship Type Manufacturer10UPNAMERelationship Last Changed Bynvarchar120
38COMM_IL_PRDMRKMarketing Material7UPNAMERelationship Last Changed Bynvarchar120
39COMM_IL_PRDMRK_HMarketing Material History8UPNAMERelationship Last Changed Bynvarchar120
40COMM_IL_PRDVNDMaster Data of Relationship Type Vendors9UPNAMERelationship Last Changed Bynvarchar120
41COMM_IL_PRDVND_HHistorical Data of Relationship Type Vendors10UPNAMERelationship Last Changed Bynvarchar120
42COMM_IL_PROREFMaster Data of Relationship Type Reference Product9UPNAMERelationship Last Changed Bynvarchar120
43COMM_IL_PROREF_HHistorical Data of Relationship Type Reference Product10UPNAMERelationship Last Changed Bynvarchar120
44COMM_IL_SERVIMaster Data of Relationship Type Services8UPNAMERelationship Last Changed Bynvarchar120
45COMM_IL_SERVI_HHistorical Data of Relationship Type Services9UPNAMERelationship Last Changed Bynvarchar120
46COMM_IL_SPAREMaster Data of Relationship Type Spare Parts8UPNAMERelationship Last Changed Bynvarchar120
47COMM_IL_SPARE_HHistorical Data of Relationship Type Spare Parts9UPNAMERelationship Last Changed Bynvarchar120
48COMM_IPRODUCTInactive Product12UPNAMEName of the User Who Last Changed the Setnvarchar120
49COMM_PRCATProduct Category17UPNAMEName of the User Who Last Changed the Setnvarchar120
50COMM_PRCATFRGRAssignment Product Category - Set Type10UPNAMEName of the User Who Last Changed the Setnvarchar120
51COMM_PRCATFRGRHProduct Category - Set Type Assignment: History10UPNAMEName of the User Who Last Changed the Setnvarchar120
52COMM_PRCATHProduct Category: History17UPNAMEName of the User Who Last Changed the Setnvarchar120
53COMM_PRCAT_ILProduct Category - Relationship Type Assignment8UPNAMEName of the User Who Last Changed the Setnvarchar120
54COMM_PRCAT_ILHProduct Category - Relationship Type Assignment: History8UPNAMEName of the User Who Last Changed the Setnvarchar120
55COMM_PRFREEATTRFree Attributes for a Product6UPNAMEName of the User Who Last Changed the Setnvarchar120
56COMM_PRFREEATTRHFree Attributes for a Product - History6UPNAMEName of the User Who Last Changed the Setnvarchar120
57COMM_PRODUCTProduct12UPNAMEName of the User Who Last Changed the Setnvarchar120
58COMM_PRODUCTHProduct History12UPNAMEName of the User Who Last Changed the Setnvarchar120
59COMM_PROD_VARAssignment of Product Variants to Configurable Product8UPNAMEName of the User Who Last Changed the Setnvarchar120
60COMM_PROD_VARHHistory: Assignment of Variants to Configurable Product8UPNAMEName of the User Who Last Changed the Setnvarchar120
61COMM_PRPRDCATRProduct - Product Category Assignment8UPNAMEName of the User Who Last Changed the Setnvarchar120
62COMM_PRPRDCATRHProduct - Product Category Assignment: History8UPNAMEName of the User Who Last Changed the Setnvarchar120
63COMM_PRSHTEXTProduct Description8UPNAMEName of the User Who Last Changed the Setnvarchar120
64COMM_PRSHTEXTHProduct Description (History)6UPNAMEName of the User Who Last Changed the Setnvarchar120
65COMM_PRVIEWProduct View6UPNAMEName of the User Who Last Changed the Setnvarchar120
66COMM_PRVIEWHProduct View - History6UPNAMEName of the User Who Last Changed the Setnvarchar120
67COMM_PRVIEWTProduct View Description7UPNAMEName of the User Who Last Changed the Setnvarchar120
68COMM_PRVIEWTHProduct View Description - History7UPNAMEName of the User Who Last Changed the Setnvarchar120
69COMM_PR_FRG_REGProduct-Set Assignment (Gen. Link-Handler)11UPNAMEName of the User Who Last Changed the Setnvarchar120
70COMM_PR_FRG_REGHProduct-Set Assignment History (Gen. Link-Handler)11UPNAMEName of the User Who Last Changed the Setnvarchar120
71COMM_PR_FRG_RELProduct - Set - Assignment9UPNAMEName of the User Who Last Changed the Setnvarchar120
72COMM_PR_FRG_RELHProduct - Set - Assignment History9UPNAMEName of the User Who Last Changed the Setnvarchar120
73COMM_PR_GTINGTIN - Global Trade Item Number11UPNAMEName of the User Who Last Changed the Setnvarchar120
74COMM_PR_GTINHGTIN - Global Trade Item Number History11UPNAMEName of the User Who Last Changed the Setnvarchar120
75COMM_PR_PUR_1Purchasing5UPNAMEName of the User Who Last Changed the Setnvarchar120
76COMM_PR_PUR_1HPurchasing5UPNAMEName of the User Who Last Changed the Setnvarchar120
77COMM_PR_UNITProduct Unit of Measurement20UPNAMEName of the User Who Last Changed the Setnvarchar120
78COMM_PR_UNITHProduct Unit of Measurement History20UPNAMEName of the User Who Last Changed the Setnvarchar120
79COMM_SCHEMENumbering Scheme7UPNAMEName of the User Who Last Changed the Setnvarchar120
80COMM_SETTPH_TEMPTemplate XXXX (History)5UPNAMEName of the User Who Last Changed the Setnvarchar120
81COMM_SETTP_TEMPTemplate XXXX5UPNAMEName of the User Who Last Changed the Setnvarchar120
82COMS_KEYTYPE_PCUSAP Control Table for Key Assignment Generation9UPNAMEName of the User Who Last Changed the Setnvarchar120
83COM_COMMERCIALBusiness data5UPNAMEName of the User Who Last Changed the Setnvarchar120
84COM_COMMERCIALHBusiness data5UPNAMEName of the User Who Last Changed the Setnvarchar120
85CRMM_PR_TAXProduct Sales Tax12UPNAMEName of the User Who Last Changed the Setnvarchar120
86CRMM_PR_TAXHProduct Sales Tax - History12UPNAMEName of the User Who Last Changed the Setnvarchar120
87PRREFPermitted Object Categories6UPNAMEName of the User Who Last Changed the Setnvarchar120
88PRREFHPermitted Object Categories6UPNAMEName of the User Who Last Changed the Setnvarchar120
TOPClassification System New
89CHARACTERTEXTDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
90CHARACTERTEXTHDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
91CME_ST_CHARATRCharacteristic: Global Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
92CME_ST_CHARATRHCharacteristic: Global Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
93CME_ST_FORMATCME Data Type: Format Details5UPNAMEName of the User Who Last Changed the Setnvarchar120
94CME_ST_FORMAT1CME-Datentyp: Formatangaben5UPNAMEName des Benutzers, der das Set zuletzt geändert hatnvarchar120
95CME_ST_FORMATHCME Data Type: Format Details5UPNAMEName of the User Who Last Changed the Setnvarchar120
96CME_ST_ISO_AT1CME Characteristic: ISO Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
97CME_ST_ISO_AT1HCME Characteristic: ISO Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
98CME_ST_ISO_ATACME Characteristic: ISO Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
99CME_ST_ISO_ATAHCME Characteristic: ISO Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
100CME_ST_ISO_ATBCME Characteristic: ISO Attributes6UPNAMEName of the User Who Last Changed the Setnvarchar120
101CME_ST_ISO_ATBHCME Characteristic: ISO Attributes6UPNAMEName of the User Who Last Changed the Setnvarchar120
102CME_ST_R3_ATTRCME Characteristic: R/3 Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
103CME_ST_R3_ATTRHCME Characteristic: R/3 Attributes5UPNAMEName of the User Who Last Changed the Setnvarchar120
104CME_ST_R3_DEPCME Characteristic: Object Dependencies for R/3 Characterstc6UPNAMEName of the User Who Last Changed the Setnvarchar120
105CME_ST_R3_DEPHCME Characteristic: Object Dependencies for R/3 Characterstc6UPNAMEName of the User Who Last Changed the Setnvarchar120
106CME_ST_REFCharacteristic: Data Reference8UPNAMEName of the User Who Last Changed the Setnvarchar120
107CME_ST_REFHCharacteristic: Data Reference8UPNAMEName of the User Who Last Changed the Setnvarchar120
108CME_ST_VALUECME Data Type: Values10UPNAMEName of the User Who Last Changed the Setnvarchar120
109CME_ST_VALUEHCME Data Type: Values10UPNAMEName of the User Who Last Changed the Setnvarchar120
110CME_ST_VAL_TXTDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
111CME_ST_VAL_TXTHDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
112COMM_IL_DSCOPEDefinition Scope15UPNAMERelationship Last Changed Bynvarchar120
113COMM_IL_DSCOPE_HChange Graph for History Table16UPNAMERelationship Last Changed Bynvarchar120
114COMM_IL_DTYPEEngineering Change Management: Change Graph15UPNAMERelationship Last Changed Bynvarchar120
115COMM_IL_DTYPE_HChange Graph for History Table16UPNAMERelationship Last Changed Bynvarchar120
116COMM_IL_SCPCHRDefinition Scope -> Characteristic21UPNAMERelationship Last Changed Bynvarchar120
117COMM_IL_SCPCHR_HChange Graph for History Table22UPNAMERelationship Last Changed Bynvarchar120
118DEFSCOPETEXTDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
119DEFSCOPETEXTHDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
120DTYPETEXTDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
121DTYPETEXTHDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
TOPEngineering Change Management
122COMM_IL_ECMCHGEngineering Change Management: Change Graph18UPNAMERelationship Last Changed Bynvarchar120
123COMM_IL_ECMCHG_HChange Graph for History Table8UPNAMERelationship Last Changed Bynvarchar120
TOPMaster Data Framework
124DML_LH_FRG_REGProduct-Set Assignment (Gen. Link-Handler)11UPNAMEName of the User Who Last Changed the Setnvarchar120
125DML_LH_FRG_REGHProduct-Set Assignment History (Gen. Link-Handler)11UPNAMEName of the User Who Last Changed the Setnvarchar120
126DML_ST_TEXTDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
127DML_ST_TEXTHDML Text Object12UPNAMEName of the User Who Last Changed the Setnvarchar120
TOPObjects
128COM_TA_MANUFACManufacturer Information5UPNAMEName of the User Who Last Changed the Setnvarchar120
129COM_TA_MANUFACHManufacturer Information5UPNAMEName of the User Who Last Changed the Setnvarchar120
130COM_TA_R3_IDR3 Identification5UPNAMEName of the User Who Last Changed the Setnvarchar120
131COM_TA_R3_IDHR3 Identification5UPNAMEName of the User Who Last Changed the Setnvarchar120
TOPSet Types and Attributes
132COMM_EXTENSIONHExtension Table History (Template)6UPNAMEName of the User Who Last Changed the Setnvarchar120
133COMT_EXT_TEMPTemplate for Extension Tables6UPNAMEName of the User Who Last Changed the Setnvarchar120
134COMT_EXT_TEMPHTemplate for Extension Tables History6UPNAMEName of the User Who Last Changed the Setnvarchar120
135COMT_EXT_TEMP_DBTemplate for Extension Tables6UPNAMEName of the User Who Last Changed the Setnvarchar120
136COMT_SETTMaster Data of Set Type <SETTYPE_ID>5UPNAMEName of the User Who Last Changed the Setnvarchar120
137COMT_SETT_HHistory of Set Type <SETTYPE_ID>5UPNAMEName of the User Who Last Changed the Setnvarchar120
138COMT_SETT_MLMaster Data of Set Type <SETTYPE_ID>6UPNAMEName of the User Who Last Changed the Setnvarchar120
139COMT_SETT_ML_HHistory of Set Type <SETTYPE_ID>6UPNAMEName of the User Who Last Changed the Setnvarchar120
140COMT_SETT_XMaster Data of Set Type <SETTYPE_ID>5UPNAMEName of the User Who Last Changed the Setnvarchar120
141COMT_SETT_XMLMaster Data of Set Type <SETTYPE_ID>6UPNAMEName of the User Who Last Changed the Setnvarchar120
142COMT_SETT_XML_HHistory of Set Type <SETTYPE_ID>6UPNAMEName of the User Who Last Changed the Setnvarchar120
143COMT_SETT_X_HHistory of Set Type <SETTYPE_ID>5UPNAMEName of the User Who Last Changed the Setnvarchar120
144COMT_TEMPLATESet Type Template5UPNAMEName of the User Who Last Changed the Setnvarchar120
145COMT_TEMPLATEHSet Type History Template5UPNAMEName of the User Who Last Changed the Setnvarchar120
146COMT_TEMP_MRSet Type Template5UPNAMEName of the User Who Last Changed the Setnvarchar120
147COMT_TEMP_MRHSet Type History Template5UPNAMEName of the User Who Last Changed the Setnvarchar120
148COMT_TEMP_MR_DBSet Type Template for Multi-Value Set Types6UPNAMEName of the User Who Last Changed the Setnvarchar120
TOPSets
149T802GSets: Variables10UPNAMELast Changed Bynvarchar120
TOPTemplates
150COMC_MINITP_DATAMini-Template Data for Set Types (Generic Store)11UPNAMEName of User Who Last Changed Data Recordnvarchar120
151COMC_MINITP_DATHMini-Template Data History for Set Types (Generic Store)11UPNAMEName of User Who Last Changed Data Recordnvarchar120
152COMC_MINITP_DATSShadow Table Mini-Template Data for Set Types (Generic)11UPNAMEName of User Who Last Changed Data Recordnvarchar120
153COMC_MINITP_REGWrapping of Several Mini-Templates by a Key GUID (REG)7UPNAMEName of User Who Last Changed Data Recordnvarchar120
154COMC_MINITP_REGHHistory for Table COMC_MINITP_REG7UPNAMEName of User Who Last Changed Data Recordnvarchar120