P_FunctionalLocationSearch

//Functional Location Anchor View for CDS Search Model

@AbapCatalog.sqlViewName: 'PFLOCSEARCH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_LongText']
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'FunctionalLocation'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_FunctionalLocationSearch
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : abap.lang,
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_FunctionalLocation
  association [0..*] to I_TextObjectPlainLongText   as _LongText            on  $projection.FunctionalLocation = _LongText.TextObjectKey
                                                                            and _LongText.TextObjectCategory   = 'IFLOT'
                                                                            and _LongText.TextObjectType       = 'LTXT'

  association [0..*] to I_ClfnObjectCharcValForKeyDate as _CharValueAssignment on  $projection.FunctionalLocation    = _CharValueAssignment.ClfnObjectID
                                                                            and _CharValueAssignment.ClfnObjectTable = 'IFLOT'

  association [0..*] to I_ClfnObjectClassForKeyDate as _ClassAssignment     on  $projection.FunctionalLocation   = _ClassAssignment.ClfnObjectID
                                                                            and _ClassAssignment.ClfnObjectTable = 'IFLOT'

{

  key FunctionalLocation,
      FuncLocationStructure,
      FunctionalLocationCategory,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      TechnicalObjectType,
      MaintObjectLocAcctAssgmtNmbr,
      ConstructionMaterial,
      CreatedByUser,
      CreationDate,
      LastChangedByUser,
      LastChangeDate,
      AssetManufacturerName,
      ManufacturerPartTypeName,
      MaintenancePlannerGroup,
      MaintenancePlanningPlant,
      CatalogProfile,
      AuthorizationGroup,
      SuperiorFunctionalLocation,
      ManufacturerCountry,
      ConstructionYear,
      ConstructionMonth,
      AcquisitionValue,
      Currency,
      AcquisitionDate,
      MaintObjectInternalID,
      ManufacturerPartNmbr,
      ManufacturerSerialNumber,
      InventoryNumber,
      GrossWeight,
      GrossWeightUnit,
      SizeOrDimensionText,
      OperationStartDate,
      LastChangeDateTime,
      // Propagate association

      _LastChangedByUser,
      _CreatedByUser,
      _FunctionalLocationText,
      _FunctionalLocationCategory,
      _SupFunctionalLocationText,
      _WorkCenterType,
      _WorkCenter,
      _TechnicalObjectType,
      _LocationAccountAssignment,
      _MaintenancePlanningPlant,
      _MaintenancePlannerGroup,
      _ManufacturerCountry,
      _Currency,
      _FunctionalLocationCodeCatalog,
      _FuncLocationStructure,
      _FunctionalLocationLabel,
      _ConstructionMaterial,
      _GrossWeightUnit,
      _LinearAssetManagementData,
      _Status,
      _LongText,
      _ClassAssignment,
      _CharValueAssignment


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FUNCTIONALLOCATION"
],
"ASSOCIATED":
[
"I_CLFNOBJECTCHARCVALFORKEYDATE",
"I_CLFNOBJECTCLASSFORKEYDATE",
"I_COUNTRY",
"I_CURRENCY",
"I_FUNCLOCATIONSTRUCTURE",
"I_FUNCTIONALLOCATIONCATEGORY",
"I_FUNCTIONALLOCATIONLABEL",
"I_FUNCTIONALLOCATIONTEXT",
"I_LINEARASSETMANAGEMENTDATA",
"I_LOCATIONACCOUNTASSIGNMENT",
"I_MAINTENANCEPLANNERGROUP",
"I_MAINTENANCEPLANPLANT",
"I_MATERIAL",
"I_STATUSOBJECTSTATUS",
"I_TECHNICALOBJECTTYPE",
"I_TECHNICALREPORT",
"I_TEXTOBJECTPLAINLONGTEXT",
"I_UNITOFMEASURE",
"I_USER",
"I_WORKCENTER",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_FUNCTIONALLOCATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/