C_TechnicalObject

DDL: C_TECHNICALOBJECT SQL: CTECHNICALOBJECT Type: view CONSUMPTION
82 Fields 2 Data Sources 1 Associations

Technical Object

C_TechnicalObject is a Consumption CDS View that provides data about "Technical Object" in SAP S/4HANA. It reads from 2 data sources (C_Equipment, C_FunctionalLocation) and exposes 82 fields with key field TechObjectWithLeadingZeros. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
C_Equipment C_Equipment from
C_FunctionalLocation C_FunctionalLocation union_all

Parameters (2)

NameTypeDefault
P_Language sylangu
P_KeyDate sydate

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_DataElementLabelText _DataElementLabelText _DataElementLabelText.ABAPDataElement = 'EQUNR'

Annotations (10)

NameValueLevelField
EndUserText.label Technical Object view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CTECHNICALOBJECT view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey TechObjectWithLeadingZeros view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY TechObjectWithLeadingZeros Equipment check
TechObjIsEquipOrFuncnlLoc
TechnicalObject Functional Loc.
TechnicalObjectDescription Functional Loc.
TechObjIsEquipOrFuncnlLocDesc
TechnicalObject_H Object ID
TechnicalObjectLabel Functional Loc.
TechnicalObjectCategory C_Equipment EquipmentCategory FunctLocCat.
TechnicalObjectCategoryDesc C_Equipment EquipmentCategoryDesc
TechnicalObjectType C_Equipment TechnicalObjectType Text object
TechnicalObjectTypeDesc C_Equipment TechnicalObjectTypeDesc
CreatedByUser C_Equipment CreatedByUser User Name
CreationDate C_Equipment CreationDate Time Stamp
LastChangedByUser C_Equipment LastChangedByUser User Name
LastChangeDate C_Equipment LastChangeDate Time Stamp
AssetManufacturerName C_Equipment AssetManufacturerName Manufacturer
ManufacturerPartTypeName C_Equipment ManufacturerPartTypeName Model number
MaintenancePlanningPlant C_Equipment MaintenancePlanningPlant Planning Plant
MainWorkCenter C_Equipment MainWorkCenter Work Center
MaintenanceWorkCenter C_Equipment MaintenanceWorkCenter Work Center
MaintenancePlant C_Equipment MaintenancePlant Plant
PlantSection C_Equipment PlantSection Plant Section
AssetLocation C_Equipment AssetLocation Location
MaintObjectFreeDefinedAttrib C_Equipment MaintObjectFreeDefinedAttrib Sort Field
BusinessArea C_Equipment BusinessArea Business Area
ControllingArea C_Equipment ControllingArea Controlling Area
CostCenter C_Equipment CostCenter Cost Center
CompanyCode C_Equipment CompanyCode Receiver Company Code
Division C_Equipment Division Internal Division ID
AssetRoom C_Equipment AssetRoom Room
ABCIndicator C_Equipment ABCIndicator ABC Indicator
MaintenancePlannerGroup C_Equipment MaintenancePlannerGroup Planner Group
CatalogProfile C_Equipment CatalogProfile Catalog Profile
AuthorizationGroup C_Equipment AuthorizationGroup AuthorizGroup
FunctionalLocation C_Equipment FunctionalLocation Object ID
MainWorkCenterPlant C_Equipment MainWorkCenterPlant Plnt WorkCenter
SalesOrganization C_Equipment SalesOrganization Sales Organization
DistributionChannel C_Equipment DistributionChannel RefDistCh-Cust/Mat.
SalesOffice C_Equipment SalesOffice Sales Office
OrganizationDivision C_Equipment OrganizationDivision Org. Division
SalesGroup C_Equipment SalesGroup Sales Group
TechObjIsEquipOrFuncnlLoc
TechnicalObject Functional Loc.
TechnicalObjectDescription Functional Loc.
TechObjIsEquipOrFuncnlLocDesc
TechnicalObject_H FunctionalLocation Object ID
TechnicalObjectLabel FuncnlLocPrimaryLabelName Functional Loc.
TechnicalObjectCategory C_FunctionalLocation FunctionalLocationCategory FunctLocCat.
TechnicalObjectCategoryDesc C_FunctionalLocation FunctionalLocationCategoryDesc
TechnicalObjectType C_FunctionalLocation TechnicalObjectType Text object
TechnicalObjectTypeDesc C_FunctionalLocation TechnicalObjectTypeDesc
CreatedByUser C_FunctionalLocation CreatedByUser User Name
CreationDate C_FunctionalLocation CreationDate Time Stamp
LastChangedByUser C_FunctionalLocation LastChangedByUser User Name
LastChangeDate C_FunctionalLocation LastChangeDate Time Stamp
AssetManufacturerName C_FunctionalLocation AssetManufacturerName Manufacturer
ManufacturerPartTypeName C_FunctionalLocation ManufacturerPartTypeName Model number
MaintenancePlanningPlant C_FunctionalLocation MaintenancePlanningPlant Planning Plant
MainWorkCenter C_FunctionalLocation MainWorkCenter Work Center
MaintenanceWorkCenter C_FunctionalLocation MaintenanceWorkCenter Work Center
MaintenancePlant C_FunctionalLocation MaintenancePlant Plant
PlantSection C_FunctionalLocation PlantSection Plant Section
AssetLocation C_FunctionalLocation AssetLocation Location
MaintObjectFreeDefinedAttrib C_FunctionalLocation MaintObjectFreeDefinedAttrib Sort Field
BusinessArea C_FunctionalLocation BusinessArea Business Area
ControllingArea C_FunctionalLocation ControllingArea Controlling Area
CostCenter C_FunctionalLocation CostCenter Cost Center
CompanyCode C_FunctionalLocation CompanyCode Receiver Company Code
Division C_FunctionalLocation Division Internal Division ID
AssetRoom C_FunctionalLocation AssetRoom Room
ABCIndicator C_FunctionalLocation ABCIndicator ABC Indicator
MaintenancePlannerGroup C_FunctionalLocation MaintenancePlannerGroup Planner Group
CatalogProfile C_FunctionalLocation CatalogProfile Catalog Profile
AuthorizationGroup C_FunctionalLocation AuthorizationGroup AuthorizGroup
FunctionalLocation C_FunctionalLocation FunctionalLocation Object ID
MainWorkCenterPlant C_FunctionalLocation MainWorkCenterPlant Plnt WorkCenter
SalesOrganization C_FunctionalLocation SalesOrganization Sales Organization
DistributionChannel C_FunctionalLocation DistributionChannel RefDistCh-Cust/Mat.
SalesOffice C_FunctionalLocation SalesOffice Sales Office
OrganizationDivision C_FunctionalLocation OrganizationDivision Org. Division
SalesGroup C_FunctionalLocation SalesGroup Sales Group
ItemCounter 1

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_TechnicalObject.
-- 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: CTECHNICALOBJECT
-- Parameters: P_Language : sylangu, P_KeyDate : sydate

CREATE VIEW C_TechnicalObject AS
SELECT
  cast ( Equipment as eams_tec_obj ) AS TechObjectWithLeadingZeros,
  cast ( 'EAMS_EQUI' as eams_tec_obj_type) AS TechObjIsEquipOrFuncnlLoc,
  cast ( Equipment as eams_tec_obj ) AS TechnicalObject,
  cast ( EquipmentName as eams_tec_obj_des ) AS TechnicalObjectDescription,
  cast ( _DataElementLabelText[1: Language = $parameters.P_Language ].ABAPLongFieldLabel as eams_tec_obj_type_desc ) AS TechObjIsEquipOrFuncnlLocDesc,
  cast( Equipment as eams_tec_obj ) AS TechnicalObject_H,
  cast( Equipment as eams_tec_obj ) AS TechnicalObjectLabel,
  C_Equipment.EquipmentCategory AS TechnicalObjectCategory,
  C_Equipment.EquipmentCategoryDesc AS TechnicalObjectCategoryDesc,
  C_Equipment.TechnicalObjectType AS TechnicalObjectType,
  C_Equipment.TechnicalObjectTypeDesc AS TechnicalObjectTypeDesc,
  C_Equipment.CreatedByUser AS CreatedByUser,
  C_Equipment.CreationDate AS CreationDate,
  C_Equipment.LastChangedByUser AS LastChangedByUser,
  C_Equipment.LastChangeDate AS LastChangeDate,
  C_Equipment.AssetManufacturerName AS AssetManufacturerName,
  C_Equipment.ManufacturerPartTypeName AS ManufacturerPartTypeName,
  C_Equipment.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  C_Equipment.MainWorkCenter AS MainWorkCenter,
  C_Equipment.MaintenanceWorkCenter AS MaintenanceWorkCenter,
  C_Equipment.MaintenancePlant AS MaintenancePlant,
  C_Equipment.PlantSection AS PlantSection,
  C_Equipment.AssetLocation AS AssetLocation,
  C_Equipment.MaintObjectFreeDefinedAttrib AS MaintObjectFreeDefinedAttrib,
  C_Equipment.BusinessArea AS BusinessArea,
  C_Equipment.ControllingArea AS ControllingArea,
  C_Equipment.CostCenter AS CostCenter,
  C_Equipment.CompanyCode AS CompanyCode,
  C_Equipment.Division AS Division,
  C_Equipment.AssetRoom AS AssetRoom,
  C_Equipment.ABCIndicator AS ABCIndicator,
  C_Equipment.MaintenancePlannerGroup AS MaintenancePlannerGroup,
  C_Equipment.CatalogProfile AS CatalogProfile,
  C_Equipment.AuthorizationGroup AS AuthorizationGroup,
  C_Equipment.FunctionalLocation AS FunctionalLocation,
  C_Equipment.MainWorkCenterPlant AS MainWorkCenterPlant,
  C_Equipment.SalesOrganization AS SalesOrganization,
  C_Equipment.DistributionChannel AS DistributionChannel,
  C_Equipment.SalesOffice AS SalesOffice,
  C_Equipment.OrganizationDivision AS OrganizationDivision,
  C_Equipment.SalesGroup AS SalesGroup,
  1 AS ItemCounter
FROM C_Equipment
LEFT OUTER JOIN I_DataElementLabelText AS _DataElementLabelText ON _DataElementLabelText.ABAPDataElement = 'EQUNR'  -- association [0..1]
-- UNION ALL with additional select branch(es): C_FunctionalLocation
;

Learn More