SAP ABAP Table CRMT_SRVPLAN_BW_EXTR_BTIL (input for the bw extraction functionality of BTQRSimOrd obj)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BTIL_OBJ (Package) Objects of the Transaction Interaction Layer

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_SRVPLAN_BW_EXTR_BTIL	Table Relationship Diagram
Short Description	input for the bw extraction functionality of BTQRSimOrd obj

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	BW Extraction Structure for CRM Service Planning
2	DISPO_FLG	☐	CRMT_SRV_DISPO_FLG	FLAG	CHAR	1	0	Relevant for Resource Planning
3	CONFIRM_RELEVANT	☐	CRMT_CONFIRM_RELEVANT	CRM_BOOLEAN	CHAR	1	0	Relevant for Confirmation
4	SERVICE_TYPE	☐	CRMT_SERVICE_TYPE	CRMT_SERVICE_TYPE	CHAR	4	0	Service Type	*
5	VALUATION_TYPE	☐	CRMT_VALUATION_TYPE	CRMT_VALUATION_TYPE	CHAR	6	0	Valuation Type	*
6	SRV_ESCAL	☐	CRMT_SRV_ESCAL	CRM_SRV_ESCAL	CHAR	10	0	Response Profile	*
7	SRV_SERWI	☐	CRMT_SRV_SERWI	CRM_SRV_SERWI	CHAR	10	0	Service Profile	*
8	DURATION	☐	CRMT_SRV_DURATION	MENG13	QUAN	13	3	Duration
9	DURATION_UNIT	☐	CRMT_SRV_DURATION_UOM	MEINS	UNIT	3	0	Unit for Duration of Work	*
10	PERSONS	☐	CRMT_SRV_PERSONS	NUMC3	NUMC	3	0	Number of Persons
11	GUID_OBJECT	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
12	GUID_OBJ_OBJFAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
13	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
14	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
15	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
16	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
17	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
18	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
19	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
20	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
21	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
22	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
23	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
24	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
25	ITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
26	ORDER_DATE	☐	CRMT_OPPT_ORDER_DATE	DATUM	DATS	8	0	Posting Date
27	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
28	NUMBER_PARENT	☐	CRMT_ITEM_NO_PARENT	CRM_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Transaction
29	ITEM_OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITEM	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
30	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
31	NUMBER_OF_I	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
32	BW_ASSIGN	☐	CRMT_BW_ASSIGN	CRMT_BW_ASSIGN	CHAR	1	0	Assign BW and CO
33	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
34	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
35	SHIP_TO_PARTY	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
36	BILL_TO_PARTY	☐	CRMT_BILL_TO_PART	BU_PARTNER	CHAR	10	0	Bill-To Party	*
37	PAYER	☐	CRMT_RP_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
38	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
39	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
40	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
41	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
42	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
43	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
44	SALES_ORG	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
45	SALES_OFFICE	☐	CRMT_SALES_OFFICE_SHORT	TEXT12	CHAR	12	0	Sales Office Abbreviation
46	SALES_GROUP	☐	CRMT_SALES_GROUP_SHORT	TEXT12	CHAR	12	0	Sales Group Abbreviation
47	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
48	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
49	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
50	SERVICE_ORG	☐	CRMT_SERVICE_ORG_SHORT	TEXT12	CHAR	12	0	Service Organization Identifier
51	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
52	PRODUCT_GUID	☐	CRMT_PRODUCT_GUID_32	SYSUUID_C	CHAR	32	0	GUID for Product CHAR32
53	MATERIAL	☐	CRMT_R3_MATERIAL	CRM_R3_MATERIAL	CHAR	18	0	Distribution CRM -> R/3: Material
54	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
55	CATEGORY_GUID	☐	COMT_CATEGORY_GUID	SYSUUID	RAW	16	0	Category GUID
56	SHORT_TEXT_UC	☐	COMT_PRSHTEXTX_UP	PRSHTEXTG40	CHAR	40	0	Product Description
57	CATALOG_ID	☐	CRMT_CATALOG	CRM_CATALOGID	CHAR	20	0	Catalog ID from which the line was selected
58	CATALOG_ITEM_ID	☐	CRMT_CATALOGITEM	CRM_CATALOGITEM	CHAR	40	0	Catalog Item (Unique Key)
59	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
60	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
61	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
62	EXPONENT10	☐	CRMT_EXPONENT10	CRM_EXPONENT10	INT2	5	0	10 Exponent for Quantity Conversion
63	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
64	PROD_PR_GROUP	☐	CRMT_PROD_PR_GROUP	CRM_PROD_PR_GROUP	CHAR	2	0	Product Group	*
65	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
66	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
67	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
68	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
69	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
70	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
71	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
72	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
73	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
74	.INCLUDE	☐				0	0	PRICING_I Data for BW DataSources
75	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
76	TARGET_VALUE	☐	CRMT_TARGET_VALUE	WERTV10	CURR	19	2	Target Value for Contracts
77	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
78	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
79	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
80	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
81	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
82	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
83	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
84	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
85	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
86	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
87	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
88	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
89	BILLING_DATE	☐	CRMT_BW_BILL_DATE	CRM_RPRTNG_DATE	DATS	8	0	Billing Date
90	BILLING_BLOCK	☐	CRMT_BUS_BILL_BLOCK_REASON	CRM_BILLING_BLOCK	CHAR	2	0	Business Partner (CRM): Billing Block Reason	*
91	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
92	PREDEC_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
93	PREDEC_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
94	LOGSYS_PRED	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
95	ORDER_QTY	☐	CRMT_QTY_ORDER	MENG13	QUAN	13	3	CRM: Order Quantity
96	CONFIRMED_QTY	☐	CRMT_QTY_CONFIRMED	MENG13	QUAN	13	3	CRM: Confirmed Quantity
97	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
98	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
99	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
100	REQUESTED_DATE	☐	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
101	CONFIRMED_DATE	☐	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
102	GROSS_VALUE_H	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
103	NET_VALUE_H	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
104	NET_VALUE_MAN_H	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
105	SERVICE_TEAM	☐	CRMT_SERVICE_TEAM	BU_PARTNER	CHAR	10	0	Service Team	*
106	SERVICE_EMPLOYEE	☐	CRMT_SERVICE_EMPLOYEE	BU_PARTNER	CHAR	10	0	Executing Service Employee	*
107	CHA_SRV_RREADY	☐	CHA_SRV_RREADY	CRMT_BW_SRV_CHA_DATES	CHAR	1	0	Data Element for Service-Date Characteristic SLA Date
108	CHA_SRV_CUST_END	☐	CHA_SRV_CUST_END	CRMT_BW_SRV_CHA_DATES	CHAR	1	0	Data Element for Service-Date Char. :Date Requested by Cust.
109	SCHED_QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
110	IOBJECT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
111	IOBJECT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
112	CONFPROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
113	CONFPROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
114	PROD_OBJ_FAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
115	SIMULATED_AT	☐	CRMT_SRVPLAN_SIMULATED_AT	DATUM	DATS	8	0	Simulated On (Forecast)
116	PLANNED_DATE	☐	CRMT_SRVPLAN_PLANNED_DATE	DATUM	DATS	8	0	Planned Date of Service Order (Simulation)
117	DATE_FROM	☐	CRMT_SRVPLAN_DATE_FROM	DATUM	DATS	8	0	Start Date for Simulation
118	DATE_TO	☐	CRMT_SRVPLAN_DATE_TO	DATUM	DATS	8	0	End Date for Simulation
119	HEADER_FLG	☐	CRMT_SRVPLAN_HEADER_FLG	FLAG	CHAR	1	0	Identifies Whether Order Header or Order Item
120	CYCLE_COUNTS	☐	CRMT_SRVPLAN_COUNTER	COUNTING	NUMC	10	0	Number of Release Orders
121	TIMESTAMP_FROM	☐	BCOS_TSTMP	BCOS_TSTMP	DEC	15	0	Time Stamp (In UTC)
122	SRV_CONTR_VALID	☐	FLAG	FLAG	CHAR	1	0	General Flag
123	PRED_PSL_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
124	PRED_PSL_OBJKID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
125	PRED_TMPL_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
126	PRED_TMPL_OBJKID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
127	IMPV_LOGHANDLE	☐	BALLOGHNDL	SYSUUID_22	CHAR	22	0	Application Log: Log Handle

History

Last changed by/on	SAP	20130604
SAP Release Created in	510