Which tables does I_SalesOrderScheduleLine use?

I_SalesOrderScheduleLine reads from 1 data source(s): I_SalesDocumentScheduleLine.

How many fields does I_SalesOrderScheduleLine have?

I_SalesOrderScheduleLine has 66 fields. Key fields: SalesOrder, SalesOrderItem, ScheduleLine.

I_SalesOrderScheduleLine

DDL: I_SALESORDERSCHEDULELINE SQL: ISDSLSORDSCHEDLN Type: view BASIC Package: VDM_SD_SLS_SO

Sales Order Schedule Line

I_SalesOrderScheduleLine is a Basic CDS View (Dimension) that provides data about "Sales Order Schedule Line" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 66 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 2 associations to related views. Part of development package VDM_SD_SLS_SO.

Data Sources (1)

Source	Alias	Join Type
I_SalesDocumentScheduleLine	SalesDocumentScheduleLine	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_SalesOrder	_SalesOrder	`$projection.SalesOrder = _SalesOrder.SalesOrder`
[1..1]	I_SalesOrderItem	_SalesOrderItem	`$projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem and $projection.SalesOrder = _SalesOrderItem.SalesOrder`

Annotations (14)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.representativeKey	ScheduleLine	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
EndUserText.label	Sales Order Schedule Line	view
Analytics.dataCategory	#DIMENSION	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	ISDSLSORDSCHEDLN	view

Fields (66)

Key	Field	Source Table	Source Field
KEY	SalesOrder
KEY	SalesOrderItem
KEY	ScheduleLine	I_SalesDocumentScheduleLine	ScheduleLine
	ScheduleLineCategory	I_SalesDocumentScheduleLine	ScheduleLineCategory
	OrderQuantityUnit	I_SalesDocumentScheduleLine	OrderQuantityUnit
	OrderToBaseQuantityDnmntr	I_SalesDocumentScheduleLine	OrderToBaseQuantityDnmntr
	OrderToBaseQuantityNmrtr	I_SalesDocumentScheduleLine	OrderToBaseQuantityNmrtr
	BaseUnit	I_SalesDocumentScheduleLine	BaseUnit
	DeliveryDate	I_SalesDocumentScheduleLine	DeliveryDate
	IsRequestedDelivSchedLine
	RequestedDeliveryDate
	RequestedDeliveryTime	I_SalesDocumentScheduleLine	RequestedDeliveryTime
	ScheduleLineOrderQuantity	I_SalesDocumentScheduleLine	ScheduleLineOrderQuantity
	CorrectedQtyInOrderQtyUnit	I_SalesDocumentScheduleLine	CorrectedQtyInOrderQtyUnit
	IsConfirmedDelivSchedLine
	ConfirmedDeliveryDate
	ConfirmedDeliveryTime	I_SalesDocumentScheduleLine	ConfirmedDeliveryTime
	ConfdOrderQtyByMatlAvailCheck	I_SalesDocumentScheduleLine	ConfdOrderQtyByMatlAvailCheck
	ConfdSchedLineReqdDelivDate	I_SalesDocumentScheduleLine	ConfdSchedLineReqdDelivDate
	ProductAvailabilityDate	I_SalesDocumentScheduleLine	ProductAvailabilityDate
	ProductAvailabilityTime	I_SalesDocumentScheduleLine	ProductAvailabilityTime
	ProductAvailCheckRqmtDate	I_SalesDocumentScheduleLine	ProductAvailCheckRqmtDate
	ProdAvailabilityCheckRqmtType	I_SalesDocumentScheduleLine	ProdAvailabilityCheckRqmtType
	ProdAvailyCheckPlanningType	I_SalesDocumentScheduleLine	ProdAvailyCheckPlanningType
	ScheduleLineConfirmationStatus	I_SalesDocumentScheduleLine	ScheduleLineConfirmationStatus
	OrderSchedulingGroup	I_SalesDocumentScheduleLine	OrderSchedulingGroup
	PlannedOrder	I_SalesDocumentScheduleLine	PlannedOrder
	OrderID	I_SalesDocumentScheduleLine	OrderID
	PurchaseRequisition	I_SalesDocumentScheduleLine	PurchaseRequisition
	PurchaseRequisitionItem	I_SalesDocumentScheduleLine	PurchaseRequisitionItem
	PurchasingOrderType	I_SalesDocumentScheduleLine	PurchasingOrderType
	PurchasingDocumentCategory	I_SalesDocumentScheduleLine	PurchasingDocumentCategory
	DeliveryCreationDate	I_SalesDocumentScheduleLine	DeliveryCreationDate
	TransportationPlanningDate	I_SalesDocumentScheduleLine	TransportationPlanningDate
	TransportationPlanningTime	I_SalesDocumentScheduleLine	TransportationPlanningTime
	GoodsIssueDate	I_SalesDocumentScheduleLine	GoodsIssueDate
	LoadingDate	I_SalesDocumentScheduleLine	LoadingDate
	GoodsIssueTime	I_SalesDocumentScheduleLine	GoodsIssueTime
	LoadingTime	I_SalesDocumentScheduleLine	LoadingTime
	ItemIsDeliveryRelevant	I_SalesDocumentScheduleLine	ItemIsDeliveryRelevant
	DelivBlockReasonForSchedLine	I_SalesDocumentScheduleLine	DelivBlockReasonForSchedLine
	OpenReqdDelivQtyInOrdQtyUnit	I_SalesDocumentScheduleLine	OpenReqdDelivQtyInOrdQtyUnit
	OpenReqdDelivQtyInBaseUnit	I_SalesDocumentScheduleLine	OpenReqdDelivQtyInBaseUnit
	OpenConfdDelivQtyInOrdQtyUnit	I_SalesDocumentScheduleLine	OpenConfdDelivQtyInOrdQtyUnit
	OpenConfdDelivQtyInBaseUnit	I_SalesDocumentScheduleLine	OpenConfdDelivQtyInBaseUnit
	DeliveredQtyInOrderQtyUnit	I_SalesDocumentScheduleLine	DeliveredQtyInOrderQtyUnit
	DeliveredQuantityInBaseUnit	I_SalesDocumentScheduleLine	DeliveredQuantityInBaseUnit
	RequestedRqmtQtyInBaseUnit	I_SalesDocumentScheduleLine	RequestedRqmtQtyInBaseUnit
	ConfirmedRqmtQtyInBaseUnit	I_SalesDocumentScheduleLine	ConfirmedRqmtQtyInBaseUnit
	GoodsMovementType	I_SalesDocumentScheduleLine	GoodsMovementType
	OpenDeliveryNetAmount	I_SalesDocumentScheduleLine	OpenDeliveryNetAmount
	TransactionCurrency	I_SalesDocumentScheduleLine	TransactionCurrency
	TradeCmplncLegalCtrlChkSts	I_SalesDocumentScheduleLine	TradeCmplncLegalCtrlChkSts
	_SalesOrder		_SalesOrder
	_SalesOrderItem		_SalesOrderItem
	_ScheduleLineCategory	I_SalesDocumentScheduleLine	_ScheduleLineCategory
	_ProdAvailabilityCheckRqmtType	I_SalesDocumentScheduleLine	_ProdAvailabilityCheckRqmtType
	_ScheduleLineConfStatus	I_SalesDocumentScheduleLine	_ScheduleLineConfStatus
	_TransactionCurrency	I_SalesDocumentScheduleLine	_TransactionCurrency
	_OrderID	I_SalesDocumentScheduleLine	_OrderID
	_ManufacturingOrder	I_SalesDocumentScheduleLine	_ManufacturingOrder
	_OrderQuantityUnit	I_SalesDocumentScheduleLine	_OrderQuantityUnit
	_BaseUnit	I_SalesDocumentScheduleLine	_BaseUnit
	_DelivBlockReasonForSchedLine	I_SalesDocumentScheduleLine	_DelivBlockReasonForSchedLine
	_GoodsMovementType	I_SalesDocumentScheduleLine	_GoodsMovementType
	_TradeCmplncLegalCtrlChkSts	I_SalesDocumentScheduleLine	_TradeCmplncLegalCtrlChkSts

@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';

Depth:

I_SalesOrderScheduleLine view

I_SalesDocumentScheduleLine view