I_PlngScopeDetsAssgdToChgRecd

@AbapCatalog.sqlViewName: 'IPLNGSCPCRASSGD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Details of Planning Scopes Assigned to Change Record'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_PlngScopeDetsAssgdToChgRecd
  // as select from I_ChgRecdRefPlngScpBsc as ChgRecdRefPlngScp

  as select from    I_ChangeRecordBsc           as ChangeRecord

    inner join      P_MngUnassgdEBOMChgRecdType as _EBOMChangeRecordType on ChangeRecord.ChangeRecordType = _EBOMChangeRecordType.ChangeRecordType

  //left outer join   I_PlngScpHdr           as PlngScpHdr on  ChgRecdRefPlngScp.ChgRecRefInternalKey1 = PlngScpHdr.DocumentId

  //                                              and ChgRecdRefPlngScp.ChgRecRefInternalKey2 = PlngScpHdr.PlanningScopeAlternative

    left outer join I_ChgRecdRefPlngScpBsc      as ChgRecdRefPlngScp     on ChangeRecord.ChangeRecordUUID = ChgRecdRefPlngScp.ChangeRecordUUID

    left outer join I_ChgRecdRefEBOM            as ChgRecdRefEngBOM      on ChangeRecord.ChangeRecordUUID = ChgRecdRefEngBOM.ChangeRecordUUID
  // inner join   I_PlngScpHdr           as PlngScpHdr on  ChgRecdRefPlngScp.ChgRecRefInternalKey1 = PlngScpHdr.DocumentId

  //                                              and ChgRecdRefPlngScp.ChgRecRefInternalKey2 = PlngScpHdr.PlanningScopeAlternative


{


      //key  ChgRecdRefPlngScp.ChangeRecordReferenceUUID,

  key ChangeRecord.ChangeRecordUUID,
  key ChgRecdRefPlngScp.ChangeRecordReferenceUUID as ChangeRecordRefPlngScpUUID,
  key ChgRecdRefEngBOM.ChangeRecordReferenceUUID  as ChgRecdRefEngBillOfMatlUUID,
      ChgRecdRefPlngScp.ChgRecRefInternalKey1     as ChgRecRefInternalKey1PlngScp,
      ChgRecdRefPlngScp.ChgRecRefInternalKey2     as ChgRecRefInternalKey2PlngScp,
      ChgRecdRefEngBOM.ChgRecRefInternalKey1      as ChgRecdRefInternalKey1EngBOM,
      ChgRecdRefEngBOM.ChgRecRefInternalKey2      as ChgRecdRefInternalKey2EngBOM,
      ChgRecdRefEngBOM.ChgRecRefInternalKey3      as ChgRecdRefInternalKey3EngBOM,
      ChgRecdRefEngBOM.ChgRecRefInternalKey4      as ChgRecdRefInternalKey4EngBOM,
      //  ChgRecdRefPlngScp.ChangeRecordReferenceUUID,

      //  PlngScpHdr.SourceMaterial,

      // PlngScpHdr.PlanningScopeDescription,

      //   PlngScpHdr.DocumentId                                                                 as PlanningScopeUUID,

      // PlngScpHdr.PlanningScopeAlternative                                                   as PlanningScopeAlt,

      // Planning Scope Details

      //ChgRecdRefPlngScp.ChangeRecordUUID,

      ChangeRecord.ChangeRecord,
      ChangeRecord.ChangeRecordCategory,
      ChangeRecord.ChangeRecordStatus,
      ChangeRecord.ChangeRecordType,
      ChangeRecord.ChangeNumber,
      ChangeRecord.Partner,
      ChangeRecord.ChgRecordApplication,
      ChangeRecord.CreatedByUser,
      ChangeRecord.ChangeRecordLifecycleStatus,
      ChangeRecord.ChgRecordDescriptionText,
      ChangeRecord.ChgRecdEngEffectiveDate,
      ChangeRecord.ChgRecdMfgEffectiveDate
       //ChgRecdRefPlngScp._ChangeRecordBsc.ChangeRecordLifecycleStatus,

      //   PlngScpHdr.SourceMaterial,

      //  PlngScpHdr.SourcePlant,

      // PlngScpHdr.TargetMaterial,

      // PlngScpHdr.Plant                                                                      as ProductionPlant,

      // PlngScpHdr.CreatedByUser,

      // PlngScpHdr.PlanningScopeTimeStamp

      //  _ChangeRecord.ChangeRecordLifecycleStatus

      //     _ChangeRecordSG





}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDBSC",
"I_CHGRECDREFEBOM",
"I_CHGRECDREFPLNGSCPBSC",
"P_MNGUNASSGDEBOMCHGRECDTYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/