I_BOMHeaderDraft

DDL: I_BOMHEADERDRAFT Type: view_entity BASIC Package: CS_MODEL

Billof material header draft data

I_BOMHeaderDraft is a Basic CDS View that provides data about "Billof material header draft data" in SAP S/4HANA. It reads from 2 data sources (I_DraftAdministrativeData, stko_draft_v2) and exposes 7 fields with key field DraftUUID. Part of development package CS_MODEL.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_DraftAdministrativeData admindraft inner
stko_draft_v2 bomdraft from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
EndUserText.label Billof material header draft data view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY DraftUUID stko_draft_v2 draftuuid
BillOfMaterialCategory stko_draft_v2 billofmaterialcategory
BillOfMaterialVariantUsage stko_draft_v2 billofmaterialvariantusage
PlantForEdit stko_draft_v2 plantforedit
MaterialForEdit stko_draft_v2 materialforedit
SalesOrder stko_draft_v2 salesorder
SalesOrderItem stko_draft_v2 salesorderitem 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #BASIC
@EndUserText.label: 'Billof material header draft data'

define view entity I_BOMHeaderDraft

as select from stko_draft_v2 as bomdraft
 inner join  I_DraftAdministrativeData as admindraft on 
 (  admindraft.InProcessByUser = $session.user  or admindraft.CreatedByUser = $session.user )
  and admindraft.DraftUUID = bomdraft.draftuuid and  admindraft.DraftEntityType = 'I_BILLOFMATERIALTP' 
{
  
  key bomdraft.draftuuid as DraftUUID ,
 // bomdraft.billofmaterial as BillOfMaterial , 

  bomdraft.billofmaterialcategory as BillOfMaterialCategory, 
  bomdraft.billofmaterialvariantusage as BillOfMaterialVariantUsage, 
  bomdraft.plantforedit as PlantForEdit, 
  bomdraft.materialforedit as MaterialForEdit,
  bomdraft.salesorder as SalesOrder,
  bomdraft.salesorderitem as SalesOrderItem
}
where
bomdraft.draftentityoperationcode <> 'D' or bomdraft.draftentityoperationcode <> 'L'

Learn More