SAP ABAP View JVVSOP_ADR (IS-M/SD Shipping Order Item with Address Data)

Hierarchy

☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JSD (Package) Appl. dev. R/3 Publishing Sales and Distribution System

Basic Data

View Type	D	Database View
Database View	JVVSOP_ADR
Short Description	IS-M/SD Shipping Order Item with Address Data
Root table	JVSOP	IS-M/SD Shipping Order Item

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JVSOP	JVSOP
2	JGTSADR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JVSOP	CLIENT	JL	EQ				0	0
2	JGTSADR	MANDT	JR	EQ			AND	0	0
3	JVSOP	ADDRESS	JL	EQ				0	0
4	JGTSADR	ADRNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	JVSOP	CLIENT		☐	MANDT	☐	Client
2	ORDNBR	JVSOP	ORDNBR		☐	SHIPORDNBR	☐	Address-Based Shipping Order Number
3	POSNBR	JVSOP	POSNBR		☐	SHIPORDPOSNBR	☐	Address-Based Shipping Order Item Number
4	VALIDFROM	JVSOP	VALIDFROM		☐	GUELTIGVON	☐	Valid-From Date
5	VALIDTO	JVSOP	VALIDTO		☐	GUELTIGBIS	☐	Valid-To Date
6	QUANTITY	JVSOP	QUANTITY		☐	JVQUANTITY	☐	Quantity for Shipping Order Item
7	UNIT	JVSOP	UNIT		☐	MEINLIEF	☐	Unit of Measure for Delivery Quantity
8	ADDRESS	JVSOP	ADDRESS		☐	JADRNR	☐	IS-M: Address Number
9	ADDRESS_VARIANT	JVSOP	ADDRESS_VARIANT		☐	ADRESSVAR	☐	IS-M: Address Variant
10	POST_CODE	JVSOP	POST_CODE		☐	PLZ_ISP	☐	IS-M: Postal Code
11	INCOMPLETE	JVSOP	INCOMPLETE		☐	XUNVLIEFER	☐	IS-M: Viability Data Incomplete for Item
12	COUNTRY	JGTSADR	LAND1		☐	LAND1	☐	Country Key
13	CITY_NBR	JGTSADR	POSTEINORT		☐	JALORT	☐	IS-M: City Number (Unique)
14	STREET_NBR	JGTSADR	POSTEINSTR		☐	STRASSENNR	☐	IS-M: Street Number
15	POBOX_NBR	JGTSADR	PEINORTPF		☐	ALORT2	☐	IS-M: Postal Unit of City for PO Box
16	STREET_CODED	JGTSADR	UVADR_ST		☐	UVADR_AD	☐	IS-M: Coding Status of Address
17	POBOX_CODED	JGTSADR	UVADR_PF		☐	UVADR_AD	☐	IS-M: Coding Status of Address
18	MAJCUS_CODED	JGTSADR	UVADR_GK		☐	UVADR_AD	☐	IS-M: Coding Status of Address

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	20130529
SAP Release Created in