SAP ABAP Table V_JSBW_RECL_ITEM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_JSBW_RECL_ITEM	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	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order
3	GPAG	☑	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	JGTGPNR
4	JPARVWGPAG	☑	JPARVWGPAG	JPARVWGPAG	CHAR	1	0	IS-M: Partner usage of sold-to party
5	VBTYP	☑	VBTYP_ISP	VBTYP_ISP	CHAR	1	0	Sales document category, IS-M
6	TRVOG	☑	TRVOG_ISP	TRVOG_ISP	CHAR	1	0	Transaction Group for IS-M Order Processing
7	AUART	☑	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	TJAK
8	AUARTGRP	☑	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
9	WAERK	☑	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
10	NETWR	☑	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
11	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
12	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
13	SPART	☑	SPART_AK	SPART	CHAR	2	0	Division for order header	TVTA
14	VKGRP	☑	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
15	VKBUR	☑	JVKBUR	VKBUR	CHAR	4	0	IS-M/SD: Receiving Sales Office	TVKBZ
16	KNUMV	☑	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
17	FAKSP	☑	FAKTSPERRE	FAKSP	CHAR	2	0	Billing Block	TVFS
18	KALSM	☑	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
19	KURST	☑	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
20	STAFO	☑	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
21	STWAE	☑	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
22	XIMMATRIK	☑	XIMMATRIK	XFELD	CHAR	1	0	Indicator: Proof of matriculation provided
23	IMMATDAT	☑	IMMATDAT	DATUM	DATS	8	0	Matriculation Certificate Valid To
24	KORRGRD	☑	KORRGRD	KORRGRD	CHAR	3	0	IS-M: Reason for correction	TJK81
25	REMVON	☑	REMVON_ISP	DATUM	DATS	8	0	IS-M: Return date from
26	REMBIS	☑	REMBIS_ISP	DATUM	DATS	8	0	IS-M: Return date valid to
27	REFBELEG	☑	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
28	REMDATUM	☑	REMDAT_ISP	DATUM	DATS	8	0	IS-M: Date of return notification
29	REMSCHEIN	☑	RSCHEIN_IS	NUM6	NUMC	6	0	IS-M: Return slip number
30	XFKBASAUFT	☑	XFKBASAUFT	XFELD	CHAR	1	0	IS-M: Billing based on order
31	XFKBASLIEF	☑	XFKBASLIEF	XFELD	CHAR	1	0	IS-M: Billing based on delivery
32	XJKSOFAKT	☑	XJKSOFAKT	XFELD	CHAR	1	0	IS-M/SD: Immed.billing for credit memo request (subsc.only)
33	XRENEWAL	☑	XRENEWAL	XFELD	CHAR	1	0	IS-M/SD: Order extended by renewal offer
34	REKLERGB	☑	ISM_REKLERGB	ISM_REKLERGB	CHAR	2	0	IS-M: Complaint Result	TJK17
35	REKLTYP	☑	ISM_REKLTYP	ISM_REKLTYP	NUMC	1	0	IS-M: Complaint Category
36	REKLDATUM	☑	ISM_COMPLDATE	DATUM	DATS	8	0	IS-M/SD: Complaint Date
37	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item
38	GUELTIGVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
39	GUELTIGBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
40	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	TJAP
41	AEART	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
42	ZSKLS	☐	JZSKLS	JZSKLS	CHAR	1	0	Time slice classification for sales order
43	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
44	DRERZ	☐	DRERZ	DRERZ	CHAR	8	0	Publication	JDTDRER
45	PVA	☐	PVA	PVA	CHAR	8	0	Edition	JDTPVA
46	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
47	XRUECKABO	☐	XRUECKABO	XFELD	CHAR	1	0	IS-M: Backdated subscription created
48	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
49	IVWKNFREI	☐	IVWKNFREI	IVWKN	CHAR	8	0	Circulation Report Category ID for Non-Calculation Period	TJI01
50	XLIEFSE	☐	XLIEFSE	XFELD	CHAR	1	0	Delivery to social facility
51	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	TJV01
52	UNTBRGRD	☐	UNTBRGRD	UNTBRGRD	CHAR	3	0	Reason for Suspension	TJK85
53	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	TJK87
54	RECHBEGINN	☐	RECHBEGINN	DATUM	DATS	8	0	Billing From
55	RECHENDE	☐	RECHENDE	DATUM	DATS	8	0	Billing To
56	XIVW	☐	XIVW	XFELD	CHAR	1	0	Indicator: Relevant for audit report
57	XFAKTURA	☐	XFAKTURA	XFELD	CHAR	1	0	Indicator: Relevant for billing
58	KUENDGRD	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	TJK83
59	XURPOS	☐	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order
60	POSNR_UR	☐	APNR_UR	APNR	NUMC	6	0	Original Item in Publishing Sales Order	JKAP
61	POSNR_VG	☐	APNR_VG	APNR	NUMC	6	0	Preceding Item in Publishing Sales Order	JKAP
62	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
63	KOSTL_L	☐	KOSTL_L	KOSTL	CHAR	10	0	Debit Cost Center	CSKS
64	XSTORNO	☐	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
65	STORNOGRD	☐	STORNOGRD	STORNOGRD	CHAR	3	0	Reversal Reason	TJK91
66	HEFTNUMVON	☐	HEFTNUMVON	HEFTNUMMER	CHAR	9	0	Copy Number of First Issue to be Delivered
67	HEFTNUMBIS	☐	HEFTNUMBIS	HEFTNUMMER	CHAR	9	0	Copy Number of Last Issue for Delivery
68	DELIVSPLITGRP	☐	DELIVSPLITGRP	DELIVSPLITGRP	CHAR	10	0	IS-M/SD: Address Alternation Group	TJD63
69	DELIVSPLIT	☐	DELIVSPLIT	DELIVSPLIT	CHAR	8	0	IS-M/SD: Alternating Address Element	TJD23
70	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	JKAP
71	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	JKAP
72	XMAINSPLIT	☐	XMAINSPLIT	XFELD	CHAR	1	0	Item for this Alternating Add. Element is a Main Sub-Item
73	X_MONTAG	☐	X_MONTAG	XFELD	CHAR	1	0	IS-M: Monday
74	X_DIENSTAG	☐	X_DIENSTAG	XFELD	CHAR	1	0	IS-M: Tuesday
75	X_MITTWOCH	☐	X_MITTWOCH	XFELD	CHAR	1	0	IS-M: Wednesday
76	X_DONNETAG	☐	X_DONNETAG	XFELD	CHAR	1	0	IS-M: Thursday
77	X_FREITAG	☐	X_FREITAG	XFELD	CHAR	1	0	IS-M: Friday
78	X_SAMSTAG	☐	X_SAMSTAG	XFELD	CHAR	1	0	IS-M: Saturday
79	X_SONNTAG	☐	X_SONNTAG	XFELD	CHAR	1	0	IS-M: Sunday
80	CAMPAIGN	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
81	SPART_DRZ	☐	SPARTDRERZ	SPART	CHAR	2	0	Division for publication	TSPA

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_JSBW_RECL_ITEM	AUART	TJAK	AUART	REF	1	CN
2	V_JSBW_RECL_ITEM	BEZUGGRD	TJK87	BEZUGGRD	REF	C	CN
3	V_JSBW_RECL_ITEM	BEZUGSTYP	JDTBEZTYP	BEZTYP	REF	1	CN
4	V_JSBW_RECL_ITEM	DELIVSPLIT	TJD23	DELIVSPLIT	REF	C	CN
5	V_JSBW_RECL_ITEM	DELIVSPLITGRP	TJD63	DELIVSPLITGRP	REF	C	CN
6	V_JSBW_RECL_ITEM	DRERZ	JDTDRER	DRERZ	REF	C	CN
7	V_JSBW_RECL_ITEM	FAKSP	TVFS	FAKSP	REF	C	CN
8	V_JSBW_RECL_ITEM	GPAG	JGTGPNR	GPNR	KEY	1	CN
9	V_JSBW_RECL_ITEM	IVWKNFREI	TJI01	IVWKN	REF	C	CN
10	V_JSBW_RECL_ITEM	KALSM	T683	KALSM	REF	C	CN
11	V_JSBW_RECL_ITEM	KOKRS	TKA01	KOKRS	REF	C	CN
12	V_JSBW_RECL_ITEM	KORRGRD	TJK81	KORRGRD	REF	C	CN
13	V_JSBW_RECL_ITEM	KOSTL_L	CSKS	KOSTL	REF	C	CN
14	V_JSBW_RECL_ITEM	KUENDGRD	TJK83	KUENDGRD	REF	C	CN
15	V_JSBW_RECL_ITEM	KURST	TCURV	KURST	REF	C	CN
16	V_JSBW_RECL_ITEM	LIEFERART	TJV01	LIEFERART	REF	C	CN
17	V_JSBW_RECL_ITEM	MANDT	T000	MANDT	KEY	1	CN
18	V_JSBW_RECL_ITEM	MATKL	T023	MATKL	REF	C	CN
19	V_JSBW_RECL_ITEM	POART	TJAP	POART	REF	1	CN
20	V_JSBW_RECL_ITEM	POSNR_MAIN	JKAP	POSNR	REF	C	CN
21	V_JSBW_RECL_ITEM	POSNR_SUB	JKAP	POSNR	REF	C	CN
22	V_JSBW_RECL_ITEM	POSNR_UR	JKAP	POSNR	REF	1	CN
23	V_JSBW_RECL_ITEM	POSNR_VG	JKAP	POSNR	REF	1	CN
24	V_JSBW_RECL_ITEM	PVA	JDTPVA	PVA	REF	C	CN
25	V_JSBW_RECL_ITEM	REKLERGB	TJK17	REKLERGB	KEY	1	CN
26	V_JSBW_RECL_ITEM	SPART	TVTA	SPART	KEY	1	CN
27	V_JSBW_RECL_ITEM	SPART_DRZ	TSPA	SPART	REF	C	CN
28	V_JSBW_RECL_ITEM	STAFO	TMCB	STAFO	REF	C	CN
29	V_JSBW_RECL_ITEM	STORNOGRD	TJK91	STORNOGRD	REF	C	CN
30	V_JSBW_RECL_ITEM	STWAE	TCURC	WAERS	REF	C	CN
31	V_JSBW_RECL_ITEM	UNTBRGRD	TJK85	UNTBRGRD	REF	C	CN
32	V_JSBW_RECL_ITEM	VKBUR	TVKBZ	VKBUR	REF	C	CN
33	V_JSBW_RECL_ITEM	VKGRP	TVBVK	VKGRP	REF	C	CN
34	V_JSBW_RECL_ITEM	VKORG	TVKO	VKORG	KEY	1	CN
35	V_JSBW_RECL_ITEM	VTWEG	TVKOV	VTWEG	KEY	1	CN
36	V_JSBW_RECL_ITEM	WAERK	TCURC	WAERS	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in