I_UTILITIESDEVICEHEADER
Device Header Data
I_UTILITIESDEVICEHEADER is a CDS View in S/4HANA. Device Header Data. It contains 32 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_UtilitiesDeviceDP | view_entity | from | CONSUMPTION | Data Provider for utilities device |
| R_UtilitiesDeviceTP | view_entity | from | TRANSACTIONAL | Utilities Device - TP |
Fields (32)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _UtilsDeviceCertfnStatus | _UtilsDeviceCertfnStatus | 2 | |
| _UtilsDeviceCertfnType | _UtilsDeviceCertfnType | 2 | |
| _UtilsDeviceLastChangedByUser | _UtilsDeviceLastChangedByUser | 2 | |
| _UtilsDeviceModReason | _UtilsDeviceModReason | 2 | |
| _UtilsDeviceSampleLot | _UtilsDeviceSampleLot | 2 | |
| _UtilsDvceInspRelevance | _UtilsDvceInspRelevance | 2 | |
| _UtilsDvceParametrization | _UtilsDvceParametrization | 2 | |
| _UtilsSampleDeviceStatus | _UtilsSampleDeviceStatus | 2 | |
| DvceIndivCertfnValdtyInYrs | DvceIndivCertfnValdtyInYrs | 2 | |
| InstdUtilsDeviceIsCertifiable | InstdUtilsDeviceIsCertifiable | 2 | |
| LastChangeDate | LastChangeDate | 2 | |
| SampleUtilsDeviceStatus | SampleUtilsDeviceStatus | 2 | |
| UtilsDeviceAdvncRplcmtYear | UtilsDeviceAdvncRplcmtYear | 2 | |
| UtilsDeviceARCRCommandGroup | UtilsDeviceARCRCommandGroup | 2 | |
| UtilsDeviceCalibrnValdtyIsUsed | UtilsDeviceCalibrnValdtyIsUsed | 2 | |
| UtilsDeviceCertfnStatus | UtilsDeviceCertfnStatus | 2 | |
| UtilsDeviceCertfnType | UtilsDeviceCertfnType | 2 | |
| UtilsDeviceCertificationNumber | UtilsDeviceCertificationNumber | 2 | |
| UtilsDeviceCertificationYear | UtilsDeviceCertificationYear | 2 | |
| UtilsDeviceInOutGroup | UtilsDeviceInOutGroup | 2 | |
| UtilsDeviceInspectionNumber | UtilsDeviceInspectionNumber | 2 | |
| UtilsDeviceInspPointGroup | UtilsDeviceInspPointGroup | 2 | |
| UtilsDeviceInspRelevanceCode | UtilsDeviceInspRelevanceCode | 2 | |
| UtilsDeviceLastChangedByUser | UtilsDeviceLastChangedByUser | 2 | |
| UtilsDeviceLastLeadSealingDate | UtilsDeviceLastLeadSealingDate | 2 | |
| UtilsDeviceLeadSealingCode | UtilsDeviceLeadSealingCode | 2 | |
| UtilsDeviceMeasuredPressure | UtilsDeviceMeasuredPressure | 2 | |
| UtilsDeviceModificationDate | UtilsDeviceModificationDate | 2 | |
| UtilsDeviceModReason | UtilsDeviceModReason | 2 | |
| UtilsDeviceParametrizationCode | UtilsDeviceParametrizationCode | 2 | |
| UtilsDeviceSampleLot | UtilsDeviceSampleLot | 2 | |
| UtilsDeviceTransformationRatio | UtilsDeviceTransformationRatio | 2 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Device Header Data
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UTILITIESDEVICEHEADER (
_UTILSDEVICECERTFNSTATUS,
_UTILSDEVICECERTFNTYPE,
_UTILSDEVICELASTCHANGEDBYUSER,
_UTILSDEVICEMODREASON,
_UTILSDEVICESAMPLELOT,
_UTILSDVCEINSPRELEVANCE,
_UTILSDVCEPARAMETRIZATION,
_UTILSSAMPLEDEVICESTATUS,
DVCEINDIVCERTFNVALDTYINYRS,
INSTDUTILSDEVICEISCERTIFIABLE,
LASTCHANGEDATE,
SAMPLEUTILSDEVICESTATUS,
UTILSDEVICEADVNCRPLCMTYEAR,
UTILSDEVICEARCRCOMMANDGROUP,
UTILSDEVICECALIBRNVALDTYISUSED,
UTILSDEVICECERTFNSTATUS,
UTILSDEVICECERTFNTYPE,
UTILSDEVICECERTIFICATIONNUMBER,
UTILSDEVICECERTIFICATIONYEAR,
UTILSDEVICEINOUTGROUP,
UTILSDEVICEINSPECTIONNUMBER,
UTILSDEVICEINSPPOINTGROUP,
UTILSDEVICEINSPRELEVANCECODE,
UTILSDEVICELASTCHANGEDBYUSER,
UTILSDEVICELASTLEADSEALINGDATE,
UTILSDEVICELEADSEALINGCODE,
UTILSDEVICEMEASUREDPRESSURE,
UTILSDEVICEMODIFICATIONDATE,
UTILSDEVICEMODREASON,
UTILSDEVICEPARAMETRIZATIONCODE,
UTILSDEVICESAMPLELOT,
UTILSDEVICETRANSFORMATIONRATIO
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA