SAP ABAP Table CRMT_7210_SALES_UI (Item Data Detail Sales A)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF (Application Component) Basic Functions for Business Transactions
     ⤷ CRM_USERFACE (Package) User Interface One Order

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_7210_SALES_UI	Table Relationship Diagram
Short Description	Item Data Detail Sales A

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	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
5	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
6	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
7	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
8	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	CRMC_USAGE
9	PROCESS_QTY_NUM	☐	CRMT_PROCESS_QTY_NUM	CRM_PROCESS_QTY_NUM	INT4	10	0	Numerator (factor) for conversion trans. quantity in BME
10	PROCESS_QTY_DEN	☐	CRMT_PROCESS_QTY_DEN	CRM_PROCESS_QTY_DEN	INT4	10	0	Denominator (factor) for conversion trans. quantity in BME
11	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
12	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
13	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
14	TAX_DEPART_CTY	☐	CRMT_TAX_DEPART_CTY	LAND1	CHAR	3	0	Tax Departure Country	*
15	TAX_DEPART_REG	☐	CRMT_TAX_DEPART_REG	REGIO	CHAR	3	0	Departure Region for Tax	*
16	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
17	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
18	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
19	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
20	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
21	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
22	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
23	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
24	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
25	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
26	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
27	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
28	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	T005
29	TAX_DEST_REG	☐	CRMT_TAX_DEST_REG	REGIO	CHAR	3	0	Taxable Recipient Region	T005S
30	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
31	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
32	TAX_GROUP_P	☐	CRMT_TAX_GROUP	CRM_TAX_GROUP	CHAR	20	0	Product Tax Group	CRMC_TAX_GROUP
33	TAX_GROUP_P_CTY	☐	CRMT_TAX_LAND	LAND1	CHAR	3	0	Tax Country	CRMC_TAX_GROUP
34	TAX_GROUP_P_REG	☐	CRMT_TAX_REGION	REGIO	CHAR	3	0	Tax Region	CRMC_TAX_GROUP
35	TAX_GROUP_P_TTP	☐	CRMT_TAX_TYPE	BUTX_TAX_TYPE	CHAR	4	0	Tax Type	CRMC_TAX_GROUP
36	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	CRMC_AC_IND
37	AC_IND_TXT	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_7210_SALES_UI	AC_INDICATOR	CRMC_AC_IND	AC_INDICATOR	KEY
2	CRMT_7210_SALES_UI	CURRENCY	TCURC	WAERS
3	CRMT_7210_SALES_UI	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
4	CRMT_7210_SALES_UI	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
5	CRMT_7210_SALES_UI	TAX_DEST_CTY	T005	LAND1
6	CRMT_7210_SALES_UI	TAX_DEST_REG	T005S	BLAND
7	CRMT_7210_SALES_UI	TAX_GROUP_P	CRMC_TAX_GROUP	TAX_TYPE
8	CRMT_7210_SALES_UI	TAX_GROUP_P_CTY	CRMC_TAX_GROUP	CLIENT
9	CRMT_7210_SALES_UI	TAX_GROUP_P_REG	CRMC_TAX_GROUP	TAX_CTY
10	CRMT_7210_SALES_UI	TAX_GROUP_P_TTP	CRMC_TAX_GROUP	TAX_REG
11	CRMT_7210_SALES_UI	USAGE_TYPE	CRMC_USAGE	CALL_USAGE	REF	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in