P_Bomitemvalid_To

DDL: P_BOMITEMVALID_TO SQL: PBOMITEMVALIDTO Type: view BASIC

P_Bomitemvalid_To is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (stas) and exposes 9 fields with key fields stlty, stlnr, stlal.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
stas b left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBOMITEMVALIDTO view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.lifecycle.contract.type #NONE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY stlty a stlty
KEY stlnr a stlnr
KEY stlal a stlal
stlkn a stlkn
ValidFromDate a datuv
ValidToDate
change_from a aennr
BillOfMaterialVersion a bom_versn
stvkn a stvkn 
@AbapCatalog.sqlViewName: 'PBOMITEMVALIDTO'
@ClientHandling.type : #INHERITED
@ClientHandling.algorithm : #AUTOMATED
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.private: true
@VDM.lifecycle.contract.type: #NONE
//@EndUserText.label: 'BOM Item valid To Date'

define view P_Bomitemvalid_To
  as select distinct from stas as a
    left outer join       stas as b on  a.stlty     =  b.stlty
                                    and a.stlnr     =  b.stlnr
                                    and a.bom_versn =  b.bom_versn
                                    and a.stlal     =  b.stlal
                                    and a.stvkn     =  b.stvkn
                                    and a.datuv     <= b.datuv
                                    and a.stasz     <  b.stasz
{
  key a.stlty,
  key a.stlnr,
  key a.stlal,
      a.stlkn,
      a.datuv                                           as ValidFromDate,
      cast ( min ( b.datuv ) as datub preserving type ) as ValidToDate,
      a.aennr                                           as change_from,
      a.bom_versn                                       as BillOfMaterialVersion,
      a.stvkn
}
where
      a.lkenz =  ' '
  and a.datuv <> '00000000' // Select Parameter Effectivity records separately.

  and a.stlty = 'M'
group by
  a.stlty,
  a.stlnr,
  a.stlal,
  a.stasz,
  a.datuv,
  a.stvkn,
  a.aennr,
  a.bom_versn,
  a.stlkn 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"STAS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More