SAP ABAP View SMOLSTMTM (Master Data View Listed Products)
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 SMOLSTMTM  
Short Description Master Data View Listed Products    
Root table SMOCCALIPO   Customer/Comp. listing (position) 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SMOCCALIPO SMOCCALIPO
2 SMOCCALIKO  
3 SMOKNA1  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SMOCCALIKO SFACCALIKO JL EQ 0 0
2 SMOCCALIPO SFACCALIKO JR EQ AND 0 0
3 SMOCCALIKO MANDT JL EQ 0 0
4 SMOCCALIPO MANDT JR EQ AND 0 0
5 SMOKNA1 SFAKNA1 JL EQ 0 0
6 SMOCCALIKO SFAKNA1 JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT SMOCCALIKO MANDT   MANDT Client
2 SFACCALIKO SMOCCALIKO SFACCALIKO   SMO_SFLIKO SFA Key of Listing Header
3 SFAKNA1 SMOCCALIKO SFAKNA1   SMO_SFAKN1 SFA Key of Business Partner
4 DATAB SMOCCALIKO DATAB   SMO3DATAB Valid-from date
5 DATBI SMOCCALIKO DATBI   SMO3DATBI Valid to date
6 VKORG SMOCCALIKO VKORG   SMO3VKORG Sales organization
7 VTWEG SMOCCALIKO VTWEG   SMO3VTWEG Distribution channel
8 SPART SMOCCALIKO SPART   SMO3SPART Division
9 LLABEL SMOCCALIKO LLABEL   SMO_LLABEL Listing Label
10 LTYPE SMOCCALIKO LISTTYPE   SMO_LISTYP Listing Type
11 SFACCALIPO SMOCCALIPO SFACCALIPO   SMO_SFLIPO SFA Key of Listing Item
12 LIPREI SMOCCALIPO LIPREI   SMO_LIPREI Listed price
13 WAERS SMOCCALIPO WAERS   SMO3WAERS Currency key
14 MATNER SMOCCALIPO MATNR   SMO3MATNR Material number
15 KUNNR SMOKNA1 KUNNR   SMO3KUNNR Customer number
                 
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