SAP ABAP Table JSBW_SD_RECL_ADDR_COMPL (IS-M/SD: BW Structure for Addresses and Partners)

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

Table Category	INTTAB	Structure
Structure	JSBW_SD_RECL_ADDR_COMPL	Table Relationship Diagram
Short Description	IS-M/SD: BW Structure for Addresses and Partners

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	STORNO_KZ	☐	XSTORNO_KZ	XFELD	CHAR	1	0	IS-M: Reversal BW (0Recordmode)
2	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for Partner Complaints
3	VBELN	☐	AVNR	AVNR	CHAR	10	0	IS-M/SD: Publishing Sales Order	*
4	POSEX	☐	POSEX_ISP	POSEX_ISP	NUMC	6	0	External Item Number (Purchase Order Item)
5	POSNR	☐	APNR	APNR	NUMC	6	0	Sales Order Item	*
6	JPARVW	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	*
7	PARZA	☐	JPARZA	JPARZA	NUMC	3	0	IS-M: Partner Role Counter
8	GUELTIGVON	☐	JKPAVON	DATUM	DATS	8	0	Date from Which Partner Data in Sales Order is Valid
9	GUELTIGBIS	☐	JKPABIS	DATUM	DATS	8	0	Date to Which Partner Data in Sales Order is Valid
10	GPNR	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
11	VERSERVGES	☐	VERSERVGES	GPNR	CHAR	10	0	IS-M: Service Company	*
12	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
13	PARNR	☐	PARNR	PARNR	NUMC	10	0	Number of contact person
14	ADRNR	☐	JADRNR	JADRNR	CHAR	10	0	IS-M: Address Number	*
15	ADRESSVAR	☐	ADRESSVAR	ERSTADR	CHAR	1	0	IS-M: Address Variant
16	HERK	☐	HERK	HERK	CHAR	1	0	IS-M: Use of Address
17	PLZ_ORDER	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
18	XCPDK	☐	XCPDK	XFELD	CHAR	1	0	Indicator: Is the account a one-time account?
19	BEABLST	☐	BEABLST	BEABLST	CHAR	10	0	IS-M: Unloading Point	*
20	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	*
21	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
22	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
23	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
24	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
25	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
26	ZLSCH	☐	JZLSCH	ZLSCH	CHAR	1	0	IS-M: Payment Method	*
27	KREISG_SCH	☐	KGS_ORDER	KREISG_SCH	CHAR	15	0	IS-M: District municipality key of ship-to party	*
28	.INCLUDE	☐				0	0	IS-M/SD: BW Structure for Addresses
29	.INCLUDE	☐				0	0	Created-By Data (Medium Scope)
30	ERFUSER	☐	ERFUSER	USNAM	CHAR	12	0	Created By
31	ERFDATE	☐	ERFDATE	DATUM	DATS	8	0	Created On
32	ERFTIME	☐	ERFTIME	UZEIT	TIMS	6	0	Time Created
33	AENUSER	☐	AENUSER	USNAM	CHAR	12	0	Last Changed By
34	AENDATE	☐	AENDATE	DATUM	DATS	8	0	Date of Last Change
35	AENTIME	☐	AENTIME	UZEIT	TIMS	6	0	Time of Last Change
36	XADRLOE	☐	XLOES	XFELD	CHAR	1	0	IS-M: Deletion Flag for Address
37	ANRED	☐	JANRED	JANRED	CHAR	2	0	IS-M: Form-of-Address Key	*
38	NAME1	☐	NAME1_ISP	NAME	CHAR	35	0	IS-M: Business Partner Name
39	NAME2	☐	NAME2_ISP	NAME	CHAR	35	0	IS-M: First Name of Business Partner
40	NAME3	☐	NAME3_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
41	NAME4	☐	NAME4_ISP	NAME	CHAR	35	0	IS-M: Further Name Field for Business Partner
42	TITEL	☐	TITEL_ISP	TITEL	CHAR	15	0	IS-M: Title	*
43	NAMZU	☐	NAMZU_ISP	TITEL	CHAR	15	0	IS-M: Name Affix	*
44	VORSW	☐	VORSW_ISP	TITEL	CHAR	15	0	IS-M: Name Prefix	*
45	.INCLUDE	☐				0	0	Core address data
46	PSTLZ	☐	PLZ_ISP	PSTLZ	CHAR	10	0	IS-M: Postal Code
47	PSTLZ_ADDON	☐	PSTLZ_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code
48	ORT01	☐	ORT01_ISP	TEXT35	CHAR	35	0	IS-M: City
49	ORT02	☐	ORT02_ISP	TEXT35	CHAR	35	0	IS-M: City District
50	PSTL2	☐	PLZPF	PSTLZ	CHAR	10	0	IS-M: Postal Code for PO Box
51	PSTL2_ADDON	☐	PSTL2_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (PO Box)
52	PSTL3	☐	PSTL3	PSTLZ	CHAR	10	0	IS-M: Company Postal Code
53	PSTL3_ADDON	☐	PSTL3_ADDON	CHAR4	CHAR	4	0	IS-M: Extension to 5-Character ZIP Code (Company)
54	PFACH	☐	PFACH_ISP	PFACH_ISP	CHAR	10	0	IS-M: Post Office Box
55	ORTPF	☐	ORTPF	TEXT35	CHAR	35	0	IS-M: City for PO Box
56	STRAS	☐	STRAS_ISP	TEXT35	CHAR	35	0	IS-M: Street Name
57	HAUSN	☐	HSNMR1	HAUSNUMMER	CHAR	10	0	IS-M: House Number
58	HSNMR2	☐	HSNMR2	CHAR8	CHAR	8	0	IS-M: House Number Affix
59	ADRZUS2	☐	ADRZUS2	ADRZUS	CHAR	6	0	Classification Using a Further Address Affix
60	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
61	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
62	PREDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
63	POSTDIRECTIONAL	☐	DIRECTIONAL	DIRECTIONAL	CHAR	10	0	IS-M: Direction for Street	TJS41
64	ADDRSECABBREV	☐	ADDRSECABBREV	ADDRSECABBREV	CHAR	4	0	IS-M: Secondary Address Text	TJS43
65	ADDRSECNUMBER	☐	ADDRSECNUMBER	ADDRSECNUMBER	CHAR	8	0	IS-M: Secondary Address Number
66	STREET2	☐	STREET2_ISM	TEXT35	CHAR	35	0	IS-M: Second street line
67	.INCLUDE	☐				0	0	Include Structure for Alias (Alias Name)
68	ALIASNAME	☐	ALIASNAME	TEXT50	CHAR	50	0	IS-M: Alias Text (Street Name + Suffix)
69	LOCCO	☐	LOCCO	LOCCO	CHAR	10	0	City Coordinates
70	NIELS	☐	NIELS	NIELS	CHAR	2	0	Nielsen ID	*
71	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
72	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
73	RPMKR	☐	RPMKR	RPMKR	CHAR	5	0	Regional market
74	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
75	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
76	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
77	GPHERK	☐	GPHERK	GPHERK	CHAR	2	0	IS-M: Business Partner Origin	*
78	GP_REF	☐	GPNR	GPNR	CHAR	10	0	IS-M: Business Partner Key	*
79	JPARVW_REF	☐	JPARVW	JPARVW	CHAR	2	0	IS-M: Business Partner Role	*
80	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	JSBW_SD_RECL_ADDR_COMPL	ADDRSECABBREV	TJS43	ADDRSECABBREV	KEY	1	CN
2	JSBW_SD_RECL_ADDR_COMPL	LAND1	T005	LAND1	REF	C	CN
3	JSBW_SD_RECL_ADDR_COMPL	POSTDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN
4	JSBW_SD_RECL_ADDR_COMPL	PREDIRECTIONAL	TJS41	DIRECTIONAL	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	471