I_ChgImpactPlngRoutingOp

DDL: I_CHGIMPACTPLNGROUTINGOP SQL: ICHGIMPLNGROUOP Type: view BASIC Package: MPE_PLAN_CIMA

Planning Routing Operation

I_ChgImpactPlngRoutingOp is a Basic CDS View that provides data about "Planning Routing Operation" in SAP S/4HANA. It reads from 2 data sources (plas, I_BillOfOperationsOpBasic) and exposes 28 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BOOOperationInternalID, BillOfOperationsVariant, BOOOpInternalVersionCounter. Part of development package MPE_PLAN_CIMA.

2 data source(s) 28 fields

Data Sources (2)

SourceAliasJoin Type
plas OperationSelection inner
I_BillOfOperationsOpBasic RoutingOperation from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICHGIMPLNGROUOP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Planning Routing Operation view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType I_BillOfOperationsOpBasic BillOfOperationsType
KEY BillOfOperationsGroup I_BillOfOperationsOpBasic BillOfOperationsGroup
KEY BOOOperationInternalID I_BillOfOperationsOpBasic BOOOperationInternalID
KEY BillOfOperationsVariant plas plnal
KEY BOOOpInternalVersionCounter I_BillOfOperationsOpBasic BOOOpInternalVersionCounter
BillOfOperationsSequence plas plnfl
BillOfOperationsVersion I_BillOfOperationsOpBasic BillOfOperationsVersion
WorkCenterInternalID I_BillOfOperationsOpBasic WorkCenterInternalID
WorkCenterTypeCode I_BillOfOperationsOpBasic WorkCenterTypeCode
IsDeleted plas loekz
IsImplicitlyDeleted plas loekz_inherited
OperationExternalID I_BillOfOperationsOpBasic OperationExternalID
Operation I_BillOfOperationsOpBasic Operation_2
OperationText
LongTextLanguageCode I_BillOfOperationsOpBasic LongTextLanguageCode
Plant I_BillOfOperationsOpBasic Plant
OperationControlProfile I_BillOfOperationsOpBasic OperationControlProfile
OperationStandardTextCode I_BillOfOperationsOpBasic OperationStandardTextCode
BillOfOperationsRefType
BillOfOperationsRefGroup I_BillOfOperationsOpBasic BillOfOperationsRefGroup
BillOfOperationsRefVariant I_BillOfOperationsOpBasic BillOfOperationsRefVariant
CreationDate
CreatedByUser I_BillOfOperationsOpBasic CreatedByUser
LastChangeDate I_BillOfOperationsOpBasic LastChangeDate
LastChangedByUser I_BillOfOperationsOpBasic LastChangedByUser
aennrasChangeNumber
ValidityStartDate plas datuv
ValidityEndDate plas valid_to 
@AbapCatalog.sqlViewName: 'ICHGIMPLNGROUOP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Planning Routing Operation'
define view I_ChgImpactPlngRoutingOp
  as select from I_BillOfOperationsOpBasic as RoutingOperation
    inner join   plas                      as OperationSelection on  OperationSelection.plnty = RoutingOperation.BillOfOperationsType
                                                                 and OperationSelection.plnnr = RoutingOperation.BillOfOperationsGroup
                                                                 and OperationSelection.plnkn = RoutingOperation.BOOOperationInternalID
{

  key RoutingOperation.BillOfOperationsType,
  key RoutingOperation.BillOfOperationsGroup,
  key RoutingOperation.BOOOperationInternalID,
  key OperationSelection.plnal as BillOfOperationsVariant,
  key RoutingOperation.BOOOpInternalVersionCounter,
            
      OperationSelection.plnfl as BillOfOperationsSequence,
      RoutingOperation.BillOfOperationsVersion,

      RoutingOperation.WorkCenterInternalID,
      RoutingOperation.WorkCenterTypeCode,
     
      OperationSelection.loekz as IsDeleted,
      OperationSelection.loekz_inherited as IsImplicitlyDeleted,

      // ************************** Operation Header ***************************


      RoutingOperation.OperationExternalID,
      RoutingOperation.Operation_2 as Operation,

      // ************************** Operation General **************************


      -- Operation
      RoutingOperation.OperationText,
      RoutingOperation.LongTextLanguageCode,
      RoutingOperation.Plant,
      RoutingOperation.OperationControlProfile,
      RoutingOperation.OperationStandardTextCode,

      -- Origin
      RoutingOperation.BillOfOperationsRefType,
      RoutingOperation.BillOfOperationsRefGroup,
      RoutingOperation.BillOfOperationsRefVariant,


      // *************************** Administration ****************************


      -- Administrative Data
      RoutingOperation.CreationDate,
      RoutingOperation.CreatedByUser,
      RoutingOperation.LastChangeDate,
      RoutingOperation.LastChangedByUser,

      -- Validity
      OperationSelection.aennr as ChangeNumber,
      OperationSelection.datuv as ValidityStartDate,
      OperationSelection.valid_to as ValidityEndDate

  }

where
      RoutingOperation.BillOfOperationsType =  'P'
  and OperationSelection.loekz              <> 'X'

Learn More