I_BILLOFOPSOPWRKCTRGROUPING

CDS View

Grpg of WrkCntr on BillOfOps Group Type

I_BILLOFOPSOPWRKCTRGROUPING is a CDS View in S/4HANA. Grpg of WrkCntr on BillOfOps Group Type. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BillOfOpsOpWorkCenterCount view_entity from COMPOSITE Bill of Operations Work Center Count
I_BillOfOpsOpWrkCtrWhereUsed view from COMPOSITE Bill of Ops Work Center Where Used

Fields (5)

KeyField CDS FieldsUsed in Views
KEY BillOfOperationsGroup BillOfOperationsGroup 1
KEY BillOfOperationsType BillOfOperationsType 1
KEY BillOfOperationsVariant BillOfOperationsVariant 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #L, dataClass: #MASTER }
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Grpg of WrkCntr on BillOfOps Group Type'
define view entity I_BillOfOpsOpWrkCtrGrouping
  as select distinct from I_BillOfOperationsOpBasic     as _OP
  
    inner join            I_MassMaintCapAreaOfRespyPlant as _AOR                 on _AOR.Plant = _OP.Plant

    inner join            I_BOOSqncOperationAssgmtChgSt as _OperationActivities on  _OperationActivities.IsDeleted              = ''
                                                                                and _OperationActivities.BillOfOperationsType   = _OP.BillOfOperationsType
                                                                                and _OperationActivities.BillOfOperationsGroup  = _OP.BillOfOperationsGroup
                                                                                and _OperationActivities.BOOOperationInternalID = _OP.BOOOperationInternalID
  //  inner join I_BillOfOperationsChangeState as _OperationsChangeSet on

  //                                                                            _OperationActivities.BillOfOperationsType   = _OperationsChangeSet.BillOfOperationsType

  //                                                                            and _OperationActivities.BillOfOperationsGroup  = _OperationsChangeSet.BillOfOperationsGroup

  //                                                                            and _OperationActivities.BillOfOperationsVariant = _OperationsChangeSet.BillOfOperationsVariant


{
  key _OP.BillOfOperationsType,
  key _OP.BillOfOperationsGroup,
  key _OP.WorkCenterInternalID,
  key _OP.WorkCenterTypeCode,
  key _OperationActivities.BillOfOperationsVariant
      //  key _OperationsChangeSet.BillOfOperationsDesc

}
where
       _OP.ValidityEndDate                  >= $session.system_date
  and  _OP.WorkCenterInternalID != '00000000'
  and  _OperationActivities.ValidityEndDate >= $session.system_date
  and(
       _OP.BillOfOperationsType             = '2'
    or _OP.BillOfOperationsType             = 'N'
  )
  and  _OP.WorkCenterTypeCode               = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFOPERATIONSOPBASIC",
"I_BOOSQNCOPERATIONASSGMTCHGST",
"I_MASSMAINTCAPAREAOFRESPYPLANT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More