C_RSHTechnicalObject

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_RSHTechnicalObject.
-- 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_RSHTechnicalObject AS
SELECT
  TechnicalObject,
  TechObjIsEquipOrFuncnlLoc,
  TechnicalObjectCategory,
  _TechnicalObjectCategory._Text[1:Language = $session.system_language].TechnicalObjectCategoryDesc AS TechnicalObjectCategoryDesc,
  TechnicalObjectType,
  _TechnicalObjectType._Text[1:Language = $session.system_language].TechnicalObjectTypeDesc AS TechnicalObjectTypeDesc,
  MaintObjectInternalID,
  TechnicalObjectDescription,
  TechnicalObjectHasLongText,
  SuperiorTechnicalObject,
  SuperiorTechnicalObjectLabel,
  SuperiorTechnicalObjectName,
  MaintObjectLocAcctAssgmtNmbr,
  _LocationAccountAssignment.MaintObjectFreeDefinedAttrib AS SortField,
  MaintenancePlanningPlant,
  MaintenancePlannerGroup,
  AuthorizationGroup
FROM P_RSHTechnicalObject
LEFT OUTER JOIN I_LocationAccountAssignment AS _LocationAccountAssignment ON _LocationAccountAssignment.MaintObjectLocAcctAssgmtNmbr = MaintObjectLocAcctAssgmtNmbr  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectType AS _TechnicalObjectType ON _TechnicalObjectType.TechnicalObjectType = TechnicalObjectType  -- association [0..1]
LEFT OUTER JOIN I_TechnicalObjectCategory AS _TechnicalObjectCategory ON TechnicalObjectCategory = _TechnicalObjectCategory.TechnicalObjectCategory AND _TechnicalObjectCategory.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocationLabel AS _FunctionalLocationLabel ON _FunctionalLocationLabel.FunctionalLocation = TechnicalObject  -- association [0..1]
;