I_MfgOrderOperationComponent

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 I_MfgOrderOperationComponent.
-- 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.
-- SQL view name: IPPMFGORDOPCOMP

CREATE VIEW I_MfgOrderOperationComponent AS
SELECT
  resb.rsnum AS Reservation,
  cast(resb.rspos as pph_rspos preserving type) AS ReservationItem,
  cast(resb.rsart as pph_rsart preserving type) AS RecordType,
  resb.matkl AS MaterialGroup,
  resb.matnr AS Material,
  resb.werks AS Plant,
  cast(resb.autyp as manufacturingordercategory preserving type) AS ManufacturingOrderCategory,
  cast(resb.auart as manufacturingordertype preserving type) AS ManufacturingOrderType,
  cast(resb.aufnr as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(resb.flgat as folgenart preserving type) AS MfgOrderSequenceCategory,
  cast(resb.vornr as manufacturingorderoperation preserving type) AS ManufacturingOrderOperation,
  cast(resb.vornr as vdm_vornr preserving type) AS ManufacturingOrderOperation_2,
  cast(resb.pwerk as pwwrk preserving type) AS ProductionPlant,
  cast(resb.aufpl as pph_aufpl preserving type) AS OrderInternalBillOfOperations,
  cast(resb.aplzl as operationinternalid preserving type) AS OrderIntBillOfOperationsItem,
  cast(resb.dispo as assymrpcontrl preserving type) AS AssemblyMRPController,
  cast(resb.fevor as pph_fevor preserving type) AS ProductionSupervisor,
  resb.OrderObjectInternalID AS OrderObjectInternalID,
  cast(resb.bdter as pph_bdter preserving type) AS MatlCompRequirementDate,
  cast(resb.bdztp as pph_bdztp preserving type) AS MatlCompRequirementTime,
  cast(resb.sbter as pph_sbter preserving type) AS LatestRequirementDate,
  cast(resb.ftrmi as mfgorderactualreleasedate preserving type) AS MfgOrderActualReleaseDate,
  cast(resb.rssta as pph_rssta preserving type) AS ReservationItemCreationCode,
  resb.kzear AS ReservationIsFinallyIssued,
  cast(resb.xloek as pph_xloek preserving type) AS MatlCompIsMarkedForDeletion,
  resb.xfehl AS MaterialComponentIsMissing,
  resb.schgt AS IsBulkMaterialComponent,
  resb.rgekz AS MatlCompIsMarkedForBackflush,
  resb.txtps AS MatlCompIsTextItem,
  cast(resb.no_disp as vdm_no_disp preserving type) AS MaterialPlanningRelevance,
  resb.kfpos AS MatlCompIsConfigurable,
  resb.clakz AS MaterialComponentIsClassified,
  resb.inpos AS MaterialCompIsIntraMaterial,
  resb.ltxsp AS LongTextLanguageCode,
  cast(resb.bdart as pph_bdart preserving type) AS RequirementType,
  cast(resb.kdauf as co_kdauf preserving type) AS SalesOrder,
  cast(resb.kdpos as co_kdpos preserving type) AS SalesOrderItem,
  cast(resb.pspel as pph_pspel preserving type) AS WBSElementInternalID,
  cast(resb.pspel as ps_s4_pspnr preserving type) AS WBSElementInternalID_2,
  resb.cuobj AS ProductConfiguration,
  resb.aennr AS ChangeNumber,
  cast(resb.revlv as vdm_qm_revlv preserving type) AS MaterialRevisionLevel,
  resb.techs AS EffectivityParameterVariant,
  resb.sortf AS SortField,
  resb.sortf AS MaterialComponentSortText,
  resb.objnr AS ObjectInternalID,
  cast(resb.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  resb.stlnr AS BillOfMaterialInternalID,
  cast(resb.stlnr as pph_stnum preserving type) AS BillOfMaterialInternalID_2,
  resb.stlan AS BillOfMaterialVariantUsage,
  resb.stlal AS BillOfMaterialVariant,
  resb.stlnr2 AS BillOfMaterial,
  cast(resb.stlkn as pph_stlkn preserving type) AS BOMItem,
  resb.bom_versn AS BillOfMaterialVersion,
  resb.stpoz AS BOMItemInternalChangeCount,
  resb.stvkn AS InheritedBOMItemNode,
  cast(resb.postp as pph_postp preserving type) AS BOMItemCategory,
  resb.posnr AS BillOfMaterialItemNumber,
  cast(resb.posnr as vdm_sposn preserving type) AS BillOfMaterialItemNumber_2,
  resb.potx1 AS BOMItemDescription,
  resb.potx2 AS BOMItemText2,
  cast(resb.sernr as pph_sernr preserving type) AS BOMExplosionDateID,
  cast(resb.infnr as pph_infnr preserving type) AS PurchasingInfoRecord,
  cast(resb.ekgrp as pph_ekgrp preserving type) AS PurchasingGroup,
  resb.lifnr AS Supplier,
  cast(resb.lifzt as pph_lifzt preserving type) AS DeliveryDurationInDays,
  cast(resb.webaz as pph_webaz preserving type) AS MaterialGoodsReceiptDuration,
  cast(resb.peinh as pph_peinh preserving type) AS NumberOfOperationPriceUnits,
  resb.xwaok AS GoodsMovementIsAllowed,
  cast(resb.lgort as pph_lgort preserving type) AS StorageLocation,
  cast(resb.shkzg as pph_shkzg preserving type) AS DebitCreditCode,
  resb.bwart AS GoodsMovementType,
  cast(resb.sobkz as inventoryspecialstocktype preserving type) AS InventorySpecialStockType,
  cast(resb.kzbws as pph_kzbws preserving type) AS InventorySpecialStockValnType,
  cast(resb.kzvbr as pph_kzvbr preserving type) AS ConsumptionPosting,
  cast(resb.prvbe as pph_prvbe preserving type) AS SupplyArea,
  cast(resb.wempf as pph_wempf preserving type) AS GoodsRecipientName,
  resb.ablad AS UnloadingPointName,
  resb.sgt_scat AS StockSegment,
  resb.sgt_rcat AS RequirementSegment,
  resb.charg AS Batch,
  resb.splkz AS BatchSplitType,
  resb.chobj AS BatchClassification,
  resb.berkz AS MaterialStaging,
  resb.lgnum AS Warehouse,
  resb.lgtyp AS StorageType,
  resb.lgpla AS StorageBin,
  resb.sanka AS MaterialCompIsCostRelevant,
  resb.gsber AS BusinessArea,
  resb.bukrs AS CompanyCode,
  resb.saknr AS GLAccount,
  resb.fkber AS FunctionalArea,
  resb.kokrs AS ControllingArea,
  cast(resb.knttp as pph_knttp preserving type) AS AccountAssignmentCategory,
  cast(resb.fipos as bbpfipos preserving type) AS CommitmentItem,
  cast(resb.fipos as fmis_ci_internalname preserving type) AS CommitmentItemShortID,
  cast(resb.fistl as bbpfistl preserving type) AS FundsCenter,
  resb.rohps AS MaterialCompIsVariableSized,
  cast(resb.roanz as pph_roanz preserving type) AS NumberOfVariableSizeComponents,
  cast(resb.roanz as pph_roanz preserving type) AS VariableSizeItemQuantity,
  cast(resb.romen as pph_romen preserving type) AS VariableSizeComponentQuantity,
  resb.roms1 AS VariableSizeDimension1,
  resb.roms2 AS VariableSizeDimension2,
  resb.roms3 AS VariableSizeDimension3,
  resb.rform AS FormulaKey,
  resb.alpos AS MaterialCompIsAlternativeItem,
  cast(resb.alpgr as pph_alpgr preserving type) AS AlternativeItemGroup,
  cast(resb.alpst as pph_alpst preserving type) AS AlternativeItemStrategy,
  cast(resb.alprf as pph_alprf preserving type) AS AlternativeItemPriority,
  resb.ewahr AS UsageProbabilityPercent,
  cast(resb.dumps as pph_dumps preserving type) AS MaterialComponentIsPhantomItem,
  resb.aufwg AS OrderPathValue,
  resb.aufst AS OrderLevelValue,
  resb.baugr AS Assembly,
  resb.bauwg AS AssemblyOrderPathValue,
  resb.baust AS AssemblyOrderLevelValue,
  cast(resb.nfeag as pph_nfeag preserving type) AS DiscontinuationGroup,
  resb.kzaus AS MatlCompDiscontinuationType,
  cast(resb.nfpkz as pph_kznfp preserving type) AS MatlCompIsFollowUpMaterial,
  cast(resb.nfgrp as pph_nfgrp preserving type) AS FollowUpGroup,
  cast(resb.nomat as pph_nomat preserving type) AS FollowUpMaterial,
  cast(resb.nafkz as pph_nafkz preserving type) AS FollowUpMaterialIsNotActive,
  cast(resb.nafkz as pph_nafkz preserving type) AS FollowUpMaterialIsActive,
  cast(resb.beikz as vdm_beikz preserving type) AS MaterialProvisionType,
  cast(resb.erskz as vdm_erskz preserving type) AS MatlComponentSparePartType,
  cast(resb.nlfzt as pph_nlfzt preserving type) AS LeadTimeOffset,
  cast(resb.nlfmv as pph_nlfmv preserving type) AS OperationLeadTimeOffsetUnit,
  cast(resb.nlfzv as pph_nlfzv preserving type) AS OperationLeadTimeOffset,
  resb.fmeng AS QuantityIsFixed,
  resb.netau AS IsNetScrap,
  resb.ausch AS ComponentScrapInPercent,
  resb.avoau AS OperationScrapInPercent,
  resb.umrez AS MaterialQtyToBaseQtyNmrtr,
  resb.umren AS MaterialQtyToBaseQtyDnmntr,
  resb.bdmng AS RequiredQuantity,
  cast(resb.enmng as pph_enmng preserving type) AS WithdrawnQuantity,
  cast(resb.vmeng as pph_vmeng preserving type) AS ConfirmedAvailableQuantity,
  cast(resb.nomng as pph_nomng preserving type) AS MaterialCompOriginalQuantity,
  cast(resb.erfmg as pph_erfmg preserving type) AS GoodsMovementEntryQty,
  resb.waers AS Currency,
  resb.enwrt AS WithdrawnQuantityAmount,
  fsh_critical_comp AS CriticalComponentType,
  fsh_critical_level AS CriticalComponentLevel
FROM P_MfgOrderOpReservationItem AS resb
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation.Reservation  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND RecordType = _ReservationItem.RecordType  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationDocRecordType ON RecordType = _ReservationDocRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrderSequence AS _ManufacturingOrderSequence ON ManufacturingOrder = _ManufacturingOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _ManufacturingOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderSequence.ManufacturingOrderSequence  -- association [1..1]
LEFT OUTER JOIN I_SequenceCategory AS _MfgOrderSequenceCategory ON MfgOrderSequenceCategory = _MfgOrderSequenceCategory.SequenceCategory  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOperationBasic AS _MfgOrderOperation ON OrderInternalBillOfOperations = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderIntBillOfOperationsItem = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemanKey AS _MfgOrderOperationBySemanKey ON ManufacturingOrder = _MfgOrderOperationBySemanKey.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperationBySemanKey.ManufacturingOrderSequence AND ManufacturingOrderOperation = _MfgOrderOperationBySemanKey.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBySemKey AS _MfgOrderOperationBySemKey ON ManufacturingOrder = _MfgOrderOperationBySemKey.ManufacturingOrder AND ManufacturingOrderSequence = _MfgOrderOperationBySemKey.ManufacturingOrderSequence AND ManufacturingOrderOperation_2 = _MfgOrderOperationBySemKey.ManufacturingOrderOperation  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrdInternalBillOfOperations ON OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_MaterialRequirementType AS _RequirementType ON RequirementType = _RequirementType.RequirementType  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant2 ON Material = _ProductPlant2.Product AND Plant = _ProductPlant2.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND Plant = _ProductSupplyPlanning.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductStorageLocation AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND Plant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageLocationBasic AS _ProductStorageLocation2 ON Material = _ProductStorageLocation2.Product AND Plant = _ProductStorageLocation2.Plant AND StorageLocation = _ProductStorageLocation2.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Material = _ProductUnitsOfMeasure.Product  -- association [1..*]
LEFT OUTER JOIN I_MRPController AS _AssemblyMRPController ON Plant = _AssemblyMRPController.Plant AND AssemblyMRPController = _AssemblyMRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON Plant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData2 ON WBSElementInternalID_2 = _WBSElementBasicData2.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_EnterpriseProjectElement AS _EnterpriseProjectElement ON WBSElementInternalID_2 = _EnterpriseProjectElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_BOMExplosionDate AS _BOMExplosion ON BOMExplosionDateID = _BOMExplosion.BOMExplosionDateID  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemBasic AS _BillOfMaterialItem ON BillOfMaterialCategory = _BillOfMaterialItem.BillOfMaterialCategory AND BillOfMaterial = _BillOfMaterialItem.BillOfMaterial AND BOMItem = _BillOfMaterialItem.BillOfMaterialItemNodeNumber AND BOMItemInternalChangeCount = _BillOfMaterialItem.BOMItemInternalChangeCount  -- association [0..1]
LEFT OUTER JOIN I_BillOfMaterialItemCategory AS _BOMItemCategory ON BOMItemCategory = _BOMItemCategory.BillOfMaterialItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecordApi01 AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderAPI01 AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItemAPI01 AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisition AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisition_Api01 AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemAPI01 AS _PurchaseRequisitionItem2 ON PurchaseRequisition = _PurchaseRequisitionItem2.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem2.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompanyByPlant AS _SupplierCompanyByPlant ON Plant = _SupplierCompanyByPlant.Plant AND Supplier = _SupplierCompanyByPlant.Supplier  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..*]
LEFT OUTER JOIN I_BatchSplitType AS _BatchSplitType ON BatchSplitType= _BatchSplitType.BatchSplitType  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [1..1]
LEFT OUTER JOIN I_InventorySpecialStockType AS _InventorySpecialStockType ON InventorySpecialStockType = _InventorySpecialStockType.InventorySpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_InvtrySpecialStockValnType AS _InventorySpecialStockValnType ON InventorySpecialStockValnType = _InventorySpecialStockValnType.InventorySpecialStockValnType  -- association [0..1]
LEFT OUTER JOIN I_ConsumptionPosting AS _ConsumptionPosting ON ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _SupplyArea ON Plant = _SupplyArea.Plant AND SupplyArea = _SupplyArea.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_Warehouse AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_Product AS _PhantomAssembly ON Assembly = _PhantomAssembly.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _FollowUpMaterial ON FollowUpMaterial = _FollowUpMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_MatlCompDiscontinuationType AS _MatlCompDiscontinuationType ON MatlCompDiscontinuationType = _MatlCompDiscontinuationType.MatlCompDiscontinuationType  -- association [0..1]
LEFT OUTER JOIN I_MatlCompProvisionType AS _ProvisionType ON MaterialProvisionType = _ProvisionType.MaterialProvisionType  -- association [0..1]
LEFT OUTER JOIN I_MatlCompSparePartType AS _SparePartType ON MatlComponentSparePartType = _SparePartType.MatlComponentSparePartType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemShortID AS _CommitmentItemShortID ON CommitmentItemShortID = _CommitmentItemShortID.CommitmentItemShortID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OpLeadTimeOffsetUnit ON OperationLeadTimeOffsetUnit = _OpLeadTimeOffsetUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeItemUnit ON VariableSizeItemUnit = _VariableSizeItemUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeCompUnit ON VariableSizeComponentUnit = _VariableSizeCompUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeDimensionUnit ON VariableSizeDimensionUnit = _VariableSizeDimensionUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EntryUnit ON EntryUnit = _EntryUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _StatusObject ON ObjectInternalID = _StatusObject.StatusObject  -- association [1..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguageCode = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_OrderComponentLongText AS _LongText ON Reservation = _LongText.Reservation AND ReservationItem = _LongText.ReservationItem AND RecordType = _LongText.RecordType  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderComponentLongText AS _MfgOrderComponentLongText ON Reservation = _MfgOrderComponentLongText.Reservation AND ReservationItem = _MfgOrderComponentLongText.ReservationItem AND RecordType = _MfgOrderComponentLongText.RecordType AND LongTextLanguageCode = _MfgOrderComponentLongText.LongTextLanguage  -- association [0..1]
LEFT OUTER JOIN E_ReservationDocumentItem AS _Extension ON Reservation = _Extension.Reservation AND ReservationItem = _Extension.ReservationItem AND RecordType = _Extension.RecordType  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _MfgOrderText ON ManufacturingOrder = _MfgOrderText.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlantText ON ProductionPlant = _ProductionPlantText.Plant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantText ON Plant = _PlantText.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _MaterialText ON Material = _MaterialText.Product  -- association [0..*]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementText ON WBSElementInternalID_2 = _WBSElementText.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocationText ON Plant = _StorageLocationText.Plant AND StorageLocation = _StorageLocationText.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyAreaText AS _SupplyAreaText ON Plant = _SupplyAreaText.Plant AND SupplyArea = _SupplyAreaText.ProductionSupplyArea  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _SupplierText ON Supplier = _SupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroupText ON PurchasingGroup = _PurchasingGroupText.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _PhantomAssemblyText ON Assembly = _PhantomAssemblyText.Product  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _FollowUpMaterialText ON FollowUpMaterial = _FollowUpMaterialText.Product  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeText ON CompanyCode = _CompanyCodeText.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingAreaText ON ControllingArea = _ControllingAreaText.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FunctionalAreaText AS _FunctionalAreaText ON FunctionalArea = _FunctionalAreaText.FunctionalArea  -- association [0..*]
;