I_REQUESTFORQUOTATION

CDS View
51 Fields 15 CDS Views

Request For Quotation

I_REQUESTFORQUOTATION is a CDS View in S/4HANA. Request For Quotation. It contains 51 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
C_RFQLowNumberOfQtn view from CONSUMPTION Situation for low number of Quotations
C_RFQProcessFlow view from CONSUMPTION RFQ Process Flow
C_RFQProcessFlow view union_all CONSUMPTION RFQ Process Flow
C_RFQValueHelp view from CONSUMPTION Request for Quotation Value Help
C_SuplrQtnComparisonChart view from CONSUMPTION Supplier Quotation Comparison Chart
ESH_N_REQUESTFORQUOTATION view from
I_Requestforquotation_Api01 view from BASIC Request for Quotation
I_RequestForQuotationEnhanced view from COMPOSITE Request For Quotation Enhanced
I_RequestForQuotationStdVH view from COMPOSITE Request For Quotation
I_RFQBidder view inner BASIC Request For Quotation Bidder
I_RFQCompareTP view from TRANSACTIONAL Request For Quotation for Comparison
I_RFQMailParamSecureBidding view from BASIC Parameters for RFQ Email Template for Secure Bidding
P_RFQEventTypes view from CONSUMPTION RFQ based on Purchasing Document Type
P_RFQEventTypes view union_all CONSUMPTION RFQ based on Purchasing Document Type
R_RFQBidder view inner BASIC Request For Quotation Bidder

Fields (51)

KeyField CDS FieldsUsed in Views
KEY PurchasingDocumentCategory PrecedingDocumentCategory,PurchasingDocumentCategory,RFQCategory 4
KEY RequestForQuotation RequestForQuotation 5
_CompanyCode _CompanyCode 1
_CreatedByUser _CreatedByUser 1
_DocumentCurrency _DocumentCurrency 1
_FollowOnDocumentCategory _FollowOnDocumentCategory 1
_FollowOnDocumentType _FollowOnDocumentType 1
_IncotermsClassification _IncotermsClassification 1
_IncotermsVersion _IncotermsVersion 1
_Language _Language 1
_PaymentTerms _PaymentTerms 1
_PurchasingDocumentCategory _PurchasingDocumentCategory 1
_PurchasingDocumentType _PurchasingDocumentType 1
_PurchasingGroup _PurchasingGroup 2
_PurchasingOrganization _PurchasingOrganization 2
_RFQLifecycleStatus _RFQLifecycleStatus 1
BindingPeriodValidityEndDate BindingPeriodValidityEndDate 2
CashDiscount1Days CashDiscount1Days 2
CashDiscount1Percent CashDiscount1Percent 2
CashDiscount2Days CashDiscount2Days 2
CashDiscount2Percent CashDiscount2Percent 2
CompanyCode CompanyCode 3
CorrespncInternalReference CorrespncInternalReference 2
CreatedByUser CreatedByUser 3
CreationDate CreationDate 2
DocumentCurrency DocumentCurrency 2
FollowOnDocumentCategory FollowOnDocumentCategory 2
FollowOnDocumentType FollowOnDocumentType 2
IncotermsClassification IncotermsClassification 2
IncotermsLocation1 IncotermsLocation1 2
IncotermsLocation2 IncotermsLocation2 2
IncotermsTransferLocation IncotermsTransferLocation 2
IncotermsVersion IncotermsVersion 2
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 5
Language Language 2
LastChangeDateTime LastChangeDateTime 2
LatestRegistrationDate LatestRegistrationDate 2
NetPaymentDays NetPaymentDays 2
PaymentTerms PaymentTerms 2
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentType PurchasingDocumentType,RFQType 6
PurchasingGroup PurchasingGroup 5
PurchasingOrganization PurchasingOrganization 5
QuotationEarliestSubmsnDate QuotationEarliestSubmsnDate 2
QuotationLatestSubmissionDate QuotationLatestSubmissionDate 3
RequestForQuotationName RequestForQuotationName 3
RFQLifecycleStatus RFQLifecycleStatus 2
RFQPublishingDate RFQPublishingDate 2
TargetAmount TargetAmount 2
ValidityEndDate PurContrValidityEndDate,ValidityEndDate 2
ValidityStartDate PurContrValidityStartDate,ValidityStartDate 2

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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_REQUESTFORQUOTATION (
    PURCHASINGDOCUMENTCATEGORY,
    REQUESTFORQUOTATION,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _FOLLOWONDOCUMENTCATEGORY,
    _FOLLOWONDOCUMENTTYPE,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _LANGUAGE,
    _PAYMENTTERMS,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURCHASINGDOCUMENTTYPE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _RFQLIFECYCLESTATUS,
    BINDINGPERIODVALIDITYENDDATE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    FOLLOWONDOCUMENTCATEGORY,
    FOLLOWONDOCUMENTTYPE,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    ISENDOFPURPOSEBLOCKED,
    LANGUAGE,
    LASTCHANGEDATETIME,
    LATESTREGISTRATIONDATE,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    QUOTATIONEARLIESTSUBMSNDATE,
    QUOTATIONLATESTSUBMISSIONDATE,
    REQUESTFORQUOTATIONNAME,
    RFQLIFECYCLESTATUS,
    RFQPUBLISHINGDATE,
    TARGETAMOUNT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (PURCHASINGDOCUMENTCATEGORY, REQUESTFORQUOTATION)
);

Learn More