P_Rfqitems

Monitor RFQ Items | view: PRFQITEMS | TRAN | Extraction: Not supported | Component: RFQ/Quotation

Tables used: EKKO, EKPO, EKET, T001, TKA02, MARA, T023, T023T, MAKT, T001W, T161, T161T, LFA1, USR21

🔑 Keys (4)
💰 Amounts (2)
∑ Quantities (3)
📅 Dates (7)
☰ Categorical (3)
Other (20)
🔗 Relations (13)

Column Name	Description
RequestForQuotation FK	Purchasing Document Number
RequestForQuotationItem	Item Number of Request For Quotation
SupplierQuotation	Purchasing Document Number
SupplierQuotationItem	null

Column Name	Description
💲 Display Currency (DisplayCurrency):
NetAmount	null
PriceQuotation	null

Column Name	Description
ScheduleLineOrderQuantity	Scheduled Quantity
PlannedQuantity	Scheduled Quantity
AwardedQuantity	Awarded Quantity

Column Name	Description
QuotationSubmissionDate	Quotation Submission Date
BindingPeriodValidityEndDate	Binding Period for Quotation
QuotationLatestSubmissionDate	Deadline for Submission of Bid/Quotation
CreationDate	Creation Date of Purchasing Document
RFQPublishingDate	RFQ Publishing Date
ScheduleLineDeliveryDate	Delivery Date
SupplierCreationDate	Creation Date of Purchasing Document

Column Name	Description
Status	RFQ Lifecycle Status	Show values
RFQLifecycleStatus	RFQ Lifecycle Status	Show values
PurchasingDocumentCategory	Purchasing Document Category	Show values

Column Name	Description	Domain name
SupplierName	Name of Supplier	TEXT80
ActiveSupplierQuotation	null
PurchaseRequisition	Purchase Requisition Number	BANFN
PurchaseRequisitionItem	null
MaterialName	Material Description	TEXT40
PlantName	Plant Name	TEXT30
PurchasingDocumentItemText	Short Text	TEXT40
PurchasingDocumentTypeName	Short Description of Purchasing Document Type	TEXT20
RequestForQuotationName	Short description or the title of the RFQ	TEXT40
RFQLifecycleStatusName	Request For Quotation Lifecycle Status Texts	DDTEXT
FullName	User Description	SUIDTECHDESC
CompanyCodeName	Name of Company Code or Company	TEXT25
PurOrdOverdueDate	null
DueDateCriticality	null
MaterialGroupName	Product Group Description	TEXT20
IsCriticallyOverdue	null
OverdueCategoryName	null
QtnLifecycleStatusName	null
QtnLifecycleStatus	null
PurchasingIsBlocked	null

Master Data Relations	Join Conditions
Company Code Company Code Client	`P_RFQITEMS.COMPANYCODE == T001.BUKRS` `P_RFQITEMS.MANDT == T001.MANDT`
Currency Key Currency Key Client	`P_RFQITEMS.DOCUMENTCURRENCY == TCURC.WAERS` `P_RFQITEMS.MANDT == TCURC.MANDT`
Material Number Client Material Number	`P_RFQITEMS.MANDT == MARA.MANDT` `P_RFQITEMS.MATERIAL == MARA.MATNR`
Material Group Material Group Client	`P_RFQITEMS.MATERIALGROUP == T023.MATKL` `P_RFQITEMS.MANDT == T023.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`P_RFQITEMS.ORDERQUANTITYUNIT == T006.MSEHI` `P_RFQITEMS.MANDT == T006.MANDT`
Plant Plant Client	`P_RFQITEMS.PLANT == T001W.WERKS` `P_RFQITEMS.MANDT == T001W.MANDT`
RFQ Document Type RFQ Document Type RFQ Document Type Purchasing Document Category Client	`P_RFQITEMS.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_RFQITEMS.RFQTYPE == T161.BSART` `P_RFQITEMS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_RFQITEMS.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`P_RFQITEMS.PURCHASINGGROUP == T024.EKGRP` `P_RFQITEMS.MANDT == T024.MANDT`
Purchasing Organization Purchasing Organization Client	`P_RFQITEMS.PURCHASINGORGANIZATION == T024E.EKORG` `P_RFQITEMS.MANDT == T024E.MANDT`
RFQ Document Type RFQ Document Type RFQ Document Type Purchasing Document Category Client	`P_RFQITEMS.PURCHASINGDOCUMENTTYPE == T161.BSART` `P_RFQITEMS.RFQTYPE == T161.BSART` `P_RFQITEMS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP` `P_RFQITEMS.MANDT == T161.MANDT`
Supplier Supplier Client	`P_RFQITEMS.SUPPLIER == LFA1.LIFNR` `P_RFQITEMS.MANDT == LFA1.MANDT`