SAP ABAP Table ISX_INV_ITEM_CRM_IL (Invoice)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ ISX_MD (Package) Master Data Replication for Cross Billing

Basic Data

Table Category	INTTAB	Structure
Structure	ISX_INV_ITEM_CRM_IL	Table Relationship Diagram
Short Description	Invoice

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	Generic object key
2	OBJKEY	☐	SWO_TYPEID	SWO_TYPEID	CHAR	70	0	Object key
3	OBJTYPE	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
4	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	*
5	.INCLUDE	☐				0	0	Invoice Item Key
6	INVDOCNO	☐	ISX_INVDOCNO	ISX_INVDOCNO	CHAR	12	0	Number of Billing Document
7	INVDOCITEM	☐	ISX_INVDOCITEM	ISX_INVDOCITEM	CHAR	12	0	Number of Billing Document
8	.INCLUDE	☐				0	0	Invoice Item - Data Part
9	ITEMTYPE	☐	ISX_INV_ITEMTYPE_KK	CHAR8	CHAR	8	0	Type of Billing Item
10	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
11	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
12	VTREF	☐	ISX_CONTRACT_ID	ISX_CONTRACT_ID	CHAR	20	0	Contract ID
13	VTPOS	☐	ISX_VTPOS_KK	NUMC6	NUMC	6	0	Contract: Item Number
14	SUBAP	☐	ISX_SUBAP_KK	CHAR1	CHAR	1	0	Subapplication in Contract Accounts Receivable and Payable
15	GPART_A	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
16	VKONT_A	☐	ISX_BUAG	ISX_BUAG	CHAR	12	0	Number of Business Agreement
17	GPVKT_A_CAT	☐	ISX_INV_GPVKT_A_CAT_KK	CHAR2	CHAR	2	0	Category of Alternative Master Data for Invoicing Item
18	HVORG	☐	ISX_HVORG_KK	CHAR4	CHAR	4	0	Main Transaction for Line Item
19	TVORG	☐	ISX_TVORG_KK	CHAR4	CHAR	4	0	Subtransaction for Document Item
20	ITEM_SIMULATED	☐	ISX_ITEM_SIMULATED_KK	XFELD	CHAR	1	0	Line Item Is Simulated
21	REVERSALITEM	☐	ISX_REVERSALITEM_KK	XFELD	CHAR	1	0	Reversal Item
22	TOTALREL	☐	ISX_TOTALREL_KK	XFELD	CHAR	1	0	Consider Items In Invoice Final Amount
23	POSTREL	☐	ISX_POSTREL_KK	XFELD	CHAR	1	0	Posting-Relevant Line Item
24	PRINTREL	☐	ISX_PRINTREL_KK	XFELD	CHAR	1	0	Line Item Is Relevant for Printing
25	PRINT_SUBSTITUTE	☐	ISX_PRINT_SUBSTITUTE_KK	CHAR4	CHAR	4	0	Substitute Group for Invoice Printing
26	WAERS	☐	ISX_BLWAE_KK	WAERS	CUKY	5	0	Transaction Currency	*
27	BETRW	☐	ISX_BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
28	SRCDOC_CURR	☐	ISX_SRCDOC_CURR_KK	WAERS	CUKY	5	0	Currency of Source Document	*
29	SRCDOC_AMT	☐	ISX_SRCDOC_AMT_KK	WRTV7	CURR	13	2	Amount in Source Document Currency
30	CURRC_GROUP	☐	ISX_CURRC_GROUP_KK	NUMC6	NUMC	6	0	Grouping for Currency Translation
31	KOFIZ	☐	ISX_KOFIZ_KK	CHAR2	CHAR	2	0	Account Determination ID
32	TAX_INCLUDED	☐	ISX_TAX_INCLUDED_KK	XFELD	CHAR	1	0	Tax Included in Amount
33	TAX_DET_TYPE	☐	ISX_TAX_DET_TYPE_KK	CHAR2	CHAR	2	0	Type of Tax Calculation
34	TAXGR	☐	ISX_TAXGR_KK	NUMC6	NUMC	6	0	Grouping Key for Tax Display
35	STRKZ	☐	ISX_STRKZ_KK	CHAR2	CHAR	2	0	Tax Code for Other Taxes
36	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
37	ERMWSKZ	☐	ISX_ERMWSKZ	CHAR2	CHAR	2	0	Indicator: Tax Determination Code
38	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
39	KTOSL	☐	ISX_KTOSL_KK	CHAR3	CHAR	3	0	Transaction key for account determination
40	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
41	TAX_PERC	☐	ISX_TAX_PERC_KK	ISX_TAX_PERC_KK	DEC	6	3	Tax Percentage
42	TXDAT	☐	ISX_TXDAT_KK	DATUM	DATS	8	0	Decisive Date for Calculating Taxes
43	SBASW	☐	ISX_SBASW_KK	WRTV7	CURR	13	2	Amount Subject to Tax in Transaction Currency (Tax Base Amt)
44	SBETW	☐	ISX_SBETRW_KK	WRTV7	CURR	13	2	Tax Amount in Transaction Currency with +/- Sign
45	STTAX	☐	ISX_STTAX_KK	WRTV7	CURR	13	2	Tax Amount as Statistical Information in Document Currency
46	XANZA	☐	ISX_XANZA_KK	XFELD	CHAR	1	0	Item is a Down Payment/Down Payment Request
47	STAKZ	☐	ISX_STAKZ_KK	CHAR1	CHAR	1	0	Type of statistical item
48	OFFSET_INVGR	☐	ISX_INV_OFFSET_GROUP_KK	CHAR6	CHAR	6	0	Grouping of Offsetting Items
49	DEFREV_STAT	☐	ISX_DEFREV_STAT_KK	CHAR1	CHAR	1	0	Status of Processing of Deferred Revenues
50	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
51	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
52	FAEDN	☐	ISX_FAEDN	DATUM	DATS	8	0	Due Date for Net Payment
53	FAEDS	☐	ISX_FAEDS	DATUM	DATS	8	0	Due Date for Cash Discount
54	SKTPZ	☐	ISX_SKTPZ_KK	PRZ23	DEC	5	3	Cash discount rate
55	XSTUND	☐	ISX_INV_XSTUND_KK	CHAR1	CHAR	1	0	Item Deferred until Due Date for Invoice
56	DATE_FROM	☐	ISX_ITEMPERIOD_FROM_KK		DATS	8	0	Start of Period of Line Item
57	DATE_TO	☐	ISX_ITEMPERIOD_TO_KK		DATS	8	0	End of Period of Line Item
58	CADOCTYPE	☐	ISX_CADOCTYPE_KK	CHAR4	CHAR	4	0	Reference Document Type of Posting Document for Invoicing
59	OPBEL	☐	ISX_OPBEL_KK	CHAR12	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.
60	PSGRP	☐	ISX_PSGRP_KK	CHAR4	CHAR	4	0	Grouping Key for Document Items
61	INVGR	☐	ISX_INVGR_KK	CHAR4	CHAR	4	0	Grouping Key for Invoicing
62	AUGBL	☐	ISX_AUGBL_KK	CHAR12	CHAR	12	0	Clearing Document or Printed Document
63	AUGBW	☐	ISX_AUGBW_KK	WRTV7	CURR	13	2	Clearing Amount in Transaction Currency (With +/- Sign)
64	ITEM_CRMET	☐	ISX_INVITEM_CRMET_KK	CHAR1	CHAR	1	0	Creation Method of Invoicing Document Item
65	INV_FUNCTION	☐	ISX_INV_FUNCTION_KK	CHAR12	CHAR	12	0	Invoicing Function
66	SRCDOCCAT	☐	ISX_SRCDOCCAT_KK	CHAR5	CHAR	5	0	Category of Source Document To Be Invoiced
67	SRCDOCNO	☐	ISX_SRCDOCNO_KK	CHAR20	CHAR	20	0	Number of Source Document to Be Invoiced
68	SRCITEMCAT	☐	ISX_SRCITEMCAT_KK	CHAR5	CHAR	5	0	Category of Source Document Item Invoiced
69	SRCDOCITEM	☐	ISX_SRCDOCITEM_KK	CHAR20	CHAR	20	0	Item of Invoiced Source Document
70	ITEMTYPE_TXT	☐	ISX_INV_ITEMTYPE_TXT_KK	TEXT50	CHAR	50	0	Name of Invoicing Item Type
71	HVORG_TXT	☐	ISX_HVORG_TXT	TEXT30	CHAR	30	0	Name of Main Transaction
72	TVORG_TXT	☐	ISX_TVORG_TXT	TEXT30	CHAR	30	0	Name of Subtransaction
73	SUBAP_TXT	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
74	CRM_TOTAL_AMOUNT	☐	ISX_INV_TOTAL_AMT	WRTV7	CURR	13	2	Total Amount in Transaction Currency
75	CRM_NET_AMOUNT	☐	ISX_INV_NET_AMOUNT	WRTV7	CURR	13	2	Net Amount in Transaction Currency
76	CRM_TAX_AMOUNT	☐	ISX_INV_TAX_AMOUNT	WRTV7	CURR	13	2	Tax Amount in Transaction Currency
77	.INCLUDE	☐				0	0	EEW Include
78	ISX_INV_ITEM_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1

History

Last changed by/on	SAP	20130529
SAP Release Created in	606