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

124 tablesERP 6.0 

Industry Specific :: SAP Utilities :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EAKLASSE21IS-U Billing ClassesMaster Data
2ERP EHP76.0EAKLASSET41IS-U Billing Classes (Texts)Master Data
3ERP EHP76.0EANL252InstallationMaster Data
4ERP EHP76.0EANLH263Install.Time SliceMaster Data
5ERP EHP76.0EBEVNTC171Business Event CategoryMaster Data
6ERP EHP76.0EBEVNTCT41Business Event Category (Texts)Master Data
7ERP EHP76.0EBP_ADDR_SERVICE217Search Index for Business Partner Service AddressesMaster Data
8ERP EHP76.0ECRM_OBJ_MDTDV41Division Dependant MDTMaster Data
9ERP EHP76.0ECRM_OBJ_TEMPL31Master Data Templates for CRM Technical ObjectsMaster Data
10ERP EHP76.0ECRM_PROD_TEMPL31Master Data Template for CRM Products (Technical Objects)Master Data
11ERP EHP76.0ECRM_TEMP_OBJ111CRM Integration: Clipboard for Technical ObjectsMaster Data
12ERP EHP76.0EFISEL711Field Selection Control for Address DataMaster Data
13ERP EHP76.0EGPLT31Device Location Details (Language Dependent)Master Data
14ERP EHP76.0EGPLTX41Device Location Details (Language Dependent)Master Data
15ERP EHP76.0EHAUISU72Connect. Obj.Master Data
16ERP EHP76.0EKON251Franchise Contract MasterDataMaster Data
17ERP EHP76.0EKONG161Franchise Contributions by Customer/Utility Co.Master Data
18ERP EHP76.0EKONH91Max. Prices/QuantitiesMaster Data
19ERP EHP76.0ELACC142Loyalty Account HeaderMaster Data
20ERP EHP76.0ELACCTAB71Loyalty Account Display Control (Customizing)Master Data
21ERP EHP76.0ELACCZ231Loyalty Account Line ItemMaster Data
22ERP EHP76.0ELOYALPRG121Loyalty ProgramMaster Data
23ERP EHP76.0ELOYALPRGT41Loyalty Program (Texts)Master Data
24ERP EHP76.0ENOTE152Allocation of Object to Note for Field ServiceMaster Data
25ERP EHP76.0ENOTET112Text Table for Field Service NotesMaster Data
26ERP EHP76.0EPDCRMPRODADD93IS-U Master Data Generator for Integration of CRM ProductsMaster Data
27ERP EHP76.0EPDCRMPRODPARAM61Table for Paramaters for Product Ident. of CRM ProductsMaster Data
28ERP EHP76.0EPDCRMPRODPIPS72Contains the CRM Product-Identifying ParametersMaster Data
29ERP EHP76.0EPDPROD322IS-U Master Data Generator: Master Data TemplateMaster Data
30ERP EHP76.0EPDPRODA285IS-U Master Data Generator: AttributeMaster Data
31ERP EHP76.0EPDPRODH134IS-U Master data Generator: Master Data Template HierarchyMaster Data
32ERP EHP76.0EPDPRODHT71IS-U Master data Generator: Master Data Template HierarchyMaster Data
33ERP EHP76.0EPDPRODIDSEL111MD Template: Selection Criteria for Environment AnalyzerMaster Data
34ERP EHP76.0EPDPRODT51IS-U Master Data Generator: Master Data Template TextMaster Data
35ERP EHP76.0EPDSETTINGS21MDG: General Settings for Master Data GeneratorMaster Data
36ERP EHP76.0EPDTYPE161IS-U Master Data Generator: Master Data Template CategoryMaster Data
37ERP EHP76.0EPDTYPEA181IS-U Master Data Generator: Master Data Template AttributesMaster Data
38ERP EHP76.0EPDTYPEH81IS-U Master Data Generator: Hierarchy for MDT CategoryMaster Data
39ERP EHP76.0EPDTYPEHT71IS-U Master Data Generator: Hierarchy for MDT CategoryMaster Data
40ERP EHP76.0EPDTYPET51IS-U Master Data Generator: Text for MD Template CategoryMaster Data
41ERP EHP76.0EPROP172Owner AllocationMaster Data
42ERP EHP76.0EPROPC121General Settings for Owner AllocationMaster Data
43ERP EHP76.0EPROPCA21Additional Activity for Automatic Owner Move-InMaster Data
44ERP EHP76.0EPROPCAT41Additional Activity for Automatic Owner Move-InMaster Data
45ERP EHP76.0EPROPH52Allocation of Inst. to OwnershipMaster Data
46ERP EHP76.0ERDMCANC21Reason for CancellationMaster Data
47ERP EHP76.0ERDMCANCT41Cancellation Reason (Texts)Master Data
48ERP EHP76.0ERDMSTAT21Redemption StatusMaster Data
49ERP EHP76.0ERDMSTATT41Redemption Status (Texts)Master Data
50ERP EHP76.0EREDEMP233Redemption Document for Loyalty ProgramMaster Data
51ERP EHP76.0EREWARD111Reward ItemMaster Data
52ERP EHP76.0EREWARDT41Reward Item (Texts)Master Data
53ERP EHP76.0ERWRDCAT21Reward CategoryMaster Data
54ERP EHP76.0ERWRDCATT41Reward Category (Texts)Master Data
55ERP EHP76.0ETINS32Technical information for the premiseMaster Data
56ERP EHP76.0EVBS222PremiseMaster Data
57ERP EHP76.0EVBST41Premise: Language-Dependent PartMaster Data
58ERP EHP76.0EVER946IS-U Cont.Master Data
59ERP EHP76.0EVERH286IS-U Contract HistoryMaster Data
60ERP EHP76.0EVST82Alloc. of ARCR to Ref. Val.Master Data
61ERP EHP76.0TE00141Alloc. of Co. Code - DivisionMaster Data
62ERP EHP76.0TE06131Installer StatusMaster Data
63ERP EHP76.0TE061T41Texts for Installer StatusMaster Data
64ERP EHP76.0TE09741Account Determ. IDsMaster Data
65ERP EHP76.0TE097T61Account Determ. IDs - TextsMaster Data
66ERP EHP76.0TE10221Premise TypesMaster Data
67ERP EHP76.0TE102T41Premise Types (Texts)Master Data
68ERP EHP76.0TE13071IS-U: Struc. Ind. and Cat. of Functional Loc.Master Data
69ERP EHP76.0TE13321LocationMaster Data
70ERP EHP76.0TE133T41Texts for Loc.Master Data
71ERP EHP76.0TE13V21Location of PremiseMaster Data
72ERP EHP76.0TE13VT41Location of Premise (Texts)Master Data
73ERP EHP76.0TE18321Co. TypesMaster Data
74ERP EHP76.0TE183T41Text for Company TypesMaster Data
75ERP EHP76.0TE18521Work Fields for InstallerMaster Data
76ERP EHP76.0TE185T41Texts: Work Fields for InstallerMaster Data
77ERP EHP76.0TE18921Installer License TypesMaster Data
78ERP EHP76.0TE189T41Texts for Installer License TypesMaster Data
79ERP EHP76.0TE24141Franchise Tax GroupsMaster Data
80ERP EHP76.0TE241T41Franchise Fee Groups (Texts)Master Data
81ERP EHP76.0TE49721Operation Type for Lighting UnitMaster Data
82ERP EHP76.0TE64321Processing StatusMaster Data
83ERP EHP76.0TE643T41Processing Status TextsMaster Data
84ERP EHP76.0TE64521Contract Types for Franchise Contr.Master Data
85ERP EHP76.0TE645T41Contract Types for Franchise Contr. (Texts)Master Data
86ERP EHP76.0TE67721Heat.Inst. DescriptionMaster Data
87ERP EHP76.0TE67941Charging Control of Heat. Inst.Master Data
88ERP EHP76.0TE68131Processing Status of Heat. Inst. Special AgreementMaster Data
89ERP EHP76.0TE68721Contract Cat. of Heat. Install.Master Data
90ERP EHP76.0TE687T41Texts: Contract Cat. of Heat. InstallationMaster Data
91ERP EHP76.0TE75921Reason for Supply GuaranteeMaster Data
92ERP EHP76.0TE759T41Reason for Supply GuaranteeMaster Data
93ERP EHP76.0TECAMIOVARAS31IS-U: Permitted Contract Model for ParkingMaster Data
94ERP EHP76.0TECAMIOVARAST51IS-U: Permitted Contract Models (Text Table)Master Data
95ERP EHP76.0TECHSTR121Changes to Street NamesMaster Data
96ERP EHP76.0TECONTRACTCLASS21IS-U Contract ClassesMaster Data
97ERP EHP76.0TECONTRACTCLASST41IS-U Account Cat.TextsMaster Data
98ERP EHP76.0TETECHINST31Allocation of division and technical installationMaster Data
Industry Specific :: SAP Utilities :: Master Data :: Business Partner
ProductVersionTableColumnsIndexesDescriptionModule
99ERP EHP76.0EKUN373IS-U-Specific Fields for Business PartnerBusiness Partner
100ERP EHP76.0TE18121Classification of Business PartnerBusiness Partner
101ERP EHP76.0TE181T41Text for Classification of Business PartnerBusiness Partner
102ERP EHP76.0TEBP_ADR_ADD51Supplementary Table for TEBP_ADR_SHIP_TOBusiness Partner
103ERP EHP76.0TEBP_ADR_SHIP_TO52Link Address Number of Business Partner to Ship-To PartyBusiness Partner
104ERP EHP76.0TECLERK_ID21Agent IDs for Agent DeterminationBusiness Partner
105ERP EHP76.0TECLERK_IDT41Agent IDs for Agent DeterminationBusiness Partner
106ERP EHP76.0TECST21Account Groups for Ref. Customers in IS-UBusiness Partner
107ERP EHP76.0TECVI21System Parameters for IS-UBusiness Partner
108ERP EHP76.0TEKND91System Parameters for Standard Customers in IS-UBusiness Partner
109ERP EHP76.0TUKTO31Account Groups Belonging to IS-UBusiness Partner
Industry Specific :: SAP Utilities :: Master Data :: Contract account
ProductVersionTableColumnsIndexesDescriptionModule
110ERP EHP76.0KONTOKLASSE21IS-U Acc. ClassesContract account
111ERP EHP76.0KONTOKLASSET41IS-U Account Cat.TextsContract account
112ERP EHP76.0TE002A31IS-U Specific Attribute for Contract Account CategoriesContract account
Industry Specific :: SAP Utilities :: Master Data :: Point of delivery
ProductVersionTableColumnsIndexesDescriptionModule
113ERP EHP76.0EUIGRID142Allocation of PoD to GridPoint of delivery
114ERP EHP76.0EUIHEAD142PoD Header DataPoint of delivery
115ERP EHP76.0EUIHEADT41PoD Header Data (Text)Point of delivery
116ERP EHP76.0EUIINSTLN152Allocation of Installation to PoDPoint of delivery
117ERP EHP76.0EUILNR132Allocation of Logical Device to PoDPoint of delivery
118ERP EHP76.0EUILZW132Allocation of Logical Register to PoDPoint of delivery
119ERP EHP76.0EUISTRUTYPE101PoD Structure CategoryPoint of delivery
120ERP EHP76.0EUISTRUTYPECUST61PoD Structure Category: Screen SettingsPoint of delivery
121ERP EHP76.0EUISTRUTYPET41Text for Point of Delivery StructurePoint of delivery
122ERP EHP76.0EUITRANS142Transformation of Internal/External Point of Delivery No.Point of delivery
123ERP EHP76.0EUITYPE31Type of Point of DeliveryPoint of delivery
124ERP EHP76.0EUITYPET41Type of Point of Delivery (Text)Point of delivery