I_SALESORDERSCHEDULELINE

CDS View

Sales Order Schedule Line

I_SALESORDERSCHEDULELINE is a CDS View in S/4HANA. Sales Order Schedule Line. It contains 25 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 25 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
/VSCEW/C_Disposition_VC view_entity left_outer Disposition VC (Customer Order)
A_SalesOrderScheduleLine view from COMPOSITE Item Schedule Line
A_SalesOrderScheduleLineSimln view from COMPOSITE Sales Order Schedule Line Sim (API)
A_SlsOrdScheduleLineSimln_2 view_entity from CONSUMPTION Sales Order Schedule Line Simulation
C_ESJISOScheduleLineDelivDate view from CONSUMPTION Requested Delivery Date from I_SalesOrderScheduleLine
C_SalesOrderScheduleLine view from CONSUMPTION Schedule Lines of Sales Order Item Factsheet
C_SlsOrdSchdLnWthCalInfoDEX view from CONSUMPTION Data Extraction for Sales Order Sched Line
I_MRPSalesOrder view from COMPOSITE MRP Sales Order
P_BusSolnOrdSlsOrdFlwLvl11 view inner CONSUMPTION Solution Order Sales Order Flow Level 11
R_SalesOrderScheduleLineTP view_entity from TRANSACTIONAL Schedule Line for Sales Order Item - TP

Fields (25)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition SubsequentDocument 1
KEY PurchasingDocumentCategory SubsequentDocumentCategory 1
KEY SalesOrder SalesOrder 4
KEY SalesOrderItem SalesOrderItem 4
KEY ScheduleLine ScheduleLine,ScheduleLineForEdit 3
_DelivBlockReasonForSchedLine _DelivBlockReasonForSchedLine 1
_GoodsMovementType _GoodsMovementType 1
_OrderQuantityUnit _OrderQuantityUnit 1
_ScheduleLineCategory _ScheduleLineCategory 1
BaseUnit BaseUnit 1
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck 2
ConfirmedDeliveryDate ConfirmedDeliveryDate 2
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine 1
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit 2
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
DeliveryDate DeliveryDate 1
GoodsMovementType GoodsMovementType 2
IsConfirmedDelivSchedLine IsConfirmedDelivSchedLine 1
IsRequestedDelivSchedLine IsRequestedDelivSchedLine 1
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit 1
OrderQuantityUnit OrderQuantityUnit 3
ProductAvailabilityDate ProductAvailabilityDate 1
RequestedDeliveryDate RequestedDeliveryDate 1
ScheduleLineCategory ScheduleLineCategory 3
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 2 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
    representativeKey: 'ScheduleLine',
    usageType:{
        dataClass: #TRANSACTIONAL,
        serviceQuality: #B,
        sizeCategory: #XL
        },
    supportedCapabilities: [ #ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE ],
    modelingPattern: #ANALYTICAL_DIMENSION
}
@EndUserText.label: 'Sales Order Schedule Line'
@Analytics.dataCategory: #DIMENSION
@Metadata: { allowExtensions: true,
             ignorePropagatedAnnotations: true }
@VDM: { viewType: #BASIC,
        lifecycle.contract.type: #PUBLIC_LOCAL_API }
@AccessControl: { authorizationCheck:#CHECK,
                  personalData.blocking:#('TRANSACTIONAL_DATA') }
@AbapCatalog.sqlViewName: 'ISDSLSORDSCHEDLN'

define view I_SalesOrderScheduleLine
  as select from           I_SalesDocumentScheduleLine as SalesDocumentScheduleLine
    left outer to one join I_SalesDocumentBasic        as SalesDocumentBasic on SalesDocumentScheduleLine.SalesDocument = SalesDocumentBasic.SalesDocument
  association [1..1] to I_SalesOrder     as _SalesOrder     on  $projection.SalesOrder = _SalesOrder.SalesOrder
  association [1..1] to I_SalesOrderItem as _SalesOrderItem on  $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
                                                            and $projection.SalesOrder     = _SalesOrderItem.SalesOrder
{
      // Key

      @ObjectModel.foreignKey.association: '_SalesOrder'
  key cast(SalesDocumentScheduleLine.SalesDocument as vdm_sales_order preserving type)      as SalesOrder,
      @ObjectModel.foreignKey.association: '_SalesOrderItem'
  key cast(SalesDocumentScheduleLine.SalesDocumentItem as sales_order_item preserving type) as SalesOrderItem,
  key SalesDocumentScheduleLine.ScheduleLine,

      // Category

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

      // Sales

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_OrderQuantityUnit'
      SalesDocumentScheduleLine.OrderQuantityUnit,
      SalesDocumentScheduleLine.OrderToBaseQuantityDnmntr,
      SalesDocumentScheduleLine.OrderToBaseQuantityNmrtr,
      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      SalesDocumentScheduleLine.BaseUnit,
      SalesDocumentScheduleLine.DeliveryDate,

      // Requested

      cast(SalesDocumentScheduleLine.IsRequestedDelivSchedLine as reqd_deliv)               as IsRequestedDelivSchedLine,
      cast(SalesDocumentScheduleLine.RequestedDeliveryDate as reqd_deliv_date)              as RequestedDeliveryDate,
      SalesDocumentScheduleLine.RequestedDeliveryTime,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      SalesDocumentScheduleLine.ScheduleLineOrderQuantity,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      SalesDocumentScheduleLine.CorrectedQtyInOrderQtyUnit,

      // Confirmed

      cast(SalesDocumentScheduleLine.IsConfirmedDelivSchedLine as confd_deliv)              as IsConfirmedDelivSchedLine,
      cast(SalesDocumentScheduleLine.ConfirmedDeliveryDate as confd_deliv_date)             as ConfirmedDeliveryDate,
      SalesDocumentScheduleLine.ConfirmedDeliveryTime,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      SalesDocumentScheduleLine.ConfdOrderQtyByMatlAvailCheck,
      SalesDocumentScheduleLine.ConfdSchedLineReqdDelivDate,

      // Availability

      SalesDocumentScheduleLine.ProductAvailabilityDate,
      SalesDocumentScheduleLine.ProductAvailabilityTime,
      SalesDocumentScheduleLine.ProductAvailCheckRqmtDate,
      SalesDocumentScheduleLine.ProdAvailabilityCheckRqmtType,
      SalesDocumentScheduleLine.ProdAvailyCheckPlanningType,
      @ObjectModel.foreignKey.association: '_ScheduleLineConfStatus'
      SalesDocumentScheduleLine.ScheduleLineConfirmationStatus,
      SalesDocumentScheduleLine.OrderSchedulingGroup,

      //InternalProcurement

      SalesDocumentScheduleLine.PlannedOrder,
      @ObjectModel.foreignKey.association: '_OrderID'
      SalesDocumentScheduleLine.OrderID,

      //Purchasing

      SalesDocumentScheduleLine.PurchaseRequisition,
      SalesDocumentScheduleLine.PurchaseRequisitionItem,
      SalesDocumentScheduleLine.PurchasingOrderType,
      SalesDocumentScheduleLine.PurchasingDocumentCategory,


      // Shipping

      SalesDocumentScheduleLine.DeliveryCreationDate,
      SalesDocumentScheduleLine.TransportationPlanningDate,
      SalesDocumentScheduleLine.TransportationPlanningTime,
      SalesDocumentScheduleLine.GoodsIssueDate,
      SalesDocumentScheduleLine.LoadingDate,
      SalesDocumentScheduleLine.GoodsIssueTime,
      SalesDocumentScheduleLine.LoadingTime,
      SalesDocumentScheduleLine.ItemIsDeliveryRelevant,
      @ObjectModel.foreignKey.association: '_DelivBlockReasonForSchedLine'
      SalesDocumentScheduleLine.DelivBlockReasonForSchedLine,

      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      SalesDocumentScheduleLine.OpenReqdDelivQtyInOrdQtyUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      SalesDocumentScheduleLine.OpenReqdDelivQtyInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      SalesDocumentScheduleLine.OpenConfdDelivQtyInOrdQtyUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      SalesDocumentScheduleLine.OpenConfdDelivQtyInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      SalesDocumentScheduleLine.DeliveredQtyInOrderQtyUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      SalesDocumentScheduleLine.DeliveredQuantityInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      SalesDocumentScheduleLine.RequestedRqmtQtyInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      SalesDocumentScheduleLine.ConfirmedRqmtQtyInBaseUnit,

      @ObjectModel.foreignKey.association: '_GoodsMovementType'
      SalesDocumentScheduleLine.GoodsMovementType,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      SalesDocumentScheduleLine.OpenDeliveryNetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      SalesDocumentScheduleLine.TransactionCurrency,
      @ObjectModel.foreignKey.association: '_TradeCmplncLegalCtrlChkSts'
      SalesDocumentScheduleLine.TradeCmplncLegalCtrlChkSts,

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _SalesOrder,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _SalesOrderItem,
      SalesDocumentScheduleLine._ScheduleLineCategory,
      SalesDocumentScheduleLine._ProdAvailabilityCheckRqmtType,
      SalesDocumentScheduleLine._ScheduleLineConfStatus,
      SalesDocumentScheduleLine._TransactionCurrency,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_ManufacturingOrder'
      SalesDocumentScheduleLine._OrderID,
      SalesDocumentScheduleLine._ManufacturingOrder,
      SalesDocumentScheduleLine._OrderQuantityUnit,
      SalesDocumentScheduleLine._BaseUnit,
      SalesDocumentScheduleLine._DelivBlockReasonForSchedLine,
      SalesDocumentScheduleLine._GoodsMovementType,
      SalesDocumentScheduleLine._TradeCmplncLegalCtrlChkSts
}
where
  SalesDocumentBasic.SDDocumentCategory = 'C';

Learn More