SAP ABAP Table JVVVSPADRAV (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JVVVSPADRAV   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 BUNDNR BUND BUND CHAR 12   0   Bundle JVTBUND
3 SHIPORDNBR SHIPORDNBR SHIPORDNBR CHAR 10   0   Address-Based Shipping Order Number JVSOH
4 SHIPORDPOSNBR SHIPORDPOSNBR SHIPORDPOSNBR NUMC 8   0   Address-Based Shipping Order Item Number JVSOP
5 ADRNR JADRNR JADRNR CHAR 10   0   IS-M: Address Number JGTSADR
6 ADRESSVAR ADRESSVAR ERSTADR CHAR 1   0   IS-M: Address Variant  
7 UVADR_ST UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
8 UVADR_PF UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
9 UVADR_GK UVADR_AD UVADR_AD CHAR 1   0   IS-M: Coding Status of Address  
10 AUART AUART_ISP AUART_ISP CHAR 4   0   IS-M/SD: Sales Document Types TJAK
11 ANRED JANRED JANRED CHAR 2   0   IS-M: Form-of-Address Key TJG43
12 NAME1 NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
13 NAME2 NAME2_ISP NAME CHAR 35   0   IS-M: First Name of Business Partner  
14 NAME3 NAME3_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
15 NAME4 NAME4_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
16 TITEL TITEL_ISP TITEL CHAR 15   0   IS-M: Title T535N
17 NAMZU NAMZU_ISP TITEL CHAR 15   0   IS-M: Name Affix T535N
18 VORSW VORSW_ISP TITEL CHAR 15   0   IS-M: Name Prefix T535N
19 PSTLZ PLZ_ISP PSTLZ CHAR 10   0   IS-M: Postal Code  
20 ORT01 ORT01_ISP TEXT35 CHAR 35   0   IS-M: City  
21 ORT02 ORT02_ISP TEXT35 CHAR 35   0   IS-M: City District  
22 PSTL2 PLZPF PSTLZ CHAR 10   0   IS-M: Postal Code for PO Box  
23 PSTL3 PSTL3 PSTLZ CHAR 10   0   IS-M: Company Postal Code  
24 PFACH PFACH_ISP PFACH_ISP CHAR 10   0   IS-M: Post Office Box  
25 ORTPF ORTPF TEXT35 CHAR 35   0   IS-M: City for PO Box  
26 STRAS STRAS_ISP TEXT35 CHAR 35   0   IS-M: Street Name  
27 HAUSN HSNMR1 HAUSNUMMER CHAR 10   0   IS-M: House Number  
28 HSNMR2 HSNMR2 CHAR8 CHAR 8   0   IS-M: House Number Affix  
29 ADRZUS2 ADRZUS2 ADRZUS CHAR 6   0   Classification Using a Further Address Affix  
30 STOCK STOCK STOCK CHAR 6   0   Floor  
31 POSTEINORT JALORT ALORT CHAR 8   0   IS-M: City Number (Unique) JSTORTPRO
32 POSTEINSTR STRASSENNR STRASSENNR CHAR 10   0   IS-M: Street Number JSTSTRPRO
33 PEINORTPF ALORT2 ALORT CHAR 8   0   IS-M: Postal Unit of City for PO Box JSTORTPRO
34 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
35 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
36 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
37 COUNC COUNC COUNC CHAR 3   0   County Code T005E
38 CITYC CITYC CITYC CHAR 4   0   City Code T005G
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JVVVSPADRAV ADRNR JGTSADR ADRNR KEY 1 CN
2 JVVVSPADRAV ANRED TJG43 JANRED REF C CN
3 JVVVSPADRAV AUART TJAK AUART KEY 1 CN
4 JVVVSPADRAV BUNDNR JVTBUND BUNDNR KEY 1 CN
5 JVVVSPADRAV CITYC T005G CITYC REF C CN
6 JVVVSPADRAV COUNC T005E COUNC REF C CN
7 JVVVSPADRAV LAND1 T005 LAND1 REF C CN
8 JVVVSPADRAV MANDT T000 MANDT KEY 1 CN
9 JVVVSPADRAV NAMZU T535N TITEL    
10 JVVVSPADRAV PEINORTPF JSTORTPRO ALORT REF C CN
11 JVVVSPADRAV POSTEINORT JSTORTPRO ALORT REF C CN
12 JVVVSPADRAV POSTEINSTR JSTSTRPRO STRASSENNR REF C CN
13 JVVVSPADRAV REGIO T005S BLAND REF C CN
14 JVVVSPADRAV SHIPORDNBR JVSOH ORDNBR KEY 1 CN
15 JVVVSPADRAV SHIPORDPOSNBR JVSOP POSNBR KEY 1 CN
16 JVVVSPADRAV SPRAS T002 SPRAS REF C CN
17 JVVVSPADRAV TITEL T535N TITEL    
18 JVVVSPADRAV VORSW T535N TITEL    
History
Last changed by/on SAP  20130529 
SAP Release Created in