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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Production Planning and Control :: Capacity Requirements Planning :: Scheduling
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0KBEZ871Add. data for table KBED (for indiv. capacities/splits)Scheduling
SQL:  selectupdate insert create

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

SELECT MANDT, 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 KBEZ
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BEDIDID of the capacity requirements recordnvarchar120NUMC(N'000000000000')NoKBKOBEDID Allow NULL? 
3BEDZLInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
4CANUMCounters for cap. rqmts. records (various caps. + indiv.capsnvarchar40NUMC(N'0000')NoKBEDCY_COUNT Allow NULL? 
5VGW01Standard Valuedecimal93QUAN((0))YesVGWRT
6VGE01Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
7VGW02Standard Valuedecimal93QUAN((0))YesVGWRT
8VGE02Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
9VGW03Standard Valuedecimal93QUAN((0))YesVGWRT
10VGE03Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
11VGW04Standard Valuedecimal93QUAN((0))YesVGWRT
12VGE04Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
13VGW05Standard Valuedecimal93QUAN((0))YesVGWRT
14VGE05Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
15VGW06Standard Valuedecimal93QUAN((0))YesVGWRT
16VGE06Unit of measure for the standard valuenvarchar30UNIT(N' ')YesT006VGWRTEH Allow NULL? 
17USR04User field for quantity (length 10.3)decimal133QUAN((0))YesUSRQUAN13
18USE04User field: Unit for quantity fieldsnvarchar30UNIT(N' ')YesT006USRUNIT Allow NULL? 
19USR05User field for quantity (length 10.3)decimal133QUAN((0))YesUSRQUAN13
20USE05User field: Unit for quantity fieldsnvarchar30UNIT(N' ')YesT006USRUNIT Allow NULL? 
21LEK01Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
22LEK02Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
23LEK03Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
24LEK04Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
25LEK05Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
26LEK06Indicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
27RSTZEUnit of measure for setup timenvarchar30UNIT(N' ')YesRSTZE Allow NULL? 
28BEAZEUnit of measure for processing timenvarchar30UNIT(N' ')YesBEAZE Allow NULL? 
29ARUZEUnit of measure for teardownnvarchar30UNIT(N' ')YesARUZE Allow NULL? 
30ARBEIWork involved in the activitydecimal71QUAN((0))YesARBEIT
31ARBEHUnit for worknvarchar30UNIT(N' ')YesT006ARBEITE Allow NULL? 
32LEKNWIndicator: No remaining activity expectedchar10CHAR(N' ')YesCO_LEIKZ Allow NULL? 
33ASVRGOperation scrapdecimal133QUAN((0))YesASVRG
34UMRENDenominator for converting rtg and op units of measuredecimal50DEC((0))YesCP_UMREN
35UMREZNumerator for converting task list and oper. un. of measuredecimal50DEC((0))YesCP_UMREZ
36BMSCHBase Quantitydecimal133QUAN((0))YesBMSCH
37LMNGATotal Yield Confirmeddecimal133QUAN((0))YesLMNGA
38XMNGATotal scrap quantity confirmeddecimal133QUAN((0))YesXMNGA
39ISMNWActual workdecimal133QUAN((0))YesCO_ISMNW
40ISM01Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
41ISM02Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
42ISM03Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
43ISM04Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
44ISM05Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
45ISM06Previously confirmed activitydecimal133QUAN((0))YesCO_RUMNG
46ISERHConfirmed break timedecimal93QUAN((0))YesISERH
47ZEIERUnit for the break timenvarchar30UNIT(N' ')YesT006DZEIER Allow NULL? 
48ISDDActual start: Execution (date)nvarchar80DATS(N'00000000')YesISDD Allow NULL? 
49ISDZActual start: Execution/setup (time)nvarchar60TIMS(N'000000')YesISDZ Allow NULL? 
50IERDActual finish: Setup (date)nvarchar80DATS(N'00000000')YesIERD Allow NULL? 
51IERZActual finish: Setup (time)nvarchar60TIMS(N'000000')YesIERZ Allow NULL? 
52ISBDActual start: Processing (date)nvarchar80DATS(N'00000000')YesISBD Allow NULL? 
53ISBZActual start: Processing (time)nvarchar60TIMS(N'000000')YesISBZ Allow NULL? 
54IEBDActual finish: Processing (date)nvarchar80DATS(N'00000000')YesIEBD Allow NULL? 
55IEBZActual processing finish (time)nvarchar60TIMS(N'000000')YesIEBZ Allow NULL? 
56ISADActual start: Teardown (date)nvarchar80DATS(N'00000000')YesISAD Allow NULL? 
57ISAZActual start: Teardown (time)nvarchar60TIMS(N'000000')YesISAZ Allow NULL? 
58IEDDActual finish: Execution (date)nvarchar80DATS(N'00000000')YesIEDD Allow NULL? 
59IEDZActual finish: Execution (time)nvarchar60TIMS(N'000000')YesIEDZ Allow NULL? 
60PEDDForecast finish date of operation from confirmationnvarchar80DATS(N'00000000')YesCO_PEDD Allow NULL? 
61PEDZForecast finish time of operation from confirmationnvarchar60TIMS(N'000000')YesCO_PEDZ Allow NULL? 
62OFM01Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
63OFM02Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
64OFM03Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
65OFM04Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
66OFM05Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
67OFM06Forecast value used to update the standard valuedecimal93QUAN((0))YesCO_SCHAETZ
68OFMNWForecasted work (actual + remaining)decimal71QUAN((0))YesOFMNW
69PDAUForecasted duration of activity from confirmationdecimal51QUAN((0))YesPDAU
70PDAEUnit of the forecasted duration from the confirmationnvarchar30UNIT(N' ')YesT006PDAE Allow NULL? 
71DAUNONormal duration of the activitydecimal51QUAN((0))YesDAUNOR
72DAUNENormal duration/unitnvarchar30UNIT(N' ')YesT006DAUNORE Allow NULL? 
73RMNGATotal confirmed rework quantitydecimal133QUAN((0))YesRMNGA
74ILE01Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
75ILE02Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
76ILE03Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
77ILE04Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
78ILE05Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
79ILE06Unit of measure for the activity to be confirmednvarchar30UNIT(N' ')YesT006CO_ISMNGEH Allow NULL? 
80PER_EXEntry in KPER exists for this splitchar10CHAR(N' ')YesCY_PEREX Allow NULL? 
81DELTA_STTime Difference Between Start Capacity and Individ. Capacitydecimal133QUAN((0))YesCY_DELTAST
82DELTA_ENTime Difference Between Fin. Capacity and Individ. Capacitydecimal133QUAN((0))YesCY_DELTAEN
83GROUP_IDGroup ID (GUID) for Grouped Capacity Requirementsvarbinary160RAWYesCOSFD_GROUP_ID
84GROUP_MEMBERMember Inside a Capacity Requirements Grouptinyint30INT1((0))YesCOSFD_GROUP_MEMBER
85GROUP_COUNTNumber of Members Inside a Capacity Requirements Grouptinyint30INT1((0))YesCOSFD_GROUP_COUNT
86FIXEDIndicator: Dispatching of Capacity Requirement Is Fixedchar10CHAR(N' ')YesCOSFD_FIXED Allow NULL? 
87NO_BREAKSDispatched in Non-Working Timeschar10CHAR(N' ')YesCOSFD_NO_BREAKS Allow NULL? 
NamePrimaryUniqueTypeColumns
KBEZ~0YesYesCLUSTEREDCANUM, BEDZL, BEDID, 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