I_EQUIPMENT

CDS View
59 Fields 39 CDS Views

Equipment

I_EQUIPMENT is a CDS View in S/4HANA. Equipment. It contains 59 fields. 39 CDS views read from this table.

CDS Views using this table (39)

ViewTypeJoinVDMDescription
A_Equipment view_entity left_outer COMPOSITE Equipment
A_EquipmentClfnCharValue view_entity inner COMPOSITE Equipment Characteristic Values
A_EquipmentClfnClass view_entity inner COMPOSITE Equipment Class
A_EquipmentClfnClassChar view_entity inner COMPOSITE Equipment Class Characteristics
A_SerialNumberMaterialDocument view inner COMPOSITE Serial Numbers
C_CustomerReturnSerialNumberVH view_entity from CONSUMPTION Returns Order Serial Number
C_EquipmentDataDEX view_entity inner CONSUMPTION Equipment DEX
C_EquipmentPartnerDEX view_entity from CONSUMPTION Equipment Partner DEX
C_FldLogsEquipmentVH view from CONSUMPTION Equipment
C_MaintItmEquipMatlSrlNmbrVH view_entity from CONSUMPTION Maintenance Item Equipment
C_MfgExecDefectRecord view left_outer CONSUMPTION View with UI attributes for defect
C_SerialNmbrEquipNmbrDelivery view left_outer CONSUMPTION Serial and Equipment Numbers
C_SerialNumbersForGdsMvtVH view from CONSUMPTION Value Help for Serial numbers for Goods Movement
C_SrlNmbrAvailableForAssyVH view_entity from CONSUMPTION Serial number available for assembly
ESH_N_MATSLNS view from Anchor view -MATSLNS
I_AvailMaterialSerialNumberVH view from COMPOSITE Available Material Serial Number
I_EquipMaterialSerialNumberVH view_entity from COMPOSITE Equipment
I_EquipMatlSerialNumber view from COMPOSITE Material Serial Number
I_EquipmentData view inner COMPOSITE Equipment Data
I_EquipmentLongText view_entity from COMPOSITE Equipment Long Text
I_EquipmentStdVH view_entity from COMPOSITE Equipment
I_FixedAssetEquipment view inner BASIC Fixed Asset Equipments
I_MaterialSerialNumberVH view from COMPOSITE Material Serial Number
I_MatlSerialNumberInformation view_entity from COMPOSITE Serial Number Information
I_SerialNumberChangeDocument view_entity inner COMPOSITE Serial Number Change Documents
I_SerialNumberStockSegment view_entity inner BASIC Serial Number Stock Segment
I_SerialNumberValueHelp view_entity from BASIC Selection Help for Serial Numbers
I_SerialNumberWithStkSgmtVH view_entity from COMPOSITE Help-View for serial numbers
I_TrackToolUsageOpActyEquip view inner COMPOSITE List of OAs for Equipment
P_EquiFuncnlLocUnionBreakdown view_entity from COMPOSITE Equipment Functional Location Union Breakdown
P_EquipMatlSerialNumberStatus view_entity from COMPOSITE Status of Material Serial Number
P_EquipmentSearch view from BASIC Equipment Anchor View for CDS Search Model
P_EquipmentStatus view_entity from COMPOSITE Equipment Status
P_MfgProcgExecNonAssySrlNmbr view from COMPOSITE Manufacturing Processing Execution Serial Number
P_RSHMaintAssetBoard view inner CONSUMPTION Maintenance Asset Board
P_WrntyClaimEquipment view_entity from COMPOSITE Warranty Claim Equipment
R_EquipmentClfnCharValueTP view_entity inner TRANSACTIONAL Equipment Characteristic Values
R_EquipmentClfnClassCharTP view_entity inner TRANSACTIONAL Equipment Class Characteristics
R_EquipmentClfnClassTP view_entity inner TRANSACTIONAL Equipment Class

Fields (59)

KeyField CDS FieldsUsed in Views
KEY Batch Batch,MatlSrlNmbrMasterBatch 4
KEY Equipment Equipment 17
KEY Material Material 13
KEY SerialNumber SerialNumber 13
_CreatedByUser _CreatedByUser 1
_Currency _Currency 3
_Customer _Customer 6
_Division _Division 3
_EquipmentCategory _EquipmentCategory 4
_EquipmentText _EquipmentText 3
_GrossWeightUnit _GrossWeightUnit 3
_LastChangedByUser _LastChangedByUser 1
_ManufacturerCountry _ManufacturerCountry 3
_MasterWrntyObjectAssgmt _MasterWrntyObjectAssgmt 1
_Material _Material 7
_Plant _Plant 3
_PlantMaintenancePartner _PlantMaintenancePartner 1
_Status _Status 2
_StorageLocation _StorageLocation 3
_Supplier _Supplier 6
_TechnicalObjectType _TechnicalObjectType 3
AcquisitionDate AcquisitionDate 8
AcquisitionValue AcquisitionValue 6
AssetManufacturerName AssetManufacturerName 8
AssetSynchronizationRule AssetSynchronizationRule 1
AuthorizationGroup AuthorizationGroup 12
ConstructionMonth ConstructionMonth 8
ConstructionYear ConstructionYear 8
CreatedByUser CreatedByUser 7
CreationDate CreationDate 9
Currency Currency 8
Customer Customer 6
Division Division 3
EquipmentCategory EquipmentCategory 7
EquipmentEndOfUseDate EquipmentEndOfUseDate 4
EquipmentHasStockInformation EquipmentHasStockInformation 1
EquipmentOID EquipmentOID 3
GrossWeight GrossWeight 6
GrossWeightUnit GrossWeightUnit 8
HasEquipmentData HasEquipmentData 1
InventoryNumber InventoryNumber 8
LastChangeDate LastChangeDate 4
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 7
MaintObjectInternalID MaintObjectInternalID 11
ManufacturerCountry ManufacturerCountry 8
ManufacturerPartTypeName ManufacturerPartTypeName 8
ManufacturerSerialNumber ManufacturerSerialNumber 11
MatlSrlNmbrLastGdsMvtDte MatlSrlNmbrLastGdsMvtDte 1
OperationStartDate OperationStartDate 7
Plant Plant 3
SizeOrDimensionText SizeOrDimensionText 8
StorageLocation StorageLocation 3
Supplier Supplier 6
TechnicalObjectType TechnicalObjectType 10
UniqueItemIdentifier UniqueItemIdentifier 4
UniqueItemIdentifierRespPlant UniqueItemIdentifierRespPlant 3
UniqueItemIdentifierStrucType UniqueItemIdentifierStrucType 3
ValidityEndDate EquipmentValidityEndDate,ValidityEndDate 6

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EQUIPMENT (
    BATCH,
    EQUIPMENT,
    MATERIAL,
    SERIALNUMBER,
    _CREATEDBYUSER,
    _CURRENCY,
    _CUSTOMER,
    _DIVISION,
    _EQUIPMENTCATEGORY,
    _EQUIPMENTTEXT,
    _GROSSWEIGHTUNIT,
    _LASTCHANGEDBYUSER,
    _MANUFACTURERCOUNTRY,
    _MASTERWRNTYOBJECTASSGMT,
    _MATERIAL,
    _PLANT,
    _PLANTMAINTENANCEPARTNER,
    _STATUS,
    _STORAGELOCATION,
    _SUPPLIER,
    _TECHNICALOBJECTTYPE,
    ACQUISITIONDATE,
    ACQUISITIONVALUE,
    ASSETMANUFACTURERNAME,
    ASSETSYNCHRONIZATIONRULE,
    AUTHORIZATIONGROUP,
    CONSTRUCTIONMONTH,
    CONSTRUCTIONYEAR,
    CREATEDBYUSER,
    CREATIONDATE,
    CURRENCY,
    CUSTOMER,
    DIVISION,
    EQUIPMENTCATEGORY,
    EQUIPMENTENDOFUSEDATE,
    EQUIPMENTHASSTOCKINFORMATION,
    EQUIPMENTOID,
    GROSSWEIGHT,
    GROSSWEIGHTUNIT,
    HASEQUIPMENTDATA,
    INVENTORYNUMBER,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MAINTOBJECTINTERNALID,
    MANUFACTURERCOUNTRY,
    MANUFACTURERPARTTYPENAME,
    MANUFACTURERSERIALNUMBER,
    MATLSRLNMBRLASTGDSMVTDTE,
    OPERATIONSTARTDATE,
    PLANT,
    SIZEORDIMENSIONTEXT,
    STORAGELOCATION,
    SUPPLIER,
    TECHNICALOBJECTTYPE,
    UNIQUEITEMIDENTIFIER,
    UNIQUEITEMIDENTIFIERRESPPLANT,
    UNIQUEITEMIDENTIFIERSTRUCTYPE,
    VALIDITYENDDATE,
    PRIMARY KEY (BATCH, EQUIPMENT, MATERIAL, SERIALNUMBER)
);

Learn More