SAP ABAP Table J_7LSADR (Address Management: Company Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ IS-REA-COR (Application Component) Recycling Administration Core Functions
     ⤷ J7LR (Package) REA Core Functionality

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_7LSADR	Table Relationship Diagram
Short Description	Address Management: Company Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	☑	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
3	NATIO	☑	INTER	NATION	CHAR	1	0	International address version ID	*
4	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
5	NAME1	☐	NAME1_BAS	NAME	CHAR	35	0	Name 1
6	NAME2	☐	NAME2_BAS	NAME	CHAR	35	0	Name 2
7	NAME3	☐	NAME3_BAS	NAME	CHAR	35	0	Name 3
8	NAME4	☐	NAME4_BAS	NAME	CHAR	35	0	Name 4
9	PSTLZ	☐	PSTLZ_BAS	PSTLZ	CHAR	10	0	Postal code
10	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
11	ORT02	☐	ORT02_BAS	TEXT35	CHAR	35	0	District
12	PSTL2	☐	PSTL2_BAS	PSTLZ	CHAR	10	0	PO Box postal code
13	PFACH	☐	PFACH_BAS	PFACH	CHAR	10	0	PO box
14	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
15	STRS2	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
16	HAUSN	☐	HAUSN_BAS	CHAR6	CHAR	6	0	House number
17	STOCK	☐	STOCK	STOCK	CHAR	6	0	Floor
18	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
19	SORTL	☐	SORTL_BAS	CHAR10	CHAR	10	0	Sort field
20	SORT2	☐	SORT20	CHAR20	CHAR	20	0	Sort field
21	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
22	LZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
23	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
24	PSTBZ	☐	PSTBZ	PSTBZ	CHAR	15	0	Post delivery district
25	TELF1	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
26	FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
27	TELFX	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
28	FLAG2	☐	XFELD	XFELD	CHAR	1	0	Checkbox
29	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
30	FLAG3	☐	XFELD	XFELD	CHAR	1	0	Checkbox
31	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
32	FLAG4	☐	XFELD	XFELD	CHAR	1	0	Checkbox
33	MAIAD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
34	MAILN	☐	OBJ_NAM	DOC_NAM	CHAR	12	0	Addresses: Document name
35	STDKO	☐	STDKO_D	CHAR1	CHAR	1	0	Default communications service
36	STDCOM	☐	COM_ART	COM_ART	CHAR	3	0	Addresses: Communication type
37	DBNAME	☐	SYM_DST	CHAR10	CHAR	10	0	Addresses: System ID
38	KLASSE	☐	SO_KLASSE	KLASSE	CHAR	18	0	Addresses: class assigned to an address
39	ANREK	☐	ANREK	ANREK	CHAR	2	0	Addresses: Form of address key
40	CRNAM	☐	CR_NAM	USERNAME	CHAR	12	0	Addresses: Created by
41	CRDAT	☐	CR_DAT	DATUM	DATS	8	0	Addresses: Creation date
42	CRTIM	☐	CR_TIM	UZEIT	TIMS	6	0	Addresses: Creation time
43	CHNAM	☐	CH_NAM	USERNAME	CHAR	12	0	Addresses: Changed by
44	CHDAT	☐	CH_DAT	DATUM	DATS	8	0	Addresses: Change date
45	CHTIM	☐	CH_TIM	UZEIT	TIMS	6	0	Addresses: Changed at
46	DUEFL	☐	DUEFL_BAS	DUEFL_BAS	CHAR	1	0	Status of data transfer into subsequent release
47	TXJCD	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
48	PFORT	☐	PFORT_ADRS	TEXT40	CHAR	40	0	PO Box city
49	TZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	TTZZ

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_7LSADR	LAND1	T005	LAND1	REF	1	CN
2	J_7LSADR	LZONE	TZONE	ZONE1	REF	1	CN
3	J_7LSADR	MANDT	T000	MANDT	KEY	1	CN
4	J_7LSADR	REGIO	T005S	BLAND	REF	1	CN
5	J_7LSADR	SPRAS	T002	SPRAS	REF	1	CN
6	J_7LSADR	TZONE	TTZZ	TZONE	REF	1	CN

History

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