I_MATLBSDAFTERPRODNCOMPDRAFT

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

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

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

  --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_MatlBsdAfterProdnCompDraft

  --Select data from master table 'Components available after production
  as select from ehfndw_mcmps_apc as MatlBasedCmpstnAftProdnDraft

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

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

      MatlBasedCmpstnAftProdnDraft.activematlbsdcompuuid       as ActiveMatlBsdCompUUID,

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

      --UUID of composition
      MatlBasedCmpstnAftProdnDraft.chmlcompositionuuid         as ChmlCompositionUUID,

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

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

      --Created by
      MatlBasedCmpstnAftProdnDraft.createdbyuser               as CreatedByUser,

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

      --Changed by
      MatlBasedCmpstnAftProdnDraft.lastchangedbyuser           as LastChangedByUser,

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

      --Concentration of component
      MatlBasedCmpstnAftProdnDraft.chmlcompqty                 as ChmlCompQty,

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

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

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

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

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

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

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

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

      --Is a component not contained
      MatlBasedCmpstnAftProdnDraft.chmlcompisnotcontained      as ChmlCompIsNotContained,

      --Is a component removed
      MatlBasedCmpstnAftProdnDraft.chmlcompisremoved           as ChmlCompIsRemoved,

      _ChmlCmplncInfo

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