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  | EWAROUTE
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.0EWAROUTE744Header table of routeWaste Management
SQL:  selectupdate insert create

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

SELECT MANDT, ROUTE, ROUTE_TXT, STICHTAG, WASTE_TYPE1, PRODUCT_AREA1, RESULTYP, PRODUCT_AREA2, RESULTYP2, PRODUCT_AREA3, RESULTYP3, FLEET_CAT, CAL_ID, CORR_OPT, WASTE_CAL, KOLONNE, KOLONNE_TXT, STANDARDDRIVER, EVOL_ROUTE_TARGE, VOL_UNIT, EPREM_ROUTE_TARG, ECONT_ROUTE_TARG, ETIME_ROUTE_TARG, MEIZT, EDIST_ROUTE_TARG, MEDST, EWGHT_ROUTE_TARG, WEIGHT_UNIT, WASTE_DISP_PLANT, REGIOGROUP, FORM_ALLORD, FORM_POSORD, FORM_HEADORD, ESHIFT, SHIFT_VON, SHIFT_BIS, EPNT_ROUTE_TARG, FLEET_EQUNR1, ARBID1, ARBPL1, WERKS1, FLEET_EQUNR2, ARBID2, ARBPL2, WERKS2, FLEET_EQUNR3, ARBID3, ARBPL3, WERKS3, INACTIVE, INACTIVE_DATE, OBJNR, SWERK, STORT, BEBER, GSBER, KOKRS, KOSTL, BUKRS, DAUFN, AUFNR, DWERK, BEH_LGORT, COSTCOL, INITIAL_STATUS, FRAKTION, KOPFVERWIEGUNG, POSVERWIEGUNG, ERDAT, ERNAM, AEDAT, AENAM, BEGRU, LOEVM FROM EWAROUTE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ROUTEPlanned Waste Disposal Order Routenvarchar100CHAR(N' ')NoEROUTE Allow NULL? 
3ROUTE_TXTText for routenvarchar300CHAR(N' ')YesEROUTE_TXT Allow NULL? 
4STICHTAGDate from which the route is validnvarchar80DATS(N'00000000')YesEGUELTIGVON Allow NULL? 
5WASTE_TYPE1Wastenvarchar180CHAR(N' ')YesMARAWASTE_TYPE Allow NULL? 
6PRODUCT_AREA1Service Areanvarchar20CHAR(N' ')YesTPRDCTAREAPRODUCT_AREA Allow NULL? 
7RESULTYPConfirmation categorynvarchar20CHAR(N' ')Yes*ERESULT Allow NULL? 
8PRODUCT_AREA2Secondary service areanvarchar20CHAR(N' ')YesTPRDCTAREAPRODUCT_AREA2 Allow NULL? 
9RESULTYP2Confirmation categorynvarchar20CHAR(N' ')Yes*ERESULT Allow NULL? 
10PRODUCT_AREA3Tertiary service areanvarchar20CHAR(N' ')YesTPRDCTAREAPRODUCT_AREA3 Allow NULL? 
11RESULTYP3Confirmation categorynvarchar20CHAR(N' ')Yes*ERESULT Allow NULL? 
12FLEET_CATVehicle Typenvarchar100CHAR(N' ')YesT370FLTFLEET_CAT Allow NULL? 
13CAL_IDFactory Calendarnvarchar20CHAR(N' ')YesTFACDWFCID Allow NULL? 
14CORR_OPTCorrect non-workdaychar10CHAR(N' ')YesCALCORR Allow NULL? 
15WASTE_CALWaste Management Calendar as Template for Routenvarchar80CHAR(N' ')YesEWACALENDERWASTE_CAL Allow NULL? 
16KOLONNEResource masternvarchar80NUMC(N'00000000')Yes*KOLONNE Allow NULL? 
17KOLONNE_TXTResource master textnvarchar250CHAR(N' ')YesKOLONNE_TXT Allow NULL? 
18STANDARDDRIVERStandard driver of routenvarchar80NUMC(N'00000000')YesCRIDSTANDARDDRIVER Allow NULL? 
19EVOL_ROUTE_TARGEPlanned volume of routedecimal133QUAN((0))YesEVOL_ROUTE_TARGET
20VOL_UNITVolume unitnvarchar30UNIT(N' ')Yes*VOL_UNIT Allow NULL? 
21EPREM_ROUTE_TARGTarget Number of Premisesnvarchar50NUMC(N'00000')YesEPREMISE_TARGET Allow NULL? 
22ECONT_ROUTE_TARGPlanned number of containers for routedecimal50DEC((0))YesECONT_ROUTE_TARGET
23ETIME_ROUTE_TARGPlanned duration of routenvarchar60TIMS(N'000000')YesETIME_ROUTE_TARGET Allow NULL? 
24MEIZTUnit of measure for travelling timesnvarchar30UNIT(N' ')Yes*MEIZT Allow NULL? 
25EDIST_ROUTE_TARGPlanned distance of routedecimal133QUAN((0))YesEDIST_ROUTE_TARGET
26MEDSTUnit of measure for distancenvarchar30UNIT(N' ')Yes*MEDST Allow NULL? 
27EWGHT_ROUTE_TARGPlanned weight of routedecimal133QUAN((0))YesEWGHT_ROUTE_TARGET
28WEIGHT_UNITUnit of weightnvarchar30UNIT(N' ')Yes*WEIGHT_UNIT Allow NULL? 
29WASTE_DISP_PLANTWaste Disposal Facilitynvarchar100CHAR(N' ')Yes*WASTE_DISP_PLANT Allow NULL? 
30REGIOGROUPPolitical regional structure elementnvarchar80CHAR(N' ')Yes*REGPOLIT Allow NULL? 
31FORM_ALLORDApplication Form "Waste Disposal Orders in Full"nvarchar300CHAR(N' ')YesEFRMFORM_ALLORD Allow NULL? 
32FORM_POSORDApplication Form "Waste Disposal Order Items"nvarchar300CHAR(N' ')YesEFRMFORM_POSORD Allow NULL? 
33FORM_HEADORDApplication Form "Waste Disposal Orders Cover Sheet"nvarchar300CHAR(N' ')YesEFRMFORM_HEADORD Allow NULL? 
34ESHIFTShiftnvarchar40CHAR(N' ')YesTEWASHIFTSESHIFT Allow NULL? 
35SHIFT_VONStart timenvarchar60TIMS(N'000000')YesTIMEFROM Allow NULL? 
36SHIFT_BISEnd timenvarchar60TIMS(N'000000')YesTIMETO Allow NULL? 
37EPNT_ROUTE_TARGTarget Service Points for Routenvarchar40CHAR(N' ')YesEPOINT_ROUTE_TARG Allow NULL? 
38FLEET_EQUNR1Vehicle Number (Equipment Number)nvarchar180CHAR(N' ')YesEQUIE_VEHICLE Allow NULL? 
39ARBID1Object ID of the resourcenvarchar80NUMC(N'00000000')YesCRIDCR_OBJID Allow NULL? 
40ARBPL1Work centernvarchar80CHAR(N' ')YesARBPL Allow NULL? 
41WERKS1Plantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
42FLEET_EQUNR2Vehicle Number (Equipment Number)nvarchar180CHAR(N' ')YesEQUIE_VEHICLE Allow NULL? 
43ARBID2Object ID of the resourcenvarchar80NUMC(N'00000000')YesCRIDCR_OBJID Allow NULL? 
44ARBPL2Work centernvarchar80CHAR(N' ')YesARBPL Allow NULL? 
45WERKS2Plantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
46FLEET_EQUNR3Vehicle Number (Equipment Number)nvarchar180CHAR(N' ')YesEQUIE_VEHICLE Allow NULL? 
47ARBID3Object ID of the resourcenvarchar80NUMC(N'00000000')YesCRIDCR_OBJID Allow NULL? 
48ARBPL3Work centernvarchar80CHAR(N' ')YesARBPL Allow NULL? 
49WERKS3Plantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
50INACTIVEIndicator to Show Whether Route Has Been Deactivatedchar10CHAR(N' ')YesROUTE_INACTIVE Allow NULL? 
51INACTIVE_DATEDate, From Which Route Is Inactivenvarchar80DATS(N'00000000')YesINACTIVE_DATE Allow NULL? 
52OBJNRObject numbernvarchar220CHAR(N' ')YesONR00J_OBJNR Allow NULL? 
53SWERKMaintenance plantnvarchar40CHAR(N' ')YesT001WSWERK Allow NULL? 
54STORTLocation of maintenance objectnvarchar100CHAR(N' ')YesT499SPMLOC Allow NULL? 
55BEBERPlant sectionnvarchar30CHAR(N' ')YesT357BEBER Allow NULL? 
56GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
57KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
58KOSTLCost Centernvarchar100CHAR(N' ')YesCSKSKOSTL Allow NULL? 
59BUKRSCompany Codenvarchar40CHAR(N' ')YesT001BUKRS Allow NULL? 
60DAUFNStanding order numbernvarchar120CHAR(N' ')YesAUFKDAUFN Allow NULL? 
61AUFNRSettlement ordernvarchar120CHAR(N' ')YesAUFKILOM_ORDST Allow NULL? 
62DWERKDelivering Plantnvarchar40CHAR(N' ')YesT001WDWERK Allow NULL? 
63BEH_LGORTLocation: Storage location in plantnvarchar40CHAR(N' ')YesT001LL_LGORT Allow NULL? 
64COSTCOLCost Collector for Waste Disposal Ordernvarchar20CHAR(N' ')YesECOSTCOL Allow NULL? 
65INITIAL_STATUSInitial Status When Creating Waste Disposal Ordernvarchar40CHAR(N' ')YesINITIAL_STATUS Allow NULL? 
66FRAKTIONWaste Fractionnvarchar90CHAR(N' ')YesTEWAWASTEWASTETYPE Allow NULL? 
67KOPFVERWIEGUNGHeader Weighingchar10CHAR(N' ')YesEEWA_VERWKOPF Allow NULL? 
68POSVERWIEGUNGItem Weighingchar10CHAR(N' ')YesEEWA_VERWPOS Allow NULL? 
69ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
70ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
71AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
72AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
73BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
74LOEVMDeletion Indicatorchar10CHAR(N' ')YesLOEVM Allow NULL? 
NamePrimaryUniqueTypeColumns
EWAROUTE~0YesYesCLUSTEREDROUTE, MANDT
EWAROUTE~001NoNoNONCLUSTEREDPRODUCT_AREA1, MANDT
EWAROUTE~002NoNoNONCLUSTEREDSTORT, SWERK, MANDT
EWAROUTE~003NoNoNONCLUSTEREDARBID1, FLEET_EQUNR1, 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