I_CustomerReturnScheduleLine

DDL: I_CUSTOMERRETURNSCHEDULELINE SQL: ISDCUSTRETSCHDLN Type: view BASIC
44 Fields 1 Data Sources 2 Associations

Returns Order Schedule Line

I_CustomerReturnScheduleLine is a Basic CDS View (Dimension) that provides data about "Returns Order Schedule Line" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 44 fields with key fields CustomerReturn, CustomerReturnItem, ScheduleLine. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentScheduleLine SalesDocumentScheduleLine from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CustomerReturn _CustomerReturn $projection.CustomerReturn = _CustomerReturn.CustomerReturn
[1..1] I_CustomerReturnItem _CustomerReturnItem $projection.CustomerReturn = _CustomerReturnItem.CustomerReturn and $projection.CustomerReturnItem = _CustomerReturnItem.CustomerReturnItem

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ScheduleLine view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Returns Order Schedule Line view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDCUSTRETSCHDLN view
Metadata.allowExtensions true view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_SalesDocumentScheduleLine SalesDocument SD Document
KEY CustomerReturnItem SalesDocumentItem Sales Document Item
KEY ScheduleLine ScheduleLine Schedule Line
ScheduleLineCategory ScheduleLineCategory Sched.Line Cat.
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderToBaseQuantityDnmntr OrderToBaseQuantityDnmntr Denominator
OrderToBaseQuantityNmrtr OrderToBaseQuantityNmrtr Numerator
BaseUnit BaseUnit Unit of Measure
RequestedDeliveryDate I_SalesDocumentScheduleLine RequestedDeliveryDate Requested Delivery Date
RequestedDeliveryTime RequestedDeliveryTime
ScheduleLineOrderQuantity ScheduleLineOrderQuantity Scheduled Qty
CorrectedQtyInOrderQtyUnit CorrectedQtyInOrderQtyUnit Corr.qty
ConfirmedDeliveryDate ConfirmedDeliveryDate Confirmed Delivery Date
ConfirmedDeliveryTime ConfirmedDeliveryTime
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck Quantity
ConfdSchedLineReqdDelivDate ConfdSchedLineReqdDelivDate Delivery Date
ScheduleLineConfirmationStatus ScheduleLineConfirmationStatus Goods Receipt
OrderID I_SalesDocumentScheduleLine OrderID Order ID
DeliveryCreationDate DeliveryCreationDate Delivery Date
TransportationPlanningDate TransportationPlanningDate TranspPlngDate
TransportationPlanningTime TransportationPlanningTime Tr. Plan. Time
LoadingDate LoadingDate Loading Date
LoadingTime LoadingTime Loading Time
ItemIsDeliveryRelevant ItemIsDeliveryRelevant Item rel.f.dlv.
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine Delivery Block
OpenReqdDelivQtyInOrdQtyUnit OpenReqdDelivQtyInOrdQtyUnit Open Quantity
OpenReqdDelivQtyInBaseUnit OpenReqdDelivQtyInBaseUnit Open Quantity
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit Open Quantity
OpenConfdDelivQtyInBaseUnit OpenConfdDelivQtyInBaseUnit Open Quantity
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit Delivered Qty
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit Delivered Qty
GoodsMovementType GoodsMovementType Movement Type
OpenDeliveryNetAmount OpenDeliveryNetAmount Open Delivery Amount
TransactionCurrency I_SalesDocumentScheduleLine TransactionCurrency Transaction Currency
_CustomerReturn _CustomerReturn
_CustomerReturnItem _CustomerReturnItem
_ScheduleLineCategory _ScheduleLineCategory
_ScheduleLineConfStatus _ScheduleLineConfStatus
_TransactionCurrency I_SalesDocumentScheduleLine _TransactionCurrency
_OrderID _OrderID
_OrderQuantityUnit _OrderQuantityUnit
_BaseUnit _BaseUnit
_DelivBlockReasonForSchedLine _DelivBlockReasonForSchedLine
_GoodsMovementType _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 I_CustomerReturnScheduleLine.
-- 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: ISDCUSTRETSCHDLN

CREATE VIEW I_CustomerReturnScheduleLine AS
SELECT
  SalesDocumentScheduleLine.SalesDocument AS CustomerReturn,
  SalesDocumentItem AS CustomerReturnItem,
  ScheduleLine,
  ScheduleLineCategory,
  OrderQuantityUnit,
  OrderToBaseQuantityDnmntr,
  OrderToBaseQuantityNmrtr,
  BaseUnit,
  SalesDocumentScheduleLine.RequestedDeliveryDate AS RequestedDeliveryDate,
  RequestedDeliveryTime,
  ScheduleLineOrderQuantity,
  CorrectedQtyInOrderQtyUnit,
  ConfirmedDeliveryDate,
  ConfirmedDeliveryTime,
  ConfdOrderQtyByMatlAvailCheck,
  ConfdSchedLineReqdDelivDate,
  ScheduleLineConfirmationStatus,
  SalesDocumentScheduleLine.OrderID AS OrderID,
  DeliveryCreationDate,
  TransportationPlanningDate,
  TransportationPlanningTime,
  LoadingDate,
  LoadingTime,
  ItemIsDeliveryRelevant,
  DelivBlockReasonForSchedLine,
  OpenReqdDelivQtyInOrdQtyUnit,
  OpenReqdDelivQtyInBaseUnit,
  OpenConfdDelivQtyInOrdQtyUnit,
  OpenConfdDelivQtyInBaseUnit,
  DeliveredQtyInOrderQtyUnit,
  DeliveredQuantityInBaseUnit,
  GoodsMovementType,
  OpenDeliveryNetAmount,
  SalesDocumentScheduleLine.TransactionCurrency AS TransactionCurrency,
  SalesDocumentScheduleLine._TransactionCurrency AS _TransactionCurrency
FROM I_SalesDocumentScheduleLine AS SalesDocumentScheduleLine
LEFT OUTER JOIN I_CustomerReturn AS _CustomerReturn ON CustomerReturn = _CustomerReturn.CustomerReturn  -- association [1..1]
LEFT OUTER JOIN I_CustomerReturnItem AS _CustomerReturnItem ON CustomerReturn = _CustomerReturnItem.CustomerReturn AND CustomerReturnItem = _CustomerReturnItem.CustomerReturnItem  -- association [1..1]
;

Learn More