R_STOScheduleLine

DDL: R_STOSCHEDULELINE Type: view_entity BASIC Package: VDM_MM_STO
32 Fields 2 Data Sources

Schedule Line for Stock Transport Order

R_STOScheduleLine is a Basic CDS View that provides data about "Schedule Line for Stock Transport Order" in SAP S/4HANA. It reads from 2 data sources (R_PurchasingDocScheduleLine, R_StockTransportOrderItem) and exposes 32 fields with key fields StockTransportOrder, StockTransportOrderItem, ScheduleLine. Part of development package VDM_MM_STO.

Data Sources (2)

SourceAliasJoin Type
R_PurchasingDocScheduleLine R_PurchasingDocScheduleLine from
R_StockTransportOrderItem R_StockTransportOrderItem inner

Annotations (9)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey ScheduleLine view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Schedule Line for Stock Transport Order view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder
KEY StockTransportOrderItem
KEY ScheduleLine R_PurchasingDocScheduleLine ScheduleLine Schedule Line
DelivDateCategory R_PurchasingDocScheduleLine DelivDateCategory Delivery Date
ScheduleLineDeliveryDate R_PurchasingDocScheduleLine ScheduleLineDeliveryDate Delivery Date
ScheduleLineDeliveryTime R_PurchasingDocScheduleLine ScheduleLineDeliveryTime Time
OrderQuantityUnit R_StockTransportOrderItem OrderQuantityUnit Sales Unit
ScheduleLineOrderQuantity R_PurchasingDocScheduleLine ScheduleLineOrderQuantity Scheduled Qty
RoughGoodsReceiptQty R_PurchasingDocScheduleLine RoughGoodsReceiptQty Delivered
PurchaseRequisition R_PurchasingDocScheduleLine PurchaseRequisition Requisition
PurchaseRequisitionItem R_PurchasingDocScheduleLine PurchaseRequisitionItem Requisn. item
ScheduleLineIsFixed R_PurchasingDocScheduleLine ScheduleLineIsFixed Fixing Ind.
ScheduleLineCommittedQuantity R_PurchasingDocScheduleLine ScheduleLineCommittedQuantity Committed Qty
TransportationPlanningDate R_PurchasingDocScheduleLine TransportationPlanningDate TranspPlngDate
TransportationPlanningTime R_PurchasingDocScheduleLine TransportationPlanningTime Tr. Plan. Time
LoadingDate R_PurchasingDocScheduleLine LoadingDate Loading Date
LoadingTime R_PurchasingDocScheduleLine LoadingTime Loading Time
GoodsIssueDate R_PurchasingDocScheduleLine GoodsIssueDate Goods Issue Date CCD
GoodsIssueTime R_PurchasingDocScheduleLine GoodsIssueTime GI Time
STOLatestPossibleGRDate R_PurchasingDocScheduleLine STOLatestPossibleGRDate GR End Date
STOLatestPossibleGRTime R_PurchasingDocScheduleLine STOLatestPossibleGRTime GR End Time
StockTransferDeliveredQuantity R_PurchasingDocScheduleLine StockTransferDeliveredQuantity Qty Delivered
StockTransportOrderType R_StockTransportOrderItem StockTransportOrderType Document Type
PurchasingOrganization R_StockTransportOrderItem PurchasingOrganization Purchasing Organization
PurchasingGroup R_StockTransportOrderItem PurchasingGroup Purchasing Group
Plant R_StockTransportOrderItem Plant Valuation Area
_StockTransportOrder _StockTransportOrder
_StockTransportOrderItem _StockTransportOrderItem
_OrderQuantityUnit _OrderQuantityUnit
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_OrderQuantityUnitText _OrderQuantityUnitText

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 R_STOScheduleLine.
-- 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.

CREATE VIEW R_STOScheduleLine AS
SELECT
  cast (R_PurchasingDocScheduleLine.PurchasingDocument as vdm_stocktransportorder preserving type ) AS StockTransportOrder,
  cast (R_PurchasingDocScheduleLine.PurchasingDocumentItem as vdm_stocktransportorderitem preserving type ) AS StockTransportOrderItem,
  R_PurchasingDocScheduleLine.ScheduleLine AS ScheduleLine,
  R_PurchasingDocScheduleLine.DelivDateCategory AS DelivDateCategory,
  R_PurchasingDocScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  R_PurchasingDocScheduleLine.ScheduleLineDeliveryTime AS ScheduleLineDeliveryTime,
  R_StockTransportOrderItem.OrderQuantityUnit AS OrderQuantityUnit,
  R_PurchasingDocScheduleLine.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  R_PurchasingDocScheduleLine.RoughGoodsReceiptQty AS RoughGoodsReceiptQty,
  R_PurchasingDocScheduleLine.PurchaseRequisition AS PurchaseRequisition,
  R_PurchasingDocScheduleLine.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  R_PurchasingDocScheduleLine.ScheduleLineIsFixed AS ScheduleLineIsFixed,
  R_PurchasingDocScheduleLine.ScheduleLineCommittedQuantity AS ScheduleLineCommittedQuantity,
  R_PurchasingDocScheduleLine.TransportationPlanningDate AS TransportationPlanningDate,
  R_PurchasingDocScheduleLine.TransportationPlanningTime AS TransportationPlanningTime,
  R_PurchasingDocScheduleLine.LoadingDate AS LoadingDate,
  R_PurchasingDocScheduleLine.LoadingTime AS LoadingTime,
  R_PurchasingDocScheduleLine.GoodsIssueDate AS GoodsIssueDate,
  R_PurchasingDocScheduleLine.GoodsIssueTime AS GoodsIssueTime,
  R_PurchasingDocScheduleLine.STOLatestPossibleGRDate AS STOLatestPossibleGRDate,
  R_PurchasingDocScheduleLine.STOLatestPossibleGRTime AS STOLatestPossibleGRTime,
  R_PurchasingDocScheduleLine.StockTransferDeliveredQuantity AS StockTransferDeliveredQuantity,
  R_StockTransportOrderItem.StockTransportOrderType AS StockTransportOrderType,
  R_StockTransportOrderItem.PurchasingOrganization AS PurchasingOrganization,
  R_StockTransportOrderItem.PurchasingGroup AS PurchasingGroup,
  R_StockTransportOrderItem.Plant AS Plant
FROM R_PurchasingDocScheduleLine
INNER JOIN R_StockTransportOrderItem ON /* join condition not captured in parsed metadata */
;

Learn More