I_BILLOFOPERATIONSRELATIONSHIP
Bill of Operation Relationship
I_BILLOFOPERATIONSRELATIONSHIP is a CDS View in S/4HANA. Bill of Operation Relationship. It contains 27 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MasterRecipeRelationship | view_entity | from | COMPOSITE | Master Recipe Relationship Details |
| R_MaintTaskListOpRelshpTP | view_entity | from | TRANSACTIONAL | Operation Relationships |
Fields (27)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillOfOperationsType | TaskListType | 1 |
| KEY | BOOInternalVersionCounter | TaskListOpBOMItmIntVersCounter | 1 |
| KEY | PrdcssrBOOGroup | TaskListGroup | 1 |
| KEY | PrdcssrBOOOpInternalID | TaskListOperationInternalId | 1 |
| KEY | PrdcssrBOOVariant | TaskListGroupCounter | 1 |
| BOORelationshipType | BOORelationshipType | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| FactoryCalendar | FactoryCalendar | 1 | |
| IsDeleted | IsDeleted | 1 | |
| IsImplicitlyDeleted | IsImplicitlyDeleted | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| MasterRecipeRelationshipType | MasterRecipeRelationshipType | 1 | |
| MaxTimeIntvlBtwnRelshp | MaxTimeIntvlBtwnRelshp | 1 | |
| MaxTimeIntvlIsUsedForSchedg | MaxTimeIntvlIsUsedForSchedg | 1 | |
| OperationIsPredecessor | OperationIsPredecessor | 1 | |
| OperationIsSuccessor | OperationIsSuccessor | 1 | |
| Plant | Plant | 1 | |
| SuccssrBOOGroup | SuccssrBOOGroup | 1 | |
| SuccssrBOOOpInternalID | SuccssrBOOOpInternalID | 1 | |
| TimeIntvlBtwnRelshp | TimeIntvlBtwnRelshp | 1 | |
| TimeIntvlBtwnRelshpUnit | TimeIntvlBtwnRelshpUnit | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 | |
| WorkCenterInternalID | WorkCenterInternalID | 1 |
//@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
}