SAP ABAP Table MCESTA_ADDR (IS-U Sales Statistics: Transfer Struc. - Conn. Obj. Address)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-IS-ST (Application Component) Statistics
     ⤷ EE70 (Package) IS-U: Statistics

Basic Data

Table Category	INTTAB	Structure
Structure	MCESTA_ADDR	Table Relationship Diagram
Short Description	IS-U Sales Statistics: Transfer Struc. - Conn. Obj. Address

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	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
2	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
3	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
4	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
5	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
6	REGPOLIT	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	TE227
7	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
8	.INCLUDE	☐				0	0	Cust.-Defined Data from Address
9	DUMMYFIELD	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
10	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCESTA_ADDR	CITYP_CODE	ADRCITYPRT	CITYP_CODE
2	MCESTA_ADDR	CITY_CODE	ADRCITY	CITY_CODE
3	MCESTA_ADDR	COUNTRY	T005	LAND1
4	MCESTA_ADDR	REGIOGROUP	ADRREGGRP	REGIOGROUP
5	MCESTA_ADDR	REGION	T005S	BLAND
6	MCESTA_ADDR	REGPOLIT	TE227	REGPOLIT
7	MCESTA_ADDR	STREETCODE	ADRSTREET	STRT_CODE

History

Last changed by/on	SAP	20130529
SAP Release Created in