SAP ABAP Table CVDSADRL (EHS: Address Management: Company Data)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ EHS-SAF (Application Component) Product Safety
     ⤷ CVDD (Package) EH&S: Report Shipping

Basic Data

Table Category	INTTAB	Structure
Structure	CVDSADRL	Table Relationship Diagram
Short Description	EHS: Address Management: Company Data

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in