ESH_N_SOLUTIONORDER

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AbapCatalog.sqlViewName: 'ESH_L_SOLUORDER'
define view ESH_N_SOLUTIONORDER
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_SERVICEDOCUMENTENHCD
association [0..*] to dd07t as _SERVICEDOCUMENTSTATUS on  $projection.ServiceDocumentStatus=_SERVICEDOCUMENTSTATUS.domvalue_l and  _SERVICEDOCUMENTSTATUS.domname='CRMS4_STAT_LIFECYCLE' and  _SERVICEDOCUMENTSTATUS.as4local='A'  {

key SERVICEDOCUMENT,

key SERVICEOBJECTTYPE,

DISTRIBUTIONCHANNEL,

DIVISION,

_SOLDTOPARTY.FIRSTNAME as SOLDTOFIRSTNAME,

_RESPEMPLOYEE.FIRSTNAME as EMPFIRSTNAME,

_SOLDTOPARTY.LASTNAME as SOLDTOLASTNAME,

_RESPEMPLOYEE.LASTNAME as EMPLASTNAME,

_SOLDTOPARTY.ORGANIZATIONBPNAME1 as SOLDTOORGFNAME,

_RESPEMPLOYEE.ORGANIZATIONBPNAME1 as EMPORGFNAME,

_SOLDTOPARTY.ORGANIZATIONBPNAME2 as SOLDTOORGLNAME,

_RESPEMPLOYEE.ORGANIZATIONBPNAME2 as EMPORGLNAME,

POSTINGDATE,

RESPONSIBLEEMPLOYEE,

SALESGROUP,

SALESGROUPORGUNITID,

SALESOFFICE,

SALESOFFICEORGUNITID,

SALESORGANIZATION,

SALESORGANIZATIONORGUNITID,

SERVICEDOCUMENTDESCRIPTION,

SERVICEDOCUMENTISQUOTATION,

_SRVCDOCHEADERLONGTEXT.SERVICEDOCUMENTLONGTEXT,

SERVICEDOCUMENTSTATUS,

_SERVICEDOCUMENTSTATUS[1: ddlanguage = $parameters. P_Language].ddtext as SERVICEDOCUMENTSTATUSNAME,

SERVICEDOCUMENTTEMPLATETYPE,

SERVICEDOCUMENTTYPE,

_SERVICEDOCUMENTTYPE._SERVICEDOCUMENTTYPETEXT[1: LANGUAGE = $parameters. P_Language].SERVICEDOCUMENTTYPENAME,

SERVICEDOCUMENTUUID,

SERVICEORGANIZATION,

SOLDTOPARTY
}where SERVICEOBJECTTYPE = 'BUS2000172'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_SERVICEDOCUMENTENHCD",
"I_SERVICEDOCUMENTTYPE",
"I_SERVICEDOCUMENTTYPETEXT",
"I_SRVCDOCHEADERLONGTEXT",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/