I_SuplrQtnScheduleLineEnh

DDL: I_SUPLRQTNSCHEDULELINEENH SQL: IMMQTNSCHEDENH Type: view COMPOSITE

Schedule Line Enhanced of a Supplier Quotation Item

I_SuplrQtnScheduleLineEnh is a Composite CDS View that provides data about "Schedule Line Enhanced of a Supplier Quotation Item" in SAP S/4HANA. It reads from 1 data source (I_SuplrQtnScheduleLine) and exposes 14 fields with key fields SupplierQuotation, SupplierQuotationItem, ScheduleLine.

Data Sources (1)

SourceAliasJoin Type
I_SuplrQtnScheduleLine I_SuplrQtnScheduleLine from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Schedule Line Enhanced of a Supplier Quotation Item view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IMMQTNSCHEDENH view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SupplierQuotation I_SuplrQtnScheduleLine SupplierQuotation RFQ
KEY SupplierQuotationItem I_SuplrQtnScheduleLine SupplierQuotationItem Supplier Quotation Item
KEY ScheduleLine I_SuplrQtnScheduleLine ScheduleLine Schedule Line
DelivDateCategory I_SuplrQtnScheduleLine DelivDateCategory Delivery Date
ScheduleLineDeliveryDate I_SuplrQtnScheduleLine ScheduleLineDeliveryDate Delivery Date
SchedLineStscDeliveryDate I_SuplrQtnScheduleLine SchedLineStscDeliveryDate Stat. Del. Date
ScheduleLineDeliveryTime I_SuplrQtnScheduleLine ScheduleLineDeliveryTime Time
ScheduleLineOrderQuantity I_SuplrQtnScheduleLine ScheduleLineOrderQuantity Scheduled Qty
PerformancePeriodStartDate I_SuplrQtnScheduleLine PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate I_SuplrQtnScheduleLine PerformancePeriodEndDate End of Performance Period
RoughGoodsReceiptQty I_SuplrQtnScheduleLine RoughGoodsReceiptQty Delivered
AwardedQuantity I_SuplrQtnScheduleLine AwardedQuantity Awarded Quantity
_SupplierQuotation _SupplierQuotation
_SupplierQuotationItem _SupplierQuotationItem

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_SuplrQtnScheduleLineEnh.
-- 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: IMMQTNSCHEDENH

CREATE VIEW I_SuplrQtnScheduleLineEnh AS
SELECT
  I_SuplrQtnScheduleLine.SupplierQuotation AS SupplierQuotation,
  I_SuplrQtnScheduleLine.SupplierQuotationItem AS SupplierQuotationItem,
  I_SuplrQtnScheduleLine.ScheduleLine AS ScheduleLine,
  I_SuplrQtnScheduleLine.DelivDateCategory AS DelivDateCategory,
  I_SuplrQtnScheduleLine.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  I_SuplrQtnScheduleLine.SchedLineStscDeliveryDate AS SchedLineStscDeliveryDate,
  I_SuplrQtnScheduleLine.ScheduleLineDeliveryTime AS ScheduleLineDeliveryTime,
  I_SuplrQtnScheduleLine.ScheduleLineOrderQuantity AS ScheduleLineOrderQuantity,
  I_SuplrQtnScheduleLine.PerformancePeriodStartDate AS PerformancePeriodStartDate,
  I_SuplrQtnScheduleLine.PerformancePeriodEndDate AS PerformancePeriodEndDate,
  I_SuplrQtnScheduleLine.RoughGoodsReceiptQty AS RoughGoodsReceiptQty,
  I_SuplrQtnScheduleLine.AwardedQuantity AS AwardedQuantity
FROM I_SuplrQtnScheduleLine
;