@AbapCatalog.sqlViewName: 'COUTBDELIVLIST'
@ClientHandling.algorithm:#SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Metadata.allowExtensions: true -- UI Annotations in the Metadata Extensions file
@AbapCatalog.viewEnhancementCategory: [#PROJECTION_LIST, #UNION] -- Enabled creating extension for UNION view
@ObjectModel: {
compositionRoot: true,
semanticKey: ['DeliveryDocument'],
representativeKey: 'DeliveryDocument',
usageType.dataClass: #MIXED,
usageType.serviceQuality: #D,
usageType.sizeCategory: #XL,
updateEnabled: true
}
@UI.headerInfo: {
typeName: 'Manage Outbound Delivery',
typeNamePlural: 'Manage Outbound Deliveries', -- Object List Table Title
title: {
type: #STANDARD,
value: 'DeliveryDocument',
label: 'Outbound Delivery'
},
description: {
value: 'PickingDate'
}
}
@UI.presentationVariant:{
requestAtLeast: ['OverallPickingStatus', 'OverallPickingConfStatus', 'OverallGoodsMovementStatus',
'ActualGoodsMovementDate', 'SDDocumentCategory', 'OverallChmlCmplncStatus',
'OverallDangerousGoodsStatus', 'OverallSafetyDataSheetStatus']
}
define view C_OutboundDeliveryList
as select from I_DeliveryDocument as DeliveryDocument
association to I_LogProcgSts as _LogProcgStsPick on $projection.OverallPickingStatus = _LogProcgStsPick.ProcessingStatus
association to I_LogProcgSts as _LogProcgStsConf on $projection.OverallPickingConfStatus = _LogProcgStsConf.ProcessingStatus
association to I_LogProcgSts as _LogProcgStsMove on $projection.OverallGoodsMovementStatus = _LogProcgStsMove.ProcessingStatus
association [0..*] to C_DeliveryShipToPartyVH as _DlvShipToPartyVH on $projection.ShipToParty = _DlvShipToPartyVH.Customer
association [0..1] to I_DeliveryPriority as _DeliveryPriority on $projection.DeliveryPriority = _DeliveryPriority.DeliveryPriority
association [0..1] to C_ShippingPointVH as _ShippingPointVH on $projection.ShippingPoint = _ShippingPointVH.ShippingPoint
association [0..1] to C_OutboundDeliveryTypeVH as _DeliveryTypeVH on $projection.DeliveryDocumentType = _DeliveryTypeVH.DeliveryDocumentType
association [0..1] to I_User as _User on $projection.CreatedByUser = _User.UserID
association [0..*] to C_OutbDelivFirstFreightOrd as _FreightOrder on $projection.DeliveryDocument = _FreightOrder.DeliveryDocument
{
@EndUserText.label: 'Delivery Document'
@Consumption.semanticObject: #(SemanticObject)
key DeliveryDocument as DeliveryDocument,
@UI.hidden: true
case SDDocumentCategory
when 'J' then 'OutboundDelivery'
when 'T' then 'ReturnsDelivery'
end as SemanticObject,
@EndUserText.label: 'Excise Tax ARC Status'
@ObjectModel.foreignKey.association: '_ExciseTaxStatus'
EU_DeliveryARCStatus,
@ObjectModel.foreignKey.association: '_DeliveryPriority'
case
when DeliveryPriority = '00' then ' '
else DeliveryPriority
end as DeliveryPriority,
PickingDate,
@EndUserText.label: 'Picking Status'
@ObjectModel.foreignKey.association:'_LogProcgStsPick'
OverallPickingStatus,
@UI.hidden
cast(
case OverallPickingStatus
when '' then 0
when 'A' then 1
when 'B' then 2
when 'C' then 3
else 0
end as abap.int1
) as PickingStatusCriticality,
@EndUserText.label: 'Confirmation Status'
@ObjectModel.foreignKey.association:'_LogProcgStsConf'
OverallPickingConfStatus,
@UI.hidden
cast(
case OverallPickingConfStatus
when '' then 0
when 'A' then 1
when 'B' then 2
when 'C' then 3
else 0
end as abap.int1
) as ConfirmationStatusCriticality,
@EndUserText.quickInfo: 'First Freight Order of Delivery'
@ObjectModel.text.element: ['FreightOrder']
@Consumption.valueHelpDefinition: [{entity: {name: 'C_OutbDelivFreightOrdVH',element: 'FreightOrder'} }]
_FreightOrder.FreightOrder as FreightOrder,
@EndUserText.label: 'GI Status'
@ObjectModel.foreignKey.association:'_LogProcgStsMove'
OverallGoodsMovementStatus,
@UI.hidden
cast(
case OverallGoodsMovementStatus
when '' then 0
when 'A' then 1
when 'B' then 2
when 'C' then 3
else 0
end as abap.int1
) as GoodsMovementStatusCriticality,
@Consumption.valueHelpDefinition: [ { entity: { name: 'D_CustomerCVH', element: 'Customer' } } ]
@ObjectModel.text.element: ['CustomerName']
@UI.textArrangement: #TEXT_FIRST
@Consumption.semanticObject: 'Customer'
ShipToParty,
@UI.hidden: true
_Partner[1:PartnerFunction='WE']._DfltAddrRprstn.AddresseeFullName as CustomerName,
@UI.textArrangement: #TEXT_FIRST
@Consumption.valueHelpDefinition: [{entity: {name: 'C_ShippingPointVH',element: 'ShippingPoint'} }]
@ObjectModel.text.element: ['ShippingPointName']
ShippingPoint,
@UI.hidden: true
cast(_ShippingPoint._Text[1: Language=$session.system_language].ShippingPointName as bezei30) as ShippingPointName,
@EndUserText.label: 'Actual Goods Movement Date'
ActualGoodsMovementDate,
cast (PlannedGoodsIssueDate as wadak_plan) as PlannedGoodsIssueDate,
LoadingDate,
@Consumption.valueHelpDefinition: [ { entity: { name: 'C_OutbDelivListCreatedByVH', element: 'UserID' } } ]
@ObjectModel.text.element: [ 'UserDescription' ]
CreatedByUser,
@UI.hidden: true
@Semantics.text: true
_User.UserDescription as UserDescription,
@Consumption.valueHelpDefinition: [{entity: {name: 'C_OutboundDeliveryTypeVH',element: 'DeliveryDocumentType'} }]
@UI.textArrangement: #TEXT_FIRST
@ObjectModel.text.element: ['DeliveryTypeName']
DeliveryDocumentType,
@UI.hidden: true
cast(_DeliveryTypeVH._Text[1: Language=$session.system_language].DeliveryDocumentTypeName as vtext) as DeliveryTypeName,
@Consumption.filter.selectionType:#INTERVAL
CreationDate,
@UI.hidden: true
SDDocumentCategory as SDDocumentCategory,
// Overall Marketability Check Status
@ObjectModel.foreignKey.association:'_OverallChmlCmplncStatus'
@EndUserText.label: 'Product Marketability Status'
OverallChmlCmplncStatus,
@UI.hidden
cast(
case OverallChmlCmplncStatus
when '' then 0
when 'A' then 3
when 'C' then 1
when 'D' then 1
else 0
end as abap.int1
) as OvrlChmlCmplncStsCriticality,
// Overall Dangerous Goods Status
@ObjectModel.foreignKey.association:'_OverallDangerousGoodsStatus'
@EndUserText.label: 'Dangerous Goods Status'
OverallDangerousGoodsStatus,
@UI.hidden
cast(
case OverallDangerousGoodsStatus
when '' then 0
when 'A' then 3
when 'B' then 2
when 'D' then 1
else 0
end as abap.int1
) as OvrlDngrsGdsStsCriticality,
// Overall Safety Data Sheet Status
@ObjectModel.foreignKey.association:'_OvrlSftyDataSheetSts'
@EndUserText.label: 'Safety Data Sheet Status'
OverallSafetyDataSheetStatus,
@UI.hidden
cast(
case OverallSafetyDataSheetStatus
when '' then 0
when 'A' then 3
when 'B' then 2
when 'D' then 1
else 0
end as abap.int1
) as OvrlSftyDataSheetStsCritlty,
@EndUserText.label: 'Warehouse Execution Status'
@Feature: 'LE_SHP_ASR_SHOW_FIELDS'
@ObjectModel.foreignKey.association: '_WarehouseExecutionStatus'
ReadyForWarehouseExecStatus,
@EndUserText.label: 'Adv. Ship. & Rec. Relevance'
@Feature: 'LE_SHP_ASR_SHOW_FIELDS'
@ObjectModel.foreignKey.association: '_DelivAdvncdShipgRcvgRlvnce'
DelivAdvncdShipgRcvgRlvnce,
// @ObjectModel.foreignKey.association: '_ProposedDeliveryRoute'
@Consumption.valueHelpDefinition: [ { entity: { name: 'C_OutbDelivListPrpsdDlvRouteVH', element: 'Route' } } ]
ProposedDeliveryRoute,
//Associations
@Consumption.filter.hidden: true
_DeliveryPriority,
@Consumption.filter.hidden: true
_ShipToParty,
@Consumption.filter.hidden: true
_ShippingPoint,
@Consumption.filter.hidden: true
_LogProcgStsPick,
@Consumption.filter.hidden: true
_LogProcgStsConf,
@Consumption.filter.hidden: true
_LogProcgStsMove,
@Consumption.filter.hidden: true
_DlvShipToPartyVH,
@Consumption.filter.hidden: true
_DeliveryTypeVH,
@Consumption.filter.hidden: true
_ShippingPointVH,
@Consumption.filter.hidden: true
_OverallChmlCmplncStatus,
@Consumption.filter.hidden: true
_OverallDangerousGoodsStatus,
@Consumption.filter.hidden: true
_OvrlSftyDataSheetSts,
@Consumption.filter.hidden: true
_User,
@Consumption.filter.hidden: true
_ExciseTaxStatus,
@Consumption.filter.hidden: true
_WarehouseExecutionStatus,
@Consumption.filter.hidden: true
_DelivAdvncdShipgRcvgRlvnce,
@Consumption.filter.hidden: true
_ProposedDeliveryRoute,
@Consumption.filter.hidden: true
_FreightOrder
} where SDDocumentCategory = 'J' or SDDocumentCategory = 'T'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_OUTBDELIVFIRSTFREIGHTORD",
"C_OUTBOUNDDELIVERYTYPEVH",
"I_ADDRESS_2",
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTTYPETEXT",
"I_SDDOCUMENTPARTNER",
"I_SHIPPINGPOINT",
"I_SHIPPINGPOINTTEXT",
"I_USER"
],
"ASSOCIATED":
[
"C_DELIVERYSHIPTOPARTYVH",
"C_OUTBDELIVFIRSTFREIGHTORD",
"C_OUTBOUNDDELIVERYTYPEVH",
"C_SHIPPINGPOINTVH",
"I_ADVSHIPRECEIVERLVNCE",
"I_CUSTOMER",
"I_DELIVERYPRIORITY",
"I_EXCISETAXSTATUS",
"I_LOGPROCGSTS",
"I_OVERALLDELIVCHMLCMPLNCSTS",
"I_OVRLDELIVDNGRSGDSSTS",
"I_OVRLDELIVSFTYDATASHTSTS",
"I_ROUTE",
"I_SHIPPINGPOINT",
"I_USER",
"I_WAREHOUSEEXECUTIONSTATUS"
],
"BASE":
[
"I_DELIVERYDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/