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  | EWA_ORDER_OBJECT
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.0EWA_ORDER_OBJECT12210Item Table for Waste Disposal OrderWaste 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
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ORDERNRInternal Number for Identifying a Waste Disposal Ordernvarchar200CHAR(N' ')No*EORDERNR Allow NULL? 
3ORDER_LAUFNRSequence Number for Waste Disposal Order Itemnvarchar40NUMC(N'0000')NoORDER_LAUFNR Allow NULL? 
4CONTAINERSerial Number of Containernvarchar180CHAR(N' ')YesBEHAELTER Allow NULL? 
5BEH_TYPEContainer categorynvarchar180CHAR(N' ')YesMARABEH_TYPE Allow NULL? 
6SERNRSerial Numbernvarchar180CHAR(N' ')YesGERNR Allow NULL? 
7ORDER_DATEPlanned Date for Execution of Waste Disposal Ordernvarchar80DATS(N'00000000')YesEORDER_DATE Allow NULL? 
8ACTUAL_DATEActual Date of Waste Disposal Ordernvarchar80DATS(N'00000000')YesEORDER_ACTDATE Allow NULL? 
9WASTE_TYPEWastenvarchar180CHAR(N' ')Yes*WASTE_TYPE Allow NULL? 
10SERVICE_TYPEService Typenvarchar20CHAR(N' ')YesTESERVICETYPESERVICE_TYPE Allow NULL? 
11WDPLANTNRIdentification of Waste Disposal Facilitynvarchar200CHAR(N' ')YesEWA_EL_WDPLANTEWAEL_WDPLANTNR Allow NULL? 
12WASTE_WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
13WASTE_LGORTDestination: Storage location in plantnvarchar40CHAR(N' ')Yes*LGORTZ Allow NULL? 
14TIMEFRAMEService windownvarchar20CHAR(N' ')YesTIMEFRAME Allow NULL? 
15START_TIMEStart time of a service windownvarchar60TIMS(N'000000')YesSTART_TIME Allow NULL? 
16END_TIMEEnd of service windownvarchar60TIMS(N'000000')YesSTOP_TIME Allow NULL? 
17SERVFREQNRNumber of service frequencynvarchar100CHAR(N' ')YesEWAOBJEOBJNR Allow NULL? 
18SERVFREQ_LFNRSequence Number of Service Frequencynvarchar50NUMC(N'00000')YesLAUFNR Allow NULL? 
19ROUTE_SEQUENCENumber of stop in routenvarchar40CHAR(N' ')YesROUTE_SEQUENCE Allow NULL? 
20SDAUFNRSales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
21SDPOSNRItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
22ADDRNRAddress numbernvarchar100CHAR(N' ')Yes*AD_ADDRNUM Allow NULL? 
23OLD_ORDER_DATEPlanned Date for Execution of Waste Disposal Ordernvarchar80DATS(N'00000000')YesEORDER_DATE Allow NULL? 
24EORDER_STATUSStatus of the waste disposal ordernvarchar20CHAR(N' ')YesEORDER_STATUS Allow NULL? 
25STATUS_TXTStatus Text of the Waste Disposal Ordernvarchar300CHAR(N' ')YesEORDER_STATUS_TXT Allow NULL? 
26POSTPONEDConfirmation of Waste Disposal Order Resetchar10CHAR(N' ')YesPOSTPONED Allow NULL? 
27SMAUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
28ORDERTXTText, 255 Charactersnvarchar2550CHAR(N' ')YesTEXT255 Allow NULL? 
29SERVLOCLocation of Containernvarchar300CHAR(N' ')YesIFLOTSERVLOC Allow NULL? 
30BEH_TYPE_NEWNew Container Categorynvarchar180CHAR(N' ')Yes*BEHTYPNEU Allow NULL? 
31SERNR_NEWNew Container Serial Numbernvarchar180CHAR(N' ')YesBEHNEU Allow NULL? 
32BEH_ANZAHLNumber of available containersint100INT4((0))YesCONT_COUNT Allow NULL? 
33EPROPPropertynvarchar120CHAR(N' ')YesEEWA_PROP_HEEWA_CLEAN_PROP Allow NULL? 
34KUNNRBusiness Partner Numbernvarchar100CHAR(N' ')YesBUT000BU_PARTNER Allow NULL? 
35KUNWEShip-to partynvarchar100CHAR(N' ')Yes*KUNWE Allow NULL? 
36CAPABCapacity Numbernvarchar100NUMC(N'0000000000')YesEEWA_CAPAB Allow NULL? 
37BULK_WEIGHT_UNITUnit of weightnvarchar30UNIT(N' ')YesT006WEIGHT_UNIT Allow NULL? 
38BULK_WASTE_WEIGHWeight of Waste Measured when Container Emptieddecimal103QUAN((0))YesWASTE_WEIGHT
39BULK_VOL_UNITVolume unitnvarchar30UNIT(N' ')YesT006VOL_UNIT Allow NULL? 
40BULK_WASTE_VOLWaste Volume Measured when Container Emptieddecimal103QUAN((0))YesWASTE_VOL
41ORDER_TYPEProcessing of Waste Disposal Ordernvarchar20CHAR(N' ')YesEORDER_TYPE Allow NULL? 
42ROBCleaning Objectnvarchar160CHAR(N' ')Yes*EEWA_CLEAN_ROB Allow NULL? 
43ROBTYPCleaning Object Categorynvarchar30CHAR(N' ')Yes*EEWA_ROB_ROBTYP Allow NULL? 
44SUPERROBHigher-Level Cleaning Objectnvarchar160CHAR(N' ')YesEEWA_CLEAN_SUPERROB Allow NULL? 
45WINTERLEVELWinter Maintenance Levelnvarchar30CHAR(N' ')Yes*EEWA_WINTERLEVEL Allow NULL? 
46CLEAN1Cleaning Methodnvarchar30CHAR(N' ')Yes*EEWA_CLEANMETH Allow NULL? 
47CLEAN2Cleaning Methodnvarchar30CHAR(N' ')Yes*EEWA_CLEANMETH Allow NULL? 
48CLEAN3Cleaning Methodnvarchar30CHAR(N' ')Yes*EEWA_CLEANMETH Allow NULL? 
49CLEAN4Cleaning Methodnvarchar30CHAR(N' ')Yes*EEWA_CLEANMETH Allow NULL? 
50CLEAN5Cleaning Methodnvarchar30CHAR(N' ')Yes*EEWA_CLEANMETH Allow NULL? 
51REMENG_TARGETAssessment Valuedecimal102DEC((0))YesEEWA_CLEAN_REMENGMET
52REUNITUnit of Measurementnvarchar30UNIT(N' ')Yes*MSEHI Allow NULL? 
53BEHGRPContainer Groupnvarchar80CHAR(N' ')Yes*BEHGRP Allow NULL? 
54ANZAHL_BEHGRPNumber of Containers in Container Groupdecimal50DEC((0))YesECONT_BEHGRP
55BEHGRP_NEWContainer Groupnvarchar80CHAR(N' ')Yes*BEHGRP Allow NULL? 
56MBLNRNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
57MBLNR_GGNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
58ADD_SERVICEIndicator for Additional Servicechar10CHAR(N' ')YesADD_SERVICE Allow NULL? 
59BELNRNumber of a billing documentnvarchar120CHAR(N' ')YesE_BELNR Allow NULL? 
60GGVERTRAGGuarantor Contractnvarchar180CHAR(N' ')YesE_GUARANTOR_CONTRACT Allow NULL? 
61SDAUFNR_NACHSubsequent sales and distribution documentnvarchar100CHAR(N' ')Yes*VBELN_NACH Allow NULL? 
62CONTALLOCIndicatorschar10CHAR(N' ')YesKENNZX Allow NULL? 
63EHS_PARTNERWaste Management Business Partnernvarchar100CHAR(N' ')YesEHS_PARTNER Allow NULL? 
64INTAPPNOWaste Approvalnvarchar100CHAR(N' ')YesEWA_EHS_APPNOINT Allow NULL? 
65APPNOAuthority-Assigned Waste Approval Numbernvarchar200CHAR(N' ')YesEWA_EHS_APPNO Allow NULL? 
66RECNUnique ID Number for Integration with EHSnvarchar320CHAR(N' ')YesEWAEHS_GUID Allow NULL? 
67WAKEYIDEWaste Codenvarchar1320CHAR(N' ')YesEHS_WAKEYIDE Allow NULL? 
68WAKEYCATLGWaste Catalognvarchar1320CHAR(N' ')YesEHS_WAKEYCATLG Allow NULL? 
69MNAMINDisposal Quantity (Planning)decimal133QUAN((0))YesEHS_MNAMIN
70MNAMQINUnit of Measure for Outgoing Quantitynvarchar30UNIT(N' ')Yes*EHS_MNAMQIN Allow NULL? 
71MNINO_UNSDisposal Documentnvarchar150CHAR(N' ')YesEWA_EHSWAE_MNINO Allow NULL? 
72MNINO_BGSDisposal Documentnvarchar150CHAR(N' ')YesEWA_EHSWAE_MNINO Allow NULL? 
73TRANSPORTERWaste Management Business Partnernvarchar100CHAR(N' ')YesEHS_PARTNER Allow NULL? 
74DISPOSERWaste Management Business Partnernvarchar100CHAR(N' ')YesEHS_PARTNER Allow NULL? 
75RECNWAKEYWaste Code (RECN)nvarchar200NUMC(N'00000000000000000000')YesEHS_WAKEY Allow NULL? 
76E_WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
77E_LGORTStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
78POBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
79CAPACITYKINDCapacity Categorynvarchar200CHAR(N' ')YesEWA_CAPACITYKIND Allow NULL? 
80SDMULTIPLEIndicator: Multiple SD Contracts Allocatedchar10CHAR(N' ')YesEWA_MULTIPLE_FLAG Allow NULL? 
81SLOCCONTACTContact Person for Container Locationnvarchar100CHAR(N' ')Yes*EWA_SLOC_CONTACT Allow NULL? 
82PLANNED_TIMETime Plannednvarchar60TIMS(N'000000')YesPLDTIM Allow NULL? 
83PLANNED_DURTService Durationnvarchar60TIMS(N'000000')YesSERVDUR Allow NULL? 
84IBASEIBase: Number of the Installed Base/IBasenvarchar180NUMC(N'000000000000000000')YesIB_IBASE Allow NULL? 
85IBASE_NEWIBase: Number of the Installed Base/IBasenvarchar180NUMC(N'000000000000000000')YesIB_IBASE Allow NULL? 
86EBELN_SCPurchasing Document Numbernvarchar100CHAR(N' ')YesEKKOEBELN Allow NULL? 
87EBELP_SCItem Number of Purchasing Documentnvarchar50NUMC(N'00000')YesEKPOEBELP Allow NULL? 
88MBLNR_SCNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
89MJAHR_SCMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
90BEHTYP_RMContainer categorynvarchar180CHAR(N' ')Yes*BEH_TYPE Allow NULL? 
91SERNR_RM_NEWSerial Numbernvarchar180CHAR(N' ')YesGERNR Allow NULL? 
92BEH_ANZAHL_RMConfirmed Number of Containersint100INT4((0))YesANZSERN_RM Allow NULL? 
93REMSERNRSerial Number for Removalnvarchar180CHAR(N' ')YesREMSERNR Allow NULL? 
94WEIGHT_UNITUnit of weightnvarchar30UNIT(N' ')YesT006WEIGHT_UNIT Allow NULL? 
95WASTE_WEIGHTWeight of Waste Measured when Container Emptieddecimal103QUAN((0))YesWASTE_WEIGHT
96CONT_WGHT_TARAWeight of empty containerdecimal103QUAN((0))YesCONT_WGHT_TARA
97CONT_WEIGHT_FULLContainer weight including wastedecimal103QUAN((0))YesCONT_WEIGHT_FULL
98WASTEWastenvarchar180CHAR(N' ')Yes*WASTE_TYPE Allow NULL? 
99VOL_UNITVolume unitnvarchar30UNIT(N' ')YesT006VOL_UNIT Allow NULL? 
100WASTE_VOLWaste Volume Measured when Container Emptieddecimal103QUAN((0))YesWASTE_VOL
101UZEITTimenvarchar60TIMS(N'000000')YesUZEIT Allow NULL? 
102CONT_SERV_DURATTime required for emptying a containernvarchar60TIMS(N'000000')YesCONT_SERV_DURAT Allow NULL? 
103REMENGAssessment Valuedecimal102DEC((0))YesEEWA_CLEAN_REMENGMET
104CONFTYPE1Confirmation notenvarchar80CHAR(N' ')YesTEWACONFTYPECONFTYPE Allow NULL? 
105CONFTYPE2Confirmation notenvarchar80CHAR(N' ')YesTEWACONFTYPECONFTYPE Allow NULL? 
106CONFTYPE3Confirmation notenvarchar80CHAR(N' ')YesTEWACONFTYPECONFTYPE Allow NULL? 
107TEXTText with 250 charactersnvarchar2500CHAR(N' ')YesETEXT250 Allow NULL? 
108WCNTConsecutive Number of Weighing Data Recordnvarchar40NUMC(N'0000')YesEWEIGHCNT Allow NULL? 
109REF_ORDERNRNumber of Waste Disposal Order for Weighing Data Recordnvarchar200CHAR(N' ')Yes*EORDERNR_REF Allow NULL? 
110WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
111LGORTStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
112ABRMENGEBilling quantitynvarchar360CHAR(N' ')YesE_ABRMENGE Allow NULL? 
113MIETDAUERTerm of Leasedecimal133QUAN((0))YesE_MIETDAUER
114ZEITUNITTime unitnvarchar30UNIT(N' ')YesT006MAIZE Allow NULL? 
115PAUSE_PLength of Breaksnvarchar60TIMS(N'000000')YesPAUSEN_P Allow NULL? 
116ACTUAL_TIMEActual Timenvarchar60TIMS(N'000000')YesACTTIM Allow NULL? 
117WGH_WASTE_WEIGHTTotal Weight of Weighing Notesdecimal103QUAN((0))YesEWADWGH_WASTE_WEIGHT
118WGH_WASTE_VOLTotal Volume of Weighing Notesdecimal103QUAN((0))YesEWADWGH_WASTE_VOL
119KONNR_SCNumber of Principal Purchase Agreementnvarchar100CHAR(N' ')YesEKKOKONNR Allow NULL? 
120KTPNR_SCItem Number of Principal Purchase Agreementnvarchar50NUMC(N'00000')YesEKPOKTPNR Allow NULL? 
121BSTMG_SCPurchase Order Quantitydecimal133QUAN((0))YesBSTMG
122BSTME_SCPurchase Order Unit of Measurenvarchar30UNIT(N' ')YesT006BSTME Allow NULL? 
NamePrimaryUniqueTypeColumns
EWA_ORDER_OBJECT00NoNoNONCLUSTEREDBELNR
EWA_ORDER_OBJECTE1NoNoNONCLUSTEREDOLD_ORDER_DATE, SERVFREQ_LFNR, SERVFREQNR, MANDT
EWA_ORDER_OBJECTE2NoNoNONCLUSTEREDROB, MANDT
EWA_ORDER_OBJECTE4NoNoNONCLUSTEREDORDER_DATE, SDAUFNR, MANDT
EWA_ORDER_OBJECTE5NoNoNONCLUSTEREDCAPAB, MANDT
EWA_ORDER_OBJECTE6NoNoNONCLUSTEREDSDAUFNR_NACH, MANDT
EWA_ORDER_OBJECTE8NoNoNONCLUSTEREDBEHGRP, MANDT
EWA_ORDER_OBJECTE9NoNoNONCLUSTEREDPOBJNR, MANDT
EWA_ORDER_OBJECTWCNoNoNONCLUSTEREDCONTAINER, MANDT
EWA_ORDER_OBJECT~0YesYesCLUSTEREDORDER_LAUFNR, ORDERNR, 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