P_FunctionalLocationSearch

DDL: P_FUNCTIONALLOCATIONSEARCH SQL: PFLOCSEARCH Type: view BASIC
57 Fields 1 Data Sources 3 Associations

P_FunctionalLocationSearch is a Basic CDS View 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.

Data Sources (1)

SourceAliasJoin Type
I_FunctionalLocation I_FunctionalLocation from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KeyDate sydate

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 (10)

NameValueLevelField
AbapCatalog.sqlViewName PFLOCSEARCH view
AbapCatalog.compiler.compareFilter true view
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
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY FunctionalLocation FunctionalLocation Object ID
FuncLocationStructure FuncLocationStructure Unused Field Length 3
FunctionalLocationCategory FunctionalLocationCategory FunctLocCat.
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterTypeCode WorkCenterTypeCode Object Type
TechnicalObjectType TechnicalObjectType Text object
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
ConstructionMaterial ConstructionMaterial ConstType
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartTypeName ManufacturerPartTypeName Model number
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
CatalogProfile CatalogProfile Catalog Profile
AuthorizationGroup AuthorizationGroup AuthorizGroup
SuperiorFunctionalLocation SuperiorFunctionalLocation Object ID
ManufacturerCountry ManufacturerCountry Mnf. Cntry/Regn
ConstructionYear ConstructionYear ConstructYear
ConstructionMonth ConstructionMonth ConstructMth
AcquisitionValue AcquisitionValue AcquistnValue
Currency Currency Valuation Crcy
AcquisitionDate AcquisitionDate Date Entered
MaintObjectInternalID MaintObjectInternalID Object number
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
InventoryNumber InventoryNumber Inventory No.
GrossWeight GrossWeight Total Weight
GrossWeightUnit GrossWeightUnit Weight Unit
SizeOrDimensionText SizeOrDimensionText Size/dimensions
OperationStartDate OperationStartDate Validity period
LastChangeDateTime LastChangeDateTime Timestamp
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_FunctionalLocationSearch.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PFLOCSEARCH
-- Parameters: P_Language : abap.lang, P_KeyDate : sydate

CREATE VIEW P_FunctionalLocationSearch AS
SELECT
  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
FROM I_FunctionalLocation
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON FunctionalLocation = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'IFLOT' AND _LongText.TextObjectType = 'LTXT'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _CharValueAssignment ON FunctionalLocation = _CharValueAssignment.ClfnObjectID AND _CharValueAssignment.ClfnObjectTable = 'IFLOT'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClassAssignment ON FunctionalLocation = _ClassAssignment.ClfnObjectID AND _ClassAssignment.ClfnObjectTable = 'IFLOT'  -- association [0..*]
;

Learn More