P_SchedgAgrmtItmDelivCalc

Scheduling Agreement Calculations | view: PSAITMDELCAL | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKETEKKOEKPOT161TUSR21
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem Item Number of Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
ReleasedAmount null
GoodsReceiptAmountInCoCodeCrcy null
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
NetAmount null
ScheduleLineOrderQuantity Scheduled Quantity
RoughGoodsReceiptQty Quantity of goods received
ScheduleLineOpenQty null
ReleasedQuantity null
GoodsReceiptQty null
Column Name Description
ScheduleLineDeliveryDate null
TodayDate null
Column Name Description
GoodsReceiptIsExpected Goods Receipt Indicator Show values
Column Name Description Domain name
ScheduleLine null
DeliveryStatus null
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == TCURC.MANDT
  • P_SCHEDGAGRMTITMDELIVCALC.DOCUMENTCURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == T006.MANDT
  • P_SCHEDGAGRMTITMDELIVCALC.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == T001W.MANDT
  • P_SCHEDGAGRMTITMDELIVCALC.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == T163.MANDT
  • P_SCHEDGAGRMTITMDELIVCALC.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • ?
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == T161.MANDT
  • P_SCHEDGAGRMTITMDELIVCALC.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDGAGRMTITMDELIVCALC.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDGAGRMTITMDELIVCALC.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SCHEDGAGRMTITMDELIVCALC.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == T024E.MANDT
Storage Location
  • Client
  • Plant
  • Storage Location
  • P_SCHEDGAGRMTITMDELIVCALC.MANDT == T001L.MANDT
  • P_SCHEDGAGRMTITMDELIVCALC.PLANT == T001L.WERKS
  • P_SCHEDGAGRMTITMDELIVCALC.STORAGELOCATION == T001L.LGORT