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 63 fields. Key fields: SalesOrder, SalesOrderItem, ScheduleLine.

I_SalesOrderScheduleLine

DDL: I_SALESORDERSCHEDULELINE SQL: ISDSLSORDSCHEDLN Type: view BASIC

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 63 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 2 associations to related views.

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 (11)

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
EndUserText.label	Sales Order Schedule Line	view
Analytics.dataCategory	#DIMENSION	view
Metadata.allowExtensions	true	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	ISDSLSORDSCHEDLN	view

Fields (63)

Key	Field	Source Table	Source Field
KEY	SalesOrder	I_SalesDocumentScheduleLine	SalesDocument
KEY	SalesOrderItem		SalesDocumentItem
KEY	ScheduleLine		ScheduleLine
	ScheduleLineCategory		ScheduleLineCategory
	OrderQuantityUnit		OrderQuantityUnit
	OrderToBaseQuantityDnmntr		OrderToBaseQuantityDnmntr
	OrderToBaseQuantityNmrtr		OrderToBaseQuantityNmrtr
	BaseUnit		BaseUnit
	DeliveryDate		DeliveryDate
	IsRequestedDelivSchedLine
	RequestedDeliveryDate
	RequestedDeliveryTime		RequestedDeliveryTime
	ScheduleLineOrderQuantity		ScheduleLineOrderQuantity
	CorrectedQtyInOrderQtyUnit		CorrectedQtyInOrderQtyUnit
	IsConfirmedDelivSchedLine
	ConfirmedDeliveryDate
	ConfirmedDeliveryTime		ConfirmedDeliveryTime
	ConfdOrderQtyByMatlAvailCheck		ConfdOrderQtyByMatlAvailCheck
	ConfdSchedLineReqdDelivDate		ConfdSchedLineReqdDelivDate
	ProductAvailabilityDate		ProductAvailabilityDate
	ProductAvailabilityTime		ProductAvailabilityTime
	ProductAvailCheckRqmtDate		ProductAvailCheckRqmtDate
	ProdAvailabilityCheckRqmtType		ProdAvailabilityCheckRqmtType
	ProdAvailyCheckPlanningType		ProdAvailyCheckPlanningType
	ScheduleLineConfirmationStatus		ScheduleLineConfirmationStatus
	OrderSchedulingGroup		OrderSchedulingGroup
	PlannedOrder		PlannedOrder
	OrderID	I_SalesDocumentScheduleLine	OrderID
	PurchaseRequisition		PurchaseRequisition
	PurchaseRequisitionItem		PurchaseRequisitionItem
	PurchasingOrderType		PurchasingOrderType
	PurchasingDocumentCategory		PurchasingDocumentCategory
	DeliveryCreationDate		DeliveryCreationDate
	TransportationPlanningDate		TransportationPlanningDate
	TransportationPlanningTime		TransportationPlanningTime
	GoodsIssueDate		GoodsIssueDate
	LoadingDate		LoadingDate
	GoodsIssueTime		GoodsIssueTime
	LoadingTime		LoadingTime
	ItemIsDeliveryRelevant		ItemIsDeliveryRelevant
	DelivBlockReasonForSchedLine		DelivBlockReasonForSchedLine
	OpenReqdDelivQtyInOrdQtyUnit		OpenReqdDelivQtyInOrdQtyUnit
	OpenReqdDelivQtyInBaseUnit		OpenReqdDelivQtyInBaseUnit
	OpenConfdDelivQtyInOrdQtyUnit		OpenConfdDelivQtyInOrdQtyUnit
	OpenConfdDelivQtyInBaseUnit		OpenConfdDelivQtyInBaseUnit
	DeliveredQtyInOrderQtyUnit		DeliveredQtyInOrderQtyUnit
	DeliveredQuantityInBaseUnit		DeliveredQuantityInBaseUnit
	GoodsMovementType		GoodsMovementType
	OpenDeliveryNetAmount		OpenDeliveryNetAmount
	TransactionCurrency	I_SalesDocumentScheduleLine	TransactionCurrency
	TradeCmplncLegalCtrlChkSts	I_SalesDocumentScheduleLine	TradeCmplncLegalCtrlChkSts
	_SalesOrder		_SalesOrder
	_SalesOrderItem		_SalesOrderItem
	_ScheduleLineCategory		_ScheduleLineCategory
	_ProdAvailabilityCheckRqmtType		_ProdAvailabilityCheckRqmtType
	_ScheduleLineConfStatus		_ScheduleLineConfStatus
	_TransactionCurrency	I_SalesDocumentScheduleLine	_TransactionCurrency
	_OrderID		_OrderID
	_OrderQuantityUnit		_OrderQuantityUnit
	_BaseUnit		_BaseUnit
	_DelivBlockReasonForSchedLine		_DelivBlockReasonForSchedLine
	_GoodsMovementType		_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
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#CHECK
@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 SalesDocumentScheduleLine.SalesDocument                                   as SalesOrder,
      @ObjectModel.foreignKey.association: '_SalesOrderItem'
  key SalesDocumentItem                                                         as SalesOrderItem,
  key ScheduleLine,

      // Category

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

      // Sales

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

      // Requested

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

      // Confirmed

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

      // Availability

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

      //InternalProcurement

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

      //Purchasing

      PurchaseRequisition,
      PurchaseRequisitionItem,
      PurchasingOrderType,
      PurchasingDocumentCategory,


      // Shipping

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

      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      OpenReqdDelivQtyInOrdQtyUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      OpenReqdDelivQtyInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      OpenConfdDelivQtyInOrdQtyUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      OpenConfdDelivQtyInBaseUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      DeliveredQtyInOrderQtyUnit,
      @DefaultAggregation: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      DeliveredQuantityInBaseUnit,
      @ObjectModel.foreignKey.association: '_GoodsMovementType'
      GoodsMovementType,

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      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,
      _ScheduleLineCategory,
      _ProdAvailabilityCheckRqmtType,
      _ScheduleLineConfStatus,
      SalesDocumentScheduleLine._TransactionCurrency,
      _OrderID,
      _OrderQuantityUnit,
      _BaseUnit,
      _DelivBlockReasonForSchedLine,
      _GoodsMovementType,
      SalesDocumentScheduleLine._TradeCmplncLegalCtrlChkSts
}
where
  SalesDocumentBasic.SDDocumentCategory = 'C';                                  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENTBASIC",
"I_SALESDOCUMENTSCHEDULELINE"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_DELIVERYBLOCKREASON",
"I_GOODSMOVEMENTTYPE",
"I_MFGORDER",
"I_PRODAVAILYCHECKRQMTTYPE",
"I_SALESORDER",
"I_SALESORDERITEM",
"I_SCHEDULELINECATEGORY",
"I_SCHEDULELINECONFSTATUS",
"I_TRADECMPLNCLEGALCTRLCHKSTS",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_SALESDOCUMENTSCHEDULELINE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_SalesOrderScheduleLine view

I_SalesDocumentScheduleLine view