WORKORDER

20 Fields

WORKORDER is an SAP database table in S/4HANA. It contains 20 fields.

Fields (20)

KeyField CDS FieldsUsed in Views
KEY MaintenanceOrder MaintenanceOrder 1
KEY MaintenanceOrderComponent MaintenanceOrderComponent 1
KEY MaintenanceOrderOperation MaintenanceOrderOperation 1
BaseUnit BaseUnit 1
CompanyCode CompanyCode 1
ComponentDescription ComponentDescription 1
DocIsPurchaseReqn DocIsPurchaseReqn 1
DocIsStockTransportReqn DocIsStockTransportReqn 1
MaintenanceOrderDesc MaintenanceOrderDesc 1
MaintenanceOrderType MaintenanceOrderType 1
MaintenancePlannerGroup MaintenancePlannerGroup 1
MaintenancePlanningPlant MaintenancePlanningPlant 1
MaintenanceProcessingPhase MaintenanceProcessingPhase 1
Material Material 1
OperationDescription OperationDescription 1
PurchaseRequisition PurchaseRequisition 1
RequirementQuantityInBaseUnit RequirementQuantityInBaseUnit 1
Reservation Reservation 1
ReservationItem ReservationItem 1
WorkCenterInternalID WorkCenterInternalID 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WORKORDER (
    MAINTENANCEORDER,
    MAINTENANCEORDERCOMPONENT,
    MAINTENANCEORDEROPERATION,
    BASEUNIT,
    COMPANYCODE,
    COMPONENTDESCRIPTION,
    DOCISPURCHASEREQN,
    DOCISSTOCKTRANSPORTREQN,
    MAINTENANCEORDERDESC,
    MAINTENANCEORDERTYPE,
    MAINTENANCEPLANNERGROUP,
    MAINTENANCEPLANNINGPLANT,
    MAINTENANCEPROCESSINGPHASE,
    MATERIAL,
    OPERATIONDESCRIPTION,
    PURCHASEREQUISITION,
    REQUIREMENTQUANTITYINBASEUNIT,
    RESERVATION,
    RESERVATIONITEM,
    WORKCENTERINTERNALID,
    PRIMARY KEY (MAINTENANCEORDER, MAINTENANCEORDERCOMPONENT, MAINTENANCEORDEROPERATION)
);

Learn More