SAP ABAP Table V_JSBW_RECL_ADDR (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_JSBW_RECL_ADDR	ADRNR	JGTSADR	ADRNR	REF	C	CN
2	V_JSBW_RECL_ADDR	AUART	TJAK	AUART	REF	1	CN
3	V_JSBW_RECL_ADDR	BANKS	T005	LAND1	REF	C	CN
4	V_JSBW_RECL_ADDR	BEABLST	JRTBEABST	BEABLST	REF	C	CN
5	V_JSBW_RECL_ADDR	BEZIRK	JVTBEZIRK	BEZIRK	REF	C	CN
6	V_JSBW_RECL_ADDR	BEZUGGRD	TJK87	BEZUGGRD	REF	C	CN
7	V_JSBW_RECL_ADDR	DRERZ	JDTDRER	DRERZ	REF	C	CN
8	V_JSBW_RECL_ADDR	GPNR	JGTGPNR	GPNR	KEY	1	CN
9	V_JSBW_RECL_ADDR	JPARVW	TJG39	JPARVW	KEY	1	CN
10	V_JSBW_RECL_ADDR	KUNWE	JGTGPNR	GPNR	REF	C	CN
11	V_JSBW_RECL_ADDR	LAND1	T005	LAND1	REF	C	CN
12	V_JSBW_RECL_ADDR	LANDE	T005	LAND1	REF	C	CN
13	V_JSBW_RECL_ADDR	MANDT	T000	MANDT	KEY	1	CN
14	V_JSBW_RECL_ADDR	POART	TJAP	POART	REF	1	CN
15	V_JSBW_RECL_ADDR	POSNR_MAIN	JKAP	POSNR	REF	C	CN
16	V_JSBW_RECL_ADDR	POSNR_SUB	JKAP	POSNR	REF	C	CN
17	V_JSBW_RECL_ADDR	POSNR_UR	JKAP	POSNR	REF	1	CN
18	V_JSBW_RECL_ADDR	POSNR_VG	JKAP	POSNR	REF	1	CN
19	V_JSBW_RECL_ADDR	PVA	JDTPVA	PVA	REF	C	CN
20	V_JSBW_RECL_ADDR	VERSERVGES	JGTVSG	VERSERVGES	REF	C	CN
21	V_JSBW_RECL_ADDR	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in