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

39 columns | Print definition?ERP 6.0  | SPARTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPContract Billing
1EJBPCustomizing Standard / Japan Billing Period2SPARTYPDivision categorynvarchar20
2TE431Price Classes3SPARTYPDivision categorynvarchar20
TOPDevice installation
3ETDZTechnical Data for Installed Register7SPARTYPDivision categorynvarchar20
4TE261Control of Settlement Indicator for Register2SPARTYPDivision categorynvarchar20
5TE404Permissible Reg. Relationships per Div. Cat.2SPARTYPDivision category for device managementnvarchar20
TOPDevice Management
6EEAGInput/Output Group12SPARTYPDivision category for device managementnvarchar20
7EZWGRegister Group6SPARTYPDivision category for device managementnvarchar20
8TE055Function Classes3SPARTYPDivision categorynvarchar20
9TE065Register Identif.2SPARTYPDivision categorynvarchar20
10TE065TRegister IDs (text)3SPARTYPDivision categorynvarchar20
11TE068Permissibility of Register Codes for Each Division Category2SPARTYPDivision categorynvarchar20
12TE237Constr.Cls4SPARTYPDivision categorynvarchar20
13TE263Permiss. Combinations of Basic Dev. Cats per Division Cat.2SPARTYPDivision category for device managementnvarchar20
14TE270EZWG_DIMUnits of Measurement for Register Categories of Reg. Group2SPARTYPDivision category for device managementnvarchar20
15TE525Search Term for Register Grp2SPARTYPDivision categorynvarchar20
16TE525TRegister Group Search Term (Text)3SPARTYPDivision categorynvarchar20
17TE527Search Term for I/O Grp2SPARTYPDivision categorynvarchar20
18TE527TSearch Term: I/O Group (Text)3SPARTYPDivision categorynvarchar20
19TE593Types of Device Group4SPARTYPDivision category for device managementnvarchar20
20TE683Periodic Repl. Variants12SPARTYPDivision category for device managementnvarchar20
21TEKEMAKZSeal Indicator (B/NL)2SPARTYPDivision categorynvarchar20
22TEKENNZIFFRegister Codes2SPARTYPDivision category for device managementnvarchar20
TOPEnergy Data Management
23EDIVDIMPermitted Dimensions for Division Cat. and Profile Val. Cat.2SPARTYPDivision category for device managementnvarchar20
24EEDMSETTLDOCVARHVariants for Header Info of Settlement Document4SPARTYPDivision categorynvarchar20
25EEDMSETTLUNITSettlement Unit (Header Data)7SPARTYPDivision categorynvarchar20
TOPIntegration Customer Relationship Management
26EDIVDIM_PRPPermitted Dimensions for Division Category2SPARTYPDivision categorynvarchar20
TOPIntercompany Data Exchange
27EDEREGSWITCHPROCDeregulation Switch for Process Control2SPARTYPDivision categorynvarchar20
28EGRIDGrid in the Utilities Industry4SPARTYPDivision categorynvarchar20
29EGRIDLTGrid Level Types3SPARTYPDivision categorynvarchar20
30EIDESWTDOCSwitch Document Header31SPARTYPDivision categorynvarchar20
31EIDESWTDOCTMPTemporary Switch Document Header Data25SPARTYPDivision categorynvarchar20
32EIDESWTVIEWTASKSWorkflow for Each Switch View3SPARTYPDivision categorynvarchar20
TOPMeter Reading
33ISU_AUNIT_MDATAUnit Test: Table for Master Data3SPARTYPDivision categorynvarchar20
34TE415Energy Feeding per Period3SPARTYPDivision categorynvarchar20
35TE569Average Monthly Energy Feeding3SPARTYPDivision categorynvarchar20
TOPPoint of delivery
36EUISTRUTYPEPoD Structure Category10SPARTYPDivision categorynvarchar20
TOPRegional structure
37ADRCITYMRUMRUs for City4SPARTYPDivision categorynvarchar20
38ADRSTRTMRUMRUs for Street9SPARTYPDivision categorynvarchar20
TOPSAP Utilities
39TESPTAlloc. of Div. Cat. to Div.3SPARTYPDivision categorynvarchar20