I_RequestForQuotationEnhanced
Request For Quotation Enhanced
I_RequestForQuotationEnhanced is a Composite CDS View that provides data about "Request For Quotation Enhanced" in SAP S/4HANA. It reads from 1 data source (I_RequestForQuotation) and exposes 55 fields with key field RequestForQuotation. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_RequestForQuotation | I_RequestForQuotation | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..*] | I_RFQItemEnhanced | _RequestForQuotationItem | $projection.RequestForQuotation = _RequestForQuotationItem.RequestForQuotation |
| [1..*] | I_RFQBidderEnhanced | _RFQBidder | $projection.RequestForQuotation = _RFQBidder.RequestForQuotation |
| [0..*] | I_SupplierQuotationEnh | _SupplierQuotation | $projection.RequestForQuotation = _SupplierQuotation.RequestForQuotation --Extension |
| [1..1] | E_PurchasingDocument | _RequestQtnExtension | $projection.RequestForQuotation = _RequestQtnExtension .PurchasingDocument |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.modelCategory | #BUSINESS_OBJECT | view | |
| ObjectModel.representativeKey | RequestForQuotation | view | |
| ObjectModel.semanticKey | RequestForQuotation | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| EndUserText.label | Request For Quotation Enhanced | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| AbapCatalog.sqlViewName | IMMRFQENH | view |
Fields (55)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | RequestForQuotation | I_RequestForQuotation | RequestForQuotation | |
| CompanyCode | I_RequestForQuotation | CompanyCode | ||
| PurchasingDocumentCategory | I_RequestForQuotation | PurchasingDocumentCategory | ||
| PurchasingDocumentType | I_RequestForQuotation | PurchasingDocumentType | ||
| CreatedByUser | I_RequestForQuotation | CreatedByUser | ||
| CreationDate | I_RequestForQuotation | CreationDate | ||
| LastChangeDateTime | I_RequestForQuotation | LastChangeDateTime | ||
| Language | I_RequestForQuotation | Language | ||
| PurchasingOrganization | I_RequestForQuotation | PurchasingOrganization | ||
| PurchasingGroup | I_RequestForQuotation | PurchasingGroup | ||
| DocumentCurrency | I_RequestForQuotation | DocumentCurrency | ||
| IncotermsClassification | I_RequestForQuotation | IncotermsClassification | ||
| IncotermsTransferLocation | I_RequestForQuotation | IncotermsTransferLocation | ||
| IncotermsVersion | I_RequestForQuotation | IncotermsVersion | ||
| IncotermsLocation1 | I_RequestForQuotation | IncotermsLocation1 | ||
| IncotermsLocation2 | I_RequestForQuotation | IncotermsLocation2 | ||
| PaymentTerms | I_RequestForQuotation | PaymentTerms | ||
| CashDiscount1Days | I_RequestForQuotation | CashDiscount1Days | ||
| CashDiscount2Days | I_RequestForQuotation | CashDiscount2Days | ||
| CashDiscount1Percent | I_RequestForQuotation | CashDiscount1Percent | ||
| CashDiscount2Percent | I_RequestForQuotation | CashDiscount2Percent | ||
| NetPaymentDays | I_RequestForQuotation | NetPaymentDays | ||
| RFQPublishingDate | I_RequestForQuotation | RFQPublishingDate | ||
| QuotationLatestSubmissionDate | I_RequestForQuotation | QuotationLatestSubmissionDate | ||
| BindingPeriodValidityEndDate | I_RequestForQuotation | BindingPeriodValidityEndDate | ||
| TargetAmount | I_RequestForQuotation | TargetAmount | ||
| CorrespncInternalReference | I_RequestForQuotation | CorrespncInternalReference | ||
| RFQLifecycleStatus | I_RequestForQuotation | RFQLifecycleStatus | ||
| RequestForQuotationName | I_RequestForQuotation | RequestForQuotationName | ||
| QuotationEarliestSubmsnDate | I_RequestForQuotation | QuotationEarliestSubmsnDate | ||
| LatestRegistrationDate | I_RequestForQuotation | LatestRegistrationDate | ||
| FollowOnDocumentCategory | I_RequestForQuotation | FollowOnDocumentCategory | ||
| FollowOnDocumentType | I_RequestForQuotation | FollowOnDocumentType | ||
| PurContrValidityStartDate | I_RequestForQuotation | ValidityStartDate | ||
| PurContrValidityEndDate | I_RequestForQuotation | ValidityEndDate | ||
| PurchasingDocumentDeletionCode | I_RequestForQuotation | PurchasingDocumentDeletionCode | ||
| IsEndOfPurposeBlocked | I_RequestForQuotation | IsEndOfPurposeBlocked | ||
| _RequestForQuotationItem | _RequestForQuotationItem | |||
| _RFQBidder | _RFQBidder | |||
| _CompanyCode | I_RequestForQuotation | _CompanyCode | ||
| _DocumentCurrency | I_RequestForQuotation | _DocumentCurrency | ||
| _IncotermsClassification | I_RequestForQuotation | _IncotermsClassification | ||
| _IncotermsVersion | I_RequestForQuotation | _IncotermsVersion | ||
| _PaymentTerms | I_RequestForQuotation | _PaymentTerms | ||
| _PurchasingDocumentType | I_RequestForQuotation | _PurchasingDocumentType | ||
| _PurchasingGroup | I_RequestForQuotation | _PurchasingGroup | ||
| _PurchasingOrganization | I_RequestForQuotation | _PurchasingOrganization | ||
| _PurchasingDocumentCategory | I_RequestForQuotation | _PurchasingDocumentCategory | ||
| _FollowOnDocumentCategory | I_RequestForQuotation | _FollowOnDocumentCategory | ||
| _FollowOnDocumentType | I_RequestForQuotation | _FollowOnDocumentType | ||
| _CreatedByUser | I_RequestForQuotation | _CreatedByUser | ||
| _SupplierQuotation | _SupplierQuotation | |||
| _Language | I_RequestForQuotation | _Language | ||
| _RFQLifecycleStatus | I_RequestForQuotation | _RFQLifecycleStatus | ||
| _RFQType | _RFQType |
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{compositionRoot: true,
modelCategory: #BUSINESS_OBJECT,
representativeKey: 'RequestForQuotation',
semanticKey: 'RequestForQuotation',
usageType.dataClass: #TRANSACTIONAL,
usageType.serviceQuality: #B,
usageType.sizeCategory: #M
}
@EndUserText.label: 'Request For Quotation Enhanced'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'IMMRFQENH'
define view I_RequestForQuotationEnhanced
as select from I_RequestForQuotation
association [1..*] to I_RFQItemEnhanced as _RequestForQuotationItem on $projection.RequestForQuotation = _RequestForQuotationItem.RequestForQuotation
association [1..*] to I_RFQBidderEnhanced as _RFQBidder on $projection.RequestForQuotation = _RFQBidder.RequestForQuotation
association [0..*] to I_SupplierQuotationEnh as _SupplierQuotation on $projection.RequestForQuotation = _SupplierQuotation.RequestForQuotation
--Extension Association
association [1..1] to E_PurchasingDocument as _RequestQtnExtension on $projection.RequestForQuotation = _RequestQtnExtension .PurchasingDocument
{
key I_RequestForQuotation.RequestForQuotation,
I_RequestForQuotation.CompanyCode,
I_RequestForQuotation.PurchasingDocumentCategory,
I_RequestForQuotation.PurchasingDocumentType,
I_RequestForQuotation.CreatedByUser,
I_RequestForQuotation.CreationDate,
I_RequestForQuotation.LastChangeDateTime,
I_RequestForQuotation.Language,
I_RequestForQuotation.PurchasingOrganization,
I_RequestForQuotation.PurchasingGroup,
I_RequestForQuotation.DocumentCurrency,
I_RequestForQuotation.IncotermsClassification,
I_RequestForQuotation.IncotermsTransferLocation,
I_RequestForQuotation.IncotermsVersion,
I_RequestForQuotation.IncotermsLocation1,
I_RequestForQuotation.IncotermsLocation2,
I_RequestForQuotation.PaymentTerms,
I_RequestForQuotation.CashDiscount1Days,
I_RequestForQuotation.CashDiscount2Days,
I_RequestForQuotation.CashDiscount1Percent,
I_RequestForQuotation.CashDiscount2Percent,
I_RequestForQuotation.NetPaymentDays,
I_RequestForQuotation.RFQPublishingDate,
I_RequestForQuotation.QuotationLatestSubmissionDate,
I_RequestForQuotation.BindingPeriodValidityEndDate,
I_RequestForQuotation.TargetAmount,
I_RequestForQuotation.CorrespncInternalReference,
I_RequestForQuotation.RFQLifecycleStatus,
I_RequestForQuotation.RequestForQuotationName,
I_RequestForQuotation.QuotationEarliestSubmsnDate,
I_RequestForQuotation.LatestRegistrationDate,
I_RequestForQuotation.FollowOnDocumentCategory,
I_RequestForQuotation.FollowOnDocumentType,
I_RequestForQuotation.ValidityStartDate as PurContrValidityStartDate,
I_RequestForQuotation.ValidityEndDate as PurContrValidityEndDate,
I_RequestForQuotation.PurchasingDocumentDeletionCode,
I_RequestForQuotation.IsEndOfPurposeBlocked,
/* Associations */
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_RequestForQuotationItem,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_RFQBidder,
I_RequestForQuotation._CompanyCode,
I_RequestForQuotation._DocumentCurrency,
I_RequestForQuotation._IncotermsClassification,
I_RequestForQuotation._IncotermsVersion,
I_RequestForQuotation._PaymentTerms,
I_RequestForQuotation._PurchasingDocumentType,
I_RequestForQuotation._PurchasingGroup,
I_RequestForQuotation._PurchasingOrganization,
I_RequestForQuotation._PurchasingDocumentCategory,
I_RequestForQuotation._FollowOnDocumentCategory,
I_RequestForQuotation._FollowOnDocumentType,
I_RequestForQuotation._CreatedByUser,
_SupplierQuotation,
I_RequestForQuotation._Language,
I_RequestForQuotation._RFQLifecycleStatus,
_RFQType
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA