SAP ABAP Table BW_HC_NADR (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BW_HC_NADR	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	☑	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number
3	ADROB	☑	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
4	PSTLZ	☐	ISH_PSTLZO	PSTLZ	CHAR	10	0	IS-H: Postal Code of City
5	LAND	☐	ISH_LAND	LAND1	CHAR	3	0	IS-H: Country	T005
6	REGIO	☐	ISH_REGION	REGIO	CHAR	3	0	IS-H: Region (Federal State, Province, County)	T005S
7	ORT	☐	ISH_CITY1	TEXT40	CHAR	40	0	IS-H: City
8	ORT2	☐	ISH_CITY2	TEXT40	CHAR	40	0	IS-H: District
9	STRAS	☐	ISH_STRASS	TEXT40	CHAR	40	0	IS-H: Street
10	STRAZ	☐	ISH_STRASZ	TEXT40	CHAR	40	0	IS-H: Other Designation Qualifying the Address
11	EINZG	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
12	PSTLP	☐	ISH_PSTLZP	PSTLZ	CHAR	10	0	IS-H: Postal Code of P.O. Box
13	PFACH	☐	ISH_POBOX	ISH_PFACH	CHAR	10	0	IS-H: Post Office Box
14	LANPF	☐	ISH_LANDPB	LAND1	CHAR	3	0	IS-H: Country of Post Office Box	T005
15	ORTPF	☐	ISH_CITYPB	TEXT40	CHAR	40	0	IS-H: PO Box City
16	PSTLF	☐	ISH_PSTLZF	PSTLZ	CHAR	10	0	IS-H: Postal Code of Company (for Major Accounts)
17	TELNR	☐	ISH_TELNR	CHAR30	CHAR	30	0	IS-H: Telephone Number
18	TELXT	☐	ISH_TELEXT	CHAR10	CHAR	10	0	Telephone Number - Extension
19	FAXNR	☐	ISH_FAXNR	CHAR30	CHAR	30	0	Fax Number
20	FAXXT	☐	ISH_FAXEXT	CHAR10	CHAR	10	0	IS-H: Fax Number - Extension
21	TEXNR	☐	ISH_TELETX	TEXT30	CHAR	30	0	IS-H: Telex Number
22	BUILD	☐	ISH_BUILD	TEXT10	CHAR	10	0	IS-H: Block/House
23	FLOOR	☐	ISH_FLOOR	TEXT10	CHAR	10	0	IS-H: Block/House Level
24	ROOM	☐	ISH_ROOM	TEXT10	CHAR	10	0	IS-H: Unit Number
25	STORT	☐	ISH_STCITY	CHAR40	CHAR	40	0	Standardized City Name
26	STOTT	☐	ISH_STCIT2	CHAR40	CHAR	40	0	Standardized District
27	STSTR	☐	ISH_STSTR	CHAR40	CHAR	40	0	Standardized Street
28	STSTZ	☐	ISH_STSTRZ	CHAR40	CHAR	40	0	IS-H: Standardized Street Supplement
29	STORP	☐	ISH_STCITP	CHAR40	CHAR	40	0	Standardized City Name of P.O. Box
30	TELKZ	☐	ISH_WTELKZ	XFELD	CHAR	1	0	IS-H: Indicator that More Tel. Nos. Exist for Address
31	EMAIL	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BW_HC_NADR	LAND	T005	LAND1		1	CN
2	BW_HC_NADR	LANPF	T005	LAND1		1	CN
3	BW_HC_NADR	MANDT	T000	MANDT		1	CN
4	BW_HC_NADR	REGIO	T005S	BLAND		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in