SAP ABAP Table CRMXIF_BT_ACTIVITY_ITEM (XIF Activity Item)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BF-XIF (Application Component) External Interfaces: Basic Functions
⤷ CRMXIF_DDIC (Package) DDIC Objects for External Interfaces
⤷ CRM-BF-XIF (Application Component) External Interfaces: Basic Functions
⤷ CRMXIF_DDIC (Package) DDIC Objects for External Interfaces
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMXIF_BT_ACTIVITY_ITEM | Table Relationship Diagram |
Short Description | XIF Activity Item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | UI Business Transaction: Item, General Data | |||||
2 | OBJECT_TASK | CRMXIF_BT_ITEM_TASK | CRMXIF_BT_OBJECT_TASK | CHAR | 1 | 0 | IF Business Transaction: Method Flag Item | ||
3 | .INCLUDE | 0 | 0 | UI Business Transaction: Item, General Data | |||||
4 | ITEM_GUID | CRMXIF_ITEM_GUID | SYSUUID_C | CHAR | 32 | 0 | Item GUID for External Interface | ||
5 | ITEM_NUMBER | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
6 | ITEM_NUMBER_EXT | CRMT_ITEM_NO_EXT | NUMC | 10 | 0 | External Item Number | |||
7 | CREATED_AT | CRMT_CREATED_AT | BCOS_TSTMP | DEC | 15 | 0 | Transaction was Created at this Time | ||
8 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
9 | CHANGED_AT | CRMT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Time of Last Change to the Transaction | ||
10 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
11 | OBJECT_TYPE | CRMT_SWO_OBJTYP_PROCESS_ITEM | CRM_OJ_NAME_PROCESS_ITEM | CHAR | 10 | 0 | CRM Item Object Type | CRMC_SUBOB_CAT_I | |
12 | ITEM_TYPE | CRMT_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | CRMC_ITEM_TYPE | |
13 | PARENT_ITEM | CRMXIF_ITEM_GUID | SYSUUID_C | CHAR | 32 | 0 | Item GUID for External Interface | ||
14 | NUMBER_PARENT | CRMT_ITEM_NO_PARENT | CRM_ITEM_NO | NUMC | 10 | 0 | Higher-Level Item Number in Transaction | ||
15 | ALTERNATIVE_ITEM | CRMXIF_ITEM_GUID | SYSUUID_C | CHAR | 32 | 0 | Item GUID for External Interface | ||
16 | NUMBER_ALTERN | CRMT_ITEM_NO_ALTERNATIVE | CRM_ITEM_NO | NUMC | 10 | 0 | Item for Which This Item is an Alternative in the Document | ||
17 | ITEM_LANGUAGE | CRMT_ITEM_LANGU | SYLANGU | LANG | 1 | 0 | Short Text Language for an Item | ||
18 | ITEM_LANGUAGE_ISO | CRMXIF_LANGUAGE_ISO | LAISO | CHAR | 2 | 0 | Language Key (ISO) | ||
19 | ORDER_DATE | CRMT_ORDER_DATE | BCOS_TSTMP | DEC | 15 | 0 | Posting Date | ||
20 | SUBSTITUT_REASON | CRMT_ITEM_SUBSTITUTION | CRM_ITEM_SUBSTITUTION | CHAR | 4 | 0 | Reason for Product Substitution | * | |
21 | ITEM_USAGE | CRMT_ITEM_USAGE | CRM_ITEM_USAGE | CHAR | 2 | 0 | Usage of Higher-Level Item | ||
22 | ITEM_TYPE_USAGE | CRMT_IT_TYPE_USAGE | CRM_IT_TYPE_USAGE | CHAR | 4 | 0 | Item Category Usage | * | |
23 | ORDERED_PRODUCT | CRMT_ORDERED_PROD | CRM_ORDERED_PROD | CHAR | 54 | 0 | Product Name Entered | ||
24 | PRODUCT_DESCRIPTION | COMT_PRSHTEXTX | PRSHTEXT40 | CHAR | 40 | 0 | Product Description | ||
25 | PRODUCT_GTIN | COMT_GTIN | COM_GTIN | CHAR | 40 | 0 | Global Trade Item Number (GTIN) | ||
26 | DESCRIPTION_UC | COMT_PRSHTEXTG | PRSHTEXTG40 | CHAR | 40 | 0 | Product Description in Uppercase for F4 Help | ||
27 | .INCLUDE | 0 | 0 | Reference to Product for External Interfaces | |||||
28 | PRODUCT_GUID | CRMXIF_PRODUCT_GUID | SYSUUID_C | CHAR | 32 | 0 | Product Number (Internal) | ||
29 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
30 | PRODUCT_ID_40 | COMT_ALTID_VALUE_UI | COM_ALTID_VALUE_SHORT | CHAR | 54 | 0 | Value of a Product ID or Individual Object | ||
31 | PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | PRSHTEXT40 | CHAR | 40 | 0 | Product Number of Business Partner | ||
32 | .INCLUDE | 0 | 0 | UI Business Transaction: Item, General Data | |||||
33 | PRODUCT_KIND | CRMT_PRODUCT_KIND | CRM_PRODUCT_KIND | CHAR | 1 | 0 | Technnical Type of Product | ||
34 | CAT_ID | COMT_CATALOG | COM_CATALOG | CHAR | 2 | 0 | Catalog | * | |
35 | PRODUCT_DATA | CRMXIF_PRODUCT_I_X | STRU | 0 | 0 | ||||
36 | DATA | CRMXIF_PRODUCT_I | STRU | 0 | 0 | ||||
37 | .INCLUDE | 0 | 0 | IF Business Transaction: Item Product Data | |||||
38 | GROSS_WEIGHT | CRMT_GROSS_WEIGHT | MENG15 | QUAN | 15 | 3 | Gross Weight | ||
39 | NET_WEIGHT | CRMT_NET_WEIGHT | MENG15 | QUAN | 15 | 3 | Net Weight | ||
40 | WEIGHT_UNIT | COMT_WEIGHT_UNIT | MEINS | UNIT | 3 | 0 | Weight Unit | ||
41 | WEIGHT_UNIT_ISO | CRMXIF_UNIT_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of Measurement (IS0) | ||
42 | VOLUME | CRMT_VOLUME | MENG15 | QUAN | 15 | 3 | Volume Occupied by the Product per Volume Unit | ||
43 | VOLUME_UNIT | COMT_VOLUME_UNIT | MEINS | UNIT | 3 | 0 | Unit for the Volume of a Product | ||
44 | VOLUME_UNIT_ISO | CRMXIF_UNIT_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of Measurement (IS0) | ||
45 | PRICE_PRODUCT | CRMT_PRICE_PRODUCT | SYSUUID | RAW | 16 | 0 | Pricing Reference Product Globally Unique Identifier | ||
46 | PRICE_PRODUCT_ID | CRMT_PRICE_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Pricing Reference Product | ||
47 | PROCESS_QTY_NUM | CRMT_PROCESS_QTY_NUM | CRM_PROCESS_QTY_NUM | INT4 | 10 | 0 | Numerator (factor) for conversion trans. quantity in BME | ||
48 | PROCESS_QTY_DEN | CRMT_PROCESS_QTY_DEN | CRM_PROCESS_QTY_DEN | INT4 | 10 | 0 | Denominator (factor) for conversion trans. quantity in BME | ||
49 | EXPONENT10 | CRMT_EXPONENT10 | CRM_EXPONENT10 | INT2 | 5 | 0 | 10 Exponent for Quantity Conversion | ||
50 | PROCESS_QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | ||
51 | PROCESS_QTY_UNIT_ISO | CRMXIF_UNIT_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of Measurement (IS0) | ||
52 | COMM_GROUP | CRMT_COMM_GROUP | CRM_COMM_GROUP | CHAR | 2 | 0 | Commission Group | ||
53 | REBATE_GROUP | CRMT_REBATE_GROUP | CRM_REBATE_GROUP | CHAR | 2 | 0 | Volume Rebate Group | ||
54 | CASH_DISC | CRMT_CASH_DISC | XFELD | CHAR | 1 | 0 | Specifies Whether a Cash Discount Can Be Given for the Prod. | ||
55 | PROD_PR_GROUP | CRMT_PROD_PR_GROUP | CRM_PROD_PR_GROUP | CHAR | 2 | 0 | Product Group | ||
56 | PRC_GROUP1 | CRMT_PRC_GROUP1 | CRM_PRC_GROUP1 | CHAR | 3 | 0 | Product Group 1 | ||
57 | PRC_GROUP2 | CRMT_PRC_GROUP2 | CRM_PRC_GROUP2 | CHAR | 3 | 0 | Product Group 2 | ||
58 | PRC_GROUP3 | CRMT_PRC_GROUP3 | CRM_PRC_GROUP3 | CHAR | 3 | 0 | Product Group 3 | ||
59 | PRC_GROUP4 | CRMT_PRC_GROUP4 | CRM_PRC_GROUP4 | CHAR | 3 | 0 | Product Group 4 | ||
60 | PRC_GROUP5 | CRMT_PRC_GROUP5 | CRM_PRC_GROUP5 | CHAR | 3 | 0 | Product Group 5 | ||
61 | PROD_HIERARCHY | CRMT_PROD_HIERARCHY | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category | ||
62 | RESID_VALUE_ST | CRMT_RESID_VALUE_ST | CRMT_RESID_VALUE_ST | CHAR | 3 | 0 | Residual Value Strategy | ||
63 | RESID_VALUE_GRP | CRMT_RESID_VALUE_GRP | CRMT_RESID_VALUE_GRP | CHAR | 3 | 0 | Residual Value Curve | ||
64 | BASE_QTY_UNIT | COMT_PRODUCT_BASE_UOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure of Product | ||
65 | BASE_QTY_UNIT_ISO | CRMXIF_UNIT_ISO | ISOCD_UNIT | CHAR | 3 | 0 | Unit of Measurement (IS0) | ||
66 | BATCH_ID | CRMT_BATCH_ID | BATCH_ID | CHAR | 10 | 0 | Batch Number | ||
67 | INT_INSPECTION | CRMT_INT_INSPECTION | CRM_ITEM_INSPECTION | CHAR | 4 | 0 | Internal Quality Inspection | ||
68 | INPUT_FIELDS | CRMXIF_PRODUCT_I_F | STRU | 0 | 0 | ||||
69 | GROSS_WEIGHT | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
70 | NET_WEIGHT | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
71 | WEIGHT_UNIT | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
72 | WEIGHT_UNIT_ISO | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
73 | VOLUME | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
74 | VOLUME_UNIT | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
75 | VOLUME_UNIT_ISO | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
76 | PRICE_PRODUCT | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
77 | PRICE_PRODUCT_ID | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
78 | PROCESS_QTY_NUM | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
79 | PROCESS_QTY_DEN | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
80 | EXPONENT10 | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
81 | PROCESS_QTY_UNIT | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
82 | PROCESS_QTY_UNIT_ISO | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
83 | COMM_GROUP | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
84 | REBATE_GROUP | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
85 | CASH_DISC | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
86 | PROD_PR_GROUP | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
87 | PRC_GROUP1 | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
88 | PRC_GROUP2 | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
89 | PRC_GROUP3 | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
90 | PRC_GROUP4 | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
91 | PRC_GROUP5 | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
92 | PROD_HIERARCHY | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
93 | RESID_VALUE_ST | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
94 | RESID_VALUE_GRP | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
95 | BASE_QTY_UNIT | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
96 | BASE_QTY_UNIT_ISO | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
97 | BATCH_ID | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
98 | INT_INSPECTION | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
99 | DATAX | CRMXIF_BT_UPDATE | BAPIUPDATE | CHAR | 1 | 0 | Information on Changes to Transaction Data Structure/Table | ||
100 | SCHEDULE_LINES | CRMXIF_SCHEDLIN_XT | STRU | 0 | 0 | ||||
101 | DATA | CRMXIF_SCHEDLIN_T | TTYP | 0 | 0 | ||||
102 | DATAX | CRMXIF_BT_UPDATE | BAPIUPDATE | CHAR | 1 | 0 | Information on Changes to Transaction Data Structure/Table | ||
103 | TOTAL_QUANTITY | CRMXIF_SCHEDLIN_I_X | STRU | 0 | 0 | ||||
104 | DATA | CRMXIF_SCHEDLIN_I | STRU | 0 | 0 | ||||
105 | .INCLUDE | 0 | 0 | IF Business Transaction: Item Quantities | |||||
106 | ORDER_QTY | CRMT_QTY_ORDER | MENG13 | QUAN | 13 | 3 | CRM: Order Quantity | ||
107 | CONFIRMED_QTY | CRMT_QTY_CONFIRMED | MENG13 | QUAN | 13 | 3 | CRM: Confirmed Quantity | ||
108 | NUMBER_CONFIRMED | CRMT_SCHEDLIN_COUNT_CONFIRMED | CRM_SCHEDLIN_COUNT | INT2 | 5 | 0 | CRM Number Confirmation Schedule Line | ||
109 | LATEST_TIME_CONF | CRMT_SCHEDLIN_LTIME_CONFIRMED | BCOS_TSTMP | DEC | 15 | 0 | Latest Confirmation Date for an Item | ||
110 | INPUT_FIELDS | CRMXIF_SCHEDLIN_I_F | STRU | 0 | 0 | ||||
111 | ORDER_QTY | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
112 | CONFIRMED_QTY | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
113 | NUMBER_CONFIRMED | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
114 | LATEST_TIME_CONF | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
115 | DATAX | CRMXIF_BT_UPDATE | BAPIUPDATE | CHAR | 1 | 0 | Information on Changes to Transaction Data Structure/Table | ||
116 | ACTIVITY_I | CRMXIF_ACTIVITY_I_X | STRU | 0 | 0 | ||||
117 | DATA | CRMXIF_ACTIVITY_I | STRU | 0 | 0 | ||||
118 | .INCLUDE | 0 | 0 | IF Business Transaction: Activity Journal Item | |||||
119 | DISCUSSED | CRMT_ACT_DISCUSSED | XFLAG | CHAR | 1 | 0 | Discussed | ||
120 | PROD_PRIORITY | CRMT_ACT_PROD_PRIORITY | CRM_ACT_PROD_PRIORITY | CHAR | 4 | 0 | Product Priority | ||
121 | STATUS | CRMT_ACT_PROD_STATUS | CRM_ACT_PROD_STATUS | CHAR | 4 | 0 | Status of documented product | ||
122 | INPUT_FIELDS | CRMXIF_ACTIVITY_I_F | STRU | 0 | 0 | ||||
123 | DISCUSSED | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
124 | PROD_PRIORITY | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
125 | STATUS | BAPIUPDATE | BAPIUPDATE | CHAR | 1 | 0 | Updated information in related user data field | ||
126 | DATAX | CRMXIF_BT_UPDATE | BAPIUPDATE | CHAR | 1 | 0 | Information on Changes to Transaction Data Structure/Table |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMXIF_BT_ACTIVITY_ITEM | ITEM_TYPE | CRMC_ITEM_TYPE | ITM_TYPE | |||
2 | CRMXIF_BT_ACTIVITY_ITEM | OBJECT_TYPE | CRMC_SUBOB_CAT_I | SUBOBJ_CATEGORY |
History
Last changed by/on | SAP | 20100421 |
SAP Release Created in | 400 |