I_OIL_LocationMaterialBasic

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_OIL_LocationMaterialBasic.
-- 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 I_OIL_LocationMaterialBasic AS
SELECT
  locid AS TSWLocationID,
  pmatnr AS Material,
  locname AS BusinessLocationName,
  pmatname AS MaterialName,
  pwerk AS BusinessLocationPlant,
  charg AS Batch,
  rduom AS PhysicalStockQuantityUnit,
  rdconv AS PhysicalStockConversionFactor,
  period AS PhysicalStockRollingPeriod,
  past AS PhysicalStockNumberOfPastDays,
  tolpct AS ToleranceUnderRate,
  tolabs AS PhysStkAbsltQtyTolUndrQty,
  pastdata AS PhysicalStockSafetyPastDays,
  phy_inv_flg AS EntityHasPhysInvtryInpt,
  phy_inv AS PhysInvtryAtLocExtSrcQty,
  phy_date AS PhysInvtryUpdtDte,
  fcpast AS PhysInvtryHistHrznForFcst,
  fcoffset AS PhysInvtryNrOfDaysFcstCalc,
  phytms AS PhysInventoryUpdateDateValue,
  srctype AS InventorySourceType,
  fchoriz AS PhysInvtryHrznForFcstThrput,
  rvp AS VaporPressureValue,
  pltyp AS PhysicalInventoryPlanningType,
  calflg AS CalendarUseActiveCode,
  plcal AS PhysInventoryPlanningCalendar,
  cover AS SftyStkCvrgPerdQty,
  plhoz AS SftyStkPlngHrznQty,
  datuom AS SftyStkPlngPerdUoM,
  ptsyst AS SftyStkPlngTransptSyst,
  pluom AS SafetyStockPlanningUnit,
  cycle AS SftyStkPlngCycPerdQty,
  cycuom AS SftyStkCycPerdUoM,
  maxlot AS PlngMaxBatSizeQty,
  minlot AS PlngMinBatSizeQty,
  inclot AS PlngIncrmtlBatSizeQty,
  invuom AS SftyStkPlngInvtryUoM,
  maxinv AS PlngMaxInvtryLvlQty,
  target AS PlngTgtInvtryLvlQty,
  reorder AS PlngReordPtInvtryLvlQty,
  safety AS PlngSftyInvtryLvlQty,
  unpump AS BlockedInventoryQuantity,
  mininv AS PlngMinInvtryLvlQty,
  stsyst AS PlanningSourceTransportSystem,
  slocid AS PlanningSourceLocation,
  spart AS PlanningSourcePartner,
  spobj AS PlngSrcePrtnObjType,
  offper AS PlngSrceOffstPerdQty,
  offuom AS PlngSrceOffstPerdUoM,
  radionosrc AS EntityHasNoPlanningSource,
  radiotssrc AS TransportSystemIsSourcing,
  radiolocsc AS LocationIsSourcing,
  planampel AS EntityPlanDetail,
  planflag AS EntityPlanningIsRun,
  scflag AS EntityIsSrcObjectPlanningRun,
  service AS SafetyStockServiceLevelValue,
  covprof AS SafetyStockCoverageProfile,
  calprof AS SafetyStockCalendarProfile,
  factory AS SafetyStockFactoryCalendar,
  sfttype AS SafetyStockCalculationType,
  histhoz AS SafetyStockHistoryHorizonValue,
  tservice AS TargetStockServiceLevelValue,
  tcovprof AS TargetStockCoverageProfile,
  tcalprof AS TargetStockCalendarProfile,
  tfactory AS TgtStkCalcFctryCal,
  tgttype AS TargetStockCalculationType,
  thisthoz AS TargetStockHistoryHorizonValue,
  fccal AS StkProjtnRackFcstCal,
  fcprf AS StkProjtnRackFcstPrfl,
  tankupd AS EntityIsUpdatedByTankInterface,
  sftlvl AS PreferredSafetyLevelQuantity,
  hrlvl AS PreferredHeadroomLevelQuantity,
  sfttdind AS SafetyStockCalculationIsActive,
  tgttdind AS EntityIsCalctTmeDepdntTgtStk,
  pptyp AS ProductionPlanningType,
  balance AS EntityIsSuppressedStkBalcngQts,
  pvflag AS ProductionVersionIsActive,
  verid AS ProductionVersion,
  todat AS ProdnVersValidityEndDate,
  fromdat AS ProdnVersValidityStartDate,
  bomalt AS OIL_AlternativeBillOfMaterial,
  bomuse AS LocPlngIsBillOfMatlUse,
  bommat AS OIL_BillOfMaterial,
  erdat AS CreationDate,
  erzeit AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aezeit AS LastChangeTime,
  aenam AS LastChangedByUser,
  bloind AS EntityIsBlocked,
  delind AS EntityIsMarkedForDeletion,
  tktselect AS TicketIsSelectable,
  tcons AS EntityHasTimeDependentData,
  autoconfirm AS AutomaticallyIsConfirmed,
  vrmod AS ProdRqmtsConsumptionMode,
  vint1 AS BackwardCnsmpnPeriodInWorkDays,
  vint2 AS FwdConsumptionPeriodInWorkDays,
  defsityp AS DefaultScheduleType,
  defdocind AS ReferenceDocumentCode,
  lbuom AS LocationBalancingUnitOfMeasure
FROM oijlocmat
LEFT OUTER JOIN I_OIL_LocationTSWBasic AS _TSWLocation ON _TSWLocation.TSWLocationID = TSWLocationID  -- association [0..1]
LEFT OUTER JOIN I_OIL_LocationTSWBasic AS _PlnSourceTSWLocation ON _PlnSourceTSWLocation.TSWLocationID = PlanningSourceLocation  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = BusinessLocationPlant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = PhysicalStockQuantityUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PlaningPeriodUnitOfMeasure ON _PlaningPeriodUnitOfMeasure.UnitOfMeasure = SftyStkPlngPerdUoM  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _PlaningUnitOfMeasure ON _PlaningUnitOfMeasure.UnitOfMeasure = SafetyStockPlanningUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CyclePeriodUnitOfMeasure ON _CyclePeriodUnitOfMeasure.UnitOfMeasure = SftyStkCycPerdUoM  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InventoryUnitOfMeasure ON _InventoryUnitOfMeasure.UnitOfMeasure = SftyStkPlngInvtryUoM  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OffsetPeriodUnitOfMeasure ON _OffsetPeriodUnitOfMeasure.UnitOfMeasure = PlngSrceOffstPerdUoM  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _LocBalancingUnitOfMeasure ON _LocBalancingUnitOfMeasure.UnitOfMeasure = LocationBalancingUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON _FactoryCalendar.FactoryCalendar = SafetyStockFactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _StockFactoryCalendar ON _StockFactoryCalendar.FactoryCalendar = StkProjtnRackFcstCal  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON _ProductionVersion.Material = Material AND _ProductionVersion.Plant = BusinessLocationPlant AND _ProductionVersion.ProductionVersion = ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_BOMVariantUsage AS _BOMVariantUsage ON _BOMVariantUsage.BillOfMaterialVariantUsage = LocPlngIsBillOfMatlUse  -- association [0..1]
LEFT OUTER JOIN I_Material AS _BOMMaterial ON _BOMMaterial.Material = OIL_BillOfMaterial  -- association [0..1]
LEFT OUTER JOIN I_NominationScheduleTypeVH AS _NominationScheduleType ON _NominationScheduleType.ScheduleType = DefaultScheduleType  -- association [0..1]
LEFT OUTER JOIN I_OIL_PhysInvtryUpdateTypeVH AS _PhysInvtryUpdateType ON _PhysInvtryUpdateType.InventorySourceType = InventorySourceType  -- association [0..1]
LEFT OUTER JOIN I_OIL_NominationCnsmpnPerdVH AS _NominationCnsmpnPerd ON _NominationCnsmpnPerd.ProfileForBulkForecast = ProfileForBulkForecast  -- association [0..1]
LEFT OUTER JOIN I_OIL_RackIssueForecastPrflVH AS _RackIssueForecastPrfl ON _RackIssueForecastPrfl.StkProjtnRackFcstPrfl = StkProjtnRackFcstPrfl  -- association [0..1]
LEFT OUTER JOIN I_OIL_SafetyStockCalProfileVH AS _SafetyStockCalProfile ON _SafetyStockCalProfile.SafetyStockCalendarProfile = SafetyStockCalendarProfile  -- association [0..1]
LEFT OUTER JOIN I_OIL_SftyStkCvrgPerdPrflVH AS _SftyStkCvrgPerdPrfl ON _SftyStkCvrgPerdPrfl.SafetyStockCoverageProfile = SafetyStockCoverageProfile  -- association [0..1]
LEFT OUTER JOIN I_OIL_SftyStkCalcTypeVH AS _SftyStkCalcType ON _SftyStkCalcType.SafetyStockCalculationType = SafetyStockCalculationType  -- association [0..*]
LEFT OUTER JOIN I_OIL_TgtStkCalcTypeVH AS _TgtStkCalcType ON _TgtStkCalcType.TargetStockCalculationType = TargetStockCalculationType  -- association [0..1]
LEFT OUTER JOIN I_OIL_PhysicalInvtryFcstTypeVH AS _PhysicalInvtryFcstType ON _PhysicalInvtryFcstType.PhysicalInventoryForecastType = PhysicalInventoryForecastType  -- association [0..1]
LEFT OUTER JOIN I_OIL_PhysInvtryPlngTypeVH AS _PhysInvtryPlngType ON _PhysInvtryPlngType.PhysicalInventoryPlanningType = PhysicalInventoryPlanningType  -- association [0..1]
LEFT OUTER JOIN I_OIL_PlanningCalendarUsageVH AS _PlanningCalendarUsage ON _PlanningCalendarUsage.CalendarUseActiveCode = CalendarUseActiveCode  -- association [0..1]
LEFT OUTER JOIN I_OIL_ProdnPlngTypeVH AS _ProdnPlngType ON _ProdnPlngType.ProductionPlanningType = ProductionPlanningType  -- association [0..1]
LEFT OUTER JOIN I_OIL_RefDocIndicatorVH AS _RefDocIndicator ON _RefDocIndicator.ReferenceDocumentCode = ReferenceDocumentCode  -- association [0..1]
LEFT OUTER JOIN I_OIL_TransportSystem AS _TransportSystem ON _TransportSystem.TransportSystem = SftyStkPlngTransptSyst  -- association [0..1]
LEFT OUTER JOIN I_OIL_TransportSystem AS _SourceTransportSystem ON _SourceTransportSystem.TransportSystem = PlanningSourceTransportSystem  -- association [0..1]
LEFT OUTER JOIN I_OIL_ProdRqmtsCnsmpnModeVH AS _ProdRqmtsCnsmpnMode ON _ProdRqmtsCnsmpnMode.ProdRqmtsConsumptionMode = ProdRqmtsConsumptionMode  -- association [1..1]
;