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
Personnel Management :: E-Recruiting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T77RCF_CDCYLIST383Data Saving for Requisition Assignment ListE-Recruiting
SQL:  selectupdate insert create

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

SELECT MANDT, PLVAR, NB_OBJID, NE_OBJID, LANGU, NA_OBJID, NA_NAME, NA_SORT_NAME, NA_EMAIL_ADDRESS, HAS_RESUME, ND_OBJID, ND_DATE, ND_SOURCE, FORWARDED_BY, IS_EMPLOYEE, EMPLOYEE_INFO, NE_STATUS, NE_STATUS_TXT, NA_QA_RANK, TP_QA_RANK, OA_TRM_RANK, OA_NB_RANK, NO_OF_ASSIGNT, HAS_NOTES, HAS_LAST_ACT, LAST_ACT, LAST_ACT_STATUS, LAST_ACT_C_DATE, PROCESSOR, NE_PROCESS, LAST_EMPLOYER, LAST_JOB, EDUCATION_TYPE, EDUCATION_LEVEL, IS_READ, PROCESS_ID, APPL_STATUS, APPL_SOURCE FROM T77RCF_CDCYLIST
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2PLVARPlan Versionnvarchar20 Allow NULL? 
3NB_OBJIDObject IDnvarchar80 Allow NULL? 
4NE_OBJIDObject IDnvarchar80 Allow NULL? 
5LANGULanguage Keychar10 Allow NULL? 
6NA_OBJIDObject IDnvarchar80 Allow NULL? 
7NA_NAMEFull Namenvarchar800 Allow NULL? 
8NA_SORT_NAMEFull Namenvarchar800 Allow NULL? 
9NA_EMAIL_ADDRESSE-Mail Addressnvarchar2410 Allow NULL? 
10HAS_RESUMEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')char10 Allow NULL? 
11ND_OBJIDObject IDnvarchar80 Allow NULL? 
12ND_DATEApplication Datenvarchar80 Allow NULL? 
13ND_SOURCEText for Application Sourcenvarchar800 Allow NULL? 
14FORWARDED_BYFull Namenvarchar800 Allow NULL? 
15IS_EMPLOYEEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')char10 Allow NULL? 
16EMPLOYEE_INFOChar 20nvarchar200 Allow NULL? 
17NE_STATUSCandidacy Statuschar10 Allow NULL? 
18NE_STATUS_TXTCandidacy Statusnvarchar600 Allow NULL? 
19NA_QA_RANKOverall Result for Rating of Questionnairechar10 Allow NULL? 
20TP_QA_RANKOverall Result for Rating of Questionnairechar10 Allow NULL? 
21OA_TRM_RANKObject Namenvarchar400 Allow NULL? 
22OA_NB_RANKObject Namenvarchar400 Allow NULL? 
23NO_OF_ASSIGNTNatural Numberint100 Allow NULL? 
24HAS_NOTESSingle-Character Indicatorchar10 Allow NULL? 
25HAS_LAST_ACTData element for domain BOOLE: TRUE (='X') and FALSE (=' ')char10 Allow NULL? 
26LAST_ACTDescription of Activity Typenvarchar400 Allow NULL? 
27LAST_ACT_STATUSSingle-Character Indicatorchar10 Allow NULL? 
28LAST_ACT_C_DATETime Stamp of Last Changedecimal150
29PROCESSORFull Namenvarchar800 Allow NULL? 
30NE_PROCESSName of a Processnvarchar400 Allow NULL? 
31LAST_EMPLOYEREmployernvarchar800 Allow NULL? 
32LAST_JOBInternal Job Titlenvarchar800 Allow NULL? 
33EDUCATION_TYPEName of Education Typenvarchar300 Allow NULL? 
34EDUCATION_LEVELName of Degree/Certificate Levelnvarchar300 Allow NULL? 
35IS_READSingle-Character Indicatorchar10 Allow NULL? 
36PROCESS_IDProcessnvarchar20 Allow NULL? 
37APPL_STATUSApplication Statuschar10 Allow NULL? 
38APPL_SOURCESource of Candidate's Applicationnvarchar40 Allow NULL? 
NamePrimaryUniqueTypeColumns
T77RCF_CDCYLIST~0YesYesCLUSTEREDLANGU, NE_OBJID, NB_OBJID, PLVAR, MANDT
T77RCF_CDCYLIST~NBNoNoNONCLUSTEREDLANGU, NB_OBJID, PLVAR
T77RCF_CDCYLIST~NENoNoNONCLUSTEREDNE_OBJID