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  | COPPP_ITM
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
Controlling
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0COPPP_ITM1091CO Postprocessing List - ItemsControlling
SQL:  selectupdate insert create

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

SELECT MANDT, GUID, VRGNG, KOKRS, BELNR, ZEILE, ZLENR, SKOSTL, SLSTAR, SAUFNR, SBEMOT, SPRZNR, SPSPNR, SKDAUF, SKDPOS, SKSTRG, SNPLNR, SVORGN, SRECIND, SPAOBJ, SGEBER, SFKBER, SGRANT_NBR, SBUDGET_PD, KSTAR, STAGR, MBGBTR, MEINB, TARIF, WAERS, AUSBR, AUBEH, PERNR, SGTXT, WTGBTR, WTFBTR, WKGBTR, WKFBTR, EKOSTL, ELSTAR, EAUFNR, EBEMOT, EPRZNR, EPSPNR, EKDAUF, EKDPOS, EKSTRG, ENPLNR, EVORGN, EPROCNR, EMATNR, EWERKS, ESAUFN, EVERID, EAUFHK, ERECIND, EPAOBJ, EGEBER, EFKBER, EGRANT_NBR, EBUDGET_PD, SIMKEY, SIMBUKRS, SIMSWENR, SIMSGRNR, SIMSGENR, SIMSMENR, SIMSMIVE, SIMSVWNR, SIMSNKSL, SIMSEMPSL, SIMDABRBEZ, SIMRECNNR, EIMKEY, EIMBUKRS, EIMSWENR, EIMSGRNR, EIMSGENR, EIMSMENR, EIMSMIVE, EIMSVWNR, EIMSNKSL, EIMSEMPSL, EIMDABRBEZ, EIMRECNNR, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, Z_PRS_OFFSHORE, Z_PRS_BILL_FLAG, Z_PRS_COUNTRY, Z_PRS_CHARGELEVL, PRICE_TOTAL, PRICE_FIX, PRICE_VAR, PRICE_TKE, EX_CURR, VALUE_TOTAL, VALUE_FIX, VALUE_VAR FROM COPPP_ITM
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2GUIDIdentification of Data Transfer/Postprocessing Listvarbinary160RAWNoRUN_ID
3VRGNGCO Business Transactionnvarchar40CHAR(N' ')No*CO_VORGANG Allow NULL? 
4KOKRSControlling Areanvarchar40CHAR(N' ')No*KOKRS Allow NULL? 
5BELNRDocument Numbernvarchar100CHAR(N' ')No*CO_BELNR Allow NULL? 
6ZEILEAccounting Document Line Item Numbernvarchar100NUMC(N'0000000000')NoPOSNR_ACC Allow NULL? 
7ZLENRAccounting Document Line Item Numbernvarchar100NUMC(N'0000000000')YesPOSNR_ACC Allow NULL? 
8SKOSTLSender Cost Centernvarchar100CHAR(N' ')Yes*SKOSTL Allow NULL? 
9SLSTARSender Activity Typenvarchar60CHAR(N' ')Yes*SLSTAR Allow NULL? 
10SAUFNRSender ordernvarchar120CHAR(N' ')Yes*SAUFNR Allow NULL? 
11SBEMOTSender Accounting Indicatornvarchar20CHAR(N' ')YesTBMOTSBEMOT Allow NULL? 
12SPRZNRSender Business Processnvarchar120CHAR(N' ')Yes*SPRZNR Allow NULL? 
13SPSPNRSender WBS elementnvarchar80NUMC(N'00000000')Yes*SPROJ Allow NULL? 
14SKDAUFSender sales ordernvarchar100CHAR(N' ')YesVBUKSKDAU Allow NULL? 
15SKDPOSItem number in sender sales ordernvarchar60NUMC(N'000000')Yes*SKDPO Allow NULL? 
16SKSTRGSender Cost Objectnvarchar120CHAR(N' ')Yes*SKSTRG Allow NULL? 
17SNPLNRSender networknvarchar120CHAR(N' ')Yes*SNPLN Allow NULL? 
18SVORGNSender operationnvarchar40CHAR(N' ')YesSVORG Allow NULL? 
19SRECINDSender Recovery Indicatornvarchar20CHAR(N' ')YesT8JJSRECID Allow NULL? 
20SPAOBJNumber for sender business segmentnvarchar100NUMC(N'0000000000')YesSPAOBJNR Allow NULL? 
21SGEBERSender fundnvarchar100CHAR(N' ')Yes*FM_SFONDS Allow NULL? 
22SFKBERSending Functional Areanvarchar160CHAR(N' ')Yes*SFKTBER Allow NULL? 
23SGRANT_NBRSender Grantnvarchar200CHAR(N' ')YesGM_GRANT_SENDER Allow NULL? 
24SBUDGET_PDFM: Sender Budget Periodnvarchar100CHAR(N' ')Yes*FM_SBUDGET_PERIOD Allow NULL? 
25KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
26STAGRStatistical key figurenvarchar60CHAR(N' ')Yes*STAGR Allow NULL? 
27MBGBTRTotal Quantitydecimal153QUAN((0))YesMEGXXX
28MEINBUnit of Measure for Displaynvarchar30UNIT(N' ')YesT006MEINH Allow NULL? 
29TARIFTotal Price per Unit of Measuredecimal112CURR((0))YesTGMXXX
30WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
31AUSBRTotal Output Quantitydecimal153QUAN((0))YesAMESU
32AUBEHOutput Unitnvarchar30UNIT(N' ')YesT006AUSEH Allow NULL? 
33PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
34SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
35WTGBTRTotal actual primary costsdecimal152CURR((0))YesIKPSU
36WTFBTRFixed value in transaction currency (not in DB)decimal152CURR((0))YesWTFXXX
37WKGBTRTotal Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
38WKFBTRFixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
39EKOSTLReceiver Cost Centernvarchar100CHAR(N' ')Yes*EKOSTL Allow NULL? 
40ELSTARReceiver activity typenvarchar60CHAR(N' ')Yes*E_LSTAR Allow NULL? 
41EAUFNRReceiver Ordernvarchar120CHAR(N' ')Yes*EAUFNR Allow NULL? 
42EBEMOTReceiver Accounting Indicatornvarchar20CHAR(N' ')YesTBMOTEBEMOT Allow NULL? 
43EPRZNRReceiver business processnvarchar120CHAR(N' ')Yes*EPRZNR Allow NULL? 
44EPSPNRReceiver WBS elementnvarchar80NUMC(N'00000000')Yes*EPROJ Allow NULL? 
45EKDAUFReceiver sales ordernvarchar100CHAR(N' ')Yes*EKDAU Allow NULL? 
46EKDPOSItem number in receiver sales ordernvarchar60NUMC(N'000000')Yes*EKDPO Allow NULL? 
47EKSTRGReceiver cost objectnvarchar120CHAR(N' ')Yes*EKSTR Allow NULL? 
48ENPLNRReceiver Networknvarchar120CHAR(N' ')Yes*ENPLN Allow NULL? 
49EVORGNReceiver operationnvarchar40CHAR(N' ')YesEVORG Allow NULL? 
50EPROCNRProduction Processnvarchar120NUMC(N'000000000000')Yes*CKML_F_PROCNR Allow NULL? 
51EMATNRReceiving Materialnvarchar180CHAR(N' ')Yes*CO_EMATNR Allow NULL? 
52EWERKSPlant for receiver materialnvarchar40CHAR(N' ')YesT001WCO_EWERKS Allow NULL? 
53ESAUFNReceiver Run Schedule Headernvarchar120CHAR(N' ')Yes*ESAUFNR Allow NULL? 
54EVERIDProduction version of receiver materialnvarchar40CHAR(N' ')YesMKALCO_EVERID Allow NULL? 
55EAUFHKOrigin Order for Product Cost Collectornvarchar120CHAR(N' ')Yes*EAUFHK Allow NULL? 
56ERECINDReceiver Recovery Indicatornvarchar20CHAR(N' ')YesT8JJERECID Allow NULL? 
57EPAOBJNumber of receiver profitability segmentnvarchar100NUMC(N'0000000000')YesEPAOBJNR Allow NULL? 
58EGEBERReceiver fundnvarchar100CHAR(N' ')Yes*FM_EFONDS Allow NULL? 
59EFKBERReceiving Functional Areanvarchar160CHAR(N' ')Yes*EFKTBER Allow NULL? 
60EGRANT_NBRReceiver Grantnvarchar200CHAR(N' ')YesGM_GRANT_RECEIVER Allow NULL? 
61EBUDGET_PDFM: Receiver Budget Periodnvarchar100CHAR(N' ')Yes*FM_EBUDGET_PERIOD Allow NULL? 
62SIMKEYSending real estate objectnvarchar80CHAR(N' ')YesSIMKEY Allow NULL? 
63SIMBUKRSCompany code of Real Estate objects to be sentnvarchar40CHAR(N' ')YesT001VVSBUKRS Allow NULL? 
64SIMSWENRSending business entity - Real Estatenvarchar80CHAR(N' ')Yes*SSWENR Allow NULL? 
65SIMSGRNRSending property - Real Estatenvarchar80CHAR(N' ')Yes*SSGRNR Allow NULL? 
66SIMSGENRSending building - Real Estatenvarchar80CHAR(N' ')Yes*SSGENR Allow NULL? 
67SIMSMENRSending rental unit - Real Estatenvarchar80CHAR(N' ')Yes*SSMENR Allow NULL? 
68SIMSMIVESending lease - Real Estatenvarchar130CHAR(N' ')YesSSMIVE Allow NULL? 
69SIMSVWNRManagement Contract Numbernvarchar130CHAR(N' ')Yes*VVSVWNR Allow NULL? 
70SIMSNKSLSending incidental expenses key - Real Estatenvarchar40CHAR(N' ')Yes*SSNKSL Allow NULL? 
71SIMSEMPSLSender settlement unit - Real Estatenvarchar50CHAR(N' ')Yes*SSEMPSL Allow NULL? 
72SIMDABRBEZSending reference date for acct settlement - Real Estatenvarchar80DATS(N'00000000')YesSDABRBEZ Allow NULL? 
73SIMRECNNRReal Estate Contract Numbernvarchar130CHAR(N' ')YesRECNNR Allow NULL? 
74EIMKEYRecipient real estate objectnvarchar80CHAR(N' ')YesEIMKEY Allow NULL? 
75EIMBUKRSCompany code of receiving Real Estate objectnvarchar40CHAR(N' ')YesT001EBUKRS Allow NULL? 
76EIMSWENRRecipient business entity - Real Estatenvarchar80CHAR(N' ')Yes*ESWENR Allow NULL? 
77EIMSGRNRRecipient property - Real Estatenvarchar80CHAR(N' ')Yes*ESGRNR Allow NULL? 
78EIMSGENRRecipient buildings- Real Estatenvarchar80CHAR(N' ')Yes*ESGENR Allow NULL? 
79EIMSMENRRecipient rental unit - Real Estatenvarchar80CHAR(N' ')Yes*ESMENR Allow NULL? 
80EIMSMIVERecipient Lease Out - Real Estatenvarchar130CHAR(N' ')YesESMIVE Allow NULL? 
81EIMSVWNRReceiving management contractnvarchar130CHAR(N' ')Yes*VVESVWNR Allow NULL? 
82EIMSNKSLRecipient incidental expenses key - Real Estatenvarchar40CHAR(N' ')Yes*ESNKSL Allow NULL? 
83EIMSEMPSLReal estate recipient settlement unitnvarchar50CHAR(N' ')Yes*ESEMPSL Allow NULL? 
84EIMDABRBEZRecipient reference date for acct sttlmnt - Real Est.nvarchar80DATS(N'00000000')YesEDABRBEZ Allow NULL? 
85EIMRECNNRReal Estate Contract Numbernvarchar130CHAR(N' ')YesRECNNR Allow NULL? 
86ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
87ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
88ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
89ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
90ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
91ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
92ZZNFALnvarchar100(N' ')Yes Allow NULL? 
93ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
94ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
95ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
96ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
97ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
98Z_PRS_OFFSHOREProfessional Services: Delivery Typechar10CHAR(N' ')YesZ_PRS_OFFSHORE Allow NULL? 
99Z_PRS_BILL_FLAGProfessional Services: Billable/Non-Billablechar10CHAR(N' ')YesZ_PRS_BILLABLE_FLAG Allow NULL? 
100Z_PRS_COUNTRYCountry Keynvarchar30CHAR(N' ')Yes*LAND1 Allow NULL? 
101Z_PRS_CHARGELEVLProfessional Services: Charge Levelnvarchar20CHAR(N' ')YesZ_PRS_CHARGELEVEL Allow NULL? 
102PRICE_TOTALTotal Price per Unit of Measure in CO Area Currencydecimal112CURR((0))YesTKGXXX
103PRICE_FIXFixed Price Per Unit of Measure in CO Area Currencydecimal112CURR((0))YesTKFXXX
104PRICE_VARVariable Price Per Unit of Measure in CO Area Currencydecimal112CURR((0))YesTKVXXX
105PRICE_TKEPrice Unit in Controlling Area Currencynvarchar50NUMC(N'00000')YesTKEXXX Allow NULL? 
106EX_CURRCurrency Keynvarchar50CUKY(N' ')Yes*OWAER Allow NULL? 
107VALUE_TOTALTotal Value in Controlling Area Currencydecimal152CURR((0))YesWKGXXX
108VALUE_FIXFixed Value in Controlling Area Currencydecimal152CURR((0))YesWKFXXX
109VALUE_VARVariable Value in Controlling Area Currencydecimal152CURR((0))YesWKVXXX
NamePrimaryUniqueTypeColumns
COPPP_ITM~0YesYesCLUSTEREDZEILE, BELNR, KOKRS, VRGNG, GUID, 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