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  | TE410
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 :: Device Management :: Meter Reading
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TE410331Parameters for MR Data ProcessingMeter Reading
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, SPARTE, PROTMS, EABLAEND, EABLBELG, E_ZUKERF, UEFAKTOR1, UEFAKTOR2, KARSCHLABL, KON_REL, DUMMYES, MSPRUMZ, LEISTMS, KOABLVOR, PRORUECK, SERVICEABW, IGNESTIRESULTS, INTERVUPLPER, INTFROMESTIRES, KAUFERSTRUHANL, PROPOSE_MOVEIN, INTV_PROP_MOVEIN, INTV_INTERNET, TREAT_INTERNETMR, NOCHGE_BACKBMRES, NOCHGE_DPCMRES, INTV_DEVREPL, DEVREPL_DIALOG, INTV_INTERIM, TREAT_INTERIMMR, AMI_DER_INTERVAL, QDPLCHECK FROM TE410
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3SPARTEDivisionnvarchar20CHAR(N' ')NoTSPASPARTE Allow NULL? 
4PROTMSLog automatic estimationchar10CHAR(N' ')YesPROTMS Allow NULL? 
5EABLAENDMeter reading results can be changedchar10CHAR(N' ')YesEABLAEND Allow NULL? 
6EABLBELGIndicator: do not print meter reading document in spoolchar10CHAR(N' ')YesEABLBELG Allow NULL? 
7E_ZUKERFLimitation on MR date of MR resultchar10CHAR(N' ')YesE_ZUKERF Allow NULL? 
8UEFAKTOR1Overestimation factor in percentdecimal31DEC((0))YesUEFAKTOR1
9UEFAKTOR2Overestimation factor in percentdecimal31DEC((0))YesUEFAKTOR2
10KARSCHLABLInterval for suppression of meter readings for final MRnvarchar30NUMC(N'000')YesKARSCHLABL Allow NULL? 
11KON_RELAuto. reflect device replacement in meter reading resultschar10CHAR(N' ')YesDEVREPLACE Allow NULL? 
12DUMMYESCreate dummy EABL for meter reading order creationchar10CHAR(N' ')YesDUMMYES Allow NULL? 
13MSPRUMZNo automatic disconnection for move-in/outchar10CHAR(N' ')YesMSPRUMZ Allow NULL? 
14LEISTMSEstimation of watt and resetting registerschar10CHAR(N' ')YesLEISTMS Allow NULL? 
15KOABLVORPrepare control readingchar10CHAR(N' ')YesKOABLVOR Allow NULL? 
16PRORUECKResetting for control/interim meter readingchar10CHAR(N' ')YesPRORUECK Allow NULL? 
17SERVICEABWCreate service notification or orderchar10CHAR(N' ')YesSERVICEABW Allow NULL? 
18IGNESTIRESULTSIgnore Estimated Meter Reading Results During Extrapolationchar10CHAR(N' ')YesIGNESTIRESULTS Allow NULL? 
19INTERVUPLPERMROC interval for upload of periodic resultsnvarchar30NUMC(N'000')YesINTERVUPLPER Allow NULL? 
20INTFROMESTIRESAlso Derive from Estimated MR Resultschar10CHAR(N' ')YesINTFROMESTIRES Allow NULL? 
21KAUFERSTRUHANLNo meter reading order creation for inactive installationschar10CHAR(N' ')YesKAUFERSTRUHANL Allow NULL? 
22PROPOSE_MOVEINDisplay default move-in valuechar10CHAR(N' ')YesPROPOSE_MOVEIN Allow NULL? 
23INTV_PROP_MOVEINInterval for determining default value for move-innvarchar30NUMC(N'000')YesINTV_PROP_MOVEIN Allow NULL? 
24INTV_INTERNETInterval for internet meter readingnvarchar30NUMC(N'000')YesINTV_INTERNET Allow NULL? 
25TREAT_INTERNETMRUpload from Internet Meter Readingchar10CHAR(N' ')YesTREAT_INTERNETMR Allow NULL? 
26NOCHGE_BACKBMRESNo change to billed reading during floating backbillingchar10CHAR(N' ')YesCHGE_BACKB_MRRES Allow NULL? 
27NOCHGE_DPCMRESNo Change to Billed Meter Reading for Dynamic Period Controlchar10CHAR(N' ')YesCHGE_DPC_MRRES Allow NULL? 
28INTV_DEVREPLDevice replacement intervalnvarchar30NUMC(N'000')YesINTV_DEVREPL Allow NULL? 
29DEVREPL_DIALOGDevice Replacement (Dialog) Automatically Taken into Accountchar10CHAR(N' ')YesDEVREPLACE_DIALOG Allow NULL? 
30INTV_INTERIMInterval for Interim Meter Readingnvarchar30NUMC(N'000')YesINTV_INTERIM Allow NULL? 
31TREAT_INTERIMMRHandling of Interim Meter Reading with Billing During Uploadchar10CHAR(N' ')YesTREAT_INTERIMMR Allow NULL? 
32AMI_DER_INTERVALInterval for Derivation During AMI Entrynvarchar30NUMC(N'000')YesE_AMI_MR_DERINTERVAL Allow NULL? 
33QDPLCHECKValidation for Final Quantitychar10CHAR(N' ')YesE_QDPLCHECK Allow NULL? 
NamePrimaryUniqueTypeColumns
TE410~0YesYesCLUSTEREDMANDT, BUKRS, SPARTE

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