P_SchedulingAgreementHistory

Scheduling Agreement History | view: PMMSCHAGHIST | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKBE, EKBEH, EKPO, T161T, USR21
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
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
MaterialDocumentYear Material Document Year
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
💲 Currency Key (Currency):
InvoiceAmountInDocCurrency null
GoodsReceiptGoodsAmtInDocCurr null
Column Name Description
GoodsReceiptQuantity null
InvoiceReceiptQty null
Column Name Description
PostingDate Posting Date in the Document
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
PurchasingDocumentOrderDate Purchasing Document Date
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
Column Name Description Domain name
NetPriceQuantity Price Unit DEC5
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
MultipleAcctAssgmtDistribution null
PartialInvoiceDistribution null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T163K.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Company Code
  • Client
  • Company Code
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T001.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == TCURC.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.CURRENCY == TCURC.WAERS
  • P_SCHEDULINGAGREEMENTHISTORY.DOCUMENTCURRENCY == TCURC.WAERS
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == TCURC.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.CURRENCY == TCURC.WAERS
  • P_SCHEDULINGAGREEMENTHISTORY.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == MARA.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T023.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.MATERIALGROUP == T023.MATKL
Material type
  • Client
  • Material type
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T134.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.MATERIALTYPE == T134.MTART
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T006.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T001W.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Client
  • ?
  • P_SCHEDULINGAGREEMENTHISTORY.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T161.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.[column in domain "BSTYP"] == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDULINGAGREEMENTHISTORY.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T024E.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Storage Location
  • Client
  • Plant
  • P_SCHEDULINGAGREEMENTHISTORY.STORAGELOCATION == T001L.LGORT
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == T001L.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.PLANT == T001L.WERKS
Supplier
  • Client
  • Supplier
  • P_SCHEDULINGAGREEMENTHISTORY.MANDT == LFA1.MANDT
  • P_SCHEDULINGAGREEMENTHISTORY.SUPPLIER == LFA1.LIFNR