I_BOMHeaderDraft

DDL: I_BOMHEADERDRAFT SQL: IBOMHEADERDRAFT Type: view BASIC

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.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_DraftAdministrativeData admindraft inner
stko_draft_v2 bomdraft from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IBOMHEADERDRAFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #X 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 
@AbapCatalog.sqlViewName: 'IBOMHEADERDRAFT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #BASIC
@EndUserText.label: 'Billof material header draft data'

define view 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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DRAFTADMINISTRATIVEDATA",
"STKO_DRAFT_V2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More