I_PURGDOCSCHEDULELINE

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);