ESH_N_PROCESSORDER

DDL: ESH_N_PROCESSORDER SQL: ESH_L_PROCORDER Type: view

ESH_N_PROCESSORDER is a CDS View in SAP S/4HANA. It reads from 1 data source (I_LOGISTICSORDER) and exposes 40 fields with key field ORDERID. It has 2 associations to related views.

1 data source(s) 40 fields

Data Sources (1)

SourceAliasJoin Type
I_LOGISTICSORDER I_LOGISTICSORDER from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[1..1] N_ORDEROPERATION _ORDEROPERATION $projection.OrderInternalBillOfOperations=_ORDEROPERATION.OrderInternalID
[0..*] N_STATUSOBJECTSTATUS _STATUSOBJECTSTATUS $projection.ObjectInternalID=_STATUSOBJECTSTATUS.StatusObject and _STATUSOBJECTSTATUS.StatusIsInactive=''

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_PROCORDER view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ORDERID ORDERID
BASEUNIT BASEUNIT
BATCH _ORDERMAINITEM BATCH
ISMARKEDFORDELETION ISMARKEDFORDELETION
LEADINGORDER LEADINGORDER
MATERIAL _ORDERMAINITEM MATERIAL
MRPAREA _ORDERMAINITEM MRPAREA
MRPAREATEXT
MRPCONTROLLER MRPCONTROLLER
MRPPLANT _ORDERMAINITEM MRPPLANT
OBJECTINTERNALID OBJECTINTERNALID
ORDERCATEGORY ORDERCATEGORY
ORDERCOMPONENTLONGTEXT
ORDERDESCRIPTION ORDERDESCRIPTION
ORDERINTERNALBILLOFOPERATIONS ORDERINTERNALBILLOFOPERATIONS
ORDEROPERATIONLONGTEXT
ORDERPLANNEDTOTALQTY ORDERPLANNEDTOTALQTY
ORDERTYPE ORDERTYPE
ORDERTYPENAME
ORGANIZATIONBPNAME1
ORDERLONGTEXT _LONGTEXT PLAINLONGTEXT
PLANNEDENDDATE PLANNEDENDDATE
PLANNEDSTARTDATE PLANNEDSTARTDATE
MRPPLANTNAME
PLANTNAME
PRODUCTIONPLANT _ORDERMAINITEM PRODUCTIONPLANT
PRODUCTNAME
MATERIALCOMPONENTNAME
SALESORDER SALESORDER
SCHEDULEDBASICENDDATE SCHEDULEDBASICENDDATE
SCHEDULEDBASICENDTIME SCHEDULEDBASICENDTIME
SCHEDULEDBASICSTARTDATE SCHEDULEDBASICSTARTDATE
SCHEDULEDBASICSTARTTIME SCHEDULEDBASICSTARTTIME
SOLDTOPARTY _SALESORDER SOLDTOPARTY
SYSTEMSTATUSNAME
LASTCHANGEDBYUSERDESCRIPTION _LASTCHANGEDBYUSER USERDESCRIPTION
CREATEDBYUSERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION
WBSDESCRIPTION _WBSELEMENT WBSDESCRIPTION
WBSELEMENT _WBSELEMENT WBSELEMENT
WORKCENTERTEXT _ORDEROPERATION WORKCENTERTEXT 
@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_PROCORDER'
define view ESH_N_PROCESSORDER
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_LOGISTICSORDER
association [1..1] to N_ORDEROPERATION as _ORDEROPERATION on  $projection.OrderInternalBillOfOperations=_ORDEROPERATION.OrderInternalID 
association [0..*] to N_STATUSOBJECTSTATUS as _STATUSOBJECTSTATUS on  $projection.ObjectInternalID=_STATUSOBJECTSTATUS.StatusObject and _STATUSOBJECTSTATUS.StatusIsInactive=''
 {

key ORDERID,

BASEUNIT,

_ORDERMAINITEM.BATCH,

ISMARKEDFORDELETION,

LEADINGORDER,

_ORDERMAINITEM.MATERIAL,

_ORDERMAINITEM.MRPAREA,

_ORDERMAINITEM._MRPAREA.MRPAREATEXT,

MRPCONTROLLER,

_ORDERMAINITEM.MRPPLANT,

OBJECTINTERNALID,

ORDERCATEGORY,

_ORDERCOMPONENT._LONGTEXT.ORDERCOMPONENTLONGTEXT,

ORDERDESCRIPTION,

ORDERINTERNALBILLOFOPERATIONS,

_ORDEROPERATION._LONGTEXT.ORDEROPERATIONLONGTEXT,

ORDERPLANNEDTOTALQTY,

ORDERTYPE,

_ORDERTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].ORDERTYPENAME,

_SALESORDER._SOLDTOPARTY.ORGANIZATIONBPNAME1,

_LONGTEXT.PLAINLONGTEXT as ORDERLONGTEXT,

PLANNEDENDDATE,

PLANNEDSTARTDATE,

_ORDERMAINITEM._MRPPLANT.PLANTNAME as MRPPLANTNAME,

_ORDERMAINITEM._PRODUCTIONPLANT.PLANTNAME,

_ORDERMAINITEM.PRODUCTIONPLANT,

_ORDERMAINITEM._PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME,

_RESERVATION._RESERVATIONDOCUMENTITEM._PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME as MATERIALCOMPONENTNAME,

SALESORDER,

SCHEDULEDBASICENDDATE,

SCHEDULEDBASICENDTIME,

SCHEDULEDBASICSTARTDATE,

SCHEDULEDBASICSTARTTIME,

_SALESORDER.SOLDTOPARTY,

_STATUSOBJECTSTATUS._SYSTEMSTATUS._SYSTEMSTATUSTEXT[1: LANGUAGE = $parameters. P_Language].SYSTEMSTATUSNAME,

_LASTCHANGEDBYUSER.USERDESCRIPTION as LASTCHANGEDBYUSERDESCRIPTION,

_CREATEDBYUSER.USERDESCRIPTION as CREATEDBYUSERDESCRIPTION,

_WBSELEMENT.WBSDESCRIPTION,

_WBSELEMENT.WBSELEMENT,

_ORDEROPERATION.WORKCENTERTEXT
}where ORDERCATEGORY = '40' AND 
ISMARKEDFORDELETION is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_LOGISTICSORDER",
"I_MRPAREA",
"I_ORDERCOMPONENT",
"I_ORDERCOMPONENTLONGTEXT",
"I_ORDERITEM",
"I_ORDERLONGTEXT",
"I_ORDEROPERATIONLONGTEXT",
"I_ORDERTYPE",
"I_ORDERTYPETEXT",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTTEXT",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESERVATIONDOCUMENTITEM",
"I_SALESORDER",
"I_SYSTEMSTATUS",
"I_SYSTEMSTATUSTEXT",
"I_USER",
"I_WBSELEMENTBYINTERNALKEY",
"N_ORDEROPERATION",
"N_STATUSOBJECTSTATUS"
],
"ASSOCIATED":
[
"N_ORDEROPERATION",
"N_STATUSOBJECTSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More