I_OIL_TranspSchedgPointVH

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_TranspSchedgPointVH.
-- 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_TranspSchedgPointVH AS
SELECT
  tplst AS TransportationPlnPoint,
  fabkl AS TranspFactoryCalendarKey,
  adrnr AS CustomerSupplierAddress,
  tpsid AS ExternalTransportSystem,
  vtparn AS ExtTransptSystemPartnerNumber,
  vtpart AS ExtTransportSystemPartnerType,
  kschl AS TranspPlanningSystOutputType,
  nketp AS ExtTransptSystemExtNumberRange,
  traend AS ExtPlndShipmentsChgsCtrlg,
  sttrg AS ExtPlndShipmentsOverallStatus,
  tpssf AS ExtTranspPlngStsFilteringMode,
  tpstx1 AS ExtTranspPlngStsDelivHdrTxtID1,
  tpstx2 AS ExtTranspPlngStsDelivHdrTxtID2,
  tpstx3 AS ExtTranspPlngStsDelivHdrTxtID3,
  bukrs AS CompanyCode,
  stagew AS TranspPlngStstcsUpdtWeightUnit,
  stavol AS TranspPlngStstcsUpdtVolumeUnit,
  stadis AS TranspPlngStstcsUpdtDstncUnit,
  stacur AS TranspPlngStstcUpdtCrcyUnit
FROM ttds
LEFT OUTER JOIN I_OIL_TranspSchedgPointText AS _TranspSchedgPointText ON _TranspSchedgPointText.TransportationPlnPoint = TransportationPlnPoint  -- association [1..*]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON _FactoryCalendar.FactoryCalendar = TranspFactoryCalendarKey  -- association [0..1]
LEFT OUTER JOIN I_OIL_LgclQueueCommNmbrMappgVH AS _LgclQueueCommNmbrMappg ON _LgclQueueCommNmbrMappg.CommunicationNumberInterface = ExternalTransportSystem  -- association [0..1]
LEFT OUTER JOIN I_ConditionType AS _ConditionType ON _ConditionType.ConditionUsage = 'B' AND _ConditionType.ConditionApplication = 'V2' AND _ConditionType.ConditionType = TranspPlanningSystOutputType  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StstcsUpdtWeightUoM ON _StstcsUpdtWeightUoM.UnitOfMeasure = TranspPlngStstcsUpdtWeightUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StstcsUpdtVolumeUoM ON _StstcsUpdtVolumeUoM.UnitOfMeasure = TranspPlngStstcsUpdtVolumeUnit  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StstcsUpdtDstncUoM ON _StstcsUpdtDstncUoM.UnitOfMeasure = TranspPlngStstcsUpdtDstncUnit  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = TranspPlngStstcUpdtCrcyUnit  -- association [0..1]
LEFT OUTER JOIN I_OIL_PlndShipmentsChgsCtrlgVH AS _PlndShipmentsChgsCtrlg ON _PlndShipmentsChgsCtrlg.ExtPlndShipmentsChgsCtrlg = ExtPlndShipmentsChgsCtrlg  -- association [0..1]
LEFT OUTER JOIN I_OIL_PlndShipmentsOvrlStsVH AS _PlndShipmentsOvrlSts ON _PlndShipmentsOvrlSts.ExtPlndShipmentsOverallStatus = ExtPlndShipmentsOverallStatus  -- association [0..1]
LEFT OUTER JOIN I_OIL_StatusFilteringModeVH AS _StatusFilteringMode ON _StatusFilteringMode.ExtTranspPlngStsFilteringMode = ExtTranspPlngStsFilteringMode  -- association [0..1]
;