SAP ABAP View V_JSBW_POS_ADDR (IS-M/SD: BW View for Reading Address Data in Subs. Order)

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_ADDR
Short Description	IS-M/SD: BW View for Reading Address Data in Subs. Order
Root table	JKAK	Sales Order Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JKAK	JKAK
2	JKAP
3	JKPA

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	JKPA	MANDT	JL	EQ				0	0
6	JKAK	MANDT	JR	EQ			AND	0	0
7	JKPA	VBELN	JL	EQ				0	0
8	JKAP	VBELN	JR	EQ			AND	0	0
9	JKPA	POSNR	JL	EQ				0	0
10	JKAP	POSNR	JR	EQ			AND	0	0
11	JKAK	VBTYP		EQ	'C'		AND	0	0
12	JKAK	TRVOG		EQ	'0'		AND	0	0
13	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	VBELN	JKAK	VBELN		☐	AVNR	☐	IS-M/SD: Publishing Sales Order
3	VBTYP	JKAK	VBTYP		☐	VBTYP_ISP	☐	Sales document category, IS-M
4	TRVOG	JKAK	TRVOG		☐	TRVOG_ISP	☐	Transaction Group for IS-M Order Processing
5	AUART	JKAK	AUART		☐	AUART_ISP	☐	IS-M/SD: Sales Document Types
6	AUARTGRP	JKAK	AUARTGRP		☐	JAUARTGRP	☐	IS-M/SD: Sales document type grouping
7	POSNR	JKAP	POSNR		☐	APNR	☐	Sales Order Item
8	POART	JKAP	POART		☐	POART_ISP	☐	Internal Item Type for Sales Order
9	AEART	JKAP	AEART		☐	AEART_JSDK	☐	Order Change Type
10	ZSKLS	JKAP	ZSKLS		☐	JZSKLS	☐	Time slice classification for sales order
11	POSEX	JKAP	POSEX		☐	POSEX_ISP	☐	External Item Number (Purchase Order Item)
12	KUNWE	JKAP	KUNWE		☐	GPNR_WE	☐	IS-M: Business Partner Ship-to Party
13	LANDE	JKAP	LANDE		☐	LANDE_ISP	☐	Current country being supplied
14	LAND1	JKAP	LAND1		☐	LAND1_ISP	☐	Normal delivery country
15	DRERZ	JKAP	DRERZ		☐	DRERZ	☐	Publication
16	PVA	JKAP	PVA		☐	PVA	☐	Edition
17	BEZUGGRD	JKAP	BEZUGGRD		☐	BEZUGGRD	☐	Purchase Reason
18	XURPOS	JKAP	XURPOS		☐	XURPOS	☐	Original item in publishing sales order
19	POSNR_UR	JKAP	POSNR_UR		☐	APNR_UR	☐	Original Item in Publishing Sales Order
20	POSNR_VG	JKAP	POSNR_VG		☐	APNR_VG	☐	Preceding Item in Publishing Sales Order
21	POSNR_VL	JKAP	POSNR_VL		☐	APNR_VL	☐	Reference Document Item
22	BEZIRK	JKAP	BEZIRK		☐	BEZIRK	☐	Carrier Route
23	POSNR_MAIN	JKAP	POSNR_MAIN		☐	APNR_MAIN	☐	IS-M/SD: Main Item in Sales Order
24	POSNR_SUB	JKAP	POSNR_SUB		☐	APNR_SUB	☐	IS-M/SD: Sub-Item in Sales Order
25	JPARVW	JKPA	JPARVW		☐	JPARVW	☐	IS-M: Business Partner Role
26	PARZA	JKPA	PARZA		☐	JPARZA	☐	IS-M: Partner Role Counter
27	GUELTIGVON	JKPA	GUELTIGVON		☐	JKPAVON	☐	Date from Which Partner Data in Sales Order is Valid
28	GUELTIGBIS	JKPA	GUELTIGBIS		☐	JKPABIS	☐	Date to Which Partner Data in Sales Order is Valid
29	GPNR	JKPA	GPNR		☐	GPNR	☐	IS-M: Business Partner Key
30	VERSERVGES	JKPA	VERSERVGES		☐	VERSERVGES	☐	IS-M: Service Company
31	PERNR	JKPA	PERNR		☐	PERNR_D	☐	Personnel Number
32	PARNR	JKPA	PARNR		☐	PARNR	☐	Number of contact person
33	ADRNR	JKPA	ADRNR		☐	JADRNR	☐	IS-M: Address Number
34	ADRESSVAR	JKPA	ADRESSVAR		☐	ADRESSVAR	☐	IS-M: Address Variant
35	HERK	JKPA	HERK		☐	HERK	☐	IS-M: Use of Address
36	PLZ_ORDER	JKPA	PLZ_ORDER		☐	PLZ_ISP	☐	IS-M: Postal Code
37	XCPDK	JKPA	XCPDK		☐	XCPDK	☐	Indicator: Is the account a one-time account?
38	BEABLST	JKPA	BEABLST		☐	BEABLST	☐	IS-M: Unloading Point
39	BANKS	JKPA	BANKS		☐	BANKS	☐	Bank country key
40	BANKL	JKPA	BANKL		☐	BANKK	☐	Bank Keys
41	BANKN	JKPA	BANKN		☐	BANKN	☐	Bank account number
42	BKONT	JKPA	BKONT		☐	BKONT	☐	Bank Control Key
43	BVTYP	JKPA	BVTYP		☐	BVTYP	☐	Partner bank type
44	XEZER	JKPA	XEZER		☐	XEZER	☐	Indicator: Is there collection authorization ?
45	ZLSCH	JKPA	ZLSCH		☐	JZLSCH	☐	IS-M: Payment Method
46	KREISG_SCH	JKPA	KREISG_SCH		☐	KGS_ORDER	☐	IS-M: District municipality key of ship-to party

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