SAP ABAP Table CRMD_DHR_HSLSQUO (Sales Quotations)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_DHR_HSLSQUO	Table Relationship Diagram
Short Description	Sales Quotations

Delivery and Maintenance

Pool/cluster
Delivery Class	S	System table, maint. only by SAP, change = modification
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☑	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	ITEMS_INVALID	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
4	.INCLUDE	☐				0	0	Structure for Sales quotation header buffer table
5	CHANGED_AT	☐	CRMT_CHANGED_AT_USR	CRM_TSTMP	DEC	15	0	Changed On (Output in User Time Zone)
6	.INCLUDE	☐				0	0	Extract Structure for OLTP Slaes Quotation internal fields
7	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
8	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
9	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-To Party ID	*
10	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
11	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
12	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
13	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
14	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
15	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
16	USER_STAT_PROC	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
17	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
18	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
19	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
20	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
21	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
22	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
23	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
24	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
25	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
26	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
27	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
28	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
29	STAT_QUOT	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
30	SOLD_TO_COUNTRY	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	*
31	SOLD_TO_REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
32	CP_PROGRAM	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
33	CP_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
34	CP_STATUS	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
35	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
36	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
37	.INCLUDE	☐				0	0	EEW Include
38	R_SLSQUOT_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
39	.INCLUDE	☐				0	0

History

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