I_CHANGERECDREFPRODNRTGTP_2

CDS View

Change Record Reference Object Prodn Routing

I_CHANGERECDREFPRODNRTGTP_2 is a CDS View in S/4HANA. Change Record Reference Object Prodn Routing. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_ChangeRecordRefProdnRouting view_entity from COMPOSITE Production Routing Assignments to Change Records 
@AbapCatalog.sqlViewName: 'ICRREFPRDNRTGTP2'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType: {
     dataClass:      #MIXED,
     serviceQuality: #C,
     sizeCategory:   #XXL
   }
}
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Change Record Reference Object Prodn Routing'
define view I_ChangeRecdRefProdnRtgTP_2   
 as select from           I_ChgRecdRefProdnRoutingBsc as reference_PRG
    left outer to one join I_BillOfOperations          as ProdnRouting on  reference_PRG.ChgRecRefInternalKey1 = ProdnRouting.BillOfOperationsType
                                                                       and reference_PRG.ChgRecRefInternalKey2 = ProdnRouting.BillOfOperationsGroup
                                                                       and reference_PRG.ChgRecRefInternalKey3 = ProdnRouting.BillOfOperationsVariant  
  association        to parent I_ChangeRecordTP_2 as _ChangeRecordAPITP on $projection.ChangeRecordUUID = _ChangeRecordAPITP.ChangeRecordUUID
  association [0..1] to E_ChgRecdRefProdnRoutingBsc as _ProdnRoutingExtension on $projection.ChangeRecordReferenceUUID = _ProdnRoutingExtension.ChangeRecordReferenceUUID
{
key   reference_PRG.ChangeRecordReferenceUUID,  
      reference_PRG.ChangeRecord,      
        case
           when ProdnRouting.BillOfOperationsType is null then cast(SUBSTRING( reference_PRG.ChangeRecordReference, 1, 1) as plnty)
           else cast(ProdnRouting.BillOfOperationsType as plnty)
           end as BillOfOperationsType,        
        case
        when ProdnRouting.BillOfOperationsGroup is null then  cast(SUBSTRING( reference_PRG.ChangeRecordReference, 2, 9) as plnnr)
        else cast(ProdnRouting.BillOfOperationsGroup as plnnr)
        end    as BillOfOperationsGroup,        
        case
         when ProdnRouting.BillOfOperationsVariant is null then cast (SUBSTRING( reference_PRG.ChangeRecordReference, 10, 2) as plnal)
         else cast(ProdnRouting.BillOfOperationsVariant as plnal)
         end   as BillOfOperationsVariant,        
        reference_PRG.ChangeRecordUUID,
        reference_PRG.ChangeRecordReferenceType,
        //reference_PRG.ChangeRecordReferenceSubtype,

       // reference_PRG.ChangeRecordRefObjectUUID,

       // reference_PRG.ChangeRecordReference,

       // reference_PRG.ParentChangeRecordRefUUID,

        //reference_PRG.IsMainReference,        

        reference_PRG.CreatedByUser,
        reference_PRG.CreationDateTime,        
        reference_PRG.LastChangedByUser,
        reference_PRG.LastChangeDateTime,        
        reference_PRG.ChangeRecordItemRelevance,
        //reference_PRG.ChangeRecordVirtualRefInd,               

        reference_PRG.ChangeRecordItemProcgStatus,      
        _ChangeRecordAPITP
}
where
     ProdnRouting.BillOfOperationsType = 'N'
  or ProdnRouting.BillOfOperationsType is null

Learn More