SAP ABAP View V_JSBW_POS_CYCLE (IS-M/SD: View for Extractor for Payment Cycles/Liab. Accts)

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_CYCLE
Short Description	IS-M/SD: View for Extractor for Payment Cycles/Liab. Accts
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	JKAP	MANDT	JL	EQ				0	0
2	JKAK	MANDT	JR	EQ			AND	0	0
3	JKAP	VBELN	JL	EQ				0	0
4	JKAK	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	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
3	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
4	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
5	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
6	VBELN	JKAP	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
7	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
8	GUELTIGVON	JKAP	GUELTIGVON		☐	JKAPVON	☐	Valid-From Date of Sales Order Item
9	GUELTIGBIS	JKAP	GUELTIGBIS		☐	JKAPBIS	☐	Date to which Sales Order Item is Valid
10	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
11	AEART	JKAP	AEART		☐	AEART_JSDK	☐	Order Change Type
12	ZSKLS	JKAP	ZSKLS		☐	JZSKLS	☐	Time slice classification for sales order
13	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
14	KUNWE	JKAP	KUNWE		☐	GPNR_WE	☐	IS-M: Business Partner Ship-to Party
15	KUNWEFREMD	JKAP	KUNWEFREMD		☐	JKUNNRVERL	☐	Cust.No. with External Company (External Deliveries/Retail)
16	LANDE	JKAP	LANDE		☐	LANDE_ISP	☐	Current country being supplied
17	LAND1	JKAP	LAND1		☐	LAND1_ISP	☐	Normal delivery country
18	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
19	PVA	JKAP	PVA		☐	PVA	☐	Edition
20	BEZUGSTYP	JKAP	BEZUGSTYP		☐	BEZUGSTYP_JE_PVA	☐	Mix Type
21	XRUECKABO	JKAP	XRUECKABO		☐	XRUECKABO	☐	IS-M: Backdated subscription created
22	LIEFVON	JKAP	LIEFVON		☐	LIEFVON	☐	Regular start of delivery for item in sales order
23	SPART	JKAP	SPART		☐	SPARTDRERZ	☐	Division for publication
24	MATKL	JKAP	MATKL		☐	MATKL	☐	Material Group
25	GSBER	JKAP	GSBER		☐	GSBER	☐	Business Area
26	VOREF	JKAP	VOREF		☐	VOREF	☐	Complete reference indicator
27	ERLRE	JKAP	ERLRE		☐	ERLRE	☐	Completion rule for quotation / contract
28	TAXM1	JKAP	TAXM1		☐	TAXMT	☐	Tax classification material
29	TAXM2	JKAP	TAXM2		☐	TAXMT	☐	Tax classification material
30	TAXM3	JKAP	TAXM3		☐	TAXMT	☐	Tax classification material
31	TAXM4	JKAP	TAXM4		☐	TAXMT	☐	Tax classification material
32	TAXM5	JKAP	TAXM5		☐	TAXMT	☐	Tax classification material
33	TAXM6	JKAP	TAXM6		☐	TAXMT	☐	Tax classification material
34	TAXM7	JKAP	TAXM7		☐	TAXMT	☐	Tax classification material
35	TAXM8	JKAP	TAXM8		☐	TAXMT	☐	Tax classification material
36	TAXM9	JKAP	TAXM9		☐	TAXMT	☐	Tax classification material
37	VGREF	JKAP	VGREF		☐	VGREF	☐	Preceding document has resulted from reference
38	STAFO	JKAP	STAFO		☐	STAFO	☐	Update group for statistics update
39	STCUR	JKAP	STCUR		☐	STCUR_AP	☐	Exchange rate for statistics (Exch.rate at time of creation)
40	IVWKN	JKAP	IVWKN		☐	IVWKN	☐	Circulation Audit Report Category ID
41	IVWKNFREI	JKAP	IVWKNFREI		☐	IVWKNFREI	☐	Circulation Report Category ID for Non-Calculation Period
42	XLIEFSE	JKAP	XLIEFSE		☐	XLIEFSE	☐	Delivery to social facility
43	LIEFERART	JKAP	LIEFERART		☐	LIEFERART	☐	Delivery Type
44	LIEFXUHR	JKAP	LIEFXUHR		☐	LIEFXUHR	☐	Time of latest delivery
45	DRUCKEREI	JKAP	DRUCKEREI		☐	JWERK	☐	Plant
46	VSAUSSTART	JKAP	VSAUSSTART		☐	VSAUSSTART	☐	Shipping outsorting type
47	UNTBRGRD	JKAP	UNTBRGRD		☐	UNTBRGRD	☐	Reason for Suspension
48	BEZUGGRD	JKAP	BEZUGGRD		☐	BEZUGGRD	☐	Purchase Reason
49	KORRGRD	JKAP	KORRGRD		☐	KORRGRD	☐	IS-M: Reason for correction
50	GUTSCHEIN	JKAP	GUTSCHEIN		☐	GUTSCHEIN	☐	Coupon Number
51	XGUTSCHEIN	JKAP	XGUTSCHEIN		☐	XGUTSCHEIN	☐	Indicator: Vouchers allowed
52	XDISPO	JKAP	XDISPO		☐	XDISPO	☐	Indicator: relevant to planning
53	XUNVLIEFER	JKAP	XUNVLIEFER		☐	XUNVLIEFER	☐	IS-M: Viability Data Incomplete for Item
54	XUNVLAUTO	JKAP	XUNVLAUTO		☐	XUNVLAUTO	☐	IS-M: Via.data incomp.for item (due to automatic change)
55	RECHBEGINN	JKAP	RECHBEGINN		☐	RECHBEGINN	☐	Billing From
56	RECHENDE	JKAP	RECHENDE		☐	RECHENDE	☐	Billing To
57	XLIEFBAR	JKAP	XLIEFBAR		☐	XLIEFBAR	☐	Determine delivery viability
58	XIVW	JKAP	XIVW		☐	XIVW	☐	Indicator: Relevant for audit report
59	XFAKTURA	JKAP	XFAKTURA		☐	XFAKTURA	☐	Indicator: Relevant for billing
60	PRSFD	JKAP	PRSFD		☐	PRSFD	☐	Carry out pricing
61	SBFREI	JKAP	SBFREI		☐	SBFREI	☐	Administrator responsible for free copies
62	WDVDAT	JKAP	WDVDAT		☐	WDVDAT	☐	Resubmission date
63	KUENDGRD	JKAP	KUENDGRD		☐	KUENDGRD	☐	Reason for end of delivery
64	XLOGO	JKAP	XLOGO		☐	XLOGO	☐	Print Logo
65	FAKSP	JKAP	FAKSP		☐	FAKTSPERRE	☐	Billing Block
66	XFAKTSPERR	JKAP	XFAKTSPERR		☐	XFAKTSPERR	☐	IS-M: Billing block set
67	XREMRECHT	JKAP	XREMRECHT		☐	XREMRECHT	☐	IS-M: Right of Return
68	XBAGABR	JKAP	XBAGABR		☐	XBAGABR	☐	Indicator: BAG billing procedure
69	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
70	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
71	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
72	VBELN_VL	JKAP	VBELN_VL		☐	AVNR_VL	☐	Reference Document
73	POSNR_VL	JKAP	POSNR_VL		☐	APNR_VL	☐	Reference Document Item
74	PVAKNTGRP	JKAP	PVAKNTGRP		☐	PVAKNTGRP	☐	Account Assignment Grouping for Edition
75	PVAKONGRP	JKAP	PVAKONGRP		☐	PVAKONGRP	☐	Condition Grouping for Edition
76	PVABONGRP	JKAP	PVABONGRP		☐	PVABONGRP	☐	Edition bonus grouping
77	XTECHVORB	JKAP	XTECHVORB		☐	XTECHVORB	☐	Indicator: Technical problem
78	REMART	JKAP	REMART		☐	REMART	☐	Return Type
79	REMWEISE	JKAP	REMWEISE		☐	REMWEISE	☐	Return Method
80	REMQUOTE	JKAP	REMQUOTE		☐	REMQUOTE	☐	Expected return rate in percent
81	XMAXREMMG	JKAP	XMAXREMMG		☐	XMAXREMMG	☐	Expected return quantity is maximum return quantity
82	ETENR_LAST	JKAP	ETENR_LAST		☐	ETENR_LAST	☐	Last Schedule Line Number Assigned
83	ETEEX_LAST	JKAP	ETEEX_LAST		☐	ETEEX_LAST	☐	Last Schedule Line Number Assigned
84	KOKRS	JKAP	KOKRS		☐	KOKRS	☐	Controlling Area
85	KOSTL_L	JKAP	KOSTL_L		☐	KOSTL_L	☐	Debit Cost Center
86	XPATE	JKAP	XPATE		☐	XPATE	☐	IS-M: Sponsored subscription
87	BEZIRK	JKAP	BEZIRK		☐	BEZIRK	☐	Carrier Route
88	XLIEFGP	JKAP	XLIEFGP		☐	XLIEFGP	☐	IS-M: Delivery to business partner
89	XLIEFBEZ	JKAP	XLIEFBEZ		☐	XLIEFBEZ	☐	IS-M: Delivery to a carrier route (reserve)
90	XNEGOPTION	JKAP	XNEGOPTION		☐	XNEGOPTION	☐	IS-M: Item with Automatic Transformation to Chargeable
91	BEZPERSE	JKAP	BEZPERSE		☐	BEZPERSE	☐	IS-M: Service Type for Social Facility
92	VSOZMENGE	JKAP	VSOZMENGE		☐	VSOZMENGE	☐	IS-M: Maximum schedule line quantity for social facility
93	LFBARDAT	JKAP	LFBARDAT		☐	LFBARDAT	☐	Delivery viability set for sales order item valid from
94	SHKZG	JKAP	SHKZG		☐	SHKZG_ISP	☐	IS-M: Debit indicator for schedule line
95	VKBURZUS	JKAP	VKBURZUS		☐	VKBURZUS	☐	Sales office responsible
96	ERFUSER	JKAP	ERFUSER		☐	ERFUSER	☐	Created By
97	ERFDATE	JKAP	ERFDATE		☐	ERFDATE	☐	Created On
98	ERFTIME	JKAP	ERFTIME		☐	ERFTIME	☐	Time Created
99	AENUSER	JKAP	AENUSER		☐	AENUSER	☐	Last Changed By
100	AENDATE	JKAP	AENDATE		☐	AENDATE	☐	Date of Last Change
101	AENTIME	JKAP	AENTIME		☐	AENTIME	☐	Time of Last Change
102	XSTORNO	JKAP	XSTORNO		☐	XJSTORNO	☐	Indicator: Reversed
103	STORNOGRD	JKAP	STORNOGRD		☐	STORNOGRD	☐	Reversal Reason
104	REFBELEG	JKAP	REFBELEG		☐	REMELD_ISP	☐	IS-M/SD: Reference Document in Legacy System
105	XSCRIPT	JKAP	XSCRIPT		☐	XSCRIPT	☐	SAPscript comment recorded
106	WBZSATZART	JKAP	WBZSATZART		☐	JWBZSTZART	☐	IS-M: WBZ, Record Type
107	WBZVORGART	JKAP	WBZVORGART		☐	JWBZVORART	☐	IS-M: WBZ, Operation Type
108	WERBKZSCHL	JKAP	WERBKZSCHL		☐	JWBZWKZSCH	☐	IS-M: WBZ, Promotion Rebate Key
109	WBZABOKUNR	JKAP	WBZABOKUNR		☐	JWBZABOKNR	☐	IS-M: Subscription Customer Number
110	XWBZRUECKU	JKAP	XWBZRUECKU		☐	XJWBZRUECK	☐	IS-M: WBZ, reply to WBZ company required
111	WBZKUNNR	JKAP	WBZKUNNR		☐	JWBZKUNNR	☐	IS-M: WBZ, VDZ Number of WBZ Company
112	VERTRKENNZ	JKAP	VERTRKENNZ		☐	JWBZVKENNZ	☐	IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)
113	WBZTERMIN	JKAP	WBZTERMIN		☐	JWBZTERMIN	☐	IS-M: WBZ, Date (Format: MMYYYYCCCC)
114	WBZVERTRETER	JKAP	WBZVERTRETER		☐	JWBZVERTR	☐	IS-M: WBZ, representative indicator
115	XSEPARATVS	JKAP	XSEPARATVS		☐	JXSEPRATVS	☐	IS-M: Separate first delivery
116	HEFTNUMVON	JKAP	HEFTNUMVON		☐	HEFTNUMVON	☐	Copy Number of First Issue to be Delivered
117	HEFTNUMBIS	JKAP	HEFTNUMBIS		☐	HEFTNUMBIS	☐	Copy Number of Last Issue for Delivery
118	XNOMESS	JKAP	XNOMESS		☐	XNOMESS	☐	IS-M: Indicator - Do Not Perform Output Determination
119	JNBRIEFTYP	JKAP	JNBRIEFTYP		☐	JNBRIEFTYP	☐	Letter type for generating letters using output control
120	XFMODRUECK	JKAP	XFMODRUECK		☐	XFMODRUECK	☐	IS-M: Backdated changes to billing method
121	XEXPDATE	JKAP	XEXPDATE		☐	XEXPDATE	☐	Limited order change affects expiration date
122	TXJCD	JKAP	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
123	XDELIV_FIXED	JKAP	XDELIV_FIXED		☐	XDELIV_FIXED	☐	IS-M/SD: No Del.Viability Optimization (Parameters Fixed)
124	XNEW_PUBL	JKAP	XNEW_PUBL		☐	XNEW_PUBL	☐	IS-M/SD: Item created by change of publication
125	DELIVSPLITGRP	JKAP	DELIVSPLITGRP		☐	DELIVSPLITGRP	☐	IS-M/SD: Address Alternation Group
126	DELIVSPLIT	JKAP	DELIVSPLIT		☐	DELIVSPLIT	☐	IS-M/SD: Alternating Address Element
127	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
128	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
129	XMAINSPLIT	JKAP	XMAINSPLIT		☐	XMAINSPLIT	☐	Item for this Alternating Add. Element is a Main Sub-Item
130	X_MONTAG	JKAP	X_MONTAG		☐	X_MONTAG	☐	IS-M: Monday
131	X_DIENSTAG	JKAP	X_DIENSTAG		☐	X_DIENSTAG	☐	IS-M: Tuesday
132	X_MITTWOCH	JKAP	X_MITTWOCH		☐	X_MITTWOCH	☐	IS-M: Wednesday
133	X_DONNETAG	JKAP	X_DONNETAG		☐	X_DONNETAG	☐	IS-M: Thursday
134	X_FREITAG	JKAP	X_FREITAG		☐	X_FREITAG	☐	IS-M: Friday
135	X_SAMSTAG	JKAP	X_SAMSTAG		☐	X_SAMSTAG	☐	IS-M: Saturday
136	X_SONNTAG	JKAP	X_SONNTAG		☐	X_SONNTAG	☐	IS-M: Sunday
137	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