I_CMMDTYORDERREQQUEUEERRLOG
bgRFC Queue Error Log for Order Request
I_CMMDTYORDERREQQUEUEERRLOG is a CDS View in S/4HANA. bgRFC Queue Error Log for Order Request. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CmmdtyOrderFillPacketLog | view | union | CONSUMPTION | Consumption View for Order Error Log |
| I_CmmdtyOrderReqPacketLog | view | union | COMPOSITE | Basic View for Order Error Log |
@AbapCatalog.sqlViewName: 'ICMDTYORDQERR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType: {
serviceQuality : #C,
sizeCategory : #S,
dataClass : #META }
@Metadata.allowExtensions: false
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'bgRFC Queue Error Log for Order Request'
define view I_CmmdtyOrderReqQueueErrLog
as select from I_CmmdtyOrderReqQueueErrLogRaw as BgRFCStatus
inner join cmmfdor_d_order as OrderRequest on BgRFCStatus.CommodityOrderRequest = OrderRequest.commodityorderrequest
{
key ProcessRun as ProcessRun,
key
case BgRFCStatus.Criticality
when 'E' then OrderRequest.commodityorderrequestuuid
else ProcessRun
end as CmmdtyOrderFillPacketMsgUUID,
OrderRequest.commodityorderrequestuuid as CommodityOrderFillPacketUUID,
OrderRequest.commodityorderrequestuuid as CommodityOrderRequestUUID,
case BgRFCStatus.Criticality
when 'E' then 1
when 'W' then 2
else
0
end as Criticality,
BgRFCStatus.CmmdtyOrderRequestMessageType as CmmdtyOrderRequestMessageType,
'' as SystemMessageTypeCriticality,
'0000000000' as CommodityOrderFillPacketID,
'00000' as CmmdtyOrderFillPacket,
BgRFCStatus.CmmdtyOrdReqMessageDateTime as CmmdtyOrdReqMessageDateTime,
BgRFCStatus.CmmdtyOrderReqMessageSource as CmmdtyOrderReqMessageSource,
BgRFCStatus.CmmdtyOrderRequestMessageText as CmmdtyOrderRequestMessageText,
BgRFCStatus.SystemMessageIdentification as SystemMessageIdentification,
BgRFCStatus.SystemMessageNumber as SystemMessageNumber
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CMMDTYORDERREQQUEUEERRLOGRAW",
"CMMFDOR_D_ORDER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/