R_CentralReqForQuotationItemTP

DDL: R_CENTRALREQFORQUOTATIONITEMTP Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
R_CentralReqForQuotationItem R_CentralReqForQuotationItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] E_PurchasingDocumentItem _ItemExtension $projection.CentralRequestForQuotation = _ItemExtension.PurchasingDocument and $projection.CentralRequestForQuotationItem = _ItemExtension.PurchasingDocumentItem
[0..*] R_CentralRFQItemDistributionTP _CentralRFQItemDistribution

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/