R_SrvcPrtsMassProcDealerProdTP

DDL: R_SRVCPRTSMASSPROCDEALERPRODTP Type: view_entity TRANSACTIONAL

Srvc Prts Dealer Product - TP

R_SrvcPrtsMassProcDealerProdTP is a Transactional CDS View that provides data about "Srvc Prts Dealer Product - TP" in SAP S/4HANA. It reads from 1 data source (I_SrvcPartsDealerProdDetail) and exposes 148 fields with key fields Location, Product, PlanningVersionExternal. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SrvcPartsDealerProdDetail I_SrvcPartsDealerProdDetail from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_SCMVersionMap _VersionMappg $projection.PlanningVersionUUID = _VersionMappg.PlanningVersionUUID
[0..*] I_UnitOfMeasureText _UnitOfMeasureText $projection.BaseUnit = _UnitOfMeasureText.UnitOfMeasure
[0..1] I_SCMPlanningVersion _SCMPlanningVersion $projection.PlanningVersionUUID = _SCMPlanningVersion.AdvncdPlngPlanningVersionUUID
[0..1] I_SrvcPartsCustomerStockUpInf _StockInfoSendDateTime $projection.Location = _StockInfoSendDateTime.Location and $projection.Product = _StockInfoSendDateTime.Product

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Srvc Prts Dealer Product - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name ServicePartsDealerProduct view

Fields (148)

KeyFieldSource TableSource FieldDescription
KEY Location Location Text
KEY Product Product Product Sold
KEY PlanningVersionExternal _VersionMappg PlanningVersionExternal
ProductInternalUUID
LocationUUID LocationUUID UUID
SrvcPartsPlanningVersionUUID SrvcPartsPlanningVersionUUID
PlanningVersionUUID PlanningVersionUUID Plan Version
MaterialExternalID MaterialExternalID Material
SrvcPartsEconomicOrderQty
SrvcPartsNrOfDaysEOQPlngDurn SrvcPartsNrOfDaysEOQPlngDurn
SrvcPartsEOQSftyMod SrvcPartsEOQSftyMod
SrvcPartsLongEOQSftyMod SrvcPartsLongEOQSftyMod
SrvcPartsEOQFixPeriod SrvcPartsEOQFixPeriod
SrvcPartsEOQCalculationType SrvcPartsEOQCalculationType
SrvcPartsEOQSftyStkHasTimeSers SrvcPartsEOQSftyStkHasTimeSers
SrvcPartsNrOfMaxDaysEOQ SrvcPartsNrOfMaxDaysEOQ
SrvcPartsNrOfMaxDaysEOQParent SrvcPartsNrOfMaxDaysEOQParent
SrvcPartsNrOfMaxDaysReorderPt SrvcPartsNrOfMaxDaysReorderPt
SrvcPartsNrOfMinDaysEOQPeriod SrvcPartsNrOfMinDaysEOQPeriod
ReplenishmentIndIsLocked ReplenishmentIndIsLocked
SrvcPartsDRPReviewTimeDurn SrvcPartsDRPReviewTimeDurn
SrvcPartsDplntReviewTimeDurn SrvcPartsDplntReviewTimeDurn
SrvcPartsDplntPlanningRunDurn SrvcPartsDplntPlanningRunDurn
SrvcPartsDRPPlanningRunDurn SrvcPartsDRPPlanningRunDurn
SrvcPartsFixOrdgCostPullAmtVal SrvcPartsFixOrdgCostPullAmtVal
SrvcPartsFixOrdgCostPushAmtVal SrvcPartsFixOrdgCostPushAmtVal
SrvcPartsMinPurOrderQty
ReplenishmentStatusCode ReplenishmentStatusCode
ChangeOfRepIndDateTime ChangeOfRepIndDateTime
SrvcPartsStkngStbltyDurnInHrs SrvcPartsStkngStbltyDurnInHrs
SrvcPartsDstkngStbltyDurnInHrs SrvcPartsDstkngStbltyDurnInHrs
SrvcPartsLocationIsStockedRgnl SrvcPartsLocationIsStockedRgnl
SrvcPartsLocationExclusionRsn SrvcPartsLocationExclusionRsn
SrvcPartsHrznFixedDmndIsTaken SrvcPartsHrznFixedDmndIsTaken
SrvcPartsProcmtLeadTimeDetn SrvcPartsProcmtLeadTimeDetn
SrvcPartsNmbrOfDaysForHorizon SrvcPartsNmbrOfDaysForHorizon
SrvcPartsLocInitStockedDteTme SrvcPartsLocInitStockedDteTme
SrvcPartsSftyStkCalcMethod SrvcPartsSftyStkCalcMethod
SrvcPartsSftyStkEOQLockRsn SrvcPartsSftyStkEOQLockRsn
SrvcPartsPlngLockEOQStrtDate SrvcPartsPlngLockEOQStrtDate
SrvcPartsPlngLockEOQEndDate SrvcPartsPlngLockEOQEndDate
SrvcPartsRecmddStorQuantity
SrvcPartsDeploymentPlng SrvcPartsDeploymentPlng
SrvcPartsDplntPlngStbltyDteTme SrvcPartsDplntPlngStbltyDteTme
SrvcPartsMltplrExprShptVal SrvcPartsMltplrExprShptVal
SrvcPartsDRPPlngLockEndDteTme SrvcPartsDRPPlngLockEndDteTme
SrvcPartsDRPPlngLockStrtDteTme SrvcPartsDRPPlngLockStrtDteTme
SrvcPartsLockEndDteTme SrvcPartsLockEndDteTme
SrvcPartsLockStartDteTme SrvcPartsLockStartDteTme
SrvcPartsLocLockEndDteTme SrvcPartsLocLockEndDteTme
SrvcPartsLocLockStrtDteTme SrvcPartsLocLockStrtDteTme
SrvcPartsParLocRmngQtyIsKept SrvcPartsParLocRmngQtyIsKept
SrvcPartsAddlGrossDemandVal SrvcPartsAddlGrossDemandVal
SrvcPartsMinNetDemandQty
SrvcPartsPseasnIsExcluded SrvcPartsPseasnIsExcluded
SrvcPartsDRPNrOfMonthsRndng SrvcPartsDRPNrOfMonthsRndng
SrvcPartsCnsldtdOrdering SrvcPartsCnsldtdOrdering
SrvcPartsMaximumGrossDemandVal SrvcPartsMaximumGrossDemandVal
SrvcPartsAntcptdDemandCoverage SrvcPartsAntcptdDemandCoverage
SrvcPartsAvgQtyStorBinQtyVal SrvcPartsAvgQtyStorBinQtyVal
SrvcPartsWrhsSpaceSvngStorType SrvcPartsWrhsSpaceSvngStorType
SrvcPartsSvngPreventedLossVal SrvcPartsSvngPreventedLossVal
SrvcPartsManFreezeHrznDteTme SrvcPartsManFreezeHrznDteTme
SrvcPartsDRPPlngModeTrggrIsSet SrvcPartsDRPPlngModeTrggrIsSet
SrvcPartsDRPPlngMode SrvcPartsDRPPlngMode
SrvcPartsRndngMaxStockIsSet SrvcPartsRndngMaxStockIsSet
SrvcPartsInventoryBalancing SrvcPartsInventoryBalancing
SrvcPartsCustInfoStkDcsnIsUsd SrvcPartsCustInfoStkDcsnIsUsd
SrvcPartsOEMMngdInvtryIsRlvt SrvcPartsOEMMngdInvtryIsRlvt
NoSubOrdSupersessionIsAllwd NoSubOrdSupersessionIsAllwd
NoSubOrdRemnftdIsAllwd NoSubOrdRemnftdIsAllwd
SrvcPartsCustApprvlReplnmtOrd SrvcPartsCustApprvlReplnmtOrd
SrvcPartsDRPLockRsn SrvcPartsDRPLockRsn
SrvcPartsDeploymentLockRsn SrvcPartsDeploymentLockRsn
SrvcPartsLocationLockRsn SrvcPartsLocationLockRsn
SrvcPartsSupplyChainAnalyst SrvcPartsSupplyChainAnalyst
SrvcPartsDRPPlanner SrvcPartsDRPPlanner
SrvcPartsInventoryPlanner SrvcPartsInventoryPlanner
SrvcPartsPlanningBuyer SrvcPartsPlanningBuyer
SrvcPartsSCMAnalystIsLocked SrvcPartsSCMAnalystIsLocked
BaseUnit BaseUnit Unit of Measure
GoodsReceiptDuration GoodsReceiptDuration GR proc. time
SrvcPartsBPGdsRcptCostVal SrvcPartsBPGdsRcptCostVal
CostFactorForStockHoldingVal CostFactorForStockHoldingVal
SafetyStockQuantity Safety stock
ParLocSafetyStockQuantity
ProductProcurementCostsVal ProductProcurementCostsVal Procuremt Costs
MaximumStockQuantity Max.stock level
ReorderThresholdQuantity Reorder Point
IsMarkedForDeletion IsMarkedForDeletion Purch.org. data
ServicePartsCreatedByUser ServicePartsCreatedByUser
ServicePartsCreatedAtDateTime ServicePartsCreatedAtDateTime
ServicePartsLastChangedByUser ServicePartsLastChangedByUser
ServicePartsLastChangeDateTime ServicePartsLastChangeDateTime
PlanningVersionName _SCMPlanningVersion PlanningVersionName
BusinessPartner BusinessPartner Issuing Authority
AuthorizationGroup _LocationBasic AuthorizationGroup AuthorizGroup
_LocationMappg _LocationMappg
_LocationText _LocationText
_Product _Product
_ProductMappg _ProductMappg
_ProductText _ProductText
_SrvcPartsAntcptdDmndPrfl _SrvcPartsAntcptdDmndPrfl
_SrvcPartsAntcptdDmndPrflText _SrvcPartsAntcptdDmndPrflText
_SrvcPartsCnsldtdOrdering _SrvcPartsCnsldtdOrdering
_SrvcPartsCnsldtdOrderingText _SrvcPartsCnsldtdOrderingText
_SrvcPartsCustApprvlReplnmt _SrvcPartsCustApprvlReplnmt
_SrvcPartsCustApprvlReplnmtT _SrvcPartsCustApprvlReplnmtT
_SrvcPartsDeploymentPlng _SrvcPartsDeploymentPlng
_SrvcPartsDeploymentPlngT _SrvcPartsDeploymentPlngT
_SrvcPartsDplntLockRsn _SrvcPartsDplntLockRsn
_SrvcPartsDplntLockRsnT _SrvcPartsDplntLockRsnT
_SrvcPartsDRPLockRsn _SrvcPartsDRPLockRsn
_SrvcPartsDRPLockRsnT _SrvcPartsDRPLockRsnT
_SrvcPartsDRPPlanner _SrvcPartsDRPPlanner
_SrvcPartsDRPPlngMode _SrvcPartsDRPPlngMode
_SrvcPartsDRPPlngModeText _SrvcPartsDRPPlngModeText
_SrvcPartsEOQCalcType _SrvcPartsEOQCalcType
_SrvcPartsEOQCalcTypeText _SrvcPartsEOQCalcTypeText
_SrvcPartsEOQFixPeriod _SrvcPartsEOQFixPeriod
_SrvcPartsEOQFixPeriodText _SrvcPartsEOQFixPeriodText
_SrvcPartsEOQSftyMod _SrvcPartsEOQSftyMod
_SrvcPartsEOQSftyModText _SrvcPartsEOQSftyModText
_SrvcPartsFixedDmndType _SrvcPartsFixedDmndType
_SrvcPartsFixedDmndTypeText _SrvcPartsFixedDmndTypeText
_SrvcPartsInventoryBalancingT _SrvcPartsInventoryBalancingT
_SrvcPartsInventoryPlanner _SrvcPartsInventoryPlanner
_SrvcPartsLocationLockRsn _SrvcPartsLocationLockRsn
_SrvcPartsLocationLockRsnT _SrvcPartsLocationLockRsnT
_SrvcPartsLocExclsnRsn _SrvcPartsLocExclsnRsn
_SrvcPartsLocExclsnRsnT _SrvcPartsLocExclsnRsnT
_SrvcPartsLongEOQSftyMod _SrvcPartsLongEOQSftyMod
_SrvcPartsLongEOQSftyModText _SrvcPartsLongEOQSftyModText
_SrvcPartsPlanningBuyer _SrvcPartsPlanningBuyer
_SrvcPartsReplenishmentCtrl _SrvcPartsReplenishmentCtrl
_SrvcPartsReplenishmentCtrlT _SrvcPartsReplenishmentCtrlT
_SrvcPartsSftyStkCalcMeth _SrvcPartsSftyStkCalcMeth
_SrvcPartsSftyStkCalcMethT _SrvcPartsSftyStkCalcMethT
_SrvcPartsSftyStkEOQLockRsn _SrvcPartsSftyStkEOQLockRsn
_SrvcPartsSftyStkEOQLockRsnT _SrvcPartsSftyStkEOQLockRsnT
_SrvcPartsSupplyChainAnalyst _SrvcPartsSupplyChainAnalyst
_SrvcPartsWhseSavingsStor _SrvcPartsWhseSavingsStor
_SrvcPartsWhseSavingsStorT _SrvcPartsWhseSavingsStorT
_VersionMappg _VersionMappg
_UnitOfMeasureText _UnitOfMeasureText
_PlngSts _PlngSts
_StockInfoSendDateTime _StockInfoSendDateTime
_LocationBasic _LocationBasic

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_SrvcPrtsMassProcDealerProdTP.
-- 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_SrvcPrtsMassProcDealerProdTP AS
SELECT
  Location,
  Product,
  _VersionMappg.PlanningVersionExternal AS PlanningVersionExternal,
  cast( ProductInternalUUID as sysuuid_22 preserving type ) AS ProductInternalUUID,
  LocationUUID,
  SrvcPartsPlanningVersionUUID,
  PlanningVersionUUID,
  MaterialExternalID,
  cast( SrvcPartsEconomicOrderQty as abap.dec(13, 3) ) AS SrvcPartsEconomicOrderQty,
  SrvcPartsNrOfDaysEOQPlngDurn,
  SrvcPartsEOQSftyMod,
  SrvcPartsLongEOQSftyMod,
  SrvcPartsEOQFixPeriod,
  SrvcPartsEOQCalculationType,
  SrvcPartsEOQSftyStkHasTimeSers,
  SrvcPartsNrOfMaxDaysEOQ,
  SrvcPartsNrOfMaxDaysEOQParent,
  SrvcPartsNrOfMaxDaysReorderPt,
  SrvcPartsNrOfMinDaysEOQPeriod,
  ReplenishmentIndIsLocked,
  SrvcPartsDRPReviewTimeDurn,
  SrvcPartsDplntReviewTimeDurn,
  SrvcPartsDplntPlanningRunDurn,
  SrvcPartsDRPPlanningRunDurn,
  SrvcPartsFixOrdgCostPullAmtVal,
  SrvcPartsFixOrdgCostPushAmtVal,
  cast( SrvcPartsMinPurOrderQty as abap.dec(13, 3) ) AS SrvcPartsMinPurOrderQty,
  ReplenishmentStatusCode,
  ChangeOfRepIndDateTime,
  SrvcPartsStkngStbltyDurnInHrs,
  SrvcPartsDstkngStbltyDurnInHrs,
  SrvcPartsLocationIsStockedRgnl,
  SrvcPartsLocationExclusionRsn,
  SrvcPartsHrznFixedDmndIsTaken,
  SrvcPartsProcmtLeadTimeDetn,
  SrvcPartsNmbrOfDaysForHorizon,
  SrvcPartsLocInitStockedDteTme,
  SrvcPartsSftyStkCalcMethod,
  SrvcPartsSftyStkEOQLockRsn,
  SrvcPartsPlngLockEOQStrtDate,
  SrvcPartsPlngLockEOQEndDate,
  cast( SrvcPartsRecmddStorQuantity as abap.dec(15, 3) ) AS SrvcPartsRecmddStorQuantity,
  SrvcPartsDeploymentPlng,
  SrvcPartsDplntPlngStbltyDteTme,
  SrvcPartsMltplrExprShptVal,
  SrvcPartsDRPPlngLockEndDteTme,
  SrvcPartsDRPPlngLockStrtDteTme,
  SrvcPartsLockEndDteTme,
  SrvcPartsLockStartDteTme,
  SrvcPartsLocLockEndDteTme,
  SrvcPartsLocLockStrtDteTme,
  SrvcPartsParLocRmngQtyIsKept,
  SrvcPartsAddlGrossDemandVal,
  cast( SrvcPartsMinNetDemandQty as abap.dec(13, 4) ) AS SrvcPartsMinNetDemandQty,
  SrvcPartsPseasnIsExcluded,
  SrvcPartsDRPNrOfMonthsRndng,
  SrvcPartsCnsldtdOrdering,
  SrvcPartsMaximumGrossDemandVal,
  SrvcPartsAntcptdDemandCoverage,
  SrvcPartsAvgQtyStorBinQtyVal,
  SrvcPartsWrhsSpaceSvngStorType,
  SrvcPartsSvngPreventedLossVal,
  SrvcPartsManFreezeHrznDteTme,
  SrvcPartsDRPPlngModeTrggrIsSet,
  SrvcPartsDRPPlngMode,
  SrvcPartsRndngMaxStockIsSet,
  SrvcPartsInventoryBalancing,
  SrvcPartsCustInfoStkDcsnIsUsd,
  SrvcPartsOEMMngdInvtryIsRlvt,
  NoSubOrdSupersessionIsAllwd,
  NoSubOrdRemnftdIsAllwd,
  SrvcPartsCustApprvlReplnmtOrd,
  SrvcPartsDRPLockRsn,
  SrvcPartsDeploymentLockRsn,
  SrvcPartsLocationLockRsn,
  SrvcPartsSupplyChainAnalyst,
  SrvcPartsDRPPlanner,
  SrvcPartsInventoryPlanner,
  SrvcPartsPlanningBuyer,
  SrvcPartsSCMAnalystIsLocked,
  BaseUnit,
  GoodsReceiptDuration,
  SrvcPartsBPGdsRcptCostVal,
  CostFactorForStockHoldingVal,
  cast( SafetyStockQuantity as abap.dec(13, 3) ) AS SafetyStockQuantity,
  cast( ParLocSafetyStockQuantity as abap.dec(13,3) ) AS ParLocSafetyStockQuantity,
  ProductProcurementCostsVal,
  cast( MaximumStockQuantity as abap.dec(13, 3) ) AS MaximumStockQuantity,
  cast( ReorderThresholdQuantity as abap.dec(13, 3) ) AS ReorderThresholdQuantity,
  IsMarkedForDeletion,
  ServicePartsCreatedByUser,
  ServicePartsCreatedAtDateTime,
  ServicePartsLastChangedByUser,
  ServicePartsLastChangeDateTime,
  _SCMPlanningVersion.PlanningVersionName AS PlanningVersionName,
  BusinessPartner,
  _LocationBasic.AuthorizationGroup AS AuthorizationGroup
FROM I_SrvcPartsDealerProdDetail
LEFT OUTER JOIN I_SCMVersionMap AS _VersionMappg ON PlanningVersionUUID = _VersionMappg.PlanningVersionUUID  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON BaseUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_SCMPlanningVersion AS _SCMPlanningVersion ON PlanningVersionUUID = _SCMPlanningVersion.AdvncdPlngPlanningVersionUUID  -- association [0..1]
LEFT OUTER JOIN I_SrvcPartsCustomerStockUpInf AS _StockInfoSendDateTime ON Location = _StockInfoSendDateTime.Location AND Product = _StockInfoSendDateTime.Product  -- association [0..1]
;