I_PURGDOCSCHEDULELINE
Purchasing Document Schedule Line
I_PURGDOCSCHEDULELINE is a CDS View in S/4HANA. Purchasing Document Schedule Line. It contains 42 fields. 47 CDS views read from this table.
CDS Views using this table (47)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_PurchaseOrderScheduleLine | view | from | COMPOSITE | Schedule Lines |
| C_ArbErp_ConfIn_ScheduleLine | view | from | CONSUMPTION | CDS View of purchase order schedule lines for ORDR OUT |
| C_Arberp_Ordrout_Scheduleline | view | from | CONSUMPTION | CDS View of purchase order schedule lines for ORDR OUT |
| C_MRPScheduleAgreement | view_entity | from | CONSUMPTION | MRP Schedule Agreement |
| C_POItmOpnQty | view_entity | from | CONSUMPTION | Purchase Order Item Open Quantity |
| C_PurgDocSchedulelineObj | view | from | CONSUMPTION | Purchasing Document Schedule Lines For Object Page |
| 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_CFinPurgDocScheduleLine | view | union_all | COMPOSITE | CFin Purchasing Document: Schedule Line |
| I_DigitalVehiclePurOrderItem | view_entity | inner | COMPOSITE | Vehicle Purchase Order |
| I_FldLogsPurOrdOpenQty | view | from | COMPOSITE | Purchase order open quantity |
| I_MRPPurchaseOrder | view | left_outer | COMPOSITE | MRP Purchase Order |
| I_MRPTransferDemand | view_entity | inner | COMPOSITE | Transfer Demand |
| I_ProjProcmtPurOrdSchedLines | view | from | COMPOSITE | Based on the scheduline lines calculate delivery date |
| I_PurchaseOrderScheduleLine | view | from | BASIC | Purchase Order Schedule Line |
| I_Schedgagrmtlinestranfields | view | from | COMPOSITE | Scheduling agreement Transient fields |
| I_Schedgline | view | from | BASIC | Schedule Agreement Schedule Lines |
| I_Scheduleline_Cumscheqty | view | from | BASIC | Cumulative Scheduled Quantity for Item |
| I_Scheduleline_Cumscheqty | view | inner | BASIC | Cumulative Scheduled Quantity for Item |
| P_AnaEketSdmMiration | view | inner | COMPOSITE | Pur Docs not migrated to MMPUR_ANA_EKET |
| P_AnaEketSdmMiration1 | view | inner | COMPOSITE | Pur Docs not migrated to MMPUR_ANA_EKET |
| P_DDOrderDetails | view | left_outer | CONSUMPTION | |
| P_DDPurchaseOrder | view | left_outer | COMPOSITE | |
| P_POItemSched | view | from | CONSUMPTION | PO Item Open Schedule Line Calculation |
| P_POItemSchedLnDelivDat | view | from | CONSUMPTION | Next Delivery Date Calculation |
| P_PurchaseOrderItemAddFields | view | inner | COMPOSITE | Purchase Order Item Additional Fields |
| P_PurchaseOrderScheduleLine1 | view | from | CONSUMPTION | |
| P_Purgdocscheduleline | view | from | CONSUMPTION | Purchasing Document Schedule Lines |
| P_PurgDocSchedulelineCuml | view | from | CONSUMPTION | |
| P_PurgDocSchedulelineCuml | view | inner | CONSUMPTION | |
| P_PurgOrdSchKeyDate | view | from | CONSUMPTION | View for Delivery Date and Quantity |
| P_PurOrditemDeliveryDate | view | from | COMPOSITE | |
| P_PurOrdLtstSchedLine | view | inner | CONSUMPTION | |
| P_PurOrdSglSchedLineHelperVw1 | view | from | CONSUMPTION | Purchase Order minimum schedule date |
| P_PurOrdSglSchedLineHelperVw2 | view | inner | CONSUMPTION | Purchase Order minimum schedule time |
| P_PurOrdSglSchedLineHelperVw3 | view | inner | CONSUMPTION | Purchase Order minimum schedule line |
| P_PurOrdSingleScheduleLine | view | inner | COMPOSITE | |
| P_PurOrdSingleScheduleLineHlp1 | view | from | COMPOSITE | |
| P_PurOrdSingleScheduleLineHlp2 | view | inner | COMPOSITE | |
| P_PurOrdSingleScheduleLineHlp3 | view | inner | COMPOSITE | |
| P_PurReqnProcFlowGR | view | from | COMPOSITE | |
| P_PurReqnProcFlowInvc | view | from | COMPOSITE | |
| P_PurReqnSuccssrDocs | view | union_all | COMPOSITE | |
| P_RFDYPurgSchedLineWthProcdQts | view_entity | from | CONSUMPTION | |
| P_SCHDLNMIGRATION | view | inner | CONSUMPTION | Schedule Line Migration |
| P_SlsDocFlfmtPurgDocItem1 | view | from | CONSUMPTION | |
| P_SlsOrderInSupplyPurgIssue3 | view | inner | COMPOSITE |
Fields (42)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PurchasingDocument | ebeln,PurchasingDocument,SchedulingAgreement | 17 |
| KEY | PurchasingDocumentItem | ebelp,PurchasingDocumentItem,SchedulingAgreementItem | 18 |
| KEY | ScheduleLine | etenr,OrderScheduleLine,ScheduleLine | 13 |
| KEY | ScheduleLineDeliveryDate | DeliveryDate,eindt,RequestedDeliveryDate,ScheduleLineDeliveryDate | 18 |
| _PurchaseRequisition | _PurchaseRequisition | 1 | |
| _PurchaseRequisitionItem | _PurchaseRequisitionItem | 1 | |
| Batch | Batch | 2 | |
| CommittedDeliveryDate | CommittedDeliveryDate,dat01 | 2 | |
| DelivDateCategory | DelivDateCategory,lpein | 7 | |
| GoodsIssueDate | RequestedGoodsIssueDate,wadat | 2 | |
| GoodsIssueTime | wauhr | 1 | |
| GoodsReceiptQuantity | GoodsReceiptQuantity | 2 | |
| LoadingDate | lddat,LoadingDate,RequestedLoadingDate | 2 | |
| LoadingTime | lduhr | 1 | |
| MaterialStagingTime | mbuhr | 1 | |
| NoOfRemindersOfScheduleLine | mahnz,NoOfRemindersOfScheduleLine,PurchasingSchdLnNrOfReminders | 3 | |
| PerformancePeriodEndDate | enddate,PerformancePeriodEndDate | 4 | |
| PerformancePeriodStartDate | PerformancePeriodStartDate,startdate | 4 | |
| PrevDelivQtyOfScheduleLine | ameng,PrevDelivQtyOfScheduleLine | 2 | |
| ProductAvailabilityDate | mbdat,ProductAvailabilityDate | 3 | |
| PurchaseRequisition | banfn,PurchaseRequisition | 7 | |
| PurchaseRequisitionItem | bnfpo,PurchaseRequisitionItem | 7 | |
| Reservation | Reservation | 1 | |
| RoughGoodsReceiptQty | DeliveredQuantity,RoughGoodsReceiptQty,wemng | 6 | |
| SchedLinePrevDelivDate | altdt | 1 | |
| SchedLineStscDeliveryDate | SchedLineStscDeliveryDate,slfdt | 3 | |
| ScheduleLineCommittedQuantity | mng02,ScheduleLineCommittedQuantity | 3 | |
| ScheduleLineDeliveryTime | ScheduleLineDeliveryTime,uzeit | 8 | |
| ScheduleLineIsFixed | fixkz,ScheduleLineIsFixed | 2 | |
| ScheduleLineIssuedQuantity | ScheduleLineIssuedQuantity,wamng | 3 | |
| ScheduleLineOpenQuantity | ScheduleLineOpenQuantity | 3 | |
| ScheduleLineOrderDate | bedat,ScheduleLineOrderDate | 4 | |
| ScheduleLineOrderQuantity | menge,OrderQuantity,ScheduledQuantity,ScheduleLineOrderQuantity | 9 | |
| ScheduleLineUniqueID | ScheduleLineUniqueID,uniqueid | 2 | |
| SchedulingAgreementReleaseType | abart | 1 | |
| SchedulingLineDataAgingFilter | _dataaging | 1 | |
| SourceOfCreation | estkz,SourceOfCreation | 3 | |
| StockTransferDeliveredQuantity | StockTransferDeliveredQuantity | 2 | |
| STOLatestPossibleGRDate | eldat | 1 | |
| STOLatestPossibleGRTime | eluhr | 1 | |
| TransportationPlanningDate | tddat | 1 | |
| 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.
-- Purchasing Document Schedule Line
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGDOCSCHEDULELINE (
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTITEM,
SCHEDULELINE,
SCHEDULELINEDELIVERYDATE,
_PURCHASEREQUISITION,
_PURCHASEREQUISITIONITEM,
BATCH,
COMMITTEDDELIVERYDATE,
DELIVDATECATEGORY,
GOODSISSUEDATE,
GOODSISSUETIME,
GOODSRECEIPTQUANTITY,
LOADINGDATE,
LOADINGTIME,
MATERIALSTAGINGTIME,
NOOFREMINDERSOFSCHEDULELINE,
PERFORMANCEPERIODENDDATE,
PERFORMANCEPERIODSTARTDATE,
PREVDELIVQTYOFSCHEDULELINE,
PRODUCTAVAILABILITYDATE,
PURCHASEREQUISITION,
PURCHASEREQUISITIONITEM,
RESERVATION,
ROUGHGOODSRECEIPTQTY,
SCHEDLINEPREVDELIVDATE,
SCHEDLINESTSCDELIVERYDATE,
SCHEDULELINECOMMITTEDQUANTITY,
SCHEDULELINEDELIVERYTIME,
SCHEDULELINEISFIXED,
SCHEDULELINEISSUEDQUANTITY,
SCHEDULELINEOPENQUANTITY,
SCHEDULELINEORDERDATE,
SCHEDULELINEORDERQUANTITY,
SCHEDULELINEUNIQUEID,
SCHEDULINGAGREEMENTRELEASETYPE,
SCHEDULINGLINEDATAAGINGFILTER,
SOURCEOFCREATION,
STOCKTRANSFERDELIVEREDQUANTITY,
STOLATESTPOSSIBLEGRDATE,
STOLATESTPOSSIBLEGRTIME,
TRANSPORTATIONPLANNINGDATE,
TRANSPORTATIONPLANNINGTIME,
PRIMARY KEY (PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, SCHEDULELINE, SCHEDULELINEDELIVERYDATE)
);
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