Which tables does I_BOOOperationCharacteristic use?

I_BOOOperationCharacteristic reads from 1 data source(s): plas.

I_BOOOperationCharacteristic

Q: How many fields does I_BOOOperationCharacteristic have?

I_BOOOperationCharacteristic has 13 fields. Key fields: BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID.

DDL: I_BOOOPERATIONCHARACTERISTIC SQL: IPPBOOOPCHARC Type: view BASIC

Bill of Operations Operation Characteristic

I_BOOOperationCharacteristic is a Basic CDS View (Dimension) that provides data about "Bill of Operations Operation Characteristic" in SAP S/4HANA. It reads from 1 data source (plas) and exposes 13 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsSequence, BOOOperationInternalID. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
plas	plas	inner

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_BillOfOperations	_BillOfOperations	`$projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant -- to parent`
[1..1]	I_BillOfOperationsOperation	_BillOfOperationsOperation	`$projection.BillOfOperationsType = _BillOfOperationsOperation.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsOperation.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsOperation.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BillOfOperationsOperation.BillOfOperationsSequence and $projection.BOOOperationInternalID = _BillOfOperationsOperation.BOOOperationInternalID -- to child`
[1..*]	I_BOOOpCharacteristicChgSt	_BOOOpCharacteristicChgSt	$projection.BillOfOperationsType = _BOOOpCharacteristicChgSt.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOOpCharacteristicChgSt.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOOpCharacteristicChgSt.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BOOOpCharacteristicChgSt.BillOfOperationsSequence and $projection.BOOOperationInternalID = _BOOOpCharacteristicChgSt.BOOOperationInternalID and $projection.BOOCharacteristic = _BOOOpCharacteristicChgSt.BOOCharacteristic
[1..1]	I_BillOfOperationsSequence	_BillOfOperationsSequence	`$projection.BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperationsSequence.BillOfOperationsVariant and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IPPBOOOPCHARC	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#BASIC	view
Analytics.dataCategory	#DIMENSION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	BOOCharacteristic	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
EndUserText.label	Bill of Operations Operation Characteristic	view
Metadata.allowExtensions	true	view
AbapCatalog.preserveKey	true	view

Fields (13)

Key	Field	Source Table	Source Field
KEY	BillOfOperationsType		BillOfOperationsType
KEY	BillOfOperationsGroup		BillOfOperationsGroup
KEY	BillOfOperationsVariant	plas	plnal
KEY	BillOfOperationsSequence	plas	plnfl
KEY	BOOOperationInternalID		BOOOperationInternalID
KEY	BOOCharacteristic		BOOCharacteristic
	_BillOfOperationsType		_BillOfOperationsType
	_BillOfOperationsGroup		_BillOfOperationsGroup
	_BillOfOperations		_BillOfOperations
	_BillOfOperationsSequence		_BillOfOperationsSequence
	_BOOOperationInternalID		_BOOOperationInternalID
	_BillOfOperationsOperation		_BillOfOperationsOperation
	_BOOOpCharacteristicChgSt		_BOOOpCharacteristicChgSt

@AbapCatalog.sqlViewName: 'IPPBOOOPCHARC'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BOOCharacteristic'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@EndUserText.label: 'Bill of Operations Operation Characteristic'
@Metadata.allowExtensions:true
@AbapCatalog.preserveKey:true 

define view I_BOOOperationCharacteristic 
  as select distinct from I_BOOCharacteristicVersion as _BOOCharcVers
    inner join   plas on  plas.plnty    =  _BOOCharcVers.BillOfOperationsType
                      and plas.plnnr    =  _BOOCharcVers.BillOfOperationsGroup
                      and plas.plnkn    =  _BOOCharcVers.BOOOperationInternalID
                      and plas.datuv    <= _BOOCharcVers.ValidityStartDate // TODO !

                      and plas.valid_to >= _BOOCharcVers.ValidityStartDate

  -- to root
  association [1..1] to I_BillOfOperations            as _BillOfOperations             on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant

  -- to parent
  association [1..1] to I_BillOfOperationsOperation   as _BillOfOperationsOperation    on  $projection.BillOfOperationsType     = _BillOfOperationsOperation.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup    = _BillOfOperationsOperation.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant  = _BillOfOperationsOperation.BillOfOperationsVariant
                                                                                       and $projection.BillOfOperationsSequence = _BillOfOperationsOperation.BillOfOperationsSequence
                                                                                       and $projection.BOOOperationInternalID   = _BillOfOperationsOperation.BOOOperationInternalID

  -- to child
  association [1..*] to I_BOOOpCharacteristicChgSt      as _BOOOpCharacteristicChgSt    on  $projection.BillOfOperationsType     = _BOOOpCharacteristicChgSt.BillOfOperationsType
                                                                                        and $projection.BillOfOperationsGroup    = _BOOOpCharacteristicChgSt.BillOfOperationsGroup
                                                                                        and $projection.BillOfOperationsVariant  = _BOOOpCharacteristicChgSt.BillOfOperationsVariant
                                                                                        and $projection.BillOfOperationsSequence = _BOOOpCharacteristicChgSt.BillOfOperationsSequence
                                                                                        and $projection.BOOOperationInternalID   = _BOOOpCharacteristicChgSt.BOOOperationInternalID
                                                                                        and $projection.BOOCharacteristic        = _BOOOpCharacteristicChgSt.BOOCharacteristic


  association [1..1] to I_BillOfOperationsSequence    as _BillOfOperationsSequence     on  $projection.BillOfOperationsType     = _BillOfOperationsSequence.BillOfOperationsType
                                                                                       and $projection.BillOfOperationsGroup    = _BillOfOperationsSequence.BillOfOperationsGroup
                                                                                       and $projection.BillOfOperationsVariant  = _BillOfOperationsSequence.BillOfOperationsVariant
                                                                                       and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence


{
      // --------------------------------------------------------------------------------------------------------

      // Key

      // --------------------------------------------------------------------------------------------------------

      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BillOfOperations'
  key plas.plnal as BillOfOperationsVariant,
      @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'
  key plas.plnfl as BillOfOperationsSequence,
      @ObjectModel.foreignKey.association: '_BOOOperationInternalID'
  key BOOOperationInternalID,
      @ObjectModel.foreignKey.association: null
  key BOOCharacteristic,

      // --------------------------------------------------------------------------------------------------------

      // Associations

      // --------------------------------------------------------------------------------------------------------

      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperations,
      _BillOfOperationsSequence,
      _BOOOperationInternalID,
      _BillOfOperationsOperation, // Parent

      _BOOOpCharacteristicChgSt   // Child

    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BOOCHARACTERISTICVERSION",
"PLAS"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSOPERATION",
"I_BILLOFOPERATIONSSEQUENCE",
"I_BILLOFOPERATIONSTYPE",
"I_BOOOPCHARACTERISTICCHGST",
"I_BOOOPERATIONINTERNALID"
],
"BASE":
[
"I_BOOCHARACTERISTICVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BOOOperationCharacteristic view

plas