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  | TCATS
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
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
10OINM101Whse Journal
Cross-Application Components :: Time Sheet
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0TCATS831CATS: Data Entry ProfilesTime Sheet
SQL:  selectupdate insert create

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

SELECT MANDT, VARIANT, CHANGABLE, PERNRLIST, MULTPER, TIMECLERK, ORGOBJ, SELKOSTL, SELWORKPL, SELCUSTOM, PERTYPE, CATSPERIOD, FIRSTDAYOF, PERLEFT, PERRIGHT, RELDATE, REJEBRIGHT, ADDINFOBRI, DAYTEXT, BRGRU, BEGEND, TARGETROW, TIMETYPE, SUBHRTIMES, UNDERTARGE, UNDERREACT, OVERTARGET, OVERREACT, SUMROW, CALENDAR, FUTURE, WORKLIST, ASSIGNED, WORKCENTRE, WORKING, WORKSINCE, FROMPOOL, FROMEXIT, WORKWITH, WF_APPR, FREEATSAVE, APPROVAL, DEFKOKRSCO, DEFCOSTCO, DEFCOSTCC, DEFACTTY, DEFPUROR, DEFLSTST, DEFATYPE, DEFAWART, DEFWTYPE, DEFLGART, TASK, KONTIREACT, KOLLIREACT, KOLHRREACT, MAXHRREACT, DIRECTHR, CATSPRINT, SELREPORT, HRCOSTASG, SELREP, CALENDAR_W, NOBREAKDED, ADDOVERTIME, WF_AUTO, NOCHANGE, SKIPISCR, DEFSPRZNR, CATSCELL_SIZE, T_SCHEMA, TEMPLATE, PERLOCK, EXC_GROUP, SPECIAL_APPROVAL, WORKCPRO, ASSIGNDB, CHECKASDB, HRENABLED, DATADISPLAY, CUTOFFDT, OFFSETPD, PUBLICHOLTY FROM TCATS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VARIANTData Entry Profilenvarchar80CHAR(N' ')NoCATSVARIAN Allow NULL? 
3CHANGABLEProfile Can Be Changedchar10CHAR(N' ')YesCATSPROFCH Allow NULL? 
4PERNRLISTDisplay List of Personnel Numberschar10CHAR(N' ')YesCATSPERLIS Allow NULL? 
5MULTPEREnter for Several Personnel Numberschar10CHAR(N' ')YesCATSMULTPE Allow NULL? 
6TIMECLERKPerson Selection by Time Administratorchar10CHAR(N' ')YesCATSTIMECL Allow NULL? 
7ORGOBJPerson Selection by Organizational Unitchar10CHAR(N' ')YesCATSORGOBJ Allow NULL? 
8SELKOSTLPerson Selection by Cost Centerchar10CHAR(N' ')YesCATSSELCOS Allow NULL? 
9SELWORKPLNOT USED ! Person Selection via Work Centerchar10CHAR(N' ')YesCATSSELWRK Allow NULL? 
10SELCUSTOMNOT USED ! Person Selection via Customer Enhancementchar10CHAR(N' ')YesCATSSELCUS Allow NULL? 
11PERTYPEType of Data Entry Periodchar10CHAR(N' ')YesCATSPERTYP Allow NULL? 
12CATSPERIODNumber of Days/Weeks on Screennvarchar20NUMC(N'00')YesCATSPERIOD Allow NULL? 
13FIRSTDAYOFFirst Day of Weekchar10NUMC(N'0')YesCATSFIRSTD Allow NULL? 
14PERLEFTNumber of Screens You Can Scroll Downnvarchar20NUMC(N'00')YesCATSPERLEF Allow NULL? 
15PERRIGHTNumber of Screens You Can Scroll Upnvarchar20NUMC(N'00')YesCATSPERRIG Allow NULL? 
16RELDATEKey Date Relative to Current Datedecimal10DEC((0))YesCATSRELDAT
17REJEBRIGHTRejected Records Highlighted and Display-Onlychar10CHAR(N' ')YesCATSBRIGHT Allow NULL? 
18ADDINFOBRIHighlight Records with Additional Informationchar10CHAR(N' ')YesCATSADDINF Allow NULL? 
19DAYTEXTDisplay Weekdayschar10CHAR(N' ')YesCATSDAYTEX Allow NULL? 
20BRGRUProfile Authorization Groupnvarchar40CHAR(N' ')YesTCATSACATSPROFAG Allow NULL? 
21BEGENDData Entry with Clock Timeschar10CHAR(N' ')YesCATSBEGEN_ Allow NULL? 
22TARGETROWLine with Target Hours per Daychar10CHAR(N' ')YesCATSTARGET Allow NULL? 
23TIMETYPETime Type for Target Hours (Default: Day's Planned Hours)nvarchar40CHAR(N' ')YesT555ACATSTIMETY Allow NULL? 
24SUBHRTIMESSubtract HR Attendance or Absence Hours from Target Hourschar10CHAR(N' ')YesCATSSUBHR Allow NULL? 
25UNDERTARGEMax. Percentage by Which Value May Fall Below Target Hoursnvarchar30NUMC(N'000')YesCATSUNDERT Allow NULL? 
26UNDERREACTReaction if Downward Tolerance Is Not Observedchar10CHAR(N' ')YesCATSUNDERR Allow NULL? 
27OVERTARGETMax. Percentage by Which Value May Exceed Target Hoursnvarchar30NUMC(N'000')YesCATSOVERTA Allow NULL? 
28OVERREACTReaction if Upward Tolerance Is Not Observedchar10CHAR(N' ')YesCATSOVERRE Allow NULL? 
29SUMROWLine with Totals for Each Daychar10CHAR(N' ')YesCATSSUMROW Allow NULL? 
30CALENDARData Entry for Workdays onlychar10CHAR(N' ')YesCATSCALE Allow NULL? 
31FUTURERelease Future Timeschar10CHAR(N' ')YesCATSFUTURE Allow NULL? 
32WORKLISTDisplay Worklistchar10CHAR(N' ')YesCATSWRKLST Allow NULL? 
33ASSIGNEDWorklist from Resource Planningchar10CHAR(N' ')YesCATSASSIGN Allow NULL? 
34WORKCENTREWorklist Based on Work Center Assignmentchar10CHAR(N' ')YesCATSWORKCT Allow NULL? 
35WORKINGWorklist with Operations that Are in Processchar10CHAR(N' ')YesCATSWORKNG Allow NULL? 
36WORKSINCECATS: Worklist - Fromdecimal30DEC((0))YesCATSSINCEP
37FROMPOOLWorklist with Pool of Confirmationschar10CHAR(N' ')YesCATSPOOL Allow NULL? 
38FROMEXITSet Up Worklist Using an SAP Enhancementchar10CHAR(N' ')YesCATSEXITWL Allow NULL? 
39WORKWITHCopy from Worklist Without Hourschar10CHAR(N' ')YesWORKWITH Allow NULL? 
40WF_APPRWorkflow for Approvalchar10CHAR(N' ')YesCATSWFAPPR Allow NULL? 
41FREEATSAVERelease Records on Savingchar10CHAR(N' ')YesCATSFREEAT Allow NULL? 
42APPROVALApproval Requiredchar10CHAR(N' ')YesCATSAPPROV Allow NULL? 
43DEFKOKRSCOPropose Controlling Area from HR Master Recordchar10CHAR(N' ')YesCATSKOKRSC Allow NULL? 
44DEFCOSTCOPropose Master Cost Center from HR Master Recordchar10CHAR(N' ')YesCATSCOSTCO Allow NULL? 
45DEFCOSTCCPropose Cost Center from HR Master Recordchar10CHAR(N' ')YesCATSCOSTCC Allow NULL? 
46DEFACTTYPropose Activity Type from HR Master Recordchar10CHAR(N' ')YesCATSACTTY Allow NULL? 
47DEFPURORPropose Purchase Order from HR Master Recordchar10CHAR(N' ')YesCATSPUROR Allow NULL? 
48DEFLSTSTPropose Service Master from HR Master Recordchar10CHAR(N' ')YesCATSLSTLS Allow NULL? 
49DEFATYPEPropose Attendance/Absence Typechar10CHAR(N' ')YesCATSATYPE Allow NULL? 
50DEFAWARTAttendance or Absence Typenvarchar40CHAR(N' ')YesT554SAWART Allow NULL? 
51DEFWTYPEPropose Wage Typechar10CHAR(N' ')YesCATSWTYPE Allow NULL? 
52DEFLGARTWage Typenvarchar40CHAR(N' ')YesT512ZLGART Allow NULL? 
53TASKTask IDnvarchar140CHAR(N' ')YesSWW_TASK Allow NULL? 
54KONTIREACTReaction if Quota Is Insufficientchar10CHAR(N' ')YesCATSQUOTAR Allow NULL? 
55KOLLIREACTReaction if CATS Records Collidechar10CHAR(N' ')YesCATSCOLLIR Allow NULL? 
56KOLHRREACTReaction if CATS Records Collide with HR Recordschar10CHAR(N' ')YesCATSCOLHRR Allow NULL? 
57MAXHRREACTReaction if More than 24 Hours Are Entered for a Daychar10CHAR(N' ')YesCATSMAXHRR Allow NULL? 
58DIRECTHRImmediate Transfer to HRchar10CHAR(N' ')YesDIRECTHR Allow NULL? 
59CATSPRINTPrint Program for the Time Sheetnvarchar400CHAR(N' ')YesTCATPCATSPRINT Allow NULL? 
60SELREPORTTime Sheet: Report for Person Selectionnvarchar400CHAR(N' ')Yes*CATSSELRP Allow NULL? 
61HRCOSTASGCost Accounting Variantschar10CHAR(N' ')YesCATSHRCO Allow NULL? 
62SELREPPerson Selection Using Selection Reportchar10CHAR(N' ')YesCATSSELREP Allow NULL? 
63CALENDAR_WDistribution of Hours in Worklist for Workdays Onlychar10CHAR(N' ')YesCATSCALE_W Allow NULL? 
64NOBREAKDEDNo Deduction of Breaks when Calculating Hourschar10CHAR(N' ')YesCATSNOBRKS Allow NULL? 
65ADDOVERTIMEAdd Overtime from HR to Target Hourschar10CHAR(N' ')YesCATSADDOVER Allow NULL? 
66WF_AUTOAutomatic Recipient Determinationchar10CHAR(N' ')YesCATSWFAUTO Allow NULL? 
67NOCHANGEApproved Records Cannot Be Changedchar10CHAR(N' ')YesCATSNOCHNG Allow NULL? 
68SKIPISCRSkip Initial Screenchar10CHAR(N' ')YesCATSSKIPISCR Allow NULL? 
69DEFSPRZNRPropose Sender Business Process from HR Master Recordchar10CHAR(N' ')YesCATSSPRZNR Allow NULL? 
70CATSCELL_SIZETime Sheet: Cell Lengthnvarchar20NUMC(N'00')YesCATSCELL_SIZE Allow NULL? 
71T_SCHEMATrip schemanvarchar20CHAR(N' ')YesT706SRSCHE Allow NULL? 
72TEMPLATEPersonal Templateschar10CHAR(N' ')YesCATSTEMPLATE Allow NULL? 
73PERLOCKInclude CO Period Lockchar10CHAR(N' ')YesCATSPERLOCK Allow NULL? 
74EXC_GROUPRule Group for Special Approvalnvarchar80CHAR(N' ')YesTCATS_EXC_GROUPCATS_EXC_GROUP Allow NULL? 
75SPECIAL_APPROVALApproval Requiredchar10CHAR(N' ')YesCATSAPPROV Allow NULL? 
76WORKCPROWorklist from Project Assignmentchar10CHAR(N' ')YesCATSCPRO Allow NULL? 
77ASSIGNDBWorklist from Staff Assignmentschar10CHAR(N' ')YesCATSASGNDB Allow NULL? 
78CHECKASDBInput Checks from Staff Assignmentschar10CHAR(N' ')YesCATSCHKADB Allow NULL? 
79HRENABLEDEnable HR information in CATSchar10CHAR(N' ')YesCATSHRE Allow NULL? 
80DATADISPLAYDisplay options for data entry in CATS WDAchar10CHAR(N' ')YesCATSDDISP Allow NULL? 
81CUTOFFDTTime recording cut-off date at the end of payroll periodchar10CHAR(N' ')YesCATSPPE Allow NULL? 
82OFFSETPDCut-off end date for time recording in CATSnvarchar20CHAR(N' ')YesCATSODD Allow NULL? 
83PUBLICHOLTYPublic holiday type for HR-Enabled CATSnvarchar40CHAR(N' ')YesT554SCATSHABSTY Allow NULL? 
NamePrimaryUniqueTypeColumns
TCATS~0YesYesCLUSTEREDVARIANT, 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