I_SalesDocumentScheduleLine

Sales Document Schedule Line | view: ISDSLSDOCSCHEDLN | ATTR | Extraction: Not supported | Component: Sales
Tables used: VBEP
Column Name Description
SalesDocument Sales Document
SalesDocumentItem Sales Document Item
ScheduleLine Schedule Line Number
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OpenDeliveryNetAmount Open Delivery Net Amount (in Sales Document Currency)
Column Name Description
📏 Sales unit (OrderQuantityUnit):
ScheduleLineOrderQuantity Order Quantity in Sales Units
CorrectedQtyInOrderQtyUnit Corrected quantity in sales unit
ConfdOrderQtyByMatlAvailCheck Confirmed Quantity
OpenReqdDelivQtyInOrdQtyUnit Open requested Delivery Quantity
OpenConfdDelivQtyInOrdQtyUnit Open Confirmed Delivery Quantity
DeliveredQtyInOrderQtyUnit Delivered Quantity
📏 Base Unit of Measure (BaseUnit):
OpenReqdDelivQtyInBaseUnit Open requested Delivery Quantity
OpenConfdDelivQtyInBaseUnit Open Confirmed Delivery Quantity
DeliveredQuantityInBaseUnit Delivered Quantity
RequestedRqmtQtyInBaseUnit Requested Requirement Quantity in Base Unit
ConfirmedRqmtQtyInBaseUnit Confirmed Requirement Quantity in Base Unit
MRPRequiredQuantityInBaseUnit Required quantity for mat.management in stockkeeping units
Column Name Description
DeliveryDate Schedule line date
RequestedDeliveryDate Schedule line date
RequestedDeliveryTime Arrival time
ConfirmedDeliveryDate Schedule line date
ConfirmedDeliveryTime Arrival time
ConfdSchedLineReqdDelivDate Schedule line date
ProductAvailabilityDate Material Staging/Availability Date
ProductAvailabilityTime Material Staging Time (Local, Relating to a Plant)
ProductAvailCheckRqmtDate Requirement date (deadline for procurement)
DeliveryCreationDate Delivery Creation Date
TransportationPlanningDate Transportation Planning Date
TransportationPlanningTime Transp. Planning Time (Local, Relating to a Shipping Point)
GoodsIssueDate Goods Issue Date
LoadingDate Loading Date
GoodsIssueTime Time of Goods Issue (Local, Relating to a Plant)
LoadingTime Loading Time (Local Time Relating to a Shipping Point)
Column Name Description
DelivDateCategory Date type (day, week, month, interval) Show values
ScheduleLineConfirmationStatus Confirmation status of schedule line (incl.ALE) Show values
SchedulingAgreementReleaseType Release type Show values
PurchasingDocumentCategory Purchasing Document Category Show values
ItemIsDeliveryRelevant Item is relevant for delivery Show values
Column Name Description Domain name
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
IsRequestedDelivSchedLine null
IsConfirmedDelivSchedLine null
ProdAvailabilityCheckRqmtType Requirement type BDART
ProdAvailyCheckPlanningType Planning type PLART
RequirementsClass Requirements class BEDAR
ScheduleLineByForecastDelivery Forecast Delivery schedule number ABRUF
OrderSchedulingGroup Order Scheduling Group ID FSH_OS_ID
CustEngineeringChgStatus Customer Engineering Change Status AESKD
PurchaseRequisition Purchase Requisition Number BANFN
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == T006.MANDT
  • I_SALESDOCUMENTSCHEDULELINE.BASEUNIT == T006.MSEHI
Schedule Line Blocked for Delivery
  • Schedule Line Blocked for Delivery
  • Client
  • I_SALESDOCUMENTSCHEDULELINE.DELIVBLOCKREASONFORSCHEDLINE == TVLS.LIFSP
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == TVLS.MANDT
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == T156.MANDT
  • I_SALESDOCUMENTSCHEDULELINE.GOODSMOVEMENTTYPE == T156.BWART
Order Number
  • Client
  • Order Number
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == AUFK.MANDT
  • I_SALESDOCUMENTSCHEDULELINE.ORDERID == AUFK.AUFNR
Sales unit
  • Sales unit
  • Client
  • I_SALESDOCUMENTSCHEDULELINE.ORDERQUANTITYUNIT == T006.MSEHI
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == T006.MANDT
Planned Order
  • Client
  • Planned Order
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == PLAF.MANDT
  • I_SALESDOCUMENTSCHEDULELINE.PLANNEDORDER == PLAF.PLNUM
Order Type (Purchasing)
  • Purchasing Document Category
  • Client
  • Order Type (Purchasing)
  • I_SALESDOCUMENTSCHEDULELINE.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == T161.MANDT
  • I_SALESDOCUMENTSCHEDULELINE.PURCHASINGORDERTYPE == T161.BSART
Route Schedule
  • Client
  • Route Schedule
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == VALW.MANDT
  • I_SALESDOCUMENTSCHEDULELINE.ROUTESCHEDULE == VALW.AULWE
Schedule line category
  • Schedule line category
  • Client
  • I_SALESDOCUMENTSCHEDULELINE.SCHEDULELINECATEGORY == TVEP.ETTYP
  • I_SALESDOCUMENTSCHEDULELINE.MANDT == TVEP.MANDT