SAP ABAP Table SDCUSTVIEW (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure SDCUSTVIEW   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 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
4 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
5 SPART SPART SPART CHAR 2   0   Division TSPA
6 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
7 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
8 MCOD1 MCDD1 CHAR25 CHAR 25   0   Search term for matchcode search  
9 MCOD3 MCDD3 CHAR25 CHAR 25   0   Search term for matchcode search  
10 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
11 NAME NAME1_GP NAME CHAR 35   0   Name 1  
12 STREET AD_STREET TEXT60 CHAR 60   0   Street  
13 STREET_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
14 PCODE PSTLZ PSTLZ CHAR 10   0   Postal Code  
15 CITY ORT01_GP TEXT35 CHAR 35   0   City  
16 COUNTRY LAND1_GP LAND1 CHAR 3   0   Country Key T005
17 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
18 TELF1 TELF1 TEXT16 CHAR 16   0   First telephone number  
19 AUFSDZ AUFSD_X KAUFS CHAR 2   0   Central order block for customer TVAST
20 AUFSDV AUFSD_V KAUFS CHAR 2   0   Customer order block (sales area) TVAST
21 LIFSDZ LIFSD_X LIFSP CHAR 2   0   Central delivery block for the customer TVLS
22 LIFSDV LIFSD_V LIFSP CHAR 2   0   Customer delivery block (sales area) TVLS
23 FAKSDZ FAKSD_X FAKSP CHAR 2   0   Central billing block for customer TVFS
24 FAKSDV FAKSD_V FAKSP CHAR 2   0   Billing block for customer (sales and distribution) TVFS
25 LOEVMZ LOEVM_X XFELD CHAR 1   0   Central Deletion Flag for Master Record  
26 LOEVMV LOEVM_V XFELD CHAR 1   0   Deletion flag for customer (sales level)  
27 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 SDCUSTVIEW AUFSDV TVAST AUFSP REF C CN
2 SDCUSTVIEW AUFSDZ TVAST AUFSP REF C CN
3 SDCUSTVIEW COUNTRY T005 LAND1 REF C CN
4 SDCUSTVIEW FAKSDV TVFS FAKSP REF C CN
5 SDCUSTVIEW FAKSDZ TVFS FAKSP REF C CN
6 SDCUSTVIEW LIFSDV TVLS LIFSP REF C CN
7 SDCUSTVIEW LIFSDZ TVLS LIFSP REF C CN
8 SDCUSTVIEW MANDT T000 MANDT KEY 1 CN
9 SDCUSTVIEW REGION T005S BLAND REF C CN
10 SDCUSTVIEW SPART TSPA SPART KEY 1 CN
11 SDCUSTVIEW VKBUR TVBUR VKBUR REF C CN
12 SDCUSTVIEW VKGRP TVBVK VKGRP REF C CN
13 SDCUSTVIEW VKORG TVKO VKORG KEY 1 CN
14 SDCUSTVIEW VTWEG TVTW VTWEG KEY 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in