SAP ABAP Table CRMT_BSP_BTX_BRI_BILLING_IL (Billing Plan Items: Billing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX (Application Component) Business Transactions
     ⤷ CRM_BSP_MODEL_IL_1O (Package) Model Implementation: Business Transaction

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_BTX_BRI_BILLING_IL	Table Relationship Diagram
Short Description	Billing Plan Items: 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	.INCLUDE	☐				0	0	Billing Plan Items: Billing - Delivery Data
5	INCOTERMS1	☐	CRMT_INCOTERMS1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (Part 1)	CRMC_INCOTERM
6	INCOTERMS2	☐	CRMT_INCOTERMS2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (Part 2)
7	SHIP_COND	☐	CRMT_SHIP_COND	CRM_SHIP_COND	CHAR	2	0	Shipping Conditions	CRMC_SHIP_COND
8	DELI_UNLIM_TOL	☐	CRMT_DELI_UNLIM_TOL	CRM_BOOLEAN	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
9	OVER_DLV_TOL	☐	CRMT_OVER_DLV_TOL	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
10	UNDER_DLV_TOL	☐	CRMT_UNDER_DLV_TOL	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
11	DLV_PRIO	☐	CRMT_DLV_PRIO	CRM_DLV_PRIO	NUMC	2	0	Delivery Priority	*
12	ORDERCOMBIND	☐	CRMT_ORDERCOMBIND	CRM_BOOLEAN	CHAR	1	0	Indicator: Order Combination
13	PART_DLV	☐	CRMT_PART_DLV	CRM_PART_DLV	CHAR	1	0	Delivery Control
14	DLV_GROUP	☐	CRMT_DLV_GROUP	CRMT_DLV_GROUP	NUMC	3	0	Delivery Group (Items are Delivered Together)
15	PART_DLV_ITM	☐	CRMT_PART_DLV_ITM	CRM_PART_DLV_ITM	CHAR	1	0	Delivery Control (Item)
16	REQ_DATE_TZTF	☐	CRMT_REQ_DLV_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Requested Delivery Date: Input/Output Field
17	RULE_REQ_DATE_T	☐	CRMT_RULE_REQ_DATE_T	TIMENAME	CHAR	12	0	Rule Req Delivery Date
18	TRANS_MOT	☐	CRMT_TRANS_MOT	CRM_TRANS_MOT	CHAR	2	0	Mode of Transport	CRMC_TRANS_MOT
19	.INCLUDE	☐				0	0	Billing Plan Items: Billing Data
20	BILLING_BLOCK	☐	CRMT_BILLING_BLOCK	CRM_BILLING_BLOCK	CHAR	2	0	Billing Block	*
21	BILL_DATE_TZTF	☐	CRMT_BILL_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Date for Billing Index and Printout
22	INVCR_DATE_TZTF	☐	CRMT_INVCR_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Billing Document Creation Date
23	VALUE_DATE_TZTF	☐	CRMT_VALUE_DATE_TZTF	TZTF_IO_FIELD	CHAR	26	0	Fixed Value Date
24	RULE_BILL_DATE_T	☐	CRMT_RULE_BILL_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining the Next Billing Date
25	RULE_INV_DATE_T	☐	CRMT_RULE_INVCR_DATE_T	TIMENAME	CHAR	12	0	Rule for Determining Next Billing Document Creation Date
26	RULE_VAL_DATE_T	☐	CRMT_RULE_VALUE_DATE_T	TIMENAME	CHAR	12	0	Rule for Origin of Next Fixed Value Date
27	BILLING_TIMEZONE	☐	CRMT_BILLING_TIMEZONE	TZNZONE	CHAR	6	0	Time Zone of Billing Plan Set	*
28	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
29	BUAG_TEXT	☐	CRMT_BUAG_TEXT	CHAR30LOW	CHAR	30	0	Text for Business Agreement
30	.INCLUDE	☐				0	0	Billing Plan Items: Billing . Cumulation Data
31	BILLED_QTY	☐	CRMT_BILLED_QTY	CRM_MENGV15	QUAN	15	3	Billed Quantity
32	BILL_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
33	BILLED_VALUE	☐	CRMT_BILLED_VALUE	CRM_COND_VALUE	CURR	19	2	Billed Value
34	BILL_CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
35	BILLING_RELEVANT	☐	CRMT_BILLING_RELEVANT	CRM_BILLING_RELEVANT	CHAR	1	0	Billing Relevance
36	.INCLUDE	☐				0	0	Billing Plan Items: Billing Data (PRICING)
37	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	CRMC_PMNTTRMS
38	PMNTTRMS_T	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
39	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
40	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
41	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
42	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
43	TAX_DEST_CTY	☐	CRMT_TAX_DEST_CTY	LAND1	CHAR	3	0	Tax Destination Country	*
44	TAX_DEST_CTY_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
45	TAX_DEST_REG	☐	CRMT_REGION	REGIO	CHAR	3	0	Region (State, Province, County)	*
46	TAX_DEST_REG_T	☐	CRMT_DESCRIPTION_20	TEXT20	CHAR	20	0	Description (20 Characters)
47	VAT_REG_NO	☐	CRMT_VAT_REG_NO		CHAR	20	0	Sales tax registration number
48	TAXJURCODE	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
49	CUST_PRIC_PROC	☐	CRMT_CUST_PRIC_PROC	CRM_CUST_PRIC_PROC	CHAR	1	0	Customer Pricing Procedure	*
50	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
51	PRICE_GRP	☐	CRMT_PRICE_GRP	CRM_PRICE_GRP	CHAR	2	0	Customer Price Group	*
52	PRICE_LIST	☐	CRMT_PRICE_LIST	CRM_PRICE_LIST	CHAR	2	0	Price List Type	*
53	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
54	ETAX_SOURCE	☐	CRMT_ETAX_SOURCE	CRM_ETAX_SOURCE	CHAR	2	0	Source of Excise Tax Rates	CRMC_ETAX_SRC
55	PAYMENT_METHOD	☐	CRMT_BUAG_PAYMETH	CRM_BUAG_PAYMETH	CHAR	1	0	Payment Method	*
56	.INCLUDE	☐				0	0	Billing Plan Items: Billing Data (PRICING_I)
57	TAX_DEPART_CTY	☐	CRMT_TAX_DEPART_CTY	LAND1	CHAR	3	0	Tax Departure Country	*
58	TAX_DEPART_REG	☐	CRMT_TAX_DEPART_REG	REGIO	CHAR	3	0	Departure Region for Tax	*
59	TAXJURCODE_FROM	☐	CRMT_TAXJURCODE	TXJCD	CHAR	15	0	Tax Jurisdiction Code (Structure for tax calculation)	*
60	TAX_TARIFF_CODE	☐	CRMT_TAX_TARIFF_CODE	CHAR16	CHAR	16	0	Tax Tariff Code
61	PRC_INDICATOR	☐	CRMT_PRICING_INDICATOR	CRM_PRICING_INDICATOR	CHAR	1	0	Pricing indicator
62	NET_VALUE	☐	CRMT_NET_VALUE	WERTV8	CURR	15	2	Net Value
63	NET_PRICE	☐	CRMT_NET_PRICE	WERTV8	CURR	15	2	Net Price
64	TAX_AMOUNT	☐	CRMT_TAX_AMOUNT	WERTV8	CURR	15	2	Tax amount in document currency
65	FREIGHT	☐	CRMT_FREIGHT	WERTV8	CURR	15	2	Shipment costs in document currency
66	GROSS_VALUE	☐	CRMT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Order Value in PO Currency
67	SUBTOTAL1	☐	CRMT_SUBTOTAL1	WERTV8	CURR	15	2	Subtotal 1 from pricing procedure for condition
68	SUBTOTAL2	☐	CRMT_SUBTOTAL2	WERTV8	CURR	15	2	Subtotal 2 from pricing procedure for condition
69	SUBTOTAL3	☐	CRMT_SUBTOTAL3	WERTV8	CURR	15	2	Subtotal 3 from pricing procedure for condition
70	SUBTOTAL4	☐	CRMT_SUBTOTAL4	WERTV8	CURR	15	2	Subtotal 4 from pricing procedure for condition
71	SUBTOTAL5	☐	CRMT_SUBTOTAL5	WERTV8	CURR	15	2	Subtotal 5 from pricing procedure for condition
72	SUBTOTAL6	☐	CRMT_SUBTOTAL6	WERTV8	CURR	15	2	Subtotal 6 from pricing procedure for condition
73	CREDIT_INDICATOR	☐	CRMT_CREDIT_INDICATOR	CRMT_CREDIT_INDICATOR	CHAR	1	0	Credit Debit Indicator
74	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
75	STATISTICAL	☐	CRMT_STATISTICAL	CRM_STATISTICAL	CHAR	1	0	Statistical values
76	TAX_GROUP_P	☐	CRMT_TAX_GROUP	CRM_TAX_GROUP	CHAR	20	0	Product Tax Group
77	TAX_GROUP_P_CTY	☐	CRMT_TAX_LAND	LAND1	CHAR	3	0	Tax Country	*
78	TAX_GROUP_P_REG	☐	CRMT_TAX_REGION	REGIO	CHAR	3	0	Tax Region	*
79	TAX_GROUP_P_TTP	☐	CRMT_TAX_TYPE	BUTX_TAX_TYPE	CHAR	4	0	Tax Type

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_BTX_BRI_BILLING_IL	ETAX_HAND_TYPE	CRMC_ETAX_HTYP	HAND_TYPE
2	CRMT_BSP_BTX_BRI_BILLING_IL	ETAX_SOURCE	CRMC_ETAX_SRC	SOURCE
3	CRMT_BSP_BTX_BRI_BILLING_IL	INCOTERMS1	CRMC_INCOTERM	INCOTERMS1
4	CRMT_BSP_BTX_BRI_BILLING_IL	PMNTTRMS	CRMC_PMNTTRMS	PAYMENT_TERMS
5	CRMT_BSP_BTX_BRI_BILLING_IL	SHIP_COND	CRMC_SHIP_COND	SHIP_COND
6	CRMT_BSP_BTX_BRI_BILLING_IL	TRANS_MOT	CRMC_TRANS_MOT	MOT

History

Last changed by/on	SAP	20130604
SAP Release Created in	500