SAP ABAP Table CRMS_BW_IU_DSM_AGR (CRM DSM Agreement Extraction Structure)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-IU-DSM (Application Component) Demand Side Management
     CRM_IU_DSM_BW (Package) Utilities DSM (Demand Side management) BW package
Basic Data
Table Category INTTAB    Structure 
Structure CRMS_BW_IU_DSM_AGR   Table Relationship Diagram
Short Description CRM DSM Agreement Extraction Structure    
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 (General) Data for BW DataSoures  
53 SALES_EMPLOYEE CRMT_SALES_EMPLOYEE BU_PARTNER CHAR 10   0   Employee *
54 PERSON_RESP CRMT_PERSON_RESP BU_PARTNER CHAR 10   0   Employee Responsible *
55 CONTACT_PERSON CRMT_CONTACT_PERSON BU_PARTNER CHAR 10   0   Customer Contact Person *
56 SALESPARTNER CRMT_SALESPARTNER BU_PARTNER CHAR 10   0   Sales Partners *
57 RESP_GROUP_RFW CRMT_RESPONSIBLE_GROUP BU_PARTNER CHAR 10   0   Responsible Group *
58 PLANNING_ACCOUNT CRMT_PLANNING_ACCOUNT BU_PARTNER CHAR 10   0   Planning Account *
59 .INCLUDE       0   0   Service Partner for BW Extraction  
60 SERVICE_TEAM CRMT_SERVICE_TEAM BU_PARTNER CHAR 10   0   Service Team *
61 SERVICE_EMPLOYEE CRMT_SERVICE_EMPLOYEE BU_PARTNER CHAR 10   0   Executing Service Employee *
62 .INCLUDE       0   0   DSM Partner Set  
63 PAYMENT_RECIPT CRMT_RP_PAYMENT_RECIPIENT BU_PARTNER CHAR 10   0   Payment Recipient *
64 PO_NUMBER_UC CRMT_PO_NUMBER_UC CHAR35 CHAR 35   0   Sold-to Party's External Reference No. (in Capital Letters)  
65 .INCLUDE       0   0   ORGMAN Data for BW DataSources  
66 SALES_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
67 SALES_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
68 SALES_OFFICE OBJEKTID NUM08 NUMC 8   0   Object ID  
69 SALES_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
70 DIS_CHANNEL CRMT_DISTRIBUTION_CHANNEL CRM_DISTRIBUTION_CHANNEL CHAR 2   0   Distribution Channel *
71 DIVISION CRMT_DIVISION CRM_DIVISION CHAR 2   0   Division *
72 SERVICE_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
73 SERVICE_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
74 PURCH_ORG_RESP OBJEKTID NUM08 NUMC 8   0   Object ID  
75 PURCH_ORG OBJEKTID NUM08 NUMC 8   0   Object ID  
76 PURCH_GROUP OBJEKTID NUM08 NUMC 8   0   Object ID  
77 IC_BD_CCODE CRM_IC_BD_CCODE BUKRS CHAR 4   0   Company Code for a Business Transaction *
78 IC_BD_LOGSYS CRM_IC_BD_LOGSYS LOGSYS CHAR 10   0   Logical System for a Business Transaction *
79 .INCLUDE       0   0   SALES Data for BW DataSources  
80 CUST_GROUP1 CRMT_CUST_GROUP1 CRM_CUST_GROUP1 CHAR 3   0   Customer Group 1 *
81 CUST_GROUP2 CRMT_CUST_GROUP2 CRM_CUST_GROUP2 CHAR 3   0   Customer Group 2 *
82 CUST_GROUP3 CRMT_CUST_GROUP3 CRM_CUST_GROUP3 CHAR 3   0   Customer Group 3 *
83 CUST_GROUP4 CRMT_CUST_GROUP4 CRM_CUST_GROUP4 CHAR 3   0   Customer Group 4 *
84 CUST_GROUP5 CRMT_CUST_GROUP5 CRM_CUST_GROUP5 CHAR 3   0   Customer Group 5 *
85 INDUSTRY CRMT_INDUSTRY CRM_INDUSTRY CHAR 4   0   Industry Sector *
86 REJECTION CRMT_REJECTION_CODE CRM_REJECTION_CODE CHAR 2   0   Cancellation Reason Code *
87 PROBABILITY CRMT_ORDER_PROBABILITY CRM_PROBABILITY NUMC 3   0   Order Probability  
88 PCAT_HDR_ID COMT_PCAT_ID COM_PCAT_OBJECTID CHAR 30   0   Product Catalog Number  
89 PCAT_VRT_ID COMT_PCAT_VRT_ID COM_PCAT_OBJECTID CHAR 30   0   Catalog Variant Number  
90 PCAT_CTY_ID COMT_PCAT_CTY_ID COM_PCAT_OBJECTID CHAR 30   0   Catalog Area Number  
91 ABNORMAL_DEMAND CRMT_ABNORMAL_DEMAND CRM_ABNORMAL_DEMAND CHAR 1   0   Abnormal Demand  
92 DLV_RELEVANCE CRMT_DELIVERY_RELEVANT CRM_DELIVERY_RELEVANT CHAR 1   0   Delivery-Relevant  
93 DATE_QTY_FIXED CRMT_DATE_QTY_FIXED CRM_BOOLEAN CHAR 1   0   Fixed Date and Quantity  
94 .INCLUDE       0   0   PRICING_H Data for BW DataSources  
95 EXCHG_TYPE CRMT_EXCHG_TYPE KURST CHAR 4   0   Exchange Rate Type *
96 EXCHG_DATE CRMT_EXCHG_DATE CRM_EXCHG_DATE DATS 8   0   Exchange Rate Date  
97 EXCHG_RATE CRMT_EXCHG_RATE CRM_EXCHG_RATE DEC 9   5   Exchange Rate  
98 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
99 PRICE_DATE CRMT_PRICE_DATE CRM_PRICE_DATE DATS 8   0   Pricing Date  
100 REF_CURRENCY CRMT_REF_CURRENCY WAERS CUKY 5   0   Reference Currency *
101 PMNTTRMS CRMT_PMNTTRMS CRM_PMNTTRMS CHAR 4   0   Terms of Payment *
102 CUST_GROUP CRMT_CUST_GROUP CRM_CUST_GROUP CHAR 2   0   Customer Group *
103 CUSTOMER_TYPE CRMT_CUSTOMER_TYPE BU_KIND CHAR 4   0   Business Partner Type *
104 .INCLUDE       0   0   PRICING_I Data for BW DataSources  
105 NET_VALUE_MAN CRMT_NET_VALUE_MAN WERTV8 CURR 15   2   Total Expected Net Value Products in Document Currency  
106 TARGET_VALUE CRMT_TARGET_VALUE WERTV10 CURR 19   2   Target Value for Contracts  
107 NET_PRICE CRMT_NET_PRICE WERTV8 CURR 15   2   Net Price  
108 NET_VALUE CRMT_NET_VALUE WERTV8 CURR 15   2   Net Value  
109 TAX_AMOUNT CRMT_TAX_AMOUNT WERTV8 CURR 15   2   Tax amount in document currency  
110 FREIGHT CRMT_FREIGHT WERTV8 CURR 15   2   Shipment costs in document currency  
111 SUBTOTAL1 CRMT_SUBTOTAL1 WERTV8 CURR 15   2   Subtotal 1 from pricing procedure for condition  
112 SUBTOTAL2 CRMT_SUBTOTAL2 WERTV8 CURR 15   2   Subtotal 2 from pricing procedure for condition  
113 SUBTOTAL3 CRMT_SUBTOTAL3 WERTV8 CURR 15   2   Subtotal 3 from pricing procedure for condition  
114 SUBTOTAL4 CRMT_SUBTOTAL4 WERTV8 CURR 15   2   Subtotal 4 from pricing procedure for condition  
115 SUBTOTAL5 CRMT_SUBTOTAL5 WERTV8 CURR 15   2   Subtotal 5 from pricing procedure for condition  
116 SUBTOTAL6 CRMT_SUBTOTAL6 WERTV8 CURR 15   2   Subtotal 6 from pricing procedure for condition  
117 CREDIT_INDICATOR CRMT_CREDIT_INDICATOR CRMT_CREDIT_INDICATOR CHAR 1   0   Credit Debit Indicator  
118 GROSS_VALUE CRMT_GROSS_VALUE WERTV8 CURR 15   2   Gross Order Value in PO Currency  
119 .INCLUDE       0   0   SRV_OSSET Data for BW DataSources  
120 KATALOGART COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
121 CODEGRUPPE QCODEGRP QCODEGRP CHAR 8   0   Code Group *
122 CODE QCODE QCODE CHAR 4   0   Code *
123 ACT_REASON_CAT COMT_CATALOG COM_CATALOG CHAR 2   0   Catalog *
124 ACT_REASON_GROUP QCODEGRP QCODEGRP CHAR 8   0   Code Group *
125 ACT_REASON_CODE QCODE QCODE CHAR 4   0   Code *
126 EXT_REFOBJ CRMT_EXT_REFOBJ CHAR40 CHAR 40   0   External Reference Object  
127 .INCLUDE       0   0   CRM BW DSM Dates  
128 SRV_RREADY DATS DATS DATS 8   0   Field of type DATS  
129 SRV_RFIRST DATS DATS DATS 8   0   Field of type DATS  
130 SRV_START SC_DATEFRO DATUM DATS 8   0   Start Date  
131 SRV_CUST_END SC_DATETO DATUM DATS 8   0   End Date  
132 SRV_CUST_BEG SC_DATEFRO DATUM DATS 8   0   Start Date  
133 SETTL_TO SC_DATETO DATUM DATS 8   0   End Date  
134 SETTL_FROM SC_DATEFRO DATUM DATS 8   0   Start Date  
135 PERIOD_DATE DATS DATS DATS 8   0   Field of type DATS  
136 BILL_DATE DATS DATS DATS 8   0   Field of type DATS  
137 INVCR_DATE DATS DATS DATS 8   0   Field of type DATS  
138 DSM_VAL_TO SC_DATETO DATUM DATS 8   0   End Date  
139 DSM_VAL_FROM SC_DATEFRO DATUM DATS 8   0   Start Date  
140 DSM_REL DATS DATS DATS 8   0   Field of type DATS  
141 START_DATE CRMT_DATE DATUM DATS 8   0   Date for Different Goals (Posting Date etc.)  
142 END_DATE CRMT_DATE DATUM DATS 8   0   Date for Different Goals (Posting Date etc.)  
143 DATE_FROM CRMT_DATE DATUM DATS 8   0   Date for Different Goals (Posting Date etc.)  
144 DATE_TO CRMT_DATE DATUM DATS 8   0   Date for Different Goals (Posting Date etc.)  
145 .INCLUDE       0   0   CRM BW DSM Business Agreement  
146 BUAG_GUID CRMT_BUAG_GUID SYSUUID RAW 16   0   GUID of the Business Agreement  
147 BUAG_ID CRMT_BUAG_ID CRMT_BUAG_ID CHAR 12   0   Number of Business Agreement  
148 BUAG_CLASS CRMT_BUAG_CLASS CRMT_BUAG_CLASS CHAR 10   0   Business Agreement Class *
149 .INCLUDE       0   0   CRM DSM Billplan D  
150 ADD_BP_USAGE CRMT_BP_USAGE CRMT_BP_USAGE CHAR 1   0   Billing Plan Usage  
151 CASHFLOW_TYPE CRMT_CASHFLOW_TYPE CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category  
152 RULE_PER_DATE_T CRMT_RULE_PERIOD_DATE_T TIMENAME CHAR 12   0   Rule for Determining the Period Date  
153 PERCENTAGE CRMT_BILL_PERCENTAGE DEC3_2 DEC 5   2   Percentage of Value to be Billed  
154 BILLPLAN_TYPE CRMT_BILLPLAN_TYPE CRM_BILLPLAN_TYPE CHAR 2   0   Billing Plan Type *
155 BILL_VALUE CRMT_BILL_VALUE CRM_COND_VALUE CURR 19   2   Value to be Billed on Date Specified in Billing Plan  
156 .INCLUDE       0   0   CUMULATED_H Data for BW Data Sources  
157 GROSS_VALUE_H CRMT_GROSS_VALUE_CUM WERTV8 CURR 15   2   Total Gross Value of Document in Document Currency  
158 NET_VALUE_H CRMT_NET_VALUE_CUM WERTV8 CURR 15   2   Total Net Value of Document in Document Currency  
159 NET_VALUE_MAN_H CRMT_NET_VALUE_MAN_CUM WERTV8 CURR 15   2   Expected Total Net Value of Products in Document Currency  
160 .INCLUDE       0   0   Time Characteristics for BW Reporting  
161 CALDAY SMOCALDAY DATUM DATS 8   0   Calendar Day  
162 CALDAY_TS CRMT_DATE_TIMESTAMP_FROM BCOS_TSTMP DEC 15   0   Time Stamp (Date and Time) of a Date/Duration  
163 .INCLUDE       0   0   DOC_FLOW Data for BW - DSM  
164 DSM_PM_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
165 DSM_PM_ID CRMT_EXTERNAL_ACTIVITY_ID CRM_EXTERNAL_ACTIVITY_ID CHAR 20   0   External Business Transaction Number  
166 DSM_APL_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
167 DSM_APL_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
168 DSM_POD_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
169 DSM_PREMISE_ID CRM_ISU_PREMISE CRM_ISU_PREMISE CHAR 10   0   Premise  
170 DSM_ITM_REF_GUID CRMT_PROCESS_GUID_32 SYSUUID_C CHAR 32   0   GUID for a Transaction  
171 DSM_ITM_REF_ID CRMT_OBJECT_ID CRM_OBJECT_ID CHAR 10   0   Transaction ID  
172 DSM_ADDR_LINE1 CRM_IU_DSM_ADDR_LINE LINES CHAR 80   0   Address Line  
173 DSM_ADDR_LINE2 CRM_IU_DSM_ADDR_LINE LINES CHAR 80   0   Address Line  
174 DSM_PREMISE_DESC CRM_IU_DSM_ADDR_LINE LINES CHAR 80   0   Address Line  
175 .INCLUDE       0   0   STATUS GROUPS Data for BW Datasources  
176 BWSTONESYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
177 BWSTONESYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
178 BWSTONESYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
179 BWSTONESYS3 CRMBWST J_STONR NUMC 2   0   BW Status  
180 BWSTONESYS4 CRMBWST J_STONR NUMC 2   0   BW Status  
181 BWSTONESYS5 CRMBWST J_STONR NUMC 2   0   BW Status  
182 BWSTONESYS6 CRMBWST J_STONR NUMC 2   0   BW Status  
183 BWSTONESYS7 CRMBWST J_STONR NUMC 2   0   BW Status  
184 BWSTONESYS8 CRMBWST J_STONR NUMC 2   0   BW Status  
185 BWSTONESYS9 CRMBWST J_STONR NUMC 2   0   BW Status  
186 BWSTONESYSA CRMBWST J_STONR NUMC 2   0   BW Status  
187 BWSTTECSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
188 BWSTTECSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
189 BWSTTECSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
190 BWSTLOCSYS0 CRMBWST J_STONR NUMC 2   0   BW Status  
191 BWSTLOCSYS1 CRMBWST J_STONR NUMC 2   0   BW Status  
192 BWSTLOCSYS2 CRMBWST J_STONR NUMC 2   0   BW Status  
193 BWSTONESYSB CRMBWST J_STONR NUMC 2   0   BW Status  
194 BWSTONESYSC CRMBWST J_STONR NUMC 2   0   BW Status  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMS_BW_IU_DSM_AGR OBJECT_TYPE CRMC_SUBOB_CAT SUBOBJ_CATEGORY    
History
Last changed by/on SAP  20130604 
SAP Release Created in 702