SAP ABAP Table /MACCRM/QUERY_FSMAC_BTIL (FS MAC search criteria structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LAM-BTX-MAC (Application Component) Multiple-Asset Contracts
     ⤷ /MACCRM/IL (Package) CRM FS: Interaction Layer for Multiple-Asset Contracts

Basic Data

Table Category	INTTAB	Structure
Structure	/MACCRM/QUERY_FSMAC_BTIL	Table Relationship Diagram
Short Description	FS MAC search criteria 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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
5	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
6	STATUS_SYSTEM	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
7	.INCLUDE	☐				0	0	BTIL structure für Sales Order - Search criteria
8	MACID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
9	EMP_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
10	PERSON_RESP_LIST	☐	CRMT_PERSON_RESP_LIST	TEXT80	CHAR	80	0	Employee Responsible
11	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
12	OBJECT_ID_M	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
13	SOLD_TO	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
14	SHIP_TO	☐	CRMT_SHIP_TO_PART	BU_PARTNER	CHAR	10	0	Ship-To Party	*
15	CONTACT	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
16	BU_PARTNER_M	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
17	BU_PARTNER_SECOND	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
18	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
19	PARTNER_FCT_SECOND	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
20	PRODUCT_ID	☐	CRMT_PRODUCT_ID	CRM_ORDERED_PROD	CHAR	54	0	Product ID
21	PRODUCT_KIND_SEL	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
22	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
23	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
24	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
25	DESCRIPTION_M	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
26	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
27	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
28	POSTING_DATE_PERIOD	☐	CRM_POSTING_DATE_SEL	CRM_DATE_SEL	CHAR	1	0	Posting Date Selection (for Example, This Week, Last Week)
29	CLASSIFICATION	☐	CRMT_CLASSIFICATION	CRMT_CLASSIFICATION	NUMC	2	0	Contract Class
30	VEH_ID_NR	☐	CRMT_ALTID_VALUE_VEH_ID_NR	CHAR40	CHAR	40	0	Vehicle Identification Number
31	LIC_PLATE	☐	CRMT_ALTID_VALUE_LIC_PLATE	CHAR40	CHAR	40	0	Official License Plate Number
32	CATEGORY_ID	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
33	ID_TYPE	☐	COMT_BSP_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
34	ID_VALUE	☐	COMT_BSP_ALTID_VALUE_40	CHAR40	CHAR	40	0	Field Value for Alternative IDs
35	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
36	NET_VALUE	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
37	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
38	START_DATE_RANGE	☐	CRMT_REPORT_STARTDATE	DATUM	DATS	8	0	Start Date
39	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
40	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
41	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS	CRM_OJ_NAME_PROCESS	CHAR	10	0	Leading Business Transaction Category	*
42	BTX_CLASS	☐	CRMT_TRANSACTION_CLASSIFICATN	CRM_TRANSACTION_CLASSIFICATION	CHAR	1	0	CRM Business Transaction Classification
43	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
44	SOLD_TO_NAME	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
45	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
46	.INCLUDE	☐				0	0	EEW Include
47	EEW_BUS2000114_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
48	.INCLUDE	☐				0	0
49	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
50	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
51	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*

History

Last changed by/on	SAP	20131122
SAP Release Created in	100