SAP ABAP Table CRMT_7130_SALES_UI (Billing)

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_7130_SALES_UI	Table Relationship Diagram
Short Description	Billing

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	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
5	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
6	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
7	PMNTTRMS_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
8	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	T005
9	TAX_DEST_CTY_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
10	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
11	TAX_DEST_REG_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
12	BILL_DATE_TZTF	☐	CRMT_BILL_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Date for Billing Index and Printout
13	BILL_DATE	☐	CRMT_BILL_DATE	BCOS_TSTMP	DEC	15	0	Billing Date for Billing Index and Printout
14	INVCR_DATE_TZTF	☐	CRMT_INVCR_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Document Creation Date
15	INVCR_DATE	☐	CRMT_INVCR_DATE	BCOS_TSTMP	DEC	15	0	Billing Document Creation Date
16	VALUE_DATE_TZTF	☐	CRMT_VALUE_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Fixed Value Date
17	VALUE_DATE	☐	CRMT_VALUE_DATE	BCOS_TSTMP	DEC	15	0	Fixed Value Date
18	RULE_BILL_DATE_T	☐	CRMT_RULE_BILL_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Next Billing Date	TIMERUNA
19	RULE_INV_DATE_T	☐	CRMT_RULE_INVCR_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Next Billing Document Creation Date	TIMERUNA
20	RULE_VAL_DATE_T	☐	CRMT_RULE_VALUE_DATE_T	TIMENAME	CHAR	12	0	Rule for Origin of Next Fixed Value Date	TIMERUNA
21	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
22	NO_INVOICE	☐	CRMT_BILLBLOCK_STATUS	CRM_BILLBLOCK_STATUS	CHAR	1	0	Collective Billing Block Status for Order Header
23	NO_INVOICE_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
24	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
25	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
26	.INCLUDE	☐				0	0	Screen fields for business agreement in document
27	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
28	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
29	ASSIGNED_BP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
30	ASSIGNED_BA_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
31	PAYMENT_METHOD	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	CRMC_BUAG_PAYM

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_7130_SALES_UI	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1
2	CRMT_7130_SALES_UI	PAYMENT_METHOD	CRMC_BUAG_PAYM	PAYM_METH	REF	1	CN
3	CRMT_7130_SALES_UI	PMNTTRMS	CRMC_PMNTTRMS	PAYMENT_TERMS
4	CRMT_7130_SALES_UI	RULE_BILL_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
5	CRMT_7130_SALES_UI	RULE_INV_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
6	CRMT_7130_SALES_UI	RULE_VAL_DATE_T	TIMERUNA	RULE_NAME	REF	1	CN
7	CRMT_7130_SALES_UI	TAX_DEST_CTY	T005	LAND1
8	CRMT_7130_SALES_UI	TAX_DEST_REG	T005S	BLAND

History

Last changed by/on	SAP	20130604
SAP Release Created in