SAP ABAP Table CRMT_BSP_SLS_OD1_PRICING (Sales ODC1 - General)

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_OD1_PRICING	Table Relationship Diagram
Short Description	Sales ODC1 - General

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_SLS_OD1_PRICING	CURRENCY	TCURC	WAERS
2	CRMT_BSP_SLS_OD1_PRICING	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
3	CRMT_BSP_SLS_OD1_PRICING	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
4	CRMT_BSP_SLS_OD1_PRICING	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1
5	CRMT_BSP_SLS_OD1_PRICING	INT_INSPECTION	CRMC_ITEM_INSP	ITEM_INSPECTION
6	CRMT_BSP_SLS_OD1_PRICING	PMNTTRMS	CRMC_PMNTTRMS	PAYMENT_TERMS
7	CRMT_BSP_SLS_OD1_PRICING	SHIP_COND	CRMC_SHIP_COND	SHIP_COND
8	CRMT_BSP_SLS_OD1_PRICING	TRANS_MOT	CRMC_TRANS_MOT	MOT

History

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