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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Cross-Application Components :: General Application Functions :: Workforce Management Application
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WFA_WRKA_HIST311Work Area AttributesWorkforce Management Application
SQL:  selectupdate insert create

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

SELECT MANDT, WRKAREA_ID, START_DATE, END_DATE, TEMP_FLAG, EXCL_VARSHIFT, EXCL_PAYROLL, EXCL_COVERAGE, EXCL_AHRCALC, EXCL_HOURS, DRIVER_IND_ID, DRIVER_ADJ_METH, DEPT_TAG, WORK_AREA_ORDER, IMPORTANCE, CREATED_BY, CREATED_AT, CHANGED_BY, CHANGED_AT, ORG_PLVAR, ORG_OTYPE, ORG_OBJID, WRKA_HIST_GUID, WRKAREA_TMAP_ID, STAT_ID, FORM, DUR_SETUP, DUR_UNIT, DUR_CLOSEOUT, MAXPEOPLE, FIXED_INCL_IN_STAFF FROM WFA_WRKA_HIST
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2WRKAREA_IDWork Area Idnvarchar320 Allow NULL? 
3START_DATEStart Datenvarchar80 Allow NULL? 
4END_DATEEnd Datenvarchar80 Allow NULL? 
5TEMP_FLAGTemporary Flagchar10 Allow NULL? 
6EXCL_VARSHIFTExclude - No variable Shiftchar10 Allow NULL? 
7EXCL_PAYROLLEclude fixed from payroll costchar10 Allow NULL? 
8EXCL_COVERAGEExclude fixed from coverage countschar10 Allow NULL? 
9EXCL_AHRCALCExclude shifts from AHR calculationchar10 Allow NULL? 
10EXCL_HOURSExclude fixed hours from Schedule and Workloadchar10 Allow NULL? 
11DRIVER_IND_IDIndicator Idnvarchar320 Allow NULL? 
12DRIVER_ADJ_METHAdjustment Constraint Typenvarchar20 Allow NULL? 
13DEPT_TAGDepartment Tag Indexnvarchar40 Allow NULL? 
14WORK_AREA_ORDERWork Area Orderint100 Allow NULL? 
15IMPORTANCEImportance Costdecimal104
16CREATED_BYCreated Bynvarchar120 Allow NULL? 
17CREATED_ATCreated Atdecimal150
18CHANGED_BYLast Changed Bynvarchar120 Allow NULL? 
19CHANGED_ATLast Changed Atdecimal150
20ORG_PLVARPlan Versionnvarchar20 Allow NULL? 
21ORG_OTYPEObject Typenvarchar20 Allow NULL? 
22ORG_OBJIDObject IDnvarchar80 Allow NULL? 
23WRKA_HIST_GUIDIDnvarchar320 Allow NULL? 
24WRKAREA_TMAP_IDTime Map IDnvarchar320 Allow NULL? 
25STAT_IDStat Idnvarchar320 Allow NULL? 
26FORMStat Formnvarchar20 Allow NULL? 
27DUR_SETUPDuration Setupdecimal133
28DUR_UNITDuration Unit of Measurenvarchar30 Allow NULL? 
29DUR_CLOSEOUTDuration Closeoutdecimal133
30MAXPEOPLEMax Peopleint100 Allow NULL? 
31FIXED_INCL_IN_STAFFInclude Fixed Shifts and Set Shifts in Core Staffingchar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
WFA_WRKA_HIST~0YesYesCLUSTEREDMANDT, WRKAREA_ID, START_DATE