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_OBJ_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_OBJ_CO791Item Table in 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, ORDER_LAUFNR, 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_OBJ_CO
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ORDERNRInternal Number for Identifying a Waste Disposal Ordernvarchar200CHAR(N' ')NoEWA_ORDER_OBJECTEORDERNR Allow NULL? 
3ORDER_LAUFNRSequence Number for Waste Disposal Order Itemnvarchar40NUMC(N'0000')NoEWA_ORDER_OBJECTORDER_LAUFNR Allow NULL? 
4LAUFNRSequence Number of CO Itemnvarchar100CHAR(N' ')NoEWAD_ORDER_OBJ_CO_LAUFNR Allow NULL? 
5SEND_CCTRSender cost centernvarchar100CHAR(N' ')YesCSKSSKOST Allow NULL? 
6ACTTYPEActivity Typenvarchar60CHAR(N' ')YesCSLALSTAR Allow NULL? 
7SENBUSPROCSender Business Processnvarchar120CHAR(N' ')YesCBPRSPRZNR Allow NULL? 
8ACTVTY_QTYActivity Quantitydecimal153QUAN((0))YesLSTXX
9ACTIVITYUNActivity unitnvarchar30UNIT(N' ')YesT006CO_MEINH_L Allow NULL? 
10ACTIVITYUN_ISOISO code for unit of measurementnvarchar30CHAR(N' ')YesT006IISOCD_UNIT Allow NULL? 
11PRICEPrice: Total Amountdecimal234DEC((0))YesBAPITAG
12CURRENCYCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
13CURRENCY_ISOISO currency codenvarchar30CHAR(N' ')YesISOCD Allow NULL? 
14POS_OUTQTYPosted output quantitydecimal153QUAN((0))YesAUBXX
15POSTOUTUNPosted output unitnvarchar30UNIT(N' ')YesT006CO_MEINB_A Allow NULL? 
16POSTOUTUN_ISOISO code for unit of measurementnvarchar30CHAR(N' ')YesT006IISOCD_UNIT Allow NULL? 
17PERSON_NOPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
18SEG_TEXTSegment textnvarchar500CHAR(N' ')YesCO_SGTXT Allow NULL? 
19REC_CCTRReceiver Cost Centernvarchar100CHAR(N' ')YesCSKSEKOSTL Allow NULL? 
20REC_ORDERReceiver Ordernvarchar120CHAR(N' ')YesAUFKEAUFNR Allow NULL? 
21REC_WBS_ELReceiver work breakdown structure element (WBS element)nvarchar240CHAR(N' ')YesE_PS_POSID Allow NULL? 
22RECSALEORDReceiver sales ordernvarchar100CHAR(N' ')YesVBUKEKDAU Allow NULL? 
23RECITEMItem number in receiver sales ordernvarchar60NUMC(N'000000')YesVBUPEKDPO Allow NULL? 
24RECCOSTOBJReceiver cost objectnvarchar120CHAR(N' ')YesCKPHEKSTR Allow NULL? 
25RECBUSPROCReceiver business processnvarchar120CHAR(N' ')YesCBPREPRZNR Allow NULL? 
26REC_NETWRKReceiver Networknvarchar120CHAR(N' ')YesAUFKENPLN Allow NULL? 
27RECOPERATNReceiver operationnvarchar40CHAR(N' ')YesEVORG Allow NULL? 
28RECRUNSCHDReceiver Run Schedule Headernvarchar120CHAR(N' ')YesSAFKESAUFNR Allow NULL? 
29MATERIALReceiving Materialnvarchar180CHAR(N' ')YesMARACO_EMATNR Allow NULL? 
30PROD_VERSNProduction version of receiver materialnvarchar40CHAR(N' ')YesMKALCO_EVERID Allow NULL? 
31PLANTPlant for receiver materialnvarchar40CHAR(N' ')YesT001WCO_EWERKS Allow NULL? 
32RECPRCMTPROCReceiver procurement processnvarchar120NUMC(N'000000000000')YesCKHSEPROCNR Allow NULL? 
33ITEMNO_ACCAccounting Document Line Item Numbernvarchar100NUMC(N'0000000000')YesPOSNR_ACC Allow NULL? 
34REC_CALC_MOTIVEReceiver Accounting Indicatornvarchar20CHAR(N' ')YesTBMOTEBEMOT Allow NULL? 
35RECACTTYPEReceiver activity typenvarchar60CHAR(N' ')YesCSLAE_LSTAR Allow NULL? 
36SRE_COMP_CODECompany code of Real Estate objects to be sentnvarchar40CHAR(N' ')YesT001VVSBUKRS Allow NULL? 
37SRE_BUS_ENTSending business entity - Real Estatenvarchar80CHAR(N' ')YesVIOB01SSWENR Allow NULL? 
38SRE_PROPERTYSending property - Real Estatenvarchar80CHAR(N' ')YesVIOB02SSGRNR Allow NULL? 
39SRE_BUILDINGSending building - Real Estatenvarchar80CHAR(N' ')YesVIOB03SSGENR Allow NULL? 
40SRE_RENT_UNITSending rental unit - Real Estatenvarchar80CHAR(N' ')YesVIMI01SSMENR Allow NULL? 
41SRE_LEASESending lease - Real Estatenvarchar130CHAR(N' ')YesSSMIVE Allow NULL? 
42SRE_MGMT_CONSending management contractnvarchar130CHAR(N' ')YesVIVW01VVSSVWNR Allow NULL? 
43SRE_INC_EXPSending incidental expenses key - Real Estatenvarchar40CHAR(N' ')YesTIV05SSNKSL Allow NULL? 
44SRE_SETT_UNITSender settlement unit - Real Estatenvarchar50CHAR(N' ')YesVIAK03SSEMPSL Allow NULL? 
45SRE_REF_DATESending reference date for acct settlement - Real Estatenvarchar80DATS(N'00000000')YesSDABRBEZ Allow NULL? 
46SRE_CON_NOSending Contract - Real Estatenvarchar130CHAR(N' ')YesRESCNNR Allow NULL? 
47RRE_COMP_CODECompany code of receiving Real Estate objectnvarchar40CHAR(N' ')YesT001EBUKRS Allow NULL? 
48RRE_BUS_ENTRecipient business entity - Real Estatenvarchar80CHAR(N' ')YesVIOB01ESWENR Allow NULL? 
49RRE_PROPERTYRecipient property - Real Estatenvarchar80CHAR(N' ')YesVIOB02ESGRNR Allow NULL? 
50RRE_BUILDINGRecipient buildings- Real Estatenvarchar80CHAR(N' ')YesVIOB03ESGENR Allow NULL? 
51RRE_RENT_UNITRecipient rental unit - Real Estatenvarchar80CHAR(N' ')YesVIMI01ESMENR Allow NULL? 
52RRE_LEASERecipient Lease Out - Real Estatenvarchar130CHAR(N' ')YesESMIVE Allow NULL? 
53RRE_MGMT_CONReceiving management contractnvarchar130CHAR(N' ')YesVIVW01VVESVWNR Allow NULL? 
54RRE_INC_EXPRecipient incidental expenses key - Real Estatenvarchar40CHAR(N' ')YesTIV05ESNKSL Allow NULL? 
55RRE_SETT_UNITReal estate recipient settlement unitnvarchar50CHAR(N' ')YesVIAK03ESEMPSL Allow NULL? 
56RRE_REF_DATERecipient reference date for acct sttlmnt - Real Est.nvarchar80DATS(N'00000000')YesEDABRBEZ Allow NULL? 
57RRE_CON_NOReceiving contract in Real Estatenvarchar130CHAR(N' ')YesREECNNR Allow NULL? 
58MATERIAL_EXTLong Material Number for MATERIAL Fieldnvarchar400CHAR(N' ')YesMGV_MATERIAL_EXTERNAL Allow NULL? 
59MATERIAL_GUIDExternal GUID for MATERIAL Fieldnvarchar320CHAR(N' ')YesMGV_MATERIAL_GUID Allow NULL? 
60MATERIAL_VERSIONVersion Number for MATERIAL Fieldnvarchar100CHAR(N' ')YesMGV_MATERIAL_VERSION Allow NULL? 
61REC_FUNDReceiver fundnvarchar100CHAR(N' ')Yes*FM_EFONDS Allow NULL? 
62REC_FUNCTIONReceiving Functional Areanvarchar160CHAR(N' ')YesTFKBEFKTBER Allow NULL? 
63REC_GRANTReceiver Grantnvarchar200CHAR(N' ')YesGM_GRANT_RECEIVER Allow NULL? 
64SEND_FUNDSender fundnvarchar100CHAR(N' ')Yes*FM_SFONDS Allow NULL? 
65SEND_FUNCTIONSending Functional Areanvarchar160CHAR(N' ')YesTFKBSFKTBER Allow NULL? 
66SEND_GRANTSender Grantnvarchar200CHAR(N' ')YesGM_GRANT_SENDER Allow NULL? 
67PRICE_FIXPrice: Fixed Portiondecimal234DEC((0))YesBAPITAF
68PRICE_VARPrice: Variable Portiondecimal234DEC((0))YesBAPITAV
69PRICE_UNITPrice Unitnvarchar50NUMC(N'00000')YesBAPITEH Allow NULL? 
70VALUE_TOTALValue: Total Amountdecimal234DEC((0))YesBAPIWTG
71VALUE_FIXValue: Fixed Portiondecimal234DEC((0))YesBAPIWTF
72VALUE_VARValue: Variable Portiondecimal234DEC((0))YesBAPIWTV
73KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
74CO_BELNRDocument Numbernvarchar100CHAR(N' ')Yes*CO_BELNR Allow NULL? 
75SOURCETYPEOrigin of CO Posting Datachar10CHAR(N' ')YesEWAD_CCOC_COSRCREF Allow NULL? 
76SKOSTSTYPESender Cost Center Type (Vehicle, Personnel...)nvarchar20CHAR(N' ')YesEWAD_CCOC_SKOSTSTYPE Allow NULL? 
77TABKEYKey for Sender Cost Center Categorynvarchar1200CHAR(N' ')YesEWAD_CCOC_SKOSTTABKEY Allow NULL? 
78VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
79POSNRItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
NamePrimaryUniqueTypeColumns
EWA_ORDER_OBJ_CO~0YesYesCLUSTEREDLAUFNR, ORDER_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