C_ChgImpactRoutingDets

DDL: C_CHGIMPACTROUTINGDETS SQL: CCHGIMPCTROUT Type: view CONSUMPTION

Routing Details

C_ChgImpactRoutingDets is a Consumption CDS View that provides data about "Routing Details" in SAP S/4HANA. It reads from 1 data source (I_ProductionRoutingVersion) and exposes 33 fields with key fields BillOfOperationsGroup, BillOfOperationsType, BillOfOperationsVariant, BillOfOperationsVersion. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductionRoutingVersion ChgImpactRoutingDets from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_BillOfOperationsTypeText _BillOfOperationsTypeText $projection.BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType
[0..1] I_BillOfOperationsStatusText _BillOfOperationsStatusText $projection.BillOfOperationsStatus = _BillOfOperationsStatusText.BillOfOperationsStatus and _BillOfOperationsStatusText.Language = $session.system_language
[0..*] C_ChgImpactRoutingMBOM _ChgImpactRoutingMBOM $projection.BillOfOperationsGroup = _ChgImpactRoutingMBOM.BillOfOperationsGroup and $projection.BillOfOperationsType = _ChgImpactRoutingMBOM.BillOfOperationsType and $projection.BillOfOperationsVariant = _ChgImpactRoutingMBOM.BillOfOperationsVariant and $projection.BillOfOperationsVersion = _ChgImpactRoutingMBOM.BillOfOperationsVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCHGIMPCTROUT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Routing Details view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
UI.headerInfo.title.value BillOfOperationsGroup view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsGroup I_ProductionRoutingVersion BillOfOperationsGroup
KEY BillOfOperationsType I_ProductionRoutingVersion BillOfOperationsType
KEY BillOfOperationsVariant I_ProductionRoutingVersion BillOfOperationsVariant
KEY BillOfOperationsVersion I_ProductionRoutingVersion BillOfOperationsVersion
BillOfOperationsDesc I_ProductionRoutingVersion BillOfOperationsDesc
BillOfOperationsVersionStatus I_ProductionRoutingVersion BillOfOperationsVersionStatus
BillOfOperationsUsage I_ProductionRoutingVersion BillOfOperationsUsage
BillOfOperationsStatus I_ProductionRoutingVersion BillOfOperationsStatus
BillOfOperationsStatusDesc _BillOfOperationsStatusText BillOfOperationsStatusDesc
ProductionPlant I_ProductionRoutingVersion Plant
MinimumLotSizeQuantity I_ProductionRoutingVersion MinimumLotSizeQuantity
MaximumLotSizeQuantity I_ProductionRoutingVersion MaximumLotSizeQuantity
ResponsiblePlannerGroup I_ProductionRoutingVersion ResponsiblePlannerGroup
WorkCenter I_ProductionRoutingVersion WorkCenter
BillOfOperationsUnit I_ProductionRoutingVersion BillOfOperationsUnit
InspectionPartialLot I_ProductionRoutingVersion InspectionPartialLot
InspExternalNumberingOfValues I_ProductionRoutingVersion InspExternalNumberingOfValues
InspSubsetFieldCombination I_ProductionRoutingVersion InspSubsetFieldCombination
SmplDrawingProcedure I_ProductionRoutingVersion SmplDrawingProcedure
InspLotDynamicRule I_ProductionRoutingVersion InspLotDynamicRule
InspectionLotDynamicLevel I_ProductionRoutingVersion InspectionLotDynamicLevel
CreationDateTime I_ProductionRoutingVersion CreationDateTime
CreatedByUser I_ProductionRoutingVersion CreatedByUser
LastChangeDateTime I_ProductionRoutingVersion LastChangeDateTime
LastChangedByUser I_ProductionRoutingVersion LastChangedByUser
LastUsageDate I_ProductionRoutingVersion LastUsageDate
NumberOfUsages I_ProductionRoutingVersion NumberOfUsages
ValidityStartDate
ValidityEndDate
BillOfOperationsTypeName
_BillOfOperationsTypeText _BillOfOperationsTypeText
_ChgImpactRoutingMBOM _ChgImpactRoutingMBOM
_BillOfOperationsStatusText _BillOfOperationsStatusText
@AbapCatalog.sqlViewName: 'CCHGIMPCTROUT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Routing Details'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
@ObjectModel.semanticKey:  [ 'BillOfOperationsGroup', 'BillOfOperationsType', 'BillOfOperationsVariant', 'BillOfOperationsVersion' ]
@UI.headerInfo:
{

  title:{value:'BillOfOperationsGroup'}
  //description:{value:'BillOfOperationsGroup'}

}
define view C_ChgImpactRoutingDets
  as select from I_ProductionRoutingVersion as ChgImpactRoutingDets
  //association [0..1] to I_Plant                   as _PlantText    on  $projection.Plant = _PlantText.Plant

  association [0..*] to I_BillOfOperationsTypeText   as _BillOfOperationsTypeText   on  $projection.BillOfOperationsType = _BillOfOperationsTypeText.BillOfOperationsType
  //   and   _BillOfOperationsTypeText.Language = $session.system_language

  association [0..1] to I_BillOfOperationsStatusText as _BillOfOperationsStatusText on  $projection.BillOfOperationsStatus   = _BillOfOperationsStatusText.BillOfOperationsStatus
                                                                                    and _BillOfOperationsStatusText.Language = $session.system_language
  association [0..*] to C_ChgImpactRoutingMBOM       as _ChgImpactRoutingMBOM       on  $projection.BillOfOperationsGroup   = _ChgImpactRoutingMBOM.BillOfOperationsGroup
                                                                                    and $projection.BillOfOperationsType    = _ChgImpactRoutingMBOM.BillOfOperationsType
                                                                                    and $projection.BillOfOperationsVariant = _ChgImpactRoutingMBOM.BillOfOperationsVariant
                                                                                    and $projection.BillOfOperationsVersion = _ChgImpactRoutingMBOM.BillOfOperationsVersion
{

       @UI.facet: [
            ----HeaderFacets
              { type: #FIELDGROUP_REFERENCE, position: 10, targetQualifier: 'GeneralData'},
              { type: #FIELDGROUP_REFERENCE, position: 20, targetQualifier: 'QualityManagement'},
              { type: #FIELDGROUP_REFERENCE, position: 30, targetQualifier: 'AdministrativeData'}

              ]

      // @UI.identification.position:10

      @UI.fieldGroup:[{position: 10,qualifier: 'Qualifier1',label:'Group', importance: #HIGH}]
       @UI.lineItem:[{position: 10,importance: #HIGH}]
       //@UI.fieldGroup:[{position: 10,qualifier: 'GeneralData',groupLabel: 'General Data'}]

  key  ChgImpactRoutingDets.BillOfOperationsGroup,
      // @UI.identification.position:20

        @UI.fieldGroup:[{position: 20,qualifier: 'Qualifier1',label:'Task List Type', importance: #HIGH}]
       @UI.lineItem:[{position: 20,importance: #HIGH }]
       @ObjectModel.text.element:  [ 'BillOfOperationsTypeName' ]
  key  ChgImpactRoutingDets.BillOfOperationsType,
       //@UI.identification.position:20

       @UI.fieldGroup:[{position: 10,qualifier: 'Qualifier2',label:'Group Counter', importance: #HIGH}]
      @UI.lineItem:[{position: 30,importance: #HIGH }]
       //@UI.fieldGroup:[{position: 20,qualifier: 'GeneralData',groupLabel: 'General Data'}]

  key  ChgImpactRoutingDets.BillOfOperationsVariant,

       //@UI.identification.position:30

       @UI.fieldGroup:[{position: 20,qualifier: 'Qualifier2',label:'Routing Version', importance: #HIGH}]
       @UI.lineItem:[{position: 40,importance: #HIGH }]
       //@UI.fieldGroup:[{position: 30,qualifier: 'GeneralData',groupLabel: 'General Data'}]

       @ObjectModel.text.element: null
  key  ChgImpactRoutingDets.BillOfOperationsVersion,

       //       @UI.fieldGroup:[{position: 10,qualifier: 'ObjectDetails',groupLabel: 'Object Details'}]

       //       ChgImpactRoutingDets.BillOfOperationsSubtype,

       //

       //

       //       @UI.fieldGroup:[{position: 20,qualifier: 'ObjectDetails',groupLabel: 'Object Details'}]

       //       ChgImpactRoutingDets.BOOInternalVersionCounter,

       //       @UI.fieldGroup:[{position: 30,qualifier: 'ObjectDetails',groupLabel: 'Object Details'}]

       //       ChgImpactRoutingDets.ValidityStartDate,

       //       @UI.fieldGroup:[{position: 40,qualifier: 'ObjectDetails',groupLabel: 'Object Details'}]

       //       ChgImpactRoutingDets.ValidityEndDate,

       //       @UI.fieldGroup:[{position: 50,qualifier: 'ObjectDetails',groupLabel: 'Object Details'}]

       //       ChgImpactRoutingDets.CreatedByUser,

       //        @UI.fieldGroup:[{position: 60,qualifier: 'ObjectDetails',groupLabel: 'Object Details'}]

       //        ChgImpactRoutingDets.BOOReferenceVersion,



       @UI.fieldGroup:[{position: 40,qualifier: 'GeneralData',groupLabel: 'General Data' }]
       ChgImpactRoutingDets.BillOfOperationsDesc,
       @UI.fieldGroup:[{position: 50,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       ChgImpactRoutingDets.BillOfOperationsVersionStatus,
       @UI.fieldGroup:[{position: 60,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       ChgImpactRoutingDets.BillOfOperationsUsage,
       @UI.hidden: true
       ChgImpactRoutingDets.BillOfOperationsStatus,
       @UI.fieldGroup:[{position: 70,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       //       @ObjectModel.text.element:  [ 'BillOfOperationsStatusDesc' ]


       _BillOfOperationsStatusText.BillOfOperationsStatusDesc,
       @UI.fieldGroup:[{position: 80,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       ChgImpactRoutingDets.Plant                                                                    as ProductionPlant,
       @UI.fieldGroup:[{position: 90,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
       ChgImpactRoutingDets.MinimumLotSizeQuantity,
       @UI.fieldGroup:[{position: 100,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       @Semantics.quantity.unitOfMeasure: 'BillOfOperationsUnit'
       ChgImpactRoutingDets.MaximumLotSizeQuantity,
       @UI.fieldGroup:[{position: 110,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       ChgImpactRoutingDets.ResponsiblePlannerGroup,
       @UI.fieldGroup:[{position: 120,qualifier: 'GeneralData',groupLabel: 'General Data'}]
       ChgImpactRoutingDets.WorkCenter,

       @Semantics.unitOfMeasure: true
       ChgImpactRoutingDets.BillOfOperationsUnit,

       @UI.fieldGroup:[{position: 10,qualifier: 'QualityManagement',groupLabel: 'Quality Management'}]
       ChgImpactRoutingDets.InspectionPartialLot,
       @UI.fieldGroup:[{position: 20,qualifier: 'QualityManagement',groupLabel: 'Quality Management'}]
       ChgImpactRoutingDets.InspExternalNumberingOfValues,
       @UI.fieldGroup:[{position: 30,qualifier: 'QualityManagement',groupLabel: 'Quality Management'}]
       ChgImpactRoutingDets.InspSubsetFieldCombination,
       @UI.fieldGroup:[{position: 40,qualifier: 'QualityManagement',groupLabel: 'Quality Management'}]
       ChgImpactRoutingDets.SmplDrawingProcedure,
       @UI.fieldGroup:[{position: 50,qualifier: 'QualityManagement',groupLabel: 'Quality Management'}]
       ChgImpactRoutingDets.InspLotDynamicRule,
       @UI.fieldGroup:[{position: 60,qualifier: 'QualityManagement',groupLabel: 'Quality Management'}]
       ChgImpactRoutingDets.InspectionLotDynamicLevel,

       @UI.fieldGroup:[{position: 10,qualifier: 'AdministrativeData',groupLabel: 'Administrative Data'}]
       ChgImpactRoutingDets.CreationDateTime,
       @UI.fieldGroup:[{position: 20,qualifier: 'AdministrativeData',groupLabel: 'Administrative Data'}]
       ChgImpactRoutingDets.CreatedByUser,
       @UI.fieldGroup:[{position: 30,qualifier: 'AdministrativeData',groupLabel: 'Administrative Data'}]
       ChgImpactRoutingDets.LastChangeDateTime,
       @UI.fieldGroup:[{position: 40,qualifier: 'AdministrativeData',groupLabel: 'Administrative Data'}]
       ChgImpactRoutingDets.LastChangedByUser,
       @UI.fieldGroup:[{position: 50,qualifier: 'AdministrativeData',groupLabel: 'Administrative Data'}]
       ChgImpactRoutingDets.LastUsageDate,
       @UI.fieldGroup:[{position: 60,qualifier: 'AdministrativeData',groupLabel: 'Administrative Data'}]
       ChgImpactRoutingDets.NumberOfUsages,
       
       @UI.hidden: true
       cast('00000000'as abap.dats) as ValidityStartDate, // For Filterring data based on Date Range 

       @UI.hidden: true
       cast('00000000'as abap.dats) as ValidityEndDate, // For Filterring data based on Date Range



       @UI.hidden: true
       _BillOfOperationsTypeText[1:Language = $session.system_language].BillOfOperationsTypeName      as BillOfOperationsTypeName,

       //       @UI.hidden: true

       //       _BillOfOperationsStatusText[1:Language = $session.system_language].BillOfOperationsStatusDesc  as BillOfOperationsStatusDesc,

       // _PlantText,

       _BillOfOperationsTypeText,
       _ChgImpactRoutingMBOM,
       _BillOfOperationsStatusText


}