_REVISION

_REVISION is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY MaintenanceRevision MaintenanceRevision 2
DfsMaintEquipmentUtilizerID DfsMaintEquipmentUtilizerID 2
DfsMaintExplosionType DfsMaintExplosionType 2
DfsMaintFunctionalLocation DfsMaintFunctionalLocation 1
DfsMaintRevisionObjectNumber DfsMaintRevisionObjectNumber 2
DfsMaintRevisionPlant DfsMaintRevisionPlant 2
DfsMaintRevisionSystStsName DfsMaintRevisionSystStsName 2
DfsMaintRevisionType DfsMaintRevisionType 2
DfsMaintRevisionUsrStsShrtName DfsMaintRevisionUsrStsShrtName 2
DfsMaintRevisionWBSElement DfsMaintRevisionWBSElement 2
DfsMaintRevisionWorkCenter DfsMaintRevisionWorkCenter 2
EquipmentName EquipmentName 2
FSItemMappingRevisionText FSItemMappingRevisionText 2
FunctionalLocationName FunctionalLocationName 2
MaintenancePlanningPlant MaintenancePlanningPlant 2
MaintenanceRevisionDesc MaintenanceRevisionDesc 2
RevisionEndDate RevisionEndDate 2
RevisionEndTime RevisionEndTime 2
RevisionStartDate RevisionStartDate 2
RevisionStartTime RevisionStartTime 2
WBSDescription WBSDescription 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _REVISION (
    MAINTENANCEREVISION,
    DFSMAINTEQUIPMENTUTILIZERID,
    DFSMAINTEXPLOSIONTYPE,
    DFSMAINTFUNCTIONALLOCATION,
    DFSMAINTREVISIONOBJECTNUMBER,
    DFSMAINTREVISIONPLANT,
    DFSMAINTREVISIONSYSTSTSNAME,
    DFSMAINTREVISIONTYPE,
    DFSMAINTREVISIONUSRSTSSHRTNAME,
    DFSMAINTREVISIONWBSELEMENT,
    DFSMAINTREVISIONWORKCENTER,
    EQUIPMENTNAME,
    FSITEMMAPPINGREVISIONTEXT,
    FUNCTIONALLOCATIONNAME,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEREVISIONDESC,
    REVISIONENDDATE,
    REVISIONENDTIME,
    REVISIONSTARTDATE,
    REVISIONSTARTTIME,
    WBSDESCRIPTION,
    PRIMARY KEY (MAINTENANCEREVISION)
);