I_ProdnVersTP

DDL: I_PRODNVERSTP SQL: IPRODNVERSTP Type: view TRANSACTIONAL Package: MPE_PLAN_PV
54 Fields 1 Data Sources 1 Associations

Manage Production Version

I_ProdnVersTP is a Transactional CDS View that provides data about "Manage Production Version" in SAP S/4HANA. It reads from 1 data source (I_ProductionVersion) and exposes 54 fields with key fields Material, Plant, ProductionVersion. It has 1 association to related views. Part of development package MPE_PLAN_PV.

Data Sources (1)

SourceAliasJoin Type
I_ProductionVersion I_ProductionVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProdnVersRtgBOMVersTP _ProdnVersRtgBOMVers $projection.Material = _ProdnVersRtgBOMVers.Material and $projection.Plant = _ProdnVersRtgBOMVers.Plant and $projection.ProductionVersion = _ProdnVersRtgBOMVers.ProductionVersion

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPRODNVERSTP view
EndUserText.label Manage Production Version view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence MPEPRODNVERSD view
ObjectModel.entityChangeStateId LastChangeDate view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY Material I_ProductionVersion Material Vehicle Model
KEY Plant I_ProductionVersion Plant Valuation Area
KEY ProductionVersion I_ProductionVersion ProductionVersion Version ID
BillOfOperationsGroup I_ProductionVersion BillOfOperationsGroup Group
BillOfOperationsVariant I_ProductionVersion BillOfOperationsVariant Group Counter
BillOfMaterialVariantUsage I_ProductionVersion BillOfMaterialVariantUsage Usage
BillOfMaterialVariant I_ProductionVersion BillOfMaterialVariant AlternativeBOM
MaterialForEdit I_ProductionVersion Material Vehicle Model
PlantForEdit I_ProductionVersion Plant Valuation Area
ProductionVersionForEdit I_ProductionVersion ProductionVersion Version ID
MRPController MatlPlnt MRPController MRP Controller
ValidityEndDate I_ProductionVersion ValidityEndDate ValidTo
ValidityStartDate I_ProductionVersion ValidityStartDate Validity Start Date
BillOfOperationsType I_ProductionVersion BillOfOperationsType Task List Type
ProductionLine I_ProductionVersion ProductionLine Production Line
ProductionVersionGroup I_ProductionVersion ProductionVersionGroup
ProductionVersionText I_ProductionVersion ProductionVersionText Vertikalization Text
QuantityDistributionKey I_ProductionVersion QuantityDistributionKey Distribution
DistributionKey I_ProductionVersion DistributionKey Distr. Number
ProdnVersIsAllowedForRptvMfg I_ProductionVersion ProdnVersIsAllowedForRptvMfg REM Allowed
MaterialMinLotSizeQuantity I_ProductionVersion MaterialMinLotSizeQuantity Min. Lot Size
MaterialMaxLotSizeQuantity I_ProductionVersion MaterialMaxLotSizeQuantity To Lot Size
ReceivingStorageLocation I_ProductionVersion ReceivingStorageLocation RecStorLoc
MaterialCostApportionmentStruc I_ProductionVersion MaterialCostApportionmentStruc Apportionment
MainProduct I_ProductionVersion MainProduct
IssuingStorageLocation I_ProductionVersion IssuingStorageLocation Iss. Stor. Loc.
ProductionSupplyArea I_ProductionVersion ProductionSupplyArea Supply Area
ProductionVersionStatus I_ProductionVersion ProductionVersionStatus Check Status
ProductionVersionLastCheckDate I_ProductionVersion ProductionVersionLastCheckDate
ProductionVersionIsLocked I_ProductionVersion ProductionVersionIsLocked Prodn Version Lock
RateBasedPlanningStatus I_ProductionVersion RateBasedPlanningStatus
PreliminaryPlanningStatus I_ProductionVersion PreliminaryPlanningStatus
BOMCheckStatus I_ProductionVersion BOMCheckStatus
OriginalBatchReferenceMaterial I_ProductionVersion OriginalBatchReferenceMaterial
ChangeHistoryCount I_ProductionVersion ChangeHistoryCount
ChangeNumber I_ProductionVersion ChangeNumber Change Number
CreationDate I_ProductionVersion CreationDate Time Stamp
CreatedByUser I_ProductionVersion CreatedByUser User Name
LastChangeDate I_ProductionVersion LastChangeDate Time Stamp
LastChangedByUser I_ProductionVersion LastChangedByUser User Name
CheckStatus
HasVersionCtrldBOMAndRouting I_ProductionVersion HasVersionCtrldBOMAndRouting BOM/RTG Vers. Exists
PlanningAndExecutionBOMIsDiff I_ProductionVersion PlanningAndExecutionBOMIsDiff Plng Exec Mstr Diff
IsMaterialUnitized
ExecBillOfMaterialVariant I_ProductionVersion ExecBillOfMaterialVariant SF BOM Alt.
ExecBillOfMaterialVariantUsage I_ProductionVersion ExecBillOfMaterialVariantUsage SF BOM Usage
ExecBillOfOperationsType I_ProductionVersion ExecBillOfOperationsType Task list Type
ExecBillOfOperationsGroup I_ProductionVersion ExecBillOfOperationsGroup Tasklist Group
ExecBillOfOperationsVariant I_ProductionVersion ExecBillOfOperationsVariant Group Counter
EWMWarehouse I_ProductionVersion Warehouse Warehouse No.
DestinationStorageBin I_ProductionVersion DestinationStorageBin Storage Bin
MaterialBaseUnit I_ProductionVersion MaterialBaseUnit Valuation Unit
_BillOfOperationsType _BillOfOperationsType
_ProdnVersRtgBOMVers _ProdnVersRtgBOMVers

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 I_ProdnVersTP.
-- 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.
-- SQL view name: IPRODNVERSTP

CREATE VIEW I_ProdnVersTP AS
SELECT
  I_ProductionVersion.Material AS Material,
  I_ProductionVersion.Plant AS Plant,
  I_ProductionVersion.ProductionVersion AS ProductionVersion,
  I_ProductionVersion.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_ProductionVersion.BillOfOperationsVariant AS BillOfOperationsVariant,
  I_ProductionVersion.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  I_ProductionVersion.BillOfMaterialVariant AS BillOfMaterialVariant,
  I_ProductionVersion.Material AS MaterialForEdit,
  I_ProductionVersion.Plant AS PlantForEdit,
  I_ProductionVersion.ProductionVersion AS ProductionVersionForEdit,
  MatlPlnt.MRPController AS MRPController,
  I_ProductionVersion.ValidityEndDate AS ValidityEndDate,
  I_ProductionVersion.ValidityStartDate AS ValidityStartDate,
  I_ProductionVersion.BillOfOperationsType AS BillOfOperationsType,
  I_ProductionVersion.ProductionLine AS ProductionLine,
  I_ProductionVersion.ProductionVersionGroup AS ProductionVersionGroup,
  I_ProductionVersion.ProductionVersionText AS ProductionVersionText,
  I_ProductionVersion.QuantityDistributionKey AS QuantityDistributionKey,
  I_ProductionVersion.DistributionKey AS DistributionKey,
  I_ProductionVersion.ProdnVersIsAllowedForRptvMfg AS ProdnVersIsAllowedForRptvMfg,
  I_ProductionVersion.MaterialMinLotSizeQuantity AS MaterialMinLotSizeQuantity,
  I_ProductionVersion.MaterialMaxLotSizeQuantity AS MaterialMaxLotSizeQuantity,
  I_ProductionVersion.ReceivingStorageLocation AS ReceivingStorageLocation,
  I_ProductionVersion.MaterialCostApportionmentStruc AS MaterialCostApportionmentStruc,
  I_ProductionVersion.MainProduct AS MainProduct,
  I_ProductionVersion.IssuingStorageLocation AS IssuingStorageLocation,
  I_ProductionVersion.ProductionSupplyArea AS ProductionSupplyArea,
  I_ProductionVersion.ProductionVersionStatus AS ProductionVersionStatus,
  I_ProductionVersion.ProductionVersionLastCheckDate AS ProductionVersionLastCheckDate,
  I_ProductionVersion.ProductionVersionIsLocked AS ProductionVersionIsLocked,
  I_ProductionVersion.RateBasedPlanningStatus AS RateBasedPlanningStatus,
  I_ProductionVersion.PreliminaryPlanningStatus AS PreliminaryPlanningStatus,
  I_ProductionVersion.BOMCheckStatus AS BOMCheckStatus,
  I_ProductionVersion.OriginalBatchReferenceMaterial AS OriginalBatchReferenceMaterial,
  I_ProductionVersion.ChangeHistoryCount AS ChangeHistoryCount,
  I_ProductionVersion.ChangeNumber AS ChangeNumber,
  I_ProductionVersion.CreationDate AS CreationDate,
  I_ProductionVersion.CreatedByUser AS CreatedByUser,
  I_ProductionVersion.LastChangeDate AS LastChangeDate,
  I_ProductionVersion.LastChangedByUser AS LastChangedByUser,
  cast( ' ' as boole_d) AS CheckStatus,
  I_ProductionVersion.HasVersionCtrldBOMAndRouting AS HasVersionCtrldBOMAndRouting,
  I_ProductionVersion.PlanningAndExecutionBOMIsDiff AS PlanningAndExecutionBOMIsDiff,
  cast( ' ' as mpe_cima_untz_matl_ind_type preserving type ) AS IsMaterialUnitized,
  I_ProductionVersion.ExecBillOfMaterialVariant AS ExecBillOfMaterialVariant,
  I_ProductionVersion.ExecBillOfMaterialVariantUsage AS ExecBillOfMaterialVariantUsage,
  I_ProductionVersion.ExecBillOfOperationsType AS ExecBillOfOperationsType,
  I_ProductionVersion.ExecBillOfOperationsGroup AS ExecBillOfOperationsGroup,
  I_ProductionVersion.ExecBillOfOperationsVariant AS ExecBillOfOperationsVariant,
  I_ProductionVersion.Warehouse AS EWMWarehouse,
  I_ProductionVersion.DestinationStorageBin AS DestinationStorageBin,
  I_ProductionVersion.MaterialBaseUnit AS MaterialBaseUnit
FROM I_ProductionVersion
LEFT OUTER JOIN I_ProdnVersRtgBOMVersTP AS _ProdnVersRtgBOMVers ON Material = _ProdnVersRtgBOMVers.Material AND Plant = _ProdnVersRtgBOMVers.Plant AND ProductionVersion = _ProdnVersRtgBOMVers.ProductionVersion  -- association [0..*]
;

Learn More