C_IsltnCertTechnicalObjectTP

DDL: C_ISLTNCERTTECHNICALOBJECTTP Type: view_entity CONSUMPTION
14 Fields 1 Data Sources 1 Associations

Isolation Certificate Technical Obj

C_IsltnCertTechnicalObjectTP is a Consumption CDS View that provides data about "Isolation Certificate Technical Obj" in SAP S/4HANA. It reads from 1 data source (R_IsltnCertTechnicalObjectTP) and exposes 14 fields with key fields IsolationCertificateInternalID, TechnicalObject, IsltnCertItmCatType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_IsltnCertTechnicalObjectTP R_IsltnCertTechnicalObjectTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_TechObjQuickVw _TechnicalObjQuickVw _TechnicalObjQuickVw.TechnicalObject = $projection.TechnicalObject and _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = $projection.TechObjIsEquipOrFuncnlLoc

Annotations (12)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Isolation Certificate Technical Obj view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.createHidden true view
UI.headerInfo.typeName Object List view
UI.headerInfo.typeNamePlural Object List view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Object List view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY IsolationCertificateInternalID IsolationCertificateInternalID Object number
KEY TechnicalObject TechnicalObject Technical Object
KEY IsltnCertItmCatType IsltnCertItmCatType Item Category
IsolationCertificate IsolationCertificate WC Document
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
MaintenancePlant MaintenancePlant Plant
PlantName PlantName Plant Name
TechObjIsEquipOrFuncnlLocDesc TechObjIsEquipOrFuncnlLocDesc TObj.Type Desc.
TechnicalObjectLabel TechnicalObjectLabel Tech. Object
TechnicalObjectDescription TechnicalObjectDescription Technical Object Description
TechObjCnctntdActvSystSts TechObjCnctntdActvSystSts Concatenated System Status
TechObjIsEquipOrFuncnlLoc TechObjIsEquipOrFuncnlLoc Tech. Obj. Type
MaintObjectInternalID MaintObjectInternalID Object number
_TechnicalObjQuickVw _TechnicalObjQuickVw

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_IsltnCertTechnicalObjectTP.
-- 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_IsltnCertTechnicalObjectTP AS
SELECT
  IsolationCertificateInternalID,
  TechnicalObject,
  IsltnCertItmCatType,
  IsolationCertificate,
  MaintenancePlanningPlant,
  MaintenancePlant,
  PlantName,
  TechObjIsEquipOrFuncnlLocDesc,
  TechnicalObjectLabel,
  TechnicalObjectDescription,
  TechObjCnctntdActvSystSts,
  TechObjIsEquipOrFuncnlLoc,
  MaintObjectInternalID
FROM R_IsltnCertTechnicalObjectTP
LEFT OUTER JOIN C_TechObjQuickVw AS _TechnicalObjQuickVw ON _TechnicalObjQuickVw.TechnicalObject = TechnicalObject AND _TechnicalObjQuickVw.TechObjIsEquipOrFuncnlLoc = TechObjIsEquipOrFuncnlLoc  -- association [0..1]
;

Learn More