SAP ABAP Table CRMT_ISALES_INVOICE_ITEM (Web Billing Documents Item Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-ISA (Application Component) Internet Sales
     ⤷ CRM_ISALES (Package) CRM Internet Sales

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_ISALES_INVOICE_ITEM	Table Relationship Diagram
Short Description	Web Billing Documents Item Data

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	Item Data for Web Billing Documents
2	BILLINGDOC	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document
3	ITEM_NUMBER	☐	CRM_POSNR_VF	POSNR	NUMC	6	0	Billing Item
4	HG_LV_ITEM	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures
5	INV_QTY	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
6	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
7	SALES_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	*
8	NETVAL_INV	☐	CRM_NETWR_FP	WERTV8	CURR	15	2	Net Value of the Billing Item in Document Currency
9	REFERENCE_DOC	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
10	REFERENCE_POS	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
11	REFERENCE_CAT	☐	VBTYP_V	VBTYP	CHAR	1	0	Document category of preceding SD document
12	REFERENCE_CATTXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
13	SALES_DOC	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document
14	SALES_POS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
15	SALES_REF	☐	CRM_AUREF	XFELD	CHAR	1	0	Sales Document has Resulted from Reference
16	SALES_CAT	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
17	SALES_CATTEXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
18	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
19	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
20	ITEM_TYPE	☐	POSAR	POSAR	CHAR	1	0	Item type
21	ITEM_TYPE_TEXT	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
22	ITEM_CATEG	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category
23	ITEM_CATEG_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
24	DIVISION	☐	SPART	SPART	CHAR	2	0	Division
25	DIVISION_TEXT	☐	VTXTK	TEXT20	CHAR	20	0	Name
26	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
27	PLANT_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
28	CASH_DISC	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
29	CSHDISCBAS	☐	CRM_SKFBP	WERTV7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
30	RETURNS	☐	CRM_SHKZG_VF	CRM_SHKZG_VF	CHAR	1	0	Returns Item
31	EAN_UPC	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
32	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
33	TAX_AMOUNT	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
34	ITEM_TEXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
35	BRVAL_INV	☐	PRCT_GROSS_VALUE	WERTV8	CURR	15	2	Gross Value of Item
36	STVAL_INV	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
37	COND_SUBTOTAL1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
38	COND_SUBTOTAL2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
39	COND_SUBTOTAL3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
40	COND_SUBTOTAL4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
41	COND_SUBTOTAL5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
42	COND_SUBTOTAL6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
43	GROSS_VALUE	☐	GROSSWR	WERTV8	CURR	15	2	Gross Value in Document Currency
44	GROSS_VALUE_C	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
45	NETVALUE_INV_C	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
46	TAX_AMOUNT_C	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
47	SALES_DOC_GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
48	INV_QTY_UI	☐	CHAR18	CHAR18	CHAR	18	0	Field length 18
49	SYSTEM_PROD	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
50	PRODUCT	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
51	GUID	☐	CRMT_OBJECT_GUID_C	SYSUUID_C	CHAR	32	0	GUID of a CRM Order Object, 32 Bit Characters
52	NOT_CLAIMABLE	☐	FLAG	FLAG	CHAR	1	0	General Flag

History

Last changed by/on	SAP	20130604
SAP Release Created in	20C