R_CENTRALREQUESTFORQUOTATION

CDS View
52 Fields 9 CDS Views

Restricted View for Central Request For Quotation Header

R_CENTRALREQUESTFORQUOTATION is a CDS View in S/4HANA. Restricted View for Central Request For Quotation Header. It contains 52 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_CentralRequestForQuotationVH view from CONSUMPTION Central Request For Quotation Value Help
C_CntrlReqForQtnProcessFlow view from CONSUMPTION CentralRequestForQuotation Process Flow
C_CntrlReqForQtnProcessFlow view union_all CONSUMPTION CentralRequestForQuotation Process Flow
C_CntrlRequestForQuotationInfo view from CONSUMPTION Consumption View for Central Request for Quotation Info
ESH_N_CNTRLREQUESTFORQUOTATION view from
I_CentralRequestForQuotation view from BASIC Central Request For Quotation Header
I_CentralRequestForQuotationTP view from TRANSACTIONAL Transactional processing view for Central RFQ Header
R_CentralRequestForQuotationTP view_entity from TRANSACTIONAL Central Request for Quotation
R_CntrlReqForQtanScheduleLine view inner BASIC Restricted View for Central RFQ Item Schedule Line

Fields (52)

KeyField CDS FieldsUsed in Views
KEY CentralRequestForQuotation CentralRequestForQuotation 4
_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 2
_PurchasingGroup _PurchasingGroup 1
_PurchasingOrganization _PurchasingOrganization 1
_RFQLifecycleStatus _RFQLifecycleStatus 1
_RFQType _RFQType 1
BindingPeriodValidityEndDate BindingPeriodValidityEndDate 1
CashDiscount1Days CashDiscount1Days 1
CashDiscount1Percent CashDiscount1Percent 1
CashDiscount2Days CashDiscount2Days 1
CashDiscount2Percent CashDiscount2Percent 1
CompanyCode CompanyCode 1
CorrespncInternalReference CorrespncInternalReference 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 1
DocumentCurrency DocumentCurrency 1
FollowOnDocumentCategory FollowOnDocumentCategory 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsTransferLocation IncotermsTransferLocation 1
IncotermsVersion IncotermsVersion 1
IsEndOfPurposeBlocked IsEndOfPurposeBlocked 3
Language Language 1
LastChangeDateTime LastChangeDateTime 1
LatestRegistrationDate LatestRegistrationDate 1
NetPaymentDays NetPaymentDays 1
PaymentTerms PaymentTerms 1
PurchasingDocumentCategory PurchasingDocumentCategory,RFQCategory 3
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode 1
PurchasingDocumentType PurchasingDocumentType,RFQType 4
PurchasingGroup PurchasingGroup 3
PurchasingOrganization PurchasingOrganization 3
PurContrValidityEndDate PurContrValidityEndDate 1
PurContrValidityStartDate PurContrValidityStartDate 1
PurgDocFollowOnDocumentType FollowOnDocumentType 1
QuotationEarliestSubmsnDate QuotationEarliestSubmsnDate 1
QuotationLatestSubmissionDate QuotationLatestSubmissionDate 2
RequestForQuotationName RequestForQuotationName 3
RFQLifecycleStatus RFQLifecycleStatus 2
RFQPublishingDate RFQPublishingDate 2
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.

-- Restricted View for Central Request For Quotation Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_CENTRALREQUESTFORQUOTATION (
    CENTRALREQUESTFORQUOTATION,
    _COMPANYCODE,
    _CREATEDBYUSER,
    _DOCUMENTCURRENCY,
    _FOLLOWONDOCUMENTCATEGORY,
    _FOLLOWONDOCUMENTTYPE,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _LANGUAGE,
    _PAYMENTTERMS,
    _PURCHASINGDOCUMENTCATEGORY,
    _PURCHASINGDOCUMENTTYPE,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _RFQLIFECYCLESTATUS,
    _RFQTYPE,
    BINDINGPERIODVALIDITYENDDATE,
    CASHDISCOUNT1DAYS,
    CASHDISCOUNT1PERCENT,
    CASHDISCOUNT2DAYS,
    CASHDISCOUNT2PERCENT,
    COMPANYCODE,
    CORRESPNCINTERNALREFERENCE,
    CREATEDBYUSER,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    FOLLOWONDOCUMENTCATEGORY,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    ISENDOFPURPOSEBLOCKED,
    LANGUAGE,
    LASTCHANGEDATETIME,
    LATESTREGISTRATIONDATE,
    NETPAYMENTDAYS,
    PAYMENTTERMS,
    PURCHASINGDOCUMENTCATEGORY,
    PURCHASINGDOCUMENTDELETIONCODE,
    PURCHASINGDOCUMENTTYPE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    PURCONTRVALIDITYENDDATE,
    PURCONTRVALIDITYSTARTDATE,
    PURGDOCFOLLOWONDOCUMENTTYPE,
    QUOTATIONEARLIESTSUBMSNDATE,
    QUOTATIONLATESTSUBMISSIONDATE,
    REQUESTFORQUOTATIONNAME,
    RFQLIFECYCLESTATUS,
    RFQPUBLISHINGDATE,
    TARGETAMOUNT,
    PRIMARY KEY (CENTRALREQUESTFORQUOTATION)
);

Learn More