R_SalesOrderScheduleLineTP

DDL: R_SALESORDERSCHEDULELINETP Type: view_entity TRANSACTIONAL
29 Fields 1 Data Sources 1 Associations

Schedule Line for Sales Order Item - TP

R_SalesOrderScheduleLineTP is a Transactional CDS View that provides data about "Schedule Line for Sales Order Item - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderScheduleLine) and exposes 29 fields with key fields SalesOrder, SalesOrderItem, ScheduleLine. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderScheduleLine SalesOrderScheduleLine from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SalesOrderTP _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder

Annotations (8)

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 #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Schedule Line for Sales Order Item - TP view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder I_SalesOrderScheduleLine SalesOrder SD Document
KEY SalesOrderItem I_SalesOrderScheduleLine SalesOrderItem Sales Order Item
KEY ScheduleLine I_SalesOrderScheduleLine ScheduleLine Schedule Line
ScheduleLineForEdit I_SalesOrderScheduleLine ScheduleLine Schedule Line
ScheduleLineCategory I_SalesOrderScheduleLine ScheduleLineCategory Sched.Line Cat.
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantitySAPUnit
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit
CorrectedQtyInOrderQtyUnit CorrectedQtyInOrderQtyUnit
DeliveryDate DeliveryDate Delivery Date
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
ConfirmedDeliveryDate ConfirmedDeliveryDate Confirmed Delivery Date
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine Delivery Block
PurchaseRequisition PurchaseRequisition Requisition
PurchaseRequisitionItem PurchaseRequisitionItem Requisn. item
GoodsMovementType I_SalesOrderScheduleLine GoodsMovementType Movement Type
_Item _Item
_SalesOrder _SalesOrder
SalesOrderType _SalesOrder SalesOrderType Sales Order Type
OrganizationDivision _SalesOrder OrganizationDivision Org. Division
SalesOrganization _SalesOrder SalesOrganization Sales Organization
DistributionChannel _SalesOrder DistributionChannel RefDistCh-Cust/Mat.
_OrderQuantityUnit I_SalesOrderScheduleLine _OrderQuantityUnit
_DelivBlockReasonForSchedLine I_SalesOrderScheduleLine _DelivBlockReasonForSchedLine
_ScheduleLineCategory I_SalesOrderScheduleLine _ScheduleLineCategory
_GoodsMovementType I_SalesOrderScheduleLine _GoodsMovementType

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_SalesOrderScheduleLineTP.
-- 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_SalesOrderScheduleLineTP AS
SELECT
  SalesOrderScheduleLine.SalesOrder AS SalesOrder,
  SalesOrderScheduleLine.SalesOrderItem AS SalesOrderItem,
  SalesOrderScheduleLine.ScheduleLine AS ScheduleLine,
  SalesOrderScheduleLine.ScheduleLine AS ScheduleLineForEdit,
  SalesOrderScheduleLine.ScheduleLineCategory AS ScheduleLineCategory,
  OrderQuantityUnit,
  cast(_OrderQuantityUnit.UnitOfMeasureSAPCode as sd_ord_qty_sapunit preserving type) AS OrderQuantitySAPUnit,
  ScheduleLineOrderQuantity,
  ConfdOrderQtyByMatlAvailCheck,
  DeliveredQtyInOrderQtyUnit,
  OpenConfdDelivQtyInOrdQtyUnit,
  CorrectedQtyInOrderQtyUnit,
  DeliveryDate,
  RequestedDeliveryDate,
  ConfirmedDeliveryDate,
  DelivBlockReasonForSchedLine,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SalesOrderScheduleLine.GoodsMovementType AS GoodsMovementType,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  SalesOrderScheduleLine._OrderQuantityUnit AS _OrderQuantityUnit,
  SalesOrderScheduleLine._DelivBlockReasonForSchedLine AS _DelivBlockReasonForSchedLine,
  SalesOrderScheduleLine._ScheduleLineCategory AS _ScheduleLineCategory,
  SalesOrderScheduleLine._GoodsMovementType AS _GoodsMovementType
FROM I_SalesOrderScheduleLine AS SalesOrderScheduleLine
LEFT OUTER JOIN R_SalesOrderTP AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
;

Learn More