_MAINTENANCEORDERCOMPONENT

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

Fields (20)

KeyField CDS FieldsUsed in Views
BaseUnit BaseUnit 3
BOMItemCategory BOMItemCategory 1
BOMItemDescription ComponentDescription 1
ComponentDescription ComponentDescription 1
FldLogsDelivIsHeldOnShore FldLogsDelivIsHeldOnShore 4
GoodsRecipientName GoodsRecipientName 1
Material Material 1
MaterialCompIsSpecialStock InventorySpecialStockType 1
MatlCompRequirementDate RequirementDate 3
OpenQuantity OpenQuantity 1
Plant Plant 1
ProjectNetwork MaintenanceOrder 2
PurchaseRequisition PurReqnAssgdToMaintOrdComp 1
PurchaseRequisitionItem PurReqnItmAssgdToMaintOrdComp 1
ReceivedQuantity ReceivedQuantity 1
RequirementQuantityInBaseUnit Quantity,RequirementQuantityInBaseUnit 3
Reservation Reservation 3
ReservationItem ReservationItem 3
UnloadingPointName UnloadingPointName 1
WBSElementInternalID WBSElementInternalID 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 _MAINTENANCEORDERCOMPONENT (
    BASEUNIT,
    BOMITEMCATEGORY,
    BOMITEMDESCRIPTION,
    COMPONENTDESCRIPTION,
    FLDLOGSDELIVISHELDONSHORE,
    GOODSRECIPIENTNAME,
    MATERIAL,
    MATERIALCOMPISSPECIALSTOCK,
    MATLCOMPREQUIREMENTDATE,
    OPENQUANTITY,
    PLANT,
    PROJECTNETWORK,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    RECEIVEDQUANTITY,
    REQUIREMENTQUANTITYINBASEUNIT,
    RESERVATION,
    RESERVATIONITEM,
    UNLOADINGPOINTNAME,
    WBSELEMENTINTERNALID
);