SAP ABAP Table JSBW_SD_ORDER_ITEM_COMPL (IS-M/SD: BW Structure for Internal Order Item)

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_ORDER_ITEM_COMPL	Table Relationship Diagram
Short Description	IS-M/SD: BW Structure for Internal Order Item

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	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 Subscrip.Items, Extractor Struct.
3	VBELN	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
4	POSNR	APNR	APNR	NUMC	6	0	Sales Order Item	*
5	GUELTIGVON	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
6	GUELTIGBIS	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
7	POART	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
8	AEART	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
9	ZSKLS	JZSKLS	JZSKLS	CHAR	1	0	Time slice classification for sales order
10	POSEX	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
11	DRERZ	DRERZ	DRERZ	CHAR	8	0	Publication	*
12	PVA	PVA	PVA	CHAR	8	0	Edition	*
13	BEZUGSTYP	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	*
14	XRUECKABO	XRUECKABO	XFELD	CHAR	1	0	IS-M: Backdated subscription created
15	LIEFVON	LIEFVON	DATUM	DATS	8	0	Regular start of delivery for item in sales order
16	SPART	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	*
17	MATKL	MATKL	MATKL	CHAR	9	0	Material Group	*
18	GSBER	GSBER	GSBER	CHAR	4	0	Business Area	*
19	IVWKN	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
20	IVWKNFREI	IVWKNFREI	IVWKN	CHAR	8	0	Circulation Report Category ID for Non-Calculation Period	*
21	XLIEFSE	XLIEFSE	XFELD	CHAR	1	0	Delivery to social facility
22	LIEFERART	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	*
23	UNTBRGRD	UNTBRGRD	UNTBRGRD	CHAR	3	0	Reason for Suspension	*
24	BEZUGGRD	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	*
25	RECHBEGINN	RECHBEGINN	DATUM	DATS	8	0	Billing From
26	RECHENDE	RECHENDE	DATUM	DATS	8	0	Billing To
27	XIVW	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
28	XFAKTURA	XFAKTURA	XFELD	CHAR	1	0	Indicator: Relevant for billing
29	KUENDGRD	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	*
30	XURPOS	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order
31	POSNR_UR	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	*
32	POSNR_VG	APNR_VG	APNR	NUMC	6	0	Preceding Item in Publishing Sales Order	*
33	KOKRS	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
34	KOSTL_L	KOSTL_L	KOSTL	CHAR	10	0	Debit Cost Center	*
35	XSTORNO	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
36	STORNOGRD	STORNOGRD	STORNOGRD	CHAR	3	0	Reversal Reason	*
37	HEFTNUMVON	HEFTNUMVON	HEFTNUMMER	CHAR	9	0	Copy Number of First Issue to be Delivered
38	HEFTNUMBIS	HEFTNUMBIS	HEFTNUMMER	CHAR	9	0	Copy Number of Last Issue for Delivery
39	DELIVSPLITGRP	DELIVSPLITGRP	DELIVSPLITGRP	CHAR	10	0	IS-M/SD: Address Alternation Group	*
40	DELIVSPLIT	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	*
41	POSNR_MAIN	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	*
42	POSNR_SUB	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	*
43	XMAINSPLIT	XMAINSPLIT	XFELD	CHAR	1	0	Item for this Alternating Add. Element is a Main Sub-Item
44	.INCLUDE				0	0	IS-M/SD: Field String for Weekdays
45	X_MONTAG	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
46	X_DIENSTAG	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
47	X_MITTWOCH	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
48	X_DONNETAG	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
49	X_FREITAG	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
50	X_SAMSTAG	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
51	X_SONNTAG	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday
52	CAMPAIGN_ORDER	CHAR24	CHAR24	CHAR	24	0	Character field length 24
53	LAND1	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	*
54	.INCLUDE				0	0	IS-M/SD: BW Structure: Subscript.Sched.Lines Extractor Struc
55	ETEEX	ETEEX_ISP	ETEEX	NUMC	6	0	IS-M: External Schedule Line Number
56	BEZPER	BEZPER	BEZPER	CHAR	5	0	Service Type	*
57	ETART	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	*
58	ETMENGE	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
59	ETMEINS	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*
60	UNTMENGE	UNTMENGE	MENGGPOS	QUAN	10	0	IS-M: Suspension quantity
61	NETWR	NETWR_ISP	WERTV8	CURR	15	2	IS-M: Net price in document currency
62	MWSBP	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
63	WAERK	WAERK	WAERS	CUKY	5	0	SD document currency	*
64	PRSBINDDAT	PRSBINDDAT	DATUM	DATS	8	0	To-date for price fixing
65	PRSDT	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
66	PRSPER	PRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	*
67	BZPERF	BEZPERFAKT	BEZPER	CHAR	5	0	IS-M: Service Type for Billing	*
68	LFARTLOG	LFARTLOG	LIEFERART	CHAR	2	0	Logistical delivery type	*
69	.INCLUDE				0	0	IS-M/SD: BW Structure for Business Data on Subs. Order
70	KDGRP	KDGRP	KDGRP	CHAR	2	0	Customer group	*
71	PLTYP	PLTYP	PLTYP	CHAR	2	0	Price list type	*
72	ZTERM	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
73	FKPER	FKPER	FKPER	CHAR	2	0	Billing Frequency	*
74	ZAHLW	JZAHLW	JZAHLW	CHAR	1	0	Billing method
75	PRBAS	PRBAS_ISP	PRBAS_ISP	CHAR	1	0	Price Basis
76	PRBAS_VK	PRBAS_VK	PRBAS_ISP	CHAR	1	0	Price Basis for Shipping Costs
77	XFKKOMP	XFKKOMP	XFELD	CHAR	1	0	Indicator: Perform Billing in Full for Billing Period
78	XFKENDE	XFKENDE	XFELD	CHAR	1	0	Indicator: Billing at end of calculation
79	JUEBART	JUEBART	JUEBART	CHAR	1	0	IS-M: Transfer Type
80	XSEPFKPOS	XSEPFKPOS	XFELD	CHAR	1	0	Separate billing document for order item
81	XKINKASSO	XKINKASSO	XFELD	CHAR	1	0	IS-M: Payment by field collector
82	RCODE	RATE_CODE	RATE_CODE	CHAR	4	0	IS-M/SD: Rate Code	*
83	XAUTO_REN	XAUTO_REN	XFELD	CHAR	1	0	IS-M/SD: Customer Requests Automatic Renewal
84	XNORENEWAL	XNORENEWAL	XFELD	CHAR	1	0	IS-M/SD: No Further Renewal Required
85	VKONT	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
86	DUEDAY	DUEDAY	DUEDAY	NUMC	2	0	IS-M/SD: Renewals, Due Day
87	.INCLUDE				0	0	IS-M/SD: BW Structure for Subscriptn Order Termination Data
88	KUENDEING	KUENDEING	DATUM	DATS	8	0	Date of Receipt of Termination
89	LIEFENDEG	LIEFENDEG	DATUM	DATS	8	0	Requested end of delivery
90	LIEFENDEI	LIEFENDEI	DATUM	DATS	8	0	Actual end of delivery
91	RECHENDE_KUEND	RECHENDE	DATUM	DATS	8	0	Billing To
92	GPRECH	GPRECH	GPNR	CHAR	10	0	IS-M: Researcher	*
93	VSGRCHEUR	VSGRCHEUR	GPNR	CHAR	10	0	Researcher's Service Company	*
94	XABGRECH	XABGRECH	XFELD	CHAR	1	0	IS-M: Generate Termination Research
95	XKUEND_AKT	XKUEND_AKT	XFELD	CHAR	1	0	IS-M: Perform termination
96	.INCLUDE				0	0	IS-M/SD: BW Structure for Subscription Order Payment Cards
97	CCINS	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
98	CCNUM	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
99	CCFOL	CCFOL	CHAR10	CHAR	10	0	Payment cards: Payment card suffix
100	DATAB	DATAB_CC	DATUM	DATS	8	0	Payment cards: Valid from
101	DATBI	DATBI_CC	DATUM	DATS	8	0	Payment Cards: Valid To
102	CCNAME	CCNAME	TEXT40	CHAR	40	0	Payment Cards: Name of Cardholder
103	CSOUR	CSOUR	CSOUR	CHAR	1	0	Payment cards: Entry mode
104	.INCLUDE				0	0	IS-M/SD: BW Structure for Weighted Quantity
105	ETMENGE_GEW	JBW_ETMENGE_GEW	JBW_ETMENGE_GEW	QUAN	16	3	Quantity in Sales Order Schedule Line w/Part.Subs.Weighting
106	UNTMENGE_GEW	JBW_UNTMENGE_GEW	JBW_ETMENGE_GEW	QUAN	16	3	Suspension qty for order sched.line with partial sub.wghtg
107	TEILABOGEW	JBW_TEILABOGEW	JBW_TEILABOGEW	DEC	17	3	Quantity in Sales Order Schedule line w/Part.Subs.Weighting
108	.INCLUDE				0	0	BW: Structure for Partner Data in Internal Item
109	GPNR	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
110	ADRNR	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
111	ZLSCH	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	*