SAP ABAP Table V_JSBW_POS_CYCLE (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_JSBW_POS_CYCLE	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_JSBW_POS_CYCLE	AUART	TJAK	AUART	REF	1	CN
2	V_JSBW_POS_CYCLE	BEZIRK	JVTBEZIRK	BEZIRK	REF	C	CN
3	V_JSBW_POS_CYCLE	BEZPERSE	TJD09	BEZPER	REF	C	CN
4	V_JSBW_POS_CYCLE	BEZUGGRD	TJK87	BEZUGGRD	REF	C	CN
5	V_JSBW_POS_CYCLE	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
6	V_JSBW_POS_CYCLE	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
7	V_JSBW_POS_CYCLE	DELIVSPLITGRP	TJD63	DELIVSPLITGRP	REF	C	CN
8	V_JSBW_POS_CYCLE	DRERZ	JDTDRER	DRERZ	REF	C	CN
9	V_JSBW_POS_CYCLE	DRUCKEREI	T001W	WERKS	REF	C	CN
10	V_JSBW_POS_CYCLE	ETENR_LAST	JKEP	ETENR	REF	C	CN
11	V_JSBW_POS_CYCLE	FAKSP	TVFS	FAKSP	REF	C	CN
12	V_JSBW_POS_CYCLE	GSBER	TGSB	GSBER	REF	C	CN
13	V_JSBW_POS_CYCLE	IVWKN	TJI01	IVWKN	REF	C	CN
14	V_JSBW_POS_CYCLE	IVWKNFREI	TJI01	IVWKN	REF	C	CN
15	V_JSBW_POS_CYCLE	JNBRIEFTYP	TJN11	JNBRIEFTYP	REF	C	CN
16	V_JSBW_POS_CYCLE	KOKRS	TKA01	KOKRS	REF	C	CN
17	V_JSBW_POS_CYCLE	KORRGRD	TJK81	KORRGRD	REF	C	CN
18	V_JSBW_POS_CYCLE	KOSTL_L	CSKS	KOSTL	REF	C	CN
19	V_JSBW_POS_CYCLE	KUENDGRD	TJK83	KUENDGRD	REF	C	CN
20	V_JSBW_POS_CYCLE	KUNWE	JGTGPNR	GPNR	REF	C	CN
21	V_JSBW_POS_CYCLE	LAND1	T005	LAND1	REF	C	CN
22	V_JSBW_POS_CYCLE	LANDE	T005	LAND1	REF	C	CN
23	V_JSBW_POS_CYCLE	LIEFERART	TJV01	LIEFERART	REF	C	CN
24	V_JSBW_POS_CYCLE	MANDT	T000	MANDT	KEY	1	CN
25	V_JSBW_POS_CYCLE	MATKL	T023	MATKL	REF	C	CN
26	V_JSBW_POS_CYCLE	POART	TJAP	POART	REF	1	CN
27	V_JSBW_POS_CYCLE	POSNR_MAIN	JKAP	POSNR	REF	C	CN
28	V_JSBW_POS_CYCLE	POSNR_SUB	JKAP	POSNR	REF	C	CN
29	V_JSBW_POS_CYCLE	POSNR_UR	JKAP	POSNR	REF	1	CN
30	V_JSBW_POS_CYCLE	POSNR_VG	JKAP	POSNR	REF	1	CN
31	V_JSBW_POS_CYCLE	POSNR_VL	JKAP	POSNR	REF	C	CN
32	V_JSBW_POS_CYCLE	PVA	JDTPVA	PVA	REF	C	CN
33	V_JSBW_POS_CYCLE	PVABONGRP	TJD49	PVABONGRP	REF	C	CN
34	V_JSBW_POS_CYCLE	PVAKNTGRP	TVKM	KTGRM	REF	C	CN
35	V_JSBW_POS_CYCLE	PVAKONGRP	TJD47	PVAKONGRP	REF	C	CN
36	V_JSBW_POS_CYCLE	SPART	TSPA	SPART	REF	C	CN
37	V_JSBW_POS_CYCLE	STORNOGRD	TJK91	STORNOGRD	REF	C	CN
38	V_JSBW_POS_CYCLE	UNTBRGRD	TJK85	UNTBRGRD	REF	C	CN
39	V_JSBW_POS_CYCLE	VBELN	JKAK	VBELN	KEY	1	CN
40	V_JSBW_POS_CYCLE	VBELN_VL	JKAK	VBELN	REF	C	CN
41	V_JSBW_POS_CYCLE	VKBURZUS	TVBUR	VKBUR	REF	C	CN
42	V_JSBW_POS_CYCLE	VSAUSSTART	TJV09	VSAUSSTART	REF	C	CN
43	V_JSBW_POS_CYCLE	WBZSATZART	TJKW1	SATZART
44	V_JSBW_POS_CYCLE	WBZVORGART	TJKW3	VORGANGART
45	V_JSBW_POS_CYCLE	WERBKZSCHL	TJKW9	WERBKZSCHL		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in