SAP ABAP Table CRMT_BSP_SLS_H_GENERAL_IL (Sales Data: General Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BSP_MODEL_IL_1O (Package) Model Implementation: Business Transaction

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_SLS_H_GENERAL_IL	Table Relationship Diagram
Short Description	Sales Data: General Data

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	Management of Interface Structures
2	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
4	.INCLUDE	☐				0	0	Sales: General Data
5	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
6	.INCLUDE	☐				0	0	Sales: Sales Data
7	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	*
8	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	*
9	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	*
10	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	*
11	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	*
12	PO_NUMBER_SOLD	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
13	PO_DATE_SOLD	☐	CRMT_PO_DATE_SOLD	DATUM	DATS	8	0	Reference Document Date
14	YOUR_REF_SOLD	☐	CRMT_YOUR_REFERENCE_SOLD	TEXT12	CHAR	12	0	Sold-to Party Reference
15	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	*
16	REGION	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
17	PO_NUMBER_SHIP	☐	CRMT_PO_NUMBER_SHIP	TEXT35	CHAR	35	0	Ship-To Party's External Reference Number
18	PO_DATE_SHIP	☐	CRMT_PO_DATE_SHIP	DATUM	DATS	8	0	Ship-To Party's Reference Document Date
19	YOUR_REF_SHIP	☐	CRMT_YOUR_REFERENCE_SHIP	TEXT12	CHAR	12	0	Ship-To Party Reference
20	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	*
21	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
22	REJECTION	☐	CRMT_REJECTION_CODE	CRM_REJECTION_CODE	CHAR	2	0	Cancellation Reason Code	*
23	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
24	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
25	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
26	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
27	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
28	INT_INSPECTION	☐	CRMT_INT_INSPECTION	CRM_ITEM_INSPECTION	CHAR	4	0	Internal Quality Inspection	CRMC_ITEM_INSP
29	HNDLCODE	☐	CRM_PROD_HNDLCODE	CRM_PROD_HNDLCODE	CHAR	4	0	Handling Indicator	*
30	HNDLCODE_TEXT	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
31	.INCLUDE	☐				0	0	Sales: Delivery Data
32	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
33	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
34	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
35	DELI_UNLIM_TOL	☐	CRMT_DELI_UNLIM_TOL	CRM_BOOLEAN	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
36	OVER_DLV_TOL	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
37	UNDER_DLV_TOL	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
38	DLV_PRIO	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	*
39	ORDERCOMBIND	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
40	PART_DLV	☐	CRMT_PART_DLV	CRM_PART_DLV	CHAR	1	0	Delivery Control
41	DLV_GROUP	☐	CRMT_DLV_GROUP	CRMT_DLV_GROUP	NUMC	3	0	Delivery Group (Items are Delivered Together)
42	PART_DLV_ITM	☐	CRMT_PART_DLV_ITM	CRM_PART_DLV_ITM	CHAR	1	0	Delivery Control (Item)
43	REQ_DATE	☐	CRMT_BSP_REQ_DLV_DATE	DATS	DATS	8	0	Requested Delivery Date: Input/Output Field
44	REQ_TIME	☐	CRMT_BSP_TIME	CHAR6	CHAR	6	0	Time
45	REQ_TIMEVALUE	☐	CHAR6	CHAR6	CHAR	6	0	Character field of length 6
46	REQ_DATE_TZTF	☐	CRMT_REQ_DLV_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Requested Delivery Date: Input/Output Field
47	RULE_REQ_DATE_T	☐	CRMT_RULE_REQ_DATE_T	TIMENAME	CHAR	12	0	Rule Req Delivery Date
48	TRANS_MOT	☐	CRMT_TRANS_MOT	CRM_TRANS_MOT	CHAR	2	0	Mode of Transport	CRMC_TRANS_MOT
49	GEOROUTE	☐	CRMT_GEOROUTE	CRM_GEOROUTE	CHAR	10	0	Route
50	TRANS_MEANS	☐	CRMT_TRANS_MEANS	CRM_TRANS_MEANS	CHAR	10	0	Means of Transport (from SCM System)
51	INV_BEFORE_GI	☐	CRMT_BEFORE_LOADING	CRM_BEFORE_LOADING	CHAR	1	0	Invoice Before Goods Issue (IBGI)
52	.INCLUDE	☐				0	0	Sales: Org. Management
53	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
54	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
55	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
56	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
57	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
58	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
59	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
60	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
61	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
62	SALES_OFFICE_SHORT	☐	CRMT_SALES_OFFICE_SHORT	TEXT12	CHAR	12	0	Sales Office Abbreviation
63	SALES_GROUP_SHORT	☐	CRMT_SALES_GROUP_SHORT	TEXT12	CHAR	12	0	Sales Group Abbreviation
64	SALES_ORG_RESP_SHORT	☐	CRMT_SALES_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Sales)
65	SERVICE_ORG_SHORT	☐	CRMT_SERVICE_ORG_SHORT	TEXT12	CHAR	12	0	Service Organization Identifier
66	SERVICE_ORG_RESP_SHORT	☐	CRMT_SERVICE_ORG_RESP_SHORT	TEXT12	CHAR	12	0	Abbreviation: Responsible Organizational Unit (Service)
67	SALES_ORG_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
68	SALES_OFFICE_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
69	SALES_GROUP_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
70	SALES_ORG_RESP_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
71	DIS_CHANNEL_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
72	SERVICE_ORG_RESP_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
73	SERVICE_ORG_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
74	DIVISION_DSCR	☐	CRMT_DESCRIPTION_40	TEXT40	CHAR	40	0	Description (40 Characters)
75	.INCLUDE	☐				0	0	Source Organizational Data Sales
76	SALES_ORG_ORI	☐	CRMT_SALES_ORG_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Organization
77	DIS_CHANNEL_ORI	☐	CRMT_DIS_CHANNEL_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Distribution Channel
78	SALES_OFF_ORI	☐	CRMT_SALES_OFFICE_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Office
79	SALES_GROUP_ORI	☐	CRMT_SALES_GROUP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Group
80	SALES_ORGR_ORI	☐	CRMT_SALES_ORG_RESP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Scenario Organizational Unit
81	DIVISION_ORI	☐	CRMT_DIVISION_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Flag: Division
82	.INCLUDE	☐				0	0	Source Organizational Data for Service
83	SERVICE_ORG_ORI	☐	CRMT_SERVICE_ORG_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Service Organization
84	SERVICE_ORGR_ORI	☐	CRMT_SERVICE_ORG_RESP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Service Scenario Organizational Unit
85	.INCLUDE	☐				0	0	Sales: Cumulated Header Data
86	GROSS_WEIGHT	☐	CRMT_GROSS_WEIGHT_CUM	MENG15	QUAN	15	3	Gross Weight for Total Document
87	NET_WEIGHT	☐	CRMT_NET_WEIGHT_CUM	MENG15	QUAN	15	3	Net Weight of Total Document
88	VOLUME	☐	CRMT_VOLUME_CUM	MENG15	QUAN	15	3	Total Volume of Document
89	VOLUME_UNIT	☐	COMT_VOLUME_UNIT	MEINS	UNIT	3	0	Unit for the Volume of a Product	*
90	WEIGHT_UNIT	☐	COMT_WEIGHT_UNIT	MEINS	UNIT	3	0	Weight Unit	*
91	GROSS_VALUE	☐	CRMT_GROSS_VALUE_CUM	WERTV8	CURR	15	2	Total Gross Value of Document in Document Currency
92	NET_VALUE	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
93	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
94	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT_CUM	WERTV8	CURR	15	2	Total Tax Amount in Document Currency
95	FREIGHT	☐	CRMT_FREIGHT_CUM	WERTV8	CURR	15	2	Shipment Costs for Document in Total Document Currency
96	NET_WO_FREIGHT	☐	CRMT_NET_WO_FREIGHT_CUM	WERTV8	CURR	15	2	Header sums: Net value without freight
97	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
98	NUMBER_ITEMS	☐	CRMT_NUMBER_ITEMS		INT2	5	0	Number of items in an order
99	.INCLUDE	☐				0	0	Sales Billing Data
100	BILL_DATE	☐	CRMT_BSP_BILL_DATE	DATS	DATS	8	0	Billing Date for Billing Index and Printout
101	BILL_DATE_TZTF	☐	CRMT_BILL_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Date for Billing Index and Printout
102	INVCR_DATE_TZTF	☐	CRMT_INVCR_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Document Creation Date
103	VALUE_DATE_TZTF	☐	CRMT_VALUE_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Fixed Value Date
104	RULE_BILL_DATE_T	☐	CRMT_RULE_BILL_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Next Billing Date
105	RULE_INV_DATE_T	☐	CRMT_RULE_INVCR_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Next Billing Document Creation Date
106	RULE_VAL_DATE_T	☐	CRMT_RULE_VALUE_DATE_T	TIMENAME	CHAR	12	0	Rule for Origin of Next Fixed Value Date
107	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
108	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
109	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
110	.INCLUDE	☐				0	0	Sales: PRICING
111	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
112	PMNTTRMS_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
113	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
114	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
115	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
116	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
117	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	*
118	TAX_DEST_CTY_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
119	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
120	TAX_DEST_REG_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
121	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
122	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
123	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	*
124	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
125	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	*
126	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	*
127	PRICING_PROCEDURE	☐	PRCT_PRIC_PROC	PRC_PRIC_PROC	CHAR	6	0	Pricing Procedure	*
128	ETAX_HAND_TYPE	☐	CRMT_ETAX_HAND_TYPE	CRM_ETAX_HAND_TYPE	CHAR	2	0	Excise Tax Handling Type (Denotes Use of Material)	CRMC_ETAX_HTYP
129	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
130	PAYMENT_METHOD	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	*
131	.INCLUDE	☐				0	0	ATP-Relevant Fields in Schedule Line
132	CONF_RULE	☐	CRMT_CONF_RULE	CRM_CONF_RULE	CHAR	1	0	Confirmation Rule
133	REQ_RULE	☐	CRMT_REQ_RULE	CRM_REQ_RULE	CHAR	1	0	Requirement Rule
134	PAR_ATP_SSTOCK	☐	CRMT_PAR_ATP_SSTOCK	CRM_PAR_ATP_SSTOCK	CHAR	1	0	Parameter-Dependent ATP Safety Stock
135	REASSIGN_ABILITY	☐	CRMT_REASSIGN_ABILITY	CRM_REASSIGN_ABILITY	CHAR	1	0	Reassignment of Order Confirmations
136	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
137	ROUNDING	☐	CRMT_ROUNDING	CRM_ROUNDING	CHAR	1	0	Round Requirement Quantity
138	DIRECT_SHIP	☐	CRMT_DIRECT_SHIP	FLAG	CHAR	1	0	Direct Delivery Without Consolidation
139	SUBST_EXCL	☐	CRMT_ATP_SUBST_EXCL	CRM_ATP_SUBST_EXCL	CHAR	2	0	Rule Criterion 1	CRMC_SUBST_EXCL
140	SEARCH_PATTERN	☐	CRMT_SEARCH_PATTERN	CRM_SEARCH_PATTERN	CHAR	10	0	Rule Criterion 2	CRMC_ATP_SEARCH
141	.INCLUDE	☐				0	0
142	.INCLUDE	☐				0	0
143	.INCLUDE	☐				0	0
144	.INCLUDE	☐				0	0
145	.INCLUDE	☐				0	0
146	.INCLUDE	☐				0	0
147	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
148	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	TB004

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_SLS_H_GENERAL_IL	CURRENCY	TCURC	WAERS
2	CRMT_BSP_SLS_H_GENERAL_IL	CUSTOMER_TYPE	TB004	BPKIND
3	CRMT_BSP_SLS_H_GENERAL_IL	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
4	CRMT_BSP_SLS_H_GENERAL_IL	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
5	CRMT_BSP_SLS_H_GENERAL_IL	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1
6	CRMT_BSP_SLS_H_GENERAL_IL	INT_INSPECTION	CRMC_ITEM_INSP	ITEM_INSPECTION
7	CRMT_BSP_SLS_H_GENERAL_IL	PMNTTRMS	CRMC_PMNTTRMS	PAYMENT_TERMS
8	CRMT_BSP_SLS_H_GENERAL_IL	SEARCH_PATTERN	CRMC_ATP_SEARCH	SEARCH_PATTERN
9	CRMT_BSP_SLS_H_GENERAL_IL	SHIP_COND	CRMC_SHIP_COND	SHIP_COND
10	CRMT_BSP_SLS_H_GENERAL_IL	SUBST_EXCL	CRMC_SUBST_EXCL	SUBST_EXCL
11	CRMT_BSP_SLS_H_GENERAL_IL	TRANS_MOT	CRMC_TRANS_MOT	MOT

History

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