|
|
DTW Business Partners / Activity / Activities
API Activities Service / Activity
OCLG - Activities Table
Activity Activity Object· Table: OCLG
Parent: Activities Service ActivitiesService Service· Table: OCLG
Activity Instance Params ActivityInstanceParams Object· Table: OCLG Parent: Activities Service ActivitiesService Service· Table: OCLG
Activity Params ActivityParams Object· Table: OCLG Parent: Activities Service ActivitiesService Service· Table: OCLG
Activities Service ActivitiesService Service· Table: OCLG
Contacts Contacts Object· Table: OCLG
OCLG SQL Table
Users OUSR SQL Table
Employees OHEM SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Activity Subjects OCLS SQL Table
Activity Types OCLT SQL Table
Countries OCRY SQL Table
Meetings Location OCLO SQL Table
Sales Employee OSLP SQL Table
States OCST SQL Table
Activity Status OCLA SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ClgCode KEY UNIQUE | Activity Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| CardCode KEY | BP Code | nVarChar | 15 | OCRD Business Partner | CRD_CODE | No | ||
| Notes | Remarks | Text | 16 | |||||
| CntctDate | System Date | Date | 8 | |||||
| CntctTime | Time | Int | 11 | |||||
| Recontact | Activity Date | Date | 8 | |||||
| Closed | Closed Activity | VarChar | Y) Yes N) No | 1 | N | |||
| CloseDate | Closing Date | Date | 8 | |||||
| ContactPer | Contact Person Name | nVarChar | 90 | |||||
| Tel | Telephone | nVarChar | 20 | |||||
| Fax | Fax | nVarChar | 20 | |||||
| CntctSbjct | Activity Subject | Int | 6 | OCLS Activity Subjects | -1 | |||
| Transfered | Transfered to Next Year | VarChar | Y) Yes N) No | 1 | N | |||
| DocType | Linked Document | nVarChar | 13) A/R Invoice 14) A/R Credit Memo 15) Delivery 16) Return 17) Sales Order 18) A/P Invoice 19) A/P Credit Memo 20) Goods Receipt PO 21) Goods Return 22) Purchase order 23) Sales Quotation 24) Incoming Payment 25) Deposit 30) Journal Entry 46) Outgoing Payment 57) Checks for Payment 59) Goods Receipt 60) Goods Issue 1250000001) Inventory Transfer Request 67) Inventory Transfer 68) Work Order 69) Landed Costs 132) Correction Invoice 162) Material Revaluation 202) Production Order 203) A/R Down Payment 204) A/P Down Payment 140000009) Outgoing Excise Invoice 140000010) Incoming Excise Invoice -1) 0 4) Items 163) A/P Correction Invoice 164) A/P Correction Invoice Reversal 165) A/R Correction Invoice 166) A/R Correction Invoice Reversal 1320000012) Campaign 540000006) Purchase Quotation 1250000025) Blanket Agreements 1470000113) Purchase Request | 20 | -1 | |||
| DocNum | Linked Document Number | nVarChar | 20 | |||||
| DocEntry | Linked Document Entry | nVarChar | 20 | |||||
| Attachment | Attachment | Text | 16 | |||||
| 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 | |||
| AttendUser | Dealt by | Int | 6 | OUSR Users | ||||
| CntctCode | Contact Person | Int | 11 | OCPR Contact Persons | ||||
| UserSign | User Signature | Int | 6 | |||||
| SlpCode | Sales Employee | Int | 11 | OSLP Sales Employee | -1 | |||
| Action | Activity | VarChar | C) Phone Call M) Meeting T) Task E) Note P) Campaign N) Other | 1 | C | |||
| Details | Details | nVarChar | 100 | |||||
| CntctType | Activity Type | Int | 6 | OCLT Activity Types | -1 | |||
| Location | Location | Int | 6 | OCLO Meetings Location | -1 | |||
| BeginTime | Start Time | Int | 11 | |||||
| Duration | Activity Duration | Num | 20 | |||||
| DurType | Duration UoM | VarChar | M) Minutes H) Hours D) Days | 1 | M | |||
| ENDTime | End Time | Int | 11 | |||||
| Priority | Priority | VarChar | 0 1) Normal 2) High | 1 | 1 | |||
| Reminder | Reminder | VarChar | Y) Yes N) No | 1 | N | |||
| RemQty | Reminder Quantity | Num | 20 | |||||
| RemType | Reminder Units | VarChar | M) Minutes H) Hours D) Days | 1 | M | |||
| OprId KEY | Opportunity - Key | Int | 11 | OPPORT | No | |||
| OprLine | Row No. - Opportunity | Int | 6 | |||||
| RemDate | Reminder Date | Date | 8 | |||||
| RemTime | Reminder Time | Int | 6 | |||||
| RemSented | Reminder Was Sent | VarChar | Y) Yes N) No | 1 | N | |||
| Instance | Instance | Int | 6 | 0 | ||||
| endDate | End/Due Date | Date | 8 | |||||
| status | Status | Int | 11 | OCLA Activity Status | ||||
| personal | Personal Flag | VarChar | Y) Yes N) No | 1 | N | |||
| inactive | Inactive Flag | VarChar | Y) Yes N) No | 1 | N | |||
| tentative | Tentative Flag | VarChar | Y) Yes N) No | 1 | N | |||
| street | Street | nVarChar | 100 | |||||
| city | City | nVarChar | 100 | |||||
| country | Country | nVarChar | 3 | OCRY Countries | ||||
| state | State | nVarChar | 3 | OCST States | ||||
| room | Room | nVarChar | 50 | |||||
| parentType | Parent Object Type | nVarChar | 20 | |||||
| parentId | Parent Object ID | Int | 11 | |||||
| prevActvty | Previous Activity | Int | 11 | |||||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| RecurPat | Recurrence Pattern | VarChar | N) None D) Daily W) Weekly M) Monthly A) Annually | 1 | N | |||
| EndType | Recurrence End Type | VarChar | N) No End Date C) By Counter D) By Date | 1 | N | |||
| SeStartDat | Series Start Date | Date | 8 | |||||
| SeEndDat | Series End Date | Date | 8 | |||||
| MaxOccur | Max Occurrences | Int | 11 | |||||
| Interval | Interval | Int | 11 | 1 | ||||
| Sunday | Sunday | VarChar | N) No Y) Yes | 1 | N | |||
| Monday | Monday | VarChar | N) No Y) Yes | 1 | N | |||
| Tuesday | Tuesday | VarChar | N) No Y) Yes | 1 | N | |||
| Wednesday | Wednesday | VarChar | N) No Y) Yes | 1 | N | |||
| Thursday | Thursday | VarChar | N) No Y) Yes | 1 | N | |||
| Friday | Friday | VarChar | N) No Y) Yes | 1 | N | |||
| Saturday | Saturday | VarChar | N) No Y) Yes | 1 | N | |||
| SubOption | Suboption | VarChar | 1) Option 1 2) Option 2 | 1 | 1 | |||
| DayInMonth | Repeat Day in Month | Int | 11 | |||||
| Month | Repeat Month | Int | 11 | |||||
| DayOfWeek | Repeat Day of Week | Int | 11 | |||||
| Week | Repeat Week in Month | Int | 1) first 2) second 3) third 4) fourth 5) last | 11 | ||||
| SeriesNum | Series Number | Int | 11 | |||||
| OrigDate | Original Date | Date | 8 | |||||
| IsRemoved | Removed Flag | VarChar | N) No Y) Yes | 1 | N | |||
| LastRemind | Last Reminder Date | Date | 8 | |||||
| AssignedBy | Assigned By | Int | 6 | OUSR Users | ||||
| AddrName | Address Name | nVarChar | 50 | |||||
| AddrType | Address Type | VarChar | S) Ship To B) Bill to | 1 | S | |||
| AttendEmpl | Dealt by Employee | Int | 11 | OHEM Employees | ||||
| NextDate | Date of Next Occurrence | Date | 8 | |||||
| NextTime | Time of Next Occurrence | Int | 6 |
Table relationship map
SELECT statement
SELECT
OCLG.ClgCode AS 'Activity Number',
OCLG.CardCode AS 'BP Code',
OCLG.Notes AS 'Remarks',
OCLG.CntctDate AS 'System Date',
OCLG.CntctTime AS 'Time',
OCLG.Recontact AS 'Activity Date',
OCLG.Closed AS 'Closed Activity',
OCLG.CloseDate AS 'Closing Date',
OCLG.ContactPer AS 'Contact Person Name',
OCLG.Tel AS 'Telephone',
OCLG.Fax AS 'Fax',
OCLG.CntctSbjct AS 'Activity Subject',
OCLG.Transfered AS 'Transfered to Next Year',
OCLG.DocType AS 'Linked Document',
OCLG.DocNum AS 'Linked Document Number',
OCLG.DocEntry AS 'Linked Document Entry',
OCLG.Attachment AS 'Attachment',
OCLG.DataSource AS 'Data Source',
OCLG.AttendUser AS 'Dealt by',
OCLG.CntctCode AS 'Contact Person',
OCLG.UserSign AS 'User Signature',
OCLG.SlpCode AS 'Sales Employee',
OCLG.Action AS 'Activity',
OCLG.Details AS 'Details',
OCLG.CntctType AS 'Activity Type',
OCLG.Location AS 'Location',
OCLG.BeginTime AS 'Start Time',
OCLG.Duration AS 'Activity Duration',
OCLG.DurType AS 'Duration UoM',
OCLG.ENDTime AS 'End Time',
OCLG.Priority AS 'Priority',
OCLG.Reminder AS 'Reminder',
OCLG.RemQty AS 'Reminder Quantity',
OCLG.RemType AS 'Reminder Units',
OCLG.OprId AS 'Opportunity - Key',
OCLG.OprLine AS 'Row No. - Opportunity',
OCLG.RemDate AS 'Reminder Date',
OCLG.RemTime AS 'Reminder Time',
OCLG.RemSented AS 'Reminder Was Sent',
OCLG.Instance AS 'Instance',
OCLG.endDate AS 'End/Due Date',
OCLG.status AS 'Status',
OCLG.personal AS 'Personal Flag',
OCLG.inactive AS 'Inactive Flag',
OCLG.tentative AS 'Tentative Flag',
OCLG.street AS 'Street',
OCLG.city AS 'City',
OCLG.country AS 'Country',
OCLG.state AS 'State',
OCLG.room AS 'Room',
OCLG.parentType AS 'Parent Object Type',
OCLG.parentId AS 'Parent Object ID',
OCLG.prevActvty AS 'Previous Activity',
OCLG.AtcEntry AS 'Attachment Entry',
OCLG.RecurPat AS 'Recurrence Pattern',
OCLG.EndType AS 'Recurrence End Type',
OCLG.SeStartDat AS 'Series Start Date',
OCLG.SeEndDat AS 'Series End Date',
OCLG.MaxOccur AS 'Max Occurrences',
OCLG.Interval AS 'Interval',
OCLG.Sunday AS 'Sunday',
OCLG.Monday AS 'Monday',
OCLG.Tuesday AS 'Tuesday',
OCLG.Wednesday AS 'Wednesday',
OCLG.Thursday AS 'Thursday',
OCLG.Friday AS 'Friday',
OCLG.Saturday AS 'Saturday',
OCLG.SubOption AS 'Suboption',
OCLG.DayInMonth AS 'Repeat Day in Month',
OCLG.Month AS 'Repeat Month',
OCLG.DayOfWeek AS 'Repeat Day of Week',
OCLG.Week AS 'Repeat Week in Month',
OCLG.SeriesNum AS 'Series Number',
OCLG.OrigDate AS 'Original Date',
OCLG.IsRemoved AS 'Removed Flag',
OCLG.LastRemind AS 'Last Reminder Date',
OCLG.AssignedBy AS 'Assigned By',
OCLG.AddrName AS 'Address Name',
OCLG.AddrType AS 'Address Type',
OCLG.AttendEmpl AS 'Dealt by Employee',
OCLG.NextDate AS 'Date of Next Occurrence',
OCLG.NextTime AS 'Time of Next Occurrence'
FROM OCLG AS OCLG
Related information
Activity Activity Object· Table: OCLG
Activities refer to interactions you have with business partners, such as phone calls, meetings, tasks, and so on. All activities are automatically recorded in your calendar and in activity reports.
In phone calls, meetings, and tasks, you can...
Parent: Activities Service ActivitiesService Service· Table: OCLG Activity Instance Params ActivityInstanceParams Object· Table: OCLG
Holds the key and date of an instance in a recurring activity.
This object is used to pass keys to and retrieve keys from ActivitiesService methods.
Source table: OCLG.
Parent: Activities Service ActivitiesService Service· Table: OCLG Activity Params ActivityParams Object· Table: OCLG
Holds the key of an activity.
This object is used to pass keys to and retrieve keys from ActivitiesService methods.
Source table: OCLG.
Parent: Activities Service ActivitiesService Service· Table: OCLG Activities Service ActivitiesService Service· Table: OCLG
The ActivitiesService service enables you to add, look up, remove, and update single activities and recurring activities.
Source table: OCLG.
Contacts Contacts Object· Table: OCLG
Contacts is a business object that represents the activities with customers and vendors in the Business Partners module.
This object enables you to:
Add an activity.
Retrieve an activity by its key.
Update an activity.
Save the object...
OCLG SQL Table
Users OUSR SQL Table
Employees OHEM SQL Table
Business Partner OCRD SQL Table
Contact Persons OCPR SQL Table
Activity Subjects OCLS SQL Table
Activity Types OCLT SQL Table
Countries OCRY SQL Table
Meetings Location OCLO SQL Table
Sales Employee OSLP SQL Table
States OCST SQL Table
Activity Status OCLA SQL Table
ActivitiesService
Object
Activity
Enumeration
Method
Property
Activity
DTW DB
ActivityCode
DTW DB
ActivityDate
DTW DB
ActivityTime
DTW DB
ActivityType
DTW DB
AddressName
DTW DB
AddressType
DTW DB
AttachmentEntry
DTW DB
BelongedSeriesNum
DTW DB
CardCode
DTW DB
City
DTW DB
Closed
DTW DB
CloseDate
DTW DB
ContactPersonCode
DTW DB
Country
DTW DB
Details
DTW DB
DocEntry
DTW DB
DocNum
DTW DB
DocType
DTW DB
DocTypeEx
DTW DB
Duration
DTW DB
DurationType
DTW DB
EndDuedate
DTW DB
EndTime
DTW DB
endType
DTW DB
Fax
DTW DB
Friday
DTW DB
HandledBy
DTW DB
HandledByEmployee
DTW DB
Inactiveflag
DTW DB
Interval
DTW DB
IsRemoved
DTW DB
Location
DTW DB
MaxOccurrence
DTW DB
Monday
DTW DB
Notes
DTW DB
ParentobjectId
DTW DB
Parentobjecttype
DTW DB
Personalflag
DTW DB
Phone
DTW DB
PreviousActivity
DTW DB
Priority
DTW DB
RecurrenceDayInMonth
DTW DB
RecurrenceDayOfWeek
DTW DB
RecurrenceMonth
DTW DB
RecurrencePattern
DTW DB
RecurrenceSequenceSpecifier
DTW DB
Reminder
DTW DB
ReminderPeriod
DTW DB
ReminderType
DTW DB
RepeatOption
DTW DB
Room
DTW DB
SalesEmployee
DTW DB
SalesOpportunityId
DTW DB
SalesOpportunityLine
DTW DB
Saturday
DTW DB
SeriesEndDate
DTW DB
SeriesStartDate
DTW DB
StartDate
DTW DB
StartTime
DTW DB
State
DTW DB
Status
DTW DB
Street
DTW DB
Subject
DTW DB
Sunday
DTW DB
Tentativeflag
DTW DB
Thursday
DTW DB
Tuesday
DTW DB
Wednesday
DTW DB
Enumeration
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
