I_MATLBSDBEFOREPRODNCOMPDRAFT

----------------------------------------------------
-- Components of Material Based Composition
-- Used for before production components
----------------------------------------------------

--Label of view
@EndUserText.label: 'Component before production draft'

@AbapCatalog:
{
  -- SQL view name (16 characters)
  sqlViewName: 'IMBFRCOMPDRAFT',

  --If it's true, the filter conditions are compared and, if they match, the associated join expression is evaluated only once
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #MANDATORY
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #BASIC

@ObjectModel:
{

  --Performance Annotations
  usageType:
  {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #XL,
    serviceQuality: #C
  }
}


define view I_MatlBsdBeforeProdnCompDraft

  --Select data from master table 'Components available before production
  as select from ehfndw_mcmps_bpc as MatlBasedCmpstnBfrProdnDraft

  --Association for DCL
  association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on $projection.ChmlCmplncInfoUUID = _ChmlCmplncInfo.ChmlCmplncInfoUUID

  association [1..1] to P_ChmlCmplConstants as _Constant       on _Constant.ConstantFalse = _Constant.ConstantFalse

{
      --UUID of component
  key MatlBasedCmpstnBfrProdnDraft.matlbsdcompuuid             as MatlBsdCompUUID,

      MatlBasedCmpstnBfrProdnDraft.activematlbsdcompuuid       as ActiveMatlBsdCompUUID,

      --UUID of chemical compliance information
      MatlBasedCmpstnBfrProdnDraft.chmlcmplncinfouuid          as ChmlCmplncInfoUUID,

      --UUID of composition
      MatlBasedCmpstnBfrProdnDraft.chmlcompositionuuid         as ChmlCompositionUUID,

      --UUID of material(cci) as component
      MatlBasedCmpstnBfrProdnDraft.compchmlcmplncinfouuid      as CompChmlCmplncInfoUUID,

      --Date/Time of creation
      MatlBasedCmpstnBfrProdnDraft.creationutcdatetime         as CreationUTCDateTime,

      --Created by
      MatlBasedCmpstnBfrProdnDraft.createdbyuser               as CreatedByUser,

      --Date/Time of change
      MatlBasedCmpstnBfrProdnDraft.lastchangeutcdatetime       as LastChangeUTCDateTime,

      --Changed by
      MatlBasedCmpstnBfrProdnDraft.lastchangedbyuser           as LastChangedByUser,

      --Indicator: Is a component before production (I) or after production (O)
      MatlBasedCmpstnBfrProdnDraft.matlbsdcompproductiontype   as MatlBsdCompProductionType,

      --Concentration of component
      MatlBasedCmpstnBfrProdnDraft.chmlcompqty                 as ChmlCompQty,

      --Concentration as text (for correct formatting with decimals exactly as entered by user)
      MatlBasedCmpstnBfrProdnDraft.chmlcompqtyastext           as ChmlCompQtyAsText,

      --Unit of measurement of concentration
      MatlBasedCmpstnBfrProdnDraft.chmlcompqtyunit             as ChmlCompQtyUnit,

      --Operator Lower limit of concentration
      MatlBasedCmpstnBfrProdnDraft.chmlcompoperatorlowerlimit  as ChmlCompOperatorLowerLimit,

      --Lower limit of concentration
      MatlBasedCmpstnBfrProdnDraft.chmlcompqtylowerlimit       as ChmlCompQtyLowerLimit,

      --Lower limit as text (for correct formatting with decimals exactly as entered by user)
      MatlBasedCmpstnBfrProdnDraft.chmlcompqtylowerlimitastext as ChmlCompQtyLowerLimitAsText,

      --Operator Upper limit of concentration
      MatlBasedCmpstnBfrProdnDraft.chmlcompoperatorupperlimit  as ChmlCompOperatorUpperLimit,

      --Upper limit of concentration
      MatlBasedCmpstnBfrProdnDraft.chmlcompqtyupperlimit       as ChmlCompQtyUpperLimit,

      --Upper limit as text (for correct formatting with decimals exactly as entered by user)
      MatlBasedCmpstnBfrProdnDraft.chmlcompqtyupperlimitastext as ChmlCompQtyUpperLimitAsText,

      --Indicator: Is a component removed - Neccessary for Calculation of Component Status
      MatlBasedCmpstnBfrProdnDraft.chmlcompisremoved           as ChmlCompIsRemoved,

      _ChmlCmplncInfo

}
where
  -- Filter Draft Entities with deletion flag
  draftentityoperationcode <> 'D'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDW_MCMPS_BPC"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO",
"P_CHMLCMPLCONSTANTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/