I_RFQITEMENHANCED

CDS View
48 Fields 5 CDS Views

Request For Quotation Item Enhanced

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_RequestForQuotationItem view from COMPOSITE Item
C_Arberp_Qteqout_Rfq_Item view from CONSUMPTION Consumition view for Request for Quotation item
C_RFQItemFacet view from CONSUMPTION Request for Quotation Item Facet
I_RFQItemEnhWD view from TRANSACTIONAL Request For Quotation Item Enhanced
R_RequestForQuotationItemTP view_entity from TRANSACTIONAL Request For Quotation Item

Fields (48)

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

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 Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_RFQITEMENHANCED (
    REQUESTFORQUOTATION,
    REQUESTFORQUOTATIONITEM,
    _BASEUNIT,
    _INCOTERMSCLASSIFICATION,
    _MANUFACTURER,
    _MANUFACTURERMATERIAL,
    _MATERIAL,
    _MATERIALGROUP,
    _ORDERQUANTITYUNIT,
    _PLANT,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURGDOCUMENTITEMCATEGORY,
    _REQUESTFORQUOTATION,
    ADDRESSID,
    BASEUNIT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    ISINFORECORDUPDATED,
    ISSTATISTICALITEM,
    ITEMDELIVERYADDRESSID,
    MANUALDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALGROUP,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERQUANTITYUNIT,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PLANT,
    PRODUCTTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGINFORECORDUPDATECODE,
    PURCHASINGPARENTITEM,
    PURGCONFIGURABLEITEMNUMBER,
    PURGDOCAGGRGDSUBITEMCATEGORY,
    PURGEXTERNALSORTNUMBER,
    REFERENCEDELIVERYADDRESSID,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEORDERQUANTITY,
    PRIMARY KEY (REQUESTFORQUOTATION, REQUESTFORQUOTATIONITEM)
);

Learn More