P_SLLMINMAXRELEVANTPOITEMS

PO history for min and max order price determination | view: PSLLMINMAXPOITMS | TRAN | Extraction: Not supported | Component: Integration with Global Trade Services
Tables used: EKBEEKKOEKPOMARAMBEWT001W
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
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
PurchaseOrderAmount null
PurOrdAmountInCompanyCodeCrcy Amount in Local Currency
InvoiceAmtInCoCodeCrcy Invoice Value Entered (in Local Currency)
Column Name Description
Quantity Quantity
QuantityInBaseUnit Quantity
Column Name Description
PostingDate Posting Date in the Document
DocumentDate Purchasing Document Date
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
DebitCreditCode Debit/Credit Indicator Show values
Column Name Description Domain name
PriceUnit Price unit PACK3
ConvNumeratorToBaseUnit Numerator for Conversion of Order Unit to Base Unit UMBSZ
ConvDenominatorToBaseUnit Denominator for Conversion of Order Unit to Base Unit UMBSN
Master Data Relations Join Conditions
Unit of Measure
  • Client
  • Base Unit of Measure
  • Purchase Order Unit of Measure
  • P_SLLMINMAXRELEVANTPOITEMS.MANDT == T006.MANDT
  • P_SLLMINMAXRELEVANTPOITEMS.BASEUNITOFMEASSURE == T006.MSEHI
  • P_SLLMINMAXRELEVANTPOITEMS.ORDERUNITOFMEASSURE == T006.MSEHI
Local currency key
  • Local currency key
  • Client
  • P_SLLMINMAXRELEVANTPOITEMS.COMPANYCODECURRENCY == TCURC.WAERS
  • P_SLLMINMAXRELEVANTPOITEMS.MANDT == TCURC.MANDT
Movement type (inventory management)
  • Movement type (inventory management)
  • Client
  • P_SLLMINMAXRELEVANTPOITEMS.GOODSMOVEMENTTYPE == T156.BWART
  • P_SLLMINMAXRELEVANTPOITEMS.MANDT == T156.MANDT
Material Number
  • Client
  • Material Number
  • P_SLLMINMAXRELEVANTPOITEMS.MANDT == MARA.MANDT
  • P_SLLMINMAXRELEVANTPOITEMS.MATERIAL == MARA.MATNR
Currency Key
  • Client
  • Currency Key
  • P_SLLMINMAXRELEVANTPOITEMS.MANDT == TCURC.MANDT
  • P_SLLMINMAXRELEVANTPOITEMS.ORDERCURRENCY == TCURC.WAERS
Purchase Order Unit of Measure
  • Client
  • Base Unit of Measure
  • Purchase Order Unit of Measure
  • P_SLLMINMAXRELEVANTPOITEMS.MANDT == T006.MANDT
  • P_SLLMINMAXRELEVANTPOITEMS.BASEUNITOFMEASSURE == T006.MSEHI
  • P_SLLMINMAXRELEVANTPOITEMS.ORDERUNITOFMEASSURE == T006.MSEHI
Plant
  • Plant
  • Client
  • P_SLLMINMAXRELEVANTPOITEMS.PLANT == T001W.WERKS
  • P_SLLMINMAXRELEVANTPOITEMS.MANDT == T001W.MANDT