I_SALESDOCUMENTSCHEDULELINE
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA