R_ProductionOrderOpComponentTP

DDL: R_PRODUCTIONORDEROPCOMPONENTTP Type: view_entity TRANSACTIONAL Package: PP_PRODUCTIONORDER_RAP
133 Fields 1 Data Sources 7 Associations

Production Order Component - TP

R_ProductionOrderOpComponentTP is a Transactional CDS View that provides data about "Production Order Component - TP" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrderComponent) and exposes 133 fields with key fields Reservation, ReservationItem, ReservationRecordType. It has 7 associations to related views. Part of development package PP_PRODUCTIONORDER_RAP.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrderComponent Component from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _VariableSizeItemUnit $projection.VariableSizeItemUnit = _VariableSizeItemUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _VariableSizeComponentUnit $projection.VariableSizeComponentUnit = _VariableSizeComponentUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _VariableSizeDimensionUnit $projection.VariableSizeDimensionUnit = _VariableSizeDimensionUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _OperationLeadTimeOffsetUnit $projection.OperationLeadTimeOffsetUnit = _OperationLeadTimeOffsetUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _BaseUnit $projection.BaseUnit = _BaseUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _EntryUnit $projection.EntryUnit = _EntryUnit.UnitOfMeasure
[1..1] E_ProductionOrderComponent _Extension $projection.Reservation = _Extension.Reservation and $projection.ReservationItem = _Extension.ReservationItem and $projection.ReservationRecordType = _Extension.ReservationRecordType

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name ProductionOrderComponent view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Production Order Component - TP view

Fields (133)

KeyFieldSource TableSource FieldDescription
KEY Reservation I_ManufacturingOrderComponent Reservation Reservation
KEY ReservationItem I_ManufacturingOrderComponent ReservationItem Reservation Item
KEY ReservationRecordType I_ManufacturingOrderComponent ReservationRecordType Record type
MaterialGroup
Material
Plant
ProductionOrder
ProductionOrderSequence I_ManufacturingOrderComponent ManufacturingOrderSequence Visit Sequence
SequenceCategory I_ManufacturingOrderComponent MfgOrderSequenceCategory
ProductionOrderOperation I_ManufacturingOrderComponent ManufacturingOrderOperation Activity
OrderInternalID I_ManufacturingOrderComponent OrderInternalID Plan No.f.Oper.
OrderOperationInternalID I_ManufacturingOrderComponent OrderOperationInternalID
MatlCompRequirementDate I_ManufacturingOrderComponent MatlCompRequirementDate Reqmts date
MatlCompRequirementTime I_ManufacturingOrderComponent MatlCompRequirementTime
LatestRequirementDate I_ManufacturingOrderComponent LatestRequirementDate Latest Requirement Date
ReservationItemCreationCode I_ManufacturingOrderComponent ReservationItemCreationCode Reserv. status
ReservationIsFinallyIssued I_ManufacturingOrderComponent ReservationIsFinallyIssued Res Final Issue
MatlCompIsMarkedForDeletion I_ManufacturingOrderComponent MatlCompIsMarkedForDeletion
MaterialComponentIsMissing I_ManufacturingOrderComponent MaterialComponentIsMissing
IsBulkMaterialComponent I_ManufacturingOrderComponent IsBulkMaterialComponent Bulk material
MatlCompIsMarkedForBackflush I_ManufacturingOrderComponent MatlCompIsMarkedForBackflush Backflush
MatlCompIsTextItem I_ManufacturingOrderComponent MatlCompIsTextItem
MaterialPlanningRelevance I_ManufacturingOrderComponent MaterialPlanningRelevance
MatlCompIsConfigurable I_ManufacturingOrderComponent MatlCompIsConfigurable
MaterialCompCostingRelevancy I_ManufacturingOrderComponent MaterialCompCostingRelevancy CostingRelevncy
MaterialComponentIsClassified I_ManufacturingOrderComponent MaterialComponentIsClassified
MaterialCompIsIntraMaterial I_ManufacturingOrderComponent MaterialCompIsIntraMaterial
MaterialIsDirectlyProduced I_ManufacturingOrderComponent MaterialIsDirectlyProduced
MaterialIsDirectlyProcured I_ManufacturingOrderComponent MaterialIsDirectlyProcured
LongTextLanguage I_ManufacturingOrderComponent LongTextLanguage Long Text Lang
MaterialComponentHasLongText I_ManufacturingOrderComponent MaterialComponentHasLongText
RequirementType I_ManufacturingOrderComponent RequirementType RequirementType
SalesOrder I_ManufacturingOrderComponent SalesOrder SD Document
SalesOrderItem I_ManufacturingOrderComponent SalesOrderItem Sales Order Item
WBSElementInternalID I_ManufacturingOrderComponent WBSElementInternalID WBS Internal ID
ProductConfiguration I_ManufacturingOrderComponent ProductConfiguration
ChangeNumber I_ManufacturingOrderComponent ChangeNumber Change Number
EffectivityParameterVariant I_ManufacturingOrderComponent EffectivityParameterVariant
MatlCompFreeDefinedAttribute I_ManufacturingOrderComponent MatlCompFreeDefinedAttribute Sort String
BillOfMaterialCategory I_ManufacturingOrderComponent BillOfMaterialCategory BOM category
BillOfMaterialInternalID I_ManufacturingOrderComponent BillOfMaterialInternalID
BillOfMaterialVariant I_ManufacturingOrderComponent BillOfMaterialVariant AlternativeBOM
BillOfMaterialItemNodeNumber I_ManufacturingOrderComponent BillOfMaterialItemNodeNumber Item node
BillOfMaterialVersion I_ManufacturingOrderComponent BillOfMaterialVersion BOM Version
BOMItemInternalChangeCount I_ManufacturingOrderComponent BOMItemInternalChangeCount Counter
InheritedBOMItemNode I_ManufacturingOrderComponent InheritedBOMItemNode
BillOfMaterialItemCategory I_ManufacturingOrderComponent BillOfMaterialItemCategory Item Category
BillOfMaterialItemNumber I_ManufacturingOrderComponent BillOfMaterialItemNumber Item
MaterialComponentText I_ManufacturingOrderComponent MaterialComponentText
MaterialComponentSecondText I_ManufacturingOrderComponent MaterialComponentSecondText
BOMExplosionDateID I_ManufacturingOrderComponent BOMExplosionDateID
PurchasingInfoRecord I_ManufacturingOrderComponent PurchasingInfoRecord Info Record
PurchasingGroup I_ManufacturingOrderComponent PurchasingGroup Purchasing Group
PurchaseRequisition I_ManufacturingOrderComponent PurchaseRequisition Requisition
PurchaseRequisitionItem I_ManufacturingOrderComponent PurchaseRequisitionItem Requisn. item
PurchaseOrder I_ManufacturingOrderComponent PurchaseOrder Purchasing Document
PurchaseOrderItem I_ManufacturingOrderComponent PurchaseOrderItem Purchasing Document Item
Supplier I_ManufacturingOrderComponent Supplier Supplier
DeliveryDurationInDays I_ManufacturingOrderComponent DeliveryDurationInDays Del time (days)
MaterialGoodsReceiptDuration I_ManufacturingOrderComponent MaterialGoodsReceiptDuration GR proc. time
ExternalProcessingPrice
NumberOfOperationPriceUnits I_ManufacturingOrderComponent NumberOfOperationPriceUnits Price Unit
GoodsMovementIsAllowed I_ManufacturingOrderComponent GoodsMovementIsAllowed Mvt Allowed
StorageLocation I_ManufacturingOrderComponent StorageLocation StorageLocation
Batch
BatchSplitType I_ManufacturingOrderComponent BatchSplitType
DebitCreditCode I_ManufacturingOrderComponent DebitCreditCode Single-Character Flag
GoodsMovementType I_ManufacturingOrderComponent GoodsMovementType Movement Type
InventorySpecialStockType I_ManufacturingOrderComponent InventorySpecialStockType Special Stock Type
InventorySpecialStockValnType I_ManufacturingOrderComponent InventorySpecialStockValnType Valuation
ConsumptionPosting I_ManufacturingOrderComponent ConsumptionPosting Consumption Posting
SupplyArea I_ManufacturingOrderComponent SupplyArea Supply Area
GoodsRecipientName I_ManufacturingOrderComponent GoodsRecipientName Recipient Name
UnloadingPointName I_ManufacturingOrderComponent UnloadingPointName Unloading Point Name
StockSegment I_ManufacturingOrderComponent StockSegment Stock Segment
RequirementSegment I_ManufacturingOrderComponent RequirementSegment Req. Segment
BusinessArea I_ManufacturingOrderComponent BusinessArea Business Area
GLAccount I_ManufacturingOrderComponent GLAccount General Ledger
FunctionalArea I_ManufacturingOrderComponent FunctionalArea Sendr Fctl Area
AccountAssignmentCategory I_ManufacturingOrderComponent AccountAssignmentCategory Acct Assgmt Cat
MaterialCompIsVariableSized I_ManufacturingOrderComponent MaterialCompIsVariableSized Var-Sized Item
VariableSizeItemUnit I_ManufacturingOrderComponent VariableSizeItemUnit VSI unit
VariableSizeItemQuantity I_ManufacturingOrderComponent VariableSizeItemQuantity VSI Quantity
VariableSizeComponentUnit I_ManufacturingOrderComponent VariableSizeComponentUnit VSI UoM
VariableSizeComponentQuantity I_ManufacturingOrderComponent VariableSizeComponentQuantity VSI Quantity
VariableSizeDimensionUnit I_ManufacturingOrderComponent VariableSizeDimensionUnit Size unit
VariableSizeDimension1 I_ManufacturingOrderComponent VariableSizeDimension1 Size 1
VariableSizeDimension2 I_ManufacturingOrderComponent VariableSizeDimension2 Size 2
VariableSizeDimension3 I_ManufacturingOrderComponent VariableSizeDimension3 Size 3
VariableSizeCompFormulaKey I_ManufacturingOrderComponent VariableSizeCompFormulaKey VSI Formula
DiscontinuationGroup I_ManufacturingOrderComponent DiscontinuationGroup Discont. group
MatlCompDiscontinuationType I_ManufacturingOrderComponent MatlCompDiscontinuationType
MatlCompIsFollowUpMaterial I_ManufacturingOrderComponent MatlCompIsFollowUpMaterial
FollowUpGroup I_ManufacturingOrderComponent FollowUpGroup Follow-up group
FollowUpMaterial I_ManufacturingOrderComponent FollowUpMaterial
FollowUpMaterialIsActive I_ManufacturingOrderComponent FollowUpMaterialIsActive
MaterialCompIsAlternativeItem I_ManufacturingOrderComponent MaterialCompIsAlternativeItem
AlternativeItemGroup I_ManufacturingOrderComponent AlternativeItemGroup AltItemGroup
AlternativeItemStrategy I_ManufacturingOrderComponent AlternativeItemStrategy Strategy
AlternativeItemPriority I_ManufacturingOrderComponent AlternativeItemPriority Priority
UsageProbabilityPercent I_ManufacturingOrderComponent UsageProbabilityPercent Usage Prob.
MaterialComponentIsPhantomItem I_ManufacturingOrderComponent MaterialComponentIsPhantomItem Phantom Item
OrderPathValue I_ManufacturingOrderComponent OrderPathValue Order path
OrderLevelValue I_ManufacturingOrderComponent OrderLevelValue Order level
MaterialProvisionType I_ManufacturingOrderComponent MaterialProvisionType Material Provision Type
MatlComponentSparePartType I_ManufacturingOrderComponent MatlComponentSparePartType Spare Part ID
LeadTimeOffset I_ManufacturingOrderComponent LeadTimeOffset Lead-tm offset
OperationLeadTimeOffsetUnit I_ManufacturingOrderComponent OperationLeadTimeOffsetUnit
OperationLeadTimeOffset I_ManufacturingOrderComponent OperationLeadTimeOffset Oper. LT offset
QuantityIsFixed I_ManufacturingOrderComponent QuantityIsFixed Qty. is fixed
IsNetScrap I_ManufacturingOrderComponent IsNetScrap Net Indicator
ComponentScrapInPercent I_ManufacturingOrderComponent ComponentScrapInPercent Component Scrap
OperationScrapInPercent I_ManufacturingOrderComponent OperationScrapInPercent Operation Scrap
MaterialQtyToBaseQtyNmrtr I_ManufacturingOrderComponent MaterialQtyToBaseQtyNmrtr Numerator
MaterialQtyToBaseQtyDnmntr I_ManufacturingOrderComponent MaterialQtyToBaseQtyDnmntr Denominator
BaseUnit I_ManufacturingOrderComponent BaseUnit Unit of Measure
RequiredQuantity I_ManufacturingOrderComponent RequiredQuantity Requirement qty
WithdrawnQuantity I_ManufacturingOrderComponent WithdrawnQuantity Withdrawn Quantity
ConfirmedAvailableQuantity I_ManufacturingOrderComponent ConfirmedAvailableQuantity Available Quantity
MaterialCompOriginalQuantity I_ManufacturingOrderComponent MaterialCompOriginalQuantity
EntryUnit I_ManufacturingOrderComponent EntryUnit Unit of Entry
GoodsMovementEntryQty I_ManufacturingOrderComponent GoodsMovementEntryQty
Currency I_ManufacturingOrderComponent Currency Valuation Crcy
WithdrawnQuantityAmount I_ManufacturingOrderComponent WithdrawnQuantityAmount
_ProductionOrder _ProductionOrder
_VariableSizeItemUnit _VariableSizeItemUnit
_VariableSizeComponentUnit _VariableSizeComponentUnit
_VariableSizeDimensionUnit _VariableSizeDimensionUnit
_OperationLeadTimeOffsetUnit _OperationLeadTimeOffsetUnit
_BaseUnit _BaseUnit
_EntryUnit _EntryUnit
_Supplier I_ManufacturingOrderComponent _Supplier
_SupplierCompanyByPlant I_ManufacturingOrderComponent _SupplierCompanyByPlant

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 R_ProductionOrderOpComponentTP.
-- 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 R_ProductionOrderOpComponentTP AS
SELECT
  Component.Reservation AS Reservation,
  Component.ReservationItem AS ReservationItem,
  Component.ReservationRecordType AS ReservationRecordType,
  cast(Component.MaterialGroup as matkl preserving type ) AS MaterialGroup,
  cast(Component.Material as matnr preserving type ) AS Material,
  cast(Component.Plant as werks_d preserving type ) AS Plant,
  cast(Component.ManufacturingOrder as vdm_manufacturingorder preserving type) AS ProductionOrder,
  Component.ManufacturingOrderSequence AS ProductionOrderSequence,
  Component.MfgOrderSequenceCategory AS SequenceCategory,
  Component.ManufacturingOrderOperation AS ProductionOrderOperation,
  Component.OrderInternalID AS OrderInternalID,
  Component.OrderOperationInternalID AS OrderOperationInternalID,
  Component.MatlCompRequirementDate AS MatlCompRequirementDate,
  Component.MatlCompRequirementTime AS MatlCompRequirementTime,
  Component.LatestRequirementDate AS LatestRequirementDate,
  Component.ReservationItemCreationCode AS ReservationItemCreationCode,
  Component.ReservationIsFinallyIssued AS ReservationIsFinallyIssued,
  Component.MatlCompIsMarkedForDeletion AS MatlCompIsMarkedForDeletion,
  Component.MaterialComponentIsMissing AS MaterialComponentIsMissing,
  Component.IsBulkMaterialComponent AS IsBulkMaterialComponent,
  Component.MatlCompIsMarkedForBackflush AS MatlCompIsMarkedForBackflush,
  Component.MatlCompIsTextItem AS MatlCompIsTextItem,
  Component.MaterialPlanningRelevance AS MaterialPlanningRelevance,
  Component.MatlCompIsConfigurable AS MatlCompIsConfigurable,
  Component.MaterialCompCostingRelevancy AS MaterialCompCostingRelevancy,
  Component.MaterialComponentIsClassified AS MaterialComponentIsClassified,
  Component.MaterialCompIsIntraMaterial AS MaterialCompIsIntraMaterial,
  Component.MaterialIsDirectlyProduced AS MaterialIsDirectlyProduced,
  Component.MaterialIsDirectlyProcured AS MaterialIsDirectlyProcured,
  Component.LongTextLanguage AS LongTextLanguage,
  Component.MaterialComponentHasLongText AS MaterialComponentHasLongText,
  Component.RequirementType AS RequirementType,
  Component.SalesOrder AS SalesOrder,
  Component.SalesOrderItem AS SalesOrderItem,
  Component.WBSElementInternalID AS WBSElementInternalID,
  Component.ProductConfiguration AS ProductConfiguration,
  Component.ChangeNumber AS ChangeNumber,
  Component.EffectivityParameterVariant AS EffectivityParameterVariant,
  Component.MatlCompFreeDefinedAttribute AS MatlCompFreeDefinedAttribute,
  Component.BillOfMaterialCategory AS BillOfMaterialCategory,
  Component.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  Component.BillOfMaterialVariant AS BillOfMaterialVariant,
  Component.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  Component.BillOfMaterialVersion AS BillOfMaterialVersion,
  Component.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  Component.InheritedBOMItemNode AS InheritedBOMItemNode,
  Component.BillOfMaterialItemCategory AS BillOfMaterialItemCategory,
  Component.BillOfMaterialItemNumber AS BillOfMaterialItemNumber,
  Component.MaterialComponentText AS MaterialComponentText,
  Component.MaterialComponentSecondText AS MaterialComponentSecondText,
  Component.BOMExplosionDateID AS BOMExplosionDateID,
  Component.PurchasingInfoRecord AS PurchasingInfoRecord,
  Component.PurchasingGroup AS PurchasingGroup,
  Component.PurchaseRequisition AS PurchaseRequisition,
  Component.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Component.PurchaseOrder AS PurchaseOrder,
  Component.PurchaseOrderItem AS PurchaseOrderItem,
  Component.Supplier AS Supplier,
  Component.DeliveryDurationInDays AS DeliveryDurationInDays,
  Component.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  Component.NumberOfOperationPriceUnits AS NumberOfOperationPriceUnits,
  Component.GoodsMovementIsAllowed AS GoodsMovementIsAllowed,
  Component.StorageLocation AS StorageLocation,
  cast(Component.Batch as charg_d preserving type ) AS Batch,
  Component.BatchSplitType AS BatchSplitType,
  Component.DebitCreditCode AS DebitCreditCode,
  Component.GoodsMovementType AS GoodsMovementType,
  Component.InventorySpecialStockType AS InventorySpecialStockType,
  Component.InventorySpecialStockValnType AS InventorySpecialStockValnType,
  Component.ConsumptionPosting AS ConsumptionPosting,
  Component.SupplyArea AS SupplyArea,
  Component.GoodsRecipientName AS GoodsRecipientName,
  Component.UnloadingPointName AS UnloadingPointName,
  Component.StockSegment AS StockSegment,
  Component.RequirementSegment AS RequirementSegment,
  Component.BusinessArea AS BusinessArea,
  Component.GLAccount AS GLAccount,
  Component.FunctionalArea AS FunctionalArea,
  Component.AccountAssignmentCategory AS AccountAssignmentCategory,
  Component.MaterialCompIsVariableSized AS MaterialCompIsVariableSized,
  Component.VariableSizeItemUnit AS VariableSizeItemUnit,
  Component.VariableSizeItemQuantity AS VariableSizeItemQuantity,
  Component.VariableSizeComponentUnit AS VariableSizeComponentUnit,
  Component.VariableSizeComponentQuantity AS VariableSizeComponentQuantity,
  Component.VariableSizeDimensionUnit AS VariableSizeDimensionUnit,
  Component.VariableSizeDimension1 AS VariableSizeDimension1,
  Component.VariableSizeDimension2 AS VariableSizeDimension2,
  Component.VariableSizeDimension3 AS VariableSizeDimension3,
  Component.VariableSizeCompFormulaKey AS VariableSizeCompFormulaKey,
  Component.DiscontinuationGroup AS DiscontinuationGroup,
  Component.MatlCompDiscontinuationType AS MatlCompDiscontinuationType,
  Component.MatlCompIsFollowUpMaterial AS MatlCompIsFollowUpMaterial,
  Component.FollowUpGroup AS FollowUpGroup,
  Component.FollowUpMaterial AS FollowUpMaterial,
  Component.FollowUpMaterialIsActive AS FollowUpMaterialIsActive,
  Component.MaterialCompIsAlternativeItem AS MaterialCompIsAlternativeItem,
  Component.AlternativeItemGroup AS AlternativeItemGroup,
  Component.AlternativeItemStrategy AS AlternativeItemStrategy,
  Component.AlternativeItemPriority AS AlternativeItemPriority,
  Component.UsageProbabilityPercent AS UsageProbabilityPercent,
  Component.MaterialComponentIsPhantomItem AS MaterialComponentIsPhantomItem,
  Component.OrderPathValue AS OrderPathValue,
  Component.OrderLevelValue AS OrderLevelValue,
  Component.MaterialProvisionType AS MaterialProvisionType,
  Component.MatlComponentSparePartType AS MatlComponentSparePartType,
  Component.LeadTimeOffset AS LeadTimeOffset,
  Component.OperationLeadTimeOffsetUnit AS OperationLeadTimeOffsetUnit,
  Component.OperationLeadTimeOffset AS OperationLeadTimeOffset,
  Component.QuantityIsFixed AS QuantityIsFixed,
  Component.IsNetScrap AS IsNetScrap,
  Component.ComponentScrapInPercent AS ComponentScrapInPercent,
  Component.OperationScrapInPercent AS OperationScrapInPercent,
  Component.MaterialQtyToBaseQtyNmrtr AS MaterialQtyToBaseQtyNmrtr,
  Component.MaterialQtyToBaseQtyDnmntr AS MaterialQtyToBaseQtyDnmntr,
  Component.BaseUnit AS BaseUnit,
  Component.RequiredQuantity AS RequiredQuantity,
  Component.WithdrawnQuantity AS WithdrawnQuantity,
  Component.ConfirmedAvailableQuantity AS ConfirmedAvailableQuantity,
  Component.MaterialCompOriginalQuantity AS MaterialCompOriginalQuantity,
  Component.EntryUnit AS EntryUnit,
  Component.GoodsMovementEntryQty AS GoodsMovementEntryQty,
  Component.Currency AS Currency,
  Component.WithdrawnQuantityAmount AS WithdrawnQuantityAmount,
  Component._Supplier AS _Supplier,
  Component._SupplierCompanyByPlant AS _SupplierCompanyByPlant
FROM I_ManufacturingOrderComponent AS Component
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeItemUnit ON VariableSizeItemUnit = _VariableSizeItemUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeComponentUnit ON VariableSizeComponentUnit = _VariableSizeComponentUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeDimensionUnit ON VariableSizeDimensionUnit = _VariableSizeDimensionUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationLeadTimeOffsetUnit ON OperationLeadTimeOffsetUnit = _OperationLeadTimeOffsetUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON EntryUnit = _EntryUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_ProductionOrderComponent AS _Extension ON Reservation = _Extension.Reservation AND ReservationItem = _Extension.ReservationItem AND ReservationRecordType = _Extension.ReservationRecordType  -- association [1..1]
;

Learn More