I_SALESDOCUMENTSCHEDULELINE

CDS View

Sales Document Schedule Line

I_SALESDOCUMENTSCHEDULELINE is a CDS View in S/4HANA. Sales Document Schedule Line. It contains 45 fields. 63 CDS views read from this table.

CDS Views using this table (63)

ViewTypeJoinVDMDescription
Atpc_Cds_Vbep view from CDS View on VBEP Table for ATP BOP
C_ESJIMaxDelivCreationDate view from CONSUMPTION Maximum Delivery Creation Date for Sales Order
C_MassChangeSlsOrdItmSchdLn view from CONSUMPTION Mass Change of Sales Order Schedule Line
C_MassChgOrdWthoutChrgSchdLn view from CONSUMPTION Mass Chg of Sls Ord Without Charge SchdLn
C_MassChgSlsSchedgAgrmtSchdLn view from CONSUMPTION Mass Change of Sls Schedg Agrmnt SchdLn
C_MRPSchedulingAgreementCard view_entity inner CONSUMPTION Scheduling Agreement Quick View
C_RFM_MaSaDoSlsOrdSchedLine view from CONSUMPTION Sales Order Schedule Line Details
C_SalesDocumentSchedLineDEX view from CONSUMPTION Data Extraction for Sales Document Schedule Lines
C_SalesDocumentSchedLineDEX_1 view from CONSUMPTION Data Extraction for Sales Document Schedule Lines
C_SlsDocFlfmtSlsDocSchdLn view from CONSUMPTION Sales Doc Fulfillment: Sales Doc Schedule Line
C_SlsDocSchedLineDeliveryBlkd view from CONSUMPTION Sales Doc Schedule Line Delivery Blocked
CIC_SalesDocumentScheduleline view_entity from Proj. on Sls Doc. Schedule Line (Industry Cloud Solutions)
I_AlignSlsOrdAcctAssgdSl view from BASIC Sales Order Schedule line data
I_ARunItmRsnCode view left_outer COMPOSITE Basic View for Reason Code of ARun
I_ARunOvwConfStrgy view left_outer COMPOSITE View for Confirmation Strategy of ARun
I_CustomerReturnScheduleLine view from BASIC Returns Order Schedule Line
I_DigitalVehScheduleLine view_entity from COMPOSITE Schedule line delivery date for SO item
I_ExcessRqmtQtyPerSlsItm view from BASIC Aggregated Quantity Per Sales Item
I_MRPSalesDemand view inner COMPOSITE MRP Sales Demand
I_PPS_PurchaseOrderProcessFlow view_entity inner COMPOSITE PPS Purchase Order Business Process FLow
I_PPS_PurReqnProcessFlow view_entity inner COMPOSITE Interface for PPS Process Flow
I_PPS_SlsOrderProcessFlowNode view_entity from COMPOSITE PPS Sales Order Proc Flow
I_RFM_MaSaDoSlsOrdItmAggrg view from BASIC Aggregated Quantity Per Sales Item
I_RFM_SlsOrdGnrcAggrg view from COMPOSITE Generic Item aggregation
I_SalesOrderScheduleLine view from BASIC Sales Order Schedule Line
I_SalesSchedgAgrmtSchedLine view from BASIC Schedule Line of Sales Scheduling Agreement
I_SlsDocItemConfDeliveryDate view from COMPOSITE Sales Document Item Conf. delivery date
I_SlsDocItemReqdDeliveryDate view from COMPOSITE Sales Document Item Req. delivery date
I_SlsDocItmDelivCreationDate view from COMPOSITE Sales Document Item Deliv. Creation Date
I_SlsDocSchedLineAnalytics view from COMPOSITE Sales Document Schedule Line Analytics
I_SlsOrdFlfmtScheduleLine view from COMPOSITE SOFM Sales Order Scheduleline
I_SlsOrdWthoutChrgSchedLine view from BASIC Schedule Line for Sales Order Without Charge
I_SupDmndAllDocSDItmBsc view from BASIC Basic View for Sales Document
P_ABOP_HRF_Sales view from BASIC
P_ABOPFC_SALES_EXT view from BASIC
P_ABOPFieldCatalog view from BASIC
P_ABOPRlvtSalesRequirement view_entity from COMPOSITE Advncd BOP Run for All Rlvt Sales Docs
P_ABOPSalesDocScheduleLine view from COMPOSITE
P_CustRetItemScheduleLine view_entity from CONSUMPTION Customer Return Item ScheduleLine
P_ForecastDemandSales view inner COMPOSITE
P_IntactvABOPRqmtAddlFields view_entity from COMPOSITE IBOP Requirements Additional Fields View
P_LegallyBindgSlsDocSchedLine view_entity from COMPOSITE
P_MassChgSlsDocSchdLnReadReq view from CONSUMPTION Mass Chg of Sales Doc SchdLn Read Req
P_ProdAllocSalesSchedLine view inner CONSUMPTION Product Allocation Sales Order Schedule Lines
P_ProdAllocSalesStatus view from CONSUMPTION
P_RFDYConfFigsBySalesOrderItem view_entity from CONSUMPTION RFDY Confirmation Figures By Sales Order Item
P_SalesOrderDeliveryBlkd1 view from COMPOSITE
P_SalesOrderItemDeliveryBlkd view from COMPOSITE
P_SalesOrderItemDeliveryBlkd1 view from COMPOSITE
P_SalesOrdersDeliveryDate view from COMPOSITE Delivery Date for Sales Order
P_SchdAgrItmSchdLnCnt view_entity from COMPOSITE Count the Sched.Lns per Sched.Agr.Item
P_SlsDocFlfmtSlsDocItem1 view from CONSUMPTION
P_SlsDocItemDeliveryBlkd1 view from COMPOSITE
P_SlsDocItemPrdtdDelivDelay1 view from CONSUMPTION
P_SlsDocItmSchdLnAnlyts2 view from COMPOSITE
P_SlsDocSchedLineAnlyts view from COMPOSITE
P_SlsOrdConfAnalytics view from COMPOSITE
P_SOTFieldCatalog_Sales view from COMPOSITE
P_SupAssgmtSDItmQty view from COMPOSITE
P_SupDmndAllDocSDDate view from BASIC
P_SupDmndOvwSDDate view from COMPOSITE
R_HUPSchedLineTP view_entity from TRANSACTIONAL Schedule Lines (HUP)
rfm_scc_so_schedule_line_agg view from RFM SO Scheducule Line Aggregation

Fields (45)

KeyField CDS FieldsUsed in Views
KEY mandt mandt 1
KEY SalesDocument ATPRelevantDocument,CustomerReturn,delnr,RequirementDocumentNumber,SalesDocument,SalesOrder,SalesOrderWithoutCharge 20
KEY SalesDocumentItem ATPRelevantDocumentItem,delps,RequirementDocumentItem,SalesDocumentItem,SalesOrderItem,SalesOrderWithoutChargeItem,SalesSchedulingAgreementItem 19
KEY ScheduleLine ATPRelevantDocScheduleLine,delet,ScheduleLine 12
_DelivBlockReasonForSchedLine _DelivBlockReasonForSchedLine,_DeliveryBlockReason 3
_OrderQuantityUnit _OrderQuantityUnit 2
_SalesDocument _SalesDocument 7
_SalesDocumentItem _SalesDocumentItem 2
_TradeCmplncLegalCtrlChkSts _TradeCmplncLegalCtrlChkSts 1
_TransactionCurrency _TransactionCurrency 4
ATPFCFSPriorityValue fcfs_priority 1
BaseUnit BaseUnit 1
ConfdOrderQtyByMatlAvailCheck ConfdOrderQtyByMatlAvailCheck 4
ConfdSchedLineReqdDelivDate ConfdSchedLineReqdDelivDate,RequestedDate,RequestedDeliveryDate 4
ConfirmedDeliveryDate ConfirmedDeliveryDate 3
ConfirmedRqmtQtyInBaseUnit ConfirmedRqmtQtyInBaseUnit 2
CorrectedQtyInOrderQtyUnit CorrectedQtyInOrderQtyUnit 3
DelivBlockReasonForSchedLine DelivBlockReasonForSchedLine,DeliveryBlockReason 7
DeliveredQtyInOrderQtyUnit DeliveredQtyInOrderQtyUnit 2
DeliveredQuantityInBaseUnit DeliveredQuantityInBaseUnit 1
DeliveryDate DeliveryDate,RequestedDeliveryDate 6
GoodsIssueDate GoodsIssueDate,wadat 3
GoodsIssueTime wauhr 1
GoodsMovementType bwart 1
IsConfirmedDelivSchedLine IsConfirmedDelivSchedLine 4
IsRequestedDelivSchedLine IsRequestedDelivSchedLine 4
LoadingDate lddat,LoadingDate 4
LoadingTime lduhr 1
MRPRequiredQuantityInBaseUnit MRPRequiredQuantityInBaseUnit 2
OpenConfdDelivQtyInBaseUnit OpenConfdDelivQtyInBaseUnit 1
OrderID OrderID 4
OrderQuantityUnit OrderQuantityUnit 6
ProductAvailabilityDate ProductAvailabilityDate 6
ProductAvailabilityTime mat_avail_time 1
PurchaseRequisitionItem bnfpo 1
RequestedDeliveryDate RequestedDeliveryDate 4
RequestedDeliveryTime RequestedDeliveryTime 1
RequestedRqmtQtyInBaseUnit open_reqqty,RequestedRqmtQtyInBaseUnit 3
RequirementsClass RequirementsClass 1
ScheduleLineCategory ScheduleLineCategory,sline_category 6
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 5
TradeCmplncLegalCtrlChkSts TradeCmplncLegalCtrlChkSts 1
TransactionCurrency TransactionCurrency 4
TransportationPlanningDate tddat,TransportationPlanningDate 3
TransportationPlanningTime tduhr 1

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 Document Schedule Line
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCUMENTSCHEDULELINE (
    MANDT,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SCHEDULELINE,
    _DELIVBLOCKREASONFORSCHEDLINE,
    _ORDERQUANTITYUNIT,
    _SALESDOCUMENT,
    _SALESDOCUMENTITEM,
    _TRADECMPLNCLEGALCTRLCHKSTS,
    _TRANSACTIONCURRENCY,
    ATPFCFSPRIORITYVALUE,
    BASEUNIT,
    CONFDORDERQTYBYMATLAVAILCHECK,
    CONFDSCHEDLINEREQDDELIVDATE,
    CONFIRMEDDELIVERYDATE,
    CONFIRMEDRQMTQTYINBASEUNIT,
    CORRECTEDQTYINORDERQTYUNIT,
    DELIVBLOCKREASONFORSCHEDLINE,
    DELIVEREDQTYINORDERQTYUNIT,
    DELIVEREDQUANTITYINBASEUNIT,
    DELIVERYDATE,
    GOODSISSUEDATE,
    GOODSISSUETIME,
    GOODSMOVEMENTTYPE,
    ISCONFIRMEDDELIVSCHEDLINE,
    ISREQUESTEDDELIVSCHEDLINE,
    LOADINGDATE,
    LOADINGTIME,
    MRPREQUIREDQUANTITYINBASEUNIT,
    OPENCONFDDELIVQTYINBASEUNIT,
    ORDERID,
    ORDERQUANTITYUNIT,
    PRODUCTAVAILABILITYDATE,
    PRODUCTAVAILABILITYTIME,
    PURCHASEREQUISITIONITEM,
    REQUESTEDDELIVERYDATE,
    REQUESTEDDELIVERYTIME,
    REQUESTEDRQMTQTYINBASEUNIT,
    REQUIREMENTSCLASS,
    SCHEDULELINECATEGORY,
    SCHEDULELINEORDERQUANTITY,
    TRADECMPLNCLEGALCTRLCHKSTS,
    TRANSACTIONCURRENCY,
    TRANSPORTATIONPLANNINGDATE,
    TRANSPORTATIONPLANNINGTIME,
    PRIMARY KEY (MANDT, SALESDOCUMENT, SALESDOCUMENTITEM, SCHEDULELINE)
);