SAP ABAP Table CRMT_7199_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_7199_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	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	CRMC_PROC_TYPE
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
8	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	CREATED_AT	☐	CRMT_CREATED_AT	BCOS_TSTMP	DEC	15	0	Transaction was Created at this Time
10	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
11	CHANGED_AT	☐	CRMT_CHANGED_AT	BCOS_TSTMP	DEC	15	0	Time of Last Change to the Transaction
12	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
13	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	TCURV
14	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
15	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
16	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	CRMC_CPRICPROC
17	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
18	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
19	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
20	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
21	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
22	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
23	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
24	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	T005
25	TAX_DEST_CTY_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
26	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
27	TAX_DEST_REG_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
28	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
29	CUST_GROUP1	☐	CRMT_CUST_GROUP1	CRM_CUST_GROUP1	CHAR	3	0	Customer Group 1	CRMC_CUSTGRP1
30	CUST_GROUP2	☐	CRMT_CUST_GROUP2	CRM_CUST_GROUP2	CHAR	3	0	Customer Group 2	CRMC_CUSTGRP2
31	CUST_GROUP3	☐	CRMT_CUST_GROUP3	CRM_CUST_GROUP3	CHAR	3	0	Customer Group 3	CRMC_CUSTGRP3
32	CUST_GROUP4	☐	CRMT_CUST_GROUP4	CRM_CUST_GROUP4	CHAR	3	0	Customer Group 4	CRMC_CUSTGRP4
33	CUST_GROUP5	☐	CRMT_CUST_GROUP5	CRM_CUST_GROUP5	CHAR	3	0	Customer Group 5	CRMC_CUSTGRP5
34	USAGE_TYPE	☐	CRMT_USAGE	CRM_USAGE	CHAR	3	0	Usage Indicator	CRMC_USAGE
35	INDUSTRY	☐	CRMT_INDUSTRY	CRM_INDUSTRY	CHAR	4	0	Industry Sector	CRMC_INDUSTRY
36	SUBMISSION	☐	CRMT_SUBMISSION	TEXT10	CHAR	10	0	Collective Number for Quotations
37	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
38	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
39	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
40	DELI_UNLIM_TOL	☐	CRMT_DELI_UNLIM_TOL	CRM_BOOLEAN	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
41	OVER_DLV_TOL	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
42	UNDER_DLV_TOL	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
43	DLV_PRIO	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	CRMC_DLV_PRIO
44	ORDERCOMBIND	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
45	CREATED_AT_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
46	CHANGED_AT_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
47	PCAT_HDR_ID	☐	COMT_PCAT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Product Catalog Number
48	PCAT_VRT_ID	☐	COMT_PCAT_VRT_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Variant Number
49	PCAT_CTY_ID	☐	COMT_PCAT_CTY_ID	COM_PCAT_OBJECTID	CHAR	30	0	Catalog Area Number
50	VALID_FROM_TZTF	☐	TZTF_IO_FIELD	TZTF_IO_FIELD	CHAR	26	0	Field for Date Input
51	VALID_FROM_EXT	☐	CRMT_VALID_FROM	BCOS_TSTMP	DEC	15	0	Time Dependency: Validity Start Date
52	PRICING_PROCEDURE	☐	PRCT_PRIC_PROC	PRC_PRIC_PROC	CHAR	6	0	Pricing Procedure	*
53	REQ_RULE	☐	CRMT_REQ_RULE	CRM_REQ_RULE	CHAR	1	0	Requirement Rule
54	SUBST_EXCL	☐	CRMT_ATP_SUBST_EXCL	CRM_ATP_SUBST_EXCL	CHAR	2	0	Rule Criterion 1	CRMC_SUBST_EXCL
55	PAR_ATP_SSTOCK	☐	CRMT_PAR_ATP_SSTOCK	CRM_PAR_ATP_SSTOCK	CHAR	1	0	Parameter-Dependent ATP Safety Stock
56	CONF_RULE	☐	CRMT_CONF_RULE	CRM_CONF_RULE	CHAR	1	0	Confirmation Rule
57	ROUNDING	☐	CRMT_ROUNDING	CRM_ROUNDING	CHAR	1	0	Round Requirement Quantity
58	SEARCH_PATTERN	☐	CRMT_SEARCH_PATTERN	CRM_SEARCH_PATTERN	CHAR	10	0	Rule Criterion 2	CRMC_ATP_SEARCH
59	REASSIGN_ABILITY	☐	CRMT_REASSIGN_ABILITY	CRM_REASSIGN_ABILITY	CHAR	1	0	Reassignment of Order Confirmations
60	DIRECT_SHIP	☐	CRMT_DIRECT_SHIP	FLAG	CHAR	1	0	Direct Delivery Without Consolidation
61	.INCLUDE	☐				0	0	Screen fields for business agreement in document
62	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
63	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
64	ASSIGNED_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
65	ASSIGNED_BA_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
66	ABNORMAL_DEMAND	☐	CRMT_ABNORMAL_DEMAND	CRM_ABNORMAL_DEMAND	CHAR	1	0	Abnormal Demand
67	INV_BEFORE_GI	☐	CRMT_BEFORE_LOADING	CRM_BEFORE_LOADING	CHAR	1	0	Invoice Before Goods Issue (IBGI)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_7199_SALES_UI	CURRENCY	TCURC	WAERS
2	CRMT_7199_SALES_UI	CUST_GROUP	CRMC_CUSTGRP	CUST_GROUP
3	CRMT_7199_SALES_UI	CUST_GROUP1	CRMC_CUSTGRP1	CUST_GROUP1	REF	C	CN
4	CRMT_7199_SALES_UI	CUST_GROUP2	CRMC_CUSTGRP2	CUST_GROUP2	REF	C	CN
5	CRMT_7199_SALES_UI	CUST_GROUP3	CRMC_CUSTGRP3	CUST_GROUP3	REF	C	CN
6	CRMT_7199_SALES_UI	CUST_GROUP4	CRMC_CUSTGRP4	CUST_GROUP4	REF	C	CN
7	CRMT_7199_SALES_UI	CUST_GROUP5	CRMC_CUSTGRP5	CUST_GROUP5	REF	C	CN
8	CRMT_7199_SALES_UI	CUST_PRIC_PROC	CRMC_CPRICPROC	CUST_PRIC_PROC
9	CRMT_7199_SALES_UI	DLV_PRIO	CRMC_DLV_PRIO	DLV_PRIO	REF	C	CN
10	CRMT_7199_SALES_UI	EXCHG_TYPE	TCURV	KURST
11	CRMT_7199_SALES_UI	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1
12	CRMT_7199_SALES_UI	INDUSTRY	CRMC_INDUSTRY	INDUSTRY	REF	C	CN
13	CRMT_7199_SALES_UI	PMNTTRMS	CRMC_PMNTTRMS	PAYMENT_TERMS
14	CRMT_7199_SALES_UI	PRICE_GRP	CRMC_PRICEGRP	PRICE_GROUP
15	CRMT_7199_SALES_UI	PRICE_LIST	CRMC_PRICELIST	PRICE_LIST	REF	C	CN
16	CRMT_7199_SALES_UI	PROCESS_TYPE	CRMC_PROC_TYPE	PROCESS_TYPE	REF	1	CN
17	CRMT_7199_SALES_UI	SEARCH_PATTERN	CRMC_ATP_SEARCH	SEARCH_PATTERN
18	CRMT_7199_SALES_UI	SHIP_COND	CRMC_SHIP_COND	SHIP_COND	REF	C	CN
19	CRMT_7199_SALES_UI	SUBST_EXCL	CRMC_SUBST_EXCL	SUBST_EXCL
20	CRMT_7199_SALES_UI	TAX_DEST_CTY	T005	LAND1
21	CRMT_7199_SALES_UI	TAX_DEST_REG	T005S	BLAND
22	CRMT_7199_SALES_UI	USAGE_TYPE	CRMC_USAGE	CALL_USAGE	REF	C	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in