|
|
DTW Business Partners / Business Partner Master Data / Contact Persons
API Business Partners / Contact Employees
OCPR - Contact Persons Table
Contact Employees ContactEmployees Object· 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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CntctCode KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OCRD Business Partner | CARD | Yes | ||
| Name | Contact Person Name | nVarChar | 50 | |||||
| Position | Position | nVarChar | 90 | |||||
| Address | Address | nVarChar | 100 | |||||
| Tel1 | Telephone 1 | nVarChar | 20 | |||||
| Tel2 | Telephone 2 | nVarChar | 20 | |||||
| Cellolar | Mobile Phone | nVarChar | 50 | |||||
| Fax | Fax | nVarChar | 20 | |||||
| E_MailL | nVarChar | 100 | ||||||
| Pager | Pager | nVarChar | 30 | |||||
| Notes1 | Remark 1 | nVarChar | 100 | |||||
| Notes2 | Remark 2 | nVarChar | 100 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| Password | Password | nVarChar | 8 | |||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 11 | |||
| BirthPlace | Place of Birth | nVarChar | 100 | |||||
| BirthDate | Date of Birth | Date | 8 | |||||
| Gender | Gender | VarChar | M) Male F) Female E) | 1 | E | |||
| Profession | Profession | nVarChar | 50 | |||||
| updateDate | Date of Update | Date | 8 | |||||
| updateTime | Update Time | Int | 11 | |||||
| Title | Title | nVarChar | 10 | |||||
| BirthCity | City of Birth | nVarChar | 100 | |||||
| Active | Active | VarChar | Y) Yes N) No | 1 | Y | |||
| FirstName | First Name | nVarChar | 50 | |||||
| MiddleName | Middle Name | nVarChar | 50 | |||||
| LastName | Last Name | nVarChar | 50 | |||||
| BirthState | State of Birth | nVarChar | 3 | OCST States | ||||
| ResidCity | City of Residence | nVarChar | 100 | |||||
| ResidCntry | Country of Residence | nVarChar | 100 | |||||
| ResidState | State of Residence | nVarChar | 3 | OCST States | ||||
| NFeRcpn | NF-e Recipient | VarChar | Y) Yes N) No | 1 | N | |||
| EmlGrpCode | E-Mail Group Code | nVarChar | 20 | OEGP E-Mail Group | ||||
| BlockComm | Block Sending Marketing | VarChar | N) No Y) Yes | 1 | N | |||
| FiscalCode | Fiscal Code for Resident | nVarChar | 16 | |||||
| CtyPrvsYr | City for Previous Year | nVarChar | 100 | |||||
| SttPrvsYr | State for Previous Year | nVarChar | 3 | OCST States | ||||
| CtyCdPrvsY | City Code for Previous Year | nVarChar | 4 | |||||
| CtyCurYr | City for Current Year | nVarChar | 100 | |||||
| SttCurYr | State for Current Year | nVarChar | 3 | OCST States | ||||
| CtyCdCurYr | City Code for Current Year | nVarChar | 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
BusinessPartners
Object
ContactEmployees
Method
Property
Active
DTW DB
Address
DTW DB
CardCode
DTW DB
CityOfBirth
DTW DB
DateOfBirth
DTW DB
E_Mail
DTW DB
Fax
DTW DB
Gender
DTW DB
InternalCode
DB
MobilePhone
DTW DB
Name
DTW DB
Pager
DTW DB
Password
DTW DB
Phone1
DTW DB
Phone2
DTW DB
PlaceOfBirth
DTW DB
Position
DTW DB
Profession
DTW DB
Remarks1
DTW DB
Remarks2
DTW DB
Title
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
