I_REQUESTFORQUOTATIONENHANCED

CDS View
55 Fields 7 CDS Views

Request For Quotation Enhanced

I_REQUESTFORQUOTATIONENHANCED is a CDS View in S/4HANA. Request For Quotation Enhanced. It contains 55 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_RequestForQuotation view from COMPOSITE Request for Quotation
C_Arberp_Qteqout_Rfq view from CONSUMPTION Consumption view Request for Quotation
C_RequestForQuotationFacet view from CONSUMPTION Request for Quotation Facet
C_RFQMonitor_Ovp view from CONSUMPTION RFQ Monitor OVP
I_RequestForQuotationEnhWD view from TRANSACTIONAL Request For Quotation Enhanced
I_RFQMailParameter view from COMPOSITE Parameters for Request For Quotation Email Template
R_RequestForQuotationTP view_entity from TRANSACTIONAL Request For Quotation

Fields (55)

KeyField CDS FieldsUsed in Views
KEY RequestForQuotation RequestForQuotation 5
_CompanyCode _CompanyCode 2
_CreatedByUser _CreatedByUser 1
_DocumentCurrency _DocumentCurrency 2
_FollowOnDocumentCategory _FollowOnDocumentCategory 1
_FollowOnDocumentType _FollowOnDocumentType 1
_IncotermsClassification _IncotermsClassification 2
_IncotermsVersion _IncotermsVersion 1
_Language _Language 1
_PaymentTerms _PaymentTerms 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 2
_PurchasingDocumentType _PurchasingDocumentType 3
_PurchasingGroup _PurchasingGroup 3
_PurchasingOrganization _PurchasingOrganization 3
_RequestForQuotationItem _RequestForQuotationItem 1
_RFQBidder _RFQBidder 1
_RFQLifecycleStatus _RFQLifecycleStatus 1
_RFQType _RFQType 1
_SupplierQuotation _SupplierQuotation 1
BindingPeriodValidityEndDate BindingPeriodValidityEndDate 3
CashDiscount1Days CashDiscount1Days 3
CashDiscount1Percent CashDiscount1Percent 3
CashDiscount2Days CashDiscount2Days 3
CashDiscount2Percent CashDiscount2Percent 3
CompanyCode CompanyCode 4
CorrespncInternalReference CorrespncInternalReference 2
CreatedByUser CreatedByUser 3
CreationDate CreationDate 3
DocumentCurrency DocumentCurrency 3
FollowOnDocumentCategory FollowOnDocumentCategory 2
FollowOnDocumentType FollowOnDocumentType 2
IncotermsClassification IncotermsClassification 3
IncotermsLocation1 IncotermsLocation1 3
IncotermsLocation2 IncotermsLocation2 3
IncotermsTransferLocation IncotermsTransferLocation 3
IncotermsVersion IncotermsVersion 3
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 5
Language Language 3
LastChangeDateTime LastChangeDateTime 2
LatestRegistrationDate LatestRegistrationDate 2
NetPaymentDays NetPaymentDays 3
PaymentTerms PaymentTerms 3
PurchasingDocumentCategory PurchasingDocumentCategory,RFQCategory 4
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentType PurchasingDocumentType,RFQType 5
PurchasingGroup PurchasingGroup 5
PurchasingOrganization PurchasingOrganization 5
PurContrValidityEndDate PurContrValidityEndDate 1
PurContrValidityStartDate PurContrValidityStartDate 1
QuotationEarliestSubmsnDate QuotationEarliestSubmsnDate 2
QuotationLatestSubmissionDate QuotationLatestSubmissionDate 4
RequestForQuotationName RequestForQuotationName 4
RFQLifecycleStatus RFQLifecycleStatus 3
RFQPublishingDate RFQPublishingDate 4
TargetAmount TargetAmount 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 Enhanced
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REQUESTFORQUOTATIONENHANCED (
    REQUESTFORQUOTATION,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _FOLLOWONDOCUMENTCATEGORY,
    _FOLLOWONDOCUMENTTYPE,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _LANGUAGE,
    _PAYMENTTERMS,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURCHASINGDOCUMENTTYPE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _REQUESTFORQUOTATIONITEM,
    _RFQBIDDER,
    _RFQLIFECYCLESTATUS,
    _RFQTYPE,
    _SUPPLIERQUOTATION,
    BINDINGPERIODVALIDITYENDDATE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    FOLLOWONDOCUMENTCATEGORY,
    FOLLOWONDOCUMENTTYPE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    ISENDOFPURPOSEBLOCKED,
    LANGUAGE,
    LASTCHANGEDATETIME,
    LATESTREGISTRATIONDATE,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCONTRVALIDITYENDDATE,
    PURCONTRVALIDITYSTARTDATE,
    QUOTATIONEARLIESTSUBMSNDATE,
    QUOTATIONLATESTSUBMISSIONDATE,
    REQUESTFORQUOTATIONNAME,
    RFQLIFECYCLESTATUS,
    RFQPUBLISHINGDATE,
    TARGETAMOUNT,
    PRIMARY KEY (REQUESTFORQUOTATION)
);

Learn More