C_RefFunctionalLocationTP

DDL: C_REFFUNCTIONALLOCATIONTP Type: view_entity CONSUMPTION
38 Fields 1 Data Sources

Reference Functional Location

C_RefFunctionalLocationTP is a Consumption CDS View that provides data about "Reference Functional Location" in SAP S/4HANA. It reads from 1 data source (R_RefFunctionalLocationTP) and exposes 38 fields with key field ReferenceFunctionalLocation.

Data Sources (1)

SourceAliasJoin Type
R_RefFunctionalLocationTP R_RefFunctionalLocationTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Reference Functional Location view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
Search.searchable true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ReferenceFunctionalLocation ReferenceFunctionalLocation FunctLocation
RefFunctionalLocationName RefFunctionalLocationName FunctLocation
RefFunctionalLocationStructure RefFunctionalLocationStructure
FuncLocationStructureDesc _RefFuncLocationStructureText FuncLocationStructureDesc
RefFunctionalLocationCategory RefFunctionalLocationCategory
RefFuncnlLocationCategoryDesc _RefFuncnlLocationCategory RefFuncnlLocationCategoryDesc
SuprRefFunctionalLocation SuprRefFunctionalLocation
SuprRefFuncLocationDescription _SuprRefFunctionalLocText RefFuncLocDescription
RefFuncLocCreationDate RefFuncLocCreationDate
RefFuncLocCreatedByUser RefFuncLocCreatedByUser
RefFuncLocLastChangeDate RefFuncLocLastChangeDate
RefFuncLocLastChangedByUser RefFuncLocLastChangedByUser
TechObjAuthorizationGroup TechObjAuthorizationGroup AuthorizGroup
TechObjAuthorizationGroupDesc _TechObjAuthznGrpText TechObjAuthorizationGroupDesc
ConstructionMaterial ConstructionMaterial ConstType
MaterialName _ConstructionMaterialText MaterialName Material Description
EquipmentInstallationIsAllowed EquipmentInstallationIsAllowed
OnePieceOfEquipmentIsAllowed OnePieceOfEquipmentIsAllowed
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlanningPlantName _MaintenancePlanningPlant PlantName1
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlannerGroupName _MaintenancePlannerGroup MaintenancePlannerGroupName Planner Group Name
WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenter WorkCenter Work Center
WorkCenterText _WorkCenterText WorkCenterText Work Center Text
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenterPlant WorkCenterPlant Plant
CatalogProfile CatalogProfile Catalog Profile
CatalogProfileText _CatalogProfileText CatalogProfileText
TechObjectABCIndicatorCode TechObjectABCIndicatorCode ABC Indic.
ABCIndicatorDesc _ABCIndicatorText ABCIndicatorDesc
MaintObjectInternalID MaintObjectInternalID Object number
RefFuncLocDescription _RefFunctionalLocationText RefFuncLocDescription
StatusCode StatusCode Statuscode
RefTechObjectSystemStatusName
RefTechObjectSystemStatusText
RefFuncnlLocExtIdentifier RefFuncnlLocExtIdentifier
RefFuncnlLocIsExternal RefFuncnlLocIsExternal

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 C_RefFunctionalLocationTP.
-- 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.

CREATE VIEW C_RefFunctionalLocationTP AS
SELECT
  ReferenceFunctionalLocation,
  RefFunctionalLocationName,
  RefFunctionalLocationStructure,
  _RefFuncLocationStructureText.FuncLocationStructureDesc AS FuncLocationStructureDesc,
  RefFunctionalLocationCategory,
  _RefFuncnlLocationCategory.RefFuncnlLocationCategoryDesc AS RefFuncnlLocationCategoryDesc,
  SuprRefFunctionalLocation,
  _SuprRefFunctionalLocText.RefFuncLocDescription AS SuprRefFuncLocationDescription,
  RefFuncLocCreationDate,
  RefFuncLocCreatedByUser,
  RefFuncLocLastChangeDate,
  RefFuncLocLastChangedByUser,
  TechObjAuthorizationGroup,
  _TechObjAuthznGrpText.TechObjAuthorizationGroupDesc AS TechObjAuthorizationGroupDesc,
  ConstructionMaterial,
  _ConstructionMaterialText.MaterialName AS MaterialName,
  EquipmentInstallationIsAllowed,
  OnePieceOfEquipmentIsAllowed,
  MaintenancePlanningPlant,
  _MaintenancePlanningPlant.PlantName1 AS MaintenancePlanningPlantName,
  MaintenancePlannerGroup,
  _MaintenancePlannerGroup.MaintenancePlannerGroupName AS MaintenancePlannerGroupName,
  WorkCenterTypeCode,
  WorkCenter,
  _WorkCenterText.WorkCenterText AS WorkCenterText,
  WorkCenterInternalID,
  WorkCenterPlant,
  CatalogProfile,
  _CatalogProfileText.CatalogProfileText AS CatalogProfileText,
  TechObjectABCIndicatorCode,
  _ABCIndicatorText.ABCIndicatorDesc AS ABCIndicatorDesc,
  MaintObjectInternalID,
  _RefFunctionalLocationText.RefFuncLocDescription AS RefFuncLocDescription,
  StatusCode,
  _StatusText[1:StatusCode = statuscode].StatusShortName AS RefTechObjectSystemStatusName,
  _StatusText[1:StatusCode = statuscode].StatusName AS RefTechObjectSystemStatusText,
  RefFuncnlLocExtIdentifier,
  RefFuncnlLocIsExternal
FROM R_RefFunctionalLocationTP
;

Learn More