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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

190 columns | Print definition?ERP 6.0  | LNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/D_MGWURMRUser Request Management (User Request Table)12LNAMEUser Request Management (Name)nvarchar600
2GRACREQUSERUser Associated with Request5LNAMELast Namenvarchar1000
3ITC_RCODE_DEF_TText table for Time collection Reason Code5LNAMELong Descriptionnvarchar600
4ITC_RCODE_PROF_TText table for iTime Clock Reason Code Profile5LNAMELong Descriptionnvarchar600
5T5FDSNMTOMBDSN: MTOM Authorization9LNAMEnvarchar640
6T5GPBST_LEATPS: LEA numbers and names5LNAMETPS LEA namenvarchar400
7T7RU1655Infotype 1655 Fields: Legal properties (Russia)5LNAMELong Name of Organizationnvarchar10000
8TMDT_MDS_HEADERTHeader information on Market Data Sets - Texts5LNAMELong Namenvarchar600
9TPDASESSIONWPTPDA: Debug Sessions - BPs3LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
10TPDA_VARIABLESVariablenablage2LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
11WFAFC_CALCPARA_TForecasting method parameters5LNAMELong Descriptionnvarchar600
TOPActivity-Based Costing
12COFUNCLCO-OM-ABC: Language-Dependent Functions6LNAMEFunction Name: Language Dependentnvarchar300
TOPAddress ManagementBusiness Address
13SADR8Address management: X.400 addresses15LNAMEAddresses: X.400 last namenvarchar400
14SADRPAddress Management: Personal Data27LNAMEA person's last name (Addresses)nvarchar350
TOPBank Accounting
15TCCLGPayment Cards: Settlement Run Log16LNAMEPayment Cards: User (Last Settlement)nvarchar120
TOPBasis Components
16ZDS400_TAB1Exercise table2LNAMECHAR40 for SYSTnvarchar400
TOPFlexible Real Estate Management
17TIVPROTPHBuchungsvorgangsdefinition: Belegköpfe6LNAMEName für Loopnvarchar150
18TIVPROTPIBuchungsvorgangsdefinition: Belegzeilen9LNAMEName für Loopnvarchar150
TOPMarket Risk Analyzer
19TMDT_MDCRHEADERTHeader information on MDCR sets - Texts5LNAMELong Namenvarchar600
TOPPayroll
20T7UA1656Infotype 1656 Fields: Legal properties (Ukraine)5LNAMELong Name of Organizationnvarchar2550
TOPPrint and Output Management
21TSP03LSpool: Long device names1LNAMESpool: Long device namesnvarchar300
22TSPCMDSCommand Line Model for LOMS1LNAMELogical output management systemnvarchar60
TOPSets
23RWSLINEReport Writer Data for the Set Line8LNAMESymbolic name (Report Writer)nvarchar80
TOPSyntax, Compiler, Runtime
24TPDAOPTIONSTPDA: Optionen3LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
25TPDAPRESUITPDA: Default Settings - tpdasubsc/tpdasubscarea Additions3LNAMETPDA: Layout Name of User-Specific Debugger Layoutnvarchar300
26TPDASESSIONBP3LNAMETPDA: Layout Name of User-Specific Debugger Layoutnvarchar300
27TPDASESSIONSTPDA: Debug Sessions3LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
28TPDASESSIONSSETTTPDA: Debug Sessions - Einstellungen3LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
29TPDASESSIONSTTPDA: Debug Sessions Text3LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
30TPDASETTINGSTPDA: ABAP Debugger Settings2LNAMETPDA: Layout Name of User-Specific Debugger Layoutnvarchar300
31TPDASUBSCTPDA: Subscreens for Subscreen Tree3LNAMETPDA: Layout Name of User-Specific Debugger Layoutnvarchar300
32TPDASUBSCAREATPDA: Subscreen Tree - Areas (Occupation)3LNAMETPDA: Layout Name of User-Specific Debugger Layoutnvarchar300
33TPDATABTEXTTPDA: Voreistellungen -Texte der Desktops3LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
34TPDA_TABLE_CONFCSpalten2LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
35TPDA_TABLE_CONFHSpaltenkonfigurationen für User und Session2LNAMETPDA: Layoutname des Userspezifischen Debugger Layoutnvarchar300
TOPTreasury and Risk Management
36VVWKN1OBSOLETE - Fields as factors for secondary data2LNAMEName of sort field (sort string)nvarchar300
37VVWKN2Allocation of values to value groups2LNAMEName of sort field (sort string)nvarchar300
38VVWKN6Alloc. of charac.group to second.term via the invoice no.2LNAMEName of sort field (sort string)nvarchar300
39VVWKN7Charact.group - Secondary values alloc. (via the inv.no.)2LNAMEName of sort field (sort string)nvarchar300
TOPWorkbench Utilities
40FLEMPEmployees2LNAMELast namenvarchar150
TOPWorkforce Management Application
41ITC_CALCR_RULE_TCalculation Rule Text Table5LNAMELong Descriptionnvarchar600
42ITC_CALC_PRF_TCalculation Profile Text Table5LNAMELong Descriptionnvarchar600
43ITC_CALC_RULE_TCalculation Rule Text Table5LNAMELong Descriptionnvarchar600
44ITC_CFG_TYP_TiTime Clock Administration Configuration Setting Definition5LNAMELong Descriptionnvarchar600
45ITC_EXCPN_TYPE_TPunch Exception Types text table5LNAMEiTimeClock Exception long textnvarchar1000
46ITC_ORG_CFG_TiTime Clock Admin Org Configurationg Setting Text5LNAMELong Descriptionnvarchar600
47ITC_ORG_PRF_TiTime Clock Org Profile Text5LNAMELong Descriptionnvarchar600
48ITC_PNCH_EXCPN_TPunch exception profile text table5LNAMELong Descriptionnvarchar600
49WFAC_ABSTYPE_TAbsence Type Translation Table6LNAMELong Descriptionnvarchar600
50WFAC_AGE_QUAL_TWFM Age Qualifer Text Table5LNAMELong Descriptionnvarchar600
51WFAC_AVAIL_TMP_TAvailablility Template Translation Table6LNAMELong Descriptionnvarchar600
52WFAC_BRKRULSET_TBreakRule Set6LNAMELong Descriptionnvarchar600
53WFAC_BRKTYPES_TBreak Types Texts6LNAMELong Descriptionnvarchar600
54WFAC_CONTR_RL_TContract Rule Text Table5LNAMELong Descriptionnvarchar600
55WFAC_COSTN_TCosts: External Key Text5LNAMELong Descriptionnvarchar600
56WFAC_COSTS_DEF_TCost Definitions Text5LNAMELong Descriptionnvarchar600
57WFAC_DALWDSHFT_TDisallowed Shift Lengths6LNAMELong Descriptionnvarchar600
58WFAC_DAYSHIFTN_TWeek/day breaker: External Key Text5LNAMELong Descriptionnvarchar600
59WFAC_DEPT_TAG_Tdepartment tag text table5LNAMELong Descriptionnvarchar600
60WFAC_DFTSETGRP_TDefault Settings Group Text6LNAMELong Descriptionnvarchar600
61WFAC_EXCPT_DEF_TSchedule ExceptionTexts5LNAMELong Descriptionnvarchar600
62WFAC_EXPORT_RL_TSchedule export rules6LNAMELong Descriptionnvarchar600
63WFAC_FIELD_SEL_TField selection text table8LNAMELong Descriptionnvarchar600
64WFAC_HOLASSIGN_THoliday Cost Profile Assigment - Text Table6LNAMELong Descriptionnvarchar600
65WFAC_HOLPPRF_THoliday Pay Profile Text Table6LNAMELong Descriptionnvarchar600
66WFAC_IMPORT_RL_TActual worked segment import rules6LNAMELong Descriptionnvarchar600
67WFAC_LOCATION_TLocation Translation Table5LNAMELong Descriptionnvarchar600
68WFAC_LOCSETTN_TGen. Location Settings Translation Table5LNAMELong Descriptionnvarchar600
69WFAC_NONTRAN_Ttext for non transition zones6LNAMELong Descriptionnvarchar600
70WFAC_OPHOURS_TWFM Operating Hours Text Table6LNAMELong Descriptionnvarchar600
71WFAC_PAYCLASS_TPayclass Translation Table6LNAMELong Descriptionnvarchar600
72WFAC_PERIOD_RL_TPeriod Rule configuration5LNAMELong Descriptionnvarchar600
73WFAC_QUERY_FLD_TQuery field5LNAMELong Descriptionnvarchar600
74WFAC_SCHDEXCPN_TSchedule Exceptions: External Key Text5LNAMELong Descriptionnvarchar600
75WFAC_SETSHFTCN_TSet Shift Template Text6LNAMELong Descriptionnvarchar600
76WFAC_SNPRFN_TSeniority Date Profile: External Key Text5LNAMELong Descriptionnvarchar600
77WFAC_SOPHOURS_TWFM Operating Hours Text Table6LNAMELong Descriptionnvarchar600
78WFAC_SPECDAYPT_TWFM Operating Hours Text Table6LNAMELong Descriptionnvarchar600
79WFAC_SPEC_DAYH_TSpecial Day Parts5LNAMELong Descriptionnvarchar600
80WFAC_TRK_GRP_TSchedule Track Group5LNAMELong Descriptionnvarchar600
81WFAC_TRK_PAGE_TSchedule Track Pages5LNAMELong Descriptionnvarchar600
82WFAC_TRK_TEMP_TSchedule Track Templates5LNAMELong Descriptionnvarchar600
83WFAC_WARELUCT_Ttext table for work area reluctance profile6LNAMELong Descriptionnvarchar600
84WFAC_WKNDDAYSN_TWeekend Days: External Key Text5LNAMELong Descriptionnvarchar600
85WFAC_WKRLDFLTN_TDefault work rules: External Key Text5LNAMELong Descriptionnvarchar600
86WFAC_WKRLTEMPN_TWork Rule Template Set Text6LNAMELong Descriptionnvarchar600
87WFAC_WKRL_DEF_TDefault Work Rules Definitions5LNAMELong Descriptionnvarchar600
88WFAC_WK_WGT_PR_TWeek Weight Profile Text5LNAMELong Descriptionnvarchar600
89WFAC_WRKRULE_ENTWork Rule Enabement5LNAMELong Descriptionnvarchar600
90WFAEM_FIELD_A_TUI screen group field attributes5LNAMELong Descriptionnvarchar600
91WFAEM_FIELD_TText table for UI screen fields4LNAMELong Descriptionnvarchar600
92WFAEM_SGRP_A_TAttributes for UI screen groups5LNAMELong Descriptionnvarchar600
93WFAEM_SGRP_TText table for WFMEM_SCRNGRP4LNAMELong Descriptionnvarchar600
94WFAFC_ATTRCODE_TAttribute Code5LNAMELong Descriptionnvarchar600
95WFAFC_CALCMETH_TForecasting calculation methods5LNAMELong Descriptionnvarchar600
96WFAFC_CALC_BCH_TCalculation Batch5LNAMELong Descriptionnvarchar600
97WFAFC_FCSTCFGN_TSeniority Date Profile: External Key Text5LNAMELong Descriptionnvarchar600
98WFAFC_FGPRMTYP_TForecasts5LNAMELong Descriptionnvarchar600
99WFAFC_FISC_CAL_TFiscal Calendar Text Table5LNAMELong Descriptionnvarchar600
100WFAFC_FIXHIST_TFixed History Text- Obsolete as of 5.05LNAMELong Descriptionnvarchar600
101WFAFC_GENHIST_TGeneration History Text5LNAMELong Descriptionnvarchar600
102WFAFC_GEN_CUST_TCustomizing settings for above store level adjustments5LNAMELong Descriptionnvarchar600
103WFAFC_INDCATOR_TIndicator5LNAMELong Descriptionnvarchar600
104WFAFC_IND_GRP_TIndicator Groups5LNAMELong Descriptionnvarchar600
105WFAFC_PRM_CODE_TForecasts5LNAMELong Descriptionnvarchar600
106WFAFC_TAGHIST_TStore tagged history5LNAMELong Descriptionnvarchar600
107WFAFC_TAG_HIST_TTag History5LNAMELong Descriptionnvarchar600
108WFAFC_TAG_SET_TTag set text5LNAMELong Descriptionnvarchar600
109WFAFC_WKGEN_CD_TWeekend Generation Code5LNAMELong Descriptionnvarchar600
110WFATM_RSTR_MSG_TText table for restriction message5LNAMELong Descriptionnvarchar600
111WFATM_RSTR_PRF_TText table for restriction profile5LNAMELong Descriptionnvarchar600
112WFATM_RSTR_RULETText table for restriction rule5LNAMELong Descriptionnvarchar600
113WFATM_SR_WKR_TMPTM Temp Table: Schedule Rule - Work Rule15LNAMELong Descriptionnvarchar600
114WFATM_TC_PRF_TText table for time collection settings profile5LNAMELong Descriptionnvarchar600
115WFATM_TC_STNG_TText table for Time Collection settings5LNAMELong Descriptionnvarchar600
116WFATM_UPDN_SCH_TText table for upload and download schedule tasks settings5LNAMELong Descriptionnvarchar600
117WFA_AGT_ROT_TAgent Rotation Set Text Table6LNAMELong Descriptionnvarchar600
118WFA_EMPWRROT_TEmployee Work Rule Rotation Text Table6LNAMELong Descriptionnvarchar600
119WFA_SCH_EVT_TSchedule Event Texts5LNAMELong Descriptionnvarchar600
120WFA_WRKAREA_TWork Area Texts5LNAMELong Descriptionnvarchar600
121WFA_WRKLOAD_TWorkload Texts5LNAMELong Descriptionnvarchar600
TOPWorkforce Management Core
122WFMCAS_AGT_ROT_TAgent Rotation Set Text Table6LNAMELong Descriptionnvarchar600
123WFMCAS_CALCST_TCalculation Status Text Table - OBSOLETE5LNAMELong Descriptionnvarchar600
124WFMCAS_SCH_EVT_TSchedule Event Texts5LNAMELong Descriptionnvarchar600
125WFMCAS_TMPORGH_TOrg Text Table OBSOLETE5LNAMELong Descriptionnvarchar600
126WFMCAS_WRKAREA_TWork Area Texts5LNAMELong Descriptionnvarchar600
127WFMCAS_WRKLOAD_TWorkload Texts5LNAMELong Descriptionnvarchar600
128WFMC_ABSTYPE_TAbsence Type Translation Table6LNAMELong Descriptionnvarchar600
129WFMC_AGE_QUAL_TWFM Age Qualifer Text Table5LNAMELong Descriptionnvarchar600
130WFMC_AVAIL_TMP_TAvailablility Template Translation Table6LNAMELong Descriptionnvarchar600
131WFMC_BRKRULSET_TBreakRule Set6LNAMELong Descriptionnvarchar600
132WFMC_BRKTYPES_TBreak Types Texts6LNAMELong Descriptionnvarchar600
133WFMC_COSTN_TCosts: External Key Text5LNAMELong Descriptionnvarchar600
134WFMC_COSTS_DEF_TCost Definitions Text5LNAMELong Descriptionnvarchar600
135WFMC_DALWDSHFT_TDisallowed Shift Lengths6LNAMELong Descriptionnvarchar600
136WFMC_DAYSHIFTN_TWeek/day breaker: External Key Text5LNAMELong Descriptionnvarchar600
137WFMC_DEPT_TAG_Tdepartment tag text table5LNAMELong Descriptionnvarchar600
138WFMC_DFTSETGRP_TDefault Settings Group Text6LNAMELong Descriptionnvarchar600
139WFMC_EXCPT_DEF_TSchedule ExceptionTexts5LNAMELong Descriptionnvarchar600
140WFMC_EXPORT_RL_TSchedule export rules6LNAMELong Descriptionnvarchar600
141WFMC_FIELD_SEL_TField selection text table8LNAMELong Descriptionnvarchar600
142WFMC_HOLASSIGN_THoliday Cost Profile Assigment - Text Table6LNAMELong Descriptionnvarchar600
143WFMC_HOLPPRF_THoliday Pay Profile Text Table6LNAMELong Descriptionnvarchar600
144WFMC_IMPORT_RL_TActual worked segment import rules6LNAMELong Descriptionnvarchar600
145WFMC_LOCATION_TLocation Translation Table5LNAMELong Descriptionnvarchar600
146WFMC_LOCSETTN_TGen. Location Settings Translation Table5LNAMELong Descriptionnvarchar600
147WFMC_NONTRAN_Ttext for non transition zones6LNAMELong Descriptionnvarchar600
148WFMC_OPHOURS_TWFM Operating Hours Text Table6LNAMELong Descriptionnvarchar600
149WFMC_PAYCLASS_TPayclass Translation Table6LNAMELong Descriptionnvarchar600
150WFMC_QUERY_FLD_TQuery field5LNAMELong Descriptionnvarchar600
151WFMC_SCHDEXCPN_TSchedule Exceptions: External Key Text5LNAMELong Descriptionnvarchar600
152WFMC_SETSHFTCN_TSet Shift Template Text6LNAMELong Descriptionnvarchar600
153WFMC_SNPRFN_TSeniority Date Profile: External Key Text5LNAMELong Descriptionnvarchar600
154WFMC_SOPHOURS_TWFM Operating Hours Text Table6LNAMELong Descriptionnvarchar600
155WFMC_TRK_GRP_TSchedule Track Group5LNAMELong Descriptionnvarchar600
156WFMC_TRK_PAGE_TSchedule Track Pages5LNAMELong Descriptionnvarchar600
157WFMC_TRK_TEMP_TSchedule Track Templates5LNAMELong Descriptionnvarchar600
158WFMC_WARELUCT_Ttext table for work area reluctance profile6LNAMELong Descriptionnvarchar600
159WFMC_WKNDDAYSN_TWeekend Days: External Key Text5LNAMELong Descriptionnvarchar600
160WFMC_WKRLDFLTN_TDefault work rules: External Key Text5LNAMELong Descriptionnvarchar600
161WFMC_WKRLTEMPN_TWork Rule Template Set Text6LNAMELong Descriptionnvarchar600
162WFMC_WKRL_DEF_TDefault Work Rules Definitions5LNAMELong Descriptionnvarchar600
163WFMC_WKRL_TEMP_TWork Rule Template Set Text (out of use for Retail)6LNAMELong Descriptionnvarchar600
164WFMEM_FIELD_A_TUI screen group field attributes5LNAMELong Descriptionnvarchar600
165WFMEM_FIELD_TText table for UI screen fields4LNAMELong Descriptionnvarchar600
166WFMEM_SGRP_A_TAttributes for UI screen groups5LNAMELong Descriptionnvarchar600
167WFMEM_SGRP_TText table for WFMEM_SCRNGRP4LNAMELong Descriptionnvarchar600
168WFMFC_ATTRCODE_TAttribute Code5LNAMELong Descriptionnvarchar600
169WFMFC_CALCMETH_TForecasting calculation methods5LNAMELong Descriptionnvarchar600
170WFMFC_CALC_BCH_TCalculation Batch5LNAMELong Descriptionnvarchar600
171WFMFC_CALC_PHASECalculation phase defined for forecasting3LNAMELong Descriptionnvarchar600
172WFMFC_FCSTCFGN_TSeniority Date Profile: External Key Text5LNAMELong Descriptionnvarchar600
173WFMFC_FGPRMTYP_TForecasts5LNAMELong Descriptionnvarchar600
174WFMFC_FISC_CAL_TFiscal Calendar Text Table5LNAMELong Descriptionnvarchar600
175WFMFC_FIXHIST_TFixed History Text- Obsolete as of 5.05LNAMELong Descriptionnvarchar600
176WFMFC_GENHIST_TGeneration History Text5LNAMELong Descriptionnvarchar600
177WFMFC_INDCATOR_TIndicator5LNAMELong Descriptionnvarchar600
178WFMFC_IND_GRP_TIndicator Groups5LNAMELong Descriptionnvarchar600
179WFMFC_PRM_CODE_TForecasts5LNAMELong Descriptionnvarchar600
180WFMFC_TAGHIST_TStore tagged history5LNAMELong Descriptionnvarchar600
181WFMFC_TAG_HIST_TTag History5LNAMELong Descriptionnvarchar600
182WFMFC_TAG_SET_TTag set text5LNAMELong Descriptionnvarchar600
183WFMFC_WKGEN_CD_TWeekend Generation Code5LNAMELong Descriptionnvarchar600
184WFMTM_RSTR_MSG_TText table for restriction message5LNAMELong Descriptionnvarchar600
185WFMTM_RSTR_PRF_TText table for restriction profile5LNAMELong Descriptionnvarchar600
186WFMTM_RSTR_RULETText table for restriction rule5LNAMELong Descriptionnvarchar600
187WFMTM_SR_WKR_TMPTM Temp Table: Schedule Rule - Work Rule15LNAMELong Descriptionnvarchar600
188WFMTM_TC_PRF_TText table for time collection settings profile5LNAMELong Descriptionnvarchar600
189WFMTM_TC_STNG_TText table for Time Collection settings5LNAMELong Descriptionnvarchar600
190WFMTM_UPDN_SCH_TText table for upload and download schedule tasks settings5LNAMELong Descriptionnvarchar600