SAP ABAP Table CC_DB_VIEW (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CC_DB_VIEW   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  
2 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
3 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document  
4 TXZ01 TXZ01 TEXT40 CHAR 40   0   Short Text  
5 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
6 KTMNG KTMNG MENGE QUAN 13   3   Target Quantity  
7 KTWRT KTWRT WERT15 CURR 15   2   Target Value for Header Area per Distribution  
8 MENGE BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
9 MEINS BSTME MEINS UNIT 3   0   Order unit T006
10 NETPR BPREI WERT11 CURR 11   2   Net Price in Purchasing Document (in Document Currency)  
11 PEINH EPEIN DEC5 DEC 5   0   Price unit  
12 SRM_CONTRACT_ID SRM_CONTRACT_ID BBP_BAPI_EBELN CHAR 10   0   Central Contract  
13 SRM_CONTRACT_ITM SRM_CONTRACT_ITEM BBP_ITEMNO NUMC 10   0   Central Contract Item Number  
14 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
15 BSTYP EBSTYP EBSTYP CHAR 1   0   Purchasing Document Category  
16 STATU ESTAK ESTAK CHAR 1   0   Status of Purchasing Document  
17 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
18 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
19 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
20 EKORG EKORG EKORG CHAR 4   0   Purchasing organization T024E
21 EKGRP BKGRP EKGRP CHAR 3   0   Purchasing Group T024
22 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
23 WKURS WKURS KURSP DEC 9   5   Exchange Rate  
24 KDATB KDATB DATUM DATS 8   0   Start of Validity Period  
25 KDATE KDATE DATUM DATS 8   0   End of Validity Period  
26 HIERARCHY_EXISTS HIERARCHY_EXISTS XFELD CHAR 1   0   Part of a Contract Hierarchy  
27 THRESHOLD_EXISTS EX_RATE_THRESHOLD XFELD CHAR 1   0   Threshold Value for Exchange Rates Exists  
28 LEGAL_CONTRACT LEGAL_CONTRACT_ID CHAR040 CHAR 40   0   Legal Contract Number  
29 DESCRIPTION CONTRACT_DESCRIPTION TEXT40 CHAR 40   0   Contract Name  
30 AEDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
31 RELEASE_DATE RELEASE_DATE DATUM DATS 8   0   Release Date of Contract  
32 WERKS EWERK WERKS CHAR 4   0   Plant T001W
33 LOEKZ ELOEK ELOEK CHAR 1   0   Deletion indicator in purchasing document  
34 PSTYP PSTYP PSTYP CHAR 1   0   Item category in purchasing document T163
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CC_DB_VIEW BUKRS T001 BUKRS REF 1 N
2 CC_DB_VIEW EBELN EKKO EBELN KEY 1 N
3 CC_DB_VIEW EKGRP T024 EKGRP REF 1 N
4 CC_DB_VIEW EKORG T024E EKORG REF 1 N
5 CC_DB_VIEW LIFNR LFA1 LIFNR REF 1 N
6 CC_DB_VIEW MATNR MARA MATNR REF 1 N
7 CC_DB_VIEW MEINS T006 MSEHI REF 1 N
8 CC_DB_VIEW PSTYP T163 PSTYP REF 1 N
9 CC_DB_VIEW WAERS TCURC WAERS REF 1 N
10 CC_DB_VIEW WERKS T001W WERKS REF 1 N
History
Last changed by/on SAP  20140121 
SAP Release Created in