I_StockTransptOrdScheduleLine

DDL: I_STOCKTRANSPTORDSCHEDULELINE SQL: ISTOSCHLINE Type: view BASIC Package: VDM_MM_PUR_PO_STO
35 Fields 2 Data Sources 2 Associations

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. Part of development package VDM_MM_PUR_PO_STO.

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

NameValueLevelField
AbapCatalog.sqlViewName ISTOSCHLINE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED 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 Purchasing Document
KEY PurchaseOrderItem Purchasing Doc. Item
KEY ScheduleLine ScheduleLine Schedule Line
DelivDateCategory DelivDateCategory Delivery Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
SchedLineStscDeliveryDate SchedLineStscDeliveryDate Stat. Del. Date
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Time
OrderQuantityUnit OrderQuantityUnit Sales Unit
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
RoughGoodsReceiptQty RoughGoodsReceiptQty Delivered
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
SourceOfCreation SourceOfCreation Creation Ind.
NoOfRemindersOfScheduleLine NoOfRemindersOfScheduleLine No. Rem./Exp.
ScheduleLineIsFixed ScheduleLineIsFixed Fixing Ind.
ScheduleLineCommittedQuantity ScheduleLineCommittedQuantity Committed Qty
Reservation Reservation Reservation
ProductAvailabilityDate ProductAvailabilityDate Mat.Avail.Date
MaterialStagingTime MaterialStagingTime Staging Time
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
TransportationPlanningTime TransportationPlanningTime Tr. Plan. Time
LoadingDate LoadingDate Loading Date
LoadingTime LoadingTime Loading Time
GoodsIssueDate GoodsIssueDate Goods Issue Date CCD
GoodsIssueTime GoodsIssueTime GI Time
STOLatestPossibleGRDate STOLatestPossibleGRDate GR End Date
STOLatestPossibleGRTime STOLatestPossibleGRTime GR End Time
StockTransferDeliveredQuantity StockTransferDeliveredQuantity Qty Delivered
ScheduleLineIssuedQuantity ScheduleLineIssuedQuantity Issued
Batch Batch Lot No.
_StockTransportOrderItem _StockTransportOrderItem
_StockTransportOrder _StockTransportOrder
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_DeliveryDateCategory _DeliveryDateCategory

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_StockTransptOrdScheduleLine.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISTOSCHLINE

CREATE VIEW I_StockTransptOrdScheduleLine AS
SELECT
  cast (PurchasingDocument as vdm_stocktransportorder preserving type) AS PurchaseOrder,
  cast (PurchasingDocumentItem as vdm_stocktransportorderitem preserving type) AS PurchaseOrderItem,
  ScheduleLine,
  DelivDateCategory,
  ScheduleLineDeliveryDate,
  SchedLineStscDeliveryDate,
  ScheduleLineDeliveryTime,
  OrderQuantityUnit,
  ScheduleLineOrderQuantity,
  RoughGoodsReceiptQty,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SourceOfCreation,
  NoOfRemindersOfScheduleLine,
  ScheduleLineIsFixed,
  ScheduleLineCommittedQuantity,
  Reservation,
  ProductAvailabilityDate,
  MaterialStagingTime,
  TransportationPlanningDate,
  TransportationPlanningTime,
  LoadingDate,
  LoadingTime,
  GoodsIssueDate,
  GoodsIssueTime,
  STOLatestPossibleGRDate,
  STOLatestPossibleGRTime,
  StockTransferDeliveredQuantity,
  ScheduleLineIssuedQuantity,
  Batch
FROM I_PurgDocScheduleLineBasic
INNER JOIN I_StockTransportOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StockTransportOrder AS _StockTransportOrder ON PurchaseOrder = _StockTransportOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_StockTransportOrderItem AS _StockTransportOrderItem ON PurchaseOrder = _StockTransportOrderItem.PurchaseOrder AND PurchaseOrderItem = _StockTransportOrderItem.PurchaseOrderItem  -- association [1..1]
;

Learn More