P_SchedgAgrmtItemHistory

Scheduling Agreement Item History | view: PSCAGTITMHIS | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKET, EKBE, EKBEH, EKKO, EKPO, T161T, USR21
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem Item Number of Purchasing Document
Column Name Description
💲 Display Currency (DisplayCurrency):
TargetAmount Target Amount
SchedulingAgreementSpend Scheduling Agreement Released Amount
GoodsReceiptAmountInDspCrcy Goods Receipt Amount
InvoiceAmtInDisplayCurrency Invoice Amount
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
InvoiceReceiptQty null
SchedgAgrmtItmDueDeliveryQty null
SchedgAgrmtItmOverdueQty null
SchedgAgrmtItmNextDelivQty Scheduled Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
PurchasingDocumentOrderDate Purchasing Document Date
NextDeliveryDate null
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
SchedgAgreementItemNextRelDate Next Delivery According To Scheduling Agreement Show values
SchedAgrmtItemIsOverdue Delivery Status Show values
SchedAgrmtItmInApprvlSts Scheduling Agreement In Approval Status Show values
Column Name Description Domain name
NetPriceAmount null
NetPriceQuantity Price Unit DEC5
ScheduleLineOrderQuantity Target Quantity of Scheduling Agreement Items DEC
OrderPriceUnitToOrderUnitNmrtr Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
OrdPriceUnitToOrderUnitDnmntr Denominator for Conv. of Order Price Unit into Order Unit UMBSN
ProductType Product Type Group CHAR2
GoodsReceiptQuantity Goods Receipt Quantity of Scheduling Agreement Items DEC
SchedAgrmtValidityStatus Purchase Contract Validity Status CHAR20
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.COMPANYCODE == T001.BUKRS
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.DOCUMENTCURRENCY == TCURC.WAERS
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.MATERIAL == MARA.MATNR
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.MATERIALGROUP == T023.MATKL
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T134.MANDT
  • P_SCHEDGAGRMTITEMHISTORY.MATERIALTYPE == T134.MTART
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T006.MANDT
  • P_SCHEDGAGRMTITEMHISTORY.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Plant
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.PLANT == T001W.WERKS
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T001W.MANDT
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • P_SCHEDGAGRMTITEMHISTORY.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T024E.MANDT
Storage Location
  • Plant
  • Storage Location
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.PLANT == T001L.WERKS
  • P_SCHEDGAGRMTITEMHISTORY.STORAGELOCATION == T001L.LGORT
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == T001L.MANDT
Supplier
  • Supplier
  • Client
  • P_SCHEDGAGRMTITEMHISTORY.SUPPLIER == LFA1.LIFNR
  • P_SCHEDGAGRMTITEMHISTORY.MANDT == LFA1.MANDT