How many fields does I_MfgOrderItemLongText have?

I_MfgOrderItemLongText has 10 fields. Key fields: ManufacturingOrder, ManufacturingOrderItem, LongTextLanguage.

I_MfgOrderItemLongText

Q: Which tables does I_MfgOrderItemLongText use?

I_MfgOrderItemLongText reads from 3 data source(s): I_OrderComponent, I_OrderItem, I_OrderComponentLongText.

DDL: I_MFGORDERITEMLONGTEXT Type: view_entity COMPOSITE

Manufacturing Order Item - Text

I_MfgOrderItemLongText is a Composite CDS View that provides data about "Manufacturing Order Item - Text" in SAP S/4HANA. It reads from 3 data sources (I_OrderComponent, I_OrderItem, I_OrderComponentLongText) and exposes 10 fields with key fields ManufacturingOrder, ManufacturingOrderItem, LongTextLanguage. It has 3 associations to related views.

Data Sources (3)

Source	Alias	Join Type
I_OrderComponent	comp	inner
I_OrderItem	item	inner
I_OrderComponentLongText	text	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_Language	_LongTextLanguage	`$projection.LongTextLanguage = _LongTextLanguage.Language -- to root: Header`
[1..1]	I_ManufacturingOrder	_MfgOrder	`$projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder -- to parent: Item`
[1..1]	I_ManufacturingOrderItem	_MfgOrderItem	`$projection.ManufacturingOrder = _MfgOrderItem.ManufacturingOrder and $projection.ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem`

Annotations (10)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.dataCategory	#TEXT	view
ObjectModel.modelingPattern	#LANGUAGE_DEPENDENT_TEXT	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view
EndUserText.label	Manufacturing Order Item - Text	view

Fields (10)

Key	Field	Source Table	Source Field
KEY	ManufacturingOrder	I_OrderItem	OrderID
KEY	ManufacturingOrderItem	I_OrderItem	OrderItem
KEY	LongTextLanguage	I_OrderComponentLongText	Language
	Reservation	I_OrderComponentLongText	Reservation
	ReservationItem	I_OrderComponentLongText	ReservationItem
	ManufacturingOrderItemText	I_OrderComponent	MaterialComponentText
	MfgOrderItemLongText	I_OrderComponentLongText	OrderComponentLongText
	_MfgOrder		_MfgOrder
	_MfgOrderItem		_MfgOrderItem
	_LongTextLanguage		_LongTextLanguage

@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Manufacturing Order Item - Text'

define view entity I_MfgOrderItemLongText
    as select from I_OrderComponentLongText as text
        inner join I_OrderComponent         as comp on  comp.Reservation     = text.Reservation
                                                    and comp.ReservationItem = text.ReservationItem
                                                    and comp.RecordType      = text.RecordType
        inner join I_OrderItem              as item on  item.CoProductReservation     = text.Reservation
                                                    and item.CoProductReservationItem = text.ReservationItem
                                                    and ''                            = text.RecordType

    association [1..1] to I_Language               as _LongTextLanguage on  $projection.LongTextLanguage = _LongTextLanguage.Language
--  to root: Header
    association [1..1] to I_ManufacturingOrder     as _MfgOrder         on  $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
--  to parent: Item
    association [1..1] to I_ManufacturingOrderItem as _MfgOrderItem     on  $projection.ManufacturingOrder     = _MfgOrderItem.ManufacturingOrder
                                                                        and $projection.ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem
{
      //  Key

  key item.OrderID   as ManufacturingOrder,
      @ObjectModel.text.element: ['MfgOrderItemLongText']
  key item.OrderItem as ManufacturingOrderItem,
      @Semantics.language: true
  key text.Language  as LongTextLanguage,

     // Technical key

      @Consumption.hidden: true
      text.Reservation,
      @Consumption.hidden: true
      text.ReservationItem,
      
      // Text

      @Semantics.text: true
      comp.MaterialComponentText  as ManufacturingOrderItemText,
      @Semantics.text: true
      text.OrderComponentLongText as MfgOrderItemLongText,

      // Associations

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _MfgOrder,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]     
      _MfgOrderItem,
      _LongTextLanguage
}
  where
      comp.MaterialComponentHasLongText = 'X' and
   (  item.OrderCategory = '10' or
      item.OrderCategory = '40' );
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDERCOMPONENT",
"I_ORDERCOMPONENTLONGTEXT",
"I_ORDERITEM"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MANUFACTURINGORDER",
"I_MANUFACTURINGORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_MfgOrderItemLongText view_entity