SAP ABAP Table CMDT_ADR (Generic Master Record: Address)

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	TRANSP	Transparent table
Transparent table	CMDT_ADR	Table Relationship Diagram
Short Description	Generic Master Record: Address

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in