SAP ABAP View SMOPRSPCTM (master Data View Prospect)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-ANA-EXT (Application Component) Extraction Technology
     SMOX_MAP (Package) Mapping objects from BW adapter
Basic Data
View Type D Database View 
Database View SMOPRSPCTM  
Short Description master Data View Prospect    
Root table SMOKNA1   General Data in Customer Master 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SMOKNA1 SMOKNA1
2 SMOADRC  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SMOKNA1 MANDT JL EQ 0 0
2 SMOADRC MANDT JR EQ AND 0 0
3 SMOKNA1 SFAKNA1 JL EQ 0 0
4 SMOADRC SFAKNA1 JR EQ AND 0 0
5 SMOKNA1 KUNNR EQ ' ' AND 0 0
6 SMOADRC ADRCDFLT EQ 'S' AND 0 0
7 SMOKNA1 SOURCE EQ 'CAP' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT SMOKNA1 MANDT   MANDT Client
2 KTOKD SMOKNA1 KTOKD   SMO3KTOKD Customer account group
3 KEYACC SMOKNA1 KEYACC   SMO_KEYACC Business Partner is Key Account (T/F)
4 BRYTH SMOKNA1 BRYTH   SMO3BRYTH Call frequency
5 KVOUTYP SMOKNA1 KVOUTYP   SMO_OUTYP Outlet Type
6 KVMARKT SMOKNA1 KVMARKT   SMO_MARKET Market of Partner
7 SFAKNA1 SMOKNA1 SFAKNA1   SMO_SFAKN1 SFA Key of Business Partner
8 COUNTRY SMOADRC COUNTRY   LAND1 Country Key
9 REGION SMOADRC REGION   REGIO Region (State, Province, County)
10 BRSCH SMOKNA1 BRSCH   SMO3BRSCH Industry key
11 NIELS SMOKNA1 NIELS   SMO3NIELS Nielsen indicator
12 KUKLA SMOKNA1 KUKLA   SMO3KUKLA Customer classification
13 BRAN1 SMOKNA1 BRAN1   SMO3BRAN1 Industry code 1
14 BRAN2 SMOKNA1 BRAN2   SMO3BRAN2 Industry code 2
15 BRAN3 SMOKNA1 BRAN3   SMO3BRAN3 Industry code 3
16 BRAN4 SMOKNA1 BRAN4   SMO3BRAN4 Industry code 4
17 BRAN5 SMOKNA1 BRAN5   SMO3BRAN5 Industry code 5
18 COUNC SMOADRC COUNC   SMO3COUNC County code
19 WERKS SMOKNA1 WERKS   SMO3WERKS Plant
20 LOEVM SMOKNA1 LOEVM   SMO3LOEVM2 Central deletion flag for master record
21 CITY1 SMOADRC CITY1   AD_CITY1 City
22 POST_CODE1 SMOADRC POST_CODE1   AD_PSTCD1 City postal code
23 NAME1 SMOKNA1 NAME1   AD_NAME1 Name 1
                 
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  20140117 
SAP Release Created in