Which CDS Views use I_PURGDOCSCHEDULELINE?

I_PURGDOCSCHEDULELINE is used by 47 CDS view(s), including: A_PurchaseOrderScheduleLine, C_ArbErp_ConfIn_ScheduleLine, C_Arberp_Ordrout_Scheduleline, C_MRPScheduleAgreement, C_PurgDocSchedulelineObj, I_ARunItmRsnCode, I_ARunOvwConfStrgy, I_CFinPurgDocScheduleLine, I_DigitalVehiclePurOrderItem, I_MRPPurchaseOrder.

How many fields does I_PURGDOCSCHEDULELINE have?

I_PURGDOCSCHEDULELINE has 42 fields. Key fields: PurchasingDocument, PurchasingDocumentItem, ScheduleLine, ScheduleLineDeliveryDate.

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)

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_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	from	COMPOSITE	CFin Purchasing Document: Schedule Line
I_DigitalVehiclePurOrderItem	view_entity	inner	COMPOSITE	Vehicle Purchase Order
I_MRPPurchaseOrder	view	left_outer	COMPOSITE	MRP Purchase Order
I_MRPTransferDemand	view_entity	inner	COMPOSITE	Transfer Demand
I_ProjProcmtPurOrdSchedLines	view	from	BASIC	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	COMPOSITE	Cumulative Scheduled Quantity for Item
I_Scheduleline_Cumscheqty	view	inner	COMPOSITE	Cumulative Scheduled Quantity for Item
I_ShippingNotifQuickView	view_entity	left_outer	COMPOSITE	MRP Shipping Notifications
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	Order Details in Replenishment App
P_DDPurchaseOrder	view	left_outer	COMPOSITE	Purchase Order Basic Details
P_POItemSched	view	from	CONSUMPTION	PO Item Open Schedule Line Calculation
P_POItemSchedLnDelivDat	view	from	CONSUMPTION	Next Delivery Date Calculation
P_POItemSchedLnTotal	view_entity	from	CONSUMPTION	PO Item Open Schedule Line
P_PurchaseOrderItemAddFields	view	inner	COMPOSITE	Purchase Order Item Additional Fields
P_PurchaseOrderScheduleLine1	view	from	CONSUMPTION	P_PurchaseOrderScheduleLine1
P_Purgdocscheduleline	view	from	CONSUMPTION	Purchasing Document Schedule Lines
P_PurgDocSchedulelineCuml	view	from	CONSUMPTION	Cumulative Quantity based on Schedule Lines
P_PurgDocSchedulelineCuml	view	inner	CONSUMPTION	Cumulative Quantity based on Schedule Lines
P_PurgOrdSchKeyDate	view	from	CONSUMPTION	View for Delivery Date and Quantity
P_PurOrditemDeliveryDate	view	from	COMPOSITE	Calculation of Purchase Order Item Delivery date
P_PurOrdLtstSchedLine	view	inner	CONSUMPTION	Latest Schedule Line of Purchase Orders
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	Get data of only one Schedule Line
P_PurOrdSingleScheduleLineHlp1	view	from	COMPOSITE	Helper view to get only one Schedule Line
P_PurOrdSingleScheduleLineHlp2	view	inner	COMPOSITE	Helper view to get only one Schedule Line
P_PurOrdSingleScheduleLineHlp3	view	inner	COMPOSITE	Helper view to get only one Schedule Line
P_PurReqnProcFlowGR	view	from	COMPOSITE	Fetch GR in Pur Reqn Process flow
P_PurReqnProcFlowInvc	view	from	COMPOSITE	Fetch Invoice in Pur Reqn Process flow
P_PurReqnSuccssrDocs	view	union_all	COMPOSITE	Direct Successor documents of Pur Reqn
P_RFDYPurgSchedLineWthProcdQts	view_entity	from	CONSUMPTION	RFDY Purchasing Schedule Line With Processed Quantities
P_SCHDLNMIGRATION	view	inner	CONSUMPTION	Schedule Line Migration
P_SlsDocFlfmtPurgDocItem1	view	from	CONSUMPTION	Sales Doc Fulfillment: Purg Doc Item Delivery Date
P_SlsOrderInSupplyPurgIssue3	view	inner	COMPOSITE	SOFM Purchasing Issue 3 V2

Fields (42)

Key	Field	CDS Fields	Used in Views
KEY	PurchasingDocument	ebeln,PurchasingDocument,SchedulingAgreement	18
KEY	PurchasingDocumentItem	ebelp,PurchasingDocumentItem,SchedulingAgreementItem	19
KEY	ScheduleLine	etenr,OrderScheduleLine,ScheduleLine	13
KEY	ScheduleLineDeliveryDate	DeliveryDate,eindt,RequestedDeliveryDate,ScheduleLineDeliveryDate	20
	_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	3
	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	4
	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	4
	ScheduleLineOrderDate	bedat,ScheduleLineOrderDate	5
	ScheduleLineOrderQuantity	menge,OrderQuantity,ScheduledQuantity,ScheduleLineOrderQuantity	10
	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

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Purchasing Document Schedule Line'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IMMPRGDOCSCHEDLN'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_PurgDocScheduleLine
  as select from eket as eket

  association [0..1] to I_Purchaserequisitionitem as _PurchaseRequisitionItem on  $projection.PurchaseRequisition     = _PurchaseRequisitionItem.PurchaseRequisition
                                                                              and $projection.PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem

  association [1..1] to I_Purchaserequisition     as _PurchaseRequisition     on  $projection.PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition


  association [1..1] to I_Deliverydatecategory    as _DeliveryDateCategory    on  $projection.DelivDateCategory = _DeliveryDateCategory.DelivDateCategory

{
      //@ObjectModel.foreignKey.association: '_PurchasingDocument'

  key eket.ebeln    as PurchasingDocument,

      //@ObjectModel.foreignKey.association: '_PurchaseDocumentItem'

  key eket.ebelp    as PurchasingDocumentItem,

  key etenr         as ScheduleLine,
      //_DeliveryDateCategory.Language,

      //@ObjectModel: { foreignKey.association: '_Deliverydatecategtext'}

      @ObjectModel: { foreignKey.association: '_DeliveryDateCategory'}
      lpein         as DelivDateCategory,

      eindt         as ScheduleLineDeliveryDate,

      slfdt         as SchedLineStscDeliveryDate,

      startdate     as PerformancePeriodStartDate,

      enddate       as PerformancePeriodEndDate,

      uzeit         as ScheduleLineDeliveryTime,

      eket.menge    as ScheduleLineOrderQuantity,

      bedat         as ScheduleLineOrderDate,

      wemng         as RoughGoodsReceiptQty,


      abart         as SchedulingAgreementReleaseType,
      dat01         as CommittedDeliveryDate,
      altdt         as SchedLinePrevDelivDate,
      _dataaging    as SchedulingLineDataAgingFilter,

      @ObjectModel.foreignKey.association: '_PurchaseRequisition'
      eket.banfn    as PurchaseRequisition,

      @ObjectModel.foreignKey.association: '_PurchaseRequisitionItem'
      eket.bnfpo    as PurchaseRequisitionItem,

      estkz         as SourceOfCreation,

      ameng         as PrevDelivQtyOfScheduleLine,

      eket.mahnz    as NoOfRemindersOfScheduleLine,

      fixkz         as ScheduleLineIsFixed,

      mng02         as ScheduleLineCommittedQuantity,

      rsnum         as Reservation,

      mbdat         as ProductAvailabilityDate,
      mbuhr         as MaterialStagingTime,
      tddat         as TransportationPlanningDate,
      tduhr         as TransportationPlanningTime,
      lddat         as LoadingDate,
      lduhr         as LoadingTime,
      wadat         as GoodsIssueDate,
      wauhr         as GoodsIssueTime,
      eldat         as STOLatestPossibleGRDate,
      eluhr         as STOLatestPossibleGRTime,
      wemng         as GoodsReceiptQuantity,
      glmng         as StockTransferDeliveredQuantity,
      wamng         as ScheduleLineIssuedQuantity,
      charg         as Batch,

      // Fields added for R_*TP development, GFN need to be approved

      aulwe         as RouteSchedule,
      mbuhr         as ProductAvailabilityTime,
//      eldat         as GoodsReceiptEndDate,

//      eluhr         as GoodsReceiptEndTime,

//      dat01         as CommittedDate,

//      handoverdate  as HandoverDte,

//      handovertime  as HandoverTme,

//      geo_route     as GeographicalRoute,


      // Fields doen't exist in DB Table, but exist in BAPIMEPOSCHEDULE

      // PurchasingDocumentDeletionCode - DELETE_IND

      // IsClosed - REQ_CLOSED


      //Persistent Key Adoption

      eket.uniqueid as ScheduleLineUniqueID,

      case
        when
         eket.menge > wemng
        then
         (eket.menge - wemng )
         else
         0
      end           as ScheduleLineOpenQuantity,

      _PurchaseRequisition,
      _PurchaseRequisitionItem,
      _DeliveryDateCategory

}

Depth:

I_PURGDOCSCHEDULELINE

CDS Views using this table (47)

Fields (42)

Learn More