Fields (40)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA