A_SlsOrdScheduleLineSimln_2

DDL: A_SLSORDSCHEDULELINESIMLN_2 Type: view_entity CONSUMPTION Package: ODATA_SD_SALESORDER_API

Sales Order Schedule Line Simulation

A_SlsOrdScheduleLineSimln_2 is a Consumption CDS View that provides data about "Sales Order Schedule Line Simulation" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderScheduleLine) and exposes 26 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 1 association to related views. It is exposed through 1 OData service (API_SALESORDERSIMULATION). Part of development package ODATA_SD_SALESORDER_API.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderScheduleLine SalesOrderScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_SalesOrderSimulation_2 _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sales Order Schedule Line Simulation view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.query.implementedBy ABAP:CL_SD_SO_SIMLN_RAP_V4_QRY view
OData.entityType.name SalesOrderScheduleLine_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_SALESORDERSIMULATION API_SALESORDERSIMULATION V4 C2 C1

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrderScheduleLine SalesOrder
KEY SalesOrderItem I_SalesOrderScheduleLine SalesOrderItem
KEY ScheduleLine I_SalesOrderScheduleLine ScheduleLine
ScheduleLineCategory I_SalesOrderScheduleLine ScheduleLineCategory
ScheduleLineOrderQuantity_H
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
OrderQuantitySAPUnit OrderQuantityUnit
OrderQuantityISOUnit
RequestedDeliveryDate RequestedDeliveryDate
ConfirmedDeliveryDate ConfirmedDeliveryDate
ConfdOrdQtyByMatlAvailCheck_H
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit
CorrectedQtyInOrderQtyUnit CorrectedQtyInOrderQtyUnit
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem_H
PurchaseRequisitionItem PurchaseRequisitionItem
GoodsMovementType I_SalesOrderScheduleLine GoodsMovementType
_Item _Item
_SalesOrder _SalesOrder
SalesOrderType _SalesOrder SalesOrderType
OrganizationDivision _SalesOrder OrganizationDivision
SalesOrganization _SalesOrder SalesOrganization
DistributionChannel _SalesOrder DistributionChannel
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@EndUserText.label: 'Sales Order Schedule Line Simulation'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
  semanticKey: ['SalesOrder','SalesOrderItem', 'ScheduleLine'],
  usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   },
   query.implementedBy: 'ABAP:CL_SD_SO_SIMLN_RAP_V4_QRY'
}

@OData: {
  entityType.name: 'SalesOrderScheduleLine_Type'
}

@VDM: {
  lifecycle.contract.type: #PUBLIC_REMOTE_API,
  viewType: #CONSUMPTION,
  usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
}
define view entity A_SlsOrdScheduleLineSimln_2
  as select from I_SalesOrderScheduleLine as SalesOrderScheduleLine
  association        to parent A_SalesOrderItemSimulation_2   as _Item       on  $projection.SalesOrder             = _Item.SalesOrder
                                                                   and $projection.SalesOrderItem         = _Item.SalesOrderItem
  association [1..1] to A_SalesOrderSimulation_2              as _SalesOrder on  $projection.SalesOrder             = _SalesOrder.SalesOrder

{
    
    key SalesOrderScheduleLine.SalesOrder,

    key SalesOrderScheduleLine.SalesOrderItem,

    key SalesOrderScheduleLine.ScheduleLine,
    
    @ObjectModel.sapObjectNodeTypeReference: 'SalesDocScheduleLineCategory'
    SalesOrderScheduleLine.ScheduleLineCategory,
    
    @Consumption.hidden: true
    @Semantics.nullValueIndicatorFor: 'ScheduleLineOrderQuantity'
    cast( '' as rap_null_value_indicator ) as ScheduleLineOrderQuantity_H,
    
    @Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
    ScheduleLineOrderQuantity,
    
    OrderQuantityUnit                                            as OrderQuantitySAPUnit,
    cast(_OrderQuantityUnit.UnitOfMeasureISOCode as sd_ord_qty_isounit preserving type) as OrderQuantityISOUnit,
    
    RequestedDeliveryDate,

    ConfirmedDeliveryDate,
    
    
    @Consumption.hidden: true
    @Semantics.nullValueIndicatorFor: 'ConfdOrderQtyByMatlAvailCheck'
    cast( '' as rap_null_value_indicator ) as ConfdOrdQtyByMatlAvailCheck_H,
    
    @Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
    ConfdOrderQtyByMatlAvailCheck,
    
    @Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
    DeliveredQtyInOrderQtyUnit,
          
    @Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
    OpenConfdDelivQtyInOrdQtyUnit,

    @Semantics.quantity.unitOfMeasure: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureSapCode: 'OrderQuantitySAPUnit'
    @Semantics.quantity.unitOfMeasureIsoCode: 'OrderQuantityISOUnit'
    CorrectedQtyInOrderQtyUnit,
    
    @ObjectModel.sapObjectNodeTypeReference: 'DeliveryBlockReason'
    DelivBlockReasonForSchedLine,
    
    PurchaseRequisition,
    
    @Consumption.hidden: true
    @Semantics.nullValueIndicatorFor: 'PurchaseRequisitionItem'
    cast( '' as rap_null_value_indicator ) as PurchaseRequisitionItem_H,    
    
    PurchaseRequisitionItem,
    
    @ObjectModel.sapObjectNodeTypeReference: 'GoodsMovementType'
    SalesOrderScheduleLine.GoodsMovementType,
    
    //Parent

    @ObjectModel.filter.enabled: false
    @ObjectModel.sort.enabled: false
    _Item,
    @ObjectModel.filter.enabled: false
    @ObjectModel.sort.enabled: false
    _SalesOrder,
    
    // For Access control

    @Consumption.hidden: true
    _SalesOrder.SalesOrderType,
    @Consumption.hidden: true
    _SalesOrder.OrganizationDivision,
    @Consumption.hidden: true
    _SalesOrder.SalesOrganization,
    @Consumption.hidden: true
    _SalesOrder.DistributionChannel
}