I_EQUIPMENT

CDS View
66 Fields 51 CDS Views

Equipment

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

CDS Views using this table (51)

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_DFS_EquipSerialNumberVH view from CONSUMPTION Equipment By Serial Number Seach Help
C_DFS_MaintEquipmentVH view from CONSUMPTION Value help for Equipment
C_EquipMaterialSerialNumber2VH view_entity from CONSUMPTION Consumption of Equipment F4 Help
C_EquipmentDataDEX view_entity inner CONSUMPTION Equipment Data for Data Product
C_EquipmentPartnerDEX view_entity inner CONSUMPTION Equipment Partner for Data Product
C_FldLogsEquipmentVH view from CONSUMPTION Equipment
C_MaintItmEquipMatlSrlNmbrVH view from CONSUMPTION Maintenance Item Equipment
C_MfgExecDefectRecord view left_outer CONSUMPTION View with UI attributes for defect
C_RefEquipWhereUsedInEquipment view_entity from CONSUMPTION Equipment Created from Ref Equipment
C_RegistrableTestEquipmentVH view_entity inner CONSUMPTION All Equipment PRTs
C_SerialNmbrEquipNmbrDelivery view left_outer CONSUMPTION Serial and Equipment Numbers
C_SerialNumberObjPage view from CONSUMPTION Serial Number Object Page
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
I_AuthzdActlEquipmentDetails view inner COMPOSITE View of Equipments relevant for AAC
I_AvailMaterialSerialNumberVH view from COMPOSITE Available Material Serial Number
I_DFS_MaintStsBrdEquipment view from COMPOSITE Interface view for Status Board Equip
I_EquipMaterialSerialNumberVH view from COMPOSITE Equipment
I_EquipMatlSerialNumber view from COMPOSITE Material Serial Number
I_EquipmentData view inner COMPOSITE Equipment Data
I_EquipmentLongText view from COMPOSITE Equipment Long Text
I_EquipmentStdVH view from COMPOSITE Equipment
I_EWA_EquipNumberVH view_entity from COMPOSITE Equipment Number Values
I_FixedAssetEquipment view inner BASIC Fixed Asset Equipments
I_IndlSystPerspectiveObject view_entity from COMPOSITE Industrial System Perspective Object
I_MaterialSerialNumberVH view from COMPOSITE Material Serial Number
I_MatlSerialNumberInformation view_entity from COMPOSITE Serial Number Information
I_SerialNumberStockSegment view inner BASIC Serial Number Stock Segment
I_SerialNumberValueHelp view_entity from BASIC Selection Help for Serial Numbers
I_SerialNumberWithStkSgmtVH view from BASIC Help-View for serial numbers
P_EquiFuncnlLocUnionBreakdown view from COMPOSITE
P_EquipMatlSerialNumberStatus view from COMPOSITE
P_EquipmentSearch view from BASIC
P_EquipmentStatus view from COMPOSITE
P_MfgProcgExecAssembledSrlNmbr view_entity from COMPOSITE
P_MfgProcgExecNonAssySrlNmbr view from COMPOSITE
P_OpActyInstceTestPRTUnion view_entity inner CONSUMPTION
P_PRTEquipmentAssignment view_entity inner COMPOSITE
P_SFIAtOpActyTestEquipPRTUnion view_entity inner CONSUMPTION
P_UnplndRegnProdnRsceTool view_entity inner COMPOSITE
P_WrntyClaimEquipment view 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 (66)

KeyField CDS FieldsUsed in Views
KEY Batch Batch,MatlSrlNmbrMasterBatch 10
KEY Equipment Equipment 20
KEY Material Material 20
KEY SerialNumber SerialNumber 19
_Batch _Batch 1
_Currency _Currency 3
_Customer _Customer 7
_Division _Division 3
_EquipmentCategory _EquipmentCategory 4
_EquipmentText _EquipmentText 3
_GrossWeightUnit _GrossWeightUnit 3
_ManufacturerCountry _ManufacturerCountry 3
_MasterWarranty _MasterWarranty 1
_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 8
AssetManufacturerName AssetManufacturerName 8
AssetSynchronizationRule AssetSynchronizationRule 2
AuthorizationGroup AuthorizationGroup 14
ConfigurableMaterial ConfigurableMaterial 1
ConstructionMonth ConstructionMonth 8
ConstructionYear ConstructionYear 8
CreatedByUser CreatedByUser 7
CreationDate CreationDate 9
Currency Currency 8
Customer Customer 7
Division Division 3
EquipmentCategory EquipmentCategory 9
EquipmentEndOfUseDate EquipmentEndOfUseDate 5
EquipmentFirstDeliveryDate EquipmentFirstDeliveryDate 1
EquipmentHasStockInformation EquipmentHasStockInformation 2
EquipmentOID EquipmentOID 3
EquipUsagePeriodSequenceNumber EquipUsagePeriodSequenceNumber 1
GrossWeight GrossWeight 8
GrossWeightUnit GrossWeightUnit 8
HasEquipmentData HasEquipmentData 3
InventoryNumber InventoryNumber 8
LastChangeDate LastChangeDate 4
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 6
MaintenancePlan MaintenancePlan 2
MaintObjectInternalID MaintObjectInternalID 13
ManufacturerCountry ManufacturerCountry 8
ManufacturerPartTypeName ManufacturerPartTypeName 9
ManufacturerSerialNumber ManufacturerSerialNumber 13
MasterWarranty MasterWarranty 1
MatlSrlNmbrLastGdsMvtDte MatlSrlNmbrLastGdsMvtDte 2
MeasuringPoint MeasuringPoint 2
OperationStartDate OperationStartDate 8
Plant Plant 5
SizeOrDimensionText SizeOrDimensionText 8
StorageLocation StorageLocation 3
Supplier Supplier 7
TechnicalObjectType TechnicalObjectType 12
UniqueItemIdentifier UniqueItemIdentifier 9
UniqueItemIdentifierRespPlant UniqueItemIdentifierRespPlant 4
UniqueItemIdentifierStrucType UniqueItemIdentifierStrucType 4
ValidityEndDate EquipmentValidityEndDate,ValidityEndDate 8
ValidityStartDate ValidityStartDate 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.

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

Learn More