C_SchedgAgrmtItmDelivCalc

Scheduling Agreement Calculations | view: CSAITMDELCAL | 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)
NetAmount Net Order Value
ReleasedAmount null
GoodsReceiptAmountInCoCodeCrcy null
StillToBeDeliveredValue null
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
ScheduleLineOrderQuantity Scheduled Quantity
RoughGoodsReceiptQty Quantity of goods received
ScheduleLineOpenQty null
ReleasedQuantity null
GoodsReceiptQty null
StillToBeDeliveredQuantity null
Column Name Description
ScheduleLineDeliveryDate null
Column Name Description
Column Name Description Domain name
ScheduleLine null
DeliveryStatus null
SchedAgrmtValidityStatus null
DifferenceInDays null
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == TCURC.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.DOCUMENTCURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == T006.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == T001W.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.PLANT == T001W.WERKS
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == T163.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • C_SCHEDGAGRMTITMDELIVCALC.[column in domain "BSTYP"] == T161.BSTYP
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == T161.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == T024.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == T024E.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Plant
  • Storage Location
  • C_SCHEDGAGRMTITMDELIVCALC.MANDT == T001L.MANDT
  • C_SCHEDGAGRMTITMDELIVCALC.PLANT == T001L.WERKS
  • C_SCHEDGAGRMTITMDELIVCALC.STORAGELOCATION == T001L.LGORT