I_CHGRECDREFPRODNROUTINGTP

CDS View

Change Record Reference Object Production Routing TP

I_CHGRECDREFPRODNROUTINGTP is a CDS View in S/4HANA. Change Record Reference Object Production Routing TP. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ChangeRecdObjPgProdnRouting view from CONSUMPTION Change Record Object Page Production Routing

Fields (3)

KeyField CDS FieldsUsed in Views
BillOfOperationsType BillOfOperationsType 1
CreatedByUser CreatedByUser 1
LastChangedByUser LastChangedByUser 1 
@AbapCatalog.sqlViewName: 'ICRREFPRDNRTGTP'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Change Record Reference Object Production Routing TP'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel: { semanticKey: ['BillOfOperationsType','BillOfOperationsGroup','BillOfOperationsVariant'],
                writeDraftPersistence: 'PLMCRREFPRG_D',
                createEnabled : 'EXTERNAL_CALCULATION',
                deleteEnabled : 'EXTERNAL_CALCULATION',
                updateEnabled : 'EXTERNAL_CALCULATION'
              }
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true 
define view I_ChgRecdRefProdnRoutingTP
  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
  //                                                            and reference_PRG.ChgRecRefInternalKey4 = Routing.BillOfOperationsVersion

  association [1..1] to I_ChangeRecordDraftTP       as _ChangeRecordTP        on $projection.ChangeRecordUUID = _ChangeRecordTP.ChangeRecordUUID
  association [0..1] to E_ChgRecdRefProdnRoutingBsc as _ProdnRoutingExtension on $projection.ChangeRecordReferenceUUID = _ProdnRoutingExtension.ChangeRecordReferenceUUID
{
  key   reference_PRG.ChangeRecordReferenceUUID,
        @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
        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,

        @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
        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,

        @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
        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,

        //        case

        //          when Routing.BillOfOperationsVersion is null then cast (SUBSTRING( reference_PRG.ChangeRecordReference, 12, 4) as plnversn)

        //          else cast(Routing.BillOfOperationsVersion as plnversn)

        //          end                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                as     BillOfOperationsVersion,

        reference_PRG.ChangeRecordUUID,
        reference_PRG.ChangeRecordReferenceType,
        reference_PRG.ChangeRecordReferenceSubtype,
        reference_PRG.ChangeRecordRefObjectUUID,
        reference_PRG.ChangeRecordReference,
        reference_PRG.ParentChangeRecordRefUUID,
        reference_PRG.IsMainReference, 
        ChgRecdReasonForChange,
        ExpdCompltnDte,
        ChgRecdAuthznGrpText,
        ChgRecdNmbrChgSts,
          
        
        
        @Semantics.user.createdBy: true
        @ObjectModel.readOnly: true
        reference_PRG.CreatedByUser,
        reference_PRG.CreationDateTime,
        @Semantics.user.lastChangedBy: true
        @ObjectModel.readOnly: true
        reference_PRG.LastChangedByUser,
        reference_PRG.LastChangeDateTime,
        @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
        reference_PRG.ChangeRecordItemRelevance,
        reference_PRG.ChangeRecordVirtualRefInd,
        //        @ObjectModel.readOnly: true

        //        Routing.Plant,

        //        @ObjectModel.readOnly: true

        //        Routing.OrderID,

        @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
        reference_PRG.ChangeRecordItemProcgStatus,
        @ObjectModel.readOnly: true
        reference_PRG.ChgRecdCurrentItemProcgStatus,
         @ObjectModel.readOnly: true
        reference_PRG.ChgRecdItmTgtSts,
         @ObjectModel.readOnly: true
        reference_PRG.ChgRecdItmDSgntr,
        @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
        _ChangeRecordTP
}
where
     ProdnRouting.BillOfOperationsType = 'N'
  or ProdnRouting.BillOfOperationsType is null  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONS",
"I_CHGRECDREFPRODNROUTINGBSC"
],
"ASSOCIATED":
[
"E_CHGRECDREFPRODNROUTINGBSC",
"I_CHANGERECORDDRAFTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More