I_StockTransptOrdScheduleLine

DDL: I_STOCKTRANSPTORDSCHEDULELINE SQL: ISTOSCHLINE Type: view BASIC

CDS View for STO Schedule Line

I_StockTransptOrdScheduleLine is a Basic CDS View that provides data about "CDS View for STO Schedule Line" in SAP S/4HANA. It reads from 2 data sources (I_PurgDocScheduleLineBasic, I_StockTransportOrder) and exposes 35 fields with key fields PurchaseOrder, PurchaseOrderItem, ScheduleLine. It has 2 associations to related views.

2 data source(s) 35 fields

Data Sources (2)

SourceAliasJoin Type
I_PurgDocScheduleLineBasic I_PurgDocScheduleLineBasic from
I_StockTransportOrder I_StockTransportOrder inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_StockTransportOrder _StockTransportOrder $projection.PurchaseOrder = _StockTransportOrder.PurchaseOrder
[1..1] I_StockTransportOrderItem _StockTransportOrderItem $projection.PurchaseOrder = _StockTransportOrderItem.PurchaseOrder and $projection.PurchaseOrderItem = _StockTransportOrderItem.PurchaseOrderItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISTOSCHLINE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View for STO Schedule Line view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey ScheduleLine view
Metadata.ignorePropagatedAnnotations true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder
KEY PurchaseOrderItem
KEY ScheduleLine ScheduleLine
DelivDateCategory DelivDateCategory
ScheduleLineDeliveryDate ScheduleLineDeliveryDate
SchedLineStscDeliveryDate SchedLineStscDeliveryDate
ScheduleLineDeliveryTime ScheduleLineDeliveryTime
OrderQuantityUnit OrderQuantityUnit
ScheduleLineOrderQuantity ScheduleLineOrderQuantity
RoughGoodsReceiptQty RoughGoodsReceiptQty
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
SourceOfCreation SourceOfCreation
NoOfRemindersOfScheduleLine NoOfRemindersOfScheduleLine
ScheduleLineIsFixed ScheduleLineIsFixed
ScheduleLineCommittedQuantity ScheduleLineCommittedQuantity
Reservation Reservation
ProductAvailabilityDate ProductAvailabilityDate
MaterialStagingTime MaterialStagingTime
TransportationPlanningDate TransportationPlanningDate
TransportationPlanningTime TransportationPlanningTime
LoadingDate LoadingDate
LoadingTime LoadingTime
GoodsIssueDate GoodsIssueDate
GoodsIssueTime GoodsIssueTime
STOLatestPossibleGRDate STOLatestPossibleGRDate
STOLatestPossibleGRTime STOLatestPossibleGRTime
StockTransferDeliveredQuantity StockTransferDeliveredQuantity
ScheduleLineIssuedQuantity ScheduleLineIssuedQuantity
Batch Batch
_StockTransportOrderItem _StockTransportOrderItem
_StockTransportOrder _StockTransportOrder
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_DeliveryDateCategory _DeliveryDateCategory 
@AbapCatalog.sqlViewName: 'ISTOSCHLINE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View for STO Schedule Line'
@VDM.viewType : #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.representativeKey: 'ScheduleLine'
@Metadata.ignorePropagatedAnnotations:true

define view I_StockTransptOrdScheduleLine as select from I_PurgDocScheduleLineBasic
 inner join   I_StockTransportOrder on I_PurgDocScheduleLineBasic.PurchasingDocument = I_StockTransportOrder.PurchaseOrder

  association [1..1] to I_StockTransportOrder as _StockTransportOrder on  $projection.PurchaseOrder = _StockTransportOrder.PurchaseOrder
  association [1..1] to I_StockTransportOrderItem as _StockTransportOrderItem on  $projection.PurchaseOrder = _StockTransportOrderItem.PurchaseOrder
                                                and $projection.PurchaseOrderItem = _StockTransportOrderItem.PurchaseOrderItem
{
  @ObjectModel.foreignKey.association: '_StockTransportOrder'
  key cast (PurchasingDocument as vdm_stocktransportorder preserving type) as PurchaseOrder,
  
  @ObjectModel.foreignKey.association: '_StockTransportOrderItem'
  key cast (PurchasingDocumentItem as vdm_stocktransportorderitem preserving type) as PurchaseOrderItem,
  key ScheduleLine,
  //@ObjectModel: { foreignKey.association: '_DeliveryDateCategory'}

  DelivDateCategory,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  ScheduleLineDeliveryTime,
  @Semantics.unitOfMeasure: true
  OrderQuantityUnit,
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'   
  ScheduleLineOrderQuantity,
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit' 
  RoughGoodsReceiptQty,
  @ObjectModel.foreignKey.association: '_PurchaseRequisition'
  PurchaseRequisition,
  @ObjectModel.foreignKey.association: '_PurchaseRequisitionItem'
  PurchaseRequisitionItem,
  SourceOfCreation,
  NoOfRemindersOfScheduleLine,
  ScheduleLineIsFixed,
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'  
  ScheduleLineCommittedQuantity,
  Reservation,  
  ProductAvailabilityDate,
  MaterialStagingTime,
  TransportationPlanningDate,
  TransportationPlanningTime,
  LoadingDate,
  LoadingTime,
  GoodsIssueDate,
  GoodsIssueTime,
  STOLatestPossibleGRDate,
  STOLatestPossibleGRTime,
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'  
  StockTransferDeliveredQuantity,
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'  
  ScheduleLineIssuedQuantity,
  Batch,
  
  @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
  _StockTransportOrderItem,
  
   @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
  _StockTransportOrder,
  
  _PurchaseRequisition,
  _PurchaseRequisitionItem,
  _DeliveryDateCategory

}

where _StockTransportOrder.SupplyingPlant <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURGDOCSCHEDULELINEBASIC",
"I_STOCKTRANSPORTORDER"
],
"ASSOCIATED":
[
"I_DELIVERYDATECATEGORY",
"I_PURCHASEREQUISITION",
"I_PURCHASEREQUISITIONITEM",
"I_STOCKTRANSPORTORDER",
"I_STOCKTRANSPORTORDERITEM"
],
"BASE":
[
"I_PURGDOCSCHEDULELINEBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More