I_EngmntProjFieldMapChgDoc

@AbapCatalog.sqlViewName: 'IENGPROJFLDMAP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType:#BASIC
@EndUserText.label: 'Field Mapping for Engagement Prj Chg Doc'
define view I_EngmntProjFieldMapChgDoc
  as select from dd27s
    inner join   dd03nd as DD03ND on(
      (
        (
          DD03ND.strucobjn   = 'I_ENGMNTPROJECTPLANDATA'
          and dd27s.viewname = 'IEPRPLANDATA'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGMNTPROJDMNDHDR'
          and dd27s.viewname = 'IENGPROJDMNDHDR'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGAGEMENTPROJECTHEADER'
          and dd27s.viewname = 'IENGMNTPROJHDR'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGAGEMENTPROJECTITEM'
          and dd27s.viewname = 'IEPPROJITEM'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGMTPROJTEAMMEMBER'
          and dd27s.viewname = 'IENGPROJTEAMMEM'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGAGEMENTPROJECTTEAMROLE'
          and dd27s.viewname = 'IEPROJTEAMROLE'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGAGEMENTPROJFINANCIALPLAN'
          and dd27s.viewname = 'IEPFINANPLN'
        )
        or(
          DD03ND.strucobjn   = 'I_CUSTPROJWRKPCKGTEXT'
          and dd27s.viewname = 'ICUSPRJWRKPCKGT'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGAGEMENTPROJECTTEAM'
          and dd27s.viewname = 'IENGMTPROJTEAM'
        )
        or(
          DD03ND.strucobjn   = 'I_WORKPACKAGE'
          and dd27s.viewname = 'IWORKPCKG'
        )
        or(
          DD03ND.strucobjn   = 'I_ENGMTPROJFINPLANVERSION'
          and dd27s.viewname = 'IEPFINPLNVERSN'
        )
        or(
          DD03ND.strucobjn   = 'I_CUSTOMER'
          and dd27s.viewname = 'I_CUSTOMER_CDS'
        )
        or(
          DD03ND.strucobjn   = 'I_BUSINESSPARTNER'
          and dd27s.viewname = 'IBUSINESSPARTNER'
        )
      )
      and DD03ND.nodename    = '.NODE1'
      and DD03ND.fieldname   = dd27s.viewfield
    )
{
  key dd27s.viewfield      as EntProjChgDocViewFld,
  key DD03ND.strucobjn     as EntProjChgDocObj,
      dd27s.fieldname      as EntProjChgDocFld,
      DD03ND.fieldname_raw as EntPrjChgDocFldDet
}
where
  dd27s.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03ND",
"DD27S"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/