R_IsltnCertItmTimeFrameCheckTP

DDL: R_ISLTNCERTITMTIMEFRAMECHECKTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

Isolation Item Time Frame Conflict - TP

R_IsltnCertItmTimeFrameCheckTP is a Transactional CDS View that provides data about "Isolation Item Time Frame Conflict - TP" in SAP S/4HANA. It reads from 1 data source (I_IsltnCertItmTimeFrameCheck) and exposes 15 fields with key fields MaintenancePlanningPlant, TechnicalObjectLabel, IsltnCertItmCatType, IsltnCertItemOperationalGroup, IsltnCertItmTaggingCondition. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_IsltnCertItmTimeFrameCheck I_IsltnCertItmTimeFrameCheck from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_IsolationCertificateTP _IsolationCertificateTP $projection.IsolationCertificate = _IsolationCertificateTP.IsolationCertificate

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Isolation Item Time Frame Conflict - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
KEY TechnicalObjectLabel TechnicalObjectLabel Tech. Object
KEY IsltnCertItmCatType IsltnCertItmCatType Item Category
KEY IsltnCertItemOperationalGroup IsltnCertItemOperationalGroup Op. Group
KEY IsltnCertItmTaggingCondition IsltnCertItmTaggingCondition Tagging Cond.
KEY IsltnCertItmTaggingType IsltnCertItmTaggingType Tagging Type
KEY IsolationCertItemInternalID IsolationCertItemInternalID Object number
IsolationCertificate IsolationCertificate WC Document
IsltnCertItemSequenceNumber IsltnCertItemSequenceNumber Item
IsolationCertificateItem IsolationCertificateItem Item
CreatedByUserName CreatedByUserName Person Resp.
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
_IsltnCertificateItemTP _IsltnCertificateItemTP
_IsolationCertificateTP _IsolationCertificateTP

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 R_IsltnCertItmTimeFrameCheckTP.
-- 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 R_IsltnCertItmTimeFrameCheckTP AS
SELECT
  MaintenancePlanningPlant,
  TechnicalObjectLabel,
  IsltnCertItmCatType,
  IsltnCertItemOperationalGroup,
  IsltnCertItmTaggingCondition,
  IsltnCertItmTaggingType,
  IsolationCertItemInternalID,
  IsolationCertificate,
  IsltnCertItemSequenceNumber,
  IsolationCertificateItem,
  CreatedByUserName,
  CreationDate,
  CreationTime
FROM I_IsltnCertItmTimeFrameCheck
LEFT OUTER JOIN R_IsolationCertificateTP AS _IsolationCertificateTP ON IsolationCertificate = _IsolationCertificateTP.IsolationCertificate  -- association [1..1]
;

Learn More