SAP ABAP Table JSBW_SD_DELIVERY_2 (IS-M/SD: BW Structure for 0ME_ISM_SD_DELIVERY_2)

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_DELIVERY_2	Table Relationship Diagram
Short Description	IS-M/SD: BW Structure for 0ME_ISM_SD_DELIVERY_2

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	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for "Pure" Delivery Data
2	LFNGNR	☐	LFNGNR	LFNGNR	NUMC	12	0	IS-M: Sequence Number for Delivery	*
3	NACHLFNGNR	☐	NACHLFNGNR	NUM2	NUMC	2	0	Sequence number of subsequent delivery
4	LFNGART	☐	LFNGART	LFNGART	CHAR	1	0	Type of Delivery
5	BEZUGSTYP	☐	BEZUGSTYP_JE_PVA	BEZUGSTYP_JE_PVA	CHAR	2	0	Mix Type	JDTBEZTYP
6	DRERZTAT	☐	DRERZTAT	DRERZ	CHAR	8	0	Actual Publication Delivered	*
7	PVATAT	☐	PVATAT	PVA	CHAR	8	0	Actual edition delivered	*
8	BEZIRKTAT	☐	BEZIRKTAT	BEZIRK	CHAR	10	0	Actual Carrier Route	*
9	BEZRUNDTAT	☐	BEZRUNDTAT	BEZRUNDE	CHAR	10	0	Actual Delivery Round	*
10	GEOEINTAT	☐	GEOEINTAT	GEOEIN	CHAR	10	0	Actual Geographical Unit	*
11	LFARTTAT	☐	LFARTTAT	LIEFERART	CHAR	2	0	Actual delivery type (usually DT for dist.viability set)	*
12	MBZART	☐	MITBEZART	MITBEZART	NUMC	1	0	Combination type of edition combined in mix type definition
13	KNDGRUPPE	☐	KNDGRUPPE	KDGRP	CHAR	2	0	IS-M: Customer Group	*
14	AUARTGRP	☐	JAUARTGRP	JAUARTGRP	CHAR	1	0	IS-M/SD: Sales document type grouping
15	ERSCHDAT	☐	ERSCHDAT	DATUM	DATS	8	0	Publication Date
16	VERSANDDAT	☐	VRSNDDATUM	DATUM	DATS	8	0	IS-M: Shipping Date
17	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
18	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
19	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
20	DRUCKEREI	☐	JWERK	WERKS	CHAR	4	0	Plant	*
21	LFARTLOG	☐	LFARTLOG	LIEFERART	CHAR	2	0	Logistical delivery type	*
22	LFMENGE	☐	LIEFRMENG2	LIEFRMENG2	QUAN	9	0	Delivery quantity of edition
23	ETMEINS	☐	ETMEINS	MEINS	UNIT	3	0	IS-M: Sales Unit for Sales Order	*
24	.INCLUDE	☐				0	0	IS-M/SD: BW Structure Additional Delivery Data
25	ZUSTELLER	☐	JZUSTELLER	GPNR	CHAR	10	0	IS-M: Carrier	*
26	VSGZUSTLR	☐	VSGZUSTLR	GPNR	CHAR	10	0	IS-M/SD: Service Company to Which Carrier Belongs	*
27	.INCLUDE	☐				0	0	IS-M/SD: BW Structure Order Header Data for Delivery
28	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
29	AUART	☐	AUART_ISP	AUART_ISP	CHAR	4	0	IS-M/SD: Sales Document Types	*
30	SPART	☐	SPART_AK	SPART	CHAR	2	0	Division for order header	*
31	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
32	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
33	GPAG	☐	GPAG	GPNR	CHAR	10	0	Business Partner: Sold-to Party	*
34	.INCLUDE	☐				0	0	IS-M/SD: BW Structure Order Item Data for Delivery
35	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
36	POART	☐	POART_ISP	POART_ISP	CHAR	2	0	Internal Item Type for Sales Order	*
37	KUNWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	*
38	LANDE	☐	LANDE_ISP	LAND1	CHAR	3	0	Current country being supplied	*
39	LAND1	☐	LAND1_ISP	LAND1	CHAR	3	0	Normal delivery country	*
40	DRERZ	☐	DRERZAUFTR	DRERZ	CHAR	8	0	Order Publication	*
41	PVA	☐	PVAAUFTR	PVA	CHAR	8	0	Order-related edition	*
42	IVWKN	☐	IVWKN	IVWKN	CHAR	8	0	Circulation Audit Report Category ID	*
43	LIEFERART	☐	LIEFERART	LIEFERART	CHAR	2	0	Delivery Type	*
44	BEZUGGRD	☐	BEZUGGRD	BEZUGGRD	CHAR	3	0	Purchase Reason	*
45	XREMRECHT	☐	XREMRECHT	XFELD	CHAR	1	0	IS-M: Right of Return
46	VKBURZUS	☐	VKBURZUS	VKBUR	CHAR	4	0	Sales office responsible	*
47	POSNR_MAIN	☐	APNR_MAIN	APNR	NUMC	6	0	IS-M/SD: Main Item in Sales Order	*
48	POSNR_SUB	☐	APNR_SUB	APNR	NUMC	6	0	IS-M/SD: Sub-Item in Sales Order	*
49	VAUSGB	☐	VAUSGB	VAUSGB	CHAR	10	0	Issue	*
50	.INCLUDE	☐				0	0	IS-M/SD: BW Structure Order Schedule Line Data for Delivery
51	ETENR	☐	JAENR	AENR	NUMC	4	0	Sales Order Schedule Line	*
52	BEZPER	☐	BEZPER	BEZPER	CHAR	5	0	Service Type	*
53	ETART	☐	ETART_ISP	ETART_ISP	CHAR	2	0	Schedule Line Type for Internal Sales Order Schedule Line	*
54	REMMG_PLAN	☐	REMMG_PLAN	MENGGPOS	QUAN	10	0	Expected returns
55	REMME_PLAN	☐	REMME_PLAN	MEINS	UNIT	3	0	IS-M: Unit of measure of expected returns	*
56	.INCLUDE	☐				0	0	IS-M/SD: BW Structure (Other) Order Data for Delivery
57	GPNR_RG	☐	GPNR_RG	GPNR	CHAR	10	0	IS-M: Payer Business Partner	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JSBW_SD_DELIVERY_2	BEZUGSTYP	JDTBEZTYP	BEZTYP

History

Last changed by/on	SAP	20110901
SAP Release Created in