SAP ABAP Table CRMD_DHR_HSLSAGR (Sales agreements)

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_HSLSAGR	Table Relationship Diagram
Short Description	Sales agreements

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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 agreement 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 Sales agreement 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	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
13	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
14	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
15	USER_STAT_PROC	☐	CRM_J_STSMA	CRM_J_STSMA	CHAR	8	0	Status Profile	*
16	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
17	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
18	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
19	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
20	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
21	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
22	PO_NUMBER_UC	☐	CRMT_PO_NUMBER_UC	CHAR35	CHAR	35	0	Sold-to Party's External Reference No. (in Capital Letters)
23	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
24	RESP_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
25	CHANNEL_PARTNER	☐	CMST_CHANNEL_PARTNER	BU_PARTNER	CHAR	10	0	Channel Partner	*
26	SOLD_TO_COUNTRY	☐	CRMT_COUNTRY	LAND1	CHAR	3	0	Country	*
27	SOLD_TO_REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
28	CP_PROGRAM	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
29	CP_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
30	CP_STATUS	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
31	CANCPARTY	☐	CRMT_CANC_PARTY	CRM_CANC_PARTY	CHAR	4	0	Cancelling Party
32	CANC_REASON	☐	CRMT_SRV_CANCEL_REASON	QCODE	CHAR	4	0	CRM Service : Reason for Cancellation	*
33	NUMSLSO_SUCC_CON	☐	CRMT_NUMSLSO_SUCC_CON	INT4	INT4	10	0	No. of Sales Orders Succeeding Customer Contract
34	PATH_ID	☐	CRMT_TERRITORY_PATH_ID	CRM_TERRITORY_PATH_ID	CHAR	30	0	Territory Hierarchy ID
35	TERR_ID	☐	CRMT_TERRITORY_ID	CRM_TERRITORY_ID	CHAR	30	0	Territory ID
36	STAT_CREDIT	☐	CRMT_STATUS_CRED	CRMT_STATUS_CRED	CHAR	1	0	Credit Block on Transaction
37	STAT_OPEN	☐	CRMT_STATUS_OPEN	CRM_BOOLEAN	CHAR	1	0	Transaction is Still Open
38	STAT_REJECTED	☐	CRMT_STATUS_REJECTED	BOOLEAN	CHAR	1	0	Status: Rejected
39	.INCLUDE	☐				0	0	EEW Include
40	R_SLSAGR_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

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