I_SubcontractingComponent

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_SubcontractingComponent.
-- 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: IPPSUBCONTRCOMP

CREATE VIEW I_SubcontractingComponent AS
SELECT
  mdsb.rsnum AS Reservation,
  cast(mdsb.rspos as pph_rspos preserving type) AS ReservationItem,
  cast(mdsb.rsart as pph_rsart preserving type) AS RecordType,
  mdsb.matkl AS MaterialGroup,
  mdsb.matnr AS Material,
  mdsb.werks AS Plant,
  cast(mdsb.lgort as pph_lgort preserving type) AS StorageLocation,
  mdsb.charg AS Batch,
  cast(mdsb.prvbe as pph_prvbe preserving type) AS ProductionSupplyArea,
  mdsb.sgt_scat AS StockSegment,
  mdsb.sgt_rcat AS RequirementSegment,
  cast(mdsb.bdter as pph_bdter preserving type) AS RequirementDate,
  cast(mdsb.bdztp as pph_bdztp preserving type) AS RequirementTime,
  cast(mdsb.sbter as pph_sbter preserving type) AS LatestRequirementDate,
  mdsb.kzear AS ReservationIsFinallyIssued,
  cast(mdsb.xloek as pph_xloek preserving type) AS MatlCompIsMarkedForDeletion,
  mdsb.xfehl AS MaterialComponentIsMissing,
  mdsb.schgt AS IsBulkMaterialComponent,
  mdsb.txtps AS MatlCompIsTextItem,
  mdsb.kfpos AS MatlCompIsConfigurable,
  mdsb.clakz AS MaterialComponentIsClassified,
  mdsb.inpos AS MaterialCompIsIntraMaterial,
  mdsb.plnum AS PlannedOrder,
  mdsb.aufnr AS OrderID,
  cast(mdsb.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  cast(mdsb.aplzl as operationinternalid preserving type) AS OrderOperationInternalID,
  cast(mdsb.ekgrp as pph_ekgrp preserving type) AS PurchasingGroup,
  cast(mdsb.infnr as pph_infnr preserving type) AS PurchasingInfoRecord,
  cast(mdsb.banfn as co_banfn preserving type) AS PurchaseRequisition,
  cast(mdsb.bnfpo as co_bnfpo preserving type) AS PurchaseRequisitionItem,
  cast(mdsb.ebeln as pph_ebeln preserving type) AS PurchasingDocument,
  cast(mdsb.ebelp as pph_ebelp preserving type) AS PurchasingDocumentItem,
  mdsb.ebele AS ScheduleLine,
  mdsb.lifnr AS Supplier,
  cast(mdsb.stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  mdsb.stlnr AS BillOfMaterialInternalID,
  cast(mdsb.stlnr as pph_stnum preserving type) AS BillOfMaterialInternalID_2,
  mdsb.stlal AS BillOfMaterialVariant,
  mdsb.bom_versn AS BillOfMaterialVersion,
  cast(mdsb.stlkn as pph_stlkn preserving type) AS BOMItem,
  mdsb.stpoz AS BOMItemInternalChangeCount,
  mdsb.stvkn AS InheritedBOMItemNode,
  cast(mdsb.postp as pph_postp preserving type) AS BOMItemCategory,
  mdsb.posnr AS BillOfMaterialItemNumber,
  cast(mdsb.posnr as vdm_sposn preserving type) AS BillOfMaterialItemNumber_2,
  mdsb.potx1 AS BOMItemDescription,
  mdsb.potx2 AS BOMItemText2,
  cast(mdsb.sernr as pph_sernr preserving type) AS BOMExplosionDateID,
  cast(mdsb.shkzg as pph_shkzg preserving type) AS DebitCreditCode,
  mdsb.bwart AS GoodsMovementType,
  cast(mdsb.sobkz as inventoryspecialstocktype preserving type) AS InventorySpecialStockType,
  cast(mdsb.kzbws as pph_kzbws preserving type) AS InventorySpecialStockValnType,
  cast(mdsb.kzvbr as pph_kzvbr preserving type) AS ConsumptionPosting,
  cast(mdsb.knttp as pph_knttp preserving type) AS AccountAssignmentCategory,
  mdsb.sanka AS MaterialCompIsCostRelevant,
  mdsb.sanka AS MaterialCompCostingRelevancy,
  mdsb.gsber AS BusinessArea,
  mdsb.fkber AS FunctionalArea,
  mdsb.ltxsp AS LongTextLanguageCode,
  mdsb.aennr AS ChangeNumber,
  mdsb.revlv AS MaterialRevisionLevel,
  cast(mdsb.revlv as vdm_qm_revlv preserving type) AS MaterialRevisionLevel_2,
  mdsb.verti AS QuantityDistributionKey,
  mdsb.techs AS EffectivityParameterVariant,
  mdsb.cuobj AS ProductConfiguration,
  mdsb.sortf AS SortField,
  mdsb.sortf AS MatlCompFreeDefinedAttribute,
  mdsb.rohps AS MaterialCompIsVariableSized,
  cast(mdsb.roanz as pph_roanz preserving type) AS NumberOfVariableSizeComponents,
  cast(mdsb.roanz as pph_roanz preserving type) AS VariableSizeItemQuantity,
  cast(mdsb.rokme as pph_rokme preserving type) AS VariableSizeComponentUnit,
  cast(mdsb.romen as pph_romen preserving type) AS VariableSizeComponentQuantity,
  mdsb.romei AS UnitOfMeasureForSize1To3,
  mdsb.roms1 AS Size1,
  mdsb.roms2 AS Size2,
  mdsb.roms3 AS Size3,
  mdsb.rform AS FormulaKey,
  mdsb.alpos AS MaterialCompIsAlternativeItem,
  cast(mdsb.alpgr as pph_alpgr preserving type) AS AlternativeItemGroup,
  cast(mdsb.alpst as pph_alpst preserving type) AS AlternativeItemStrategy,
  cast(mdsb.alprf as pph_alprf preserving type) AS AlternativeItemPriority,
  mdsb.ewahr AS UsageProbabilityPercent,
  cast(mdsb.nfeag as pph_nfeag preserving type) AS DiscontinuationGroup,
  mdsb.kzaus AS MatlCompDiscontinuationType,
  cast(mdsb.nfpkz as pph_kznfp preserving type) AS MatlCompIsFollowUpMaterial,
  cast(mdsb.nfgrp as pph_nfgrp preserving type) AS FollowUpGroup,
  cast(mdsb.nomat as pph_nomat preserving type) AS FollowUpMaterial,
  cast(mdsb.nafkz as pph_nafkz preserving type) AS FollowUpMaterialIsActive,
  cast(mdsb.dumps as pph_dumps preserving type) AS MaterialComponentIsPhantomItem,
  mdsb.aufwg AS OrderPathValue,
  mdsb.aufst AS OrderLevelValue,
  mdsb.baugr AS Assembly,
  mdsb.bauwg AS AssemblyOrderPathValue,
  mdsb.baust AS AssemblyOrderLevelValue,
  mdsb.beikz AS IsMaterialProvision,
  cast(mdsb.beikz as vdm_beikz preserving type) AS MaterialProvisionType,
  mdsb.erskz AS SparePartFltrType,
  cast(mdsb.erskz as vdm_erskz preserving type) AS MatlComponentSparePartType,
  cast(mdsb.nlfzt as pph_nlfzt preserving type) AS LeadTimeOffset,
  cast(mdsb.nlfmv as pph_nlfmv preserving type) AS OperationLeadTimeOffsetUnit,
  cast(mdsb.nlfzv as pph_nlfzv preserving type) AS OperationLeadTimeOffset,
  mdsb.fmeng AS QuantityIsFixed,
  mdsb.ausch AS ComponentScrapInPercent,
  mdsb.avoau AS OperationScrapInPercent,
  mdsb.netau AS IsNetScrap,
  mdsb.umrez AS MaterialQtyToBaseQtyNmrtr,
  mdsb.umren AS MaterialQtyToBaseQtyDnmntr,
  mdsb.meins AS BaseUnit,
  mdsb.bdmng AS RequiredQuantity,
  cast(mdsb.enmng as pph_enmng preserving type) AS WithdrawnQuantity,
  cast(mdsb.nomng as pph_nomng preserving type) AS MaterialCompOriginalQuantity,
  mdsb.esmng AS MaterialComponentUsageQuantity,
  mdsb.erfme AS EntryUnit,
  cast(mdsb.erfmg as pph_erfmg preserving type) AS QuantityInEntryUnit
FROM resb AS mdsb
LEFT OUTER JOIN I_ReservationDocumentHeader AS _Reservation ON Reservation = _Reservation .Reservation  -- association [0..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 _ReservationRecordType ON RecordType = _ReservationRecordType.RecordType  -- association [0..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_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Material = _ProductUnitsOfMeasure.Product  -- association [1..*]
LEFT OUTER JOIN I_ProductPlantBasic AS _ProductPlant ON Material = _ProductPlant.Product AND Plant = _ProductPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ProductSupplyPlanning AS _ProductSupplyPlanning ON Material = _ProductSupplyPlanning.Product AND Plant = _ProductSupplyPlanning.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageLocationBasic AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND Plant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..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 Plant = _Batch.Plant AND Batch = _Batch.Batch  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON Plant = _ProductionSupplyArea.Plant AND ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea  -- association [0..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..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_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- 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  -- association [0..*]
LEFT OUTER JOIN I_PlannedOrder AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecordApi01 AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument AND PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseRequisitionItemAPI01 AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- 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_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_Product AS _FollowUpMaterial ON FollowUpMaterial = _FollowUpMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Assembly ON Assembly = _Assembly.Material  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON LongTextLanguageCode = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSizeCompUnit ON VariableSizeComponentUnit = _VariableSizeCompUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VariableSize1To3Unit ON UnitOfMeasureForSize1To3 = _VariableSize1To3Unit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LeadTimeOffsetUnit ON OperationLeadTimeOffsetUnit = _LeadTimeOffsetUnit.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 [0..1]
;