SAP ABAP View V_JSBW_POS_INT (IS-M/SD: BW View for Reading Subs. Order (Header and Items))

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

View Type	D	Database View
Database View	V_JSBW_POS_INT
Short Description	IS-M/SD: BW View for Reading Subs. Order (Header and Items)
Root table	JKAK	Sales Order Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKAK	JKAK
2	JKAP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JKAK	MANDT	JL	EQ				0	0
2	JKAP	MANDT	JR	EQ			AND	0	0
3	JKAK	VBELN	JL	EQ				0	0
4	JKAP	VBELN	JR	EQ			AND	0	0
5	JKAK	VBTYP		EQ	'C'		AND	0	0
6	JKAK	TRVOG		EQ	'0'		AND	0	0
7	JKAK	AUARTGRP		EQ	'1'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JKAK	MANDT		☐	MANDT	☐	Client
2	VBELN	JKAK	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	GPAG	JKAK	GPAG		☐	GPAG	☐	Business Partner: Sold-to Party
4	JPARVWGPAG	JKAK	JPARVWGPAG		☐	JPARVWGPAG	☐	IS-M: Partner usage of sold-to party
5	ANGDT	JKAK	ANGDT		☐	ANGDT_V	☐	Quotation/Inquiry is valid from
6	BNDDT	JKAK	BNDDT		☐	BNDDT	☐	Date until which bid/quotation is binding (valid-to date)
7	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
8	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
9	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
10	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
11	WAERK	JKAK	WAERK		☐	WAERK	☐	SD document currency
12	NETWR	JKAK	NETWR		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
13	VKORG	JKAK	VKORG		☐	VKORG	☐	Sales Organization
14	VTWEG	JKAK	VTWEG		☐	VTWEG	☐	Distribution Channel
15	VKGRP	JKAK	VKGRP		☐	VKGRP	☐	Sales group
16	VKBUR	JKAK	VKBUR		☐	JVKBUR	☐	IS-M/SD: Receiving Sales Office
17	EXEMPLART	JKAK	EXEMPLART		☐	EXEMPLART	☐	IS-M: Copy Type
18	GSKST	JKAK	GSKST		☐	GSKST	☐	Business area from cost center
19	KNUMV	JKAK	KNUMV		☐	KNUMV	☐	Number of the document condition
20	KALSM	JKAK	KALSM		☐	KALSMASD	☐	Sales and Distribution: Pricing Procedure in Pricing
21	KURST	JKAK	KURST		☐	KURST	☐	Exchange Rate Type
22	BSTNK	JKAK	BSTNK		☐	BSTNK	☐	Customer purchase order number
23	BSARK	JKAK	BSARK		☐	BSARK	☐	Customer Order Type
24	BSTDK	JKAK	BSTDK		☐	BSTDK	☐	Customer purchase order date
25	BSTZD	JKAK	BSTZD		☐	BSTZD	☐	Customer purchase order number supplement
26	IHREZ	JKAK	IHREZ		☐	IHREZ	☐	Your Reference
27	BNAME	JKAK	BNAME		☐	BNAME_V	☐	Name of orderer
28	TELF1	JKAK	TELF1		☐	TELF1_VP	☐	Telephone Number
29	STWAE	JKAK	STWAE		☐	STWAE	☐	Statistics currency
30	XIMMATRIK	JKAK	XIMMATRIK		☐	XIMMATRIK	☐	Indicator: Proof of matriculation provided
31	IMMATDAT	JKAK	IMMATDAT		☐	IMMATDAT	☐	Matriculation Certificate Valid To
32	XSEPFKKOPF	JKAK	XSEPFKKOPF		☐	XSEPFKKOPF	☐	Separate billing document for sales order
33	REMSP	JKAK	REMSP		☐	REMSP	☐	IS-M: Billing Block for Return Notification
34	REMVON	JKAK	REMVON		☐	REMVON_ISP	☐	IS-M: Return date from
35	REMBIS	JKAK	REMBIS		☐	REMBIS_ISP	☐	IS-M: Return date valid to
36	REMDATUM	JKAK	REMDATUM		☐	REMDAT_ISP	☐	IS-M: Date of return notification
37	REMSCHEIN	JKAK	REMSCHEIN		☐	RSCHEIN_IS	☐	IS-M: Return slip number
38	IVWDATUM	JKAK	IVWDATUM		☐	IVWDATUM	☐	Date of Audit Report for Returns
39	POSNR_LAST	JKAK	POSNR_LAST		☐	POSNR_LAST	☐	Last Assigned Item Number
40	POSEX_LAST	JKAK	POSEX_LAST		☐	POSEX_LAST	☐	Last purchase order item number assigned
41	KPOSN_LAST	JKAK	KPOSN_LAST		☐	KPOSN_LAST	☐	IS-M: Last condition item number assigned
42	XFKBASAUFT	JKAK	XFKBASAUFT		☐	XFKBASAUFT	☐	IS-M: Billing based on order
43	XFKBASLIEF	JKAK	XFKBASLIEF		☐	XFKBASLIEF	☐	IS-M: Billing based on delivery
44	XJKSOFAKT	JKAK	XJKSOFAKT		☐	XJKSOFAKT	☐	IS-M/SD: Immed.billing for credit memo request (subsc.only)
45	XWBZABO	JKAK	XWBZABO		☐	XWBZABO	☐	IS-M: WBZ subscription
46	XFKVDICHT	JKAK	XFKVDICHT		☐	XFKVDICHT	☐	IS-M: Summarize deliveries according to billing item
47	XSTATARC	JKAK	XSTATARC		☐	XJSTATARC	☐	IS-M: Order archived in full (only placed in archive)
48	KALSM_AMO	JKAK	KALSM_AMO		☐	KALSM_AMO	☐	IS-M/SD: Pricing Procedure for Amortization
49	XRENEWAL	JKAK	XRENEWAL		☐	XRENEWAL	☐	IS-M/SD: Order extended by renewal offer
50	AMORTN	JKAK	AMORTN		☐	AMORTN	☐	IS-M/SD: Use of Liability Account in Order
51	REKLERGB	JKAK	REKLERGB		☐	ISM_REKLERGB	☐	IS-M: Complaint Result
52	REKLTYP	JKAK	REKLTYP		☐	ISM_REKLTYP	☐	IS-M: Complaint Category
53	REKLDATUM	JKAK	REKLDATUM		☐	ISM_COMPLDATE	☐	IS-M/SD: Complaint Date
54	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
55	GUELTIGVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
56	GUELTIGBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
57	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
58	AEART	JKAP	AEART		☐	AEART_JSDK	☐	Order Change Type
59	ZSKLS	JKAP	ZSKLS		☐	JZSKLS	☐	Time slice classification for sales order
60	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
61	KUNWE	JKAP	KUNWE		☐	GPNR_WE	☐	IS-M: Business Partner Ship-to Party
62	KUNWEFREMD	JKAP	KUNWEFREMD		☐	JKUNNRVERL	☐	Cust.No. with External Company (External Deliveries/Retail)
63	LANDE	JKAP	LANDE		☐	LANDE_ISP	☐	Current country being supplied
64	LAND1	JKAP	LAND1		☐	LAND1_ISP	☐	Normal delivery country
65	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
66	PVA	JKAP	PVA		☐	PVA	☐	Edition
67	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
68	XRUECKABO	JKAP	XRUECKABO		☐	XRUECKABO	☐	IS-M: Backdated subscription created
69	LIEFVON	JKAP	LIEFVON		☐	LIEFVON	☐	Regular start of delivery for item in sales order
70	SPART	JKAP	SPART		☐	SPARTDRERZ	☐	Division for publication
71	MATKL	JKAP	MATKL		☐	MATKL	☐	Material Group
72	GSBER	JKAP	GSBER		☐	GSBER	☐	Business Area
73	VOREF	JKAP	VOREF		☐	VOREF	☐	Complete reference indicator
74	ERLRE	JKAP	ERLRE		☐	ERLRE	☐	Completion rule for quotation / contract
75	TAXM1	JKAP	TAXM1		☐	TAXMT	☐	Tax classification material
76	TAXM2	JKAP	TAXM2		☐	TAXMT	☐	Tax classification material
77	TAXM3	JKAP	TAXM3		☐	TAXMT	☐	Tax classification material
78	TAXM4	JKAP	TAXM4		☐	TAXMT	☐	Tax classification material
79	TAXM5	JKAP	TAXM5		☐	TAXMT	☐	Tax classification material
80	TAXM6	JKAP	TAXM6		☐	TAXMT	☐	Tax classification material
81	TAXM7	JKAP	TAXM7		☐	TAXMT	☐	Tax classification material
82	TAXM8	JKAP	TAXM8		☐	TAXMT	☐	Tax classification material
83	TAXM9	JKAP	TAXM9		☐	TAXMT	☐	Tax classification material
84	VGREF	JKAP	VGREF		☐	VGREF	☐	Preceding document has resulted from reference
85	STAFO	JKAP	STAFO		☐	STAFO	☐	Update group for statistics update
86	STCUR	JKAP	STCUR		☐	STCUR_AP	☐	Exchange rate for statistics (Exch.rate at time of creation)
87	IVWKN	JKAP	IVWKN		☐	IVWKN	☐	Circulation Audit Report Category ID
88	IVWKNFREI	JKAP	IVWKNFREI		☐	IVWKNFREI	☐	Circulation Report Category ID for Non-Calculation Period
89	XLIEFSE	JKAP	XLIEFSE		☐	XLIEFSE	☐	Delivery to social facility
90	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
91	LIEFXUHR	JKAP	LIEFXUHR		☐	LIEFXUHR	☐	Time of latest delivery
92	DRUCKEREI	JKAP	DRUCKEREI		☐	JWERK	☐	Plant
93	VSAUSSTART	JKAP	VSAUSSTART		☐	VSAUSSTART	☐	Shipping outsorting type
94	UNTBRGRD	JKAP	UNTBRGRD		☐	UNTBRGRD	☐	Reason for Suspension
95	BEZUGGRD	JKAP	BEZUGGRD		☐	BEZUGGRD	☐	Purchase Reason
96	GUTSCHEIN	JKAP	GUTSCHEIN		☐	GUTSCHEIN	☐	Coupon Number
97	XGUTSCHEIN	JKAP	XGUTSCHEIN		☐	XGUTSCHEIN	☐	Indicator: Vouchers allowed
98	XDISPO	JKAP	XDISPO		☐	XDISPO	☐	Indicator: relevant to planning
99	XUNVLIEFER	JKAP	XUNVLIEFER		☐	XUNVLIEFER	☐	IS-M: Viability Data Incomplete for Item
100	XUNVLAUTO	JKAP	XUNVLAUTO		☐	XUNVLAUTO	☐	IS-M: Via.data incomp.for item (due to automatic change)
101	RECHBEGINN	JKAP	RECHBEGINN		☐	RECHBEGINN	☐	Billing From
102	RECHENDE	JKAP	RECHENDE		☐	RECHENDE	☐	Billing To
103	XLIEFBAR	JKAP	XLIEFBAR		☐	XLIEFBAR	☐	Determine delivery viability
104	XIVW	JKAP	XIVW		☐	XIVW	☐	Indicator: Relevant for audit report
105	XFAKTURA	JKAP	XFAKTURA		☐	XFAKTURA	☐	Indicator: Relevant for billing
106	PRSFD	JKAP	PRSFD		☐	PRSFD	☐	Carry out pricing
107	SBFREI	JKAP	SBFREI		☐	SBFREI	☐	Administrator responsible for free copies
108	WDVDAT	JKAP	WDVDAT		☐	WDVDAT	☐	Resubmission date
109	KUENDGRD	JKAP	KUENDGRD		☐	KUENDGRD	☐	Reason for end of delivery
110	XLOGO	JKAP	XLOGO		☐	XLOGO	☐	Print Logo
111	XFAKTSPERR	JKAP	XFAKTSPERR		☐	XFAKTSPERR	☐	IS-M: Billing block set
112	XBAGABR	JKAP	XBAGABR		☐	XBAGABR	☐	Indicator: BAG billing procedure
113	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
114	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
115	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
116	VBELN_VL	JKAP	VBELN_VL		☐	AVNR_VL	☐	Reference Document
117	POSNR_VL	JKAP	POSNR_VL		☐	APNR_VL	☐	Reference Document Item
118	PVAKNTGRP	JKAP	PVAKNTGRP		☐	PVAKNTGRP	☐	Account Assignment Grouping for Edition
119	PVAKONGRP	JKAP	PVAKONGRP		☐	PVAKONGRP	☐	Condition Grouping for Edition
120	PVABONGRP	JKAP	PVABONGRP		☐	PVABONGRP	☐	Edition bonus grouping
121	XTECHVORB	JKAP	XTECHVORB		☐	XTECHVORB	☐	Indicator: Technical problem
122	REMART	JKAP	REMART		☐	REMART	☐	Return Type
123	REMWEISE	JKAP	REMWEISE		☐	REMWEISE	☐	Return Method
124	REMQUOTE	JKAP	REMQUOTE		☐	REMQUOTE	☐	Expected return rate in percent
125	XMAXREMMG	JKAP	XMAXREMMG		☐	XMAXREMMG	☐	Expected return quantity is maximum return quantity
126	ETENR_LAST	JKAP	ETENR_LAST		☐	ETENR_LAST	☐	Last Schedule Line Number Assigned
127	ETEEX_LAST	JKAP	ETEEX_LAST		☐	ETEEX_LAST	☐	Last Schedule Line Number Assigned
128	KOKRS	JKAP	KOKRS		☐	KOKRS	☐	Controlling Area
129	KOSTL_L	JKAP	KOSTL_L		☐	KOSTL_L	☐	Debit Cost Center
130	XPATE	JKAP	XPATE		☐	XPATE	☐	IS-M: Sponsored subscription
131	BEZIRK	JKAP	BEZIRK		☐	BEZIRK	☐	Carrier Route
132	XLIEFGP	JKAP	XLIEFGP		☐	XLIEFGP	☐	IS-M: Delivery to business partner
133	XLIEFBEZ	JKAP	XLIEFBEZ		☐	XLIEFBEZ	☐	IS-M: Delivery to a carrier route (reserve)
134	XNEGOPTION	JKAP	XNEGOPTION		☐	XNEGOPTION	☐	IS-M: Item with Automatic Transformation to Chargeable
135	BEZPERSE	JKAP	BEZPERSE		☐	BEZPERSE	☐	IS-M: Service Type for Social Facility
136	VSOZMENGE	JKAP	VSOZMENGE		☐	VSOZMENGE	☐	IS-M: Maximum schedule line quantity for social facility
137	LFBARDAT	JKAP	LFBARDAT		☐	LFBARDAT	☐	Delivery viability set for sales order item valid from
138	SHKZG	JKAP	SHKZG		☐	SHKZG_ISP	☐	IS-M: Debit indicator for schedule line
139	VKBURZUS	JKAP	VKBURZUS		☐	VKBURZUS	☐	Sales office responsible
140	XSTORNO	JKAP	XSTORNO		☐	XJSTORNO	☐	Indicator: Reversed
141	STORNOGRD	JKAP	STORNOGRD		☐	STORNOGRD	☐	Reversal Reason
142	XSCRIPT	JKAP	XSCRIPT		☐	XSCRIPT	☐	SAPscript comment recorded
143	WBZSATZART	JKAP	WBZSATZART		☐	JWBZSTZART	☐	IS-M: WBZ, Record Type
144	WBZVORGART	JKAP	WBZVORGART		☐	JWBZVORART	☐	IS-M: WBZ, Operation Type
145	WERBKZSCHL	JKAP	WERBKZSCHL		☐	JWBZWKZSCH	☐	IS-M: WBZ, Promotion Rebate Key
146	WBZABOKUNR	JKAP	WBZABOKUNR		☐	JWBZABOKNR	☐	IS-M: Subscription Customer Number
147	XWBZRUECKU	JKAP	XWBZRUECKU		☐	XJWBZRUECK	☐	IS-M: WBZ, reply to WBZ company required
148	WBZKUNNR	JKAP	WBZKUNNR		☐	JWBZKUNNR	☐	IS-M: WBZ, VDZ Number of WBZ Company
149	VERTRKENNZ	JKAP	VERTRKENNZ		☐	JWBZVKENNZ	☐	IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)
150	WBZTERMIN	JKAP	WBZTERMIN		☐	JWBZTERMIN	☐	IS-M: WBZ, Date (Format: MMYYYYCCCC)
151	WBZVERTRETER	JKAP	WBZVERTRETER		☐	JWBZVERTR	☐	IS-M: WBZ, representative indicator
152	XSEPARATVS	JKAP	XSEPARATVS		☐	JXSEPRATVS	☐	IS-M: Separate first delivery
153	HEFTNUMVON	JKAP	HEFTNUMVON		☐	HEFTNUMVON	☐	Copy Number of First Issue to be Delivered
154	HEFTNUMBIS	JKAP	HEFTNUMBIS		☐	HEFTNUMBIS	☐	Copy Number of Last Issue for Delivery
155	JNBRIEFTYP	JKAP	JNBRIEFTYP		☐	JNBRIEFTYP	☐	Letter type for generating letters using output control
156	XFMODRUECK	JKAP	XFMODRUECK		☐	XFMODRUECK	☐	IS-M: Backdated changes to billing method
157	XEXPDATE	JKAP	XEXPDATE		☐	XEXPDATE	☐	Limited order change affects expiration date
158	TXJCD	JKAP	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
159	XDELIV_FIXED	JKAP	XDELIV_FIXED		☐	XDELIV_FIXED	☐	IS-M/SD: No Del.Viability Optimization (Parameters Fixed)
160	XNEW_PUBL	JKAP	XNEW_PUBL		☐	XNEW_PUBL	☐	IS-M/SD: Item created by change of publication
161	DELIVSPLITGRP	JKAP	DELIVSPLITGRP		☐	DELIVSPLITGRP	☐	IS-M/SD: Address Alternation Group
162	DELIVSPLIT	JKAP	DELIVSPLIT		☐	DELIVSPLIT	☐	IS-M/SD: Alternating Address Element
163	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
164	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
165	XMAINSPLIT	JKAP	XMAINSPLIT		☐	XMAINSPLIT	☐	Item for this Alternating Add. Element is a Main Sub-Item
166	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
167	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
168	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
169	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
170	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
171	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
172	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
173	CAMPAIGN	JKAP	CAMPAIGN		☐	ISM_MARKETING_CAMPAIGN	☐	IS-M: Marketing Campaign

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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