SAP ABAP View V_CMS_AST_BP_SH (Asset-Business Partner)
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_AST_BP_SH  
Short Description Asset-Business Partner    
Root table CMS_AST   Asset Details 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 CMS_AST CMS_AST
2 CMS_AST_BP  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 CMS_AST MANDT JL EQ 0 0
2 CMS_AST_BP MANDT JR EQ AND 0 0
3 CMS_AST AST_GUID JL EQ 0 0
4 CMS_AST_BP AST_GUID JR EQ AND 0 0
5 CMS_AST AST_ID NE ' ' AND 0 0
6 CMS_AST AST_TYP NE ' ' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT CMS_AST MANDT   MANDT Client
2 AST_GUID CMS_AST AST_GUID   CMS_DTE_AST_GUID GUID for Table CMS_AST
3 AST_BP_GUID CMS_AST_BP AST_BP_GUID   CMS_DTE_AST_BP_GUID GUID for Table CMS_AST_BP
4 BU_PARTNERID CMS_AST_BP BU_PARTNERID   CMS_DTE_BPID Business Partner Identification Number
5 AST_ID CMS_AST AST_ID   CMS_DTE_AST_ID Asset ID
6 AST_TYP CMS_AST AST_TYP   CMS_DTE_AST_TYP Asset Type
7 BPF CMS_AST_BP BPF   CMS_DTE_BPF Business Partner Function
8 SUBAST_ID CMS_AST SUBAST_ID   CMS_DTE_SAS_ID Sub-asset ID
9 SUBAST_TYP CMS_AST SUBAST_TYP   CMS_DTE_SAS_TYP Sub-asset Type
10 DESCRIPTION CMS_AST DESCRIPTION   CMS_DTE_AST_DESC Description
11 OBJECT_REF_ID CMS_AST OBJECT_REF_ID   CMS_DTE_OBJ_REFID Reference ID for the object
12 OBJECT_TYP CMS_AST OBJECT_TYP   CMS_DTE_OBJ_TYP Not used
                 
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 110