SAP ABAP Table JSBW_SD_INV_ITEM_COMPL (IS-M/SD: BW Structure for Billing Items - Full)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M-IS (Application Component) Information System
     ⤷ JSBW (Package) IS-M: Link to Business Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	JSBW_SD_INV_ITEM_COMPL	Table Relationship Diagram
Short Description	IS-M/SD: BW Structure for Billing Items - Full

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	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
2	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for Billing Items
3	VBELN	☐	ISPVBELN	ISPVBELN	CHAR	10	0	IS-M/SD: Billing Document	*
4	POSNR	☐	ISPPOSNR	ISPPOSNR	NUMC	6	0	IS-M: Billing Item	*
5	FKIMG	☐	FKIMG	MENG13	QUAN	13	3	Actual billed quantity
6	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
7	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
8	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
9	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
10	FBUDA	☐	FBUDA	DATUM	DATS	8	0	Date When Services Rendered
11	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
12	NETWR	☐	NETWR_FP	WERTV8	CURR	15	2	Net value of the billing item in document currency
13	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
14	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
15	POSPA	☐	ISPPOSPA	ISPPOSNR	NUMC	6	0	IS-M: Item Number of Partner Segment	*
16	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
17	ALAND	☐	ALAND	LAND1	CHAR	3	0	Departure country (country from which the goods are sent)	*
18	WKREG	☐	WKREG	REGIO	CHAR	3	0	Region in which plant is located	*
19	WKCOU	☐	WKCOU	CHAR3	CHAR	3	0	County in which plant is located
20	WKCTY	☐	WKCTY	CHAR4	CHAR	4	0	City in which plant is located
21	TAXM1	☐	TAXM1	TAXKM	CHAR	1	0	Tax classification material	*
22	TAXM2	☐	TAXM2	TAXKM	CHAR	1	0	Tax classification material	*
23	TAXM3	☐	TAXM3	TAXKM	CHAR	1	0	Tax classification material	*
24	TAXM4	☐	TAXM4	TAXKM	CHAR	1	0	Tax Classification 4 Material	*
25	TAXM5	☐	TAXM5	TAXKM	CHAR	1	0	Tax classification 5 for material	*
26	TAXM6	☐	TAXM6	TAXKM	CHAR	1	0	Tax classification 6 for material	*
27	TAXM7	☐	TAXM7	TAXKM	CHAR	1	0	Tax classification 7 for material	*
28	TAXM8	☐	TAXM8	TAXKM	CHAR	1	0	Tax Classification 8 Material	*
29	TAXM9	☐	TAXM9	TAXKM	CHAR	1	0	Tax Classification 9 Material	*
30	SKTOF	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
31	SKFBP	☐	SKFBP	WERTV7	CURR	13	2	Amount eligible for cash discount in document currency
32	SPARA	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
33	SHKZG	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
34	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
35	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
36	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
37	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
38	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
39	STCUR	☐	STCUR_AP	KURRF	DEC	9	5	Exchange rate for statistics (Exch.rate at time of creation)
40	UVPRS	☐	UVPRS	XFELD	CHAR	1	0	Incomplete with respect to pricing
41	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
42	.INCLUDE	☐				0	0	IS-M/SD: Item Data for Billing
43	ISPAUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
44	ISPAUAGRP	☐	ISPAUAGRP	JAUARTGRP	CHAR	1	0	IS-M: Sales Document Type Grouping for Sales Order
45	ISPKOSTL_L	☐	ISPKOSTL_L	KOSTL	CHAR	10	0	IS-M: Cost Center to be Charged	*
46	ISPDRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
47	ISPPVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
48	ISPBEZ	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
49	ISPLIFART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
50	ISPDRUCK	☐	ISPDRUCK	WERKS	CHAR	4	0	IS-M: Plant (Printing Works)	T001W
51	ISPGUTSCH	☐	ISPGUTSCH	GUTSCHEIN	NUMC	8	0	IS-M: Coupon Number
52	ISPXLOGO	☐	XLOGO	XFELD	CHAR	1	0	Print Logo
53	ISPPVAKNTG	☐	ISPPVAKNTG	KTGRM	CHAR	2	0	IS-M: Account Assignment Grouping for Edition	TVKM
54	ISPPVAKONG	☐	ISPPVAKONG	KONDM	CHAR	2	0	IS-M: Edition Condition Grouping	T178
55	ISPPVABONG	☐	ISPPVABONG	BONUS	CHAR	2	0	IS-M: Bonus Grouping for Edition	TVBO
56	ISPFKPER	☐	FKPER	FKPER	CHAR	2	0	Billing Frequency	TJK01
57	ISPPERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)	TFACD
58	ISPZAHLW	☐	JZAHLW	JZAHLW	CHAR	1	0	Billing method
59	ISPPOSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
60	ISPJPERIOD	☐	JPERIOD	XFELD	CHAR	1	0	IS-M: Periodic settlement
61	ISPVBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
62	ISPPOSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	JKAP
63	ISPETENR	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	JKEP
64	ISPETEEX	☐	ETEEX_ISP	ETEEX	NUMC	6	0	IS-M: External Schedule Line Number
65	ISPETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	TJEP
66	ISPETMENGE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
67	ISPETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	T006
68	ISPETVOR	☐	ISPETVOR	VORZEI	CHAR	1	0	IS-M: Plus/Minus Sign for Sch. Line Quantity in Sales Order
69	ISPKPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
70	ISPPRBAS	☐	ISPPRBAS	PRBAS_ISP	CHAR	1	0	IS-M: Price Basis
71	ISPPRSPER	☐	ISPPRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	TJK03
72	ISPBZPERF	☐	ISPBZPERF	BEZPER	CHAR	5	0	IS-M: Service Type for Billing	TJD09
73	ISPPRSMLT	☐	ISPPRSMLT	PRSMLT	DEC	5	0	IS-M: Numerator in Conversion Factor for Frequencies
74	ISPPRSDIV	☐	ISPPRSDIV	PRSDIV	DEC	5	0	IS-M: Denominator for Frequency Conversion Factor
75	ISPAEART	☐	ISPAEART	AEART_JSDK	CHAR	1	0	IS-M: Order Change Type
76	ISPANZET	☐	ISPANZET	ANZET	DEC	5	0	IS-M: Number of Publication Dates
77	ISPERSDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
78	ISPWRBAKT	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	TJWAK
79	ISPFAKVON	☐	FAKVON	DATUM	DATS	8	0	IS-M: Billing Period From
80	ISPFAKBIS	☐	FAKBIS	DATUM	DATS	8	0	IS-M: Billing Period To
81	ISPKONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
82	ISPKDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
83	ISPPOART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
84	ISPPRSANTZ	☐	PRSANTZ	ISPWERT8	DEC	8	0	IS-M: Numerator for proportional prices
85	ISPPRSANTN	☐	PRSANTN	ISPWERT8	DEC	8	0	IS-M: Denominator for proportional prices
86	ISPPRSANZP	☐	PRSANZP	ISPWERT8	DEC	8	0	IS-M: Number of periods in billing period
87	ISPBRTWR_P	☐	ISPBRTWR	WERTV8	CURR	15	2	IS-M: Gross Value in Document Currency
88	ISPPRBAS_V	☐	PRBAS_VK	PRBAS_ISP	CHAR	1	0	Price Basis for Shipping Costs
89	ISPLAGRP_V	☐	LANDGRP_VK	LANDGRP_VK	CHAR	2	0	Country grouping for shipping costs	TJG92
90	ISPXFKKOMP	☐	XFKKOMP	XFELD	CHAR	1	0	Indicator: Perform Billing in Full for Billing Period
91	ISPXFKENDE	☐	XFKENDE	XFELD	CHAR	1	0	Indicator: Billing at end of calculation
92	ISPSFPOS	☐	XSEPFKPOS	XFELD	CHAR	1	0	Separate billing document for order item
93	ISPXKOMPP	☐	XKOMPP	XFELD	CHAR	1	0	IS-M: Full period (billing)
94	ISPVERSDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
95	ISPLANDE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
96	ISPRKAUFNR	☐	J_RK_AUFNR	J_RK_AUFNR	CHAR	8	0	Order Number of RK Order for Account Assignment
97	ISPRKPOSNR	☐	J_RK_POSNR	J_RK_POSNR	NUMC	2	0	Item Number of RK Order for Account Assignment
98	ISPCOAUFNR	☐	J_CO_AUFNR	AUFNR	CHAR	12	0	Order number of internal CO order for account assignment	AUFK
99	ISPVAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	JDTVAUSGB
100	ISPXFKBALF	☐	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
101	ISPXFKBAAU	☐	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
102	ISPVKBURZU	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
103	ISPXSTABGR	☐	JXMWSTABGR	XFELD	CHAR	1	0	VAT to be accrued proportionally for payment in billing
104	ISPXIMMAT	☐	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
105	ISPIMMATD	☐	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
106	ISPXFKRUEK	☐	XFKRUECK	XFELD	CHAR	1	0	IS-M: Retroactive Billing of Period Already Billed
107	ISPIVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
108	ISPXIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
109	ISPJKPAVRG	☐	JKPAVONREG	DATUM	DATS	8	0	Normal Start of Address Validity for Retro.Order Items
110	ISPJKPABRG	☐	JKPABISREG	DATUM	DATS	8	0	End of Address Validity if End of Billing Delayed
111	XNEGOPTION	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
112	IVWDATUM	☐	IVWDATUM	DATUM	DATS	8	0	Date of Audit Report for Returns
113	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
114	ISPBDPER	☐	BDPER	DATUM	DATS	8	0	IS-M: Basic Date for Billing Frequency
115	FKPERVON	☐	FKPERVON	DATUM	DATS	8	0	IS-M: Initial Date of Full Billing Period
116	FKPERBIS	☐	FKPERBIS	DATUM	DATS	8	0	IS-M: Closing Date of Full Billing Period
117	ISPZSKLS	☐	JZSKLS	JZSKLS	CHAR	1	0	Time slice classification for sales order
118	ISPWRBART	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	*
119	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	*
120	CYCLENR	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
121	FAKNRRUECK	☐	ISPFAKNRRUECK	ISPVBELN	CHAR	10	0	IS-M: Recalculated Billing Document	*
122	XFIXED	☐	XINDEXFIXED	XFELD	CHAR	1	0	Indicator: Billing Index Fixed and Cannot be Deleted
123	RCODE	☐	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	*
124	XAUTO_REN	☐	XAUTO_REN	XFELD	CHAR	1	0	IS-M/SD: Customer Requests Automatic Renewal
125	STBFREI	☐	JSTBFREI	JSTBFREI	CHAR	2	0	Type of Tax Exemption	*
126	XNFAK	☐	ISPXNFAK	XFELD	CHAR	1	0	IS-M: Indicator - Repeat Billing After Reversal
127	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	*
128	DELIVSPLITGRP	☐	DELIVSPLITGRP	DELIVSPLITGRP	CHAR	10	0	IS-M/SD: Address Alternation Group	*
129	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	*
130	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	*
131	.INCLUDE	☐				0	0	IS-M/SD: Field String for Weekdays
132	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
133	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
134	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
135	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
136	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
137	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
138	X_SONNTAG	☐	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday
139	VBELN_FROM	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
140	POSNR_UR_FROM	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
141	CYCLENR_FROM	☐	CYCLENR	CYCLENR	NUMC	3	0	IS-M/SD: Billing Cycle Number	*
142	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_SD_INV_ITEM_COMPL	ISPAUART	TJAK	AUART	KEY	1	CN
2	JSBW_SD_INV_ITEM_COMPL	ISPBEZ	JDTBEZTYP	BEZTYP
3	JSBW_SD_INV_ITEM_COMPL	ISPBZPERF	TJD09	BEZPER
4	JSBW_SD_INV_ITEM_COMPL	ISPCOAUFNR	AUFK	AUFNR
5	JSBW_SD_INV_ITEM_COMPL	ISPDRERZ	JDTDRER	DRERZ
6	JSBW_SD_INV_ITEM_COMPL	ISPDRUCK	T001W	WERKS
7	JSBW_SD_INV_ITEM_COMPL	ISPETART	TJEP	ETART	KEY	1	CN
8	JSBW_SD_INV_ITEM_COMPL	ISPETENR	JKEP	ETENR	KEY	1	CN
9	JSBW_SD_INV_ITEM_COMPL	ISPETMEINS	T006	MSEHI
10	JSBW_SD_INV_ITEM_COMPL	ISPFKPER	TJK01	FKPER
11	JSBW_SD_INV_ITEM_COMPL	ISPKDGRP	T151	KDGRP
12	JSBW_SD_INV_ITEM_COMPL	ISPKONDA	T188	KONDA
13	JSBW_SD_INV_ITEM_COMPL	ISPLAGRP_V	TJG92	LANDGRP_VK
14	JSBW_SD_INV_ITEM_COMPL	ISPLIFART	TJV01	LIEFERART
15	JSBW_SD_INV_ITEM_COMPL	ISPPERFK	TFACD	IDENT
16	JSBW_SD_INV_ITEM_COMPL	ISPPOART	TJAP	POART
17	JSBW_SD_INV_ITEM_COMPL	ISPPOSNR	JKAP	POSNR	KEY	1	CN
18	JSBW_SD_INV_ITEM_COMPL	ISPPRSPER	TJK03	PRSPER
19	JSBW_SD_INV_ITEM_COMPL	ISPPVA	JDTPVA	PVA
20	JSBW_SD_INV_ITEM_COMPL	ISPPVABONG	TVBO	BONUS
21	JSBW_SD_INV_ITEM_COMPL	ISPPVAKNTG	TVKM	KTGRM
22	JSBW_SD_INV_ITEM_COMPL	ISPPVAKONG	T178	KONDM
23	JSBW_SD_INV_ITEM_COMPL	ISPVAUSGB	JDTVAUSGB	VAUSGB
24	JSBW_SD_INV_ITEM_COMPL	ISPVBELN	JKAK	VBELN	KEY	1	CN
25	JSBW_SD_INV_ITEM_COMPL	ISPWRBAKT	TJWAK	WERBEAKT

History

Last changed by/on	SAP	20110901
SAP Release Created in	471