Which tables does I_DocInfoRecdStructureItem use?

I_DocInfoRecdStructureItem reads from 1 data source(s): I_BillOfMaterialItem.

How many fields does I_DocInfoRecdStructureItem have?

I_DocInfoRecdStructureItem has 42 fields. Key fields: BillOfMaterialItemUUID.

I_DocInfoRecdStructureItem

DDL: I_DOCINFORECDSTRUCTUREITEM SQL: ICVDOCSTRUCTITEM Type: view COMPOSITE

Document Stucture Item Details

I_DocInfoRecdStructureItem is a Composite CDS View (Dimension) that provides data about "Document Stucture Item Details" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterialItem) and exposes 42 fields with key field BillOfMaterialItemUUID. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BillOfMaterialItem	bom_item	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..*]	I_DocInfoRecdStructure	_Header	`$projection.BillOfMaterial = _Header.BillOfMaterial and $projection.BillOfMaterialCategory = _Header.BillOfMaterialCategory and $projection.AlternativeBillOfMaterial = _Header.AlternativeBillOfMaterial -- Item Document`
[0..1]	I_DocInfoRecd	_Document	`$projection.DocumentType = _Document.DocumentType and $projection.DocumentInfoRecord = _Document.DocumentInfoRecord and $projection.DocumentVersion = _Document.DocumentVersion and $projection.DocumentPart = _Document.DocumentPart -- Created user full name`
[0..1]	I_User	_CreatedUser	`$projection.CreatedByUser = _CreatedUser.UserID -- Changed user full name`
[0..1]	I_User	_LastChangedUser	`$projection.LastChangedByUser = _LastChangedUser.UserID`
[1..1]	I_UnitOfMeasure	_UnitOfMeasure	`$projection.BillOfMaterialItemUnit = _UnitOfMeasure.UnitOfMeasure`
[0..1]	I_BillOfMaterialItemCategory	_BOMItemCategory	`$projection.BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ICVDOCSTRUCTITEM	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	BillOfMaterialItemUUID	view
Analytics.dataCategory	#DIMENSION	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Document Stucture Item Details	view
VDM.lifecycle.type	#PUBLIC_LOCAL_API	view

Fields (42)

Key	Field	Source Table	Source Field
KEY	BillOfMaterialItemUUID	I_BillOfMaterialItem	BillOfMaterialItemUUID
	BillOfMaterialCategory	I_BillOfMaterialItem	BillOfMaterialCategory
	BillOfMaterial	I_BillOfMaterialItem	BillOfMaterial
	BillOfMaterialItemNodeNumber	I_BillOfMaterialItem	BillOfMaterialItemNodeNumber
	BOMItemInternalChangeCount	I_BillOfMaterialItem	BOMItemInternalChangeCount
	AlternativeBillOfMaterial	I_BillOfMaterialItem	BillOfMaterialVariant
	BillOfMaterialItemCategory	I_BillOfMaterialItem	BillOfMaterialItemCategory
	BillOfMaterialItemNumber	I_BillOfMaterialItem	BillOfMaterialItemNumber
	DocumentType	I_BillOfMaterialItem	DocumentType
	DocumentInfoRecord	I_BillOfMaterialItem	DocNumber
	DocumentVersion	I_BillOfMaterialItem	DocumentVersion
	DocumentPart	I_BillOfMaterialItem	DocumentPart
	ValidityStartDate	I_BillOfMaterialItem	ValidityStartDate
	ValidityEndDate	I_BillOfMaterialItem	ValidityEndDate
	EngineeringChangeDocument	I_BillOfMaterialItem	EngineeringChangeDocument
	ChgToEngineeringChgDocument	I_BillOfMaterialItem	ChgToEngineeringChgDocument
	BillOfMaterialItemUnit	I_BillOfMaterialItem	BillOfMaterialItemUnit
	BillOfMaterialItemQuantity	I_BillOfMaterialItem	BillOfMaterialItemQuantity
	FixedQuantity	I_BillOfMaterialItem	FixedQuantity
	IsSubItem	I_BillOfMaterialItem	IsSubItem
	BOMItemSorter	I_BillOfMaterialItem	BOMItemSorter
	IsBOMRecursiveAllowed	I_BillOfMaterialItem	IsBOMRecursiveAllowed
	BOMIsRecursive	I_BillOfMaterialItem	BOMIsRecursive
	IsALE	I_BillOfMaterialItem	IsALE
	DocumentIsCreatedByCAD	I_BillOfMaterialItem	DocumentIsCreatedByCAD
	ReferencePoint	I_BillOfMaterialItem	ReferencePoint
	IsAssembly	I_BillOfMaterialItem	IsAssembly
	BOMItemDescription	I_BillOfMaterialItem	BOMItemDescription
	BOMItemText2	I_BillOfMaterialItem	BOMItemText2
	BOMItemIsPlantMaintRelevant	I_BillOfMaterialItem	BOMItemIsPlantMaintRelevant
	IsEngineeringRelevant	I_BillOfMaterialItem	IsEngineeringRelevant
	IsDeleted	I_BillOfMaterialItem	IsDeleted
	CreationDate	I_BillOfMaterialItem	BOMItemRecordCreationDate
	CreatedByUser	I_BillOfMaterialItem	BOMItemCreatedByUser
	LastChangeDate	I_BillOfMaterialItem	BOMItemRecordCreationDate
	LastChangedByUser	I_BillOfMaterialItem	BOMItemLastChangedByUser
	Associations_Header
	_Document		_Document
	_CreatedUser		_CreatedUser
	_LastChangedUser		_LastChangedUser
	_UnitOfMeasure		_UnitOfMeasure
	_BOMItemCategory		_BOMItemCategory

@AbapCatalog.sqlViewName: 'ICVDOCSTRUCTITEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.privilegedAssociations:  [ '_CreatedUser', '_LastChangedUser']
@ObjectModel.representativeKey: 'BillOfMaterialItemUUID'
@Analytics: { dataCategory: #DIMENSION }
@Metadata.allowExtensions: true
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #MIXED}
@EndUserText.label: 'Document Stucture Item Details'
@VDM.lifecycle: {
  contract.
    type: #PUBLIC_LOCAL_API
}
define view I_DocInfoRecdStructureItem
  as select from I_BillOfMaterialItem as bom_item
  -- Header Association
  association [1..*] to I_DocInfoRecdStructure as _Header on  $projection.BillOfMaterial            = _Header.BillOfMaterial
                                                          and $projection.BillOfMaterialCategory    = _Header.BillOfMaterialCategory
                                                          and $projection.AlternativeBillOfMaterial = _Header.AlternativeBillOfMaterial

  -- Item Document
  association [0..1] to I_DocInfoRecd as _Document on  $projection.DocumentType       = _Document.DocumentType
                                                   and $projection.DocumentInfoRecord          = _Document.DocumentInfoRecord
                                                   and $projection.DocumentVersion    = _Document.DocumentVersion
                                                   and $projection.DocumentPart       = _Document.DocumentPart

  -- Created user full name
  association [0..1] to I_User as _CreatedUser     on  $projection.CreatedByUser = _CreatedUser.UserID

  -- Changed user full name
  association [0..1] to I_User as _LastChangedUser on  $projection.LastChangedByUser = _LastChangedUser.UserID

  association [1..1] to I_UnitOfMeasure as _UnitOfMeasure   on  $projection.BillOfMaterialItemUnit = _UnitOfMeasure.UnitOfMeasure

  association [0..1] to I_BillOfMaterialItemCategory as _BOMItemCategory on  $projection.BillOfMaterialItemCategory = _BOMItemCategory.BillOfMaterialItemCategory
{
      @ObjectModel.readOnly: true
  key bom_item.BillOfMaterialItemUUID as BillOfMaterialItemUUID,

      @ObjectModel.readOnly: true
      bom_item.BillOfMaterialCategory as BillOfMaterialCategory,

      @ObjectModel.readOnly: true
      bom_item.BillOfMaterial as BillOfMaterial,

      @ObjectModel.readOnly: true
      bom_item.BillOfMaterialItemNodeNumber as BillOfMaterialItemNodeNumber,

      @ObjectModel.readOnly: true
      bom_item.BOMItemInternalChangeCount as BOMItemInternalChangeCount,

      @ObjectModel.readOnly: true
      bom_item.BillOfMaterialVariant as AlternativeBillOfMaterial,

      //@ObjectModel.updateEnabled: true

      bom_item.BillOfMaterialItemCategory as BillOfMaterialItemCategory,

      //@ObjectModel.updateEnabled: true

      bom_item.BillOfMaterialItemNumber as BillOfMaterialItemNumber,

      //@ObjectModel.updateEnabled: true

      bom_item.DocumentType as DocumentType,

      //@ObjectModel.updateEnabled: true

      bom_item.DocNumber as DocumentInfoRecord,

      //@ObjectModel.updateEnabled: true

      bom_item.DocumentVersion as DocumentVersion,

      //@ObjectModel.updateEnabled: true

      bom_item.DocumentPart as  DocumentPart,

      //@ObjectModel.updateEnabled: true

      bom_item.ValidityStartDate as ValidityStartDate,

      @ObjectModel.readOnly: true
      bom_item.ValidityEndDate as  ValidityEndDate,

      //@ObjectModel.updateEnabled: true

      bom_item.EngineeringChangeDocument as  EngineeringChangeDocument,

      @ObjectModel.readOnly: true
      bom_item.ChgToEngineeringChgDocument as ChgToEngineeringChgDocument,

      //@ObjectModel.updateEnabled: true

      @Semantics.unitOfMeasure: true
      bom_item.BillOfMaterialItemUnit as BillOfMaterialItemUnit,

      //@ObjectModel.updateEnabled: true

      @Semantics.quantity.unitOfMeasure: 'BillOfMaterialItemUnit'
      @DefaultAggregation: #NONE
      bom_item.BillOfMaterialItemQuantity as BillOfMaterialItemQuantity,

      //@ObjectModel.updateEnabled: true

      bom_item.FixedQuantity as FixedQuantity,

      @ObjectModel.readOnly: true
      bom_item.IsSubItem as IsSubItem,

      //@ObjectModel.updateEnabled: true

      bom_item.BOMItemSorter as BOMItemSorter,

      //@ObjectModel.updateEnabled: true

      bom_item.IsBOMRecursiveAllowed as IsBOMRecursiveAllowed,

      @ObjectModel.readOnly: true
      bom_item.BOMIsRecursive as BOMIsRecursive,

      //@ObjectModel.updateEnabled: true

      bom_item.IsALE as IsALE,

      //@ObjectModel.updateEnabled: true

      bom_item.DocumentIsCreatedByCAD as DocumentIsCreatedByCAD,

      //@ObjectModel.updateEnabled: true

      bom_item.ReferencePoint as ReferencePoint,

      @ObjectModel.readOnly: true
      bom_item.IsAssembly as IsAssembly,

      //@ObjectModel.updateEnabled: true

      bom_item.BOMItemDescription as BOMItemDescription,

      //@ObjectModel.updateEnabled: true

      bom_item.BOMItemText2 as BOMItemText2,

      //@ObjectModel.updateEnabled: true

      bom_item.BOMItemIsPlantMaintRelevant as BOMItemIsPlantMaintRelevant,

      //@ObjectModel.updateEnabled: true

      bom_item.IsEngineeringRelevant as IsEngineeringRelevant,

      //@ObjectModel.updateEnabled: true

      bom_item.IsDeleted as    IsDeleted,

      @Semantics.businessDate.createdAt: true
      bom_item.BOMItemRecordCreationDate as CreationDate,

      @Semantics.user.createdBy: true
      bom_item.BOMItemCreatedByUser as  CreatedByUser,
      
      @Semantics.businessDate.at: true
      @Semantics.businessDate.changedAt: true
      bom_item.BOMItemRecordCreationDate as LastChangeDate,

      @Semantics.user.lastChangedBy: true
      bom_item.BOMItemLastChangedByUser as  LastChangedByUser,      

      --Associations
      _Header,
      _Document,
      _CreatedUser,
      _LastChangedUser,
      _UnitOfMeasure,
      _BOMItemCategory

}
where
  BillOfMaterialCategory = 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLOFMATERIALITEM"
],
"ASSOCIATED":
[
"I_BILLOFMATERIALITEMCATEGORY",
"I_DOCINFORECD",
"I_DOCINFORECDSTRUCTURE",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_DocInfoRecdStructureItem view

I_BillOfMaterialItem view