P_NonVersEBOMHdrLtstInstance

DDL: P_NONVERSEBOMHDRLTSTINSTANCE SQL: PNVEBMHDRLTST Type: view COMPOSITE

P_NonVersEBOMHdrLtstInstance is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_MaterialBOM) and exposes 6 fields with key fields BillOfMaterialCategory, BillOfMaterial, BillOfMaterialVariant, Material, Plant.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialBOM MaterialBOM from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PNVEBMHDRLTST view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY BillOfMaterialCategory I_MaterialBOM BillOfMaterialCategory
KEY BillOfMaterial I_MaterialBOM BillOfMaterial
KEY BillOfMaterialVariant I_MaterialBOM BillOfMaterialVariant
KEY Material I_MaterialBOM Material
KEY Plant I_MaterialBOM Plant
HeaderValidityStartDate 
/*
  This view is a Determination View to calculate the Most Recent Header Valid from date. This will help us to retrieve the
  BOM Header details of the most recent effective BOM ( For Bom Header not Item ) , this in turn will give the latest effective
  snapshot of BOM.
*/
@AbapCatalog.sqlViewName: 'PNVEBMHDRLTST'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType: {serviceQuality:#X, sizeCategory: #XXL, dataClass: #MASTER}

define view P_NonVersEBOMHdrLtstInstance
  as select from I_MaterialBOM as MaterialBOM

{
  key MaterialBOM.BillOfMaterialCategory,
  key MaterialBOM.BillOfMaterial,
  key MaterialBOM.BillOfMaterialVariant,
  key MaterialBOM.Material,
  key MaterialBOM.Plant,
      max(MaterialBOM.HeaderValidityStartDate) as HeaderValidityStartDate
}
where
// This calculation is only required for Non-version BOMs

  MaterialBOM.IsVersionBillOfMaterial = ' ' and
// Will avoid the calculations for other types of BOM

  MaterialBOM.BillOfMaterialCategory = 'M'
group by
  MaterialBOM.BillOfMaterialCategory,
  MaterialBOM.BillOfMaterial,
  MaterialBOM.BillOfMaterialVariant,
  MaterialBOM.Material,
  MaterialBOM.Plant
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALBOM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More