C_ProdnVersStaging

DDL: C_PRODNVERSSTAGING SQL: CPRODNVERSSTG Type: view CONSUMPTION

Production Version Staging

C_ProdnVersStaging is a Consumption CDS View that provides data about "Production Version Staging" in SAP S/4HANA. It reads from 2 data sources (I_Material, I_ProdnVersStaging) and exposes 26 fields with key field DraftUUID.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_Material Material inner
I_ProdnVersStaging ProdnVersStaging from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPRODNVERSSTG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private false view
EndUserText.label Production Version Staging view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.updateEnabled true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID I_ProdnVersStaging DraftUUID
Material I_ProdnVersStaging Material
Plant I_ProdnVersStaging Plant
ProductionVersion I_ProdnVersStaging ProductionVersion
ProductionVersionText I_ProdnVersStaging ProductionVersionText
BillOfOperationsType I_ProdnVersStaging BillOfOperationsType
BillOfOperationsGroup I_ProdnVersStaging BillOfOperationsGroup
BillOfOperationsVariant I_ProdnVersStaging BillOfOperationsVariant
BillOfOperationsVersion I_ProdnVersStaging BillOfOperationsVersion
BillOfMaterialCategory I_ProdnVersStaging BillOfMaterialCategory
BillOfMaterialVariantUsage I_ProdnVersStaging BillOfMaterialVariantUsage
BillOfMaterial I_ProdnVersStaging BillOfMaterial
BillOfMaterialVariant I_ProdnVersStaging BillOfMaterialVariant
MaterialMinLotSizeQuantity I_ProdnVersStaging MaterialMinLotSizeQuantity
MaterialMaxLotSizeQuantity I_ProdnVersStaging MaterialMaxLotSizeQuantity
ValidFrom I_ProdnVersStaging ValidFrom
ValidTo I_ProdnVersStaging ValidTo
ProductionVersionIsLocked I_ProdnVersStaging ProductionVersionIsLocked
ValidityStartDate I_ProdnVersStaging ValidityStartDate
ValidityEndDate I_ProdnVersStaging ValidityEndDate
BillOfMaterialVersion I_ProdnVersStaging BillOfMaterialVersion
ProdnRtgVersBOMInternalID I_ProdnVersStaging ProdnRtgVersBOMInternalID
BillOfOperationsUnit I_ProdnVersStaging BillOfOperationsUnit
IsReadOnly I_ProdnVersStaging IsReadOnly
EffectivityType UnitizedMaterialType EffectivityType
_MaterialText _MaterialText 
@AbapCatalog.sqlViewName: 'CPRODNVERSSTG'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@VDM.private: false
@EndUserText.label: 'Production Version Staging'
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER}
@ObjectModel.updateEnabled: true
define view C_ProdnVersStaging
  as select from           I_ProdnVersStaging     as ProdnVersStaging

    inner join             I_Material             as Material             on Material.Material = ProdnVersStaging.Material

    left outer to one join I_UnitizedMaterialType as UnitizedMaterialType on UnitizedMaterialType.MaterialType = Material.MaterialType

{
  key ProdnVersStaging.DraftUUID,
      ProdnVersStaging.Material,
      ProdnVersStaging.Plant,
      ProdnVersStaging.ProductionVersion,
      ProdnVersStaging.ProductionVersionText,
      ProdnVersStaging.BillOfOperationsType,
      ProdnVersStaging.BillOfOperationsGroup,
      ProdnVersStaging.BillOfOperationsVariant,
      ProdnVersStaging.BillOfOperationsVersion,
      ProdnVersStaging.BillOfMaterialCategory,
      ProdnVersStaging.BillOfMaterialVariantUsage,
      ProdnVersStaging.BillOfMaterial,
      ProdnVersStaging.BillOfMaterialVariant,
      ProdnVersStaging.MaterialMinLotSizeQuantity,
      ProdnVersStaging.MaterialMaxLotSizeQuantity,
      ProdnVersStaging.ValidFrom,
      ProdnVersStaging.ValidTo,
      ProdnVersStaging.ProductionVersionIsLocked,
      ProdnVersStaging.ValidityStartDate,
      ProdnVersStaging.ValidityEndDate,
      ProdnVersStaging.BillOfMaterialVersion,
      ProdnVersStaging.ProdnRtgVersBOMInternalID,
      ProdnVersStaging.BillOfOperationsUnit,
      ProdnVersStaging.IsReadOnly,
      UnitizedMaterialType.EffectivityType,
      _MaterialText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIAL",
"I_PRODNVERSSTAGING",
"I_UNITIZEDMATERIALTYPE"
],
"ASSOCIATED":
[
"I_PRODUCTTEXT"
],
"BASE":
[
"I_PRODNVERSSTAGING"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More