C_MatlProdnModComponentTP

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_MatlProdnModComponentTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_MatlProdnModComponentTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  ProductionModelComponentUUID,
  BillOfMaterialCategory,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfMaterialItemNodeNumber,
  EngineeringChangeDocument,
  ChgToEngineeringChgDocument,
  InheritedNodeNumberForBOMItem,
  InheritedNodeNumberVersionBOM,
  BOMItemInternalChangeCount,
  BillOfMaterialItemNumber,
  BillOfMaterialComponent,
  BillOfMaterialItemCategory,
  ComponentDescription,
  PreliminaryMaterial,
  BOMItemSorter,
  IdentifierBOMItem,
  virtual Operation : vdm_vornr AS virtualOperationvdm_vornr,
  virtual OperationText : ltxa1 AS virtualOperationTextltxa1,
  virtual BOOOperationInternalID : plnkn AS virtualBOOOperationInternalIDplnkn,
  virtual OperationActivity : mpe_oa_id AS virtualOperationActivitympe_oa_id,
  virtual BOOOpBOMItemInternalID : cim_zuord AS virtualBOOOpBOMItemInternalIDcim_zuord,
  virtual ProdnModBOMCompAssgdQuantity : kmpmg AS virtualProdnModBOMCompAssgdQuantitykmpmg,
  virtual ProdnModBOMCompAssgdQtyUnit : kmpme AS virtualProdnModBOMCompAssgdQtyUnitkmpme,
  BillOfMaterialItemQuantity,
  BillOfMaterialItemUnit,
  virtual ReferenceDesignatorValue : abap.char( 1024 ) AS char1024,
  virtual ParamEffctyParamCmSprtdStr : char255 AS virtualParamEffctyParamCmSprtdStrchar255,
  BOMItemHasFixedQuantity,
  OperationScrapInPercent,
  IsNetScrap,
  ComponentScrapInPercent,
  LeadTimeOffset,
  OperationLeadTimeOffset,
  OpsLeadTimeOffsetUnit,
  DistrKeyCompConsumption,
  IsPhantomItem,
  ExplosionType,
  SpecialProcurementType,
  AlternativeItemGroup,
  MaterialIsCoProduct,
  AlternativeItemPriority,
  IsBOMRecursiveAllowed,
  AlternativeItemStrategy,
  IsALE,
  UsageProbabilityPercent,
  ReferencePoint,
  FollowUpGroup,
  DocumentIsCreatedByCAD,
  DiscontinuationGroup,
  BOMIsRecursive,
  BOMItemDescription,
  BOMItemText2,
  IsEngineeringRelevant,
  IsProductionRelevant,
  BOMItemIsPlantMaintRelevant,
  MatlComponentSparePartType,
  BOMItemSalesRelevancy,
  MaterialCompCostingRelevancy,
  ProductIsToBeDiscontinued,
  EffectiveOutDate,
  FollowUpProduct,
  MaterialProvisionType,
  IsBulkMaterial,
  IsBulkMaterialComponent,
  ProdOrderIssueLocation,
  ProductionSupplyArea,
  Size1,
  Size2,
  Size3,
  UnitOfMeasureForSize1To3,
  FormulaKey,
  VariableSizeItemQuantity,
  VariableSizeItemUnit,
  QuantityVariableSizeItem,
  VariableSizeCompUnitOfMeasure,
  IsAssembly
FROM R_ProductionModelComponentTP
LEFT OUTER JOIN C_ProdnModCompInstcAggrgd AS _ProdnModCompInstcAggrgd ON ProductionModelUUID = _ProdnModCompInstcAggrgd.ProductionModelUUID AND BillOfOperationsVersion = _ProdnModCompInstcAggrgd.BillOfOperationsVersion AND ProductionModelComponentUUID = _ProdnModCompInstcAggrgd.ProductionModelComponentUUID  -- association [0..*]
;