I_STOCKTRANSPTORDSCHEDULELINE

CDS View

CDS View for STO Schedule Line

I_STOCKTRANSPTORDSCHEDULELINE is a CDS View in S/4HANA. CDS View for STO Schedule Line. It contains 5 fields. 13 CDS views read from this table.

Used by 13 CDS view(s) 5 fields

CDS Views using this table (13)

ViewTypeJoinVDMDescription
I_ExcessRqmtQtyPerSTOItm view from BASIC Aggregated Quantity Per Stock Transport Order Item
P_ABOP_HRF_STO view from BASIC
P_ABOPFC_STO_EXT view from BASIC
P_ABOPFieldCatalogSTO view from BASIC
P_ABOPRlvtStkTransptRqmt view_entity from COMPOSITE Advncd BOP Run All Rlvt Stk Transpt Docs
P_ABOPStaticWhereConditionSTO view from COMPOSITE
P_IntactvABOPRqmtAddlFields view_entity union COMPOSITE IBOP Requirements Additional Fields View
P_ReqdAllocStkTransptSchedLine view_entity inner COMPOSITE Requested Allocation Stock Transport Order Schedule Lines
P_SOTFieldCatalog_STO view from COMPOSITE
P_StkTransptFilteredSchedLine view from CONSUMPTION
P_STOItmSchdlnAnlyts view from COMPOSITE
P_SupAssgmtSTOItmQty view from COMPOSITE
rfm_scc_sto_schedule_line_agg view from RFM STO Scheducule Line Aggregation

Fields (5)

KeyField CDS FieldsUsed in Views
KEY PurchaseOrder ATPRelevantDocument,ProdAllocAssignedOrder 2
KEY ScheduleLine ATPRelevantDocScheduleLine 1
KEY ScheduleLineDeliveryDate RequestedDeliveryDate,ScheduleLineDeliveryDate 2
KEY ScheduleLineDeliveryTime ScheduleLineDeliveryTime 1
OrderQuantityUnit BaseUnit 1 
@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,
  ATPFCFSPriorityValue,
  
  @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
  _StockTransportOrderItem,
  
   @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
  _StockTransportOrder,
  
  _PurchaseRequisition,
  _PurchaseRequisitionItem,
  _DeliveryDateCategory

}

where _StockTransportOrder.SupplyingPlant <> ''

Learn More