SAP ABAP Table CDBD_ACTIVITY_H (Business Transaktion - Activity segment)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX (Application Component) Business Transactions
⤷ CDB_ORDER (Package) CRM Order: CDB Objects for General Sales Order Processing
⤷ CRM-BTX (Application Component) Business Transactions
⤷ CDB_ORDER (Package) CRM Order: CDB Objects for General Sales Order Processing
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | CDBD_ACTIVITY_H | Table Relationship Diagram |
Short Description | Business Transaktion - Activity segment |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | ACTIVITY_H_GUID | CDBT_ACTIVITY_H_GUID | SYSUUID | RAW | 16 | 0 | Activity Header GUID | ||
3 | ORDERADM_H_GUID | CDBT_ORDERADM_H_GUID | SYSUUID | RAW | 16 | 0 | Order Header Guid | ||
4 | ADR_GUID | CDBT_ADR_GUID | SYSUUID | RAW | 16 | 0 | Guid for ADR(Address table) | ||
5 | .INCLUDE | 0 | 0 | Structure of an Activity - External Fields | |||||
6 | CATEGORY | CRMT_ACTIVITY_CATEGORY | CRM_ACTIVITY_CATEGORY | CHAR | 3 | 0 | Activity Category (Communication Type) | CRMC_ACT_CATEGOR | |
7 | PRIORITY | CRMT_PRIORITY | SC_PRIO | NUMC | 1 | 0 | Activity Priority | SCPRIO | |
8 | OBJECTIVE | CRMT_OBJECTIVE | CRM_OBJECTIVE | CHAR | 3 | 0 | Goal of an Activity | CRMC_ACT_OBJ | |
9 | DIRECTION | CRMT_DIRECTION | CRM_DIRECTION | CHAR | 1 | 0 | Direction of an Activity | ||
10 | EXTERN_ACT_ID | CRMT_EXTERNAL_ACTIVITY_ID | CRM_EXTERNAL_ACTIVITY_ID | CHAR | 20 | 0 | External Business Transaction Number | ||
11 | ADDRESS_ID | CRMT_ADDRESS | AD_ADDRNUM | CHAR | 10 | 0 | Location where Activity takes place | * | |
12 | PRIVATE_FLAG | CRMT_PRIVAT | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Task is Private | ||
13 | COMPLETION | CRMT_COMPLETION | CRM_COMPLETION | NUMC | 3 | 0 | Completion Rate in Percent | ||
14 | ACT_LOCATION | CRMT_ACTIVITY_LCTN | CRM_ACTIVITY_LOCATION | CHAR | 100 | 0 | Location | ||
15 | .INCLUDE | 0 | 0 | EEW Include | |||||
16 | ACTIVITY_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
17 | .INCLUDE | 0 | 0 | ||||||
18 | CALENDAR | CRMT_CALENDAR | CRM_BOOLEAN | CHAR | 1 | 0 | Include Activity in Calendar | ||
19 | ACTIVITY_TASK | CRMT_TASK | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Activity is a Task | ||
20 | CLASS | CRMT_ACTIVITY_CLASS | CRM_ACTIVITY_CLASS | CHAR | 1 | 0 | Activity Class | ||
21 | .INCLUDE | 0 | 0 | Communication Fields for Mobile Sales/Service | |||||
22 | TR_USER | SMO_TR_USR | SMO_TR_USR | CHAR | 32 | 0 | Transaction User | ||
23 | TR_ID | SMO_TR_ID | SMO_TR_ID | CHAR | 32 | 0 | Transaction Identifier | ||
24 | TR_STATUS | SMO_TR_STS | SMO_TR_STS | CHAR | 4 | 0 | Status of Transaction | ||
25 | TIMESTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
26 | DELETED | SMO_DELETD | SMO_DELETD | CHAR | 1 | 0 | Mobile Sales Deleted | ||
27 | TR_ROOTID | SMO_RTGUID | SMO_GUID | CHAR | 32 | 0 | Identifier of BDoc Root object |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CDBD_ACTIVITY_H | CATEGORY | CRMC_ACT_CATEGOR | CATEGORY | |||
2 | CDBD_ACTIVITY_H | OBJECTIVE | CRMC_ACT_OBJ | OBJECTIVE | |||
3 | CDBD_ACTIVITY_H | PRIORITY | SCPRIO | PRIORITY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 30A |