ESH_N_SOURCINGPROJECT

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_MMSRCGPROJ'
define view ESH_N_SOURCINGPROJECT
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from R_SOURCINGPROJECTTP
association [0..*] to dd07t as _SRCGPROJLIFECYCLESTATUS on  $projection.SrcgProjLifecycleStatus=_SRCGPROJLIFECYCLESTATUS.domvalue_l and  _SRCGPROJLIFECYCLESTATUS.domname='VDM_SRCGPROJECTLFCYCSTS' and  _SRCGPROJLIFECYCLESTATUS.as4local='A' and  _SRCGPROJLIFECYCLESTATUS.as4vers='0000'  {

key SOURCINGPROJECTUUID,

_SRCGPROJPUBDSUPLRLISTBP._BUSINESSPARTNER.BUSINESSPARTNER,

COMPANYCODE,

_COMPANYCODE.COMPANYCODENAME,

CREATEDBYUSER,

CREATIONDATETIME,

EXTERNALSOURCINGPROJECTREF,

_SOURCINGPROJECTITEM.MATERIAL,

MATERIALGROUP,

_MATERIALGROUPTEXT[1: LANGUAGE = $parameters. P_Language].MATERIALGROUPNAME,

_SRCGPROJPUBDSUPLRLISTBP._SUPPLIER.ORGANIZATIONBPNAME1,

_SOURCINGPROJECTITEM.PLANT,

PURCHASERRESPWORKAGREEMENT,

PURCHASINGGROUP,

_PURCHASINGGROUP.PURCHASINGGROUPNAME,

PURCHASINGORGANIZATION,

_PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME,

QTNLATESTSUBMISSIONDATETIME,

SOURCINGPROJECT,

SOURCINGPROJECTNAME,

_SOURCINGPROJECTPHASETEXT[1: LANGUAGE = $parameters. P_Language].SOURCINGPROJECTPHASETEXT,

SOURCINGPROJECTTYPE,

_SOURCINGPROJECTTYPETEXT[1: LANGUAGE = $parameters. P_Language].SOURCINGPROJECTTYPETEXT,

SOURCINGPROJECTVERSION,

_SOURCINGPROJECTITEM.SRCGPROJITEMDESCRIPTION,

SRCGPROJLIFECYCLESTATUS,

_SRCGPROJLIFECYCLESTATUS[1: ddlanguage = $parameters. P_Language].ddtext as SRCGPROJLIFECYCLESTATUSNAME,

_SRCGPROJPUBDSUPLRLISTBP._SUPPLIER.SUPPLIER,

_CREATEDBYUSER.USERDESCRIPTION
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_COMPANYCODE",
"I_MATERIALGROUPTEXT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SOURCINGPROJECTPHASETEXT",
"I_SOURCINGPROJECTTYPETEXT",
"I_SUPPLIER",
"I_USERCONTACTCARD",
"R_SOURCINGPROJECTITEMTP",
"R_SOURCINGPROJECTTP",
"R_SRCGPROJPUBDSUPLRLISTBPTP",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/