SAP ABAP View V_CMS_PAT_BP_SH (Search Patents By BP)
Hierarchy
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   FS-CMS (Application Component) Collateral Management System
     CMS_OMS_RIG_UI (Package) Collateral Management Rights
Basic Data
View Type D Database View 
Database View V_CMS_PAT_BP_SH  
Short Description Search Patents By BP    
Root table CMS_RIG   CMS: Rights table. Includes claims, patents, other rights. 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CMS_RIG CMS_RIG
2 CMS_AST_BP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CMS_RIG MANDT JL EQ 0 0
2 CMS_AST_BP MANDT JR EQ AND 0 0
3 CMS_RIG RIG_GUID JL EQ 0 0
4 CMS_AST_BP AST_GUID JR EQ AND 0 0
5 CMS_RIG RIG_CATEGORY EQ '000006' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT CMS_RIG MANDT   MANDT Client
2 RIG_GUID CMS_RIG RIG_GUID   CMS_DTE_RIG_GUID Rights GUID
3 RIG_CATEGORY CMS_RIG RIG_CATEGORY   CMS_DTE_OMS_OBJ_CAT Object Category
4 RIG_TYP CMS_RIG RIG_TYP   CMS_DTE_RIG_TYP Right Type
5 RIG_ID CMS_RIG RIG_ID   CMS_DTE_RIG_ID Rights ID
6 ADD_DESCR CMS_RIG ADD_DESCR   CMS_DTE_CLM_DESC Additional description of the right
7 AST_BP_GUID CMS_AST_BP AST_BP_GUID   CMS_DTE_AST_BP_GUID GUID for Table CMS_AST_BP
8 BU_PARTNERID CMS_AST_BP BU_PARTNERID   CMS_DTE_BPID Business Partner Identification Number
9 BPF CMS_AST_BP BPF   CMS_DTE_BPF Business Partner Function
10 ADMIN_ORG_UNIT CMS_RIG ADMIN_ORG_UNIT   CMS_DTE_ADMINORG Administration Organizational Unit
                 
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  20110901 
SAP Release Created in 500