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

54 columns | Print definition?ERP 6.0  | ATWRT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_PM007Data staging - Equip List Set - Char Values - complex table15ATWRTCharacteristic Valuenvarchar300
2/SMERP/STG_PM012Data staging - Func Loc LSet - Char Values - complex table15ATWRTCharacteristic Valuenvarchar300
3AUSP_CONVCharacteristic Values8ATWRTCharacteristic Valuenvarchar300
4CNV_10400_ATWRTFound values for identified ATINNs per table5ATWRTCharacteristic value /copy of ATWRTnvarchar300
TOPABAP List-Based PI Sheet
5COFIVPI Sheet: Signature for Deviation9ATWRTCharacteristic Valuenvarchar300
6COFVPPI Sheet: Process Instruction Characteristics6ATWRTCharacteristic Valuenvarchar300
7COMEPPI Sheet: Message Characteristics4ATWRTCharacteristic Valuenvarchar300
8COVLPPI Sheet: Current Variable Values5ATWRTCharacteristic Valuenvarchar300
TOPAssortment
9WRF_APC_PAVARPlanned Article Variants10ATWRTCharacteristic Valuenvarchar300
TOPAssortment Maintenance
10TWGRSize interval to calculation factor assignment6ATWRTCharacteristic Valuenvarchar300
TOPCharacteristics
11CAWNCharacteristic values5ATWRTCharacteristic Valuenvarchar300
TOPClasses
12AUSPCharacteristic Values8ATWRTCharacteristic Valuenvarchar300
13CLSELSTATISTICSStatistics for Optimizing Object Search6ATWRTCharacteristic Valuenvarchar300
TOPComputer Aided Process Planning
14VMETVORData base for CAPP rules10ATWRTCharacteristic Valuenvarchar300
TOPCross-Application Component CA Enhancements
15MILL_CLPROFPProfile for Selection by Characteristics: Items7ATWRTCharacteristic Valuenvarchar300
TOPData Collection
16S127Open Variants - Basis 212ATWRTCharacteristic Valuenvarchar300
17S127ES127 - Structural information5ATWRTCharacteristic Valuenvarchar300
18S128Open Variants - SIS11ATWRTCharacteristic Valuenvarchar300
19S128ES128 - Structural information6ATWRTCharacteristic Valuenvarchar300
20S129Open Variants - Planning12ATWRTCharacteristic Valuenvarchar300
21S129ES129 - Structural information7ATWRTCharacteristic Valuenvarchar300
TOPDigital Signature
22TC74Digital Signature for PI Sheet12ATWRTCharacteristic Valuenvarchar300
TOPEnvironment, Health and Safety
23EHQMT_CODE2EH&S-QM: Assignment of Characteristic Values to Codes2ATWRTCharacteristic Valuenvarchar300
24EHQMT_MAIN1EH&S-QM: Subs. Value Assignmt Types for Insp. Plan Creation20ATWRTCharacteristic Valuenvarchar300
TOPInstalled Base
25IBSYMBOLIB: Characteristic Value Assignment4ATWRTCharacteristic Valuenvarchar300
TOPLogistics - General
26HBSCNBConfiguration <-> condition indexing4ATWRTCharacteristic Valuenvarchar300
27HBSFSPHelp dummy table12ATWRTCharacteristic Valuenvarchar300
28WYT2MVendor-Dependent Characteristic Value Conversion5ATWRTCharacteristic Valuenvarchar300
TOPMaintenance Program Definition
29MPDEFFECTMPD effectivity data6ATWRTCharacteristic Valuenvarchar300
TOPMaster Recipe
30PLFVPI Characteristics/Sub-Operation Parameter Values19ATWRTCharacteristic Valuenvarchar300
TOPMaterial Categories
31/ISDFPS/MPO_PROTLog of Data Transfers into MPO19ATWRTCharacteristic Valuenvarchar300
TOPMaterial Groups
32WMWPValue Scale: Item Data4ATWRTCharacteristic Valuenvarchar300
TOPMaterial Master
33WRF_CHARVALCharacteristic Values with Customer Fields3ATWRTCharacteristic Value (Seasonal Procurement)nvarchar180
34WRF_CHARVALTForeign-Language Texts for Characteristic Values3ATWRTCharacteristic Value (Seasonal Procurement)nvarchar180
TOPObject Dependencies
35CUXREFObject Dependency Cross References8ATWRTCharacteristic Valuenvarchar300
TOPProcess Management
36COFVProcess Management: Process Instr. Charact. in Ctrl Recipe6ATWRTCharacteristic Valuenvarchar300
37COMEProcess Management: Message Characteristics4ATWRTCharacteristic Valuenvarchar300
38COMERProcess Message Record: Message Characteristics4ATWRTCharacteristic Valuenvarchar300
39TC50CCharacteristics for Process Messages / Process Instructions8ATWRTCharacteristic Valuenvarchar300
40TC50EProcess Management: Process Characteristics8ATWRTCharacteristic Valuenvarchar300
41TC60PP-PI: Assignment of PI Characteristics to Operator Cockpit9ATWRTCharacteristic Valuenvarchar300
42TCB11Assignment of Characteristics to Predefined Messages7ATWRTCharacteristic Valuenvarchar300
TOPProcess Order
43AFFVOrder - Process Instruction Values17ATWRTCharacteristic Valuenvarchar300
TOPProduct Lifecycle Management
44DIWPS_CACharacteristics for Work Package6ATWRTCharacteristic Valuenvarchar300
45DIWPS_RV_CARevision: Characteristics for Work Package6ATWRTCharacteristic Valuenvarchar300
TOPProduct Safety
46TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions61ATWRTCharacteristic Valuenvarchar300
TOPSoftware Management
47S427Variant Config.2---IBASE11ATWRTCharacteristic Valuenvarchar300
48S427ES427 - Structural information6ATWRTCharacteristic Valuenvarchar300
TOPVariant Configuration
49CDCNDConfiguration: Direct Conditions Data Type:CHAR4ATWRTCharacteristic Valuenvarchar300
50IBVALUECCBASE: Redundant Object Doc. on Value Changes for Instance6ATWRTCharacteristic Valuenvarchar300
51MACONDConfiguration: Manually Assigned Conditions5ATWRTCharacteristic Valuenvarchar300
TOPVehicle Management System
52VLCSEARCHCHARVELO : Search Fields (Char.) Vehicle Search (for Profile)6ATWRTCharacteristic Valuenvarchar300
TOPVendor Master
53WYT2Vendor-dependent char. value conversion4ATWRTCharacteristic Valuenvarchar300
TOPWaste Management
54TEWAUPOSADMISBLEPermissable Waste/Waste Fraction for Subitem7ATWRTCharacteristic Valuenvarchar300