I_DFS_MAINTMASTEREQUIPMENT

CDS View

Interface view of Master Equipment

I_DFS_MAINTMASTEREQUIPMENT is a CDS View in S/4HANA. Interface view of Master Equipment. It contains 15 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_DFS_MaintMasterEquipDetails view from COMPOSITE Interface view of master equip details
I_FrcElmntOrgMasterEquipment view from COMPOSITE Master Equipment
I_MstrEquipUnassgdToFrcElmnt view from COMPOSITE View for Unassigned Equipment to FE
I_MstrEquipWithAuthorization view union COMPOSITE View for Master Equipment with Authzn

Fields (15)

KeyField CDS FieldsUsed in Views
KEY Equipment Equipment 3
DfsMaintActualConfiguration DfsMaintActualConfiguration,FrcElmntOrgActualConfign 2
DfsMaintEquipmentType DfsMaintEquipmentType,FrcElmntOrgEquipType 3
DfsMaintEquipOplObjNmbr DfsMaintEquipOplObjNmbr 1
DfsMaintIsForeignEquipment DfsMaintIsForeignEquipment 1
DfsMaintIsMasterEquipment DfsMaintIsMasterEquipment 1
DfsMaintMasterEquipTechObjNmbr DfsMaintMasterEquipTechObjNmbr 1
DfsMaintMeasuringPoint DfsMaintMeasuringPoint 1
DfsMaintModelIdentification DfsMaintModelIdentification,FrcElmntOrgModelIdn 2
DfsMaintPrioritizationCategory DfsMaintPrioritizationCategory 1
DfsMaintRemarkText DfsMaintRemarkText,FrcElmntOrgRemarkText 2
DfsMaintSiteID DfsMaintSiteID,FrcElmntOrgSiteID 2
DfsMaintTailNumber DfsMaintTailNumber,FrcElmntOrgTailNumber 2
DfsMaintTechStsAggrgnIsStppd DfsMaintTechStsAggrgnIsStppd 1
DfsMaintUsagePrefPriority DfsMaintUsagePrefPriority 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.

-- Interface view of Master Equipment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DFS_MAINTMASTEREQUIPMENT (
    EQUIPMENT,
    DFSMAINTACTUALCONFIGURATION,
    DFSMAINTEQUIPMENTTYPE,
    DFSMAINTEQUIPOPLOBJNMBR,
    DFSMAINTISFOREIGNEQUIPMENT,
    DFSMAINTISMASTEREQUIPMENT,
    DFSMAINTMASTEREQUIPTECHOBJNMBR,
    DFSMAINTMEASURINGPOINT,
    DFSMAINTMODELIDENTIFICATION,
    DFSMAINTPRIORITIZATIONCATEGORY,
    DFSMAINTREMARKTEXT,
    DFSMAINTSITEID,
    DFSMAINTTAILNUMBER,
    DFSMAINTTECHSTSAGGRGNISSTPPD,
    DFSMAINTUSAGEPREFPRIORITY,
    PRIMARY KEY (EQUIPMENT)
);