SAP ABAP View SDCUSTVIEW (Customer Master Data: SD Area and 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	SDCUSTVIEW
Short Description	Customer Master Data: SD Area and Address Data
Root table	KNA1	General Data in Customer Master

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KNVV	MANDT	JL	EQ				0	0
2	KNA1	MANDT	JR	EQ			AND	0	0
3	KNVV	KUNNR	JL	EQ				0	0
4	KNA1	KUNNR	JR	EQ			AND	0	0
5	ADRC	CLIENT	JL	EQ				0	0
6	KNA1	MANDT	JR	EQ			AND	0	0
7	ADRC	ADDRNUMBER	JL	EQ				0	0
8	KNA1	ADRNR	JR	EQ			AND	0	0
9	ADRC	NATION		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	VKORG	KNVV	VKORG		☐	VKORG	☐	Sales Organization
4	VTWEG	KNVV	VTWEG		☐	VTWEG	☐	Distribution Channel
5	SPART	KNVV	SPART		☐	SPART	☐	Division
6	VKBUR	KNVV	VKBUR		☐	VKBUR	☐	Sales office
7	VKGRP	KNVV	VKGRP		☐	VKGRP	☐	Sales group
8	MCOD1	KNA1	MCOD1		☐	MCDD1	☐	Search term for matchcode search
9	MCOD3	KNA1	MCOD3		☐	MCDD3	☐	Search term for matchcode search
10	SORTL	KNA1	SORTL		☐	SORTL	☐	Sort field
11	NAME	KNA1	NAME1		☐	NAME1_GP	☐	Name 1
12	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
13	STREET_NO	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
14	PCODE	KNA1	PSTLZ		☐	PSTLZ	☐	Postal Code
15	CITY	KNA1	ORT01		☐	ORT01_GP	☐	City
16	COUNTRY	KNA1	LAND1		☐	LAND1_GP	☐	Country Key
17	REGION	KNA1	REGIO		☐	REGIO	☐	Region (State, Province, County)
18	TELF1	KNA1	TELF1		☐	TELF1	☐	First telephone number
19	AUFSDZ	KNA1	AUFSD		☐	AUFSD_X	☐	Central order block for customer
20	AUFSDV	KNVV	AUFSD		☐	AUFSD_V	☐	Customer order block (sales area)
21	LIFSDZ	KNA1	LIFSD		☐	LIFSD_X	☐	Central delivery block for the customer
22	LIFSDV	KNVV	LIFSD		☐	LIFSD_V	☐	Customer delivery block (sales area)
23	FAKSDZ	KNA1	FAKSD		☐	FAKSD_X	☐	Central billing block for customer
24	FAKSDV	KNVV	FAKSD		☐	FAKSD_V	☐	Billing block for customer (sales and distribution)
25	LOEVMZ	KNA1	LOEVM		☐	LOEVM_X	☐	Central Deletion Flag for Master Record
26	LOEVMV	KNVV	LOEVM		☐	LOEVM_V	☐	Deletion flag for customer (sales level)
27	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