SAP ABAP Table CRMT_7110_SALES_UI (Header Data Detail Sales)

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_7110_SALES_UI	Table Relationship Diagram
Short Description	Header Data Detail Sales

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	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
5	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
6	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
7	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
8	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
9	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
10	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
11	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	CRMC_USAGE
12	TAX_DEPART_CTY	☐	CRMT_TAX_DEPART_CTY	LAND1	CHAR	3	0	Tax Departure Country	*
13	TAX_DEPART_REG	☐	CRMT_TAX_DEPART_REG	REGIO	CHAR	3	0	Departure Region for Tax	*
14	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
15	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
16	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	CRMC_CPRICPROC
17	PRICING_PROCEDURE	☐	PRCT_PRIC_PROC	PRC_PRIC_PROC	CHAR	6	0	Pricing Procedure	*
18	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
19	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
20	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	T005
21	TAX_DEST_REG	☐	CRMT_TAX_DEST_REG	REGIO	CHAR	3	0	Taxable Recipient Region	T005S
22	AC_INDICATOR	☐	CRMT_AC_INDICATOR	CRMT_AC_INDICATOR	CHAR	2	0	Accounting Indicator	CRMC_AC_IND

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_7110_SALES_UI	AC_INDICATOR	CRMC_AC_IND	AC_INDICATOR		1	CN
2	CRMT_7110_SALES_UI	CURRENCY	TCURC	WAERS
3	CRMT_7110_SALES_UI	CUST_GROUP	CRMC_CUSTGRP	CUST_GROUP
4	CRMT_7110_SALES_UI	CUST_PRIC_PROC	CRMC_CPRICPROC	CUST_PRIC_PROC
5	CRMT_7110_SALES_UI	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
6	CRMT_7110_SALES_UI	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
7	CRMT_7110_SALES_UI	PRICE_GRP	CRMC_PRICEGRP	PRICE_GROUP
8	CRMT_7110_SALES_UI	PRICE_LIST	CRMC_PRICELIST	PRICE_LIST
9	CRMT_7110_SALES_UI	TAX_DEST_CTY	T005	LAND1
10	CRMT_7110_SALES_UI	TAX_DEST_REG	T005S	BLAND
11	CRMT_7110_SALES_UI	USAGE_TYPE	CRMC_USAGE	CALL_USAGE	REF	C	CN

History

Last changed by/on	SAP	20110908
SAP Release Created in