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

25 columns | Print definition?ERP 6.0  | ABLESGR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1ECRM_MIOMR_TMPTemporary MR Data3ABLESGRMeter reading reasonnvarchar20
TOPContract Billing
2DBERCHVConsumption History14ABLESGRMeter reading reasonnvarchar20
3DBERCHZIndividual Line Items56ABLESGRMeter reading reasonnvarchar20
4DBERCHZ2Individual line items (device data)9ABLESGRMeter reading reasonnvarchar20
5DBERCHZ6Document line items (device data, unimportant rows)9ABLESGRMeter reading reasonnvarchar20
6EMRACCJBP: Shift Meter Reading Dates per Meter Reading Reason3ABLESGRMeter reading reasonnvarchar20
7EMRCLASSAllocate Action Meter Reading + Technical Operations Group2ABLESGRMeter reading reasonnvarchar20
8EMRSHIFTTest BIN DAI !!!!!!!!!!!!!!!!!!!6ABLESGRMeter reading reasonnvarchar20
9ERCHZ_SHORTBilling Document Individual Lines Extract48ABLESGRMeter reading reasonnvarchar20
TOPInvoicing
10DBERDZDB Table: Individ. Lines - Print Document82ABLESGRMeter reading reasonnvarchar20
11TE639Control Parameters for Express Transaction BB Change7ABLESGRMeter reading reason (limited to single entry)nvarchar20
TOPMeter Reading
12EABLGMR Reasons in MR Document4ABLESGRMeter reading reasonnvarchar20
13EABLGDELMeter Reading Reasons of Deleted Meter Reading Document4ABLESGRMeter reading reasonnvarchar20
14EIKEIndex for Removed Device -> Removal Not Yet Entered12ABLESGRMeter reading reasonnvarchar20
15TE455Parameters for Change to MR Result (CRM Integration)2ABLESGRMeter reading reasonnvarchar20
16TE609MR Reasons (Values)1ABLESGRMeter reading reasonnvarchar20
17TE609TMR Reasons (Texts)2ABLESGRMeter reading reasonnvarchar20
18TE610Priority of MR Reasons for Interval Validation2ABLESGRMeter reading reasonnvarchar20
19TE611Interpolation of MR Reasons2ABLESGRMeter reading reasonnvarchar20
20TE613Priority of Meter Reading Reasons When Times Are the Same2ABLESGRMeter reading reasonnvarchar20
21TE630Control of Meter Reading Proc.3ABLESGRMeter reading reasonnvarchar20
22TE935Automatic Meter Reading Monitoring3ABLESGRMeter reading reasonnvarchar20
TOPPortioning and scheduling
23TE418Schedule Records: MR Units16ABLESGRMeter reading reasonnvarchar20
24TE425Meter Reading Dates for Meter Reading Units6ABLESGRMeter reading reasonnvarchar20
TOPSAP Utilities
25EABLGCTemporary MR Reason of MR Document in AMI Environment4ABLESGRMeter reading reasonnvarchar20