I_SUPPLIERQUOTATIONITEMENH

CDS View
52 Fields 4 CDS Views

Supplier Quotation Item Enhanced

I_SUPPLIERQUOTATIONITEMENH is a CDS View in S/4HANA. Supplier Quotation Item Enhanced. It contains 52 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_SupplierQuotationItem view from COMPOSITE Item
C_RequirementTrackingPurRFQ view left_outer CONSUMPTION RFQ by Requirement Tracking
I_SuplrQuotationItemEnhWD view from TRANSACTIONAL Supplier Quotation Item Enhanced
R_SupplierQuotationItemTP view_entity from TRANSACTIONAL Supplier Quotation Item

Fields (52)

KeyField CDS FieldsUsed in Views
KEY SupplierQuotation SupplierQuotation 4
KEY SupplierQuotationItem SupplierQuotationItem 4
AddressID AddressID 2
AwardedQuantity AwardedQuantity 3
BaseUnit BaseUnit 2
DocumentCurrency DocumentCurrency 4
EffectiveAmount EffectiveAmount 2
GrossAmount GrossAmount 2
IncotermsClassification IncotermsClassification 3
IncotermsLocation1 IncotermsLocation1 3
IncotermsLocation2 IncotermsLocation2 3
IncotermsTransferLocation IncotermsTransferLocation 3
IsInfoRecordUpdated IsInfoRecordUpdated 2
IsStatisticalItem IsStatisticalItem 1
ItemDeliveryAddressID ItemDeliveryAddressID 2
ManualDeliveryAddressID ManualDeliveryAddressID 2
Manufacturer Manufacturer 3
ManufacturerMaterial ManufacturerMaterial 3
ManufacturerPartNmbr ManufacturerPartNmbr 3
Material Material 3
MaterialGroup MaterialGroup 3
NetAmount NetAmount 3
NetPriceAmount NetPriceAmount 3
NetPriceQuantity NetPriceQuantity 3
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr 2
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr 2
OrderPriceUnit OrderPriceUnit 3
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr 3
OrderQuantityUnit OrderQuantityUnit 2
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr 3
PerformancePeriodEndDate PerformancePeriodEndDate 3
PerformancePeriodStartDate PerformancePeriodStartDate 3
Plant Plant 3
ProductType ProductType,ProductTypeCode 3
PurchaseRequisition PurchaseRequisition 3
PurchaseRequisitionItem PurchaseRequisitionItem 3
PurchasingDocumentCategory PurchasingDocumentCategory 3
PurchasingDocumentItemCategory PurchasingDocumentItemCategory 2
PurchasingDocumentItemText PurchasingDocumentItemText 3
PurchasingInfoRecord PurchasingInfoRecord 3
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode 2
PurchasingParentItem PurchasingParentItem 1
PurgConfigurableItemNumber PurgConfigurableItemNumber 1
PurgDocAggrgdSubitemCategory PurgDocAggrgdSubitemCategory 1
PurgDocPriceDate PurgDocPriceDate 2
PurgExternalSortNumber PurgExternalSortNumber 1
ReferenceDeliveryAddressID ReferenceDeliveryAddressID 2
RequestForQuotation RequestForQuotation 3
RequestForQuotationItem RequestForQuotationItem 3
ScheduleLineDeliveryDate ScheduleLineDeliveryDate 4
ScheduleLineOrderQuantity ScheduleLineOrderQuantity 3
SupplierMaterialNumber SupplierMaterialNumber 3

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.

-- Supplier Quotation Item Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUPPLIERQUOTATIONITEMENH (
    SUPPLIERQUOTATION,
    SUPPLIERQUOTATIONITEM,
    ADDRESSID,
    AWARDEDQUANTITY,
    BASEUNIT,
    DOCUMENTCURRENCY,
    EFFECTIVEAMOUNT,
    GROSSAMOUNT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    ISINFORECORDUPDATED,
    ISSTATISTICALITEM,
    ITEMDELIVERYADDRESSID,
    MANUALDELIVERYADDRESSID,
    MANUFACTURER,
    MANUFACTURERMATERIAL,
    MANUFACTURERPARTNMBR,
    MATERIAL,
    MATERIALGROUP,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    ORDERITEMQTYTOBASEQTYDNMNTR,
    ORDERITEMQTYTOBASEQTYNMRTR,
    ORDERPRICEUNIT,
    ORDERPRICEUNITTOORDERUNITNMRTR,
    ORDERQUANTITYUNIT,
    ORDPRICEUNITTOORDERUNITDNMNTR,
    PERFORMANCEPERIODENDDATE,
    PERFORMANCEPERIODSTARTDATE,
    PLANT,
    PRODUCTTYPE,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTITEMCATEGORY,
    PURCHASINGDOCUMENTITEMTEXT,
    PURCHASINGINFORECORD,
    PURCHASINGINFORECORDUPDATECODE,
    PURCHASINGPARENTITEM,
    PURGCONFIGURABLEITEMNUMBER,
    PURGDOCAGGRGDSUBITEMCATEGORY,
    PURGDOCPRICEDATE,
    PURGEXTERNALSORTNUMBER,
    REFERENCEDELIVERYADDRESSID,
    REQUESTFORQUOTATION,
    REQUESTFORQUOTATIONITEM,
    SCHEDULELINEDELIVERYDATE,
    SCHEDULELINEORDERQUANTITY,
    SUPPLIERMATERIALNUMBER,
    PRIMARY KEY (SUPPLIERQUOTATION, SUPPLIERQUOTATIONITEM)
);

Learn More