SAP ABAP View SDCUSTVIEW1 (Customer Master Data: General with Address Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_PORTAL (Package) ERP Sales Portal Roles

Basic Data

View Type	D	Database View
Database View	SDCUSTVIEW1
Short Description	Customer Master Data: General with Address Data
Root table	KNA1	General Data in Customer Master

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ADRC	CLIENT	JL	EQ				0	0
2	KNA1	MANDT	JR	EQ			AND	0	0
3	ADRC	ADDRNUMBER	JL	EQ				0	0
4	KNA1	ADRNR	JR	EQ				0	0

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	MCOD1	KNA1	MCOD1		☐	MCDD1	☐	Search term for matchcode search
4	MCOD3	KNA1	MCOD3		☐	MCDD3	☐	Search term for matchcode search
5	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
6	NAME	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
7	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
8	STREET_NO	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
9	PCODE	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code
10	CITY	KNA1	ORT01		☐	ORT01_GP	☐	City
11	COUNTRY	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
12	REGION	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
13	TELF1	KNA1	TELF1		☐	TELF1	☐	First telephone number
14	AUFSDZ	KNA1	AUFSD		☐	AUFSD_X	☐	Central order block for customer
15	LIFSDZ	KNA1	LIFSD		☐	LIFSD_X	☐	Central delivery block for the customer
16	FAKSDZ	KNA1	FAKSD		☐	FAKSD_X	☐	Central billing block for customer
17	LOEVMZ	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
18	NODEL	KNA1	NODEL		☐	NODEL_X	☐	Central deletion block for master record

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	20140121
SAP Release Created in	500