I_REQUESTFORQUOTATIONITEM

CDS View
41 Fields 5 CDS Views

Request For Quotation Item

I_REQUESTFORQUOTATIONITEM is a CDS View in S/4HANA. Request For Quotation Item. It contains 41 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_RFQItemEnhanced view from COMPOSITE Request For Quotation Item Enhanced
P_CalcQuotationDays view from CONSUMPTION Private view for Quotation Days Calculation
P_Rfqitemsmntr view from CONSUMPTION Private View For RFQ Visual Filters
P_RFQScheduleLine view from COMPOSITE RFQ Schedule Line
R_RFQItemHierarchyNodeRelation view from COMPOSITE Source View for RFQ items Hierarchy

Fields (41)

KeyField CDS FieldsUsed in Views
KEY RequestForQuotation RequestForQuotation 2
KEY RequestForQuotationItem RequestForQuotationItem 2
_BaseUnit _BaseUnit 1
_IncotermsClassification _IncotermsClassification 1
_Manufacturer _Manufacturer 1
_ManufacturerMaterial _ManufacturerMaterial 1
_Material _Material 1
_MaterialGroup _MaterialGroup 1
_OrderQuantityUnit _OrderQuantityUnit 1
_Plant _Plant 1
_ProductType _ProductType 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 1
_PurgDocumentItemCategory _PurgDocumentItemCategory 1
BaseUnit BaseUnit 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IsInfoRecordUpdated PurchasingInfoRecordUpdateCode 1
IsStatisticalItem IsStatisticalItem 1
ManualDeliveryAddressID ManualDeliveryAddressID 1
Manufacturer Manufacturer 1
ManufacturerMaterial ManufacturerMaterial 1
ManufacturerPartNmbr ManufacturerPartNmbr 1
Material Material 2
MaterialGroup MaterialGroup 2
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 1
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 1
OrderQuantityUnit OrderQuantityUnit 2
Plant Plant 2
ProductType ProductType 1
PurchaseRequisition PurchaseRequisition 2
PurchaseRequisitionItem PurchaseRequisitionItem 2
PurchasingDocumentCategory PurchasingDocumentCategory 1
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 1
PurchasingDocumentItemText PurchasingDocumentItemText 1
PurchasingParentItem PurchasingParentItem 1
PurgConfigurableItemNumber PurgConfigurableItemNumber 1
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory 1
PurgExternalSortNumber PurgExternalSortNumber 1
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Request For Quotation Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REQUESTFORQUOTATIONITEM (
    REQUESTFORQUOTATION,
    REQUESTFORQUOTATIONITEM,
    _BASEUNIT,
    _INCOTERMSCLASSIFICATION,
    _MANUFACTURER,
    _MANUFACTURERMATERIAL,
    _MATERIAL,
    _MATERIALGROUP,
    _ORDERQUANTITYUNIT,
    _PLANT,
    _PRODUCTTYPE,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURGDOCUMENTITEMCATEGORY,
    BASEUNIT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    ISINFORECORDUPDATED,
    ISSTATISTICALITEM,
    MANUALDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALGROUP,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERQUANTITYUNIT,
    PLANT,
    PRODUCTTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGPARENTITEM,
    PURGCONFIGURABLEITEMNUMBER,
    PURGDOCAGGRGDSUBITEMCATEGORY,
    PURGEXTERNALSORTNUMBER,
    REFERENCEDELIVERYADDRESSID,
    PRIMARY KEY (REQUESTFORQUOTATION, REQUESTFORQUOTATIONITEM)
);

Learn More