C_SchedAgrmtSchedLineDEX

Data Extraction for Scheduling Agreement Releases | view: CMMSCHEDGLINEDEX | TRAN | Extraction: Full or Incremental | Component: Reporting
Tables used: EKKOEKETEKKOEKPOT161TUSR21
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem FK Item Number of Purchasing Document
ScheduleLine Delivery Schedule Line Counter
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
ScheduleLineOrderQuantity Scheduled Quantity
RoughGoodsReceiptQty Quantity of goods received
PrevDelivQtyOfScheduleLine Previous Quantity (Delivery Schedule Lines)
Column Name Description
ScheduleLineDeliveryDate Item delivery date
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
ScheduleLineDeliveryTime Delivery Date Time-Spot
PurchasingDocumentOrderDate Purchasing Document Date
Column Name Description
ScheduleLineIsFixed Schedule Line is "Fixed" Show values
SourceOfCreation Creation indicator (purchase requisition/schedule lines) Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
Column Name Description Domain name
PurchaseRequisition Purchase Requisition Number BANFN
PurchasingSchdLnNrOfReminders No. of Reminders/Expediters for Schedule Line PACK2
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == MARA.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.MATERIAL == MARA.MATNR
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == T006.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == T001W.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • ?
  • C_SCHEDAGRMTSCHEDLINEDEX.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == T161.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == T024.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == T024E.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Plant
  • Storage Location
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == T001L.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.PLANT == T001L.WERKS
  • C_SCHEDAGRMTSCHEDLINEDEX.STORAGELOCATION == T001L.LGORT
Supplier
  • Client
  • Supplier
  • C_SCHEDAGRMTSCHEDLINEDEX.MANDT == LFA1.MANDT
  • C_SCHEDAGRMTSCHEDLINEDEX.SUPPLIER == LFA1.LIFNR