P_FlocUserLabel

DDL: P_FLOCUSERLABEL Type: view COMPOSITE Package: ILOM

Functional Location User Defined Label

P_FlocUserLabel is a Composite CDS View that provides data about "Functional Location User Defined Label" in SAP S/4HANA. It reads from 1 data source (I_FunclocationLabelInternal) and exposes 5 fields with key field FunctionalLocation. Part of development package ILOM.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_FunclocationLabelInternal I_FunclocationLabelInternal from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PFLOCUSERLABEL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation FunctionalLocation
FunctionalLocLabelingSyst I_FlocUserProfile FunctionalLocLabelingSyst
FunctionalLocLabelIsActive FunctionalLocLabelIsActive
FunctionalLocationLabelName FunctionalLocationLabelName
FuncnlLocLabelIsPrimaryLabel FuncnlLocLabelIsPrimaryLabel 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog: { sqlViewName: 'PFLOCUSERLABEL', preserveKey }
@AccessControl.authorizationCheck:#NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

// View for active user-specific Alternative Functional Location Labels

//define view P_FlocUserlabel

//  as select from I_FunclocationLabelInternal

//  // Filter out all alternative labels for the current user based on the currently active user profile of the user (if exsiting)

//    inner join   I_FlocUserProfile as _FlocUserProfile on  I_FunclocationLabelInternal.FunctionalLocLabelingSyst = _FlocUserProfile.FunctionalLocLabelingSyst

//                                                       and _FlocUserProfile.CreatedByUser                        = $session.user

//                                                       and _FlocUserProfile.UserProfileForLabelingIsActive       = 'X'

//{

//  key I_FunclocationLabelInternal.FunctionalLocation,

//

//      I_FunclocationLabelInternal.FunctionalLocLabelingSyst,

//

//      I_FunclocationLabelInternal.FunctionalLocLabelIsActive,

//      I_FunclocationLabelInternal.FunctionalLocationLabelName,

//      I_FunclocationLabelInternal.FuncnlLocLabelIsPrimaryLabel

//

//

//}

//where

//      I_FunclocationLabelInternal.FunctionalLocLabelIsActive   = 'X'

//  and I_FunclocationLabelInternal.FuncnlLocLabelIsPrimaryLabel = ''


define view P_FlocUserLabel
  as select from           I_FunclocationLabelInternal
    left outer to one join I_FlocUserProfile on  I_FunclocationLabelInternal.FunctionalLocLabelingSyst = I_FlocUserProfile.FunctionalLocLabelingSyst
                                             and I_FlocUserProfile.CreatedByUser                       = $session.user
                                             and I_FlocUserProfile.UserProfileForLabelingIsActive      = 'X'
{
  key FunctionalLocation,

      I_FlocUserProfile.FunctionalLocLabelingSyst,
      FunctionalLocLabelIsActive,
      FunctionalLocationLabelName,
      FuncnlLocLabelIsPrimaryLabel

}
where
      I_FlocUserProfile.CreatedByUser                          is not null
  and I_FunclocationLabelInternal.FunctionalLocLabelIsActive   = 'X'
  and I_FunclocationLabelInternal.FuncnlLocLabelIsPrimaryLabel = ''

Learn More