P_OPACTYINSTCEPLNDCOMPONENT
Planned Components at OA Instance
P_OPACTYINSTCEPLNDCOMPONENT is a CDS View in S/4HANA. Planned Components at OA Instance. It contains 76 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_OpActyInstcePlndComponent | view_entity | from | CONSUMPTION | Planned Components at OA Instance |
Fields (76)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OpActyNtwkInstance | OpActyNtwkInstance | 1 |
| KEY | Plant | Plant | 1 |
| _BillOfMaterialItem | _BillOfMaterialItem | 1 | |
| _Material | _Material | 1 | |
| _MfgOrder | _MfgOrder | 1 | |
| _MfgOrderOperation | _MfgOrderOperation | 1 | |
| _MfgRefHierItemWithDetails | _MfgRefHierItemWithDetails | 1 | |
| _MfgRefStrucItemWithDetails | _MfgRefStrucItemWithDetails | 1 | |
| _OpActyCompInstceAssignment | _OpActyCompInstceAssignment | 1 | |
| _OpActyNtwkInstance | _OpActyNtwkInstance | 1 | |
| _OpActyNtwkInstanceBasic | _OpActyNtwkInstanceBasic | 1 | |
| _OperationActivityInstance | _OperationActivityInstance | 1 | |
| _Plant | _Plant | 1 | |
| _ProductionPlant | _ProductionPlant | 1 | |
| _ProductPlant | _ProductPlant | 1 | |
| _Reservation | _Reservation | 1 | |
| _StorageLocation | _StorageLocation | 1 | |
| AlternativeItemGroup | AlternativeItemGroup | 1 | |
| Assembly | Assembly | 1 | |
| AssemblySequenceNumber | AssemblySequenceNumber | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BillOfMaterialInternalID | BillOfMaterialInternalID | 1 | |
| BillOfMaterialVariant | BillOfMaterialVariant | 1 | |
| BillOfMaterialVersion | BillOfMaterialVersion | 1 | |
| BillOfOperationsGroup | BillOfOperationsGroup | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| BOMItem | BOMItem | 1 | |
| BOMItemCategory | BOMItemCategory | 1 | |
| BOMItemInternalChangeCount | BOMItemInternalChangeCount | 1 | |
| BOOOpBOMItemInternalID | BOOOpBOMItemInternalID | 1 | |
| EffectivityParameterVariant | EffectivityParameterVariant | 1 | |
| FormulaKey | FormulaKey | 1 | |
| GoodsMovementIsAllowed | GoodsMovementIsAllowed | 1 | |
| InheritedBOMItemNode | InheritedBOMItemNode | 1 | |
| IsBatchManagementRequired | IsBatchManagementRequired | 1 | |
| IsBulkMaterialComponent | IsBulkMaterialComponent | 1 | |
| LeadingOpActyNtwkElement | LeadingOpActyNtwkElement | 1 | |
| LeadingOpActyNtwkInstance | LeadingOpActyNtwkInstance | 1 | |
| LeadingReservation | LeadingReservation | 1 | |
| LeadingReservationItem | LeadingReservationItem | 1 | |
| LeadingReservationRecordType | LeadingReservationRecordType | 1 | |
| LogicalComponent | LogicalComponent | 1 | |
| ManufacturingOrder | ManufacturingOrder | 1 | |
| MaterialCompIsAlternativeItem | MaterialCompIsAlternativeItem | 1 | |
| MaterialComponentIsMissing | MaterialComponentIsMissing | 1 | |
| MatlCompAssembleControl | MatlCompAssembleControl | 1 | |
| MatlCompDiscontinuationType | MatlCompDiscontinuationType | 1 | |
| MatlCompInstceAssyIsRequired | MatlCompInstceAssyIsRequired | 1 | |
| MatlCompIsMarkedForBackflush | MatlCompIsMarkedForBackflush | 1 | |
| MfgBOMItemIsPhantomChild | MfgBOMItemIsPhantomChild | 1 | |
| MfgOrderComponentUsageQuantity | MfgOrderComponentUsageQuantity | 1 | |
| MfgRefStrucBOMLeafAssgmtUUID | MfgRefStrucBOMLeafAssgmtUUID | 1 | |
| MfgRefStrucItmDetIsContextual | MfgRefStrucItmDetIsContextual | 1 | |
| MfgRefStrucItmRefDesignator | MfgRefStrucItmRefDesignator | 1 | |
| MfgRefStrucItmRefDsgntrName | MfgRefStrucItmRefDsgntrName | 1 | |
| MfgRefStructureItemDetailUUID | MfgRefStructureItemDetailUUID | 1 | |
| OpActyNtwkSegmentType | OpActyNtwkSegmentType | 1 | |
| OrderInternalID | OrderInternalID | 1 | |
| OrderOperationInternalID | OrderOperationInternalID | 1 | |
| ProductionPlant | ProductionPlant | 1 | |
| RelatedOpActyNtwkElement | RelatedOpActyNtwkElement | 1 | |
| RelatedOpActyNtwkInstance | RelatedOpActyNtwkInstance | 1 | |
| RelatedRecordType | RelatedRecordType | 1 | |
| RelatedReservationItem | RelatedReservationItem | 1 | |
| RequiredQuantity | RequiredQuantity | 1 | |
| ReservationIsFinallyIssued | ReservationIsFinallyIssued | 1 | |
| SerialNumberIsRqdForAssembly | SerialNumberIsRqdForAssembly | 1 | |
| SerialNumberProfile | SerialNumberProfile | 1 | |
| StockCheckMessageType | StockCheckMessageType | 1 | |
| StorageLocation | StorageLocation | 1 | |
| VariableSizeComponentQuantity | VariableSizeComponentQuantity | 1 | |
| VariableSizeComponentUnit | VariableSizeComponentUnit | 1 | |
| VariableSizeDimension1 | VariableSizeDimension1 | 1 | |
| VariableSizeDimension2 | VariableSizeDimension2 | 1 | |
| VariableSizeDimension3 | VariableSizeDimension3 | 1 | |
| VariableSizeDimensionUnit | VariableSizeDimensionUnit | 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.
-- Planned Components at OA Instance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPACTYINSTCEPLNDCOMPONENT (
OPACTYNTWKINSTANCE,
PLANT,
_BILLOFMATERIALITEM,
_MATERIAL,
_MFGORDER,
_MFGORDEROPERATION,
_MFGREFHIERITEMWITHDETAILS,
_MFGREFSTRUCITEMWITHDETAILS,
_OPACTYCOMPINSTCEASSIGNMENT,
_OPACTYNTWKINSTANCE,
_OPACTYNTWKINSTANCEBASIC,
_OPERATIONACTIVITYINSTANCE,
_PLANT,
_PRODUCTIONPLANT,
_PRODUCTPLANT,
_RESERVATION,
_STORAGELOCATION,
ALTERNATIVEITEMGROUP,
ASSEMBLY,
ASSEMBLYSEQUENCENUMBER,
BASEUNIT,
BILLOFMATERIALINTERNALID,
BILLOFMATERIALVARIANT,
BILLOFMATERIALVERSION,
BILLOFOPERATIONSGROUP,
BILLOFOPERATIONSTYPE,
BOMITEM,
BOMITEMCATEGORY,
BOMITEMINTERNALCHANGECOUNT,
BOOOPBOMITEMINTERNALID,
EFFECTIVITYPARAMETERVARIANT,
FORMULAKEY,
GOODSMOVEMENTISALLOWED,
INHERITEDBOMITEMNODE,
ISBATCHMANAGEMENTREQUIRED,
ISBULKMATERIALCOMPONENT,
LEADINGOPACTYNTWKELEMENT,
LEADINGOPACTYNTWKINSTANCE,
LEADINGRESERVATION,
LEADINGRESERVATIONITEM,
LEADINGRESERVATIONRECORDTYPE,
LOGICALCOMPONENT,
MANUFACTURINGORDER,
MATERIALCOMPISALTERNATIVEITEM,
MATERIALCOMPONENTISMISSING,
MATLCOMPASSEMBLECONTROL,
MATLCOMPDISCONTINUATIONTYPE,
MATLCOMPINSTCEASSYISREQUIRED,
MATLCOMPISMARKEDFORBACKFLUSH,
MFGBOMITEMISPHANTOMCHILD,
MFGORDERCOMPONENTUSAGEQUANTITY,
MFGREFSTRUCBOMLEAFASSGMTUUID,
MFGREFSTRUCITMDETISCONTEXTUAL,
MFGREFSTRUCITMREFDESIGNATOR,
MFGREFSTRUCITMREFDSGNTRNAME,
MFGREFSTRUCTUREITEMDETAILUUID,
OPACTYNTWKSEGMENTTYPE,
ORDERINTERNALID,
ORDEROPERATIONINTERNALID,
PRODUCTIONPLANT,
RELATEDOPACTYNTWKELEMENT,
RELATEDOPACTYNTWKINSTANCE,
RELATEDRECORDTYPE,
RELATEDRESERVATIONITEM,
REQUIREDQUANTITY,
RESERVATIONISFINALLYISSUED,
SERIALNUMBERISRQDFORASSEMBLY,
SERIALNUMBERPROFILE,
STOCKCHECKMESSAGETYPE,
STORAGELOCATION,
VARIABLESIZECOMPONENTQUANTITY,
VARIABLESIZECOMPONENTUNIT,
VARIABLESIZEDIMENSION1,
VARIABLESIZEDIMENSION2,
VARIABLESIZEDIMENSION3,
VARIABLESIZEDIMENSIONUNIT,
PRIMARY KEY (OPACTYNTWKINSTANCE, PLANT)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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