C_SvPaTranspLaneSOSVersionTP

DDL: C_SVPATRANSPLANESOSVERSIONTP Type: view_entity CONSUMPTION

Service Parts TL SOS Version Maintenance

C_SvPaTranspLaneSOSVersionTP is a Consumption CDS View that provides data about "Service Parts TL SOS Version Maintenance" in SAP S/4HANA. It reads from 1 data source (R_SvPaTranspLaneSOSVersionTP) and exposes 53 fields with key fields SCMSourceOfSupplyUUID, PlanningVersionUUID. It is exposed through 1 OData service (UI_MASSPROCDATATYPEDSP).

Data Sources (1)

SourceAliasJoin Type
R_SvPaTranspLaneSOSVersionTP R_SvPaTranspLaneSOSVersionTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Service Parts TL SOS Version Maintenance view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MASSPROCDATATYPEDSP UI_MASSPROCDATATYPEDSP V4 C1 NOT_RELEASED

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY SCMSourceOfSupplyUUID SCMSourceOfSupplyUUID
KEY PlanningVersionUUID PlanningVersionUUID Plan Version
PlanningVersionExternal PlanningVersionExternal
PlanningVersionName PlanningVersionName
StartLocationUUID StartLocationUUID
StartLocation StartLocation
StartLocationDescription StartLocationDescription
DestinationLocationUUID DestinationLocationUUID
DestinationLocation DestinationLocation
DestinationLocationDescription DestinationLocationDescription
ProductUUID22 ProductUUID22
Product Product Product Sold
ProductName ProductName Description
PlanningModel PlanningModel
PlanningModelName PlanningModelName
SOSProductionDuration SOSProductionDuration
SOSProductionDurationIsUsed SOSProductionDurationIsUsed
SOSSupplierShutdownProfile SOSSupplierShutdownProfile
SOSSupplierShutdownProfileName SOSSupplierShutdownProfileName
SOSSuplrShutdownProfileIsUsed SOSSuplrShutdownProfileIsUsed
SOSSynczStrtGdsRcptCalendar SOSSynczStrtGdsRcptCalendar
SOSSynczStrtGdsRcptCalIsUsed SOSSynczStrtGdsRcptCalIsUsed
SOSDynamicFreezeHorizonDate SOSDynamicFreezeHorizonDate
SOSDynFreezeHorizonDateIsUsed SOSDynFreezeHorizonDateIsUsed
SOSUnsrvcblProductsOrderType SOSUnsrvcblProductsOrderType
SOSUnsrvcblProdsOrderTypeText SOSUnsrvcblProdsOrderTypeText
SOSUnsrvcblProdsOrdTypeIsUsed SOSUnsrvcblProdsOrdTypeIsUsed
SourceOfSupplyBlocking SourceOfSupplyBlocking
SourceOfSupplyBlockingName SourceOfSupplyBlockingName
SourceOfSupplyBlockingIsUsed SourceOfSupplyBlockingIsUsed
SOSMinimumLotSizeQuantityVal SOSMinimumLotSizeQuantityVal
SOSMinLotSizeQtyValueIsUsed SOSMinLotSizeQtyValueIsUsed
SOSMaximumLotSizeQuantityVal SOSMaximumLotSizeQuantityVal
SOSMaxLotSizeQtyValueIsUsed SOSMaxLotSizeQtyValueIsUsed
LocProdProcurementCostValue LocProdProcurementCostValue
LocProdProcmtCostValueIsUsed LocProdProcmtCostValueIsUsed
DistributionPriorityVal DistributionPriorityVal
SOSDistrPriorityValueIsUsed SOSDistrPriorityValueIsUsed
SourceOfSupplyCostFunction SourceOfSupplyCostFunction
SourceOfSupplyCostFunctionCode SourceOfSupplyCostFunctionCode
SOSCostFunctionIsUsed SOSCostFunctionIsUsed
SOSProcurementPriorityVal SOSProcurementPriorityVal
SOSProcmtPriorityValueIsUsed SOSProcmtPriorityValueIsUsed
SOSProcurementPullDuration SOSProcurementPullDuration
SOSProcmtPullDurationIsUsed SOSProcmtPullDurationIsUsed
SOSProcurementPushDuration SOSProcurementPushDuration
SOSProcmtPushDurationIsUsed SOSProcmtPushDurationIsUsed
SOSStockTransferPullDuration SOSStockTransferPullDuration
SOSStkTransfPullDurationIsUsed SOSStkTransfPullDurationIsUsed
SOSStockTransferPushDuration SOSStockTransferPushDuration
SOSStkTransfPushDurationIsUsed SOSStkTransfPushDurationIsUsed
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup AuthorizationGroup AuthorizGroup

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,
  StartLocationDescription,
  DestinationLocationUUID,
  DestinationLocation,
  DestinationLocationDescription,
  ProductUUID22,
  Product,
  ProductName,
  PlanningModel,
  PlanningModelName,
  SOSProductionDuration,
  SOSProductionDurationIsUsed,
  SOSSupplierShutdownProfile,
  SOSSupplierShutdownProfileName,
  SOSSuplrShutdownProfileIsUsed,
  SOSSynczStrtGdsRcptCalendar,
  SOSSynczStrtGdsRcptCalIsUsed,
  SOSDynamicFreezeHorizonDate,
  SOSDynFreezeHorizonDateIsUsed,
  SOSUnsrvcblProductsOrderType,
  SOSUnsrvcblProdsOrderTypeText,
  SOSUnsrvcblProdsOrdTypeIsUsed,
  SourceOfSupplyBlocking,
  SourceOfSupplyBlockingName,
  SourceOfSupplyBlockingIsUsed,
  SOSMinimumLotSizeQuantityVal,
  SOSMinLotSizeQtyValueIsUsed,
  SOSMaximumLotSizeQuantityVal,
  SOSMaxLotSizeQtyValueIsUsed,
  LocProdProcurementCostValue,
  LocProdProcmtCostValueIsUsed,
  DistributionPriorityVal,
  SOSDistrPriorityValueIsUsed,
  SourceOfSupplyCostFunction,
  SourceOfSupplyCostFunctionCode,
  SOSCostFunctionIsUsed,
  SOSProcurementPriorityVal,
  SOSProcmtPriorityValueIsUsed,
  SOSProcurementPullDuration,
  SOSProcmtPullDurationIsUsed,
  SOSProcurementPushDuration,
  SOSProcmtPushDurationIsUsed,
  SOSStockTransferPullDuration,
  SOSStkTransfPullDurationIsUsed,
  SOSStockTransferPushDuration,
  SOSStkTransfPushDurationIsUsed,
  IsBusinessPurposeCompleted,
  AuthorizationGroup
FROM R_SvPaTranspLaneSOSVersionTP
;