P_OPACTYINSTCEPLNDCOMPDSASSY
Plnd Comps for Disassembly at OA Instnce
P_OPACTYINSTCEPLNDCOMPDSASSY is a CDS View in S/4HANA. Plnd Comps for Disassembly at OA Instnce. It contains 58 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_OpActyInstcePlndCompDsassy | view_entity | from | CONSUMPTION | Plnd Dassy Components at OA Instance |
Fields (58)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OpActyNtwkInstance | OpActyNtwkInstance | 1 |
| KEY | Plant | Plant | 1 |
| _MfgRefHierItemWithDetails | _MfgRefHierItemWithDetails | 1 | |
| _MfgRefStrucItemWithDetails | _MfgRefStrucItemWithDetails | 1 | |
| _OpActyNtwkInstanceBasic | _OpActyNtwkInstanceBasic | 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 | |
| MatlCompAssembleControl | MatlCompAssembleControl | 1 | |
| MatlCompAssemblyIsNotRequired | MatlCompAssemblyIsNotRequired | 1 | |
| MatlCompDiscontinuationType | MatlCompDiscontinuationType | 1 | |
| MatlCompInstceAssyIsRequired | MatlCompInstceAssyIsRequired | 1 | |
| MfgBOMItemIsPhantomChild | MfgBOMItemIsPhantomChild | 1 | |
| MfgOrderComponentUsageQuantity | MfgOrderComponentUsageQuantity | 1 | |
| MfgRefStrucBOMLeafAssgmtUUID | MfgRefStrucBOMLeafAssgmtUUID | 1 | |
| MfgRefStrucItmDetIsContextual | MfgRefStrucItmDetIsContextual | 1 | |
| MfgRefStrucItmRefDesignator | MfgRefStrucItmRefDesignator | 1 | |
| MfgRefStrucItmRefDsgntrName | MfgRefStrucItmRefDsgntrName | 1 | |
| MfgRefStructureItemDetailUUID | MfgRefStructureItemDetailUUID | 1 | |
| PlannedInventoryUsabilityCode | PlannedInventoryUsabilityCode | 1 | |
| ProductionPlant | ProductionPlant | 1 | |
| RelatedOpActyNtwkElement | RelatedOpActyNtwkElement | 1 | |
| RelatedOpActyNtwkInstance | RelatedOpActyNtwkInstance | 1 | |
| RelatedRecordType | RelatedRecordType | 1 | |
| RelatedReservationItem | RelatedReservationItem | 1 | |
| RequiredQuantity | RequiredQuantity | 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.
-- Plnd Comps for Disassembly at OA Instnce
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_OPACTYINSTCEPLNDCOMPDSASSY (
OPACTYNTWKINSTANCE,
PLANT,
_MFGREFHIERITEMWITHDETAILS,
_MFGREFSTRUCITEMWITHDETAILS,
_OPACTYNTWKINSTANCEBASIC,
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,
MATLCOMPASSEMBLECONTROL,
MATLCOMPASSEMBLYISNOTREQUIRED,
MATLCOMPDISCONTINUATIONTYPE,
MATLCOMPINSTCEASSYISREQUIRED,
MFGBOMITEMISPHANTOMCHILD,
MFGORDERCOMPONENTUSAGEQUANTITY,
MFGREFSTRUCBOMLEAFASSGMTUUID,
MFGREFSTRUCITMDETISCONTEXTUAL,
MFGREFSTRUCITMREFDESIGNATOR,
MFGREFSTRUCITMREFDSGNTRNAME,
MFGREFSTRUCTUREITEMDETAILUUID,
PLANNEDINVENTORYUSABILITYCODE,
PRODUCTIONPLANT,
RELATEDOPACTYNTWKELEMENT,
RELATEDOPACTYNTWKINSTANCE,
RELATEDRECORDTYPE,
RELATEDRESERVATIONITEM,
REQUIREDQUANTITY,
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