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

115 columns | Print definition?ERP 6.0  | SPARTE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_PM001Data staging - Equipment complex table70SPARTEDivisionnvarchar20
2/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab70SPARTEDivisionnvarchar20
3EPRODDETIS-U: Product Determination for Owner Move-in2SPARTEDivisionnvarchar20
TOPContract Accounts Receivable and Payable
4TE305Transactions for Company Code and Division4SPARTEDivisionnvarchar20
5TE305TTransactions for Company Code and Division (Texts)5SPARTEDivisionnvarchar20
TOPContract Billing
6EDSCDisc.Header Data3SPARTEDivisionnvarchar20
7EMDUSDIFACEHEADTime-of-Use Interface6SPARTEDivisionnvarchar20
8EMRSHIFTTest BIN DAI !!!!!!!!!!!!!!!!!!!7SPARTEDivisionnvarchar20
9EPREIMstr Pricing Table for All Prices5SPARTEDivisionnvarchar20
10EPRESCLPrice Adjustment Clause for All Price Categories4SPARTEDivisionnvarchar20
11ERCHBilling Doc. Data4SPARTEDivisionnvarchar20
12ERCH_RIVAHeader Data for Billing Document Extract (RIVA)4SPARTEDivisionnvarchar20
13ERCH_SHORTHeader Data for Billing Document - Extract4SPARTEDivisionnvarchar20
14ESCHBilling Schema (Header Data)3SPARTEDivisionnvarchar20
15ETOUDCONSPATConsumption Pattern3SPARTEDivisionnvarchar20
16ETRFRate (Head. Data)3SPARTEDivisionnvarchar20
17ETTAGeneral Rate Category (Header Data)3SPARTEDivisionnvarchar20
18TE069Rate Types3SPARTEDivisionnvarchar20
19TE221Operands3SPARTEDivisionnvarchar20
20TE222Consumption Types3SPARTEDivisionnvarchar20
21TEPREPAYCustomizing Settings for Prepayment Meter2SPARTEDivisionnvarchar20
22TEPREPAY_NATUREDescription of Complaint Reason2SPARTEDivisionnvarchar20
TOPCustomer Contact
23BCONTBusiness Partner Contact24SPARTEDivisionnvarchar20
TOPCustomer Service
24EINIDATCRIInitial Data Creation Doc.: Premise - Installation Data4SPARTEDivisionnvarchar20
TOPDevice Management
25EGERRDevice data: Info record for point of delivery - historical26SPARTEDivisionnvarchar20
26EGTURPeriodic Replacement List15SPARTEDivisionnvarchar20
27ETYPDev. Cat.: IS-U Additional Material Data34SPARTEDivisionnvarchar20
28TE025ASample Device Determination2SPARTEDivisionnvarchar20
29TE025BExtension Periods for Official Lots2SPARTEDivisionnvarchar20
30TE025CSample Device Determination2SPARTEDivisionnvarchar20
31TE269Dev.Req. Planning8SPARTEDivisionnvarchar20
32TE271Sample Lot7SPARTEDivisionnvarchar20
33TE595Allocation of Group Type to Division3SPARTEDivisionnvarchar20
34TELOT_CRDEFSpecifications for Lot Compilation (B/NL)2SPARTEDivisionnvarchar20
35TELOT_LOCKEDBlocked Devices During Lot Compilation (B/NL)2SPARTEDivisionnvarchar20
36TELOT_RESULTResults of Lot Allocation for Belgium/Netherlands2SPARTEDivisionnvarchar20
37TELOT_RESULT_TOPHeader Table for Lot Allocation Results for B/NL2SPARTEDivisionnvarchar20
TOPEnergy Data Management
38EEDMIMPORTLOG_DBEDM Import Log: Database Table25SPARTEDivisionnvarchar20
39EPROFHEADProfile Header Data3SPARTEDivisionnvarchar20
40EPROFHEAD_TMPHeader Data of Temporary Profile3SPARTEDivisionnvarchar20
41ERTPINTERFACERTP Interface (Header Data)5SPARTEDivisionnvarchar20
TOPEquipment
42EQUIEquipment master data65SPARTEDivisionnvarchar20
TOPGeneric Contract Accounts Receivable and Payable
43TFSCHVTVTransactions for Company Code and Division4SPARTEDivisionnvarchar20
44TFSCHVTVTTransactions for Company Code and Division (Texts)5SPARTEDivisionnvarchar20
TOPIntercompany Data Exchange
45EDEREGSCENARIOSupply Scenario3SPARTEDivisionnvarchar20
46ESERVICEPoint of delivery service10SPARTEDivisionnvarchar20
TOPInvoicing
47DBERDLPrint Document Line Items9SPARTEDivisionnvarchar20
48DBERDLBReference of a Print Doc. Line Item to a Bill.Doc. Line Item11SPARTEDivisionnvarchar20
49DBERDZDB Table: Individ. Lines - Print Document24SPARTEDivisionnvarchar20
50EITRTemporary Selection Data for IS-U Invoicing11SPARTEDivisionnvarchar20
51EJVLYearly Advance Payment4SPARTEDivisionnvarchar20
52ERDTSAdditional Charges and Taxes of a Print Document9SPARTEDivisionnvarchar20
53ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data18SPARTEDivisionnvarchar20
54TE558Amount/Process Limits for Pay.Scheme Adjustment in Invoicing3SPARTEDivisionnvarchar20
55TE560Percentage Limits for Manual Payment Scheme Changes3SPARTEDivisionnvarchar20
56TE757General Amount Adjustment Factor for BB Plan3SPARTEDivisionnvarchar20
TOPMarketing
57EMKT_ESTM_CONSMarketing: Extrapolated Consumption for Each Contract5SPARTEDivisionnvarchar20
58EMKT_ESTM_CONS_PMarketing: Extrapolation Index for Mass Activity5SPARTEDivisionnvarchar20
TOPMaster Data
59EANLInstallation3SPARTEDivisionnvarchar20
60EKONFranchise Contract MasterData4SPARTEDivisionnvarchar20
61ELACCZLoyalty Account Line Item17SPARTEDivisionnvarchar20
62EVERIS-U Cont.4SPARTEDivisionnvarchar20
63TE001Alloc. of Co. Code - Division3SPARTEDivisionnvarchar20
64TE097Account Determ. IDs3SPARTEDivisionnvarchar20
65TE097TAccount Determ. IDs - Texts4SPARTEDivisionnvarchar20
66TECAMIOVARASIS-U: Permitted Contract Model for Parking2SPARTEDivisionnvarchar20
67TECAMIOVARASTIS-U: Permitted Contract Models (Text Table)3SPARTEDivisionnvarchar20
68TETECHINSTAllocation of division and technical installation2SPARTEDivisionnvarchar20
TOPMeter Reading
69EBIASTable for Calculation of BIAS Factor8SPARTEDivisionnvarchar20
70ETRGBilling Order6SPARTEDivisionnvarchar20
71TE410Parameters for MR Data Processing3SPARTEDivisionnvarchar20
72TE411Estimation Parameters: MR Data Entry3SPARTEDivisionnvarchar20
73TE630Control of Meter Reading Proc.2SPARTEDivisionnvarchar20
74TE935Automatic Meter Reading Monitoring2SPARTEDivisionnvarchar20
TOPMove-InOut
75ECAMIOPRCIIS-U: Parked Document: Contracts and Installations8SPARTEDivisionnvarchar20
76TE490AVMove-Out Control: Contract Level3SPARTEDivisionnvarchar20
77TE490EVMove-In Control: Contract Level3SPARTEDivisionnvarchar20
78TECAMIOVARAMIS-U: Pre-entry Variants / Permitted Master Data Templates3SPARTEDivisionnvarchar20
79TECAMIOVARAMTIS-U: Permitted Master Data Templates (Text Tables)4SPARTEDivisionnvarchar20
80TECAMIOVARAPIS-U: Pre-entry Variants / Permitted Products3SPARTEDivisionnvarchar20
81TECAMIOVARAPTIS-U: Permitted Contract Models (Text Table)4SPARTEDivisionnvarchar20
82TECAMIOVARSPIS-U: Pre-entry Variants: Division-dependent Data3SPARTEDivisionnvarchar20
TOPPeriodical Sales and Distribution
83JWTWEKOIS-M/SD: Sales Activity for Business Partner16SPARTEDivisionnvarchar20
TOPProcessing
84EWMINSPDETAILInspection List Detail7SPARTEDivisionnvarchar20
85EWMPERIODEQPeriods for equipment inspections3SPARTEDivisionnvarchar20
86EWMPERIODTIPeriods for technical installation inspections3SPARTEDivisionnvarchar20
87TESERVICEAlloc. of Service Obj. to Division and Set Level4SPARTEDivisionnvarchar20
TOPRegional structure
88ADRCITYCCSDivision-Dependent Data for City4SPARTEDivisionnvarchar20
89ADRCITYKONFranch. Contracts for City5SPARTEDivisionnvarchar20
90ADRSTRTCCSDivision-Dependent Data for Street9SPARTEDivisionnvarchar20
91ADRSTRTKONFranchise Contracts for Street10SPARTEDivisionnvarchar20
TOPRegulatory reporting for insurance companies
92ISSRFLDEOObject table 110SPARTEInsurance Line of Business Indicatornvarchar20
93ISSR_RPI_MFTISSR: Feste und variable Daten Meldewesen14SPARTEKennzeichen Versicherungsspartenvarchar20
94ISSR_RPI_MFT_BCKISSR: Feste und variable Daten Meldewesen als Backuptabelle14SPARTEKennzeichen Versicherungsspartenvarchar20
95TISSR_ADMIN_FVALFestwertsteuerung für Meldewesen-Stammdatenverwaltung6SPARTEKennzeichen Versicherungsspartenvarchar20
96TISSR_BPV_ANRECHMeldewesen Schweiz - Anrechnungsfaktor4SPARTEKennzeichen Versicherungsspartenvarchar20
97TISSR_BPV_SKZ_SPMeldewesen Schweiz - erlaubte Kombinationen SichFonds/Sparte4SPARTEKennzeichen Versicherungsspartenvarchar20
98TISSR_CHA_MD_PROProtokoll bei Stammdatenänderung22SPARTEKennzeichen Versicherungsspartenvarchar20
99TISSR_DEPOT_FVALFestwertmodifikation für Meldewesen-Depotdaten4SPARTEKennzeichen Versicherungsspartenvarchar20
100TISSR_SPARTEISSR: Versicherungssparte2SPARTEKennzeichen Versicherungsspartenvarchar20
101TISSR_SPARTETISSR: Versicherungssparte Texttabelle3SPARTEKennzeichen Versicherungsspartenvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
102TNWCHTMDIVISIS-H CH: TARMED - Leistungsregel Spartenzuschlag4SPARTEIS-H CH: codice settorenvarchar40
TOPSAP Utilities
103ELPROFLoad Profile Header Data3SPARTEDivisionnvarchar20
104TECONTYPConcession Type9SPARTEDivisionnvarchar20
105TESPTAlloc. of Div. Cat. to Div.2SPARTEDivisionnvarchar20
TOPStatistics
106S440IS-U rate statistics8SPARTEDivisionnvarchar20
107S440ES440: Structure Information3SPARTEDivisionnvarchar20
108S441IS-U Industry Statistics12SPARTEDivisionnvarchar20
109S441ES441: Structure Information7SPARTEDivisionnvarchar20
110TE775Update Group Determination2SPARTEDivisionnvarchar20
111TE776UIS: Alloc. of Billing Unit of Meas. -> Stat. Unit of Meas.2SPARTEDivisionnvarchar20
TOPTransaction Manager
112TWD01Treasury: Securities Account Master Data46SPARTEInsurance Line of Business Indicatornvarchar20
TOPVisit Control
113/DSD/VC_VLPDSD: Visit List - Item Data11SPARTEDivisionnvarchar20
114/DSD/VC_VPPDSD: Visit Schedule - Item Data13SPARTEDivisionnvarchar20
TOPWaste Management
115TEROBTYPCustomizing for Cleaning Object Category5SPARTEDivisionnvarchar20