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

Home | ERP 6.0  | TEPREPAY
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
Industry Specific :: SAP Utilities :: Contract Billing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TEPREPAY551Customizing Settings for Prepayment MeterContract Billing
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, SPARTE, RR_FROM, RR_TO, WEEKS_CONS, WEEKS_CONS_MAX, WEEKS_N_CONS, WEEKS_N_CONS_MAX, RR_MIN_CONS, RR_MIN_NON_CONS, RR_EXEPTION_CONS, RR_PROZ_CONS, RR_PROZ_NON_CONS, RR_EXEPTION_NON, WAERS, HVORG, TVORG, GEGEN_TVORG, ROUNDTYP, ROUND, FRAME_1, AKTIVE_FRAME_1, FRAME_2, AKTIVE_FRAME_2, FRAME_3, AKTIVE_FRAME_3, FRAME_4, AKTIVE_FRAME_4, FRAME_5, AKTIVE_FRAME_5, FRAME_6, AKTIVE_FRAME_6, FRAME_7, AKTIVE_FRAME_7, FRAME_8, AKTIVE_FRAME_8, FRAME_9, AKTIVE_FRAME_9, FRAME1_1, AKTIVE_FRAME1_1, FRAME1_2, AKTIVE_FRAME1_2, FRAME1_3, AKTIVE_FRAME1_3, FRAME1_4, AKTIVE_FRAME1_4, FRAME1_5, AKTIVE_FRAME1_5, FRAME1_6, AKTIVE_FRAME1_6, BLOCKING_AKTIVE, CREDIT_AKTIVE, NO_IDOC, FRAME_11, AKTIVE_FRAME_11 FROM TEPREPAY
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2SPARTEDivisionnvarchar20CHAR(N' ')NoTSPASPARTE Allow NULL? 
3RR_FROMValidity Date of Entrynvarchar80DATS(N'00000000')NoE_PP_FROM Allow NULL? 
4RR_TOValidity Date of Entrynvarchar80DATS(N'00000000')NoE_PP_TO Allow NULL? 
5WEEKS_CONSRepayment Period for Energy Debtsnvarchar30CHAR(N' ')NoE_PP_WEEKS_CONS Allow NULL? 
6WEEKS_CONS_MAXOfficial Repayment Periodnvarchar30CHAR(N' ')NoE_PP_WEEKS_MAX Allow NULL? 
7WEEKS_N_CONSRepayment Period for Energy Debtsnvarchar30CHAR(N' ')NoE_PP_WEEKS_CONS Allow NULL? 
8WEEKS_N_CONS_MAXOfficial Repayment Periodnvarchar30CHAR(N' ')NoE_PP_WEEKS_MAX Allow NULL? 
9RR_MIN_CONSRecovery Rate for Energy Debtsdecimal132CURR((0))NoE_RR_CONS
10RR_MIN_NON_CONSRecovery Rate for Non-Energy Debtsdecimal132CURR((0))NoE_RR_NON_CONS
11RR_EXEPTION_CONSException Amount for Consumption Ratedecimal132CURR((0))NoE_RR_EXEPTION
12RR_PROZ_CONSRecovery Rate (%) of Paid Amountnvarchar30CHAR(N' ')NoE_RR_PROZ_CONS Allow NULL? 
13RR_PROZ_NON_CONSRecovery Rate (%) of Paid Amountnvarchar30CHAR(N' ')NoE_RR_PROZ_NON_CONS Allow NULL? 
14RR_EXEPTION_NONException Amount for Consumption Ratedecimal132CURR((0))NoE_RR_EXEPTION
15WAERSCurrency Keynvarchar50CUKY(N' ')No*WAERS Allow NULL? 
16HVORGMain Transaction for Line Itemnvarchar40CHAR(N' ')NoTFKHVOHVORG_KK Allow NULL? 
17TVORGSubtransaction for Document Itemnvarchar40CHAR(N' ')NoTFKTVOTVORG_KK Allow NULL? 
18GEGEN_TVORGOffsetting trans. for sub-transaction of billing line itemnvarchar40CHAR(N' ')No*GEGEN_TVORG Allow NULL? 
19ROUNDTYPRounding Categorychar10CHAR(N' ')NoRUNDART Allow NULL? 
20ROUNDStarting Point for Roundingnvarchar20CHAR(N' ')NoE_RUNDUNG Allow NULL? 
21FRAME_1Text Description from 1st Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_1 Allow NULL? 
22AKTIVE_FRAME_1Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
23FRAME_2Title of Second Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_2 Allow NULL? 
24AKTIVE_FRAME_2Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
25FRAME_3Title of Third Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_3 Allow NULL? 
26AKTIVE_FRAME_3Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
27FRAME_4Title of 4th Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_4 Allow NULL? 
28AKTIVE_FRAME_4Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
29FRAME_5Title of Fifth Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_5 Allow NULL? 
30AKTIVE_FRAME_5Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
31FRAME_6Title of Sixth Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_6 Allow NULL? 
32AKTIVE_FRAME_6Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
33FRAME_7Title of Seventh Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_7 Allow NULL? 
34AKTIVE_FRAME_7Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
35FRAME_8Title of 8th Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_8 Allow NULL? 
36AKTIVE_FRAME_8Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
37FRAME_9Title of 9th Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME_9 Allow NULL? 
38AKTIVE_FRAME_9Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
39FRAME1_1Tab Form Overviewnvarchar250CHAR(N' ')NoE_PPM_FRAME1_1 Allow NULL? 
40AKTIVE_FRAME1_1Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
41FRAME1_2Tab Page Historynvarchar250CHAR(N' ')NoE_PPM_FRAME1_2 Allow NULL? 
42AKTIVE_FRAME1_2Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
43FRAME1_3Simulation Tab Pagenvarchar250CHAR(N' ')NoE_PPM_FRAME1_3 Allow NULL? 
44AKTIVE_FRAME1_3Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
45FRAME1_4Tab Page for Header Datanvarchar250CHAR(N' ')NoE_PPM_FRAME1_4 Allow NULL? 
46AKTIVE_FRAME1_4Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
47FRAME1_5Tab Page for FI/CA Documentsnvarchar250CHAR(N' ')NoE_PPM_FRAME1_5 Allow NULL? 
48AKTIVE_FRAME1_5Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
49FRAME1_6Tab Page for Individual Datanvarchar250CHAR(N' ')NoE_PPM_FRAME1_6 Allow NULL? 
50AKTIVE_FRAME1_6Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
51BLOCKING_AKTIVEBlock QS3 and QS1 IDOCSchar10CHAR(N' ')NoE_PPM_BLOCKING_AKTIVE Allow NULL? 
52CREDIT_AKTIVEDisplay Credit Window for Open Itemschar10CHAR(N' ')NoE_PPM_CREDIT_AKTIVE Allow NULL? 
53NO_IDOCDo Not Send IDOCchar10CHAR(N' ')NoE_PPM_NOIDOC Allow NULL? 
54FRAME_11Title of 11th Tabstripnvarchar250CHAR(N' ')NoE_PPM_FRAME__11 Allow NULL? 
55AKTIVE_FRAME_11Tabstrip is Activechar10CHAR(N' ')NoE_PPM_AKTIVE_TABSTRIP Allow NULL? 
NamePrimaryUniqueTypeColumns
TEPREPAY~0YesYesCLUSTEREDMANDT, SPARTE, RR_FROM

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy