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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Cross-Application Components :: General Application Functions :: Workforce Management Application
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WFAFC_WKLD_ADJ461Summarized Workload Forecasted and Adjusted ValuesWorkforce Management Application
SQL:  selectupdate insert create

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

SELECT MANDT, ORG_PLVAR, ORG_OTYPE, ORG_OBJID, DEPT_INDEX, WRKAREA_CODE, START_DATE, END_DATE, FCST_FIX_WKLD1, FCST_FIX_WKLD2, FCST_FIX_WKLD3, FCST_FIX_WKLD4, FCST_FIX_WKLD5, FCST_FIX_WKLD6, FCST_FIX_WKLD7, FCST_FIX_WKLDW, FCST_VAR_WKLD1, FCST_VAR_WKLD2, FCST_VAR_WKLD3, FCST_VAR_WKLD4, FCST_VAR_WKLD5, FCST_VAR_WKLD6, FCST_VAR_WKLD7, FCST_VAR_WKLDW, ADJ_VAR_WKLD1, ADJ_VAR_WKLD2, ADJ_VAR_WKLD3, ADJ_VAR_WKLD4, ADJ_VAR_WKLD5, ADJ_VAR_WKLD6, ADJ_VAR_WKLD7, ADJ_VAR_WKLDW, NETUNITS_1, NETUNITS_2, NETUNITS_3, NETUNITS_4, NETUNITS_5, NETUNITS_6, NETUNITS_7, NETUNITS_W, TOTAL_UNITS, TOTAL_HOURS, CREATED_BY, CREATED_AT, CHANGED_BY, CHANGED_AT FROM WFAFC_WKLD_ADJ
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ORG_PLVARPlan Versionnvarchar20CHAR(N' ')No*PLVAR Allow NULL? 
3ORG_OTYPEObject Typenvarchar20CHAR(N' ')No*OTYPE Allow NULL? 
4ORG_OBJIDObject IDnvarchar80NUMC(N'00000000')No*HROBJID Allow NULL? 
5DEPT_INDEXDepartment Tag Indexnvarchar40NUMC(N'0000')No*WFA_DEPT_INDEX Allow NULL? 
6WRKAREA_CODEWork Area Codenvarchar200CHAR(N' ')NoWFA_WRKAREA_CODE Allow NULL? 
7START_DATEStart Datenvarchar80DATS(N'00000000')NoWFA_START_DATE Allow NULL? 
8END_DATEEnd Datenvarchar80DATS(N'00000000')YesWFA_END_DATE Allow NULL? 
9FCST_FIX_WKLD1Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
10FCST_FIX_WKLD2Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
11FCST_FIX_WKLD3Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
12FCST_FIX_WKLD4Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
13FCST_FIX_WKLD5Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
14FCST_FIX_WKLD6Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
15FCST_FIX_WKLD7Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
16FCST_FIX_WKLDWForecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
17FCST_VAR_WKLD1Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
18FCST_VAR_WKLD2Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
19FCST_VAR_WKLD3Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
20FCST_VAR_WKLD4Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
21FCST_VAR_WKLD5Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
22FCST_VAR_WKLD6Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
23FCST_VAR_WKLD7Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
24FCST_VAR_WKLDWForecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
25ADJ_VAR_WKLD1Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
26ADJ_VAR_WKLD2Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
27ADJ_VAR_WKLD3Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
28ADJ_VAR_WKLD4Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
29ADJ_VAR_WKLD5Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
30ADJ_VAR_WKLD6Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
31ADJ_VAR_WKLD7Forecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
32ADJ_VAR_WKLDWForecast Workload Valuedecimal1610DEC((0))YesWFAFC_FORECASTED_VALUE
33NETUNITS_1Valuefloat1516FLTP((0))YesWFAFC_VALUE
34NETUNITS_2Valuefloat1516FLTP((0))YesWFAFC_VALUE
35NETUNITS_3Valuefloat1516FLTP((0))YesWFAFC_VALUE
36NETUNITS_4Valuefloat1516FLTP((0))YesWFAFC_VALUE
37NETUNITS_5Valuefloat1516FLTP((0))YesWFAFC_VALUE
38NETUNITS_6Valuefloat1516FLTP((0))YesWFAFC_VALUE
39NETUNITS_7Valuefloat1516FLTP((0))YesWFAFC_VALUE
40NETUNITS_WValuefloat1516FLTP((0))YesWFAFC_VALUE
41TOTAL_UNITSValuefloat1516FLTP((0))YesWFAFC_VALUE
42TOTAL_HOURSValuefloat1516FLTP((0))YesWFAFC_VALUE
43CREATED_BYCreated Bynvarchar120CHAR(N' ')YesWFA_CRUNAME Allow NULL? 
44CREATED_ATCreated Atdecimal150DEC((0))YesWFA_CRTIME
45CHANGED_BYLast Changed Bynvarchar120CHAR(N' ')YesWFA_CHUNAME Allow NULL? 
46CHANGED_ATLast Changed Atdecimal150DEC((0))YesWFA_CHTIME
NamePrimaryUniqueTypeColumns
WFAFC_WKLD_ADJ~0YesYesCLUSTEREDMANDT, ORG_PLVAR, ORG_OTYPE, ORG_OBJID, DEPT_INDEX, WRKAREA_CODE, START_DATE