I_BillOfOperationsRelationship

DDL: I_BILLOFOPERATIONSRELATIONSHIP SQL: IBOORELSHP Type: view_entity BASIC

Bill of Operation Relationship

I_BillOfOperationsRelationship is a Basic CDS View that provides data about "Bill of Operation Relationship" in SAP S/4HANA. It reads from 1 data source (plab) and exposes 27 fields with key fields BillOfOperationsType, PrdcssrBOOGroup, PrdcssrBOOVariant, PrdcssrBOOOpInternalID, SuccssrBOOGroup.

1 data source(s) 27 fields

Data Sources (1)

SourceAliasJoin Type
plab plab from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bill of Operation Relationship view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #REQUIRED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsType plnty
KEY PrdcssrBOOGroup plnnr
KEY PrdcssrBOOVariant plnal
KEY PrdcssrBOOOpInternalID plnkn
KEY SuccssrBOOGroup plnrn
KEY SuccssrBOOVariant alnrn
KEY SuccssrBOOOpInternalID knnrn
KEY MasterRecipeRelationshipType
KEY MaxTimeIntvlIsUsedForSchedg mimax
KEY BOOInternalVersionCounter zaehl
ValidityStartDate datuv
ValidityEndDate valid_to
CreationDate andat
CreatedByUser annam
LastChangeDate aedat
LastChangedByUser aenam
ChangeNumber aennr
TimeIntvlBtwnRelshp dauer
MaxTimeIntvlBtwnRelshp dauermax
TimeIntvlBtwnRelshpUnit zeinh
OperationIsSuccessor vornc
OperationIsPredecessor ncvor
FactoryCalendar kalid
IsDeleted loekz
IsImplicitlyDeleted loekz_inherited
WorkCenterInternalID arbid
Plant werks 
//@AbapCatalog.sqlViewName: 'IBOORELSHP'

//@AbapCatalog.compiler.compareFilter: true

//@AbapCatalog.preserveKey: true

//@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Bill of Operation Relationship'
@VDM.viewType: #BASIC
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #XXL, dataClass: #MASTER }
@AccessControl.personalData.blocking: #REQUIRED
//define view I_BillOfOperationsRelationship

define view entity I_BillOfOperationsRelationship
  as select from plab
{
  key plnty                    as BillOfOperationsType,
  key plnnr                    as PrdcssrBOOGroup,
  key plnal                    as PrdcssrBOOVariant,
  key plnkn                    as PrdcssrBOOOpInternalID,
  key plnrn                    as SuccssrBOOGroup,
  key alnrn                    as SuccssrBOOVariant,
  key knnrn                    as SuccssrBOOOpInternalID,
  key cast(aobar as vdm_aobar) as MasterRecipeRelationshipType,
  key mimax                    as MaxTimeIntvlIsUsedForSchedg,
  key zaehl                    as BOOInternalVersionCounter,
      case aobar
           when 'NF'
           then cast('1' as aobky)
           when 'AF'
           then cast('2' as aobky)
           when 'EF'
           then cast('3' as aobky)
           when 'SF'
           then cast('4' as aobky)
           end                 as BOORelationshipType, // For MRC SOAP

      @Semantics.businessDate.from: true
      datuv                    as ValidityStartDate,
      @Semantics.businessDate.to: true
      valid_to                 as ValidityEndDate,
      @Semantics.systemDate.createdAt: true
      andat                    as CreationDate,
      @Semantics.user.createdBy: true
      annam                    as CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      aedat                    as LastChangeDate,
      @Semantics.user.lastChangedBy: true
      aenam                    as LastChangedByUser,
      aennr                    as ChangeNumber,
      dauer                    as TimeIntvlBtwnRelshp,
      dauermax                 as MaxTimeIntvlBtwnRelshp,
      zeinh                    as TimeIntvlBtwnRelshpUnit,
      vornc                    as OperationIsSuccessor,
      ncvor                    as OperationIsPredecessor,
      kalid                    as FactoryCalendar,
      loekz                    as IsDeleted,
      loekz_inherited          as IsImplicitlyDeleted,
      arbid                    as WorkCenterInternalID,
      werks                    as Plant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PLAB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More