SAP ABAP Table LOCATION_I (City: Identification)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VTR (Package) SD R/3 transport processing

Basic Data

Table Category	INTTAB	Structure
Structure	LOCATION_I	Table Relationship Diagram
Short Description	City: Identification

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	KNOTE	☐	L_KNOTE	KNOTN	CHAR	10	0	Location: Points	TVKN
2	VSTEL	☐	L_VSTEL	VSTEL	CHAR	4	0	Location: Shipping point	TVST
3	LSTEL	☐	L_LSTEL	LSTEL	CHAR	2	0	Location: Loading point at shipping point	TVLA
4	KUNNR	☐	L_KUNNR	KUNNR	CHAR	10	0	Location: Customer	KNA1
5	KUNABL	☐	L_KUNABL	TEXT25	CHAR	25	0	Location: Customer's unloading point	KNVA
6	LIFNR	☐	L_LIFNR	LIFNR	CHAR	10	0	Location: Vendor	LFA1
7	WERKS	☐	L_WERK	WERKS	CHAR	4	0	Location: Plant	T001W
8	LGORT	☐	L_LGORT	LGORT	CHAR	4	0	Location: Storage location in plant	T001L
9	LGNUM	☐	L_LGNUM	LGNUM	CHAR	3	0	Location: Warehouse number	T300
10	TOR	☐	L_LGTOR	LGTOR	CHAR	3	0	Location: Door for warehouse number	T30B
11	BELAD	☐	L_BEABLAD	TEXT25	CHAR	25	0	Loaction: Additional information (e.g. load./unload.point)
12	.INCLUDE	☐				0	0	City: Address data that are used for identification
13	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
14	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
15	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
16	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
17	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
18	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
19	STREETCODE	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	*
20	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
21	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
22	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
23	TRANSPZONE	☐	AD_TRNSPZN	ZONE	CHAR	10	0	Transportation zone	*
24	CITY_CODE	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
25	CITYP_CODE	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
26	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	LOCATION_I	KNOTE	TVKN	KNOTE
2	LOCATION_I	KUNABL	KNVA	ABLAD
3	LOCATION_I	KUNNR	KNA1	KUNNR
4	LOCATION_I	LGNUM	T300	LGNUM
5	LOCATION_I	LGORT	T001L	LGORT
6	LOCATION_I	LIFNR	LFA1	LIFNR
7	LOCATION_I	LSTEL	TVLA	LSTEL
8	LOCATION_I	TOR	T30B	LGTOR
9	LOCATION_I	VSTEL	TVST	VSTEL
10	LOCATION_I	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in