SAP ABAP Table JSBW_SD_ORDERTRANS (IS-M/SD: BW Structure (Transaction Affecting Live Subs.))

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_ORDERTRANS	Table Relationship Diagram
Short Description	IS-M/SD: BW Structure (Transaction Affecting Live Subs.)

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	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
2	.INCLU-PRE	☐				0	0	IS-M/SD: BW Struc. (Trans.f.Live Subs.) IN PROCESS
3	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Hdr Data (Trans.f.Live Subs.)
4	VBELNPRE	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
5	AUARTPRE	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	*
6	VKORGPRE	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
7	VTWEGPRE	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
8	SPARTPRE	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
9	VKGRPPRE	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
10	VKBURPRE	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
11	GSBERPRE	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
12	GSKSTPRE	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	*
13	GPAGPRE	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
14	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Item Data (Trans.f.Live Subs.)
15	POSNRPRE	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
16	POARTPRE	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
17	AEART_ITEMPRE	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
18	XNEGOPTIONPRE	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
19	KUNWEPRE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	*
20	LANDEPRE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
21	LAND1PRE	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	*
22	DRERZPRE	☐	DRERZAUFTR	DRERZ	CHAR	8	0	Order Publication	*
23	PVAPRE	☐	PVAAUFTR	PVA	CHAR	8	0	Order-related edition	*
24	BEZUGSTYPPRE	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	*
25	XRUECKABOPRE	☐	XRUECKABO	XFELD	CHAR	1	0	IS-M: Backdated subscription created
26	IVWKNPRE	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
27	IVWKNFREIPRE	☐	IVWKNFREI	IVWKN	CHAR	8	0	Circulation Report Category ID for Non-Calculation Period	*
28	LIEFERARTPRE	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	*
29	BEZUGGRDPRE	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	*
30	UNTBRGRDPRE	☐	UNTBRGRD	UNTBRGRD	CHAR	3	0	Reason for Suspension	*
31	KUENDGRDPRE	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	*
32	XREMRECHTPRE	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
33	XURPOSPRE	☐	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order
34	VKBURZUSPRE	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
35	ERFDATEPRE	☐	ERFDATE	DATUM	DATS	8	0	Created On
36	POSNR_MAINPRE	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	*
37	POSNR_SUBPRE	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	*
38	CAMPAIGNPRE	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
39	.INCLUDE	☐				0	0	IS-M/SD: BW Struc.f.Order Sched.Line Data (Trans.f.Live Sub)
40	ETENRPRE	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	*
41	GUELTIGVONPRE	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
42	GUELTIGBISPRE	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
43	BEZPERPRE	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	*
44	ETARTPRE	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	*
45	AEART_SCHDPRE	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
46	XUREINTPRE	☐	XUREINT	XFELD	CHAR	1	0	Original schedule line in publishing sales order
47	ETMENGEPRE	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
48	UNTMENGEPRE	☐	UNTMENGE	MENGGPOS	QUAN	10	0	IS-M: Suspension quantity
49	PRSPERPRE	☐	PRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	*
50	BZPERFPRE	☐	BEZPERFAKT	BEZPER	CHAR	5	0	IS-M: Service Type for Billing	*
51	XSTORNOPRE	☐	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
52	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Partner Data (Trans.f.LiveSub)
53	GPNR_RGPRE	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	*
54	PLZWEPRE	☐	JMCPLZWE	PSTLZ	CHAR	10	0	Postal code in ship-to party address from order
55	PLZREPRE	☐	JMCPLZRE	PSTLZ	CHAR	10	0	Postal code in bill-to party address from order
56	KREISG_SCHPRE	☐	KGS_ORDER	KREISG_SCH	CHAR	15	0	IS-M: District municipality key of ship-to party	*
57	ZLSCHPRE	☐	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	*
58	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Prom.Data (Trans.f.Live Subs.)
59	WERBEARTPRE	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	*
60	WERBEAKTPRE	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	*
61	WERBTRAEGPRE	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	*
62	GPNRPRVPRE	☐	GPPROV	GPNR	CHAR	10	0	IS-M: Commission Recipient	*
63	VERSERVGESPRE	☐	VSGPROV	GPNR	CHAR	10	0	Service company for commission payee	*
64	XEINMALPRVPRE	☐	XEINMALPRV	XFELD	CHAR	1	0	Indicator: One-time commission
65	XRENDITEPRE	☐	XRENDITE	XFELD	CHAR	1	0	Renewal commission
66	MATNRWERBPRE	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	*
67	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for Order Del.Via.(Trans.f.Live Subs.)
68	BEZIRKPRE	☐	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	*
69	GEOEINPRE	☐	GEOEIN	GEOEIN	CHAR	10	0	Number of Geographical Unit	*
70	XUNVLIEFERPRE	☐	XUNVLIEFER	XFELD	CHAR	1	0	IS-M: Viability Data Incomplete for Item
71	.INCLU-SUC	☐				0	0	IS-M/SD: BW Struc. (Trans.f.Live Subs.) IN PROCESS
72	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Hdr Data (Trans.f.Live Subs.)
73	VBELNSUC	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
74	AUARTSUC	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	*
75	VKORGSUC	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
76	VTWEGSUC	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
77	SPARTSUC	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
78	VKGRPSUC	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
79	VKBURSUC	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
80	GSBERSUC	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
81	GSKSTSUC	☐	GSKST	GSBER	CHAR	4	0	Business area from cost center	*
82	GPAGSUC	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
83	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Item Data (Trans.f.Live Subs.)
84	POSNRSUC	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
85	POARTSUC	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
86	AEART_ITEMSUC	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
87	XNEGOPTIONSUC	☐	XNEGOPTION	XFELD	CHAR	1	0	IS-M: Item with Automatic Transformation to Chargeable
88	KUNWESUC	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	*
89	LANDESUC	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
90	LAND1SUC	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	*
91	DRERZSUC	☐	DRERZAUFTR	DRERZ	CHAR	8	0	Order Publication	*
92	PVASUC	☐	PVAAUFTR	PVA	CHAR	8	0	Order-related edition	*
93	BEZUGSTYPSUC	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	*
94	XRUECKABOSUC	☐	XRUECKABO	XFELD	CHAR	1	0	IS-M: Backdated subscription created
95	IVWKNSUC	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
96	IVWKNFREISUC	☐	IVWKNFREI	IVWKN	CHAR	8	0	Circulation Report Category ID for Non-Calculation Period	*
97	LIEFERARTSUC	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	*
98	BEZUGGRDSUC	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	*
99	UNTBRGRDSUC	☐	UNTBRGRD	UNTBRGRD	CHAR	3	0	Reason for Suspension	*
100	KUENDGRDSUC	☐	KUENDGRD	KUENDGRD	CHAR	3	0	Reason for end of delivery	*
101	XREMRECHTSUC	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
102	XURPOSSUC	☐	XURPOS	XFELD	CHAR	1	0	Original item in publishing sales order
103	VKBURZUSSUC	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
104	ERFDATESUC	☐	ERFDATE	DATUM	DATS	8	0	Created On
105	POSNR_MAINSUC	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	*
106	POSNR_SUBSUC	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	*
107	CAMPAIGNSUC	☐	ISM_MARKETING_CAMPAIGN	ISM_MARKETING_CAMPAIGN	RAW	16	0	IS-M: Marketing Campaign
108	.INCLUDE	☐				0	0	IS-M/SD: BW Struc.f.Order Sched.Line Data (Trans.f.Live Sub)
109	ETENRSUC	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	*
110	GUELTIGVONSUC	☐	GUELTIGVON	DATUM	DATS	8	0	Valid-From Date
111	GUELTIGBISSUC	☐	GUELTIGBIS	DATUM	DATS	8	0	Valid-To Date
112	BEZPERSUC	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	*
113	ETARTSUC	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	*
114	AEART_SCHDSUC	☐	AEART_JSDK	AEART_JSDK	CHAR	1	0	Order Change Type
115	XUREINTSUC	☐	XUREINT	XFELD	CHAR	1	0	Original schedule line in publishing sales order
116	ETMENGESUC	☐	ETMENGE	MENGGPOS	QUAN	10	0	IS-M: Sales Order Schedule Line Quantity
117	UNTMENGESUC	☐	UNTMENGE	MENGGPOS	QUAN	10	0	IS-M: Suspension quantity
118	PRSPERSUC	☐	PRSPER	PRSPER	CHAR	2	0	IS-M: Price Frequency	*
119	BZPERFSUC	☐	BEZPERFAKT	BEZPER	CHAR	5	0	IS-M: Service Type for Billing	*
120	XSTORNOSUC	☐	XJSTORNO	XFELD	CHAR	1	0	Indicator: Reversed
121	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Partner Data (Trans.f.LiveSub)
122	GPNR_RGSUC	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	*
123	PLZWESUC	☐	JMCPLZWE	PSTLZ	CHAR	10	0	Postal code in ship-to party address from order
124	PLZRESUC	☐	JMCPLZRE	PSTLZ	CHAR	10	0	Postal code in bill-to party address from order
125	KREISG_SCHSUC	☐	KGS_ORDER	KREISG_SCH	CHAR	15	0	IS-M: District municipality key of ship-to party	*
126	ZLSCHSUC	☐	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	*
127	.INCLUDE	☐				0	0	IS-M/SD: BW Structure f.Order Prom.Data (Trans.f.Live Subs.)
128	WERBEARTSUC	☐	WERBEART	WERBEART	CHAR	4	0	Sales Source	*
129	WERBEAKTSUC	☐	WERBEAKT	WERBEAKT	CHAR	8	0	Sales Promotion	*
130	WERBTRAEGSUC	☐	WERBTRAEG	WERBTRAEG	CHAR	10	0	Advertising Medium	*
131	GPNRPRVSUC	☐	GPPROV	GPNR	CHAR	10	0	IS-M: Commission Recipient	*
132	VERSERVGESSUC	☐	VSGPROV	GPNR	CHAR	10	0	Service company for commission payee	*
133	XEINMALPRVSUC	☐	XEINMALPRV	XFELD	CHAR	1	0	Indicator: One-time commission
134	XRENDITESUC	☐	XRENDITE	XFELD	CHAR	1	0	Renewal commission
135	MATNRWERBSUC	☐	MATNR_SAPR	MATNR_ISP	CHAR	18	0	IS-M: Material number for gift	*
136	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for Order Del.Via.(Trans.f.Live Subs.)
137	BEZIRKSUC	☐	BEZIRK	BEZIRK	CHAR	10	0	Carrier Route	*
138	GEOEINSUC	☐	GEOEIN	GEOEIN	CHAR	10	0	Number of Geographical Unit	*
139	XUNVLIEFERSUC	☐	XUNVLIEFER	XFELD	CHAR	1	0	IS-M: Viability Data Incomplete for Item
140	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*

History

Last changed by/on	SAP	20110901
SAP Release Created in