SAP ABAP View V_CMS_PRDCLS_SH (View for Product Class Search Help (CMS))
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CMS-MD (Application Component) Master Data
     CMS_CORE (Package) Collateral Management System
Basic Data
View Type D Database View 
Database View V_CMS_PRDCLS_SH  
Short Description View for Product Class Search Help (CMS)    
Root table TCMS_PRD   Product description 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TCMS_PRD TCMS_PRD
2 TCMS_RBL_CRDSYS  
3 TCMS_RBL_CRDSY_T  
4 TCMS_PRD_T  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 TCMS_RBL_CRDSYS CRDSYS JL EQ 0 0
2 TCMS_PRD CREDITSYSTEM JR EQ AND 0 0
3 TCMS_RBL_CRDSYS CRDSYS JL EQ 0 0
4 TCMS_RBL_CRDSY_T CRDSYS JR EQ AND 0 0
5 TCMS_PRD MANDT JL EQ 0 0
6 TCMS_PRD_T MANDT JR EQ AND 0 0
7 TCMS_PRD PRD_CLASS JL EQ 0 0
8 TCMS_PRD_T PRD_CLASS JR EQ AND 0 0
9 TCMS_RBL_CRDSY_T LANGUAGE JL EQ 0 0
10 TCMS_PRD_T LANGUAGE JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT TCMS_PRD MANDT   MANDT Client
2 PRD_CLASS TCMS_PRD PRD_CLASS   CMS_DTE_PRD_CLASS Product Class
3 LANGUAGE TCMS_PRD_T LANGUAGE   CMS_DTE_LNG_KEY Language in which Description is Required
4 NAME TCMS_PRD_T NAME   CMS_DTE_PRD_NAME Product Name in a Specified Language
5 CREDITSYSTEM TCMS_PRD CREDITSYSTEM   CMS_DTE_RBL_CRDSYS Credit System
6 TEXT TCMS_RBL_CRDSY_T TEXT   CMS_DTE_RBL_CRDSYSTXT Credit System Text
                 
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  20040116 
SAP Release Created in 200