SAP ABAP Table CRMST_QUERY_SLSORD_BTIL (BTIL structure für Sales Order - Search criteria)

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	CRMST_QUERY_SLSORD_BTIL	Table Relationship Diagram
Short Description	BTIL structure für Sales Order - Search criteria

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_ID	☐	CRMT_UIU_SALES_ORDER_ID	CRM_OBJECT_ID	CHAR	10	0	Sales Order ID
2	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
3	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
4	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
5	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
6	BU_PARTNER	☐	CRMT_BSP_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Usage Within BSP
7	SOLD_TO_PARTY	☐	CRMT_UIU_SOLD_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Sold-To Party
8	SHIP_TO_PARTY	☐	CRMT_UIU_SHIP_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Ship-To Party
9	BILL_TO_PARTY	☐	CRMT_UIU_BILL_TO_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Bill-To Party
10	CONTACT_PERSON	☐	CRMT_UIU_CONTACT_PARTY	CRM_PARTNER_NUMBER	CHAR	20	0	Contact
11	EMPLOYEE_RESP	☐	CRMT_UIU_EMPLOYEE_RESP	CRM_PARTNER_NUMBER	CHAR	20	0	Employee Responsible
12	PRODUCT_ID	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
13	PRODUCT_KIND_SEL	☐	CRMT_PRODUCT_LOC_2	CRM_PRODUCT_LOC_2	CHAR	2	0	Product/Product Selection for Locator/OIC (Product/IObject)
14	STATUS_AREA	☐	CRMT_STATUS_AREA_OIC	CRM_STATUS_AREA_OIC	CHAR	13	0	Status Area (All, Completed, Not Completed)
15	STATUS_COMMON	☐	CRMT_STATUS_COMMON		CHAR	13	0	General Status (User, System, Area)
16	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
17	POSTING_DATE	☐	CRMT_UIU_POSTING_DATE_RANGE		DATS	8	0	Posting Date Free Selection
18	POSTING_DATE_PERIOD	☐	CRMT_UIU_POSTING_DATE_PERIOD	CRMT_DATE_RANGE	CHAR	5	0	Posting Date Period
19	CARD_TYPE	☐	CRMT_CC_INSTITUTE	CC_INSTITUTE	CHAR	4	0	Payment Card Type	*
20	CARD_NO	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
21	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
22	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
23	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
24	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
25	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
26	PAYER	☐	CRMT_PAYER_ID	BU_PARTNER	CHAR	10	0	Payer ID	*
27	PAYER_NAME	☐	CRMT_UIU_PAYER_NAME	CHAR40	CHAR	40	0	Payer Name
28	SHIP_TO_PARTY_NAME	☐	CRMT_UIU_SHIP_TO_PARTY_NAME	CHAR40	CHAR	40	0	Ship-To Party Name
29	SOLD_TO_PARTY_NAME	☐	CRMT_UIU_SOLD_TO_PARTY_NAME	CHAR40	CHAR	40	0	Sold-To Party Name
30	EMPLOYEE_RESP_LASTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_LASTNA	CHAR40	CHAR	40	0	Employee Responsible Last Name
31	EMPLOYEE_RESP_FIRSTNAME	☐	CRMT_UIU_EMPLOYEE_RESP_FIRSTNA	CHAR40	CHAR	40	0	Employee Responsible First Name
32	BILL_TO_PARTY_NAME	☐	CRMT_UIU_BILL_TO_PARTY_NAME	CHAR40	CHAR	40	0	Bill-To Party Name
33	CONTACT_FIRSTNAME	☐	CRMT_UIU_CONTACT_FIRSTNAME	CHAR40	CHAR	40	0	Contact First Name
34	CONTACT_LASTNAME	☐	CRMT_UIU_CONTACT_LASTNAME	CHAR40	CHAR	40	0	Contact Last Name
35	CHANNEL_PARTNER	☐	CRMT_UIU_SALES_PARTNER	BU_PARTNER	CHAR	10	0	Sales Partner ID	*
36	CHANNEL_PARTNER_NAME	☐	CRMT_UIU_SALES_PARTNER_NAME	CHAR40	CHAR	40	0	Sales Partner Name
37	RESP_CHAN_PARTNER_FIRSTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_FN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner First Name
38	RESP_CHAN_PARTNER_LASTNAME	☐	CRMT_UIU_RESP_AT_CHAN_PART_LN	CHAR40	CHAR	40	0	Employee Resp. at Channel Partner Last Name
39	RESP_CHAN_PARTNER	☐	CRMT_RESP_AT_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Responsible at Channel Partner	*
40	RESPONS_AREA	☐	CRMT_RESPONS_AREA_OIC	CRM_RESPONS_AREA_OIC	CHAR	1	0	Belonging To (Me, My Department, My Group)
41	BU_PARTNER_NAME	☐	CRMT_UIU_PARTNER_NAME	CHAR40	CHAR	40	0	Partner Name
42	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
43	TERR_DESCRIPTION	☐	CRMT_TERRITORY_DESCRIPTION	TEXT40	CHAR	40	0	Territory Description
44	.INCLUDE	☐				0	0	EEW Include
45	EEW_BUS2000115_SEARCH_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
46	.INCLUDE	☐				0	0
47	PARTNER_COMB	☐	CRMT_UIU_PARTNER_TO_PARTNERFCT	CHAR40	CHAR	40	0	Partner In Partner Function
48	INCL_SUB_TERR	☐	CRMT_SUB_TERR_IND	CRM_SUB_TERR_IND	CHAR	1	0	Indicator: Include Subterritories in Territory Search

History

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