A_ProductionOrderComponent_5

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 A_ProductionOrderComponent_5.
-- 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 A_ProductionOrderComponent_5 AS
SELECT
  Reservation,
  ReservationItem,
  MaterialGroup,
  Material,
  Plant,
  ProductionOrder,
  ProductionOrderSequence,
  SequenceCategory,
  ProductionOrderOperation,
  OrderInternalID,
  OrderOperationInternalID,
  MaterialComponentText,
  MaterialComponentSecondText,
  MatlCompRequirementDate,
  MatlCompRequirementTime,
  LatestRequirementDate,
  cast( _ProductionOrder._ProductionPlant._Address.AddressTimeZone as vdm_prodnplant_tzone preserving type ) AS ProductionPlantTimeZone,
  ReservationItemCreationCode,
  ReservationIsFinallyIssued,
  MatlCompIsMarkedForDeletion,
  MaterialComponentIsMissing,
  IsBulkMaterialComponent,
  MatlCompIsMarkedForBackflush,
  MatlCompIsTextItem,
  MatlCompIsConfigurable,
  MaterialComponentIsClassified,
  MaterialCompIsIntraMaterial,
  MaterialIsDirectlyProduced,
  MaterialIsDirectlyProcured,
  MaterialPlanningRelevance,
  MaterialCompCostingRelevancy,
  RequirementType,
  SalesOrder,
  SalesOrderItem,
  ProductConfiguration,
  ChangeNumber,
  EffectivityParameterVariant,
  MatlCompFreeDefinedAttribute,
  BillOfMaterialInternalID,
  BillOfMaterialVariant,
  BillOfMaterialItemNodeNumber,
  BOMItemInternalChangeCount,
  InheritedBOMItemNode,
  BillOfMaterialItemCategory,
  BillOfMaterialItemNumber,
  PurchasingInfoRecord,
  PurchasingGroup,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  PurchaseOrder,
  PurchaseOrderItem,
  Supplier,
  DeliveryDurationInDays,
  MaterialGoodsReceiptDuration,
  GoodsMovementIsAllowed,
  StorageLocation,
  Batch,
  BatchSplitType,
  DebitCreditCode,
  GoodsMovementType,
  InventorySpecialStockType,
  InventorySpecialStockValnType,
  ConsumptionPosting,
  SupplyArea,
  GoodsRecipientName,
  UnloadingPointName,
  BusinessArea,
  GLAccount,
  FunctionalArea,
  AccountAssignmentCategory,
  MaterialCompIsVariableSized,
  cast(VariableSizeItemUnit as BT_VariableSizeItemSAPUnit preserving type) AS VariableSizeItemSAPUnit,
  cast(_VariableSizeItemUnit.UnitOfMeasureISOCode as BT_VariableSizeItemISOUnit preserving type) AS VariableSizeItemISOUnit,
  VariableSizeItemQuantity,
  cast(VariableSizeComponentUnit as BT_VariableSizeCompSAPUnit preserving type) AS VariableSizeCompSAPUnit,
  cast(_VariableSizeComponentUnit.UnitOfMeasureISOCode as BT_VariableSizeCompISOUnit preserving type) AS VariableSizeCompISOUnit,
  VariableSizeComponentQuantity,
  cast(VariableSizeDimensionUnit as BT_VariableSizeDimnSAPUnit preserving type) AS VariableSizeDimnSAPUnit,
  cast(_VariableSizeDimensionUnit.UnitOfMeasureISOCode as BT_VariableSizeDimnISOUnit preserving type) AS VariableSizeDimnISOUnit,
  VariableSizeDimension1,
  VariableSizeDimension2,
  VariableSizeDimension3,
  VariableSizeCompFormulaKey,
  MaterialComponentIsPhantomItem,
  OrderPathValue,
  OrderLevelValue,
  DiscontinuationGroup,
  MatlCompDiscontinuationType,
  MatlCompIsFollowUpMaterial,
  FollowUpGroup,
  FollowUpMaterial,
  FollowUpMaterialIsActive,
  MaterialCompIsAlternativeItem,
  AlternativeItemGroup,
  AlternativeItemStrategy,
  AlternativeItemPriority,
  UsageProbabilityPercent,
  LeadTimeOffset,
  cast(OperationLeadTimeOffsetUnit as BT_OpLeadTimeOffsetSAPUnit preserving type ) AS OpLeadTimeOffsetSAPUnit,
  cast(_OperationLeadTimeOffsetUnit.UnitOfMeasureISOCode as BT_OpLeadTimeOffsetISOUnit preserving type) AS OpLeadTimeOffsetISOUnit,
  OperationLeadTimeOffset,
  QuantityIsFixed,
  IsNetScrap,
  ComponentScrapInPercent,
  OperationScrapInPercent,
  MaterialQtyToBaseQtyNmrtr,
  MaterialQtyToBaseQtyDnmntr,
  cast( _BaseUnit.UnitOfMeasureISOCode as BT_BaseISOUnit preserving type ) AS BaseISOUnit,
  RequiredQuantity,
  WithdrawnQuantity,
  ConfirmedAvailableQuantity,
  MaterialCompOriginalQuantity,
  cast( _EntryUnit.UnitOfMeasureISOCode as BT_EntryISOUnit preserving type ) AS EntryISOUnit,
  GoodsMovementEntryQty,
  Currency,
  WithdrawnQuantityAmount
FROM R_ProductionOrderOpComponentTP
;