I_GteeMMyGrantMasterBasic

DDL: I_GTEEMMYGRANTMASTERBASIC SQL: IGMAGRMASTRBASIC Type: view BASIC

Grantee Management My Grant Master Basic

I_GteeMMyGrantMasterBasic is a Basic CDS View that provides data about "Grantee Management My Grant Master Basic" in SAP S/4HANA. It reads from 4 data sources (t001, gmgr, fpb_persparm, fpb_persparm) and exposes 2 fields with key field GrantID.

4 data source(s) 2 fields

Data Sources (4)

SourceAliasJoin Type
t001 CC inner
gmgr MD from
fpb_persparm p1 left_outer
fpb_persparm p2 left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGMAGRMASTRBASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Grantee Management My Grant Master Basic view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY GrantID gmgr grant_nbr
CompanyCodeCurrency 
@AbapCatalog.sqlViewName: 'IGMAGRMASTRBASIC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Grantee Management My Grant Master Basic'

@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.usageType.dataClass: #TRANSACTIONAL    
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL

define view I_GteeMMyGrantMasterBasic

 as select from gmgr as MD

    inner join t001 as CC on  CC.bukrs = MD.company_code
                      
//     Personalization (FPB application), for Grant Type and Sponsor selection:                          

    left outer join   fpb_persparm    as p1  on  p1.perskeytp       = 'U'
                                             and p1.perskey         = $session.user
                                             and p1.applid          = 'GM-MY_GRANTS'
                                             and p1.fieldname       = 'GRANT_TYPE'
                                             and p1.pers_subcontext = ''
                                             and p1.noauth          = ' '
                                             and p1.sel_sign        = 'I'
                                             and p1.fieldtype       = 'V'
                                             and p1.sel_option      = 'EQ'

    left outer join   fpb_persparm    as p2  on  p2.perskeytp       = 'U'
                                             and p2.perskey         = $session.user
                                             and p2.applid          = 'GM-MY_GRANTS'
                                             and p2.fieldname       = 'SPONSOR'
                                             and p2.pers_subcontext = ''
                                             and p2.noauth          = ' '
                                             and p2.sel_sign        = 'I'
                                             and p2.fieldtype       = 'V'
                                             and p2.sel_option      = 'EQ'                                                                                                                                    
                                             
 {                   

      key MD.grant_nbr as GrantID,
      
      cast(CC.waers as gm_comp_code_currency preserving type )                             as  CompanyCodeCurrency
}

where
      (
      p1.low        is null or
      p1.low        = '*' or
      MD.grant_type = p1.low
      )
  and (
      p2.low     is null or 
      p2.low     = '*' or
      MD.partner = p2.low
      )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FPB_PERSPARM",
"GMGR",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More