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

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
Production Planning and Control :: Information System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MCSFIS1481R/2 SFIS Data: OldInformation System
SQL:  selectupdate insert create

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

SELECT MANDT, SSOUR, AUFNR, AUFPL, RSNUM, WERKSM, MATNRM, KSTAR, KOSTL, LSTAR, WERKSK, MATNRK, ARBIDK, AUART, AUTYP, ERDAT, AEDAT, OBJNR, BUKRS, WERKS, PLGRP, DISPO, FEVOR, GLTRP, GSTRP, FTRMS, GLTRS, GSTRS, GSTRI, GETRI, GLTRI, FTRMI, FTRMP, GASMG, GAMNG, GMEIN, VERID, KUNUM, POSNR, MATNR, PWERK, ETRMP, STRMP, LTRMP, LTRMI, PAMNG, PGMNG, MEINS, PSAMG, PSMNG, WEMNG, IAMNG, AMEIN, UMREZ, UMREN, DFZEH, S_DFZ, I_DFZ, KEINH, KSUMS, PLNUM, KDAUF, KDPOS, LGORT, SERNR, CHARG, GSBER, ZEITP, APLZL, ZAEHL, PLNFL, VORNR, ARBID, KAPAR, KAPID, ARBPL, STEUS, OBJNRV, MEINH, UMRENV, UMREZV, BMSCH, VERTL, KALID, MGVRG, ASVRG, LMNGA, XMNGA, GMNGA, SSADD, IADD, FSAVD, SSAVD, ISDD, ISAVD, FSEDD, SSEDD, IEDD, IEAVD, N_IEAVD, WARTZ, WRTZE, RUEST, RSTZE, BEARZ, BEAZE, ABRUE, ARUZE, LIEGZ, V_LIEGZ, LIGZE, TRANZ, KRUES, KBEAS, KABRS, KEINHV, TRAZE, DFZEHV, S_DFZV, I_DFZV, KAPKZ, A, VDATU, DUMMY, ZEITPV, LGORTM, CHARGM, BDMNG, ENMNG, ENWRT, MEINSM, WAERS, SOBKZ, SHKZG, BWART, GSBERM, TYPPS, PSKNZ, BWTAR, PREIS, WERTN, WRTFX, WRTVR, WAERSK, PPREIS, PWERTN, PWRTFX, PWRTVR FROM MCSFIS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SSOURStatistic(s) originnvarchar40CHAR(N' ')NoSSOUR Allow NULL? 
3AUFNROrder Numbernvarchar120CHAR(N' ')No*AUFNR Allow NULL? 
4AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')NoCO_AUFPL Allow NULL? 
5RSNUMNumber of Reservation/Dependent Requirementnvarchar100NUMC(N'0000000000')No*RSNUM Allow NULL? 
6WERKSMPlantnvarchar40CHAR(N' ')No*WERKS_D Allow NULL? 
7MATNRMMaterial Numbernvarchar180CHAR(N' ')No*MATNR Allow NULL? 
8KSTARCost Elementnvarchar100CHAR(N' ')No*KSTAR Allow NULL? 
9KOSTLCost Centernvarchar100CHAR(N' ')No*KOSTL Allow NULL? 
10LSTARActivity Typenvarchar60CHAR(N' ')No*LSTAR Allow NULL? 
11WERKSKPlantnvarchar40CHAR(N' ')No*WERKS_D Allow NULL? 
12MATNRKMaterial Numbernvarchar180CHAR(N' ')No*MATNR Allow NULL? 
13ARBIDKObject ID of the resourcenvarchar80NUMC(N'00000000')No*CR_OBJID Allow NULL? 
14AUARTOrder Typenvarchar40CHAR(N' ')Yes*AUFART Allow NULL? 
15AUTYPOrder categorynvarchar20NUMC(N'00')YesAUFTYP Allow NULL? 
16ERDATCreated onnvarchar80DATS(N'00000000')YesAUFERFDAT Allow NULL? 
17AEDATChange date for Order Masternvarchar80DATS(N'00000000')YesAUFAEDAT Allow NULL? 
18OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
19BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
20WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
21PLGRPResponsible planner group/departmentnvarchar30CHAR(N' ')Yes*VAGRP Allow NULL? 
22DISPOMRP controller for the ordernvarchar30CHAR(N' ')Yes*CO_DISPO Allow NULL? 
23FEVORResponsible planner group/departmentnvarchar30CHAR(N' ')Yes*VAGRP Allow NULL? 
24GLTRPBasic finish datenvarchar80DATS(N'00000000')YesCO_GLTRP Allow NULL? 
25GSTRPBasic start datenvarchar80DATS(N'00000000')YesCO_GSTRP Allow NULL? 
26FTRMSScheduled release datenvarchar80DATS(N'00000000')YesCO_FTRMS Allow NULL? 
27GLTRSScheduled finishnvarchar80DATS(N'00000000')YesCO_GLTRS Allow NULL? 
28GSTRSScheduled startnvarchar80DATS(N'00000000')YesCO_GSTRS Allow NULL? 
29GSTRIActual start datenvarchar80DATS(N'00000000')YesCO_GSTRI Allow NULL? 
30GETRIConfirmed Order Finish Datenvarchar80DATS(N'00000000')YesCO_GETRI Allow NULL? 
31GLTRIActual finish datenvarchar80DATS(N'00000000')YesCO_GLTRI Allow NULL? 
32FTRMIActual release datenvarchar80DATS(N'00000000')YesCO_FTRMI Allow NULL? 
33FTRMPPlanned release datenvarchar80DATS(N'00000000')YesCO_FTRMP Allow NULL? 
34GASMGTotal scrap quantity in the orderdecimal133QUAN((0))YesGASMG
35GAMNGTotal order quantitydecimal133QUAN((0))YesGAMNG
36GMEINBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
37VERIDProduction Versionnvarchar40CHAR(N' ')Yes*VERID Allow NULL? 
38KUNUMCustomer Numbernvarchar100CHAR(N' ')Yes*KUNUM Allow NULL? 
39POSNROrder Item Numbernvarchar40NUMC(N'0000')YesCO_POSNR Allow NULL? 
40MATNRMaterial Number for Ordernvarchar180CHAR(N' ')Yes*CO_MATNR Allow NULL? 
41PWERKPlanning plant for the ordernvarchar40CHAR(N' ')Yes*CO_PWERK Allow NULL? 
42ETRMPOpening date of the planned ordernvarchar80DATS(N'00000000')YesCO_ETRMP Allow NULL? 
43STRMPStart date of the planned ordernvarchar80DATS(N'00000000')YesCO_STRMP Allow NULL? 
44LTRMPDelivery date from planned ordernvarchar80DATS(N'00000000')YesCO_LTRMP Allow NULL? 
45LTRMIActual delivery/finish datenvarchar80DATS(N'00000000')YesCO_LTRMI Allow NULL? 
46PAMNGFixed quantity of scrap from productiondecimal133QUAN((0))YesAVMNG
47PGMNGTotal planned order quantitydecimal133QUAN((0))YesGSMNG
48MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*LAGME Allow NULL? 
49PSAMGScrap quantity in itemdecimal133QUAN((0))YesCO_PSAMG
50PSMNGOrder item quantitydecimal133QUAN((0))YesCO_PSMNG
51WEMNGQuantity of goods received for the order itemdecimal133QUAN((0))YesCO_WEMNG
52IAMNGExpected surplus/deficit for goods receiptdecimal133QUAN((0))YesCO_IAMNG
53AMEINUnit of measure for in-house productionnvarchar30UNIT(N' ')Yes*CO_AUFME Allow NULL? 
54UMREZNumerator for Conversion to Base Units of Measuredecimal50DEC((0))YesUMREZ
55UMRENDenominator for conversion to base units of measuredecimal50DEC((0))YesUMREN
56DFZEHUnit of measure for execution timenvarchar30UNIT(N' ')YesDFZEH Allow NULL? 
57S_DFZTarget execution timedecimal71QUAN((0))YesS_DFZ
58I_DFZActual execution timedecimal71QUAN((0))YesI_DFZ
59KEINHUnit of of measure for displaying capacity requirementsnvarchar30UNIT(N' ')Yes*CY_KEINH Allow NULL? 
60KSUMSTotal target capacity requirementsdecimal71QUAN((0))YesMC_KSUMS
61PLNUMPlanned order numbernvarchar100CHAR(N' ')Yes*PLNUM Allow NULL? 
62KDAUFSales order numbernvarchar100CHAR(N' ')Yes*CO_KDAUF Allow NULL? 
63KDPOSSales order itemnvarchar60NUMC(N'000000')Yes*CO_KDPOS Allow NULL? 
64LGORTStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
65SERNRBOM explosion numbernvarchar80CHAR(N' ')Yes*SERNR Allow NULL? 
66CHARGBatch Numbernvarchar100CHAR(N' ')Yes*CHARG_D Allow NULL? 
67GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
68ZEITPEvent for which updating should take placenvarchar20CHAR(N' ')Yes*DZEITP Allow NULL? 
69APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
70ZAEHLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
71PLNFLSequencenvarchar60CHAR(N' ')YesPLNFOLGE Allow NULL? 
72VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
73ARBIDObject IDnvarchar80NUMC(N'00000000')YesOBJEKTID Allow NULL? 
74KAPARCapacity categorynvarchar30CHAR(N' ')Yes*KAPART Allow NULL? 
75KAPIDCapacity IDnvarchar80NUMC(N'00000000')Yes*KAPID Allow NULL? 
76ARBPLWork centernvarchar80CHAR(N' ')YesARBPL Allow NULL? 
77STEUSControl keynvarchar40CHAR(N' ')Yes*STEUS Allow NULL? 
78OBJNRVObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
79MEINHUnit of Measure for Activity/Operationnvarchar30UNIT(N' ')Yes*VORME Allow NULL? 
80UMRENVDenominator for conversion to base units of measuredecimal50DEC((0))YesUMREN
81UMREZVNumerator for Conversion to Base Units of Measuredecimal50DEC((0))YesUMREZ
82BMSCHBase Quantitydecimal133QUAN((0))YesBMSCH
83VERTLDistribution function for capacity requirementsnvarchar20CHAR(N' ')Yes*VERTEILUNG Allow NULL? 
84KALIDFactory Calendarnvarchar20CHAR(N' ')Yes*WFCID Allow NULL? 
85MGVRGOperation Quantitydecimal133QUAN((0))YesMGVRG
86ASVRGOperation scrapdecimal133QUAN((0))YesASVRG
87LMNGATotal Yield Confirmeddecimal133QUAN((0))YesLMNGA
88XMNGATotal scrap quantity confirmeddecimal133QUAN((0))YesXMNGA
89GMNGAConfirmed yield in order unit of measuredecimal133QUAN((0))YesGMNGA
90SSADDLatest target input datenvarchar80DATS(N'00000000')YesSSADD Allow NULL? 
91IADDActual input datenvarchar80DATS(N'00000000')YesIADD Allow NULL? 
92FSAVDEarliest scheduled start: Execution (date)nvarchar80DATS(N'00000000')YesFSAVD Allow NULL? 
93SSAVDLatest scheduled start: Execution (date)nvarchar80DATS(N'00000000')YesSSAVD Allow NULL? 
94ISDDActual start: Execution (date)nvarchar80DATS(N'00000000')YesISDD Allow NULL? 
95ISAVDActual operation start (date)nvarchar80DATS(N'00000000')YesISAVD Allow NULL? 
96FSEDDEarliest scheduled finish: Execution (date)nvarchar80DATS(N'00000000')YesFSEDD Allow NULL? 
97SSEDDLatest scheduled finish: Execution (date)nvarchar80DATS(N'00000000')YesSSEDD Allow NULL? 
98IEDDActual finish: Execution (date)nvarchar80DATS(N'00000000')YesIEDD Allow NULL? 
99IEAVDActual finish of operation (date)nvarchar80DATS(N'00000000')YesIEAVD Allow NULL? 
100N_IEAVDActual finish of operation (date)nvarchar80DATS(N'00000000')YesIEAVD Allow NULL? 
101WARTZQueue time used for schedulingdecimal93QUAN((0))YesMCWARTZ
102WRTZEUnit of measure for queue timenvarchar30UNIT(N' ')YesWTRZE Allow NULL? 
103RUESTSetup timedecimal93QUAN((0))YesMCRUEST
104RSTZEUnit of measure for setup timenvarchar30UNIT(N' ')YesRSTZE Allow NULL? 
105BEARZProcessing timedecimal93QUAN((0))YesMCBEARZ
106BEAZEUnit of measure for processing timenvarchar30UNIT(N' ')YesBEAZE Allow NULL? 
107ABRUETeardowndecimal93QUAN((0))YesMCABRUE
108ARUZEUnit of measure for teardownnvarchar30UNIT(N' ')YesARUZE Allow NULL? 
109LIEGZWait time used for schedulingdecimal93QUAN((0))YesMCLIEGEZ
110V_LIEGZWait time used for schedulingdecimal93QUAN((0))YesMCLIEGEZ
111LIGZEUnit of measure for wait timenvarchar30UNIT(N' ')YesLIGZE Allow NULL? 
112TRANZMove time used for schedulingdecimal93QUAN((0))YesMCTRANZ
113KRUESScheduled cap. requirements for the op. segment "setup"decimal93QUAN((0))YesMCKRUES
114KBEASScheduled cap. requirements for the op. segment "processing"decimal93QUAN((0))YesMCKBEAS
115KABRSScheduled cap. requirements for the op. segment teardowndecimal93QUAN((0))YesMCKABRS
116KEINHVUnit of of measure for displaying capacity requirementsnvarchar30UNIT(N' ')Yes*CY_KEINH Allow NULL? 
117TRAZEUnit of measure for move timenvarchar30UNIT(N' ')YesTRAZE Allow NULL? 
118DFZEHVUnit of measure for execution timenvarchar30UNIT(N' ')YesDFZEH Allow NULL? 
119S_DFZVTarget execution timedecimal71QUAN((0))YesS_DFZ
120I_DFZVActual execution timedecimal71QUAN((0))YesI_DFZ
121KAPKZSFIS indicator for cumulative updating of capacity datachar10CHAR(N' ')YesKAPKZ Allow NULL? 
122ADummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
123VDATUDate of update for statistics updatingnvarchar80DATS(N'00000000')YesMC_VDATUM Allow NULL? 
124DUMMYDummy function in length 1char10CHAR(N' ')YesDUMMY Allow NULL? 
125ZEITPVEvent for which updating should take placenvarchar20CHAR(N' ')Yes*DZEITP Allow NULL? 
126LGORTMStorage Locationnvarchar40CHAR(N' ')Yes*LGORT_D Allow NULL? 
127CHARGMBatch Numbernvarchar100CHAR(N' ')Yes*CHARG_D Allow NULL? 
128BDMNGRequirement Quantitydecimal153QUAN((0))YesMC_BDMNG
129ENMNGQuantity withdrawndecimal153QUAN((0))YesMC_ENMNG
130ENWRTIssued Valuedecimal192CURR((0))YesMC_ENWRT
131MEINSMBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
132WAERSCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
133SOBKZSpecial Stock Indicatorchar10CHAR(N' ')Yes*SOBKZ Allow NULL? 
134SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
135BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')Yes*BWART Allow NULL? 
136GSBERMBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
137TYPPSItem Categorychar10CHAR(N' ')YesTYPPS Allow NULL? 
138PSKNZFixed/Variable Indicatorchar10CHAR(N' ')YesFVFLG Allow NULL? 
139BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
140PREISTotal Price in Local Currencydecimal152CURR((0))YesPPGXXX
141WERTNValue (total) in controlling area currencydecimal192CURR((0))YesMC_WERTN
142WRTFXFixed Value in Controlling Area Currencydecimal192CURR((0))YesMC_WRTFX
143WRTVRVariable Value in Controlling Area Currencydecimal192CURR((0))YesMC_WRTVR
144WAERSKCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
145PPREISPlanned price (total) in local currencydecimal152CURR((0))YesMC_PGPREIS
146PWERTNPlanned value (total) in controlling area currencydecimal192CURR((0))YesMC_PWERTN
147PWRTFXPlanned value (fixed) in controlling area currencydecimal192CURR((0))YesMC_PWRTFX
148PWRTVRPlanned value (variable) in controlling area currencydecimal192CURR((0))YesMC_PWRTVR
NamePrimaryUniqueTypeColumns
MCSFIS~0YesYesCLUSTEREDARBIDK, MATNRK, WERKSK, LSTAR, KOSTL, KSTAR, MATNRM, WERKSM, RSNUM, AUFPL, AUFNR, SSOUR, MANDT