A_SalesOrderScheduleLineSimln

DDL: A_SALESORDERSCHEDULELINESIMLN Type: view COMPOSITE Package: ODATA_SD_SALESORDER_API

Sales Order Schedule Line Sim (API)

A_SalesOrderScheduleLineSimln is a Composite CDS View that provides data about "Sales Order Schedule Line Sim (API)" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderScheduleLine) and exposes 18 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) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderScheduleLine ScheduleLine from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentBasic _SalesDocument _SalesDocument.SalesDocument = $projection.SalesOrder
[1..1] A_SalesOrderSimulation _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder
[1..1] A_SalesOrderItemSimulation _SalesOrderItem $projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Order Schedule Line Sim (API) view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASOSLINESIMLN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

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

define view A_SalesOrderScheduleLineSimln
  as select from I_SalesOrderScheduleLine as ScheduleLine

  association [1..1] to I_SalesDocumentBasic       as _SalesDocument  on  _SalesDocument.SalesDocument = $projection.SalesOrder

  association [1..1] to A_SalesOrderSimulation     as _SalesOrder     on  $projection.SalesOrder = _SalesOrder.SalesOrder

  association [1..1] to A_SalesOrderItemSimulation 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'      
      OpenConfdDelivQtyInOrdQtyUnit,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @Semantics.quantity.unitOfMeasureSAPCode: 'OrderQuantitySAPUnit' 
      @Semantics.quantity.unitOfMeasureISOCode: 'OrderQuantityISOUnit'      
      CorrectedQtyInOrderQtyUnit,

      // For Access control

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

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

      // Expose own associations

      _SalesOrder,
      _SalesOrderItem

}
where
  ScheduleLine.SalesOrder = '0'

Learn More