C_SlsOrdProdnModComponentTP

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_SlsOrdProdnModComponentTP.
-- 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_SlsOrdProdnModComponentTP AS
SELECT
  ProductionModelUUID,
  BillOfOperationsVersion,
  ProductionModelComponentUUID,
  BillOfMaterialCategory,
  Material,
  Plant,
  BillOfMaterialVariantUsage,
  BillOfMaterial,
  BillOfOperationsType,
  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,
  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,
  MaterialProvisionType,
  IsBulkMaterial,
  IsBulkMaterialComponent,
  ProdOrderIssueLocation,
  ProductionSupplyArea,
  Size1,
  Size2,
  Size3,
  UnitOfMeasureForSize1To3,
  FormulaKey,
  VariableSizeItemQuantity,
  VariableSizeItemUnit,
  QuantityVariableSizeItem,
  VariableSizeCompUnitOfMeasure,
  IsAssembly,
  BOMItemRecordCreationDate,
  BOMItemCreatedByUser,
  BOMItemLastChangeDate,
  BOMItemLastChangedByUser,
  PurchasingOrganization,
  PurchasingGroup,
  Creditor,
  DeliveryDurationInDays,
  MaterialGroup,
  GoodsReceiptDuration,
  MaterialComponentPrice,
  Currency,
  CostElement,
  _AltItemStrategyText.AltItemStrategyDescription AS AltItemStrategyDescription,
  _BOMItemCategoryText.BillOfMaterialItemCategoryDesc AS BillOfMaterialItemCategoryDesc,
  _CostingRelevantText.CostingRelevantDescription AS CostingRelevantDescription,
  _DistrKeyText.QuantityDistributionKeyName AS QuantityDistributionKeyName,
  _ExplosionTypeText.ExplosionTypeDescription AS ExplosionTypeDescription,
  _IssueLocationText.StorageLocationName AS StorageLocationName,
  _MaterialGroupText.MaterialGroupText AS MaterialGroupText,
  _MaterialText.MaterialName AS MaterialName,
  _MatProvisionIndText.MaterialProvisionDescription AS MaterialProvisionDescription,
  _ProdSupplyAreaText.ProductionSupplyAreaName AS ProductionSupplyAreaName,
  _PurchasingGroupText.PurchasingGroupName AS PurchasingGroupName,
  _PurchasingOrgText.PurchasingOrganizationName AS PurchasingOrganizationName,
  _ReferencePointText.ReferencePointDescription AS ReferencePointDescription,
  _SalesRelevantText.SalesRelevantDescription AS SalesRelevantDescription,
  _SparePartText.SparePartDescription AS SparePartDescription,
  _SpecialProcTypeText.SpecialProcurementTypeText AS SpecialProcurementTypeText,
  _SupplierText.SupplierFullName AS SupplierFullName
FROM R_ProductionModelComponentTP
LEFT OUTER JOIN C_ProdnModCompInstcAggrgd AS _ProdnModCompInstcAggrgd ON ProductionModelUUID = _ProdnModCompInstcAggrgd.ProductionModelUUID AND BillOfOperationsVersion = _ProdnModCompInstcAggrgd.BillOfOperationsVersion AND ProductionModelComponentUUID = _ProdnModCompInstcAggrgd.ProductionModelComponentUUID  -- association [0..*]
;