ESH_N_PROCESSORDERCONF

@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ESH_L_PROCORDCNF'
define view ESH_N_PROCESSORDERCONF
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_MFGORDERCONFIRMATION
association [0..*] to dd07t as _FINALCONFIRMATIONTYPE on  $projection.FinalConfirmationType=_FINALCONFIRMATIONTYPE.domvalue_l and  _FINALCONFIRMATIONTYPE.domname='AUERU_VS' and  _FINALCONFIRMATIONTYPE.as4local='A' association [0..*] to dd07t as _REVERSEDINDICATOR on ( $projection.IsReversed=_REVERSEDINDICATOR.domvalue_l AND  _REVERSEDINDICATOR.domname='XFELD' AND  _REVERSEDINDICATOR.as4local='A' ) {

key MFGORDERCONFIRMATION,

key MFGORDERCONFIRMATIONGROUP,

CONFIRMATIONAPPLICATIONORIGIN,

CONFIRMATIONSCRAPQUANTITY,

CONFIRMATIONTEXT,

CONFIRMATIONUNIT,

CONFIRMATIONYIELDQUANTITY,

ENTEREDBYUSER,

FINALCONFIRMATIONTYPE,

_FINALCONFIRMATIONTYPE[1: ddlanguage = $parameters. P_Language].ddtext as FINALCONFIRMATIONTYPENAME,

_USERCONTACTCARD.FIRSTNAME,

_REVERSEDINDICATOR[1: ddlanguage = $parameters. P_Language].ddtext as INDICATORTEXT,

ISFINALCONFIRMATION,

ISREVERSED,

LASTCHANGEDBYUSER,

_USERCONTACTCARD.LASTNAME,

MANUFACTURINGORDER,

MANUFACTURINGORDERCATEGORY,

MANUFACTURINGORDERTYPE,

MFGORDERCONFIRMATIONENTRYDATE,

OPPLANNEDTOTALQUANTITY,

ORDEROPERATIONINTERNALID,

_LONGTEXT.PLAINLONGTEXT,

PLANT,

_PLANT.PLANTNAME,

POSTINGDATE,

_MFGORDER.PRODUCT,

_MFGORDER._PRODUCT._TEXT[1: Language = $parameters. P_Language].PRODUCTNAME,

_USER.USERDESCRIPTION,

VARIANCEREASONCODE
}where ConfirmationApplicationOrigin = '6' AND 
ManufacturingOrderCategory = '40' AND 
OrderOperationInternalID is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDER",
"I_MFGORDERCONFIRMATION",
"I_ORDERCONFLONGTEXT",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTTEXT",
"I_USER",
"I_USERCONTACTCARD",
"DD07T"
],
"ASSOCIATED":
[
"DD07T"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/