R_UtilitiesDeviceTP

DDL: R_UTILITIESDEVICETP Type: view_entity TRANSACTIONAL
39 Fields 1 Data Sources

Utilities Device - TP

R_UtilitiesDeviceTP is a Transactional CDS View that provides data about "Utilities Device - TP" in SAP S/4HANA. It reads from 1 data source (I_UtilitiesDeviceHeader) and exposes 39 fields with key field Equipment.

Data Sources (1)

SourceAliasJoin Type
I_UtilitiesDeviceHeader I_UtilitiesDeviceHeader from

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Utilities Device - TP view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.representativeKey Equipment view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.sapObjectNodeType.name UtilitiesDevice view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
UtilsDeviceInOutGroup UtilsDeviceInOutGroup I/O Group
UtilsDeviceARCRCommandGroup UtilsDeviceARCRCommandGroup Command Group
UtilsDeviceSampleLot UtilsDeviceSampleLot Lot
UtilsDeviceMeasuredPressure UtilsDeviceMeasuredPressure Measured Press.
UtilsDeviceTransformationRatio UtilsDeviceTransformationRatio Transform.ratio
UtilsDeviceInspRelevanceCode UtilsDeviceInspRelevanceCode Inspection rel.
UtilsDeviceCertificationYear UtilsDeviceCertificationYear Cert. year
UtilsDeviceAdvncRplcmtYear UtilsDeviceAdvncRplcmtYear Advance repl.
UtilsDeviceCertfnStatus UtilsDeviceCertfnStatus Certific. stat.
SampleUtilsDeviceStatus SampleUtilsDeviceStatus Samp.dev.status
UtilsDeviceLastLeadSealingDate UtilsDeviceLastLeadSealingDate Sealing date
UtilsDeviceCertfnType UtilsDeviceCertfnType Certif. type
UtilsDeviceCertificationNumber UtilsDeviceCertificationNumber Certific. no.
UtilsDeviceModificationDate UtilsDeviceModificationDate Modificat. date
UtilsDeviceModReason UtilsDeviceModReason Modific. reason
UtilsDeviceCalibrnValdtyIsUsed UtilsDeviceCalibrnValdtyIsUsed Calibrat.valid.
UtilsDeviceParametrizationCode UtilsDeviceParametrizationCode Parametrization
UtilsDeviceLeadSealingCode UtilsDeviceLeadSealingCode Seal code
LastChangeDate LastChangeDate Time Stamp
UtilsDeviceLastChangedByUser UtilsDeviceLastChangedByUser User Name
UtilsDeviceInspPointGroup UtilsDeviceInspPointGroup Insp. point grp
InstdUtilsDeviceIsCertifiable InstdUtilsDeviceIsCertifiable Cert. ins. devs
UtilsDeviceInspectionNumber UtilsDeviceInspectionNumber Inspection no.
DvceIndivCertfnValdtyInYrs DvceIndivCertfnValdtyInYrs Ind. cal. val.
SerialNumber _Equipment SerialNumber Serial Number
Material _Equipment Material Vehicle Model
AuthorizationGroup _Equipment AuthorizationGroup AuthorizGroup
_Equipment _Equipment
_Material _Equipment _Material
_UtilitiesDeviceHistory _UtilitiesDeviceHistory
_UtilsDeviceCertfnStatus _UtilsDeviceCertfnStatus
_UtilsDeviceCertfnType _UtilsDeviceCertfnType
_UtilsDeviceLastChangedByUser _UtilsDeviceLastChangedByUser
_UtilsDeviceModReason _UtilsDeviceModReason
_UtilsDeviceSampleLot _UtilsDeviceSampleLot
_UtilsDvceInspRelevance _UtilsDvceInspRelevance
_UtilsDvceParametrization _UtilsDvceParametrization
_UtilsSampleDeviceStatus _UtilsSampleDeviceStatus

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_UtilitiesDeviceTP.
-- 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_UtilitiesDeviceTP AS
SELECT
  Equipment,
  UtilsDeviceInOutGroup,
  UtilsDeviceARCRCommandGroup,
  UtilsDeviceSampleLot,
  UtilsDeviceMeasuredPressure,
  UtilsDeviceTransformationRatio,
  UtilsDeviceInspRelevanceCode,
  UtilsDeviceCertificationYear,
  UtilsDeviceAdvncRplcmtYear,
  UtilsDeviceCertfnStatus,
  SampleUtilsDeviceStatus,
  UtilsDeviceLastLeadSealingDate,
  UtilsDeviceCertfnType,
  UtilsDeviceCertificationNumber,
  UtilsDeviceModificationDate,
  UtilsDeviceModReason,
  UtilsDeviceCalibrnValdtyIsUsed,
  UtilsDeviceParametrizationCode,
  UtilsDeviceLeadSealingCode,
  LastChangeDate,
  UtilsDeviceLastChangedByUser,
  UtilsDeviceInspPointGroup,
  InstdUtilsDeviceIsCertifiable,
  UtilsDeviceInspectionNumber,
  DvceIndivCertfnValdtyInYrs,
  _Equipment.SerialNumber AS SerialNumber,
  _Equipment.Material AS Material,
  _Equipment.AuthorizationGroup AS AuthorizationGroup,
  _Equipment._Material AS _Material
FROM I_UtilitiesDeviceHeader
;

Learn More