I_SALESORDERSCHEDULELINE

CDS View
22 Fields 8 CDS Views

Sales Order Schedule Line

I_SALESORDERSCHEDULELINE is a CDS View in S/4HANA. Sales Order Schedule Line. It contains 22 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
A_SalesOrderScheduleLine view from COMPOSITE Item Schedule Line
A_SalesOrderScheduleLineSimln view from COMPOSITE Sales Order Schedule Line Sim (API)
C_ESJISOScheduleLineDelivDate view from CONSUMPTION Requested Delivery Date from I_SalesOrderScheduleLine
C_SalesOrderScheduleLine view from CONSUMPTION
C_SlsOrdSchdLnWthCalInfoDEX view from CONSUMPTION Data Extraction for Sales Order Sched Line
I_MRPSalesOrder view from COMPOSITE MRP Sales Order
P_BusSolnOrdSlsOrdFlwLvl11 view inner CONSUMPTION Solution Order Sales Order Flow Level 11
R_SalesOrderScheduleLineTP view_entity from TRANSACTIONAL Schedule Line for Sales Order Item - TP

Fields (22)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition SubsequentDocument 1
KEY PurchasingDocumentCategory SubsequentDocumentCategory 1
KEY SalesOrder SalesOrder 3
KEY SalesOrderItem SalesOrderItem 3
KEY ScheduleLine ScheduleLine,ScheduleLineForEdit 2
_DelivBlockReasonForSchedLine _DelivBlockReasonForSchedLine 1
_GoodsMovementType _GoodsMovementType 1
_OrderQuantityUnit _OrderQuantityUnit 1
_ScheduleLineCategory _ScheduleLineCategory 1
BaseUnit BaseUnit 1
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck 2
ConfirmedDeliveryDate ConfirmedDeliveryDate 2
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine 1
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit 1
GoodsMovementType GoodsMovementType 1
IsConfirmedDelivSchedLine IsConfirmedDelivSchedLine 1
IsRequestedDelivSchedLine IsRequestedDelivSchedLine 1
OpenConfdDelivQtyInOrdQtyUnit OpenConfdDelivQtyInOrdQtyUnit 1
OrderQuantityUnit OrderQuantityUnit 2
RequestedDeliveryDate RequestedDeliveryDate 1
ScheduleLineCategory ScheduleLineCategory 1
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Order Schedule Line
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESORDERSCHEDULELINE (
    PURCHASEREQUISITION,
    PURCHASINGDOCUMENTCATEGORY,
    SALESORDER,
    SALESORDERITEM,
    SCHEDULELINE,
    _DELIVBLOCKREASONFORSCHEDLINE,
    _GOODSMOVEMENTTYPE,
    _ORDERQUANTITYUNIT,
    _SCHEDULELINECATEGORY,
    BASEUNIT,
    CONFDORDERQTYBYMATLAVAILCHECK,
    CONFIRMEDDELIVERYDATE,
    DELIVBLOCKREASONFORSCHEDLINE,
    DELIVEREDQTYINORDERQTYUNIT,
    GOODSMOVEMENTTYPE,
    ISCONFIRMEDDELIVSCHEDLINE,
    ISREQUESTEDDELIVSCHEDLINE,
    OPENCONFDDELIVQTYINORDQTYUNIT,
    ORDERQUANTITYUNIT,
    REQUESTEDDELIVERYDATE,
    SCHEDULELINECATEGORY,
    SCHEDULELINEORDERQUANTITY,
    PRIMARY KEY (PURCHASEREQUISITION, PURCHASINGDOCUMENTCATEGORY, SALESORDER, SALESORDERITEM, SCHEDULELINE)
);

Learn More