R_CentralReqForQuotationItemTP
Central Request for Quotation Item
R_CentralReqForQuotationItemTP is a Transactional CDS View that provides data about "Central Request for Quotation Item" in SAP S/4HANA. It reads from 1 data source (R_CentralReqForQuotationItem) and exposes 47 fields with key fields CentralRequestForQuotation, CentralRequestForQuotationItem. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_CentralReqForQuotationItem | R_CentralReqForQuotationItem | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_PurchasingDocumentItem | _ItemExtension | $projection.CentralRequestForQuotation = _ItemExtension.PurchasingDocument and $projection.CentralRequestForQuotationItem = _ItemExtension.PurchasingDocumentItem |
| [0..*] | R_CentralRFQItemDistributionTP | _CentralRFQItemDistribution | |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| EndUserText.label | Central Request for Quotation Item | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.representativeKey | CentralRequestForQuotationItem | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (47)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CentralRequestForQuotation | CentralRequestForQuotation | ||
| KEY | CentralRequestForQuotationItem | CentralRequestForQuotationItem | ||
| PurchasingDocumentCategory | PurchasingDocumentCategory | |||
| PurchasingDocumentItemText | PurchasingDocumentItemText | |||
| ProductTypeCode | ProductTypeCode | |||
| ManufacturerMaterial | ManufacturerMaterial | |||
| ManufacturerPartNmbr | ManufacturerPartNmbr | |||
| Manufacturer | Manufacturer | |||
| MaterialGroup | MaterialGroup | |||
| Plant | Plant | |||
| ManualDeliveryAddressID | ManualDeliveryAddressID | |||
| ReferenceDeliveryAddressID | ReferenceDeliveryAddressID | |||
| AddressID | AddressID | |||
| ItemDeliveryAddressID | ItemDeliveryAddressID | |||
| IncotermsClassification | IncotermsClassification | |||
| IncotermsTransferLocation | IncotermsTransferLocation | |||
| IncotermsLocation1 | IncotermsLocation1 | |||
| IncotermsLocation2 | IncotermsLocation2 | |||
| ScheduleLineOrderQuantity | _CntrlReqForQtanScheduleLine | ScheduleLineOrderQuantity | ||
| ScheduleLineDeliveryDate | _CntrlReqForQtanScheduleLine | ScheduleLineDeliveryDate | ||
| PerformancePeriodStartDate | _CntrlReqForQtanScheduleLine | PerformancePeriodStartDate | ||
| PerformancePeriodEndDate | _CntrlReqForQtanScheduleLine | PerformancePeriodEndDate | ||
| OrderQuantityUnit | OrderQuantityUnit | |||
| OrderItemQtyToBaseQtyNmrtr | OrderItemQtyToBaseQtyNmrtr | |||
| OrderItemQtyToBaseQtyDnmntr | OrderItemQtyToBaseQtyDnmntr | |||
| OrderPriceUnitToOrderUnitNmrtr | OrderPriceUnitToOrderUnitNmrtr | |||
| OrdPriceUnitToOrderUnitDnmntr | OrdPriceUnitToOrderUnitDnmntr | |||
| BaseUnit | BaseUnit | |||
| PurchaseRequisition | PurchaseRequisition | |||
| PurchaseRequisitionItem | PurchaseRequisitionItem | |||
| RequirementTracking | RequirementTracking | |||
| PurchasingCentralMaterial | PurchasingCentralMaterial | |||
| PurchasingDocumentItemCategory | PurchasingDocumentItemCategory | |||
| DocumentCurrency | DocumentCurrency | |||
| LastChangeDateTime | _CentralRequestForQuotation | LastChangeDateTime | ||
| _CentralRequestForQuotation | _CentralRequestForQuotation | |||
| _CentralRFQItemDistribution | _CentralRFQItemDistribution | |||
| _IncotermsClassification | _IncotermsClassification | |||
| _OrderQuantityUnit | _OrderQuantityUnit | |||
| _Plant | _Plant | |||
| _PurchasingDocumentCategory | _PurchasingDocumentCategory | |||
| _CntrlReqForQtanScheduleLine | _CntrlReqForQtanScheduleLine | |||
| _MaterialGroup | _MaterialGroup | |||
| _ManufacturerMaterial | _ManufacturerMaterial | |||
| _PurgDocumentItemCategory | _PurgDocumentItemCategory | |||
| _BaseUnit | _BaseUnit | |||
| _Manufacturer | _Manufacturer |
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Central Request for Quotation Item'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel.semanticKey: [ 'CentralRequestForQuotation', 'CentralRequestForQuotationItem' ]
@ObjectModel.representativeKey: 'CentralRequestForQuotationItem'
@ObjectModel: {
usageType: {
sizeCategory: #L,
serviceQuality: #C,
dataClass: #MIXED
}
}
@Metadata.ignorePropagatedAnnotations: true
define view entity R_CentralReqForQuotationItemTP
as select from R_CentralReqForQuotationItem
association to parent R_CentralRequestForQuotationTP as _CentralRequestForQuotation on $projection.CentralRequestForQuotation = _CentralRequestForQuotation.CentralRequestForQuotation
composition [0..*] of R_CentralRFQItemDistributionTP as _CentralRFQItemDistribution
---- Extension Association
association [0..1] to E_PurchasingDocumentItem as _ItemExtension on $projection.CentralRequestForQuotation = _ItemExtension.PurchasingDocument
and $projection.CentralRequestForQuotationItem = _ItemExtension.PurchasingDocumentItem
{
@ObjectModel.foreignKey.association: '_CentralRequestForQuotation'
key CentralRequestForQuotation,
key CentralRequestForQuotationItem,
@ObjectModel: { foreignKey.association: '_PurchasingDocumentCategory' }
PurchasingDocumentCategory,
PurchasingDocumentItemText,
ProductTypeCode,
ManufacturerMaterial,
ManufacturerPartNmbr,
Manufacturer,
MaterialGroup,
@ObjectModel: { foreignKey.association: '_Plant' }
Plant,
ManualDeliveryAddressID,
ReferenceDeliveryAddressID,
AddressID,
ItemDeliveryAddressID,
@ObjectModel: { foreignKey.association: '_IncotermsClassification' }
IncotermsClassification,
IncotermsTransferLocation,
IncotermsLocation1,
IncotermsLocation2,
@Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
_CntrlReqForQtanScheduleLine.ScheduleLineOrderQuantity,
_CntrlReqForQtanScheduleLine.ScheduleLineDeliveryDate,
_CntrlReqForQtanScheduleLine.PerformancePeriodStartDate,
_CntrlReqForQtanScheduleLine.PerformancePeriodEndDate,
@ObjectModel: { foreignKey.association: '_OrderQuantityUnit' }
OrderQuantityUnit,
OrderItemQtyToBaseQtyNmrtr,
OrderItemQtyToBaseQtyDnmntr,
OrderPriceUnitToOrderUnitNmrtr,
OrdPriceUnitToOrderUnitDnmntr,
BaseUnit,
PurchaseRequisition,
PurchaseRequisitionItem,
RequirementTracking,
PurchasingCentralMaterial,
PurchasingDocumentItemCategory,
DocumentCurrency,
@Semantics.systemDateTime.lastChangedAt: true
_CentralRequestForQuotation.LastChangeDateTime as LastChangeDateTime,
/* Associations */
_CentralRequestForQuotation,
_CentralRFQItemDistribution,
_IncotermsClassification,
_OrderQuantityUnit,
_Plant,
_PurchasingDocumentCategory,
_CntrlReqForQtanScheduleLine,
_MaterialGroup,
_ManufacturerMaterial,
_PurgDocumentItemCategory,
_BaseUnit,
_Manufacturer
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CENTRALREQFORQUOTATIONITEM",
"R_CENTRALREQUESTFORQUOTATIONTP",
"R_CNTRLREQFORQTANSCHEDULELINE"
],
"ASSOCIATED":
[
"I_INCOTERMSCLASSIFICATION",
"I_MATERIAL",
"I_MATERIALGROUP",
"I_PLANT",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURGDOCUMENTITEMCATEGORY",
"I_SUPPLIER",
"I_UNITOFMEASURE",
"R_CENTRALREQUESTFORQUOTATIONTP",
"R_CENTRALRFQITEMDISTRIBUTIONTP",
"R_CNTRLREQFORQTANSCHEDULELINE"
],
"BASE":
[
"R_CENTRALREQFORQUOTATIONITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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