I_SchedulingAgreementHistory

Scheduling Agreement History | view: IMMSAGMTHISTORY | TRAN | Extraction: Not supported | Component: Contract
Tables used: EKKOEKBEEKBEHT161TUSR21
Column Name Description
SchedulingAgreement FK Purchasing Document Number
SchedulingAgreementItem FK Item Number of Purchasing Document
AccountAssignmentNumber Sequential Number of Account Assignment
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
MaterialDocumentYear Material Document Year
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
Column Name Description
💲 Currency Key (Currency):
PurOrdAmountInCompanyCodeCrcy Amount in Local Currency
PurchaseOrderAmount Amount in Document Currency
GRIRAcctClrgAmtInCoCodeCrcy GR/IR account clearing value in local currency
InvoiceAmtInCoCodeCrcy Invoice Value Entered (in Local Currency)
InvoiceAmountInFrgnCurrency Invoice Value in Foreign Currency
GRIRAcctClrgAmtInTransacCrcy Clearing value on GR/IR clearing account (transac. currency)
GRIRAcctClrgAmtInOrdTrnsacCrcy Clearing Value on GR/IR Account in PO Currency
InvoiceAmtInPurOrdTransacCrcy Invoice Amount in PO Currency
ExchangeRateDifferenceAmount Exchange Rate Difference Amount
Column Name Description
Quantity Quantity
QtyInPurchaseOrderPriceUnit Quantity in purchase order price unit
GdsRcptBlkdStkQtyInOrdQtyUnit Goods Receipt Blocked Stock in Order Unit
GdsRcptBlkdStkQtyInOrdPrcUnit Quantity in GR blocked stock in order price unit
QuantityInBaseUnit Quantity
VltdGdsRcptBlkdStkQtyInOrdUnit Valuated Goods Receipt Blocked Stock in Order Unit
VltdGdsRcptBlkdQtyInOrdPrcUnit Quantity in Valuated GR Blocked Stock in Order Price Unit
📏 Unit of Measure From Delivery Note (DeliveryQuantityUnit):
QuantityInDeliveryQtyUnit Quantity in Unit of Measure from Delivery Note
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
AccountingDocumentCreationDate Day On Which Accounting Document Was Entered
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
DebitCreditCode Debit/Credit Indicator Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
IsToBeAcceptedAtOrigin Acceptance At Origin Show values
Column Name Description Domain name
ReferenceDocumentFiscalYear Fiscal Year of a Reference Document GJAHR
ReferenceDocument Document No. of a Reference Document BELNR
ReferenceDocumentItem Item of a Reference Document MBLPO
PricingDocument Number of the Document Condition KNUMV
TaxCode Tax on sales/purchases code MWSKZ
DocumentReferenceID Reference Document Number XBLNR1
ExchangeRate Exchange Rate KURSP
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.CURRENCY == TCURC.WAERS
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == TCURC.MANDT
Unit of Measure From Delivery Note
  • Unit of Measure From Delivery Note
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.DELIVERYQUANTITYUNIT == T006.MSEHI
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == T006.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.GOODSMOVEMENTTYPE == T156.BWART
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == T156.MANDT
Valuation Type
  • Valuation Type
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == T149D.MANDT
Material number
  • Material number
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.MANUFACTURERMATERIAL == MARA.MATNR
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == MARA.MANDT
Material Number
  • Material Number
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.MATERIAL == MARA.MATNR
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == MARA.MANDT
Plant
  • Plant
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.PLANT == T001W.WERKS
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == T001W.MANDT
Purchase Order History Category
  • Purchase Order History Category
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.PURCHASEORDERHISTCATEGORY == T163B.BEWTP
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == T163B.MANDT
Compliance with Shipping Instructions
  • Compliance with Shipping Instructions
  • ?
  • Client
  • I_SCHEDULINGAGREEMENTHISTORY.SHIPGINSTRNSUPPLIERCOMPLIANCE == T027C.EVERE
  • I_SCHEDULINGAGREEMENTHISTORY.[column in domain "EVERS"] == T027C.EVERS
  • I_SCHEDULINGAGREEMENTHISTORY.MANDT == T027C.MANDT