I_RFQCompareTP

DDL: I_RFQCOMPARETP SQL: IRFQCOMPARETP Type: view TRANSACTIONAL Package: APPL_MM_PUR_QTN_COMPARE_SD

Request For Quotation for Comparison

I_RFQCompareTP is a Transactional CDS View that provides data about "Request For Quotation for Comparison" in SAP S/4HANA. It reads from 1 data source (I_RequestForQuotation) and exposes 18 fields with key field RequestForQuotation. It has 1 association to related views. Part of development package APPL_MM_PUR_QTN_COMPARE_SD.

Data Sources (1)

SourceAliasJoin Type
I_RequestForQuotation I_RequestForQuotation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SupplierQuotationCompareTP _SupplierQuotationCompare $projection.RequestForQuotation = _SupplierQuotationCompare.RequestForQuotation

Annotations (18)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey RequestForQuotation view
ObjectModel.semanticKey RequestForQuotation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.compositionRoot true view
ObjectModel.draftEnabled true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence MMRFQCOMP_D view
EndUserText.label Request For Quotation for Comparison view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName IRFQCOMPARETP view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY RequestForQuotation RequestForQuotation
RequestForQuotationName RequestForQuotationName
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
CreatedByUser CreatedByUser
CreationDate CreationDate
RFQPublishingDate RFQPublishingDate
QuotationLatestSubmissionDate QuotationLatestSubmissionDate
RFQLifecycleStatus RFQLifecycleStatus
PurchasingDocument RequestForQuotation
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
_SupplierQuotationCompare _SupplierQuotationCompare
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingOrganization _PurchasingOrganization
_PurchasingGroup _PurchasingGroup
_RFQLifecycleStatus _RFQLifecycleStatus
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel: {
                representativeKey: 'RequestForQuotation',
                semanticKey: 'RequestForQuotation',
                usageType.dataClass: #TRANSACTIONAL,
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #L,

                compositionRoot: true,
                draftEnabled: true,
                transactionalProcessingEnabled: true,

                createEnabled: true,
                updateEnabled: true,
                deleteEnabled: true,

                writeDraftPersistence: 'MMRFQCOMP_D'
              }
@EndUserText.label: 'Request For Quotation for Comparison'
@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'IRFQCOMPARETP'

//@AccessControl.privilegedAssociations: [ '_ContactCard' ]


define view I_RFQCompareTP
  as select from I_RequestForQuotation

  association [0..*] to I_SupplierQuotationCompareTP as _SupplierQuotationCompare on $projection.RequestForQuotation = _SupplierQuotationCompare.RequestForQuotation

{

  key RequestForQuotation,

      RequestForQuotationName,

      @ObjectModel: { readOnly: true}
      PurchasingDocumentCategory,

      @ObjectModel: { readOnly: true }
      PurchasingDocumentType,

      @ObjectModel: { readOnly: true }
      CreatedByUser,

      @ObjectModel: { readOnly: true }
      CreationDate,

      @ObjectModel: { readOnly: true }
      RFQPublishingDate,

      @ObjectModel: { readOnly: true }
      QuotationLatestSubmissionDate,

      @ObjectModel: { readOnly: true }
      RFQLifecycleStatus,

      RequestForQuotation                                           as PurchasingDocument,

      //DCL

      @UI.hidden: true
      PurchasingOrganization,
      @UI.hidden: true
      PurchasingGroup,
      @UI.hidden: true
      IsEndOfPurposeBlocked,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _SupplierQuotationCompare,

      _PurchasingDocumentCategory,
      _PurchasingOrganization,
      _PurchasingGroup,
      _RFQLifecycleStatus

}