SAP ABAP Table CRMT_BW_SALES_ORDER_I (BW: Datasource for CRM Sales Orders - Item Data)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
⤷ CRM_REPORT (Package) Operative Reporting in CRM
⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
⤷ CRM_REPORT (Package) Operative Reporting in CRM
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BW_SALES_ORDER_I | Table Relationship Diagram |
Short Description | BW: Datasource for CRM Sales Orders - Item Data |
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 | ORDERADM_H Data for BW DataSources | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
4 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
5 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
6 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
7 | DESCRIPTION_UC | CRMT_PROCESS_DESCRIPTION_UC | CRM_PROCESS_DESCRIPTION_UC | CHAR | 40 | 0 | Transaction Description (Upper Case) | ||
8 | DESCR_LANGUAGE | CRMT_PROCESS_DESCRIPTION_LANGU | SPRAS | LANG | 1 | 0 | Language Key of Description | * | |
9 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
10 | OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY | CRM_OJ_NAME_PROCESS | CHAR | 10 | 0 | Business Transaction Category | CRMC_SUBOB_CAT | |
11 | CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
12 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
13 | CHANGED_AT | CRMT_OPPT_CHANGED_AT | DATUM | DATS | 8 | 0 | Time of Last Change to the Transaction | ||
14 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
15 | RECORDMODE | RODMUPDMOD | RODMUPDMOD | CHAR | 1 | 0 | BW Delta Process: Record Mode | ||
16 | NUM_OF_HEAD | CRMT_NUMBER_OF_H | INT4 | INT4 | 10 | 0 | Order Header Number | ||
17 | OCCURRENCE | CRMT_OCC_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
18 | SCENARIO | CRMT_SCENARIO | CRM_SCENARIO | CHAR | 10 | 0 | Scenario Identity | ||
19 | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | CRM_TEMPLATE_TYPE | CHAR | 1 | 0 | Template Type of CRM Transaction | ||
20 | OCCURR_QUOT | CRMT_QUO_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
21 | OCCURR_CONT | CRMT_CON_AT_LEAST_ONCE | CRM_BOOLEAN | CHAR | 1 | 0 | Counter: Document Cat. Appears at Least Once in Document | ||
22 | REF_UPDATE | CRMT_FLG_REF_UPDATE_BW | XFELD | CHAR | 1 | 0 | Flag: Ref. Update (Extract Structure Only Partially Filled) | ||
23 | INPUT_CHANNEL | CRMT_INPUT_CHANNEL | CRM_INPUT_CHANNEL | CHAR | 3 | 0 | Input channel | ||
24 | CREATED_TS | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
25 | CHANGED_TS | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
26 | .INCLUDE | 0 | 0 | ORDERADM_I Data for BW DataSources | |||||
27 | ITEM_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
28 | ITEM_CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
29 | ITEM_CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
30 | ITEM_CHANGED_AT | CRMT_OPPT_CHANGED_AT | DATUM | DATS | 8 | 0 | Time of Last Change to the Transaction | ||
31 | ITEM_CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
32 | ORDER_DATE | CRMT_OPPT_ORDER_DATE | DATUM | DATS | 8 | 0 | Posting Date | ||
33 | NUMBER_INT | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
34 | ITEM_OBJECT_TYPE | CRMT_SWO_OBJTYP_PROCESS_ITEM | CRM_OJ_NAME_PROCESS_ITEM | CHAR | 10 | 0 | CRM Item Object Type | * | |
35 | ITM_TYPE | CRMT_ITEM_TYPE | CRM_ITEM_TYPE | CHAR | 4 | 0 | Item Category | * | |
36 | NUMBER_OF_I | CRMT_NUMBER_OF_I | INT4 | INT4 | 10 | 0 | Order Item Number | ||
37 | BW_ASSIGN | CRMT_BW_ASSIGN | CRMT_BW_ASSIGN | CHAR | 1 | 0 | Assign BW and CO | ||
38 | ITM_USAGE | CRMT_ITEM_USAGE | CRM_ITEM_USAGE | CHAR | 2 | 0 | Usage of Higher-Level Item | ||
39 | ITM_TYPE_USAGE | CRMT_IT_TYPE_USAGE | CRM_IT_TYPE_USAGE | CHAR | 4 | 0 | Item Category Usage | * | |
40 | ALTERNATIVE | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
41 | PARENT | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
42 | ITM_BP | CRM_ISU_PARTNER_NO | CRM_ISU_PARTNER_NO | CHAR | 10 | 0 | Partner Number | ||
43 | ITEM_CREATED_TS | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
44 | ITEM_CHANGED_TS | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
45 | ORDER_DATE_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
46 | .INCLUDE | 0 | 0 | PARTNER (Sales) Data for BW DataSources | |||||
47 | SOLD_TO_PARTY | CRMT_SOLD_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Sold-To Party | * | |
48 | SHIP_TO_PARTY | CRMT_SHIP_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Ship-To Party | * | |
49 | BILL_TO_PARTY | CRMT_BILL_TO_PART | BU_PARTNER | CHAR | 10 | 0 | Bill-To Party | * | |
50 | PAYER | CRMT_RP_PAYER | BU_PARTNER | CHAR | 10 | 0 | Payer | * | |
51 | SOLD_FROM | CRMT_SOLD_FROM_PARTY_ID | BU_PARTNER | CHAR | 10 | 0 | Salesperson ID | * | |
52 | .INCLUDE | 0 | 0 | PARTNER (Locator) Various Partner Functions | |||||
53 | INSTALL_AT | CRMT_INSTALL_AT_PART | BU_PARTNER | CHAR | 10 | 0 | Installed At | * | |
54 | INSTALL_AT_LIST | CRMT_INSTALL_AT_LIST | CHAR80 | CHAR | 80 | 0 | Installed At - Name | ||
55 | RESPONS_AT_PARTNER | CRMT_RESPONSIBLE_AT_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Person Responsible at Partners (Channel Management) | * | |
56 | END_CUSTOMER | CRMT_END_CUSTOMER | BU_PARTNER | CHAR | 10 | 0 | End Customer (Channel Management) | * | |
57 | RESP_AT_PART | CRMT_RESPONSIBLE_AT_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Person Responsible at Partners (Channel Management) | * | |
58 | .INCLUDE | 0 | 0 | PARTNER (General) Data for BW DataSoures | |||||
59 | SALES_EMPLOYEE | CRMT_SALES_EMPLOYEE | BU_PARTNER | CHAR | 10 | 0 | Employee | * | |
60 | PERSON_RESP | CRMT_PERSON_RESP | BU_PARTNER | CHAR | 10 | 0 | Employee Responsible | * | |
61 | CONTACT_PERSON | CRMT_CONTACT_PERSON | BU_PARTNER | CHAR | 10 | 0 | Customer Contact Person | * | |
62 | SALESPARTNER | CRMT_SALESPARTNER | BU_PARTNER | CHAR | 10 | 0 | Sales Partners | * | |
63 | RESP_GROUP_RFW | CRMT_RESPONSIBLE_GROUP | BU_PARTNER | CHAR | 10 | 0 | Responsible Group | * | |
64 | PLANNING_ACCOUNT | CRMT_PLANNING_ACCOUNT | BU_PARTNER | CHAR | 10 | 0 | Planning Account | * | |
65 | .INCLUDE | 0 | 0 | PARTNER (Call Center) Data for BW Datasoures | |||||
66 | EXECUTING_CC | CRMT_EXECUTING_CC | BU_PARTNER | CHAR | 10 | 0 | Executing Interaction Center | * | |
67 | RESP_GROUP | CRMT_RESPONSIBLE_GROUP | BU_PARTNER | CHAR | 10 | 0 | Responsible Group | * | |
68 | .INCLUDE | 0 | 0 | ORGMAN Data for BW DataSources | |||||
69 | SALES_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
70 | SALES_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
71 | SALES_OFFICE | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
72 | SALES_GROUP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
73 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | * | |
74 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | * | |
75 | SERVICE_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
76 | SERVICE_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
77 | PURCH_ORG_RESP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
78 | PURCH_ORG | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
79 | PURCH_GROUP | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
80 | IC_BD_CCODE | CRM_IC_BD_CCODE | BUKRS | CHAR | 4 | 0 | Company Code for a Business Transaction | * | |
81 | IC_BD_LOGSYS | CRM_IC_BD_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System for a Business Transaction | * | |
82 | .INCLUDE | 0 | 0 | SALES Data for BW DataSources | |||||
83 | CUST_GROUP1 | CRMT_CUST_GROUP1 | CRM_CUST_GROUP1 | CHAR | 3 | 0 | Customer Group 1 | * | |
84 | CUST_GROUP2 | CRMT_CUST_GROUP2 | CRM_CUST_GROUP2 | CHAR | 3 | 0 | Customer Group 2 | * | |
85 | CUST_GROUP3 | CRMT_CUST_GROUP3 | CRM_CUST_GROUP3 | CHAR | 3 | 0 | Customer Group 3 | * | |
86 | CUST_GROUP4 | CRMT_CUST_GROUP4 | CRM_CUST_GROUP4 | CHAR | 3 | 0 | Customer Group 4 | * | |
87 | CUST_GROUP5 | CRMT_CUST_GROUP5 | CRM_CUST_GROUP5 | CHAR | 3 | 0 | Customer Group 5 | * | |
88 | INDUSTRY | CRMT_INDUSTRY | CRM_INDUSTRY | CHAR | 4 | 0 | Industry Sector | * | |
89 | REJECTION | CRMT_REJECTION_CODE | CRM_REJECTION_CODE | CHAR | 2 | 0 | Cancellation Reason Code | * | |
90 | PROBABILITY | CRMT_ORDER_PROBABILITY | CRM_PROBABILITY | NUMC | 3 | 0 | Order Probability | ||
91 | PCAT_HDR_ID | COMT_PCAT_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Product Catalog Number | ||
92 | PCAT_VRT_ID | COMT_PCAT_VRT_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Catalog Variant Number | ||
93 | PCAT_CTY_ID | COMT_PCAT_CTY_ID | COM_PCAT_OBJECTID | CHAR | 30 | 0 | Catalog Area Number | ||
94 | ABNORMAL_DEMAND | CRMT_ABNORMAL_DEMAND | CRM_ABNORMAL_DEMAND | CHAR | 1 | 0 | Abnormal Demand | ||
95 | DLV_RELEVANCE | CRMT_DELIVERY_RELEVANT | CRM_DELIVERY_RELEVANT | CHAR | 1 | 0 | Delivery-Relevant | ||
96 | DATE_QTY_FIXED | CRMT_DATE_QTY_FIXED | CRM_BOOLEAN | CHAR | 1 | 0 | Fixed Date and Quantity | ||
97 | .INCLUDE | 0 | 0 | General Product Data for BW DataSources | |||||
98 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
99 | PRODUCT_GUID | CRMT_PRODUCT_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for Product CHAR32 | ||
100 | MATERIAL | CRMT_R3_MATERIAL | CRM_R3_MATERIAL | CHAR | 18 | 0 | Distribution CRM -> R/3: Material | ||
101 | CATEGORY_ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR | 20 | 0 | Category ID | ||
102 | CATEGORY_GUID | COMT_CATEGORY_GUID | SYSUUID | RAW | 16 | 0 | Category GUID | ||
103 | SHORT_TEXT_UC | COMT_PRSHTEXTX_UP | PRSHTEXTG40 | CHAR | 40 | 0 | Product Description | ||
104 | CATALOG_ID | CATALOG_PL | KATALOGID | CHAR | 20 | 0 | Catalog ID, from Which the Line PPR Was Selected | * | |
105 | CATALOG_ITEM_ID | CRMT_CATALOGITEM | CRM_CATALOGITEM | CHAR | 40 | 0 | Catalog Item (Unique Key) | ||
106 | PARTNER_PROD | CRMT_ITEM_DESCR_PARTNER | PRSHTEXT40 | CHAR | 40 | 0 | Product Number of Business Partner | ||
107 | PARENT_PRODUCT | CRMT_PRODUCT_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for Product CHAR32 | ||
108 | COMPETITOR_PROD | CRMT_PRODUCT_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for Product CHAR32 | ||
109 | REPLACED_PROD | CRMT_PRODUCT_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for Product CHAR32 | ||
110 | .INCLUDE | 0 | 0 | PRODUCT_I Data for BW DataSources | |||||
111 | GROSS_WEIGHT | CRMT_GROSS_WEIGHT | MENG15 | QUAN | 15 | 3 | Gross Weight | ||
112 | NET_WEIGHT | CRMT_NET_WEIGHT | MENG15 | QUAN | 15 | 3 | Net Weight | ||
113 | WEIGHT_UNIT | COMT_WEIGHT_UNIT | MEINS | UNIT | 3 | 0 | Weight Unit | * | |
114 | VOLUME | CRMT_VOLUME | MENG15 | QUAN | 15 | 3 | Volume Occupied by the Product per Volume Unit | ||
115 | VOLUME_UNIT | COMT_VOLUME_UNIT | MEINS | UNIT | 3 | 0 | Unit for the Volume of a Product | * | |
116 | PROCESS_QTY_NUM | CRMT_PROCESS_QTY_NUM | CRM_PROCESS_QTY_NUM | INT4 | 10 | 0 | Numerator (factor) for conversion trans. quantity in BME | ||
117 | PROCESS_QTY_DEN | CRMT_PROCESS_QTY_DEN | CRM_PROCESS_QTY_DEN | INT4 | 10 | 0 | Denominator (factor) for conversion trans. quantity in BME | ||
118 | EXPONENT10 | CRMT_EXPONENT10 | CRM_EXPONENT10 | INT2 | 5 | 0 | 10 Exponent for Quantity Conversion | ||
119 | PROCESS_QTY_UNIT | CRMT_PROCESS_QTY_UNIT | MEINS | UNIT | 3 | 0 | Unit of Measure in Which the Product Is Sold | * | |
120 | PROD_PR_GROUP | CRMT_PROD_PR_GROUP | CRM_PROD_PR_GROUP | CHAR | 2 | 0 | Product Group | * | |
121 | PRC_GROUP1 | CRMT_PRC_GROUP1 | CRM_PRC_GROUP1 | CHAR | 3 | 0 | Product Group 1 | * | |
122 | PRC_GROUP2 | CRMT_PRC_GROUP2 | CRM_PRC_GROUP2 | CHAR | 3 | 0 | Product Group 2 | * | |
123 | PRC_GROUP3 | CRMT_PRC_GROUP3 | CRM_PRC_GROUP3 | CHAR | 3 | 0 | Product Group 3 | * | |
124 | PRC_GROUP4 | CRMT_PRC_GROUP4 | CRM_PRC_GROUP4 | CHAR | 3 | 0 | Product Group 4 | * | |
125 | PRC_GROUP5 | CRMT_PRC_GROUP5 | CRM_PRC_GROUP5 | CHAR | 3 | 0 | Product Group 5 | * | |
126 | BASE_QTY_UNIT | COMT_PRODUCT_BASE_UOM | MEINS | UNIT | 3 | 0 | Base Unit of Measure of Product | * | |
127 | .INCLUDE | 0 | 0 | PRICING_H Data for BW DataSources | |||||
128 | EXCHG_TYPE | CRMT_EXCHG_TYPE | KURST | CHAR | 4 | 0 | Exchange Rate Type | * | |
129 | EXCHG_DATE | CRMT_EXCHG_DATE | CRM_EXCHG_DATE | DATS | 8 | 0 | Exchange Rate Date | ||
130 | EXCHG_RATE | CRMT_EXCHG_RATE | CRM_EXCHG_RATE | DEC | 9 | 5 | Exchange Rate | ||
131 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
132 | PRICE_DATE | CRMT_PRICE_DATE | CRM_PRICE_DATE | DATS | 8 | 0 | Pricing Date | ||
133 | REF_CURRENCY | CRMT_REF_CURRENCY | WAERS | CUKY | 5 | 0 | Reference Currency | * | |
134 | PMNTTRMS | CRMT_PMNTTRMS | CRM_PMNTTRMS | CHAR | 4 | 0 | Terms of Payment | * | |
135 | CUST_GROUP | CRMT_CUST_GROUP | CRM_CUST_GROUP | CHAR | 2 | 0 | Customer Group | * | |
136 | CUSTOMER_TYPE | CRMT_CUSTOMER_TYPE | BU_KIND | CHAR | 4 | 0 | Business Partner Type | * | |
137 | .INCLUDE | 0 | 0 | PRICING_I Data for BW DataSources | |||||
138 | NET_VALUE_MAN | CRMT_NET_VALUE_MAN | WERTV8 | CURR | 15 | 2 | Total Expected Net Value Products in Document Currency | ||
139 | TARGET_VALUE | CRMT_TARGET_VALUE | WERTV10 | CURR | 19 | 2 | Target Value for Contracts | ||
140 | NET_PRICE | CRMT_NET_PRICE | WERTV8 | CURR | 15 | 2 | Net Price | ||
141 | NET_VALUE | CRMT_NET_VALUE | WERTV8 | CURR | 15 | 2 | Net Value | ||
142 | TAX_AMOUNT | CRMT_TAX_AMOUNT | WERTV8 | CURR | 15 | 2 | Tax amount in document currency | ||
143 | FREIGHT | CRMT_FREIGHT | WERTV8 | CURR | 15 | 2 | Shipment costs in document currency | ||
144 | SUBTOTAL1 | CRMT_SUBTOTAL1 | WERTV8 | CURR | 15 | 2 | Subtotal 1 from pricing procedure for condition | ||
145 | SUBTOTAL2 | CRMT_SUBTOTAL2 | WERTV8 | CURR | 15 | 2 | Subtotal 2 from pricing procedure for condition | ||
146 | SUBTOTAL3 | CRMT_SUBTOTAL3 | WERTV8 | CURR | 15 | 2 | Subtotal 3 from pricing procedure for condition | ||
147 | SUBTOTAL4 | CRMT_SUBTOTAL4 | WERTV8 | CURR | 15 | 2 | Subtotal 4 from pricing procedure for condition | ||
148 | SUBTOTAL5 | CRMT_SUBTOTAL5 | WERTV8 | CURR | 15 | 2 | Subtotal 5 from pricing procedure for condition | ||
149 | SUBTOTAL6 | CRMT_SUBTOTAL6 | WERTV8 | CURR | 15 | 2 | Subtotal 6 from pricing procedure for condition | ||
150 | CREDIT_INDICATOR | CRMT_CREDIT_INDICATOR | CRMT_CREDIT_INDICATOR | CHAR | 1 | 0 | Credit Debit Indicator | ||
151 | GROSS_VALUE | CRMT_GROSS_VALUE | WERTV8 | CURR | 15 | 2 | Gross Order Value in PO Currency | ||
152 | .INCLUDE | 0 | 0 | DATES Data for BW DataSources | |||||
153 | REQUESTED_DATE | CRMT_REQUESTED_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Order Date | ||
154 | CONFIRMED_DATE | CRMT_CONFIRMED_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Latest Confirmation Date for Item Schedule Line | ||
155 | BEGIN_DATE | CRMT_BEGIN_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Contract Start Date | ||
156 | ENDING_DATE | CRMT_ENDING_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Contract End Date | ||
157 | START_OF_BILLING | CRMT_START_OF_BILLING | CRM_RPRTNG_DATE | DATS | 8 | 0 | Start Date of Billing Plan | ||
158 | VALID_FROM_DATE | CRMT_VALID_FROM_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Quotation Valid from Date | ||
159 | VALID_TO_DATE | CRMT_VALID_TO_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Quotation: Valid to Date | ||
160 | BW_POST_DATE | CRMT_BW_POST_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Posting Date for BW Reporting | ||
161 | PLANNED_TS_FROM | CRMT_PLANNED_TS_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Planned Date/Time from | ||
162 | PLANNED_TS_TO | CRMT_PLANNED_TS_TO | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Planned Date/Time to | ||
163 | ACTUAL_TS_FROM | CRMT_ACTUAL_TS_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Actual Date/Time from | ||
164 | ACTUAL_TS_TO | CRMT_ACTUAL_TS_TO | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Actual Date/Time to | ||
165 | PLANNED_FROM | CRMT_PLANNED_FROM | CRM_RPRTNG_DATE | DATS | 8 | 0 | Planned Date from | ||
166 | PLANNED_TO | CRMT_PLANNED_TO | CRM_RPRTNG_DATE | DATS | 8 | 0 | Planned Date to | ||
167 | ACTUAL_FROM | CRMT_ACTUAL_FROM | CRM_RPRTNG_DATE | DATS | 8 | 0 | Actual Date from | ||
168 | ACTUAL_TO | CRMT_ACTUAL_TO | CRM_RPRTNG_DATE | DATS | 8 | 0 | Actual Date to | ||
169 | EARLIEST_CONFIRM | CRMT_EARLIEST_CONFIRMED | CRM_RPRTNG_DATE | DATS | 8 | 0 | Earliest Confirmation Date Still Not Delivered | ||
170 | DURA | CRMT_BW_DURATION | TIMEDURA | DEC | 13 | 0 | Duration of Contract/Quotation | ||
171 | DURA_FULLFILL | CRMT_BW_DURA_FULLFILL | TIMEDURA | DEC | 13 | 0 | Duration Until Fulfillment of Contract | ||
172 | DURA_UNIT | CRMT_BW_DURA_UNIT | TIMEUNITNA | CHAR | 12 | 0 | Time Unit for Duration of Contract/Quotation in Days | * | |
173 | BEGIN_TO_COMPLET | CRMT_BW_BEGIN_TO_COMPLETE | TIMEDURA | DEC | 13 | 0 | Duration Start to Conversion or Cancellation of a Quotation | ||
174 | COMPLETE_TO_END | CRMT_BW_COMPLETE_TO_END | TIMEDURA | DEC | 13 | 0 | Duration Conversion or Cancellation Before End of Quotation | ||
175 | REL_TO_BEGIN | CRMT_BW_REL_TO_BEGIN | DEC | 7 | 2 | Time Relation: Time to Completion / Validity Interval | |||
176 | REL_BEFORE_END | CRMT_BW_REL_BEFORE_END | DEC | 5 | 2 | Time Relation: Time Completed Before End / Validity Interval | |||
177 | REQ_DLV_DATE | CRMT_REQ_DELIVERY_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Last Required Delivery Date | ||
178 | LAST_DLV_DATE | CRMT_LAST_DELIVERY_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Last Delivery Date | ||
179 | LAST_QI_ACT_DATE | CRMT_LAST_QI_ACTUAL_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Last Actual Goods Issue Data | ||
180 | LAST_REQ_AVA_DAT | CRMT_LAST_REQ_AVAILABLE_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Last Material Availability Date (Requested) | ||
181 | LAST_CONF_AV_DAT | CRMT_LAST_CONF_AVAILABLE_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Last Material Availability Date (Confirmed) | ||
182 | LAST_REQ_QI_PLDA | CRMT_LAST_REQ_QI_PLANNED_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Last Planned Goods Issue Date (Requested) | ||
183 | LAST_CONF_QI_PLD | CRMT_LAST_CONF_QI_PLANNED_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp: Last Planned Goods Issue Date (Confirmed) | ||
184 | CONFIRMED_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
185 | ACTUAL_FROM_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
186 | EARLIEST_CON_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
187 | REQUESTED_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
188 | VALID_FROM_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
189 | VALID_TO_TS | CRMT_DATE_TIMESTAMP_TO | BCOS_TSTMP | DEC | 15 | 0 | Time stamp (Date and Time) until a Date/Duration | ||
190 | .INCLUDE | 0 | 0 | CUMULATED_I Data for BW DataSources | |||||
191 | CALL_OF_CURR_CUM | CRMT_CALL_OF_CURRENCY_CUM | WAERS | CUKY | 5 | 0 | Currency for Value Called | * | |
192 | CALL_OF_QTY_CUM | CRMT_CALL_OF_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Quantity Retrieved for a Contract | ||
193 | CALL_OF_UNIT_CUM | CRMT_CALL_OF_QTY_UNIT_CUM | MEINS | UNIT | 3 | 0 | Quantity Unit Called | * | |
194 | CALL_OF_VAL_CUM | CRMT_CALL_OF_VALUE_CUM | CRM_COND_VALUE | CURR | 19 | 2 | Released Value for a Contract | ||
195 | COMPL_CURR_CUM | CRMT_COMPLETED_CURRENCY_CUM | WAERS | CUKY | 5 | 0 | Currency of Actual Referenced Value | * | |
196 | COMPL_QTY_CUM | CRMT_COMPLETED_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Actual Referenced Quantity for a Quotation | ||
197 | COMPL_UNIT_CUM | CRMT_COMPLETED_QTY_UNIT_CUM | MEINS | UNIT | 3 | 0 | Unit for Actual Referenced Quantity | * | |
198 | COMPL_VALUE_CUM | CRMT_COMPLETED_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Actual Referenced Value for a Quotation | ||
199 | TARGET_QUAN_CUM | CRMT_TARGET_QUAN_CUM | MENG13 | QUAN | 13 | 3 | Target Quantity Cumulated | ||
200 | TGT_QTY_UNIT_CUM | CRMT_TARGET_QTY_UNIT_CUM | MEINS | UNIT | 3 | 0 | Unit for a Target Quantity | * | |
201 | DELIVERY_QTY_CUM | CRMT_DELIVERED_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Delivered Quantity for an Item | ||
202 | INVOICED_QTY_CUM | CRMT_INVOICED_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Billed Quantity for an Item | ||
203 | O_CALLOF_QTY_CUM | CRMT_O_CALLOF_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Open Releasable Quantity for Item | ||
204 | O_INV_QTY_CUM | CRMT_OPEN_INV_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Open Item Quantity for Billing | ||
205 | O_ORDER_QTY_CUM | CRMT_OPEN_ORD_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Open Order Quantity for Item | ||
206 | DELIVERY_VAL_CUM | CRMT_DELIVERED_VAL_CUM | WERTV8 | CURR | 15 | 2 | Delivered Value for an Item | ||
207 | INVOICED_VAL_CUM | CRMT_INVOICED_VAL_CUM | WERTV8 | CURR | 15 | 2 | Billed Value of an Item | ||
208 | O_CALLOF_VAL_CUM | CRMT_O_CALLOF_VAL_CUM | CRM_COND_VALUE | CURR | 19 | 2 | Open Releasable Value for Item | ||
209 | O_INV_VAL_CUM | CRMT_OPEN_INV_VAL_CUM | WERTV8 | CURR | 15 | 2 | Open Item Value for Billing | ||
210 | O_ORDER_VAL_CUM | CRMT_OPEN_ORD_VAL_CUM | WERTV8 | CURR | 15 | 2 | Open Order Value for Item | ||
211 | FULLFILL_QTY | CRMT_FULLFILLMENT_TGT | DEC | 9 | 2 | Degree of Fulfillment: Target/Quantity | |||
212 | FULLFILL_VAL | CRMT_FULLFILLMENT_TGT | DEC | 9 | 2 | Degree of Fulfillment: Target/Quantity | |||
213 | CUMULAT_UNIT_CUM | CRMT_CUMULAT_QTY_UNIT_CUM | MEINS | UNIT | 3 | 0 | Unit of Cumulated Quantity | * | |
214 | CUMULAT_CURR_CUM | CRMT_CUMULAT_CURR_CUM | WAERS | CUKY | 5 | 0 | Currency of Cumulated Value | * | |
215 | QUOT_VAL_CUM | CRMT_QUOT_VAL_CUM | WERTV8 | CURR | 15 | 2 | Quotation Value for an Item | ||
216 | QUOT_QTY_CUM | CRMT_QUOT_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Quotation Quantity for Item | ||
217 | GI_QTY_CUM | CRMT_GOODS_ISSUE_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Goods Issue Quantity for an Item | ||
218 | GI_QTY_SINGLE | CRMT_GOODS_ISSUE_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Goods Issue Quantity for an Item | ||
219 | DELIV_QTY_SINGLE | CRMT_DELIVERED_QTY_CUM | CRM_MENGV15 | QUAN | 15 | 3 | Delivered Quantity for an Item | ||
220 | .INCLUDE | 0 | 0 | SHIPPING Data for BW DataSources | |||||
221 | INCOTERMS1 | CRMT_INCOTERMS1 | CRM_INCOTERMS1 | CHAR | 3 | 0 | Incoterms (Part 1) | * | |
222 | INCOTERMS2 | CRMT_INCOTERMS2 | CRM_INCOTERMS2 | CHAR | 28 | 0 | Incoterms (Part 2) | ||
223 | .INCLUDE | 0 | 0 | BILLING Data for BW DataSources | |||||
224 | BILLING_DATE | CRMT_BW_BILL_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Billing Date | ||
225 | BILLING_BLOCK | CRMT_BUS_BILL_BLOCK_REASON | CRM_BILLING_BLOCK | CHAR | 2 | 0 | Business Partner (CRM): Billing Block Reason | * | |
226 | LOC_GUID | CRMT_LOC_GUID | SYSUUID_C | CHAR | 32 | 0 | Letter of Credit GUID from SAP Global Trade Services | ||
227 | LOC_EXT_NUMBER | CRMT_LOC_EXTERNAL_NUMBER | CHAR | 40 | 0 | External Number Letter of Credit | |||
228 | BILLING_DATE_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
229 | .INCLUDE | 0 | 0 | STATUS Data for BW DataSources | |||||
230 | STATUS_INQUIRY | CRMT_STATUS_INQUIRY | BOOLEAN | CHAR | 1 | 0 | Status of Inquiry | ||
231 | STATUS_QUOTATION | CRMT_STATUS_QUOTATION | CRM_BOOLEAN | CHAR | 1 | 0 | Quotation Status | ||
232 | STATUS_ERROR | CRMT_STATUS_ERROR | CRM_BOOLEAN | CHAR | 1 | 0 | Indicates Whether Document is Incorrect | ||
233 | STATUS_INVOICED | CRMT_STATUS_INVOICED | CRM_BOOLEAN | CHAR | 1 | 0 | Billing Status | ||
234 | STATUS_ACCEPTED | CRMT_STATUS_ACCEPTED | BOOLEAN | CHAR | 1 | 0 | Status Accepted | ||
235 | STATUS_COMPLETED | CRMT_STATUS_COMPLETED | BOOLEAN | CHAR | 1 | 0 | Status: Completed | ||
236 | STATUS_CANCELLED | CRMT_STATUS_CANCELLED | BOOLEAN | CHAR | 1 | 0 | Rejection Status | ||
237 | STATUS_DOC_SYS | CRM_J_STATUS | CRM_J_STATUS | CHAR | 5 | 0 | Object Status | ||
238 | STATUS_DELIVERED | CRMT_DELIVERY_STAT | CRMT_BW_DELIVERY_STAT_DOM | CHAR | 1 | 0 | Delivery Status (Use for BW Only) | ||
239 | STATUS_EXPIRED | CRMT_STATUS_EXPIRED | BOOLEAN | CHAR | 1 | 0 | Status End of Validity Period (Quotation) | ||
240 | STATUS_INCOMPL | CRMT_STATUS_INCOMPLETE | BOOLEAN | CHAR | 1 | 0 | Status: Incompleted | ||
241 | .INCLUDE | 0 | 0 | SRV_OSSET Data for BW DataSources | |||||
242 | KATALOGART | COMT_CATALOG | COM_CATALOG | CHAR | 2 | 0 | Catalog | * | |
243 | CODEGRUPPE | QCODEGRP | QCODEGRP | CHAR | 8 | 0 | Code Group | * | |
244 | CODE | QCODE | QCODE | CHAR | 4 | 0 | Code | * | |
245 | ACT_REASON_CAT | COMT_CATALOG | COM_CATALOG | CHAR | 2 | 0 | Catalog | * | |
246 | ACT_REASON_GROUP | QCODEGRP | QCODEGRP | CHAR | 8 | 0 | Code Group | * | |
247 | ACT_REASON_CODE | QCODE | QCODE | CHAR | 4 | 0 | Code | * | |
248 | EXT_REFOBJ | CRMT_EXT_REFOBJ | CHAR40 | CHAR | 40 | 0 | External Reference Object | ||
249 | .INCLUDE | 0 | 0 | Time Characteristics for BW Reporting | |||||
250 | CALDAY | SMOCALDAY | DATUM | DATS | 8 | 0 | Calendar Day | ||
251 | CALDAY_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
252 | .INCLUDE | 0 | 0 | DOC_FLOW Data for BW DataSources | |||||
253 | PREDEC_OBJKEY | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
254 | PREDEC_OBJTYPE | CRMT_PRED_OBJECT_TYPE | OJ_NAME | CHAR | 10 | 0 | Object Type of a Preceding Document | * | |
255 | LOGSYS_PRED | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
256 | MKT_ELEMENT | CRM_MKTPL_MKT_PLAN_TASKID | CGPL_EXTID | CHAR | 24 | 0 | Marketing Plan Element | ||
257 | PRED_LEAD_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
258 | LEAD_CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
259 | PRED_OPPT_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
260 | OPPT_CREATED_AT | CRMT_OPPT_CREATED_AT | DATUM | DATS | 8 | 0 | Transaction Was Created at This Time | ||
261 | PRED_ACT_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
262 | ACT_CATEGORY | CRMT_ACTIVITY_CATEGORY | CRM_ACTIVITY_CATEGORY | CHAR | 3 | 0 | Activity Category (Communication Type) | * | |
263 | ACT_DIRECTION | CRMT_DIRECTION | CRM_DIRECTION | CHAR | 1 | 0 | Direction of an Activity | ||
264 | QUOTATION_GUID | CRMT_PROCESS_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | GUID for a Transaction | ||
265 | QUOT_VALID_FROM | CRMT_VALID_FROM_DATE | CRM_RPRTNG_DATE | DATS | 8 | 0 | Quotation Valid from Date | ||
266 | PROCESS_CATEGORY | CRMT_ACTIVITY_CATEGORY | CRM_ACTIVITY_CATEGORY | CHAR | 3 | 0 | Activity Category (Communication Type) | * | |
267 | PROCESS_CATALOG | COMT_CATALOG | COM_CATALOG | CHAR | 2 | 0 | Catalog | * | |
268 | PROCESS_CODEGR | QCODEGRP | QCODEGRP | CHAR | 8 | 0 | Code Group | * | |
269 | PROCESS_CODE | QCODE | QCODE | CHAR | 4 | 0 | Code | * | |
270 | PROCESS_OBJTYPE | CRMT_PRED_OBJECT_TYPE | OJ_NAME | CHAR | 10 | 0 | Object Type of a Preceding Document | * | |
271 | PO_NUMBER | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
272 | PO_ITEM_NUMBER | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC | 10 | 0 | Item Number in Document | ||
273 | LEAD_CREATED_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
274 | OPPT_CREATED_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
275 | QUOT_VALID_TS | CRMT_DATE_TIMESTAMP_FROM | BCOS_TSTMP | DEC | 15 | 0 | Time Stamp (Date and Time) of a Date/Duration | ||
276 | .INCLUDE | 0 | 0 | Schedule line quantities - Daten für BW Datasoures | |||||
277 | ORDER_QTY | CRMT_QTY_ORDER | MENG13 | QUAN | 13 | 3 | CRM: Order Quantity | ||
278 | CONFIRMED_QTY | CRMT_QTY_CONFIRMED | MENG13 | QUAN | 13 | 3 | CRM: Confirmed Quantity | ||
279 | .INCLUDE | 0 | 0 | STATUS GROUPS Data for BW Datasources | |||||
280 | BWSTONESYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
281 | BWSTONESYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
282 | BWSTONESYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
283 | BWSTONESYS3 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
284 | BWSTONESYS4 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
285 | BWSTONESYS5 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
286 | BWSTONESYS6 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
287 | BWSTONESYS7 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
288 | BWSTONESYS8 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
289 | BWSTONESYS9 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
290 | BWSTONESYSA | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
291 | BWSTTECSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
292 | BWSTTECSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
293 | BWSTTECSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
294 | BWSTLOCSYS0 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
295 | BWSTLOCSYS1 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
296 | BWSTLOCSYS2 | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
297 | BWSTONESYSB | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
298 | BWSTONESYSC | CRMBWST | J_STONR | NUMC | 2 | 0 | BW Status | ||
299 | .INCLUDE | 0 | 0 | CUMULATED_H Data for BW Data Sources | |||||
300 | GROSS_VALUE_H | CRMT_GROSS_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Gross Value of Document in Document Currency | ||
301 | NET_VALUE_H | CRMT_NET_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Net Value of Document in Document Currency | ||
302 | NET_VALUE_MAN_H | CRMT_NET_VALUE_MAN_CUM | WERTV8 | CURR | 15 | 2 | Expected Total Net Value of Products in Document Currency | ||
303 | .INCLUDE | 0 | 0 | Territory Data for BW Data Sources (Partner Attribute) | |||||
304 | PATH_GUID | CRMT_PATH_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Path GUID of Territory 32 | ||
305 | TERR_GUID | CRMT_TERR_GUID_32 | SYSUUID_C | CHAR | 32 | 0 | Territory GUID 32 | ||
306 | .INCLUDE | 0 | 0 | Hosted Order Management | |||||
307 | HOM_FLAG | CRMT_HOM_FLAG | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator of an order from Hosted Order Management scenario | ||
308 | .INCLUDE | 0 | 0 | Further Product Data for BW DataSources | |||||
309 | IOBJECT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
310 | IOBJECT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
311 | CONFPROD_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
312 | CONFPROD_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
313 | PROD_OBJ_FAM | COMT_PRODUCT_OBJECT_FAMILY | COM_PRODUCT_OBJECT_FAMILY | CHAR | 4 | 0 | Object Family | * | |
314 | BATCH_ID | CRMT_BATCH_ID | BATCH_ID | CHAR | 10 | 0 | Batch Number | ||
315 | SAMPLE | CRMT_SAMPLE_INV | CRM_BOOLEAN | CHAR | 1 | 0 | Sample Indicator | ||
316 | SAMPLE_SPEC | CRMT_SAMPLE_SPEC | CRMBWSAMPLE | CHAR | 1 | 0 | Sample | ||
317 | SAMPLE_QTY_ALLOW | CRM_ACT_NUMBER_OF_SAMPLES | DEC4 | DEC | 4 | 0 | Number of samples | ||
318 | .INCLUDE | 0 | 0 | CUOBJ for BW DataSources | |||||
319 | CUOBJ | CRMT_INT_OBJ_NO | IB_INSTANCE | NUMC | 18 | 0 | Configuration (Internal Object Number) | ||
320 | .INCLUDE | 0 | 0 | FLAGS Data for BW DataSources | |||||
321 | FLAG_ALT_ITM | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
322 | FLAG_STAT | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
323 | .INCLUDE | 0 | 0 | Reasons for Rejection External Dynamic Fields | |||||
324 | RJCTRS | CRMT_RJCTRS | CRM_RJCTRS | CHAR | 3 | 0 | Reason for Rejection | * | |
325 | .INCLUDE | 0 | 0 | APO Item Data for BW DataSources | |||||
326 | EXE_LOC_NUMBER | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
327 | EXE_LOC_TYPE | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
328 | FACING_LOCATION | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
329 | FACING_LOCTYPE | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
330 | FIRSTS_LOCATION | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
331 | FIRSTS_LOC_TYPE | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
332 | OVERRIDE_LOC | CHAR20 | CHAR20 | CHAR | 20 | 0 | Char 20 | ||
333 | .INCLUDE | 0 | 0 | PARTNER (APO) Data for BW DataSources | |||||
334 | EXELOC_BP | CRMT_EXELOC_BP | BU_PARTNER | CHAR | 10 | 0 | Business Partner of the Executing Location | * | |
335 | FACLOC_BP | CRMT_FACLOC_BP | BU_PARTNER | CHAR | 10 | 0 | Business Partner for Facing Location | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BW_SALES_ORDER_I | OBJECT_TYPE | CRMC_SUBOB_CAT | SUBOBJ_CATEGORY |
History
Last changed by/on | SAP | 20131122 |
SAP Release Created in | 30A |