P_FlocPrimaryLabel

DDL: P_FLOCPRIMARYLABEL Type: view COMPOSITE

P_FlocPrimaryLabel is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_FunclocationLabelInternal) and exposes 5 fields with key field FunctionalLocation.

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 PFLOCPRLABEL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

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

@ClientHandling.algorithm: #SESSION_VARIABLE 


// View for Primary Functional Location Labels

define view P_FlocPrimaryLabel as select from I_FunclocationLabelInternal{

    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 = 'X'          
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCLOCATIONLABELINTERNAL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More