P_Rfqitemsmntr

Private View For RFQ Visual Filters | view: PRFQITEMSMNTR | TRAN | Extraction: Not supported | Component: RFQ/Quotation
Tables used: EKKOEKPOEKETT001TKA02MARAT023T023TMAKTT001WLFA1
Column Name Description
RequestForQuotation FK Purchasing Document Number
RequestForQuotationItem Item Number of Request For Quotation
SupplierQuotation FK Purchasing Document Number
SupplierQuotationItem Item Number of Supplier Quotation
Column Name Description
NetAmount Quotation Net Value
PriceQuotation null
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
ScheduleLineOrderQuantity Scheduled Quantity
PlannedQuantity Scheduled Quantity
AwardedQuantity Awarded Quantity
Column Name Description
CreationDate Creation Date of Purchasing Document
QuotationSubmissionDate Quotation Submission Date
ScheduleLineDeliveryDate Delivery Date
Column Name Description
PurchasingIsBlocked Centrally imposed purchasing block Show values
RFQLifecycleStatus RFQ Lifecycle Status Show values
Column Name Description Domain name
QtnLifecycleStatus null
IsCriticallyOverdue null
SupplierName Name of Supplier TEXT80
PurchaseRequisition Purchase Requisition Number BANFN
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
MaterialGroupName Product Group Description TEXT20
CompanyCodeName Name of Company Code or Company TEXT25
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • P_RFQITEMSMNTR.MANDT == TCURC.MANDT
  • P_RFQITEMSMNTR.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_RFQITEMSMNTR.MANDT == MARA.MANDT
  • P_RFQITEMSMNTR.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_RFQITEMSMNTR.MANDT == T023.MANDT
  • P_RFQITEMSMNTR.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_RFQITEMSMNTR.MANDT == T006.MANDT
  • P_RFQITEMSMNTR.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • P_RFQITEMSMNTR.MANDT == T001W.MANDT
  • P_RFQITEMSMNTR.PLANT == T001W.WERKS
Supplier
  • Supplier
  • Client
  • P_RFQITEMSMNTR.SUPPLIER == LFA1.LIFNR
  • P_RFQITEMSMNTR.MANDT == LFA1.MANDT