I_REQUESTFORQUOTATIONENHWD
Request For Quotation Enhanced
I_REQUESTFORQUOTATIONENHWD is a CDS View in S/4HANA. Request For Quotation Enhanced. It contains 51 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_RequestForQuotationEnhWD | view | from | CONSUMPTION | Request For Quotation |
Fields (51)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | RequestForQuotation | RequestForQuotation | 1 |
| _CompanyCode | _CompanyCode | 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 | 1 | |
| _PurchasingOrganization | _PurchasingOrganization | 1 | |
| _RFQLifecycleStatus | _RFQLifecycleStatus | 1 | |
| BindingPeriodValidityEndDate | BindingPeriodValidityEndDate | 1 | |
| CashDiscount1Days | CashDiscount1Days | 1 | |
| CashDiscount1Percent | CashDiscount1Percent | 1 | |
| CashDiscount2Days | CashDiscount2Days | 1 | |
| CashDiscount2Percent | CashDiscount2Percent | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CorrespncInternalReference | CorrespncInternalReference | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreationDate | CreationDate | 1 | |
| DocumentCurrency | DocumentCurrency | 1 | |
| FollowOnDocumentCategory | FollowOnDocumentCategory | 1 | |
| FollowOnDocumentType | FollowOnDocumentType | 1 | |
| IncotermsClassification | IncotermsClassification | 1 | |
| IncotermsLocation1 | IncotermsLocation1 | 1 | |
| IncotermsLocation2 | IncotermsLocation2 | 1 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 1 | |
| IncotermsVersion | IncotermsVersion | 1 | |
| IsEndOfPurposeBlocked | IsEndOfPurposeBlocked | 1 | |
| Language | Language | 1 | |
| LastChangeDateTime | LastChangeDateTime | 1 | |
| LatestRegistrationDate | LatestRegistrationDate | 1 | |
| NetPaymentDays | NetPaymentDays | 1 | |
| PaymentTerms | PaymentTerms | 1 | |
| PurchasingDocumentCategory | PurchasingDocumentCategory | 1 | |
| PurchasingDocumentType | PurchasingDocumentType | 1 | |
| PurchasingGroup | PurchasingGroup | 1 | |
| PurchasingItemHasHierarchy | PurchasingItemHasHierarchy | 1 | |
| PurchasingOrganization | PurchasingOrganization | 1 | |
| PurContrValidityEndDate | PurContrValidityEndDate | 1 | |
| PurContrValidityStartDate | PurContrValidityStartDate | 1 | |
| QuotationEarliestSubmsnDate | QuotationEarliestSubmsnDate | 1 | |
| QuotationLatestSubmissionDate | QuotationLatestSubmissionDate | 1 | |
| RequestForQuotationName | RequestForQuotationName | 1 | |
| RFQLifecycleStatus | RFQLifecycleStatus | 1 | |
| RFQPublishingDate | RFQPublishingDate | 1 | |
| ScenarioIsRelevantForHierarchy | ScenarioIsRelevantForHierarchy | 1 | |
| 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_REQUESTFORQUOTATIONENHWD (
REQUESTFORQUOTATION,
_COMPANYCODE,
_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,
PURCHASINGDOCUMENTCATEGORY,
PURCHASINGDOCUMENTTYPE,
PURCHASINGGROUP,
PURCHASINGITEMHASHIERARCHY,
PURCHASINGORGANIZATION,
PURCONTRVALIDITYENDDATE,
PURCONTRVALIDITYSTARTDATE,
QUOTATIONEARLIESTSUBMSNDATE,
QUOTATIONLATESTSUBMISSIONDATE,
REQUESTFORQUOTATIONNAME,
RFQLIFECYCLESTATUS,
RFQPUBLISHINGDATE,
SCENARIOISRELEVANTFORHIERARCHY,
TARGETAMOUNT,
PRIMARY KEY (REQUESTFORQUOTATION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA