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,
  _StartLocationText[1:Language = $session.system_language].LocationDescription AS StartLocationDescription,
  _TLSOSVersion.DestinationLocationUUID AS DestinationLocationUUID,
  _TLSOSVersion.DestinationLocation AS DestinationLocation,
  _DestinationLocationText[1:Language = $session.system_language].LocationDescription AS DestinationLocationDescription,
  _TLSOSVersion.ProductUUID22 AS ProductUUID22,
  _TLSOSVersion.Product AS Product,
  _ProductText[1:Language = $session.system_language].ProductName AS ProductName,
  _TLSOSVersion.PlanningModel AS PlanningModel,
  _PlanningModelText[1:Language = $session.system_language].PlanningModelName AS PlanningModelName,
  _TLSOSVersion.SOSProductionDuration AS SOSProductionDuration,
  _TLSOSVersion.SOSProductionDurationIsUsed AS SOSProductionDurationIsUsed,
  _TLSOSVersion.SOSSupplierShutdownProfile AS SOSSupplierShutdownProfile,
  _ShutdownProfileText[1:Language = $session.system_language].SOSSupplierShutdownProfileName AS SOSSupplierShutdownProfileName,
  _TLSOSVersion.SOSSuplrShutdownProfileIsUsed AS SOSSuplrShutdownProfileIsUsed,
  _TLSOSVersion.SOSSynczStrtGdsRcptCalendar AS SOSSynczStrtGdsRcptCalendar,
  _TLSOSVersion.SOSSynczStrtGdsRcptCalIsUsed AS SOSSynczStrtGdsRcptCalIsUsed,
  _TLSOSVersion.SOSDynamicFreezeHorizonDate AS SOSDynamicFreezeHorizonDate,
  _TLSOSVersion.SOSDynFreezeHorizonDateIsUsed AS SOSDynFreezeHorizonDateIsUsed,
  _TLSOSVersion.SOSUnsrvcblProductsOrderType AS SOSUnsrvcblProductsOrderType,
  _ProdsOrdTypeText[1:Language = $session.system_language].SOSUnsrvcblProdsOrderTypeText AS SOSUnsrvcblProdsOrderTypeText,
  _TLSOSVersion.SOSUnsrvcblProdsOrdTypeIsUsed AS SOSUnsrvcblProdsOrdTypeIsUsed,
  _TLSOSVersion.SourceOfSupplyBlocking AS SourceOfSupplyBlocking,
  _SOSBlkgCodeText[1:Language = $session.system_language].SourceOfSupplyBlockingName AS SourceOfSupplyBlockingName,
  _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,
  _SOSCostFunctionText.SourceOfSupplyCostFunctionText AS SourceOfSupplyCostFunctionText,
  _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.LocationUUID AS LocationUUID
FROM I_SrvcPrtsTranspLaneSOSVers AS _TLSOSVersion
LEFT OUTER JOIN I_LocationText AS _StartLocationText ON StartLocationUUID = _StartLocationText.LocationUUID  -- association [0..*]
LEFT OUTER JOIN I_LocationText AS _DestinationLocationText ON DestinationLocationUUID = _DestinationLocationText.LocationUUID  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN I_SCMPlanningModelText AS _PlanningModelText ON PlanningModel = _PlanningModelText.PlanningModel  -- association [0..*]
LEFT OUTER JOIN I_TrLnSuplrShutdownProfileT AS _ShutdownProfileText ON SOSSupplierShutdownProfile = _ShutdownProfileText.SOSSupplierShutdownProfile  -- association [0..*]
LEFT OUTER JOIN I_TrLnUnsrvcblProdsOrdTypeT AS _ProdsOrdTypeText ON SOSUnsrvcblProductsOrderType = _ProdsOrdTypeText.SOSUnsrvcblProductsOrderType  -- association [0..*]
LEFT OUTER JOIN I_TranspLaneSOSBlkgCodeText AS _SOSBlkgCodeText ON SourceOfSupplyBlocking = _SOSBlkgCodeText.SourceOfSupplyBlocking  -- association [0..*]
LEFT OUTER JOIN I_TranspLaneSOSCostFunction AS _SOSCostFunctionText ON SourceOfSupplyCostFunction = _SOSCostFunctionText.SourceOfSupplyCostFunction  -- association [0..*]
LEFT OUTER JOIN I_SrvcPartsLocationVersion AS _LocationVersion ON PlanningVersionUUID = _LocationVersion.PlanningVersionUUID AND LocationUUID = _LocationVersion.LocationUUID  -- association [1..1]
;