I_EQUIPMENTTYPE
Equipment Type
I_EQUIPMENTTYPE is a CDS View in S/4HANA. Equipment Type. It contains 103 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SCMTMS/CV_EquipmentRoot | view | inner | Equipment Root | |
| /SCMTMS/CV_EquipResourceText | view | union | BOPF: /SCMTMS/RESOURCE Node: Description | |
| /SCMTMS/CV_EquipRsceCapOffer | view | union | BOPF: /SCMTMS/RESOURCE Node: Transp Capacity Offering | |
| /SCMTMS/CV_EquipRsceCombn | view | inner | BOPF: /SCMTMS/RESOURCE Node: Combination | |
| C_EquipmentTypeAndResource | view_entity | inner | CONSUMPTION | Equipment Type and Resource Master Data |
| C_EquipTypeAndRsceCapOffer | view_entity | union | CONSUMPTION | Equipment and Resource Capacity Offer |
Fields (103)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | EquipmentType | EquipmentType | 2 |
| AttachedEquipmentProfile | AttachedEquipmentProfile | 1 | |
| EquipmentTypeIsDeleted | EquipmentTypeIsDeleted | 1 | |
| EquipTypeIsTranspPlngNotRlvt | EquipTypeIsTranspPlngNotRlvt | 1 | |
| NumberOfAxles | NumberOfAxles | 1 | |
| PackagingMaterialName | PackagingMaterialName | 1 | |
| ResourceAdditionalUUID | indiv_resuuid,ResourceAdditionalUUID | 2 | |
| ResourceAxleGroup1DistanceUnit | ResourceAxleGroup1DistanceUnit | 1 | |
| ResourceAxleGroup1Type | ResourceAxleGroup1Type | 1 | |
| ResourceAxleGroup2DistanceUnit | ResourceAxleGroup2DistanceUnit | 1 | |
| ResourceAxleGroup2Type | ResourceAxleGroup2Type | 1 | |
| ResourceAxleGroup3DistanceUnit | ResourceAxleGroup3DistanceUnit | 1 | |
| ResourceAxleGroup3Type | ResourceAxleGroup3Type | 1 | |
| ResourceAxleSpaceDistance | ResourceAxleSpaceDistance | 1 | |
| ResourceAxleSpaceDistanceUnit | ResourceAxleSpaceDistanceUnit | 1 | |
| ResourceCargoBodyDistance | ResourceCargoBodyDistance | 1 | |
| ResourceCompartmentProfile | ResourceCompartmentProfile | 1 | |
| ResourceConnectorDistance | ResourceConnectorDistance | 1 | |
| ResourceConnectorMaxWeight | ResourceConnectorMaxWeight | 1 | |
| ResourceCouplerStyle | ResourceCouplerStyle | 1 | |
| ResourceCtrlTemperatureUnit | ResourceCtrlTemperatureUnit | 1 | |
| ResourceCubicCapacity | ResourceCubicCapacity | 1 | |
| ResourceCubicCapacityUnit | QTY_UNIT_C,ResourceCapacityUnit,ResourceCubicCapacityUnit | 3 | |
| ResourceDoorHeight | ResourceDoorHeight | 1 | |
| ResourceDoorLengthUnit | ResourceDoorLengthUnit | 1 | |
| ResourceDoorWidth | ResourceDoorWidth | 1 | |
| ResourceDraftGearType | ResourceDraftGearType | 1 | |
| ResourceInteriorHeight | ResourceInteriorHeight | 1 | |
| ResourceInteriorLength | ResourceInteriorLength | 1 | |
| ResourceInteriorLengthUnit | ResourceInteriorLengthUnit | 1 | |
| ResourceInteriorWidth | ResourceInteriorWidth | 1 | |
| ResourceIsCombinationResource | ResourceIsCombinationResource | 1 | |
| ResourceIsIATACompliant | ResourceIsIATACompliant | 1 | |
| ResourceIsTemperatureCtrld | ResourceIsTemperatureCtrld | 1 | |
| ResourceIsUsableForFood | ResourceIsUsableForFood | 1 | |
| ResourceIsVentilated | ResourceIsVentilated | 1 | |
| ResourceKingpinDistance | ResourceKingpinDistance | 1 | |
| ResourceKingpinMaxWeight | ResourceKingpinMaxWeight | 1 | |
| ResourceLoadWeightUnit | ResourceLoadWeightUnit | 1 | |
| ResourceMaxAxleWeight | ResourceMaxAxleWeight | 1 | |
| ResourceMaxAxleWeightUnit | ResourceMaxAxleWeightUnit | 1 | |
| ResourceMaxCtrlTemperature | ResourceMaxCtrlTemperature | 1 | |
| ResourceMaximumGrossWeight | ResourceMaximumGrossWeight | 1 | |
| ResourceMaximumGrossWeightUnit | ResourceMaximumGrossWeightUnit | 1 | |
| ResourceMaximumHeight | ResourceMaximumHeight | 1 | |
| ResourceMaximumLength | ResourceMaximumLength | 1 | |
| ResourceMaximumLengthUnit | ResourceMaximumLengthUnit | 1 | |
| ResourceMaximumLoadWeight | ResourceMaximumLoadWeight | 1 | |
| ResourceMaximumLoadWeightUnit | QTY_UNIT_C,ResourceCapacityUnit,ResourceMaximumLoadWeightUnit | 3 | |
| ResourceMaximumWidth | ResourceMaximumWidth | 1 | |
| ResourceMinCtrlTemperature | ResourceMinCtrlTemperature | 1 | |
| ResourcePictureURL | ResourcePictureURL | 1 | |
| ResourcePlatformHeight | ResourcePlatformHeight | 1 | |
| ResourcePlatformHeightUnit | ResourcePlatformHeightUnit | 1 | |
| ResourceSplitDeckDistance | ResourceSplitDeckDistance | 1 | |
| ResourceSplitDeckMaxWeight | ResourceSplitDeckMaxWeight | 1 | |
| ResourceTareVolume | ResourceTareVolume | 1 | |
| ResourceTareVolumeUnit | ResourceTareVolumeUnit | 1 | |
| ResourceTareWeight | ResourceTareWeight | 1 | |
| ResourceTareWeightUnit | ResourceTareWeightUnit | 1 | |
| ResourceTechnicalDistanceUnit | ResourceTechnicalDistanceUnit | 1 | |
| ResourceTopDeckHeight | ResourceTopDeckHeight | 1 | |
| ResourceTopDeckHeightUnit | ResourceTopDeckHeightUnit | 1 | |
| ResourceTypeClassification | ResourceTypeClassification | 1 | |
| ResourceULDClassification | ResourceULDClassification | 1 | |
| ResourceWheelBearingType | ResourceWheelBearingType | 1 | |
| ResourceWheelDiameter | ResourceWheelDiameter | 1 | |
| ResourceWheelDiameterUnit | ResourceWheelDiameterUnit | 1 | |
| RsceAddlCapAltvNmbrOfUnits | QTY_VALUE,ResourceCapacity,RsceAddlCapAltvNmbrOfUnits | 3 | |
| RsceAddlCapAltvNmbrOfUnitsUnit | QTY_UNIT_C,ResourceCapacityUnit,RsceAddlCapAltvNmbrOfUnitsUnit | 3 | |
| RsceAddlCapNmbrOfUnits | RsceAddlCapNmbrOfUnits | 1 | |
| RsceAddlCapNmbrOfUnitsUnit | QTY_UNIT_C,ResourceCapacityUnit,RsceAddlCapNmbrOfUnitsUnit | 3 | |
| RsceAxleGroup1Distance | RsceAxleGroup1Distance | 1 | |
| RsceAxleGroup1EmptyWeight | RsceAxleGroup1EmptyWeight | 1 | |
| RsceAxleGroup1IsDrivingAxle | RsceAxleGroup1IsDrivingAxle | 1 | |
| RsceAxleGroup1IsSteeringAxle | RsceAxleGroup1IsSteeringAxle | 1 | |
| RsceAxleGroup1MaximumWeight | RsceAxleGroup1MaximumWeight | 1 | |
| RsceAxleGroup1SpaceDistance | RsceAxleGroup1SpaceDistance | 1 | |
| RsceAxleGroup1WeightUnit | RsceAxleGroup1WeightUnit | 1 | |
| RsceAxleGroup2Distance | RsceAxleGroup2Distance | 1 | |
| RsceAxleGroup2EmptyWeight | RsceAxleGroup2EmptyWeight | 1 | |
| RsceAxleGroup2IsDrivingAxle | RsceAxleGroup2IsDrivingAxle | 1 | |
| RsceAxleGroup2IsSteeringAxle | RsceAxleGroup2IsSteeringAxle | 1 | |
| RsceAxleGroup2MaximumWeight | RsceAxleGroup2MaximumWeight | 1 | |
| RsceAxleGroup2SpaceDistance | RsceAxleGroup2SpaceDistance | 1 | |
| RsceAxleGroup2WeightUnit | RsceAxleGroup2WeightUnit | 1 | |
| RsceAxleGroup3Distance | RsceAxleGroup3Distance | 1 | |
| RsceAxleGroup3EmptyWeight | RsceAxleGroup3EmptyWeight | 1 | |
| RsceAxleGroup3IsDrivingAxle | RsceAxleGroup3IsDrivingAxle | 1 | |
| RsceAxleGroup3IsSteeringAxle | RsceAxleGroup3IsSteeringAxle | 1 | |
| RsceAxleGroup3MaximumWeight | RsceAxleGroup3MaximumWeight | 1 | |
| RsceAxleGroup3SpaceDistance | RsceAxleGroup3SpaceDistance | 1 | |
| RsceAxleGroup3WeightUnit | RsceAxleGroup3WeightUnit | 1 | |
| RsceLoadOpeningLength | RsceLoadOpeningLength | 1 | |
| RsceLoadOpeningLengthUnit | RsceLoadOpeningLengthUnit | 1 | |
| RsceLoadOpeningWidth | RsceLoadOpeningWidth | 1 | |
| RsceMaxTrailingLoadWeight | RsceMaxTrailingLoadWeight | 1 | |
| RsceMaxTrailingLoadWeightUnit | RsceMaxTrailingLoadWeightUnit | 1 | |
| RsceULDLoadingInstruction | RsceULDLoadingInstruction | 1 | |
| RsceULDNumberIsToBeChecked | RsceULDNumberIsToBeChecked | 1 | |
| TranspMeansOfTransport | TranspMeansOfTransport | 2 | |
| TwentyFootEquivUnitCapacity | TwentyFootEquivUnitCapacity | 1 | |
| VehicleLoadingProfile | VehicleLoadingProfile | 1 |
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.
-- Equipment Type
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EQUIPMENTTYPE (
EQUIPMENTTYPE,
ATTACHEDEQUIPMENTPROFILE,
EQUIPMENTTYPEISDELETED,
EQUIPTYPEISTRANSPPLNGNOTRLVT,
NUMBEROFAXLES,
PACKAGINGMATERIALNAME,
RESOURCEADDITIONALUUID,
RESOURCEAXLEGROUP1DISTANCEUNIT,
RESOURCEAXLEGROUP1TYPE,
RESOURCEAXLEGROUP2DISTANCEUNIT,
RESOURCEAXLEGROUP2TYPE,
RESOURCEAXLEGROUP3DISTANCEUNIT,
RESOURCEAXLEGROUP3TYPE,
RESOURCEAXLESPACEDISTANCE,
RESOURCEAXLESPACEDISTANCEUNIT,
RESOURCECARGOBODYDISTANCE,
RESOURCECOMPARTMENTPROFILE,
RESOURCECONNECTORDISTANCE,
RESOURCECONNECTORMAXWEIGHT,
RESOURCECOUPLERSTYLE,
RESOURCECTRLTEMPERATUREUNIT,
RESOURCECUBICCAPACITY,
RESOURCECUBICCAPACITYUNIT,
RESOURCEDOORHEIGHT,
RESOURCEDOORLENGTHUNIT,
RESOURCEDOORWIDTH,
RESOURCEDRAFTGEARTYPE,
RESOURCEINTERIORHEIGHT,
RESOURCEINTERIORLENGTH,
RESOURCEINTERIORLENGTHUNIT,
RESOURCEINTERIORWIDTH,
RESOURCEISCOMBINATIONRESOURCE,
RESOURCEISIATACOMPLIANT,
RESOURCEISTEMPERATURECTRLD,
RESOURCEISUSABLEFORFOOD,
RESOURCEISVENTILATED,
RESOURCEKINGPINDISTANCE,
RESOURCEKINGPINMAXWEIGHT,
RESOURCELOADWEIGHTUNIT,
RESOURCEMAXAXLEWEIGHT,
RESOURCEMAXAXLEWEIGHTUNIT,
RESOURCEMAXCTRLTEMPERATURE,
RESOURCEMAXIMUMGROSSWEIGHT,
RESOURCEMAXIMUMGROSSWEIGHTUNIT,
RESOURCEMAXIMUMHEIGHT,
RESOURCEMAXIMUMLENGTH,
RESOURCEMAXIMUMLENGTHUNIT,
RESOURCEMAXIMUMLOADWEIGHT,
RESOURCEMAXIMUMLOADWEIGHTUNIT,
RESOURCEMAXIMUMWIDTH,
RESOURCEMINCTRLTEMPERATURE,
RESOURCEPICTUREURL,
RESOURCEPLATFORMHEIGHT,
RESOURCEPLATFORMHEIGHTUNIT,
RESOURCESPLITDECKDISTANCE,
RESOURCESPLITDECKMAXWEIGHT,
RESOURCETAREVOLUME,
RESOURCETAREVOLUMEUNIT,
RESOURCETAREWEIGHT,
RESOURCETAREWEIGHTUNIT,
RESOURCETECHNICALDISTANCEUNIT,
RESOURCETOPDECKHEIGHT,
RESOURCETOPDECKHEIGHTUNIT,
RESOURCETYPECLASSIFICATION,
RESOURCEULDCLASSIFICATION,
RESOURCEWHEELBEARINGTYPE,
RESOURCEWHEELDIAMETER,
RESOURCEWHEELDIAMETERUNIT,
RSCEADDLCAPALTVNMBROFUNITS,
RSCEADDLCAPALTVNMBROFUNITSUNIT,
RSCEADDLCAPNMBROFUNITS,
RSCEADDLCAPNMBROFUNITSUNIT,
RSCEAXLEGROUP1DISTANCE,
RSCEAXLEGROUP1EMPTYWEIGHT,
RSCEAXLEGROUP1ISDRIVINGAXLE,
RSCEAXLEGROUP1ISSTEERINGAXLE,
RSCEAXLEGROUP1MAXIMUMWEIGHT,
RSCEAXLEGROUP1SPACEDISTANCE,
RSCEAXLEGROUP1WEIGHTUNIT,
RSCEAXLEGROUP2DISTANCE,
RSCEAXLEGROUP2EMPTYWEIGHT,
RSCEAXLEGROUP2ISDRIVINGAXLE,
RSCEAXLEGROUP2ISSTEERINGAXLE,
RSCEAXLEGROUP2MAXIMUMWEIGHT,
RSCEAXLEGROUP2SPACEDISTANCE,
RSCEAXLEGROUP2WEIGHTUNIT,
RSCEAXLEGROUP3DISTANCE,
RSCEAXLEGROUP3EMPTYWEIGHT,
RSCEAXLEGROUP3ISDRIVINGAXLE,
RSCEAXLEGROUP3ISSTEERINGAXLE,
RSCEAXLEGROUP3MAXIMUMWEIGHT,
RSCEAXLEGROUP3SPACEDISTANCE,
RSCEAXLEGROUP3WEIGHTUNIT,
RSCELOADOPENINGLENGTH,
RSCELOADOPENINGLENGTHUNIT,
RSCELOADOPENINGWIDTH,
RSCEMAXTRAILINGLOADWEIGHT,
RSCEMAXTRAILINGLOADWEIGHTUNIT,
RSCEULDLOADINGINSTRUCTION,
RSCEULDNUMBERISTOBECHECKED,
TRANSPMEANSOFTRANSPORT,
TWENTYFOOTEQUIVUNITCAPACITY,
VEHICLELOADINGPROFILE,
PRIMARY KEY (EQUIPMENTTYPE)
);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