I_PRODUCTIONMODELBASIC

CDS View

Production Model Header

I_PRODUCTIONMODELBASIC is a CDS View in S/4HANA. Production Model Header. It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ProductionModel view_entity from COMPOSITE Production Model Header

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ProductionModelUUID ProductionModelUUID 1
BillOfMaterial BillOfMaterial 1
BillOfMaterialCategory BillOfMaterialCategory 1
BillOfMaterialVariant BillOfMaterialVariant 1
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 1
BillOfOperationsGroup BillOfOperationsGroup 1
BillOfOperationsType BillOfOperationsType 1
BillOfOperationsVariant BillOfOperationsVariant 1
Material Material 1
Plant Plant 1
ProdnModComplexAssemblyType ProdnModComplexAssemblyType 1
ProdnModelChangedDateTime ProdnModelChangedDateTime 1
ProdnModelCreationDateTime ProdnModelCreationDateTime 1
ProductionModelChangedByUser ProductionModelChangedByUser 1
ProductionModelCreatedByUser ProductionModelCreatedByUser 1
ProductionModelProcessType ProductionModelProcessType 1
SalesOrder SalesOrder 1
SalesOrderItem SalesOrderItem 1
@EndUserText.label: 'Production Model Header'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #MASTER
}
define view entity I_ProductionModelBasic
  as select from mpe_pmdl_hdr as ProductionModel
{
  key ProductionModel.prodn_model_uuid           as ProductionModelUUID,
      ProductionModel.process_type               as ProductionModelProcessType,
      ProductionModel.prodn_model_type           as ProdnModComplexAssemblyType,
      ProductionModel.material                   as Material,
      cast( ProductionModel.stlnr  as cs_stlnr ) as BillOfMaterial,
      ProductionModel.stlal                      as BillOfMaterialVariant,
      ProductionModel.stlty                      as BillOfMaterialCategory,
      ProductionModel.stlan                      as BillOfMaterialVariantUsage,
      ProductionModel.werks                      as Plant,
      ProductionModel.plnty                      as BillOfOperationsType,
      ProductionModel.plnnr                      as BillOfOperationsGroup,
      ProductionModel.plnal                      as BillOfOperationsVariant,
      ProductionModel.salesorder                 as SalesOrder,
      ProductionModel.salesorder_item            as SalesOrderItem,
      ProductionModel.created_on                 as ProdnModelCreationDateTime,
      ProductionModel.created_by                 as ProductionModelCreatedByUser,
      ProductionModel.changed_on                 as ProdnModelChangedDateTime,
      ProductionModel.changed_by                 as ProductionModelChangedByUser
}