R_STOScheduleLineTP

DDL: R_STOSCHEDULELINETP Type: view_entity TRANSACTIONAL Package: RAP_MM_STO
33 Fields 1 Data Sources 1 Associations

Schedule Line for STO - TP

R_STOScheduleLineTP is a Transactional CDS View that provides data about "Schedule Line for STO - TP" in SAP S/4HANA. It reads from 1 data source (R_STOScheduleLine) and exposes 33 fields with key fields StockTransportOrder, StockTransportOrderItem, ScheduleLine. It has 1 association to related views. Part of development package RAP_MM_STO.

Data Sources (1)

SourceAliasJoin Type
R_STOScheduleLine R_STOScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_STOSubcontractingComponentTP _STOSubcontractingComponent

Annotations (9)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C 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 STO - TP view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY StockTransportOrder StockTransportOrder STO Number
KEY StockTransportOrderItem StockTransportOrderItem STO Item
KEY ScheduleLine ScheduleLine Schedule Line
DelivDateCategory DelivDateCategory Delivery Date
ScheduleLineDeliveryDate ScheduleLineDeliveryDate Delivery Date
ScheduleLineDeliveryTime ScheduleLineDeliveryTime Time
OrderQuantityUnit OrderQuantityUnit Sales Unit
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
RoughGoodsReceiptQty RoughGoodsReceiptQty Delivered
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
ScheduleLineIsFixed ScheduleLineIsFixed Fixing Ind.
ScheduleLineCommittedQuantity ScheduleLineCommittedQuantity Committed Qty
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
StockTransportOrderType StockTransportOrderType Document Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area
_OrderQuantityUnit _OrderQuantityUnit
_PurchaseRequisition _PurchaseRequisition
_PurchaseRequisitionItem _PurchaseRequisitionItem
_StockTransportOrder _StockTransportOrder
_StockTransportOrderItem _StockTransportOrderItem
_STOSubcontractingComponent _STOSubcontractingComponent
_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_STOScheduleLineTP.
-- 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_STOScheduleLineTP AS
SELECT
  StockTransportOrder,
  StockTransportOrderItem,
  ScheduleLine,
  DelivDateCategory,
  ScheduleLineDeliveryDate,
  ScheduleLineDeliveryTime,
  OrderQuantityUnit,
  ScheduleLineOrderQuantity,
  RoughGoodsReceiptQty,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  ScheduleLineIsFixed,
  ScheduleLineCommittedQuantity,
  TransportationPlanningDate,
  TransportationPlanningTime,
  LoadingDate,
  LoadingTime,
  GoodsIssueDate,
  GoodsIssueTime,
  STOLatestPossibleGRDate,
  STOLatestPossibleGRTime,
  StockTransferDeliveredQuantity,
  StockTransportOrderType,
  PurchasingOrganization,
  PurchasingGroup,
  Plant
FROM R_STOScheduleLine
LEFT OUTER JOIN R_STOSubcontractingComponentTP AS _STOSubcontractingComponent ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More