I_PRODNVERSSTAGING
Production Version Staging Basic View
I_PRODNVERSSTAGING is a CDS View in S/4HANA. Production Version Staging Basic View. It contains 24 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ProdnVersStaging | view | from | CONSUMPTION | Production Version Staging |
Fields (24)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | DraftUUID | DraftUUID | 1 |
| BillOfMaterial | BillOfMaterial | 1 | |
| BillOfMaterialCategory | BillOfMaterialCategory | 1 | |
| BillOfMaterialVariant | BillOfMaterialVariant | 1 | |
| BillOfMaterialVariantUsage | BillOfMaterialVariantUsage | 1 | |
| BillOfMaterialVersion | BillOfMaterialVersion | 1 | |
| BillOfOperationsGroup | BillOfOperationsGroup | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| BillOfOperationsUnit | BillOfOperationsUnit | 1 | |
| BillOfOperationsVariant | BillOfOperationsVariant | 1 | |
| BillOfOperationsVersion | BillOfOperationsVersion | 1 | |
| IsReadOnly | IsReadOnly | 1 | |
| Material | Material | 1 | |
| MaterialMaxLotSizeQuantity | MaterialMaxLotSizeQuantity | 1 | |
| MaterialMinLotSizeQuantity | MaterialMinLotSizeQuantity | 1 | |
| Plant | Plant | 1 | |
| ProdnRtgVersBOMInternalID | ProdnRtgVersBOMInternalID | 1 | |
| ProductionVersion | ProductionVersion | 1 | |
| ProductionVersionIsLocked | ProductionVersionIsLocked | 1 | |
| ProductionVersionText | ProductionVersionText | 1 | |
| ValidFrom | ValidFrom | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 | |
| ValidTo | ValidTo | 1 |
@AbapCatalog.sqlViewName: 'IPRODNVERSSTG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Production Version Staging Basic View'
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ProdnVersStaging
as select from mpe_rtg_pvstage
association [0..*] to I_ProductText as _MaterialText on $projection.Material = _MaterialText.Product
{
key guid as DraftUUID,
@ObjectModel.text.association: '_MaterialText'
matnr as Material,
werks as Plant,
verid as ProductionVersion,
text1 as ProductionVersionText,
plnty as BillOfOperationsType,
plnnr as BillOfOperationsGroup,
plnal as BillOfOperationsVariant,
versn as BillOfOperationsVersion,
stlty as BillOfMaterialCategory,
stlan as BillOfMaterialVariantUsage,
stlnr as BillOfMaterial,
stlal as BillOfMaterialVariant,
bstmi as MaterialMinLotSizeQuantity,
bstma as MaterialMaxLotSizeQuantity,
adatu as ValidFrom, // Production Version Start Date I_ProductionVersion
bdatu as ValidTo, //as ValidityEndDate, // Production Version End Date I_ProductionVersion
mksp as ProductionVersionIsLocked,
validitystartdate as ValidityStartDate,
validityenddate as ValidityEndDate,
bom_versn as BillOfMaterialVersion,
zuonr as ProdnRtgVersBOMInternalID,
plnme as BillOfOperationsUnit,
isnew as IsReadOnly,
_MaterialText
}