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  | EEWA_ROB
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 :: Waste Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EEWA_ROB402Cleaning ObjectWaste Management
SQL:  selectupdate insert create

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

SELECT MANDT, ROB, BIS, AB, ROBTYP, ROBTXT, SUBKZ, SUPERROB, WINTERLEVEL, CLEAN1, CLEAN2, CLEAN3, CLEAN4, CLEAN5, REMENG, REUNIT, GESREMENG, HNRINTANF, HNRINTANFEX, HNRINTEND, HNRINTENDEX, HNSEQ, HNRHF, HNRINTANF_TXT, HNRINTEND_TXT, COORD_LATI, COORD_LONG, COORD_TEXT, ADDRNUM, STRT_CODE, STRT_SCTN_CODE, STREET_S15, REGPOLIT, REGIOGROUP, ERDAT, ERNAM, AEDAT, AENAM, BEGRU, LOEVM FROM EEWA_ROB
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ROBCleaning Objectnvarchar160CHAR(N' ')NoEEWA_CLEAN_ROB Allow NULL? 
3BISDate at Which a Time Slice Expiresnvarchar80DATS(N'00000000')NoBISZEITSCH Allow NULL? 
4ABDate from which time slice is validnvarchar80DATS(N'00000000')NoABZEITSCH Allow NULL? 
5ROBTYPCleaning Object Categorynvarchar30CHAR(N' ')YesTEROBTYPEEWA_ROB_ROBTYP Allow NULL? 
6ROBTXTText for Cleaning Objectnvarchar720CHAR(N' ')YesEEWA_CLEAN_ROBTXT Allow NULL? 
7SUBKZLower-Level Cleaning Objectchar10CHAR(N' ')YesEEWA_CLEAN_SUBROBKZ Allow NULL? 
8SUPERROBHigher-Level Cleaning Objectnvarchar160CHAR(N' ')YesEEWA_CLEAN_SUPERROB Allow NULL? 
9WINTERLEVELWinter Maintenance Levelnvarchar30CHAR(N' ')YesTEWINTERSRVEEWA_WINTERLEVEL Allow NULL? 
10CLEAN1Cleaning Methodnvarchar30CHAR(N' ')YesTECLEANMETHODEEWA_CLEANMETH Allow NULL? 
11CLEAN2Cleaning Method 2nvarchar30CHAR(N' ')YesTECLEANMETHODEEWA_CLEANMETH2 Allow NULL? 
12CLEAN3Cleaning Method 3nvarchar30CHAR(N' ')YesTECLEANMETHODEEWA_CLEANMETH3 Allow NULL? 
13CLEAN4Cleaning Method 4nvarchar30CHAR(N' ')YesTECLEANMETHODEEWA_CLEANMETH4 Allow NULL? 
14CLEAN5Cleaning Method 5nvarchar30CHAR(N' ')YesTECLEANMETHODEEWA_CLEANMETH5 Allow NULL? 
15REMENGAssessment Valuedecimal102DEC((0))YesEEWA_CLEAN_REMENGMET
16REUNITUnit of Measurementnvarchar30UNIT(N' ')YesT006MSEHI Allow NULL? 
17GESREMENGTotal Allocated, Measured Amountdecimal102DEC((0))YesEEWA_CLEAN_GESREMENG
18HNRINTANFHaouse number - lower limit of an intervalnvarchar100NUMC(N'0000000000')YesHOUSENUM_L Allow NULL? 
19HNRINTANFEXHouse number supplement - lower limit of an intervalnvarchar40CHAR(N' ')YesHSN_SUPP_L Allow NULL? 
20HNRINTENDHouse number - upper limit of an intervalnvarchar100NUMC(N'0000000000')YesHOUSENUM_H Allow NULL? 
21HNRINTENDEXHouse number supplement - upper limit of an intervalnvarchar40CHAR(N' ')YesHSN_SUPP_H Allow NULL? 
22HNSEQHouse number ID (even/odd/all)char10NUMC(N'0')YesHSN_IND Allow NULL? 
23HNRHFHouse Number Sequencechar10CHAR(N' ')YesEEWA_CLEAN_HNRHF Allow NULL? 
24HNRINTANF_TXTText for Start of Cleaning Objectnvarchar300CHAR(N' ')YesEEWA_CLEAN_HNRINTANF_TXT Allow NULL? 
25HNRINTEND_TXTText for End of Cleaning Objectnvarchar300CHAR(N' ')YesEEWA_CLEAN_HNRINTEND_TXT Allow NULL? 
26COORD_LATIGeo location latitudedecimal1512DEC((0))YesGEOLAT
27COORD_LONGGeo location longitudedecimal1512DEC((0))YesGEOLON
28COORD_TEXTText for Coordinate Valuenvarchar720CHAR(N' ')YesEEWA_CLEAN_COORDTXT Allow NULL? 
29ADDRNUMAddress numbernvarchar100CHAR(N' ')YesADRCAD_ADDRNUM Allow NULL? 
30STRT_CODEStreet Number for City/Street Filenvarchar120CHAR(N' ')Yes*STRT_CODE Allow NULL? 
31STRT_SCTN_CODEStreet Section Codenvarchar100CHAR(N' ')YesSTRT_SCTN_CODE Allow NULL? 
32STREET_S15Short abbreviation of street name (15 chars)nvarchar150CHAR(N' ')YesSTREET_S15 Allow NULL? 
33REGPOLITPolitical regional structure elementnvarchar80CHAR(N' ')YesTE227REGPOLIT Allow NULL? 
34REGIOGROUPRegional structure groupingnvarchar80CHAR(N' ')YesADRREGGRPREGIOGROUP Allow NULL? 
35ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
36ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
37AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
38AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
39BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
40LOEVMDeletion Indicatorchar10CHAR(N' ')YesLOEVM Allow NULL? 
NamePrimaryUniqueTypeColumns
EEWA_ROB~0YesYesCLUSTEREDBIS, ROB, MANDT
EEWA_ROB~SUBNoNoNONCLUSTEREDSUPERROB, 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