R_SvPaTranspLaneSOSVersionTP

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_SvPaTranspLaneSOSVersionTP.
-- 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_SvPaTranspLaneSOSVersionTP AS
SELECT
  _TLSOSVersion.SCMSourceOfSupplyUUID AS SCMSourceOfSupplyUUID,
  _TLSOSVersion.PlanningVersionUUID AS PlanningVersionUUID,
  _TLSOSVersion.PlanningVersionExternal AS PlanningVersionExternal,
  _TLSOSVersion.PlanningVersionName AS PlanningVersionName,
  _TLSOSVersion.StartLocationUUID AS StartLocationUUID,
  _TLSOSVersion.StartLocation AS StartLocation,
  _TLSOSVersion.DestinationLocationUUID AS DestinationLocationUUID,
  _TLSOSVersion.DestinationLocation AS DestinationLocation,
  _TLSOSVersion.ProductUUID22 AS ProductUUID22,
  _TLSOSVersion.Product AS Product,
  _TLSOSVersion.PlanningModel AS PlanningModel,
  _TLSOSVersion.SOSProductionDuration AS SOSProductionDuration,
  _TLSOSVersion.SOSProductionDurationIsUsed AS SOSProductionDurationIsUsed,
  _TLSOSVersion.SOSSupplierShutdownProfile AS SOSSupplierShutdownProfile,
  _TLSOSVersion.SOSSuplrShutdownProfileIsUsed AS SOSSuplrShutdownProfileIsUsed,
  _TLSOSVersion.SOSSynczStrtGdsRcptCalendar AS SOSSynczStrtGdsRcptCalendar,
  _TLSOSVersion.SOSSynczStrtGdsRcptCalIsUsed AS SOSSynczStrtGdsRcptCalIsUsed,
  _TLSOSVersion.SOSDynamicFreezeHorizonDate AS SOSDynamicFreezeHorizonDate,
  _TLSOSVersion.SOSDynFreezeHorizonDateIsUsed AS SOSDynFreezeHorizonDateIsUsed,
  _TLSOSVersion.SOSUnsrvcblProductsOrderType AS SOSUnsrvcblProductsOrderType,
  _TLSOSVersion.SOSUnsrvcblProdsOrdTypeIsUsed AS SOSUnsrvcblProdsOrdTypeIsUsed,
  _TLSOSVersion.SourceOfSupplyBlocking AS SourceOfSupplyBlocking,
  _TLSOSVersion.SourceOfSupplyBlockingIsUsed AS SourceOfSupplyBlockingIsUsed,
  _TLSOSVersion.SOSMinimumLotSizeQuantityVal AS SOSMinimumLotSizeQuantityVal,
  _TLSOSVersion.SOSMinLotSizeQtyValueIsUsed AS SOSMinLotSizeQtyValueIsUsed,
  _TLSOSVersion.SOSMaximumLotSizeQuantityVal AS SOSMaximumLotSizeQuantityVal,
  _TLSOSVersion.SOSMaxLotSizeQtyValueIsUsed AS SOSMaxLotSizeQtyValueIsUsed,
  _TLSOSVersion.LocProdProcurementCostValue AS LocProdProcurementCostValue,
  _TLSOSVersion.LocProdProcmtCostValueIsUsed AS LocProdProcmtCostValueIsUsed,
  _TLSOSVersion.DistributionPriorityVal AS DistributionPriorityVal,
  _TLSOSVersion.SOSDistrPriorityValueIsUsed AS SOSDistrPriorityValueIsUsed,
  _TLSOSVersion.SourceOfSupplyCostFunction AS SourceOfSupplyCostFunction,
  _SOSCostFunctionText.SourceOfSupplyCostFunctionCode AS SourceOfSupplyCostFunctionCode,
  _TLSOSVersion.SOSCostFunctionIsUsed AS SOSCostFunctionIsUsed,
  _TLSOSVersion.SOSProcurementPriorityVal AS SOSProcurementPriorityVal,
  _TLSOSVersion.SOSProcmtPriorityValueIsUsed AS SOSProcmtPriorityValueIsUsed,
  _TLSOSVersion.SOSProcurementPullDuration AS SOSProcurementPullDuration,
  _TLSOSVersion.SOSProcmtPullDurationIsUsed AS SOSProcmtPullDurationIsUsed,
  _TLSOSVersion.SOSProcurementPushDuration AS SOSProcurementPushDuration,
  _TLSOSVersion.SOSProcmtPushDurationIsUsed AS SOSProcmtPushDurationIsUsed,
  _TLSOSVersion.SOSStockTransferPullDuration AS SOSStockTransferPullDuration,
  _TLSOSVersion.SOSStkTransfPullDurationIsUsed AS SOSStkTransfPullDurationIsUsed,
  _TLSOSVersion.SOSStockTransferPushDuration AS SOSStockTransferPushDuration,
  _TLSOSVersion.SOSStkTransfPushDurationIsUsed AS SOSStkTransfPushDurationIsUsed,
  _LocationVersion.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _LocationVersion.AuthorizationGroup AS AuthorizationGroup,
  _TLSOSVersion.SrvcPrtsIsSimlnPlngVersData AS SrvcPrtsIsSimlnPlngVersData,
  _TLSOSVersion.LocationUUID AS LocationUUID
FROM I_SrvcPrtsTranspLaneSOSVers AS _TLSOSVersion
LEFT OUTER JOIN I_LocationText AS _StartLocationText ON StartLocationUUID = _StartLocationText.LocationUUID AND _StartLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_LocationText AS _DestinationLocationText ON DestinationLocationUUID = _DestinationLocationText.LocationUUID AND _DestinationLocationText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SCMPlanningModelText AS _PlanningModelText ON PlanningModel = _PlanningModelText.PlanningModel AND _PlanningModelText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TrLnSuplrShutdownProfileT AS _ShutdownProfileText ON SOSSupplierShutdownProfile = _ShutdownProfileText.SOSSupplierShutdownProfile AND _ShutdownProfileText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TrLnUnsrvcblProdsOrdTypeT AS _ProdsOrdTypeText ON SOSUnsrvcblProductsOrderType = _ProdsOrdTypeText.SOSUnsrvcblProductsOrderType AND _ProdsOrdTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TranspLaneSOSBlkgCodeText AS _SOSBlkgCodeText ON SourceOfSupplyBlocking = _SOSBlkgCodeText.SourceOfSupplyBlocking AND _SOSBlkgCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TranspLaneSOSCostFunction AS _SOSCostFunctionText ON SourceOfSupplyCostFunction = _SOSCostFunctionText.SourceOfSupplyCostFunction  -- association [0..1]
LEFT OUTER JOIN I_SrvcPartsLocationVersion AS _LocationVersion ON PlanningVersionUUID = _LocationVersion.PlanningVersionUUID AND LocationUUID = _LocationVersion.LocationUUID  -- association [1..1]
LEFT OUTER JOIN I_SrvcPrtsPlngVersDataIndVH AS _PlngVersDataInd ON SrvcPrtsIsSimlnPlngVersData = _PlngVersDataInd.SrvcPrtsIsSimlnPlngVersData  -- association [1..1]
;