biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Business Partner Master Data / Contact Persons
API Business Partners / Contact Employees
OCPR - Contact Persons Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CntctCode KEY UNIQUEInternal NumberInt
11
PRIMARYYes
CardCode KEY UNIQUEBP CodenVarChar
15OCRD
Business Partner
CARDYes
NameContact Person NamenVarChar
50
PositionPositionnVarChar
90
AddressAddressnVarChar
100
Tel1Telephone 1nVarChar
20
Tel2Telephone 2nVarChar
20
CellolarMobile PhonenVarChar
50
FaxFaxnVarChar
20
E_MailLE-MailnVarChar
100
PagerPagernVarChar
30
Notes1Remark 1nVarChar
100
Notes2Remark 2nVarChar
100
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
PasswordPasswordnVarChar
8
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
11
BirthPlacePlace of BirthnVarChar
100
BirthDateDate of BirthDate
8
GenderGenderVarChar
M) Male
F) Female
E)
1
E
ProfessionProfessionnVarChar
50
updateDateDate of UpdateDate
8
updateTimeUpdate TimeInt
11
TitleTitlenVarChar
10
BirthCityCity of BirthnVarChar
100
ActiveActiveVarChar
Y) Yes
N) No
1
Y
FirstNameFirst NamenVarChar
50
MiddleNameMiddle NamenVarChar
50
LastNameLast NamenVarChar
50
BirthStateState of BirthnVarChar
3OCST
States
ResidCityCity of ResidencenVarChar
100
ResidCntryCountry of ResidencenVarChar
100
ResidStateState of ResidencenVarChar
3OCST
States
NFeRcpnNF-e RecipientVarChar
Y) Yes
N) No
1
N
EmlGrpCodeE-Mail Group CodenVarChar
20OEGP
E-Mail Group
BlockCommBlock Sending MarketingVarChar
N) No
Y) Yes
1
N
FiscalCodeFiscal Code for ResidentnVarChar
16
CtyPrvsYrCity for Previous YearnVarChar
100
SttPrvsYrState for Previous YearnVarChar
3OCST
States
CtyCdPrvsYCity Code for Previous YearnVarChar
4
CtyCurYrCity for Current YearnVarChar
100
SttCurYrState for Current YearnVarChar
3OCST
States
CtyCdCurYrCity Code for Current YearnVarChar
4

Table relationship map

SELECT statement

SELECT OCPR.CntctCode AS 'Internal Number', OCPR.CardCode AS 'BP Code', OCPR.Name AS 'Contact Person Name', OCPR.Position AS 'Position', OCPR.Address AS 'Address', OCPR.Tel1 AS 'Telephone 1', OCPR.Tel2 AS 'Telephone 2', OCPR.Cellolar AS 'Mobile Phone', OCPR.Fax AS 'Fax', OCPR.E_MailL AS 'E-Mail', OCPR.Pager AS 'Pager', OCPR.Notes1 AS 'Remark 1', OCPR.Notes2 AS 'Remark 2', OCPR.DataSource AS 'Data Source', OCPR.UserSign AS 'User Signature', OCPR.Password AS 'Password', OCPR.LogInstanc AS 'Log Instance', OCPR.ObjType AS 'Object Type', OCPR.BirthPlace AS 'Place of Birth', OCPR.BirthDate AS 'Date of Birth', OCPR.Gender AS 'Gender', OCPR.Profession AS 'Profession', OCPR.updateDate AS 'Date of Update', OCPR.updateTime AS 'Update Time', OCPR.Title AS 'Title', OCPR.BirthCity AS 'City of Birth', OCPR.Active AS 'Active', OCPR.FirstName AS 'First Name', OCPR.MiddleName AS 'Middle Name', OCPR.LastName AS 'Last Name', OCPR.BirthState AS 'State of Birth', OCPR.ResidCity AS 'City of Residence', OCPR.ResidCntry AS 'Country of Residence', OCPR.ResidState AS 'State of Residence', OCPR.NFeRcpn AS 'NF-e Recipient', OCPR.EmlGrpCode AS 'E-Mail Group Code', OCPR.BlockComm AS 'Block Sending Marketing', OCPR.FiscalCode AS 'Fiscal Code for Resident', OCPR.CtyPrvsYr AS 'City for Previous Year', OCPR.SttPrvsYr AS 'State for Previous Year', OCPR.CtyCdPrvsY AS 'City Code for Previous Year', OCPR.CtyCurYr AS 'City for Current Year', OCPR.SttCurYr AS 'State for Current Year', OCPR.CtyCdCurYr AS 'City Code for Current Year' FROM OCPR AS OCPR

Related information


Contact Employees ContactEmployees Object· Table: OCPR
ContactEmployees is a business object that represents the contact employees in the Business Partners module. This object enables you to add contact information of employees to the Business Partners master record. Source table: OCPR.
   Parent: Business Partners BusinessPartners Object· Table: OCRD
OCPR SQL Table

States OCST SQL Table

Business Partner OCRD SQL Table

E-Mail Group OEGP SQL Table

Object Settings - History ADP1 SQL Table

Users OUSR SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates