P_FunctionalLocationSearch

DDL: P_FUNCTIONALLOCATIONSEARCH Type: view_entity BASIC Package: BSESH_PM

Functional Location Anchor View for CDS Search Model

P_FunctionalLocationSearch is a Basic CDS View that provides data about "Functional Location Anchor View for CDS Search Model" in SAP S/4HANA. It reads from 1 data source (I_FunctionalLocation) and exposes 57 fields with key field FunctionalLocation. It has 3 associations to related views. Part of development package BSESH_PM.

1 data source(s) 57 fields

Data Sources (1)

SourceAliasJoin Type
I_FunctionalLocation I_FunctionalLocation from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _LongText $projection.FunctionalLocation = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'IFLOT' and _LongText.TextObjectType = 'LTXT'
[0..*] I_ClfnObjectCharcValForKeyDate _CharValueAssignment $projection.FunctionalLocation = _CharValueAssignment.ClfnObjectID and _CharValueAssignment.ClfnObjectTable = 'IFLOT'
[0..*] I_ClfnObjectClassForKeyDate _ClassAssignment $projection.FunctionalLocation = _ClassAssignment.ClfnObjectID and _ClassAssignment.ClfnObjectTable = 'IFLOT'

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.representativeKey FunctionalLocation view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation FunctionalLocation
FuncLocationStructure FuncLocationStructure
FunctionalLocationCategory FunctionalLocationCategory
WorkCenterInternalID WorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
TechnicalObjectType TechnicalObjectType
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr
ConstructionMaterial ConstructionMaterial
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
AssetManufacturerName AssetManufacturerName
ManufacturerPartTypeName ManufacturerPartTypeName
MaintenancePlannerGroup MaintenancePlannerGroup
MaintenancePlanningPlant MaintenancePlanningPlant
CatalogProfile CatalogProfile
AuthorizationGroup AuthorizationGroup
SuperiorFunctionalLocation SuperiorFunctionalLocation
ManufacturerCountry ManufacturerCountry
ConstructionYear ConstructionYear
ConstructionMonth ConstructionMonth
AcquisitionValue AcquisitionValue
Currency Currency
AcquisitionDate AcquisitionDate
MaintObjectInternalID MaintObjectInternalID
ManufacturerPartNmbr ManufacturerPartNmbr
ManufacturerSerialNumber ManufacturerSerialNumber
InventoryNumber InventoryNumber
GrossWeight GrossWeight
GrossWeightUnit GrossWeightUnit
SizeOrDimensionText SizeOrDimensionText
OperationStartDate OperationStartDate
LastChangeDateTime LastChangeDateTime
_LastChangedByUser _LastChangedByUser
_CreatedByUser _CreatedByUser
_FunctionalLocationText _FunctionalLocationText
_FunctionalLocationCategory _FunctionalLocationCategory
_SupFunctionalLocationText _SupFunctionalLocationText
_WorkCenterType _WorkCenterType
_WorkCenter _WorkCenter
_TechnicalObjectType _TechnicalObjectType
_LocationAccountAssignment _LocationAccountAssignment
_MaintenancePlanningPlant _MaintenancePlanningPlant
_MaintenancePlannerGroup _MaintenancePlannerGroup
_ManufacturerCountry _ManufacturerCountry
_Currency _Currency
_FunctionalLocationCodeCatalog _FunctionalLocationCodeCatalog
_FuncLocationStructure _FuncLocationStructure
_FunctionalLocationLabel _FunctionalLocationLabel
_ConstructionMaterial _ConstructionMaterial
_GrossWeightUnit _GrossWeightUnit
_LinearAssetManagementData _LinearAssetManagementData
_Status _Status
_LongText _LongText
_ClassAssignment _ClassAssignment
_CharValueAssignment _CharValueAssignment 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_LongText']
@VDM.private: true
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'FunctionalLocation'
//@Analytics.technicalName: 'PFLOCSEARCH'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
define view entity P_FunctionalLocationSearch
  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,
      @Semantics.amount.currencyCode: 'CURRENCY' 
AcquisitionValue,
      Currency,
      AcquisitionDate,
      MaintObjectInternalID,
      ManufacturerPartNmbr,
      ManufacturerSerialNumber,
      InventoryNumber,
      @Semantics.quantity.unitOfMeasure: 'GROSSWEIGHTUNIT' 
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


}

Learn More