C_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 C_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 C_SvPaTranspLaneSOSVersionTP AS
SELECT
  SCMSourceOfSupplyUUID,
  PlanningVersionUUID,
  PlanningVersionExternal,
  PlanningVersionName,
  StartLocationUUID,
  StartLocation,
  _StartLocationText.LocationDescription AS StartLocationDescription,
  DestinationLocationUUID,
  DestinationLocation,
  _DestinationLocationText.LocationDescription AS DestinationLocationDescription,
  ProductUUID22,
  Product,
  _ProductText.ProductName AS ProductName,
  PlanningModel,
  _PlanningModelText.PlanningModelName AS PlanningModelName,
  SOSProductionDuration,
  SOSProductionDurationIsUsed,
  SOSSupplierShutdownProfile,
  _ShutdownProfileText.SOSSupplierShutdownProfileName AS SOSSupplierShutdownProfileName,
  SOSSuplrShutdownProfileIsUsed,
  SOSSynczStrtGdsRcptCalendar,
  SOSSynczStrtGdsRcptCalIsUsed,
  SOSDynamicFreezeHorizonDate,
  SOSDynFreezeHorizonDateIsUsed,
  SOSUnsrvcblProductsOrderType,
  _ProdsOrdTypeText.SOSUnsrvcblProdsOrderTypeText AS SOSUnsrvcblProdsOrderTypeText,
  SOSUnsrvcblProdsOrdTypeIsUsed,
  SourceOfSupplyBlocking,
  _SOSBlkgCodeText.SourceOfSupplyBlockingName AS SourceOfSupplyBlockingName,
  SourceOfSupplyBlockingIsUsed,
  SOSMinimumLotSizeQuantityVal,
  SOSMinLotSizeQtyValueIsUsed,
  SOSMaximumLotSizeQuantityVal,
  SOSMaxLotSizeQtyValueIsUsed,
  LocProdProcurementCostValue,
  LocProdProcmtCostValueIsUsed,
  DistributionPriorityVal,
  SOSDistrPriorityValueIsUsed,
  SourceOfSupplyCostFunction,
  SourceOfSupplyCostFunctionCode,
  _SOSCostFunctionText.SourceOfSupplyCostFunctionText AS SourceOfSupplyCostFunctionText,
  SOSCostFunctionIsUsed,
  SOSProcurementPriorityVal,
  SOSProcmtPriorityValueIsUsed,
  SOSProcurementPullDuration,
  SOSProcmtPullDurationIsUsed,
  SOSProcurementPushDuration,
  SOSProcmtPushDurationIsUsed,
  SOSStockTransferPullDuration,
  SOSStkTransfPullDurationIsUsed,
  SOSStockTransferPushDuration,
  SOSStkTransfPushDurationIsUsed,
  IsBusinessPurposeCompleted,
  SrvcPrtsIsSimlnPlngVersData,
  _PlngVersDataInd.SrvcPrtsSimlnPlngVersDtaIndTxt AS SrvcPrtsSimlnPlngVersDtaIndTxt,
  AuthorizationGroup
FROM R_SvPaTranspLaneSOSVersionTP
;