SAP ABAP Table JKVWBZADR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	JKVWBZADR	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	ADRNR	☑	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number
3	VBELN	☑	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	JKAK
4	POSNR	☑	APNR	APNR	NUMC	6	0	Sales Order Item
5	JPARVW	☑	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	TJG39
6	PARZA	☑	JPARZA	JPARZA	NUMC	3	0	IS-M: Partner Role Counter
7	GUELTIGVON	☑	JKPAVON	DATUM	DATS	8	0	Date from Which Partner Data in Sales Order is Valid
8	POS_GUEVON	☐	JKAPVON	DATUM	DATS	8	0	Valid-From Date of Sales Order Item
9	POS_GUEBIS	☐	JKAPBIS	DATUM	DATS	8	0	Date to which Sales Order Item is Valid
10	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
11	ADRESSVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
12	ABONR	☐	REMELD_ISP	CHAR20	CHAR	20	0	IS-M/SD: Reference Document in Legacy System
13	WBZKUNNR	☐	JWBZKUNNR	JWBZKUNNR	CHAR	6	0	IS-M: WBZ, VDZ Number of WBZ Company
14	VERTRKENNZ	☐	JWBZVKENNZ	JWBZVKENNZ	CHAR	5	0	IS-M: WBZ, VDZ Sales Code (Num. Share Postal Sales Code)
15	WERBKZSCHL	☐	JWBZWKZSCH	JWBZWKZSCH	CHAR	1	0	IS-M: WBZ, Promotion Rebate Key	TJKW9
16	KUNWE	☐	GPNR_WE	GPNR	CHAR	10	0	IS-M: Business Partner Ship-to Party	JGTGPNR
17	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	TJG43
18	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
19	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
20	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
21	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
22	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	T535N
23	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	T535N
24	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	T535N
25	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
26	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
27	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
28	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
29	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
30	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
31	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
32	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
33	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
34	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
35	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
36	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
37	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
38	NAME1_MACO	☐	NAME1_ISPM	NAME_MACO	CHAR	35	0	IS-M: Business Partner Name (Upper Case for Matchcode)
39	STRAS_MACO	☐	STRAS_ISPM	STRAS_MACO	CHAR	35	0	IS-M: Street Name
40	ORT01_MACO	☐	ORT01_ISPM	ORT01_MACO	CHAR	35	0	IS-M/SD: City Name (Upper Case for Matchcode)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	JKVWBZADR	ANRED	TJG43	JANRED	REF	C	CN
2	JKVWBZADR	JPARVW	TJG39	JPARVW	KEY	1	CN
3	JKVWBZADR	KUNWE	JGTGPNR	GPNR	REF	C	CN
4	JKVWBZADR	LAND1	T005	LAND1	REF	C	CN
5	JKVWBZADR	MANDT	T000	MANDT	KEY	1	CN
6	JKVWBZADR	NAMZU	T535N	TITEL
7	JKVWBZADR	TITEL	T535N	TITEL
8	JKVWBZADR	VBELN	JKAK	VBELN	KEY	1	CN
9	JKVWBZADR	VORSW	T535N	TITEL
10	JKVWBZADR	WERBKZSCHL	TJKW9	WERBKZSCHL		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in