SAP Tables - SAP Business One/ERP Table Definition reference

 Module:  Table: 

icon of database logic symbol SAP  TABLESv1Made in Britain - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

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
10BSEG345Accounting Document Segment

B1 9.2: Top 10 requests

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

2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal
Human Resources
1Business One9.3OHEM1354EmployeesHuman Resources
SQL:  selectupdate insert create

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

SELECT empID, lastName, firstName, middleName, sex, jobTitle, type, dept, branch, workStreet, workBlock, workZip, workCity, workCounty, workCountr, workState, manager, userId, salesPrson, officeTel, officeExt, mobile, pager, homeTel, fax, email, startDate, status, salary, salaryUnit, emplCost, empCostUnt, termDate, termReason, bankCode, bankBranch, bankBranNo, bankAcount, homeStreet, homeBlock, homeZip, homeCity, homeCounty, homeCountr, homeState, birthDate, brthCountr, martStatus, nChildren, govID, citizenshp, passportNo, passportEx, picture, remark, attachment, salaryCurr, empCostCur, WorkBuild, HomeBuild, position, AtcEntry, AddrTypeW, AddrTypeH, StreetNoW, StreetNoH, DispMidNam, NamePos, DispComma, CostCenter, CompanyNum, VacPreYear, VacCurYear, MunKey, TaxClass, InTaxLiabi, EmTaxCCode, RelPartner, ExemptAmnt, ExemptUnit, AddiAmnt, AddiUnit, TaxOName, TaxONum, HeaInsName, HeaInsCode, HeaInsType, SInsurNum, StatusOfP, StatusOfE, BCodeDateV, DevBAOwner, FNameSP, SurnameSP, LogInstanc, UserSign, UserSign2, UpdateDate, PersGroup, JTCode, ExtEmpNo, BirthPlace, PymMeth, ExemptCurr, AddiCurr, STDCode, FatherName, CPF, CRC, ContResp, RepLegal, DirfDeclar, UF_CRC, IDType, Active, BPLId, ManualNUM, PassIssue, PassIssuer, QualCode, PRWebAccss, PrePRWeb, BPLink, NaturalPer, DPPStatus, EnRligion, EnRligionP, EncryptIV, EnGovID, EnPassport, CreateDate, CreateTS, UpdateTS, EnInsurNum, EnBnkAcct FROM OHEM


ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1empIDEmployee No.int110 Allow NULL? 
2lastNameLast Namenvarchar500 Allow NULL? 
3firstNameFirst Namenvarchar500 Allow NULL? 
4middleNameMiddle Namenvarchar500 Allow NULL? 
5sexGenderchar10ME=Not Specified, F=Female, M=Male Allow NULL? 
6jobTitleJob Titlenvarchar200 Allow NULL? 
7typeEmployee Typeint110OHTY Allow NULL? 
8deptDepartmentint60OUDP Allow NULL? 
9branchBranchint60OUBR Allow NULL? 
10workStreetWork Streetnvarchar1000 Allow NULL? 
11workBlockWork Blocknvarchar1000 Allow NULL? 
12workZipWork Zip Codenvarchar200 Allow NULL? 
13workCityWork Citynvarchar1000 Allow NULL? 
14workCountyWork Countynvarchar1000 Allow NULL? 
15workCountrWork Countrynvarchar30OCRY Allow NULL? 
16workStateWork Statenvarchar30 Allow NULL? 
17managerManagerint110OHEM Allow NULL? 
18userIdUser IDint110OUSR Allow NULL? 
19salesPrsonSales Employeeint110OSLP Allow NULL? 
20officeTelOffice Phonenvarchar200 Allow NULL? 
21officeExtOffice Ext.nvarchar200 Allow NULL? 
22mobileMobile Phonenvarchar200 Allow NULL? 
23pagerPagernvarchar200 Allow NULL? 
24homeTelHome Phonenvarchar200 Allow NULL? 
25faxFaxnvarchar200 Allow NULL? 
26emailE-Mailnvarchar1000 Allow NULL? 
27startDateStart Datedate80
28statusStatusint110OHST Allow NULL? 
29salarySalarynum196 Allow NULL? 
30salaryUnitSalary Unitchar10MB=Biweekly, D=Day, H=Hour, M=Month, S=Semimonthly, W=Week, Y=Year Allow NULL? 
31emplCostEmployee Costsnum196 Allow NULL? 
32empCostUntEmployee Cost Unitchar10MD=Day, H=Hour, M=Month, W=Week, Y=Year Allow NULL? 
33termDateTermination Datedate80
34termReasonTermination Reasonint110OHTR Allow NULL? 
35bankCodeBank Codenvarchar300ODSC Allow NULL? 
36bankBranchBank Branchnvarchar1000 Allow NULL? 
37bankBranNoBank Branch No.nvarchar300 Allow NULL? 
38bankAcountBank Accountnvarchar1000 Allow NULL? 
39homeStreetHome Streetnvarchar1000 Allow NULL? 
40homeBlockHome Blocknvarchar1000 Allow NULL? 
41homeZipHome Zip Codenvarchar200 Allow NULL? 
42homeCityHome Citynvarchar1000 Allow NULL? 
43homeCountyHome Countynvarchar1000 Allow NULL? 
44homeCountrHome Countrynvarchar30OCRY Allow NULL? 
45homeStateHome Statenvarchar30 Allow NULL? 
46birthDateDate of Birthdate80
47brthCountrCountry of Birthnvarchar30OCRY Allow NULL? 
48martStatusMarital Statuschar10SD=Divorced, M=Married, N=Not Specified, S=Single, W=Widowed Allow NULL? 
49nChildrenNo. of Childrenint60 Allow NULL? 
50govIDID Issued by Authoritiesnvarchar640 Allow NULL? 
51citizenshpCitizenshipnvarchar30OCRY Allow NULL? 
52passportNoPassport No.nvarchar640 Allow NULL? 
53passportExPassport Expiration Datedate80
54picturePicturenvarchar2000 Allow NULL? 
57salaryCurrSalary Currencynvarchar30 Allow NULL? 
58empCostCurEmployee Costs Currencynvarchar30 Allow NULL? 
59WorkBuildWork Building/Floor/Roomtext160
60HomeBuildHome Building/Floor/Roomtext160
61positionPositionint110OHPS Allow NULL? 
62AtcEntryAttachment Entryint110 Allow NULL? 
63AddrTypeWWork Address Typenvarchar1000 Allow NULL? 
64AddrTypeHHome Address Typenvarchar1000 Allow NULL? 
65StreetNoWWork Street No.nvarchar1000 Allow NULL? 
66StreetNoHHome Street No.nvarchar1000 Allow NULL? 
67DispMidNamDisplay Middle Namechar10NN=No, Y=Yes Allow NULL? 
68NamePosName Positioning Setchar1011=Last Name, First Name, 2=First Name, Last Name Allow NULL? 
69DispCommaDisplay Commachar10NN=No, Y=Yes Allow NULL? 
70CostCenterCost Centernvarchar80OPRC Allow NULL? 
71CompanyNumCompany Numbernvarchar200 Allow NULL? 
72VacPreYearVacation: Previous Yearint110 Allow NULL? 
73VacCurYearVacation: Current Yearint110 Allow NULL? 
74MunKeyMunicipality Keynvarchar200 Allow NULL? 
75TaxClassTax Classnvarchar2000, 1=Tax Class I, 2=Tax Class II, 3=Tax Class III, 4=Tax Class IV, 5=Tax Class V, 6=Tax Class VI Allow NULL? 
76InTaxLiabiIncome Tax Liabilitynvarchar2000, 1=On Tax Card, 2=Flat-Rate Tax, 3=Cross-Border Employee, 4=Not Liable Allow NULL? 
77EmTaxCCodeConfessionnvarchar900--=No Church Tax Liability, 0, AK=(AK) Old Catholic, EV=(EV) Protestant, FA=(FA) Non-Denomination Alzey, FB=(FB) Non-Denominational Regional Congregation Baden, FG=(FG) Non-Denominational Regional Congregation Palatinate, FM=(FM) Non-Denominational Congregation Mainz, FR=(FR) French-Reformed, FS=(FS) Non-Denominational Congregation Offenba Allow NULL? 
78RelPartnerConfession of Partnernvarchar900--=No Church Tax Liability, 0, AK=(AK) Old Catholic, EV=(EV) Protestant, FA=(FA) Non-Denomination Alzey, FB=(FB) Non-Denominational Regional Congregation Baden, FG=(FG) Non-Denominational Regional Congregation Palatinate, FM=(FM) Non-Denominational Congregation Mainz, FR=(FR) French-Reformed, FS=(FS) Non-Denominational Congregation Offenba Allow NULL? 
79ExemptAmntExemption Amountnum196 Allow NULL? 
80ExemptUnitExemption Amount Periodnvarchar20000, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily Allow NULL? 
81AddiAmntAdditional Amountnum196 Allow NULL? 
82AddiUnitAdditional Amount Periodnvarchar20000, 1=Yearly, 2=Monthly, 3=Weekly, 4=Daily Allow NULL? 
83TaxONameTax Office Namenvarchar500 Allow NULL? 
84TaxONumTax Office Numbernvarchar200 Allow NULL? 
85HeaInsNameHealth Insurance Company Namenvarchar500 Allow NULL? 
86HeaInsCodeHealth Insurance Codenvarchar500 Allow NULL? 
87HeaInsTypeType of Health Insurancenvarchar200, AOK=(AOK), BKK=(BKK), BKS=(BKS), EKK=(EKK), IKK=(IKK), LKK=(LKK) Allow NULL? 
88SInsurNumSocial Insurance Numbernvarchar200 Allow NULL? 
89StatusOfPProfessional Statusnvarchar20-1-1, 0=Trainee, 1=Worker, 2=Skilled Worker, 3=Supervisor/Foreman, 4=Office Worker, 5=Youth Help/Sheltered Workshop, 6=On Career Advancement Training, 7=Homeworker, 8=Part Time, 9=Part Time > 18 Hrs Allow NULL? 
90StatusOfEEducational Statusnvarchar2000, 1=W/o Professional Qualification, 2=W. Professional Qualification, 3=High School w/o Prof. Qualif., 4=High School w. Prof. Qualific., 5=Vocational Qualification, 6=University, 7=Not Possible to Specify Allow NULL? 
91BCodeDateVBank Code for DATEVnvarchar200 Allow NULL? 
92DevBAOwnerDeviating Bank Account Ownerchar10NN=No, Y=Yes Allow NULL? 
93FNameSPFirst Name of Spousenvarchar500 Allow NULL? 
94SurnameSPLast Name of Spousenvarchar500 Allow NULL? 
95LogInstancLog Instanceint1100 Allow NULL? 
96UserSignUser Signatureint60OUSR Allow NULL? 
97UserSign2Updating Userint60OUSR Allow NULL? 
98UpdateDateUpdate Datedate80
99PersGroupPerson Groupnvarchar50-1-1, 101=Subject to Social Insurance, 102=Apprentice, 104=Home Worker, 105=Trainee, 106=Student, 108=Early Retirement, 109=Part-Time Employee, 110=Short-Term Employee, 112=Family Member: Agriculture, 113=Addnl Income: Agriculture, 114=Addnl Income: Seasonal Agriculture, 116=Receiving Compensation Pay, 118=Irregularly Employed, 119=Pensioner Allow NULL? 
100JTCodeJob Title Codenvarchar50 Allow NULL? 
101ExtEmpNoExt. Employee No.nvarchar200 Allow NULL? 
102BirthPlacePlace of Birthnvarchar1000 Allow NULL? 
103PymMethPayment Methodnvarchar2005-1, 05=Bank Transfer Allow NULL? 
104ExemptCurrExemption Amount Currencynvarchar30 Allow NULL? 
105AddiCurrAdditional Amount Currencynvarchar30 Allow NULL? 
106STDCodeSTD Codeint110 Allow NULL? 
107FatherNameFather's Namenvarchar1500 Allow NULL? 
108CPFPersonal Fiscal IDnvarchar1000 Allow NULL? 
109CRCCRC Numbernvarchar200 Allow NULL? 
110ContRespAccountant Responsiblechar10NN=No, Y=Yes Allow NULL? 
111RepLegalLegal Representativechar10NN=No, Y=Yes Allow NULL? 
112DirfDeclarDIRF Responsiblechar10NN=No, Y=Yes Allow NULL? 
113UF_CRCCRC Statenvarchar30 Allow NULL? 
114IDTypeID Typenvarchar300OIDT Allow NULL? 
115ActiveEmployee Statuschar10YN=Inactive, Y=Active Allow NULL? 
116BPLIdBranchint110OBPL Allow NULL? 
117ManualNUMManual EMP No.nvarchar600 Allow NULL? 
118PassIssuePassport Issue Datedate80
119PassIssuerPassport Issuernvarchar2540 Allow NULL? 
120QualCodeQualification Codenvarchar30000000=n/a, 203=Diretor, 204=Conselheiro de Administração, 205=Administrador, 206=Administrador do Grupo, 207=Administrador de Sociedade Filiada, 220=Administrador Judicial - Pessoa Fisica, 222=Administrador Judicial - Pessoa Juridica - profissional responsável, 223=Administrador Judicial / Gestor, 226=Gestor Judicial, 309=Procurador, 312=Inv Allow NULL? 
121PRWebAccssEnable Access to PR from Webchar10NN=No, Y=Yes Allow NULL? 
122PrePRWebPrevious Stats of PR Web Accesschar10NN=No, Y=Yes Allow NULL? 
123BPLinkBP Linknvarchar150OCRD Allow NULL? 
124NaturalPerNatural Personchar10NN=No, Y=Yes Allow NULL? 
125DPPStatusData Protection Statuschar10NB=Blocked, D=Erased, N=None, U=Unblocked Allow NULL? 
126EnRligionEncryption of Religiontext160
127EnRligionPEncryption of Religion Partnertext160
128EncryptIVEncrypt IVnvarchar1000 Allow NULL? 
129EnGovIDEncryption of Government IDtext160
130EnPassportEncryption of Passport No.text160
131CreateDateCreation Datedate80
132CreateTSCreation Time Incl. Sec.int110 Allow NULL? 
133UpdateTSUpdate Full Timeint110 Allow NULL? 
134EnInsurNumEncryption of Social Insurance No.text160
135EnBnkAcctEncryption of Bank Accounttext160


NAMENoNofirstName, middleName, lastName