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)
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

84 columns | Print definition?ERP 6.0  | ORG_OBJID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1WFA_ABS_REQ_MOBWFA: Absence Requests for Mobile5ORG_OBJIDObject IDnvarchar80
TOPCross-Application Components
2/PTGWFI/F_PIRAPSWorkflow Runtime Stack for Parked Invoices10ORG_OBJIDUser executing an action on a work item, sy-unamenvarchar120
TOPWorkforce Management Application
3ITC_EDIT_AUDITiTime Clock Time Event Edit Audit Table17ORG_OBJIDObject IDnvarchar80
4ITC_MGR_OVERRIDEManager Override Mapping2ORG_OBJIDObject IDnvarchar80
5WFACAS_TEAMAssignment of an Org Unit as a Team for IC WFM5ORG_OBJIDObject IDnvarchar80
6WFAC_TRK_ORG_STASchedule Track Status2ORG_OBJIDObject IDnvarchar80
7WFAFC_CTI_MAPCTI Mappings7ORG_OBJIDOrganization IDnvarchar80
8WFAFC_FORECASTForecasting master table8ORG_OBJIDObject IDnvarchar80
9WFAFC_INDCATORIndicator7ORG_OBJIDObject IDnvarchar80
10WFAFC_INDTOR_GRPIndicator Group8ORG_OBJIDObject IDnvarchar80
11WFAFC_SAMPLE2Forecasting Sample8ORG_OBJIDObject IDnvarchar80
12WFAFC_VOLADJ_TMPSummarization Table for Forecast and Adjustments4ORG_OBJIDObject IDnvarchar80
13WFAFC_VOL_ADJSummarization Table for Forecast and Adjustments4ORG_OBJIDObject IDnvarchar80
14WFAFC_WKLDAD_TMPSummarized Workload Forecasted and Adjusted Values4ORG_OBJIDObject IDnvarchar80
15WFAFC_WKLD_ADJSummarized Workload Forecasted and Adjusted Values4ORG_OBJIDObject IDnvarchar80
16WFATM_SC_AVA_TMPTM Temp Table: Schedule - Availability3ORG_OBJIDObject IDnvarchar80
17WFATM_SC_LOGAudit Trail of WFM ESS Schedule Change3ORG_OBJIDObject IDnvarchar80
18WFATM_SC_SEG_TMPTM Temp Table: Schedule - Shift Segment3ORG_OBJIDObject IDnvarchar80
19WFATM_SR_AVA_TMPTM Temp Table: Schedule Rule - Availability3ORG_OBJIDObject IDnvarchar80
20WFATM_SR_CTR_TMPTM Temp Table: Schedule Rule - Contract3ORG_OBJIDObject IDnvarchar80
21WFATM_SR_LOGAudit Trail of WFM ESS Schedule Rule Change3ORG_OBJIDObject IDnvarchar80
22WFATM_SR_PRF_TMPTM Temp Table: Schedule Rule - Preference3ORG_OBJIDObject IDnvarchar80
23WFATM_SR_ROT_TMPTM Temp Table: Schedule Rule - Rotation3ORG_OBJIDObject IDnvarchar80
24WFATM_SR_SET_TMPTM Temp Table: Schedule Rule - Set Shift3ORG_OBJIDObject IDnvarchar80
25WFATM_SR_WKR_TMPTM Temp Table: Schedule Rule - Work Rule3ORG_OBJIDObject IDnvarchar80
26WFA_ACT_BENFActual imported benefits table5ORG_OBJIDObject IDnvarchar80
27WFA_ACT_SHIFTActual header table5ORG_OBJIDObject IDnvarchar80
28WFA_ACT_SUMMActual summary hours, total paid hours and total pay4ORG_OBJIDObject IDnvarchar80
29WFA_AGT_CONTRAgent Contracts4ORG_OBJIDObject IDnvarchar80
30WFA_AGT_ORGAgent Org Attributes4ORG_OBJIDObject IDnvarchar80
31WFA_AGT_WRKARAgent Work Relationship8ORG_OBJIDObject IDnvarchar80
32WFA_CALCSTCalculation Status5ORG_OBJIDObject IDnvarchar80
33WFA_ERMS_ORG_MAPERMS Mapping - Organizational Assignments4ORG_OBJIDOrganization IDnvarchar80
34WFA_ORGOrganization Table4ORG_OBJIDObject IDnvarchar80
35WFA_SCEVT_ORGSchedule Event - Organization Relationship4ORG_OBJIDObject IDnvarchar80
36WFA_SCHDL_EVTScheduled activites(meetings)8ORG_OBJIDObject IDnvarchar80
37WFA_SCHEDULESchedule Table5ORG_OBJIDObject IDnvarchar80
38WFA_SCHED_SUMMSchedule summary hours, total paid hours and total pay4ORG_OBJIDObject IDnvarchar80
39WFA_SCH_CONPAYContract employee pay to min hours per week2ORG_OBJIDObject IDnvarchar80
40WFA_SHIFTShift Table6ORG_OBJIDObject IDnvarchar80
41WFA_TEAM_EVTTeams assigned to a scheduled event6ORG_OBJIDObject IDnvarchar80
42WFA_TIMOFFREQTime off Requests5ORG_OBJIDObject IDnvarchar80
43WFA_VIOLATIONViolations5ORG_OBJIDObject IDnvarchar80
44WFA_WRKA_HISTWork Area Attributes22ORG_OBJIDObject IDnvarchar80
45WFA_WRK_RULSTWork Rule Set Master Data8ORG_OBJIDObject IDnvarchar80
TOPWorkforce Management Core
46WFMCAS_ACT_BENFActual imported benefits table5ORG_OBJIDObject IDnvarchar80
47WFMCAS_ACT_SHIFTActual header table5ORG_OBJIDObject IDnvarchar80
48WFMCAS_ACT_SUMMActual summary hours, total paid hours and total pay4ORG_OBJIDObject IDnvarchar80
49WFMCAS_AGT_CONTRAgent Contracts4ORG_OBJIDObject IDnvarchar80
50WFMCAS_AGT_ORGAgent Org Attributes4ORG_OBJIDObject IDnvarchar80
51WFMCAS_AGT_WRKARAgent Work Relationship8ORG_OBJIDObject IDnvarchar80
52WFMCAS_CALCSTCalculation Status5ORG_OBJIDObject IDnvarchar80
53WFMCAS_HOL_HISTHoliday History table (OBSOLETE)4ORG_OBJIDObject IDnvarchar80
54WFMCAS_ORGOrganization Table4ORG_OBJIDObject IDnvarchar80
55WFMCAS_SCEVT_ORGSchedule Event - Organization Relationship4ORG_OBJIDObject IDnvarchar80
56WFMCAS_SCHDL_EVTScheduled activites(meetings)8ORG_OBJIDObject IDnvarchar80
57WFMCAS_SCHEDULESchedule Table5ORG_OBJIDObject IDnvarchar80
58WFMCAS_SHIFTShift Table6ORG_OBJIDObject IDnvarchar80
59WFMCAS_STD_ORGHRTemp Organization Hours -OBSOLETE4ORG_OBJIDObject IDnvarchar80
60WFMCAS_TEAMAssignment of an Org Unit as a Team for IC WFM5ORG_OBJIDObject IDnvarchar80
61WFMCAS_TEAM_EVTTeams assigned to a scheduled event6ORG_OBJIDObject IDnvarchar80
62WFMCAS_TIMOFFREQTime off Requests5ORG_OBJIDObject IDnvarchar80
63WFMCAS_TMP_ORGHRTemp Organization Hours OBSOLETE9ORG_OBJIDObject IDnvarchar80
64WFMCAS_VIOLATIONViolations5ORG_OBJIDObject IDnvarchar80
65WFMCAS_WRKA_HISTWork Area Attributes22ORG_OBJIDObject IDnvarchar80
66WFMCAS_WRK_RULSTWork Rule Set Master Data8ORG_OBJIDObject IDnvarchar80
67WFMCAS_WRK_SEGActual Work Segment - OBSOLETE9ORG_OBJIDObject IDnvarchar80
68WFMC_TRK_ORG_STASchedule Track Status2ORG_OBJIDObject IDnvarchar80
69WFMFC_CTI_MAPCTI Mappings7ORG_OBJIDOrganization IDnvarchar80
70WFMFC_FORECASTForecasting master table8ORG_OBJIDObject IDnvarchar80
71WFMFC_INDCATORIndicator7ORG_OBJIDObject IDnvarchar80
72WFMFC_INDTOR_GRPIndicator Group8ORG_OBJIDObject IDnvarchar80
73WFMFC_SAMPLE2Forecasting Sample8ORG_OBJIDObject IDnvarchar80
74WFMTM_SC_AVA_TMPTM Temp Table: Schedule - Availability3ORG_OBJIDObject IDnvarchar80
75WFMTM_SC_LOGAudit Trail of WFM ESS Schedule Change3ORG_OBJIDObject IDnvarchar80
76WFMTM_SC_SEG_TMPTM Temp Table: Schedule - Shift Segment3ORG_OBJIDObject IDnvarchar80
77WFMTM_SR_AVA_TMPTM Temp Table: Schedule Rule - Availability3ORG_OBJIDObject IDnvarchar80
78WFMTM_SR_CTR_TMPTM Temp Table: Schedule Rule - Contract3ORG_OBJIDObject IDnvarchar80
79WFMTM_SR_LOGAudit Trail of WFM ESS Schedule Rule Change3ORG_OBJIDObject IDnvarchar80
80WFMTM_SR_PRF_TMPTM Temp Table: Schedule Rule - Preference3ORG_OBJIDObject IDnvarchar80
81WFMTM_SR_ROT_TMPTM Temp Table: Schedule Rule - Rotation3ORG_OBJIDObject IDnvarchar80
82WFMTM_SR_SET_TMPTM Temp Table: Schedule Rule - Set Shift3ORG_OBJIDObject IDnvarchar80
83WFMTM_SR_WKR_TMPTM Temp Table: Schedule Rule - Work Rule3ORG_OBJIDObject IDnvarchar80
84WFM_ERMS_ORG_MAPERMS Mapping - Organizational Assignments4ORG_OBJIDOrganization IDnvarchar80