SAP ABAP Table CRMT_1130_TSALES_UI (Header 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_1130_TSALES_UI	Table Relationship Diagram
Short Description	Header 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	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
5	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	T005
6	TAX_DEST_CTY_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
7	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
8	TAX_DEST_REG_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
9	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
10	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
11	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
12	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
13	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
14	PMNTTRMS_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
15	ORDERCOMBIND	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
16	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
17	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
18	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
19	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	CRMC_PRICELIST
20	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	CRMC_PRICEGRP
21	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
22	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	CRMC_CUSTGRP
23	.INCLUDE	☐				0	0	Screen fields for business agreement in document
24	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
25	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
26	ASSIGNED_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
27	ASSIGNED_BA_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
28	PAYMENT_METHOD	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	CRMC_BUAG_PAYM
29	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_1130_TSALES_UI	CURRENCY	TCURC	WAERS
2	CRMT_1130_TSALES_UI	CUSTOMER_TYPE	TB004	BPKIND	KEY
3	CRMT_1130_TSALES_UI	CUST_GROUP	CRMC_CUSTGRP	CUST_GROUP
4	CRMT_1130_TSALES_UI	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1
5	CRMT_1130_TSALES_UI	PAYMENT_METHOD	CRMC_BUAG_PAYM	PAYM_METH	REF	1	CN
6	CRMT_1130_TSALES_UI	PMNTTRMS	CRMC_PMNTTRMS	PAYMENT_TERMS
7	CRMT_1130_TSALES_UI	PRICE_GRP	CRMC_PRICEGRP	PRICE_GROUP
8	CRMT_1130_TSALES_UI	PRICE_LIST	CRMC_PRICELIST	PRICE_LIST
9	CRMT_1130_TSALES_UI	SHIP_COND	CRMC_SHIP_COND	SHIP_COND	REF	C	CN
10	CRMT_1130_TSALES_UI	TAX_DEST_CTY	T005	LAND1
11	CRMT_1130_TSALES_UI	TAX_DEST_REG	T005S	BLAND

History

Last changed by/on	SAP	20130604
SAP Release Created in	12A