SAP ABAP View V_KNA1ADR1 (Projection View for Importing Cust. Address Data (Conv.))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF (Application Component) Basic Functions
     ⤷ VS (Package) Application development R/3 sales master data

Basic Data

View Type	P	Projection View
Projection View	V_KNA1ADR1
Short Description	Projection View for Importing Cust. Address Data (Conv.)
Root table	KNA1	General Data in Customer Master

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KNA1	KNA1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KNA1	MANDT		☐	MANDT	☐	Client
2	KUNNR	KNA1	KUNNR		☐	KUNNR	☐	Customer Number
3	LAND1	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
4	NAME1	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
5	NAME2	KNA1	NAME2		☐	NAME2_GP	☐	Name 2
6	ORT01	KNA1	ORT01		☐	ORT01_GP	☐	City
7	PSTLZ	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code
8	REGIO	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
9	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
10	STRAS	KNA1	STRAS		☐	STRAS_GP	☐	House number and street
11	TELF1	KNA1	TELF1		☐	TELF1	☐	First telephone number
12	TELFX	KNA1	TELFX		☐	TELFX	☐	Fax Number
13	ADRNR	KNA1	ADRNR		☐	ADRNR	☐	Address
14	MCOD1	KNA1	MCOD1		☐	MCDD1	☐	Search term for matchcode search
15	MCOD2	KNA1	MCOD2		☐	MCDD2	☐	Search Term for Matchcode Search
16	MCOD3	KNA1	MCOD3		☐	MCDD3	☐	Search term for matchcode search
17	ANRED	KNA1	ANRED		☐	ANRED	☐	Title
18	DATLT	KNA1	DATLT		☐	DATLT	☐	Data communication line no.
19	NAME3	KNA1	NAME3		☐	NAME3_GP	☐	Name 3
20	NAME4	KNA1	NAME4		☐	NAME4_GP	☐	Name 4
21	ORT02	KNA1	ORT02		☐	ORT02_GP	☐	District
22	PFACH	KNA1	PFACH		☐	PFACH	☐	PO Box
23	PSTL2	KNA1	PSTL2		☐	PSTL2	☐	P.O. Box Postal Code
24	SPRAS	KNA1	SPRAS		☐	SPRAS	☐	Language Key
25	TELBX	KNA1	TELBX		☐	TELBX	☐	Telebox number
26	TELF2	KNA1	TELF2		☐	TELF2	☐	Second telephone number
27	TELTX	KNA1	TELTX		☐	TELTX	☐	Teletex number
28	TELX1	KNA1	TELX1		☐	TELX1	☐	Telex number
29	LZONE	KNA1	LZONE		☐	LZONE	☐	Transportation zone to or from which the goods are delivered
30	TXJCD	KNA1	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
31	PFORT	KNA1	PFORT		☐	PFORT_GP	☐	PO Box city
32	WERKS	KNA1	WERKS		☐	WERKS_D	☐	Plant
33	DUEFL	KNA1	DUEFL		☐	DUEFL_BKPF	☐	Status of Data Transfer into Subsequent Release
34	KNURL	KNA1	KNURL		☐	URL	☐	Uniform resource locator
35	.APPEND	XKNA1_PSO			☐		☐
36	PSOHS	KNA1	PSOHS		☐	PSOHS	☐	House number: is no longer used from Release 4.6B
37	PSOST	KNA1	PSOST		☐	PSOST	☐	Street: No longer used from Release 4.6B

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140122
SAP Release Created in