Which tables does I_DocInfoRecdStructure use?

I_DocInfoRecdStructure reads from 1 data source(s): I_BillOfMaterial.

How many fields does I_DocInfoRecdStructure have?

I_DocInfoRecdStructure has 36 fields. Key fields: BillOfMaterialHeaderUUID.

I_DocInfoRecdStructure

DDL: I_DOCINFORECDSTRUCTURE SQL: ICVDOCSTRUCT Type: view COMPOSITE

Document Structure Header Details

I_DocInfoRecdStructure is a Composite CDS View (Dimension) that provides data about "Document Structure Header Details" in SAP S/4HANA. It reads from 1 data source (I_BillOfMaterial) and exposes 36 fields with key field BillOfMaterialHeaderUUID. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BillOfMaterial	bom_header	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..*]	I_DocInfoRecdStructureItem	_Item	`$projection.BillOfMaterial = _Item.BillOfMaterial and $projection.BillOfMaterialCategory = _Item.BillOfMaterialCategory and $projection.AlternativeBillOfMaterial = _Item.AlternativeBillOfMaterial -- Document Key`
[0..1]	I_DocInfoRecd	_DocumentInfo	`$projection.DocumentType = _DocumentInfo.DocumentType and $projection.DocumentInfoRecord = _DocumentInfo.DocumentInfoRecord and $projection.DocumentVersion = _DocumentInfo.DocumentVersion and $projection.DocumentPart = _DocumentInfo.DocumentPart -- BOM Changes`
[0..*]	I_BomChanges	_BomChanges	`$projection.BillOfMaterial = _BomChanges.BillOfMaterial and $projection.BillOfMaterialCategory = _BomChanges.BillOfMaterialCategory and $projection.AlternativeBillOfMaterial = _BomChanges.BillOfMaterialVariant and $projection.EngineeringChangeDocument = _BomChanges.EngineeringChangeDocument -- 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 -- Unit of measure`
[0..1]	I_UnitOfMeasure	_UnitOfMeasure	`$projection.BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	ICVDOCSTRUCT	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	BillOfMaterialHeaderUUID	view
Metadata.allowExtensions	true	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view
EndUserText.label	Document Structure Header Details	view
VDM.lifecycle.type	#PUBLIC_LOCAL_API	view

Fields (36)

Key	Field	Source Table	Source Field
KEY	BillOfMaterialHeaderUUID	I_BillOfMaterial	BillOfMaterialHeaderUUID
	BillOfMaterialCategory	I_BillOfMaterial	BillOfMaterialCategory
	BillOfMaterial	I_BillOfMaterial	BillOfMaterial
	AlternativeBillOfMaterial	I_BillOfMaterial	BillOfMaterialVariant
	DocumentType
	DocumentInfoRecord
	DocumentVersion
	DocumentPart
	BOMHeaderInternalChangeCount	I_BillOfMaterial	BOMHeaderInternalChangeCount
	BOMGroup	I_BillOfMaterial	BOMGroup
	BOMTechnicalType	I_BillOfMaterial	BOMTechnicalType
	BOMHeaderBaseUnit	I_BillOfMaterial	BOMHeaderBaseUnit
	BOMHeaderQuantityInBaseUnit	I_BillOfMaterial	BOMHeaderQuantityInBaseUnit
	BOMHeaderText	I_BillOfMaterial	BOMHeaderText
	BOMAlternativeText	I_BillOfMaterial	BOMAlternativeText
	BillOfMaterialStatus	I_BillOfMaterial	BillOfMaterialStatus
	BillOfMaterialAuthsnGrp	I_BillOfMaterial	BillOfMaterialAuthsnGrp
	HeaderValidityStartDate	I_BillOfMaterial	HeaderValidityStartDate
	HeaderValidityEndDate	I_BillOfMaterial	HeaderValidityEndDate
	EngineeringChangeDocument	I_BillOfMaterial	EngineeringChangeDocument
	ChgToEngineeringChgDocument	I_BillOfMaterial	ChgToEngineeringChgDocument
	DocInfoRecdIsMarkedForDeletion	I_BillOfMaterial	IsMarkedForDeletion
	BOMIsToBeDeleted	I_BillOfMaterial	BOMIsToBeDeleted
	LaboratoryOrDesignOffice	I_BillOfMaterial	LaboratoryOrDesignOffice
	DocumentIsCreatedByCAD	I_BillOfMaterial	DocumentIsCreatedByCAD
	IsALE	I_BillOfMaterial	IsALE
	RecordCreationDateasCreationDate
	CreatedByUser	I_BillOfMaterial	CreatedByUser
	LastChangeDate	I_BillOfMaterial	LastChangeDate
	LastChangedByUser	I_BillOfMaterial	LastChangedByUser
	Associations_Item
	_DocumentInfo		_DocumentInfo
	_BomChanges		_BomChanges
	_CreatedUser		_CreatedUser
	_LastChangedUser		_LastChangedUser
	_UnitOfMeasure		_UnitOfMeasure

@AbapCatalog.sqlViewName: 'ICVDOCSTRUCT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@AccessControl.privilegedAssociations:  [ '_CreatedUser', '_LastChangedUser']
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'BillOfMaterialHeaderUUID'
@Metadata.allowExtensions: true
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #MIXED}
@EndUserText.label: 'Document Structure Header Details'
@VDM.lifecycle: {
  contract.
    type: #PUBLIC_LOCAL_API
}
define view I_DocInfoRecdStructure
  as select from I_BillOfMaterial as bom_header
  -- Item Association
  association [0..*] to I_DocInfoRecdStructureItem as _Item on  $projection.BillOfMaterial            = _Item.BillOfMaterial
                                                            and $projection.BillOfMaterialCategory    = _Item.BillOfMaterialCategory
                                                            and $projection.AlternativeBillOfMaterial = _Item.AlternativeBillOfMaterial

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

  -- BOM Changes Association
  association [0..*] to I_BomChanges as _BomChanges      on  $projection.BillOfMaterial            = _BomChanges.BillOfMaterial
                                                         and $projection.BillOfMaterialCategory    = _BomChanges.BillOfMaterialCategory
                                                         and $projection.AlternativeBillOfMaterial = _BomChanges.BillOfMaterialVariant
                                                         and $projection.EngineeringChangeDocument = _BomChanges.EngineeringChangeDocument

  -- 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

  -- Unit of measure Association
  association [0..1] to I_UnitOfMeasure as _UnitOfMeasure   on  $projection.BOMHeaderBaseUnit = _UnitOfMeasure.UnitOfMeasure
{
  key bom_header.BillOfMaterialHeaderUUID as BillOfMaterialHeaderUUID,

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

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

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

      //@ObjectModel.updateEnabled: true

      bom_header._Dost.DocumentType as DocumentType,

      //@ObjectModel.updateEnabled: true

      bom_header._Dost.DocNumber as DocumentInfoRecord,

      //@ObjectModel.updateEnabled: true

      bom_header._Dost.DocumentVersion as DocumentVersion,

      //@ObjectModel.updateEnabled: true

      bom_header._Dost.DocumentPart as DocumentPart,

      @ObjectModel.readOnly: true
      bom_header.BOMHeaderInternalChangeCount as BOMHeaderInternalChangeCount,

      //@ObjectModel.updateEnabled: true

      bom_header.BOMGroup as BOMGroup,

      @ObjectModel.readOnly: true
      bom_header.BOMTechnicalType as BOMTechnicalType,

      //@ObjectModel.updateEnabled: true

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      bom_header.BOMHeaderBaseUnit as BOMHeaderBaseUnit,

      @DefaultAggregation: #NONE
      @Semantics.quantity.unitOfMeasure: 'BOMHeaderBaseUnit'
      //@ObjectModel.updateEnabled: true

      bom_header.BOMHeaderQuantityInBaseUnit as BOMHeaderQuantityInBaseUnit,

      //@ObjectModel.updateEnabled: true

      bom_header.BOMHeaderText as BOMHeaderText,

      //@ObjectModel.updateEnabled: true

      bom_header.BOMAlternativeText as BOMAlternativeText,

      //@ObjectModel.updateEnabled: true

      bom_header.BillOfMaterialStatus as BillOfMaterialStatus,

      //@ObjectModel.updateEnabled: true

      bom_header.BillOfMaterialAuthsnGrp as BillOfMaterialAuthsnGrp,

      //@ObjectModel.updateEnabled: true

      bom_header.HeaderValidityStartDate as HeaderValidityStartDate,

      @ObjectModel.readOnly: true
      bom_header.HeaderValidityEndDate as HeaderValidityEndDate,

      //@ObjectModel.updateEnabled: true

      bom_header.EngineeringChangeDocument as EngineeringChangeDocument,

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

      //@ObjectModel.updateEnabled: true

      bom_header.IsMarkedForDeletion as DocInfoRecdIsMarkedForDeletion,

      //@ObjectModel.updateEnabled: true

      bom_header.BOMIsToBeDeleted as BOMIsToBeDeleted,

      //@ObjectModel.updateEnabled: true

      bom_header.LaboratoryOrDesignOffice as LaboratoryOrDesignOffice,

      //@ObjectModel.updateEnabled: true

      bom_header.DocumentIsCreatedByCAD as DocumentIsCreatedByCAD,

      //@ObjectModel.updateEnabled: true

      bom_header.IsALE as IsALE,

      -- Administrative Data
      @Semantics.businessDate.at: true
      @Semantics.businessDate.createdAt: true
      bom_header.RecordCreationDate as CreationDate,
      bom_header.CreatedByUser as CreatedByUser,

      @Semantics.businessDate.at: true
      @Semantics.businessDate.changedAt: true
      bom_header.LastChangeDate as LastChangeDate,

      @Semantics.user.lastChangedBy: true
      bom_header.LastChangedByUser as LastChangedByUser,

      --Associations
      _Item,
      _DocumentInfo,
      _BomChanges,
      _CreatedUser,
      _LastChangedUser,
      _UnitOfMeasure

}
where
  BillOfMaterialCategory = 'D'

Depth:

I_DocInfoRecdStructure view

I_BillOfMaterial view