I_DeliveryStatus

DDL: I_DELIVERYSTATUS SQL: ISDDELIVERYSTS Type: view BASIC

Delivery Status

I_DeliveryStatus is a Basic CDS View (Dimension) that provides data about "Delivery Status" in SAP S/4HANA. It reads from 1 data source (dd07l) and exposes 2 fields with key field DeliveryStatus. It has 1 association to related views. It is exposed through 2 OData services (C_SALESORDERMANAGE_SD, UI_RFM_SLSORD_PRGS_MONITOR). It is used in 1 Fiori application: Monitor Sales Order Progress - Fashion.

Data Sources (1)

SourceAliasJoin Type
dd07l dd07l from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_DeliveryStatusText _Text $projection.DeliveryStatus = _Text.DeliveryStatus

Annotations (16)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey DeliveryStatus view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
EndUserText.label Delivery Status view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ISDDELIVERYSTS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name SalesDocDeliveryStatus view

OData Services (2)

ServiceBindingVersionContractRelease
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_RFM_SLSORD_PRGS_MONITOR UI_RFM_SLSORD_PRGS_MONITOR V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5392 Monitor Sales Order Progress - Fashion Transactional Monitor Sales Order Progress - Fashion : This app is used to track and further monitor for the different status of the Sales Orders and thereby further actions can be taken accordingly by the business,

Monitor Sales Order Progress - Fashion

Business Role: Order Fulfillment Specialist (Retail)

With this app, you can monitor the status, that is, the overall progress of account assigned sales orders. This application allows you to identify the conditions based on quantity and status. It checks for exceptions and helps you take informed decisions and necessary actions.

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DeliveryStatus
_Text _Text
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'DeliveryStatus'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.resultSet.sizeCategory: #XS
@EndUserText.label: 'Delivery Status'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ISDDELIVERYSTS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern:           #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities:  [  #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #ANALYTICAL_DIMENSION  ]
@ObjectModel.sapObjectNodeType.name: 'SalesDocDeliveryStatus'                                        
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_DeliveryStatus
as select from dd07l

association [0..*] to I_DeliveryStatusText as _Text on $projection.DeliveryStatus = _Text.DeliveryStatus
{
    @ObjectModel.text.association: '_Text'
    key SUBSTRING(dd07l.domvalue_l, 1, 1) as DeliveryStatus,
   
    _Text
}
where (dd07l.domname = 'STATV') and (dd07l.as4local = 'A');