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  | EABL
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
Industry Specific :: SAP Utilities :: Device Management :: Meter Reading
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EABL824MR DocumentMeter Reading
SQL:  selectupdate insert create

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

SELECT MANDT, ABLBELNR, GERNR, EQUNR, ZWNUMMER, ADAT, ATIM, V_ZWSTAND, N_ZWSTAND, V_ZWSTNDAB, N_ZWSTNDAB, MASSREAD, MASSBILL, STANZVOR, STANZNAC, SCHAEVER, SCHAEGR, AKTIV, ADATSOLL, ADATMAX, ATIMMAX, ADATTATS, ATIMTATS, ADATERZ, ATIMERZ, ADATPROG, ATIMPROG, ZUORDDAT, THGDATUM, PRUEFZAHL, BAPERTYP, ABLSTAT, PRUEFPKT, POPCODE, PRUEFTYP, ABLHINW, STABLHW, KONTRVRF, ABLESART, ABLESER, NACHERF, MDENR, MDEUPL, E_ZEITVBL, E_ZVLZUORD, STEUERGRP, ARBAUF, KSTATUS, ERDAT, ERNAM, AEDAT, AENAM, ENTRYNUMB, ACTOR, ISTABLART, ABLESTYP, E_ZVBL_BEZDAT, SM_AUFNR, DOC_TYPE, ADATREAL, ATIMREAL, S_ISTABLART, S_AKTIV, S_ABLSTAT, S_V_ZWSTAND, S_N_ZWSTAND, S_V_ZWSTNDAB, S_N_ZWSTNDAB, REMOVED, BP, REM_ABLBELNR, REM_ABLESER, S_ADATSOLL, S_ZVBL_BEZDAT, AMS, TRANSSTAT, TRANSTSTAMP, SOURCESYST, QNT, QDSTAT, QDPROC, PREV_MRDOC FROM EABL
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ABLBELNRInternal ID for meter reading documentnvarchar200CHAR(N' ')NoABLBELNR Allow NULL? 
3GERNRDevicenvarchar180CHAR(N' ')YesGERAET Allow NULL? 
4EQUNREquipment Numbernvarchar180CHAR(N' ')NoEQUIEQUNR Allow NULL? 
5ZWNUMMERRegisternvarchar30NUMC(N'000')YesE_ZWNUMMER Allow NULL? 
6ADATMeter reading date relevant to billingnvarchar80DATS(N'00000000')NoADAT Allow NULL? 
7ATIMMeter reading time (relevant to billing)nvarchar40CHAR(N' ')NoATIM Allow NULL? 
8V_ZWSTANDPlaces Before Decimal Point in Meter Readingdecimal170DEC((0))YesV_ZWSTAND
9N_ZWSTANDPlaces After Decimal Point in the Meter Readingdecimal1414DEC((0))YesN_ZWSTAND
10V_ZWSTNDABPredecimal Places in Billed Meter Readingdecimal170DEC((0))YesV_ZWSTNDAB
11N_ZWSTNDABDecimal Places in the Billed Meter Readingdecimal1414DEC((0))YesN_ZWSTNDAB
12MASSREADUnit of measurement for meter readingnvarchar30UNIT(N' ')YesT006E_MASSREAD Allow NULL? 
13MASSBILLUnit of measurement for billingnvarchar30UNIT(N' ')YesT006E_MASSBILL Allow NULL? 
14STANZVORNumber of predecimal places for registernvarchar20NUMC(N'00')YesSTANZVORE Allow NULL? 
15STANZNACNumber of decimal places for registernvarchar20NUMC(N'00')YesSTANZNACE Allow NULL? 
16SCHAEVEREstimation procedurenvarchar20CHAR(N' ')YesSCHAEVER Allow NULL? 
17SCHAEGREstimation reasonnvarchar20CHAR(N' ')YesTE567SCHAEGR Allow NULL? 
18AKTIVMeter reading activechar10CHAR(N' ')YesE_AKTIV Allow NULL? 
19ADATSOLLScheduled meter reading datenvarchar80DATS(N'00000000')YesADATSOLL Allow NULL? 
20ADATMAXDate of maximum meter readingnvarchar80DATS(N'00000000')YesADATMAX Allow NULL? 
21ATIMMAXTime of maximum meter readingnvarchar40CHAR(N' ')YesATIMMAX Allow NULL? 
22ADATTATSActual meter reading datenvarchar80DATS(N'00000000')YesADATTATS Allow NULL? 
23ATIMTATSActual meter reading timenvarchar40CHAR(N' ')YesATIMTATS Allow NULL? 
24ADATERZMeter reading date of implausible meter reading resultnvarchar80DATS(N'00000000')YesADATERZ Allow NULL? 
25ATIMERZMeter reading time of implausible meter reading resultnvarchar40CHAR(N' ')YesATIMERZ Allow NULL? 
26ADATPROGMeter reading date from which forecast is madenvarchar80DATS(N'00000000')YesADATPROG Allow NULL? 
27ATIMPROGMeter reading time from which consumption is determinednvarchar40CHAR(N' ')YesATIMPROG Allow NULL? 
28ZUORDDATMeter reading allocation datenvarchar80DATS(N'00000000')YesE_ZUORDDAT Allow NULL? 
29THGDATUMGas allocation datenvarchar80DATS(N'00000000')YesTHGDATUM Allow NULL? 
30PRUEFZAHLCheck numbernvarchar20NUMC(N'00')YesPRUEFZAHL Allow NULL? 
31BAPERTYPBase period categorychar10CHAR(N' ')YesBAPERTYP Allow NULL? 
32ABLSTATMeter Reading Statuschar10CHAR(N' ')YesABLSTAT Allow NULL? 
33PRUEFPKTIndependent validationnvarchar20CHAR(N' ')YesTE218PRUEFPKT Allow NULL? 
34POPCODEDependent validationnvarchar20CHAR(N' ')YesTE625POPCODE Allow NULL? 
35PRUEFTYPValidation category for meter readingschar10CHAR(N' ')YesPRUEFTYP Allow NULL? 
36ABLHINWNote from meter readernvarchar40CHAR(N' ')YesTE259ABLHINW Allow NULL? 
37STABLHWControl of follow-up action for MR result with MR notenvarchar20CHAR(N' ')YesSTABLHW Allow NULL? 
38KONTRVRFIndicator: dummy record from automatic control procedurechar10CHAR(N' ')YesKONTRVRF Allow NULL? 
39ABLESARTScheduled meter reading categorynvarchar20CHAR(N' ')YesTE614GEPLABL Allow NULL? 
40ABLESERMeter reader numbernvarchar30CHAR(N' ')YesTE115ABLESER Allow NULL? 
41NACHERFMeter reading result inserted or modifiedchar10CHAR(N' ')YesNACHERF Allow NULL? 
42MDENRNumber for mobile data entry (MDE)nvarchar30NUMC(N'000')YesMDENR Allow NULL? 
43MDEUPLOrder has been outputchar10CHAR(N' ')YesMDEDOWN Allow NULL? 
44E_ZEITVBLMultiple meter reading order creationchar10CHAR(N' ')YesE_ZEITVBL Allow NULL? 
45E_ZVLZUORDMultiple allocationnvarchar30NUMC(N'000')YesE_ZVLZUORD Allow NULL? 
46STEUERGRPControl group for multiple meter reading order creationnvarchar40CHAR(N' ')YesTE629STEUERGRP Allow NULL? 
47ARBAUFControl Meter Reading Order ID Printedchar10CHAR(N' ')YesARBAUF Allow NULL? 
48KSTATUSStatus for automatic monitoring of meter reading orderchar10CHAR(N' ')YesE_KSTATUS Allow NULL? 
49ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
50ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
51AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
52AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
53ENTRYNUMBEntry number for fast entrynvarchar80NUMC(N'00000000')NoENTRYNUMB Allow NULL? 
54ACTORConcatenated Identification (Type and ID) of Org.Objectsnvarchar140CHAR(N' ')YesHROBJEC_14 Allow NULL? 
55ISTABLARTMeter reading typenvarchar20CHAR(N' ')YesTE436ISTABLART Allow NULL? 
56ABLESTYPMeter reading categorynvarchar20CHAR(N' ')YesTE614ABLESTYP Allow NULL? 
57E_ZVBL_BEZDATScheduled meter reading date for base meter readingnvarchar80DATS(N'00000000')YesE_ZVBL_BEZDAT Allow NULL? 
58SM_AUFNRService order or notificationnvarchar120CHAR(N' ')YesPM_SVCNR Allow NULL? 
59DOC_TYPEDocument category for plant maintenance and customer servicechar10CHAR(N' ')YesKZ_SM_DOC_TYPE Allow NULL? 
60ADATREAL[JBP] Real Meter Reading Datenvarchar80DATS(N'00000000')YesADATREAL Allow NULL? 
61ATIMREAL[JBP] Real Meter Reading Timenvarchar40CHAR(N' ')YesATIMREAL Allow NULL? 
62S_ISTABLART[JBP] Meter Reading Type for Original Meter Readingnvarchar20CHAR(N' ')Yes*S_ISTABLART Allow NULL? 
63S_AKTIV[JBP] Orig. Meter Reading: Meter Reading Activechar10CHAR(N' ')YesS_AKTIV Allow NULL? 
64S_ABLSTAT[JBP] Original Meter Reading Statuschar10CHAR(N' ')YesS_ABLSTAT Allow NULL? 
65S_V_ZWSTAND[JBP] Orig. MR: Decimal Places Before Meter readingdecimal170DEC((0))YesS_V_ZWSTAND
66S_N_ZWSTAND[JBP] Decimal Places of Meter Readings for Original MRdecimal1414DEC((0))YesS_N_ZWSTAND
67S_V_ZWSTNDAB[JBP] Predecimal Places of Billed MR for Original MRdecimal170DEC((0))YesS_V_ZWSTNDAB
68S_N_ZWSTNDAB[JBP] Decimal Places of Billed Orginal Meter Readingdecimal1414DEC((0))YesS_N_ZWSTNDAB
69REMOVED[JBP] Status Indicator: MR Result Suppressedchar10CHAR(N' ')YesREMOVED Allow NULL? 
70BPSelection of Billing Period: Standard or JBPchar10CHAR(N' ')YesBP Allow NULL? 
71REM_ABLBELNR[JBP] Suppressed MR Document Numbernvarchar200CHAR(N' ')Yes*REM_ABLBELNR Allow NULL? 
72REM_ABLESERMeter Reader Number of Suppressed Meter Readingnvarchar30CHAR(N' ')Yes*R_ABLESER Allow NULL? 
73S_ADATSOLLScheduled meter reading datenvarchar80DATS(N'00000000')YesADATSOLL Allow NULL? 
74S_ZVBL_BEZDATScheduled meter reading date for base meter readingnvarchar80DATS(N'00000000')YesE_ZVBL_BEZDAT Allow NULL? 
75AMSAdvanced Metering Systemnvarchar40CHAR(N' ')YesTEAMI_AMSE_AMI_AMS Allow NULL? 
76TRANSSTATTransfer Status Codenvarchar50CHAR(N' ')YesISU_F4_AMITRSTATE_AMI_MR_TRANSSTAT Allow NULL? 
77TRANSTSTAMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217DEC((0))YesTIMESTAMPL
78SOURCESYSTSource System From Which Data is Requestedchar10NUMC(N'0')YesE_AMI_SOURCESYST Allow NULL? 
79QNTQuantity Determined from Meter Reading in Internal Formatdecimal3114DEC((0))YesE_QD_QNT
80QDSTATStatus of Quantity Determinationnvarchar20CHAR(N' ')YesE_QD_STAT Allow NULL? 
81QDPROCQty Determination Procedure During Meter Reading / Billingnvarchar20NUMC(N'00')YesE_QD_PROC_MR Allow NULL? 
82PREV_MRDOCInternal ID of Previous Meter Reading Result Documentnvarchar200CHAR(N' ')Yes*E_QD_PREV_MRDOC Allow NULL? 
NamePrimaryUniqueTypeColumns
EABL~0YesYesCLUSTEREDABLBELNR, MANDT
EABL~ECLNoNoNONCLUSTEREDACTOR, MANDT
EABL~ENUNoNoNONCLUSTEREDENTRYNUMB, ADATSOLL, MANDT
EABL~EQNNoNoNONCLUSTEREDABLSTAT, ZWNUMMER, EQUNR, MANDT

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