SAP ABAP View /CEM/V_IC_BPHIER (Entitlement BP hierarchy assignments)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-EM (Application Component) CRM Entitlement Management
     /CEM/EE_COMMON (Package) Entitlements Engine - Common Objects
Basic Data
View Type D Database View 
Database View /CEM/V_IC_BPHIER  
Short Description Entitlement BP hierarchy assignments    
Root table BUT_HIER_STRUCT   Business Partner Hierarchy Group - Hierarchy Relationship 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 BUT_HIER_STRUCT BUT_HIER_STRUCT
2 BUT_HIER_TREE  
3 BUT_HIER_NODE  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 BUT_HIER_TREE CLIENT JL EQ 0 0
2 BUT_HIER_STRUCT CLIENT JR EQ AND 0 0
3 BUT_HIER_TREE TREE_GUID JL EQ 0 0
4 BUT_HIER_STRUCT TREE_GUID JR EQ AND 0 0
5 BUT_HIER_NODE CLIENT JL EQ 0 0
6 BUT_HIER_STRUCT CLIENT JR EQ AND 0 0
7 BUT_HIER_NODE NODE_GUID JL EQ 0 0
8 BUT_HIER_STRUCT NODE_GUID JR EQ 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 CLIENT BUT_HIER_TREE CLIENT   MANDT Client
2 TREE_GUID BUT_HIER_TREE TREE_GUID   BU_TREE_GUID GUID of Hierarchy Tree
3 TREE_NAME BUT_HIER_TREE SEARCH_TERM   BU_TREE_SEARCH_TERM Hierarchy Tree ID
4 NODE_NAME BUT_HIER_NODE SEARCH_TERM   BU_NODE_SEARCH_TERM Hierarchy Node ID
5 RECORD_GUID BUT_HIER_STRUCT RECORD_GUID   BU_RECORD_GUID GUID of Data Record on Database (ID of Record)
6 NODE_GUID BUT_HIER_STRUCT NODE_GUID   BU_NODE_GUID GUID of Hierarchy Node
7 VALID_TO BUT_HIER_STRUCT VALID_TO   TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8 VALID_FROM BUT_HIER_STRUCT VALID_FROM   TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9 PARENT_GUID BUT_HIER_STRUCT PARENT_GUID   BU_NODE_GUID GUID of Hierarchy Node
                 
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  20130604 
SAP Release Created in 701