C_ObjPgTechnicalObjectWthDesc

DDL: C_OBJPGTECHNICALOBJECTWTHDESC SQL: COPTOWTHDESC Type: view CONSUMPTION
34 Fields 1 Data Sources

Obj Page for Technical Object with Desc

C_ObjPgTechnicalObjectWthDesc is a Consumption CDS View that provides data about "Obj Page for Technical Object with Desc" in SAP S/4HANA. It reads from 1 data source (I_TechnicalObject) and exposes 34 fields with key fields TechnicalObject, TechObjIsEquipOrFuncnlLoc.

Data Sources (1)

SourceAliasJoin Type
I_TechnicalObject I_TechnicalObject from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName COPTOWTHDESC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Obj Page for Technical Object with Desc view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObject TechnicalObject Technical Object
KEY TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
TechnicalObjectLongText Long Text
TechnicalObjectDescription Description
ClassNumber Class
TechnicalObjectClassDesc
TechnicalObjectCategory TechnicalObjectCategory Category
TechnicalObjectCategoryDesc
TechnicalObjectType TechnicalObjectType Type
TechnicalObjectTypeDesc Type
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartTypeName ManufacturerPartTypeName Model number
ManufacturerPartNmbr ManufacturerPartNmbr Manufacturer Part Number
ManufacturerSerialNumber ManufacturerSerialNumber Manufacturer Serial Number
SerialNumber SerialNumber Serial Number
Material Material Vehicle Model
MaterialName Material Name
ConstructionMaterial ConstructionMaterial ConstType
MaterialTypeName Construction Material Name
InventoryNumber InventoryNumber
AuthorizationGroup AuthorizationGroup Authorization Group
GrossWeight GrossWeight Total Weight
GrossWeightUnit GrossWeightUnit
SizeOrDimensionText SizeOrDimensionText Size/dimensions
TechObjNmbrOfAttachedDocuments Original Files
MaintObjectInternalID MaintObjectInternalID Object number
TechObjectWithLeadingZeros Technical Object
CostCenter _LocationAccountAssignment CostCenter Cost Center
ControllingArea _LocationAccountAssignment ControllingArea Controlling Area
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
MaintenancePlant
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
_LocationAccountAssignment _LocationAccountAssignment

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_ObjPgTechnicalObjectWthDesc.
-- 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: COPTOWTHDESC
-- Parameters: P_Language : sylangu

CREATE VIEW C_ObjPgTechnicalObjectWthDesc AS
SELECT
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  cast (' ' as eams_ltext ) AS TechnicalObjectLongText,
  _TechnicalObjectText[1:Language = $session.system_language].TechnicalObjectDescription AS TechnicalObjectDescription,
  cast(' ' as klasse_d) AS ClassNumber,
  cast(' ' as klsbez) AS TechnicalObjectClassDesc,
  TechnicalObjectCategory,
  _TechnicalObjectCategory._Text[1: Language = $parameters.P_Language].TechnicalObjectCategoryDesc AS TechnicalObjectCategoryDesc,
  TechnicalObjectType,
  _TechnicalObjectType._Text[1: Language = $parameters.P_Language].TechnicalObjectTypeDesc AS TechnicalObjectTypeDesc,
  AssetManufacturerName,
  ManufacturerPartTypeName,
  ManufacturerPartNmbr,
  ManufacturerSerialNumber,
  SerialNumber,
  Material,
  _Equipment._Material._Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  ConstructionMaterial,
  _ConstructionMaterial._Text[1:Language = $session.system_language].MaterialName AS MaterialTypeName,
  InventoryNumber,
  AuthorizationGroup,
  GrossWeight,
  GrossWeightUnit,
  SizeOrDimensionText,
  cast ('0' as abap.int2 ) AS TechObjNmbrOfAttachedDocuments,
  MaintObjectInternalID,
  cast(TechnicalObject as char40) AS TechObjectWithLeadingZeros,
  _LocationAccountAssignment.CostCenter AS CostCenter,
  _LocationAccountAssignment.ControllingArea AS ControllingArea,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  _LocationAccountAssignment._WorkCenter.Plant AS MaintenancePlant,
  MaintObjectLocAcctAssgmtNmbr
FROM I_TechnicalObject
;

Learn More