A_SalesOrderScheduleLine

DDL: A_SALESORDERSCHEDULELINE Type: view COMPOSITE Package: ODATA_SD_SALESORDER_API

Item Schedule Line

A_SalesOrderScheduleLine is a Composite CDS View that provides data about "Item Schedule Line" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderScheduleLine) and exposes 20 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 3 associations to related views. Part of development package ODATA_SD_SALESORDER_API.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderScheduleLine I_SalesOrderScheduleLine from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentBasic SalesDocumentBasic SalesDocumentBasic.SalesDocument = $projection.SalesOrder
[1..1] A_SalesOrder _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder
[1..1] A_SalesOrderItem _SalesOrderItem $projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Item Schedule Line view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASOSLINE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder
KEY SalesOrderItem SalesOrderItem
KEY ScheduleLine ScheduleLine
RequestedDeliveryDate RequestedDeliveryDate
ConfirmedDeliveryDate ConfirmedDeliveryDate
OrderQuantityUnit OrderQuantityUnit
OrderQuantitySAPUnit
OrderQuantityISOUnit
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit
CorrectedQtyInOrderQtyUnit CorrectedQtyInOrderQtyUnit
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine
SalesOrderType SalesDocumentBasic SalesDocumentType
OrganizationDivision SalesDocumentBasic OrganizationDivision
SalesOrganization SalesDocumentBasic SalesOrganization
DistributionChannel SalesDocumentBasic DistributionChannel
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem 
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Item Schedule Line'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASOSLINE',
  compiler.compareFilter: true
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_SalesOrderScheduleLine
  as select from I_SalesOrderScheduleLine
  association [1..1] to I_SalesDocumentBasic as SalesDocumentBasic on  SalesDocumentBasic.SalesDocument = $projection.SalesOrder
  association [1..1] to A_SalesOrder         as _SalesOrder        on  $projection.SalesOrder = _SalesOrder.SalesOrder
  association [1..1] to A_SalesOrderItem     as _SalesOrderItem    on  $projection.SalesOrder     = _SalesOrderItem.SalesOrder
                                                                   and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem

{
      @ObjectModel.readOnly: true
  key SalesOrder,

      @ObjectModel.readOnly: true
  key SalesOrderItem,

  key ScheduleLine,

      RequestedDeliveryDate,
      ConfirmedDeliveryDate,
      
      @Semantics.unitOfMeasure: true
      OrderQuantityUnit,
      cast(_OrderQuantityUnit.UnitOfMeasureSAPCode as sd_ord_qty_sapunit preserving type) as OrderQuantitySAPUnit,
      cast(_OrderQuantityUnit.UnitOfMeasureISOCode as sd_ord_qty_isounit preserving type) as OrderQuantityISOUnit,
      
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @Semantics.quantity.unitOfMeasureSAPCode: 'OrderQuantitySAPUnit' 
      @Semantics.quantity.unitOfMeasureISOCode: 'OrderQuantityISOUnit'
      ScheduleLineOrderQuantity,
      
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @Semantics.quantity.unitOfMeasureSAPCode: 'OrderQuantitySAPUnit' 
      @Semantics.quantity.unitOfMeasureISOCode: 'OrderQuantityISOUnit'
      ConfdOrderQtyByMatlAvailCheck,
      
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @Semantics.quantity.unitOfMeasureSAPCode: 'OrderQuantitySAPUnit' 
      @Semantics.quantity.unitOfMeasureISOCode: 'OrderQuantityISOUnit'
      DeliveredQtyInOrderQtyUnit,
      
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @Semantics.quantity.unitOfMeasureSAPCode: 'OrderQuantitySAPUnit' 
      @Semantics.quantity.unitOfMeasureISOCode: 'OrderQuantityISOUnit'
      OpenConfdDelivQtyInOrdQtyUnit,
      
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @Semantics.quantity.unitOfMeasureSAPCode: 'OrderQuantitySAPUnit' 
      @Semantics.quantity.unitOfMeasureISOCode: 'OrderQuantityISOUnit'
      CorrectedQtyInOrderQtyUnit,
      
      DelivBlockReasonForSchedLine,

      // For Access control

      @Consumption.hidden: true
      SalesDocumentBasic.SalesDocumentType as SalesOrderType,
      //_SalesOrder.SalesOrderType,

      @Consumption.hidden: true
      SalesDocumentBasic.OrganizationDivision,
      @Consumption.hidden: true
      SalesDocumentBasic.SalesOrganization,
      @Consumption.hidden: true
      SalesDocumentBasic.DistributionChannel,

      // Expose own associations

      _SalesOrder,
      _SalesOrderItem


}

Learn More