SAP ABAP Table SDCUSTVIEW1 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SDCUSTVIEW1	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number
3	MCOD1	☑	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
4	MCOD3	☑	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
5	SORTL	☑	SORTL	CHAR10	CHAR	10	0	Sort field
6	NAME	☑	NAME1_GP	NAME	CHAR	35	0	Name 1
7	STREET	☑	AD_STREET	TEXT60	CHAR	60	0	Street
8	STREET_NO	☑	AD_HSNM1	TEXT10	CHAR	10	0	House Number
9	PCODE	☑	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
10	CITY	☑	ORT01_GP	TEXT35	CHAR	35	0	City
11	COUNTRY	☑	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
12	REGION	☑	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
13	TELF1	☑	TELF1	TEXT16	CHAR	16	0	First telephone number
14	AUFSDZ	☑	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
15	LIFSDZ	☑	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
16	FAKSDZ	☑	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
17	LOEVMZ	☑	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
18	NODEL	☑	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SDCUSTVIEW1	AUFSDZ	TVAST	AUFSP	REF	C	CN
2	SDCUSTVIEW1	COUNTRY	T005	LAND1	REF	C	CN
3	SDCUSTVIEW1	FAKSDZ	TVFS	FAKSP	REF	C	CN
4	SDCUSTVIEW1	LIFSDZ	TVLS	LIFSP	REF	C	CN
5	SDCUSTVIEW1	MANDT	T000	MANDT	KEY	1	CN
6	SDCUSTVIEW1	REGION	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in