R_SalesOrderScheduleLineTP

DDL: R_SALESORDERSCHEDULELINETP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_SO

Schedule Line for Sales Order Item - TP

R_SalesOrderScheduleLineTP is a Transactional CDS View that provides data about "Schedule Line for Sales Order Item - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderScheduleLine) and exposes 33 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 1 association to related views. Part of development package RAP_SD_SLS_SO.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderScheduleLine SalesOrderScheduleLine from

Associations (1)

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

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Schedule Line for Sales Order Item - TP view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrderScheduleLine SalesOrder
KEY SalesOrderItem I_SalesOrderScheduleLine SalesOrderItem
KEY ScheduleLine I_SalesOrderScheduleLine ScheduleLine
ScheduleLineForEdit I_SalesOrderScheduleLine ScheduleLine
ScheduleLineCategory I_SalesOrderScheduleLine ScheduleLineCategory
OrderQuantityUnit OrderQuantityUnit
OrderQuantitySAPUnit
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit
CorrectedQtyInOrderQtyUnit CorrectedQtyInOrderQtyUnit
DeliveryDate DeliveryDate
RequestedDeliveryDate RequestedDeliveryDate
ConfirmedDeliveryDate ConfirmedDeliveryDate
ProductAvailabilityDate ProductAvailabilityDate
TransportationPlanningDate TransportationPlanningDate
GoodsIssueDate GoodsIssueDate
LoadingDate LoadingDate
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
GoodsMovementType I_SalesOrderScheduleLine GoodsMovementType
_Item _Item
_SalesOrder _SalesOrder
SalesOrderType _SalesOrder SalesOrderType
OrganizationDivision _SalesOrder OrganizationDivision
SalesOrganization _SalesOrder SalesOrganization
DistributionChannel _SalesOrder DistributionChannel
_OrderQuantityUnit I_SalesOrderScheduleLine _OrderQuantityUnit
_DelivBlockReasonForSchedLine I_SalesOrderScheduleLine _DelivBlockReasonForSchedLine
_ScheduleLineCategory I_SalesOrderScheduleLine _ScheduleLineCategory
_GoodsMovementType I_SalesOrderScheduleLine _GoodsMovementType 
@VDM: {
  lifecycle.contract.type: #SAP_INTERNAL_API,
  viewType: #TRANSACTIONAL
}

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

@Metadata.ignorePropagatedAnnotations: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

@EndUserText.label: 'Schedule Line for Sales Order Item - TP'

define view entity R_SalesOrderScheduleLineTP
  as select from I_SalesOrderScheduleLine as SalesOrderScheduleLine
  association        to parent R_SalesOrderItemTP   as _Item       on  $projection.SalesOrder             = _Item.SalesOrder
                                                                   and $projection.SalesOrderItem         = _Item.SalesOrderItem
  association [1..1] to R_SalesOrderTP              as _SalesOrder on  $projection.SalesOrder             = _SalesOrder.SalesOrder
 
{
  key SalesOrderScheduleLine.SalesOrder,

  key SalesOrderScheduleLine.SalesOrderItem,

  key SalesOrderScheduleLine.ScheduleLine,

      @ObjectModel.editableFieldFor: 'ScheduleLine'
      SalesOrderScheduleLine.ScheduleLine                                                 as ScheduleLineForEdit,

      @ObjectModel.foreignKey.association: '_ScheduleLineCategory'
      SalesOrderScheduleLine.ScheduleLineCategory,

      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      OrderQuantityUnit,
      cast(_OrderQuantityUnit.UnitOfMeasureSAPCode as sd_ord_qty_sapunit preserving type) as OrderQuantitySAPUnit,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ScheduleLineOrderQuantity,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      ConfdOrderQtyByMatlAvailCheck,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      DeliveredQtyInOrderQtyUnit,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      OpenConfdDelivQtyInOrdQtyUnit,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      CorrectedQtyInOrderQtyUnit,

      DeliveryDate,

      RequestedDeliveryDate,

      ConfirmedDeliveryDate,

      ProductAvailabilityDate,
      
      TransportationPlanningDate,
      
      GoodsIssueDate,
      
      LoadingDate,

      @ObjectModel.foreignKey.association: '_DelivBlockReasonForSchedLine'
      DelivBlockReasonForSchedLine,

      PurchaseRequisition,
      PurchaseRequisitionItem,
      
      @ObjectModel.foreignKey.association: '_GoodsMovementType'
      SalesOrderScheduleLine.GoodsMovementType,
      
      //Parent

      _Item,
      _SalesOrder,

      // For Access control

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

      //Associations

      SalesOrderScheduleLine._OrderQuantityUnit,
      SalesOrderScheduleLine._DelivBlockReasonForSchedLine,
      SalesOrderScheduleLine._ScheduleLineCategory,
      SalesOrderScheduleLine._GoodsMovementType
}

Learn More