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_HD_CO
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_HD_CO781Header Table for Waste Disposal Order (CO Data)Waste Management
SQL:  selectupdate insert create

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

SELECT MANDT, ORDERNR, LAUFNR, SEND_CCTR, ACTTYPE, SENBUSPROC, ACTVTY_QTY, ACTIVITYUN, ACTIVITYUN_ISO, PRICE, CURRENCY, CURRENCY_ISO, POS_OUTQTY, POSTOUTUN, POSTOUTUN_ISO, PERSON_NO, SEG_TEXT, REC_CCTR, REC_ORDER, REC_WBS_EL, RECSALEORD, RECITEM, RECCOSTOBJ, RECBUSPROC, REC_NETWRK, RECOPERATN, RECRUNSCHD, MATERIAL, PROD_VERSN, PLANT, RECPRCMTPROC, ITEMNO_ACC, REC_CALC_MOTIVE, RECACTTYPE, SRE_COMP_CODE, SRE_BUS_ENT, SRE_PROPERTY, SRE_BUILDING, SRE_RENT_UNIT, SRE_LEASE, SRE_MGMT_CON, SRE_INC_EXP, SRE_SETT_UNIT, SRE_REF_DATE, SRE_CON_NO, RRE_COMP_CODE, RRE_BUS_ENT, RRE_PROPERTY, RRE_BUILDING, RRE_RENT_UNIT, RRE_LEASE, RRE_MGMT_CON, RRE_INC_EXP, RRE_SETT_UNIT, RRE_REF_DATE, RRE_CON_NO, MATERIAL_EXT, MATERIAL_GUID, MATERIAL_VERSION, REC_FUND, REC_FUNCTION, REC_GRANT, SEND_FUND, SEND_FUNCTION, SEND_GRANT, PRICE_FIX, PRICE_VAR, PRICE_UNIT, VALUE_TOTAL, VALUE_FIX, VALUE_VAR, KOKRS, CO_BELNR, SOURCETYPE, SKOSTSTYPE, TABKEY, VBELN, POSNR FROM EWA_ORDER_HD_CO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ORDERNRInternal Number for Identifying a Waste Disposal Ordernvarchar200CHAR(N' ')No*EORDERNR Allow NULL? 
3LAUFNRSequence Number of CO Itemnvarchar100CHAR(N' ')NoEWAD_ORDER_HD_CO_LAUFNR Allow NULL? 
4SEND_CCTRSender cost centernvarchar100CHAR(N' ')Yes*SKOST Allow NULL? 
5ACTTYPEActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
6SENBUSPROCSender Business Processnvarchar120CHAR(N' ')Yes*SPRZNR Allow NULL? 
7ACTVTY_QTYActivity Quantitydecimal153QUAN((0))YesLSTXX
8ACTIVITYUNActivity unitnvarchar30UNIT(N' ')Yes*CO_MEINH_L Allow NULL? 
9ACTIVITYUN_ISOISO code for unit of measurementnvarchar30CHAR(N' ')Yes*ISOCD_UNIT Allow NULL? 
10PRICEPrice: Total Amountdecimal234DEC((0))YesBAPITAG
11CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
12CURRENCY_ISOISO currency codenvarchar30CHAR(N' ')YesISOCD Allow NULL? 
13POS_OUTQTYPosted output quantitydecimal153QUAN((0))YesAUBXX
14POSTOUTUNPosted output unitnvarchar30UNIT(N' ')Yes*CO_MEINB_A Allow NULL? 
15POSTOUTUN_ISOISO code for unit of measurementnvarchar30CHAR(N' ')Yes*ISOCD_UNIT Allow NULL? 
16PERSON_NOPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
17SEG_TEXTSegment textnvarchar500CHAR(N' ')YesCO_SGTXT Allow NULL? 
18REC_CCTRReceiver Cost Centernvarchar100CHAR(N' ')Yes*EKOSTL Allow NULL? 
19REC_ORDERReceiver Ordernvarchar120CHAR(N' ')Yes*EAUFNR Allow NULL? 
20REC_WBS_ELReceiver work breakdown structure element (WBS element)nvarchar240CHAR(N' ')YesE_PS_POSID Allow NULL? 
21RECSALEORDReceiver sales ordernvarchar100CHAR(N' ')Yes*EKDAU Allow NULL? 
22RECITEMItem number in receiver sales ordernvarchar60NUMC(N'000000')Yes*EKDPO Allow NULL? 
23RECCOSTOBJReceiver cost objectnvarchar120CHAR(N' ')Yes*EKSTR Allow NULL? 
24RECBUSPROCReceiver business processnvarchar120CHAR(N' ')Yes*EPRZNR Allow NULL? 
25REC_NETWRKReceiver Networknvarchar120CHAR(N' ')Yes*ENPLN Allow NULL? 
26RECOPERATNReceiver operationnvarchar40CHAR(N' ')YesEVORG Allow NULL? 
27RECRUNSCHDReceiver Run Schedule Headernvarchar120CHAR(N' ')Yes*ESAUFNR Allow NULL? 
28MATERIALReceiving Materialnvarchar180CHAR(N' ')Yes*CO_EMATNR Allow NULL? 
29PROD_VERSNProduction version of receiver materialnvarchar40CHAR(N' ')Yes*CO_EVERID Allow NULL? 
30PLANTPlant for receiver materialnvarchar40CHAR(N' ')Yes*CO_EWERKS Allow NULL? 
31RECPRCMTPROCReceiver procurement processnvarchar120NUMC(N'000000000000')Yes*EPROCNR Allow NULL? 
32ITEMNO_ACCAccounting Document Line Item Numbernvarchar100NUMC(N'0000000000')YesPOSNR_ACC Allow NULL? 
33REC_CALC_MOTIVEReceiver Accounting Indicatornvarchar20CHAR(N' ')Yes*EBEMOT Allow NULL? 
34RECACTTYPEReceiver activity typenvarchar60CHAR(N' ')Yes*E_LSTAR Allow NULL? 
35SRE_COMP_CODECompany code of Real Estate objects to be sentnvarchar40CHAR(N' ')Yes*VVSBUKRS Allow NULL? 
36SRE_BUS_ENTSending business entity - Real Estatenvarchar80CHAR(N' ')Yes*SSWENR Allow NULL? 
37SRE_PROPERTYSending property - Real Estatenvarchar80CHAR(N' ')Yes*SSGRNR Allow NULL? 
38SRE_BUILDINGSending building - Real Estatenvarchar80CHAR(N' ')Yes*SSGENR Allow NULL? 
39SRE_RENT_UNITSending rental unit - Real Estatenvarchar80CHAR(N' ')Yes*SSMENR Allow NULL? 
40SRE_LEASESending lease - Real Estatenvarchar130CHAR(N' ')YesSSMIVE Allow NULL? 
41SRE_MGMT_CONSending management contractnvarchar130CHAR(N' ')Yes*VVSSVWNR Allow NULL? 
42SRE_INC_EXPSending incidental expenses key - Real Estatenvarchar40CHAR(N' ')Yes*SSNKSL Allow NULL? 
43SRE_SETT_UNITSender settlement unit - Real Estatenvarchar50CHAR(N' ')Yes*SSEMPSL Allow NULL? 
44SRE_REF_DATESending reference date for acct settlement - Real Estatenvarchar80DATS(N'00000000')YesSDABRBEZ Allow NULL? 
45SRE_CON_NOSending Contract - Real Estatenvarchar130CHAR(N' ')YesRESCNNR Allow NULL? 
46RRE_COMP_CODECompany code of receiving Real Estate objectnvarchar40CHAR(N' ')Yes*EBUKRS Allow NULL? 
47RRE_BUS_ENTRecipient business entity - Real Estatenvarchar80CHAR(N' ')Yes*ESWENR Allow NULL? 
48RRE_PROPERTYRecipient property - Real Estatenvarchar80CHAR(N' ')Yes*ESGRNR Allow NULL? 
49RRE_BUILDINGRecipient buildings- Real Estatenvarchar80CHAR(N' ')Yes*ESGENR Allow NULL? 
50RRE_RENT_UNITRecipient rental unit - Real Estatenvarchar80CHAR(N' ')Yes*ESMENR Allow NULL? 
51RRE_LEASERecipient Lease Out - Real Estatenvarchar130CHAR(N' ')YesESMIVE Allow NULL? 
52RRE_MGMT_CONReceiving management contractnvarchar130CHAR(N' ')Yes*VVESVWNR Allow NULL? 
53RRE_INC_EXPRecipient incidental expenses key - Real Estatenvarchar40CHAR(N' ')Yes*ESNKSL Allow NULL? 
54RRE_SETT_UNITReal estate recipient settlement unitnvarchar50CHAR(N' ')Yes*ESEMPSL Allow NULL? 
55RRE_REF_DATERecipient reference date for acct sttlmnt - Real Est.nvarchar80DATS(N'00000000')YesEDABRBEZ Allow NULL? 
56RRE_CON_NOReceiving contract in Real Estatenvarchar130CHAR(N' ')YesREECNNR Allow NULL? 
57MATERIAL_EXTLong Material Number for MATERIAL Fieldnvarchar400CHAR(N' ')YesMGV_MATERIAL_EXTERNAL Allow NULL? 
58MATERIAL_GUIDExternal GUID for MATERIAL Fieldnvarchar320CHAR(N' ')YesMGV_MATERIAL_GUID Allow NULL? 
59MATERIAL_VERSIONVersion Number for MATERIAL Fieldnvarchar100CHAR(N' ')YesMGV_MATERIAL_VERSION Allow NULL? 
60REC_FUNDReceiver fundnvarchar100CHAR(N' ')Yes*FM_EFONDS Allow NULL? 
61REC_FUNCTIONReceiving Functional Areanvarchar160CHAR(N' ')Yes*EFKTBER Allow NULL? 
62REC_GRANTReceiver Grantnvarchar200CHAR(N' ')YesGM_GRANT_RECEIVER Allow NULL? 
63SEND_FUNDSender fundnvarchar100CHAR(N' ')Yes*FM_SFONDS Allow NULL? 
64SEND_FUNCTIONSending Functional Areanvarchar160CHAR(N' ')Yes*SFKTBER Allow NULL? 
65SEND_GRANTSender Grantnvarchar200CHAR(N' ')YesGM_GRANT_SENDER Allow NULL? 
66PRICE_FIXPrice: Fixed Portiondecimal234DEC((0))YesBAPITAF
67PRICE_VARPrice: Variable Portiondecimal234DEC((0))YesBAPITAV
68PRICE_UNITPrice Unitnvarchar50NUMC(N'00000')YesBAPITEH Allow NULL? 
69VALUE_TOTALValue: Total Amountdecimal234DEC((0))YesBAPIWTG
70VALUE_FIXValue: Fixed Portiondecimal234DEC((0))YesBAPIWTF
71VALUE_VARValue: Variable Portiondecimal234DEC((0))YesBAPIWTV
72KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
73CO_BELNRDocument Numbernvarchar100CHAR(N' ')Yes*CO_BELNR Allow NULL? 
74SOURCETYPEOrigin of CO Posting Datachar10CHAR(N' ')YesEWAD_CCOC_COSRCREF Allow NULL? 
75SKOSTSTYPESender Cost Center Type (Vehicle, Personnel...)nvarchar20CHAR(N' ')YesEWAD_CCOC_SKOSTSTYPE Allow NULL? 
76TABKEYKey for Sender Cost Center Categorynvarchar1200CHAR(N' ')YesEWAD_CCOC_SKOSTTABKEY Allow NULL? 
77VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
78POSNRItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
NamePrimaryUniqueTypeColumns
EWA_ORDER_HD_CO~0YesYesCLUSTEREDLAUFNR, 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