	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	BSEG	345	Accounting Document Segment
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

122 COLUMNS | 10 INDEXES | ERP 6.0 | EWA_ORDER_OBJECT TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: SAP Utilities :: Waste Management
1	ERP EHP7	6.0	EWA_ORDER_OBJECT	122	10	Item Table for Waste Disposal Order	Waste Management

SQL: selectupdate insert create

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

SELECT MANDT, ORDERNR, ORDER_LAUFNR, CONTAINER, BEH_TYPE, SERNR, ORDER_DATE, ACTUAL_DATE, WASTE_TYPE, SERVICE_TYPE, WDPLANTNR, WASTE_WERKS, WASTE_LGORT, TIMEFRAME, START_TIME, END_TIME, SERVFREQNR, SERVFREQ_LFNR, ROUTE_SEQUENCE, SDAUFNR, SDPOSNR, ADDRNR, OLD_ORDER_DATE, EORDER_STATUS, STATUS_TXT, POSTPONED, SMAUFNR, ORDERTXT, SERVLOC, BEH_TYPE_NEW, SERNR_NEW, BEH_ANZAHL, EPROP, KUNNR, KUNWE, CAPAB, BULK_WEIGHT_UNIT, BULK_WASTE_WEIGH, BULK_VOL_UNIT, BULK_WASTE_VOL, ORDER_TYPE, ROB, ROBTYP, SUPERROB, WINTERLEVEL, CLEAN1, CLEAN2, CLEAN3, CLEAN4, CLEAN5, REMENG_TARGET, REUNIT, BEHGRP, ANZAHL_BEHGRP, BEHGRP_NEW, MBLNR, MBLNR_GG, ADD_SERVICE, BELNR, GGVERTRAG, SDAUFNR_NACH, CONTALLOC, EHS_PARTNER, INTAPPNO, APPNO, RECN, WAKEYIDE, WAKEYCATLG, MNAMIN, MNAMQIN, MNINO_UNS, MNINO_BGS, TRANSPORTER, DISPOSER, RECNWAKEY, E_WERKS, E_LGORT, POBJNR, CAPACITYKIND, SDMULTIPLE, SLOCCONTACT, PLANNED_TIME, PLANNED_DURT, IBASE, IBASE_NEW, EBELN_SC, EBELP_SC, MBLNR_SC, MJAHR_SC, BEHTYP_RM, SERNR_RM_NEW, BEH_ANZAHL_RM, REMSERNR, WEIGHT_UNIT, WASTE_WEIGHT, CONT_WGHT_TARA, CONT_WEIGHT_FULL, WASTE, VOL_UNIT, WASTE_VOL, UZEIT, CONT_SERV_DURAT, REMENG, CONFTYPE1, CONFTYPE2, CONFTYPE3, TEXT, WCNT, REF_ORDERNR, WERKS, LGORT, ABRMENGE, MIETDAUER, ZEITUNIT, PAUSE_P, ACTUAL_TIME, WGH_WASTE_WEIGHT, WGH_WASTE_VOL, KONNR_SC, KTPNR_SC, BSTMG_SC, BSTME_SC FROM EWA_ORDER_OBJECT

TOP ERP 6.0 | EWA_ORDER_OBJECT COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	ORDERNR	Internal Number for Identifying a Waste Disposal Order	nvarchar	20	0	Allow NULL?
3	ORDER_LAUFNR	Sequence Number for Waste Disposal Order Item	nvarchar	4	0	Allow NULL?
4	CONTAINER	Serial Number of Container	nvarchar	18	0	Allow NULL?
5	BEH_TYPE	Container category	nvarchar	18	0	Allow NULL?
6	SERNR	Serial Number	nvarchar	18	0	Allow NULL?
7	ORDER_DATE	Planned Date for Execution of Waste Disposal Order	nvarchar	8	0	Allow NULL?
8	ACTUAL_DATE	Actual Date of Waste Disposal Order	nvarchar	8	0	Allow NULL?
9	WASTE_TYPE	Waste	nvarchar	18	0	Allow NULL?
10	SERVICE_TYPE	Service Type	nvarchar	2	0	Allow NULL?
11	WDPLANTNR	Identification of Waste Disposal Facility	nvarchar	20	0	Allow NULL?
12	WASTE_WERKS	Plant	nvarchar	4	0	Allow NULL?
13	WASTE_LGORT	Destination: Storage location in plant	nvarchar	4	0	Allow NULL?
14	TIMEFRAME	Service window	nvarchar	2	0	Allow NULL?
15	START_TIME	Start time of a service window	nvarchar	6	0	Allow NULL?
16	END_TIME	End of service window	nvarchar	6	0	Allow NULL?
17	SERVFREQNR	Number of service frequency	nvarchar	10	0	Allow NULL?
18	SERVFREQ_LFNR	Sequence Number of Service Frequency	nvarchar	5	0	Allow NULL?
19	ROUTE_SEQUENCE	Number of stop in route	nvarchar	4	0	Allow NULL?
20	SDAUFNR	Sales Document	nvarchar	10	0	Allow NULL?
21	SDPOSNR	Item number of the SD document	nvarchar	6	0	Allow NULL?
22	ADDRNR	Address number	nvarchar	10	0	Allow NULL?
23	OLD_ORDER_DATE	Planned Date for Execution of Waste Disposal Order	nvarchar	8	0	Allow NULL?
24	EORDER_STATUS	Status of the waste disposal order	nvarchar	2	0	Allow NULL?
25	STATUS_TXT	Status Text of the Waste Disposal Order	nvarchar	30	0	Allow NULL?
26	POSTPONED	Confirmation of Waste Disposal Order Reset	char	1	0	Allow NULL?
27	SMAUFNR	Order Number	nvarchar	12	0	Allow NULL?
28	ORDERTXT	Text, 255 Characters	nvarchar	255	0	Allow NULL?
29	SERVLOC	Location of Container	nvarchar	30	0	Allow NULL?
30	BEH_TYPE_NEW	New Container Category	nvarchar	18	0	Allow NULL?
31	SERNR_NEW	New Container Serial Number	nvarchar	18	0	Allow NULL?
32	BEH_ANZAHL	Number of available containers	int	10	0	Allow NULL?
33	EPROP	Property	nvarchar	12	0	Allow NULL?
34	KUNNR	Business Partner Number	nvarchar	10	0	Allow NULL?
35	KUNWE	Ship-to party	nvarchar	10	0	Allow NULL?
36	CAPAB	Capacity Number	nvarchar	10	0	Allow NULL?
37	BULK_WEIGHT_UNIT	Unit of weight	nvarchar	3	0	Allow NULL?
38	BULK_WASTE_WEIGH	Weight of Waste Measured when Container Emptied	decimal	10	3
39	BULK_VOL_UNIT	Volume unit	nvarchar	3	0	Allow NULL?
40	BULK_WASTE_VOL	Waste Volume Measured when Container Emptied	decimal	10	3
41	ORDER_TYPE	Processing of Waste Disposal Order	nvarchar	2	0	Allow NULL?
42	ROB	Cleaning Object	nvarchar	16	0	Allow NULL?
43	ROBTYP	Cleaning Object Category	nvarchar	3	0	Allow NULL?
44	SUPERROB	Higher-Level Cleaning Object	nvarchar	16	0	Allow NULL?
45	WINTERLEVEL	Winter Maintenance Level	nvarchar	3	0	Allow NULL?
46	CLEAN1	Cleaning Method	nvarchar	3	0	Allow NULL?
47	CLEAN2	Cleaning Method	nvarchar	3	0	Allow NULL?
48	CLEAN3	Cleaning Method	nvarchar	3	0	Allow NULL?
49	CLEAN4	Cleaning Method	nvarchar	3	0	Allow NULL?
50	CLEAN5	Cleaning Method	nvarchar	3	0	Allow NULL?
51	REMENG_TARGET	Assessment Value	decimal	10	2
52	REUNIT	Unit of Measurement	nvarchar	3	0	Allow NULL?
53	BEHGRP	Container Group	nvarchar	8	0	Allow NULL?
54	ANZAHL_BEHGRP	Number of Containers in Container Group	decimal	5	0
55	BEHGRP_NEW	Container Group	nvarchar	8	0	Allow NULL?
56	MBLNR	Number of Material Document	nvarchar	10	0	Allow NULL?
57	MBLNR_GG	Number of Material Document	nvarchar	10	0	Allow NULL?
58	ADD_SERVICE	Indicator for Additional Service	char	1	0	Allow NULL?
59	BELNR	Number of a billing document	nvarchar	12	0	Allow NULL?
60	GGVERTRAG	Guarantor Contract	nvarchar	18	0	Allow NULL?
61	SDAUFNR_NACH	Subsequent sales and distribution document	nvarchar	10	0	Allow NULL?
62	CONTALLOC	Indicators	char	1	0	Allow NULL?
63	EHS_PARTNER	Waste Management Business Partner	nvarchar	10	0	Allow NULL?
64	INTAPPNO	Waste Approval	nvarchar	10	0	Allow NULL?
65	APPNO	Authority-Assigned Waste Approval Number	nvarchar	20	0	Allow NULL?
66	RECN	Unique ID Number for Integration with EHS	nvarchar	32	0	Allow NULL?
67	WAKEYIDE	Waste Code	nvarchar	132	0	Allow NULL?
68	WAKEYCATLG	Waste Catalog	nvarchar	132	0	Allow NULL?
69	MNAMIN	Disposal Quantity (Planning)	decimal	13	3
70	MNAMQIN	Unit of Measure for Outgoing Quantity	nvarchar	3	0	Allow NULL?
71	MNINO_UNS	Disposal Document	nvarchar	15	0	Allow NULL?
72	MNINO_BGS	Disposal Document	nvarchar	15	0	Allow NULL?
73	TRANSPORTER	Waste Management Business Partner	nvarchar	10	0	Allow NULL?
74	DISPOSER	Waste Management Business Partner	nvarchar	10	0	Allow NULL?
75	RECNWAKEY	Waste Code (RECN)	nvarchar	20	0	Allow NULL?
76	E_WERKS	Plant	nvarchar	4	0	Allow NULL?
77	E_LGORT	Storage Location	nvarchar	4	0	Allow NULL?
78	POBJNR	Object number	nvarchar	22	0	Allow NULL?
79	CAPACITYKIND	Capacity Category	nvarchar	20	0	Allow NULL?
80	SDMULTIPLE	Indicator: Multiple SD Contracts Allocated	char	1	0	Allow NULL?
81	SLOCCONTACT	Contact Person for Container Location	nvarchar	10	0	Allow NULL?
82	PLANNED_TIME	Time Planned	nvarchar	6	0	Allow NULL?
83	PLANNED_DURT	Service Duration	nvarchar	6	0	Allow NULL?
84	IBASE	IBase: Number of the Installed Base/IBase	nvarchar	18	0	Allow NULL?
85	IBASE_NEW	IBase: Number of the Installed Base/IBase	nvarchar	18	0	Allow NULL?
86	EBELN_SC	Purchasing Document Number	nvarchar	10	0	Allow NULL?
87	EBELP_SC	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
88	MBLNR_SC	Number of Material Document	nvarchar	10	0	Allow NULL?
89	MJAHR_SC	Material Document Year	nvarchar	4	0	Allow NULL?
90	BEHTYP_RM	Container category	nvarchar	18	0	Allow NULL?
91	SERNR_RM_NEW	Serial Number	nvarchar	18	0	Allow NULL?
92	BEH_ANZAHL_RM	Confirmed Number of Containers	int	10	0	Allow NULL?
93	REMSERNR	Serial Number for Removal	nvarchar	18	0	Allow NULL?
94	WEIGHT_UNIT	Unit of weight	nvarchar	3	0	Allow NULL?
95	WASTE_WEIGHT	Weight of Waste Measured when Container Emptied	decimal	10	3
96	CONT_WGHT_TARA	Weight of empty container	decimal	10	3
97	CONT_WEIGHT_FULL	Container weight including waste	decimal	10	3
98	WASTE	Waste	nvarchar	18	0	Allow NULL?
99	VOL_UNIT	Volume unit	nvarchar	3	0	Allow NULL?
100	WASTE_VOL	Waste Volume Measured when Container Emptied	decimal	10	3
101	UZEIT	Time	nvarchar	6	0	Allow NULL?
102	CONT_SERV_DURAT	Time required for emptying a container	nvarchar	6	0	Allow NULL?
103	REMENG	Assessment Value	decimal	10	2
104	CONFTYPE1	Confirmation note	nvarchar	8	0	Allow NULL?
105	CONFTYPE2	Confirmation note	nvarchar	8	0	Allow NULL?
106	CONFTYPE3	Confirmation note	nvarchar	8	0	Allow NULL?
107	TEXT	Text with 250 characters	nvarchar	250	0	Allow NULL?
108	WCNT	Consecutive Number of Weighing Data Record	nvarchar	4	0	Allow NULL?
109	REF_ORDERNR	Number of Waste Disposal Order for Weighing Data Record	nvarchar	20	0	Allow NULL?
110	WERKS	Plant	nvarchar	4	0	Allow NULL?
111	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
112	ABRMENGE	Billing quantity	nvarchar	36	0	Allow NULL?
113	MIETDAUER	Term of Lease	decimal	13	3
114	ZEITUNIT	Time unit	nvarchar	3	0	Allow NULL?
115	PAUSE_P	Length of Breaks	nvarchar	6	0	Allow NULL?
116	ACTUAL_TIME	Actual Time	nvarchar	6	0	Allow NULL?
117	WGH_WASTE_WEIGHT	Total Weight of Weighing Notes	decimal	10	3
118	WGH_WASTE_VOL	Total Volume of Weighing Notes	decimal	10	3
119	KONNR_SC	Number of Principal Purchase Agreement	nvarchar	10	0	Allow NULL?
120	KTPNR_SC	Item Number of Principal Purchase Agreement	nvarchar	5	0	Allow NULL?
121	BSTMG_SC	Purchase Order Quantity	decimal	13	3
122	BSTME_SC	Purchase Order Unit of Measure	nvarchar	3	0	Allow NULL?

TOP ERP 6.0 | EWA_ORDER_OBJECT INDEXES

Name	Primary	Unique	Type	Columns
EWA_ORDER_OBJECT00	No	No	NONCLUSTERED	BELNR
EWA_ORDER_OBJECTE1	No	No	NONCLUSTERED	OLD_ORDER_DATE, SERVFREQ_LFNR, SERVFREQNR, MANDT
EWA_ORDER_OBJECTE2	No	No	NONCLUSTERED	ROB, MANDT
EWA_ORDER_OBJECTE4	No	No	NONCLUSTERED	ORDER_DATE, SDAUFNR, MANDT
EWA_ORDER_OBJECTE5	No	No	NONCLUSTERED	CAPAB, MANDT
EWA_ORDER_OBJECTE6	No	No	NONCLUSTERED	SDAUFNR_NACH, MANDT
EWA_ORDER_OBJECTE8	No	No	NONCLUSTERED	BEHGRP, MANDT
EWA_ORDER_OBJECTE9	No	No	NONCLUSTERED	POBJNR, MANDT
EWA_ORDER_OBJECTWC	No	No	NONCLUSTERED	CONTAINER, MANDT
EWA_ORDER_OBJECT~0	Yes	Yes	CLUSTERED	ORDER_LAUFNR, ORDERNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

122 COLUMNS | 10 INDEXES | ERP 6.0 | EWA_ORDER_OBJECT TABLE

TOP ERP 6.0 | EWA_ORDER_OBJECT COLUMNS

TOP ERP 6.0 | EWA_ORDER_OBJECT INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

122 COLUMNS | 10 INDEXES | ERP 6.0 | EWA_ORDER_OBJECT TABLE

TOPERP 6.0 | EWA_ORDER_OBJECT COLUMNS

TOPERP 6.0 | EWA_ORDER_OBJECT INDEXES

TOP ERP 6.0 | EWA_ORDER_OBJECT COLUMNS

TOP ERP 6.0 | EWA_ORDER_OBJECT INDEXES