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  | VSKBEZ_CN
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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Project System :: Simulation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VSKBEZ_CN881Version: Additional data for table KBED (ind. capacities)Simulation
SQL:  selectupdate insert create

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

SELECT MANDT, VSNMR, BEDID, BEDZL, CANUM, VGW01, VGE01, VGW02, VGE02, VGW03, VGE03, VGW04, VGE04, VGW05, VGE05, VGW06, VGE06, USR04, USE04, USR05, USE05, LEK01, LEK02, LEK03, LEK04, LEK05, LEK06, RSTZE, BEAZE, ARUZE, ARBEI, ARBEH, LEKNW, ASVRG, UMREN, UMREZ, BMSCH, LMNGA, XMNGA, ISMNW, ISM01, ISM02, ISM03, ISM04, ISM05, ISM06, ISERH, ZEIER, ISDD, ISDZ, IERD, IERZ, ISBD, ISBZ, IEBD, IEBZ, ISAD, ISAZ, IEDD, IEDZ, PEDD, PEDZ, OFM01, OFM02, OFM03, OFM04, OFM05, OFM06, OFMNW, PDAU, PDAE, DAUNO, DAUNE, RMNGA, ILE01, ILE02, ILE03, ILE04, ILE05, ILE06, PER_EX, DELTA_ST, DELTA_EN, GROUP_ID, GROUP_MEMBER, GROUP_COUNT, FIXED, NO_BREAKS FROM VSKBEZ_CN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VSNMRNumber or description of a versionnvarchar120CHAR(N' ')NoVSNMR Allow NULL? 
3BEDIDID of the capacity requirements recordnvarchar120NUMC(N'000000000000')NoVSKBKO_CNBEDID Allow NULL? 
4BEDZLInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
5CANUMCounters for cap. rqmts. records (various caps. + indiv.capsnvarchar40NUMC(N'0000')No*CY_COUNT Allow NULL? 
6VGW01Standard Valuedecimal93QUAN((0))YesVGWRT
7VGE01Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
8VGW02Standard Valuedecimal93QUAN((0))YesVGWRT
9VGE02Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
10VGW03Standard Valuedecimal93QUAN((0))YesVGWRT
11VGE03Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
12VGW04Standard Valuedecimal93QUAN((0))YesVGWRT
13VGE04Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
14VGW05Standard Valuedecimal93QUAN((0))YesVGWRT
15VGE05Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
16VGW06Standard Valuedecimal93QUAN((0))YesVGWRT
17VGE06Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
18USR04User field for quantity (length 10.3)decimal133QUAN((0))YesUSRQUAN13
19USE04User field: Unit for quantity fieldsnvarchar30UNIT(N' ')YesT006USRUNIT Allow NULL? 
20USR05User field for quantity (length 10.3)decimal133QUAN((0))YesUSRQUAN13
21USE05User field: Unit for quantity fieldsnvarchar30UNIT(N' ')YesT006USRUNIT Allow NULL? 
22LEK01Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
23LEK02Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
24LEK03Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
25LEK04Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
26LEK05Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
27LEK06Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
28RSTZEUnit of measure for setup timenvarchar30UNIT(N' ')YesRSTZE Allow NULL? 
29BEAZEUnit of measure for processing timenvarchar30UNIT(N' ')YesBEAZE Allow NULL? 
30ARUZEUnit of measure for teardownnvarchar30UNIT(N' ')YesARUZE Allow NULL? 
31ARBEIWork involved in the activitydecimal71QUAN((0))YesARBEIT
32ARBEHUnit for worknvarchar30UNIT(N' ')YesT006ARBEITE Allow NULL? 
33LEKNWIndicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
34ASVRGOperation scrapdecimal133QUAN((0))YesASVRG
35UMRENDenominator for converting rtg and op units of measuredecimal50DEC((0))YesCP_UMREN
36UMREZNumerator for converting task list and oper. un. of measuredecimal50DEC((0))YesCP_UMREZ
37BMSCHBase Quantitydecimal133QUAN((0))YesBMSCH
38LMNGATotal Yield Confirmeddecimal133QUAN((0))YesLMNGA
39XMNGATotal scrap quantity confirmeddecimal133QUAN((0))YesXMNGA
40ISMNWActual workdecimal133QUAN((0))YesCO_ISMNW
41ISM01Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
42ISM02Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
43ISM03Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
44ISM04Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
45ISM05Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
46ISM06Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
47ISERHConfirmed break timedecimal93QUAN((0))YesISERH
48ZEIERUnit for the break timenvarchar30UNIT(N' ')YesT006DZEIER Allow NULL? 
49ISDDActual start: Execution (date)nvarchar80DATS(N'00000000')YesISDD Allow NULL? 
50ISDZActual start: Execution/setup (time)nvarchar60TIMS(N'000000')YesISDZ Allow NULL? 
51IERDActual finish: Setup (date)nvarchar80DATS(N'00000000')YesIERD Allow NULL? 
52IERZActual finish: Setup (time)nvarchar60TIMS(N'000000')YesIERZ Allow NULL? 
53ISBDActual start: Processing (date)nvarchar80DATS(N'00000000')YesISBD Allow NULL? 
54ISBZActual start: Processing (time)nvarchar60TIMS(N'000000')YesISBZ Allow NULL? 
55IEBDActual finish: Processing (date)nvarchar80DATS(N'00000000')YesIEBD Allow NULL? 
56IEBZActual processing finish (time)nvarchar60TIMS(N'000000')YesIEBZ Allow NULL? 
57ISADActual start: Teardown (date)nvarchar80DATS(N'00000000')YesISAD Allow NULL? 
58ISAZActual start: Teardown (time)nvarchar60TIMS(N'000000')YesISAZ Allow NULL? 
59IEDDActual finish: Execution (date)nvarchar80DATS(N'00000000')YesIEDD Allow NULL? 
60IEDZActual finish: Execution (time)nvarchar60TIMS(N'000000')YesIEDZ Allow NULL? 
61PEDDForecast finish date of operation from confirmationnvarchar80DATS(N'00000000')YesCO_PEDD Allow NULL? 
62PEDZForecast finish time of operation from confirmationnvarchar60TIMS(N'000000')YesCO_PEDZ Allow NULL? 
63OFM01Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
64OFM02Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
65OFM03Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
66OFM04Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
67OFM05Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
68OFM06Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
69OFMNWForecasted work (actual + remaining)decimal71QUAN((0))YesOFMNW
70PDAUForecasted duration of activity from confirmationdecimal51QUAN((0))YesPDAU
71PDAEUnit of the forecasted duration from the confirmationnvarchar30UNIT(N' ')YesT006PDAE Allow NULL? 
72DAUNONormal duration of the activitydecimal51QUAN((0))YesDAUNOR
73DAUNENormal duration/unitnvarchar30UNIT(N' ')YesT006DAUNORE Allow NULL? 
74RMNGATotal confirmed rework quantitydecimal133QUAN((0))YesRMNGA
75ILE01Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
76ILE02Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
77ILE03Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
78ILE04Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
79ILE05Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
80ILE06Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
81PER_EXEntry in KPER exists for this splitchar10CHAR(N' ')YesCY_PEREX Allow NULL? 
82DELTA_STTime Difference Between Start Capacity and Individ. Capacitydecimal133QUAN((0))YesCY_DELTAST
83DELTA_ENTime Difference Between Fin. Capacity and Individ. Capacitydecimal133QUAN((0))YesCY_DELTAEN
84GROUP_IDGroup ID (GUID) for Grouped Capacity Requirementsvarbinary160RAWYesCOSFD_GROUP_ID
85GROUP_MEMBERMember Inside a Capacity Requirements Grouptinyint30INT1((0))YesCOSFD_GROUP_MEMBER
86GROUP_COUNTNumber of Members Inside a Capacity Requirements Grouptinyint30INT1((0))YesCOSFD_GROUP_COUNT
87FIXEDIndicator: Dispatching of Capacity Requirement Is Fixedchar10CHAR(N' ')YesCOSFD_FIXED Allow NULL? 
88NO_BREAKSDispatched in Non-Working Timeschar10CHAR(N' ')YesCOSFD_NO_BREAKS Allow NULL? 
NamePrimaryUniqueTypeColumns
VSKBEZ_CN~0YesYesCLUSTEREDMANDT, VSNMR, BEDID, BEDZL, CANUM

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