I_PRODUCTIONMODELBASIC

CDS View

Production Model Header

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

Used by 4 CDS view(s) 18 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_ProdnModOperationActivity view_entity inner COMPOSITE Production Model Operation Activity
I_ProductionModel view_entity from COMPOSITE Production Model Header
I_ProductionModelOperation view_entity inner COMPOSITE Production Model Operation
P_ProductionModelComponent view_entity inner COMPOSITE Prodn Model Sales Order Component

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ProductionModelUUID ProductionModelUUID 4
BillOfMaterial BillOfMaterial 3
BillOfMaterialCategory BillOfMaterialCategory 4
BillOfMaterialVariant BillOfMaterialVariant 4
BillOfMaterialVariantUsage BillOfMaterialVariantUsage 4
BillOfOperationsGroup BillOfOperationsGroup 4
BillOfOperationsType BillOfOperationsType 4
BillOfOperationsVariant BillOfOperationsVariant 4
Material Material 2
Plant Plant 4
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,
      cast( ProductionModel.plnty as abap.char( 1 ) )  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
}

Learn More