P_SchedgAgreementItemHistory

Scheduling Agreement Item History | view: PSCHAGITMHIST | Extraction: Not supported | Component: Reporting
Tables used: EKKO, EKET, EKBE, EKBEH, EKKO, EKPO, T161T, USR21
Column Name Description
SchedulingAgreement FK Scheduling Agreement
SchedulingAgreementItem Scheduling Agreement Item
ScheduleLine Delivery Schedule Line Counter
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)
💲 Display Currency (DisplayCurrency):
TargetAmount Scheduling Agreement Target Amount
SchedulingAgreementSpend Scheduling Agreement Released Amount
ScheduleLineExpectedSpend Expected Spend of Scheduling Agreement
GoodsReceiptAmountInDspCrcy Goods Receipt Amount
InvoiceAmtInDisplayCurrency Invoice Amount
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
PurchasingDocumentOrderDate Purchasing Document Date
PostingDate Posting Date in the Document
ScheduleLineDeliveryDate Item delivery date
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
Column Name Description Domain name
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
MultipleAcctAssgmtDistribution null
PartialInvoiceDistribution null
GoodsReceiptQuantity Goods Receipt Quantity of Scheduling Agreement Items DEC
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T163K.MANDT
Company Code
  • Company Code
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.COMPANYCODE == T001.BUKRS
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.DOCUMENTCURRENCY == TCURC.WAERS
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.MATERIAL == MARA.MATNR
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.MATERIALGROUP == T023.MATKL
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.MATERIALTYPE == T134.MTART
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T134.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T006.MANDT
  • P_SCHEDGAGREEMENTITEMHISTORY.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T001W.MANDT
  • P_SCHEDGAGREEMENTITEMHISTORY.PLANT == T001W.WERKS
Purchasing Document Type
  • ?
  • Purchasing Document Type
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.[column in domain "BSTYP"] == T161.BSTYP
  • P_SCHEDGAGREEMENTITEMHISTORY.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.PURCHASINGGROUP == T024.EKGRP
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • P_SCHEDGAGREEMENTITEMHISTORY.STORAGELOCATION == T001L.LGORT
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == T001L.MANDT
  • P_SCHEDGAGREEMENTITEMHISTORY.PLANT == T001L.WERKS
Supplier
  • Supplier
  • Client
  • P_SCHEDGAGREEMENTITEMHISTORY.SUPPLIER == LFA1.LIFNR
  • P_SCHEDGAGREEMENTITEMHISTORY.MANDT == LFA1.MANDT