I_ProjMatCompAdditionalData

@AbapCatalog.sqlViewName: 'IPRMATCOMADDDAT'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Additional Data for Proj Material Comp'

define view I_ProjMatCompAdditionalData
  as select from rsadd
  association [0..1] to I_ProjNtwkActyMatBOMAssembly as _ProjNtwkActyMatBOMAssembly on  (
      $projection.BillOfMaterialInternalID                                                                                   = _ProjNtwkActyMatBOMAssembly.BillOfMaterial
      and $projection.BillOfMaterialCategory                                                                                 = _ProjNtwkActyMatBOMAssembly.BillOfMaterialCategory
    )
                                                                                    or  (
                                                                                        $projection.BillOfMaterialInternalID = _ProjNtwkActyMatBOMAssembly.BillOfMaterial
                                                                                      )
  association [1..1] to E_ProjectMaterialComponent   as _Extension                  on  $projection.Reservation     = _Extension.Reservation
                                                                                    and $projection.RecordType      = _Extension.RecordType
                                                                                    and $projection.ReservationItem = _Extension.ReservationItem
{
  key rsadd.rsnum                                        as Reservation,
  key cast (rsadd.rspos as ps_s4_rspos preserving type ) as ReservationItem,
  key rsadd.rsart                                        as RecordType,
      cast(rsadd.bstln as pph_stnum preserving type)     as BillOfMaterialInternalID,
      rsadd.bstlt                                        as BillOfMaterialCategory,
      rsadd.strecke                                      as IsThirdPartyRequisition,
      rsadd.creaby                                       as CreatedByUser,
      rsadd.creadat                                      as CreationDate,
      rsadd.changeby                                     as LastChangedByUser,
      rsadd.changedat                                    as LastChangeDate,
      rsadd.brtdate                                      as BOMExplosionFixedKeyDate,

      //23.05.2023 - new fields - start

      rsadd.ekorg                                        as PurchasingOrganization,
      rsadd.afnam                                        as RequisitionerUser,
      rsadd.bednr                                        as RequirementTracking,
      rsadd.kzfix                                        as PurgInfoRecdDataIsFixed,
      rsadd.mflic                                        as MatlCompProcmtIndicatorCode,
      //23.05.2023 - new fields - end

      //06.06.2023

      rsadd.adrn2                                        as AddressNumber,
      rsadd.kunnr                                        as Customer,
      rsadd.emlif                                        as Supplier,
      //06.06.2023 - End


      //07.07.2023 - start

      rsadd.overalllimitamount                           as OverallLimitAmount,
      rsadd.expectedoveralllimitamount                   as ExpectedOverallLimitAmount,
      //07.07.2023 - end


      _ProjNtwkActyMatBOMAssembly
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSADD"
],
"ASSOCIATED":
[
"E_PROJECTMATERIALCOMPONENT",
"I_PROJNTWKACTYMATBOMASSEMBLY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/