I_SchedgAgrmtSchedLineEnhcd

Scheduling Agreement from Analytical table | view: ISCHEDGAGRMTENHD | TRAN | Extraction: Not supported | Component: Contract
Tables used: MMPUR_ANA_EKET
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem FK Item Number of Purchasing Document
ScheduleLine Schedule Line Number
ProcurementHubSourceSystem Connected System ID
Column Name Description
💲 Reporting Currency 1 (AnalyticalReportingCurrency):
NetPriceInReportingCurrency Net Price: Reporting Currency 1
NetAmountInReportingCurrency Net Amount (in Reporting Currency 1)
OpenAmountInReportingCurrency Open Amount (in Reporting Currency 1)
💲 Reporting Currency 2 (AnalyticalReportingCurrency2):
NetPriceInReportingCurrency2 Net Price: Reporting Currency 2
NetAmountInReportingCurrency2 Net Amount (in Reporting Currency 2)
OpenAmountInReportingCurrency2 Open Amount (in Reporting Currency 2)
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
NetAmount Net Order Value in PO Currency
OpenAmountInDocumentCurrency Open Amount (in Document Currency)
💲 Company Currency (CompanyCodeCurrency):
NetPriceInCompanyCodeCrcy Net Price: Company Currency
NetAmountInCoCodeCurrency Net Amount in Company Currency
OpenAmountInCompanyCodeCrcy Open Amount (in Company Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
ScheduleLineOpenQuantity Open Quantity
ScheduleLineOrderQuantity Scheduled Quantity
GoodsReceiptQuantity Quantity of goods received
ScheduleLineIssuedQuantity Issued Quantity
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
PrevDelivQtyOfScheduleLine Previous Quantity (Delivery Schedule Lines)
ScheduleLineCommittedQuantity Committed Quantity
RoughGoodsReceiptQty Quantity of goods received
Column Name Description
CreationDate Last Changed On
PurchasingDocumentOrderDate Purchasing Document Date
ScheduleLineDeliveryDate Item delivery date
SchedLineStscDeliveryDate Statistics-Relevant Delivery Date
ScheduleLineDeliveryTime Delivery Date Time-Spot
ProductAvailabilityDate Material Staging/Availability Date
MaterialStagingTime Material Staging Time (Local, Relating to a Plant)
LoadingDate Loading Date
LoadingTime Loading Time (Local Time Relating to a Shipping Point)
TransportationPlanningDate Transportation Planning Date
TransportationPlanningTime Transp. Planning Time (Local, Relating to a Shipping Point)
GoodsIssueDate Goods Issue Date
GoodsIssueTime Time of Goods Issue (Local, Relating to a Plant)
STOLatestPossibleGRDate Goods Receipt End Date
STOLatestPossibleGRTime Goods Receipt End Time (Local, Relating to a Plant)
PurchaseOrderDate Order date of schedule line
PerformancePeriodStartDate Start Date for Period of Performance
PerformancePeriodEndDate End Date for Period of Performance
Column Name Description
AnlytlCrcyExchangeRateStatus Reporting Currency Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
GoodsReceiptIsExpected Goods Receipt Indicator Show values
PurchasingDocumentDeletionCode Asset class marked for deletion Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
PurchasingProcessingStatus Purchasing document processing state Show values
PurchasingDocumentIsAged Document is aged Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
IsReturnsItem Returns Item Show values
PurgDocSchdLnHasNextDelivery Indicator for Next Delivery Line Show values
SourceOfCreation Creation indicator (purchase requisition/schedule lines) Show values
SchedulingAgreementReleaseType Scheduling agreement release type Show values
MultipleAcctAssgmtDistribution Distribution Indicator for Multiple Account Assignment Show values
Column Name Description Domain name
ScheduleLineUniqueID Schedule line id(Concatenation of EBELN, EBELP, EETEN) PURGDOCSCHEDULELINEUNIQUEID
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
CompanyCode Company Code BUKRS
Supplier Account Number of Supplier LIFNR
Plant Plant WERKS
Material Material Number MATNR
MaterialGroup Material Group MATKL
ServicePerformer Service Performer BU_PARTNER
PurchasingDocumentType Order Type (Purchasing) BSART
PurchasingDocumentItemCategory Item category in purchasing document PSTYP
AccountAssignmentCategory Account Assignment Category KNTTP
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangeDateTime Change Time Stamp TZNTSTMPL
ProductTypeCode Product Type Group CHAR2
PurchaseRequisition Purchase Requisition Number BANFN
NoOfRemindersOfScheduleLine No. of Reminders/Expediters for Schedule Line PACK2
PurchaseContractItem Item number of principal purchase agreement EBELP
PurchaseContract Number of principal purchase agreement EBELN
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
NetPriceQuantity Price unit DEC5
Other Relations Join Conditions
Category of delivery date
  • Client
  • ?
  • Category of delivery date
  • I_SCHEDGAGRMTSCHEDLINEENHCD.MANDT == TPRG.MANDT
  • I_SCHEDGAGRMTSCHEDLINEENHCD.[column in domain "SPRAS"] == TPRG.SPRAS
  • I_SCHEDGAGRMTSCHEDLINEENHCD.DELIVDATECATEGORY == TPRG.PRGBZ