OPACTYSFIGROUP

OPACTYSFIGROUP is an SAP database table in S/4HANA. It contains 40 fields.

Fields (40)

KeyField CDS FieldsUsed in Views
KEY OperationActivitySFIGroup OperationActivitySFIGroup 2
_OpActyInstceNtwkElmntBasic _OpActyInstceNtwkElmntBasic 1
_ProductionPlant _ProductionPlant 2
_RprstvOpActyInstance _RprstvOpActyInstance 1
_RprstvOpActyNtwkInstance _RprstvOpActyNtwkInstance 1
_SASSchema _SASSchema 2
_SASStatus _SASStatus 2
_SASStatusCategory _SASStatusCategory 2
_SASStatusText _SASStatusText 2
_ShopFloorItemStatus _ShopFloorItemStatus 2
_WorkCenterByInternalID _WorkCenterByInternalID 2
CreatedByUser CreatedByUser 2
CreationDateTime CreationDateTime 2
LaborTrackingIsRequired LaborTrackingIsRequired 1
LastChangeDateTime LastChangeDateTime 2
LastChangedByUser LastChangedByUser 2
MfgBuyOffCycleIsExisting MfgBuyOffCycleIsExisting 1
MfgWorkInstructionMode MfgWorkInstructionMode 1
NumberOfGroupedShopFloorItems NumberOfGroupedShopFloorItems 1
OpActyInspectionRelevance OpActyInspectionRelevance 1
OpActyNtwkSegmentType OpActyNtwkSegmentType 1
OpActySFIGroupName OpActySFIGroupName 2
ProductionPlant ProductionPlant 2
RepresentativeInspectionLot RepresentativeInspectionLot 1
RepresentativeShopFloorItem RepresentativeShopFloorItem 1
RprstvManufacturingOrder RprstvManufacturingOrder 1
RprstvManufacturingOrderItem RprstvManufacturingOrderItem 1
RprstvMfgOrderInternalID RprstvMfgOrderInternalID 1
RprstvMfgOrderOperation RprstvMfgOrderOperation 1
RprstvMfgOrderOpInternalID RprstvMfgOrderOpInternalID 1
RprstvOpActyNtwkElement RprstvOpActyNtwkElement 1
RprstvOpActyNtwkElmntExtID RprstvOpActyNtwkElmntExtID 1
RprstvOpActyNtwkInstance RprstvOpActyNtwkInstance 1
SASStatusCategory SASStatusCategory 2
SFIIsInactiveAtOpActy SFIIsInactiveAtOpActy 1
StatusAndActionSchema StatusAndActionSchema 2
StatusAndActionSchemaStatus StatusAndActionSchemaStatus 2
WorkCenter WorkCenter 2
WorkCenterInternalID WorkCenterInternalID 2
WorkInstructionVersionCounter WorkInstructionVersionCounter 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 OPACTYSFIGROUP (
    OPERATIONACTIVITYSFIGROUP,
    _OPACTYINSTCENTWKELMNTBASIC,
    _PRODUCTIONPLANT,
    _RPRSTVOPACTYINSTANCE,
    _RPRSTVOPACTYNTWKINSTANCE,
    _SASSCHEMA,
    _SASSTATUS,
    _SASSTATUSCATEGORY,
    _SASSTATUSTEXT,
    _SHOPFLOORITEMSTATUS,
    _WORKCENTERBYINTERNALID,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LABORTRACKINGISREQUIRED,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    MFGBUYOFFCYCLEISEXISTING,
    MFGWORKINSTRUCTIONMODE,
    NUMBEROFGROUPEDSHOPFLOORITEMS,
    OPACTYINSPECTIONRELEVANCE,
    OPACTYNTWKSEGMENTTYPE,
    OPACTYSFIGROUPNAME,
    PRODUCTIONPLANT,
    REPRESENTATIVEINSPECTIONLOT,
    REPRESENTATIVESHOPFLOORITEM,
    RPRSTVMANUFACTURINGORDER,
    RPRSTVMANUFACTURINGORDERITEM,
    RPRSTVMFGORDERINTERNALID,
    RPRSTVMFGORDEROPERATION,
    RPRSTVMFGORDEROPINTERNALID,
    RPRSTVOPACTYNTWKELEMENT,
    RPRSTVOPACTYNTWKELMNTEXTID,
    RPRSTVOPACTYNTWKINSTANCE,
    SASSTATUSCATEGORY,
    SFIISINACTIVEATOPACTY,
    STATUSANDACTIONSCHEMA,
    STATUSANDACTIONSCHEMASTATUS,
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKINSTRUCTIONVERSIONCOUNTER,
    PRIMARY KEY (OPERATIONACTIVITYSFIGROUP)
);