SAP ABAP Table CMDT_ADR_S (Generic Master Record: Address - Data and Update Information)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KBAS (Package) Overhead Cost Controlling

Basic Data

Table Category	INTTAB	Structure
Structure	CMDT_ADR_S	Table Relationship Diagram
Short Description	Generic Master Record: Address - Data and Update Information

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	Generic Master Record: Address
2	.INCLUDE	☐				0	0	Generic Master Record - Key Fields
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	CMDT
5	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
6	STATUS	☐	CMDT_STATUS	CMDT_STATUS	CHAR	1	0	Activation Status of Generic Master Record
7	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
8	.INCLUDE	☐				0	0	Generic Master Record: Address
9	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
10	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
11	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
12	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
13	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
14	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
15	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
16	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
17	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
18	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
19	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
20	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
21	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
22	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
23	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
24	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
25	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
26	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
27	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
28	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
29	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
30	DRNAM	☐	KDNAM	DRNAM	CHAR	4	0	Printer destination for CCtr report
31	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
32	DBACTION	☐	DB_ACTION	CHAR1	CHAR	1	0	Action on database

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMDT_ADR_S	LAND1	T005	LAND1	REF	C	CN
2	CMDT_ADR_S	MANDT	T000	MANDT		1	CN
3	CMDT_ADR_S	OBJNR	CMDT	MANDT	KEY
4	CMDT_ADR_S	REGIO	T005S	BLAND	REF	C	CN
5	CMDT_ADR_S	SPRAS	T002	SPRAS	REF	1	N
6	CMDT_ADR_S	TXJCD	TTXJ	TXJCD

History

Last changed by/on	SAP	20130529
SAP Release Created in