R_CentralRequestForQuotationTP

DDL: R_CENTRALREQUESTFORQUOTATIONTP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_CRFQ

Central Request for Quotation

R_CentralRequestForQuotationTP is a Transactional CDS View that provides data about "Central Request for Quotation" in SAP S/4HANA. It reads from 1 data source (R_CentralRequestForQuotation) and exposes 50 fields with key field CentralRequestForQuotation. It has 3 associations to related views. Part of development package RAP_MM_PUR_CRFQ.

Data Sources (1)

SourceAliasJoin Type
R_CentralRequestForQuotation R_CentralRequestForQuotation from

Associations (3)

CardinalityTargetAliasCondition
[0..1] E_PurchasingDocument _CentralReqForQuotationExtn _CentralReqForQuotationExtn.PurchasingDocument = $projection.CentralRequestForQuotation
[1..*] R_CentralReqForQuotationItemTP _CentralReqForQuotationItem
[1..*] R_CntrlReqForQuotationBidderTP _CntrlReqForQuotationBidder

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Central Request for Quotation view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name CentralRequestForQuotation view
ObjectModel.representativeKey CentralRequestForQuotation view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY CentralRequestForQuotation CentralRequestForQuotation
CompanyCode CompanyCode
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangeDateTime LastChangeDateTime
Language Language
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
DocumentCurrency DocumentCurrency
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
IncotermsVersion IncotermsVersion
IncotermsLocation1 IncotermsLocation1
IncotermsLocation2 IncotermsLocation2
PaymentTerms PaymentTerms
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
NetPaymentDays NetPaymentDays
RFQPublishingDate RFQPublishingDate
QuotationLatestSubmissionDate QuotationLatestSubmissionDate
BindingPeriodValidityEndDate BindingPeriodValidityEndDate
TargetAmount TargetAmount
RFQLifecycleStatus RFQLifecycleStatus
RequestForQuotationName RequestForQuotationName
QuotationEarliestSubmsnDate QuotationEarliestSubmsnDate
LatestRegistrationDate LatestRegistrationDate
CorrespncInternalReference CorrespncInternalReference
FollowOnDocumentCategory FollowOnDocumentCategory
PurgDocFollowOnDocumentType PurgDocFollowOnDocumentType
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
PurContrValidityStartDate PurContrValidityStartDate
PurContrValidityEndDate PurContrValidityEndDate
_CentralReqForQuotationItem _CentralReqForQuotationItem
_CntrlReqForQuotationBidder _CntrlReqForQuotationBidder
_CompanyCode _CompanyCode
_DocumentCurrency _DocumentCurrency
_FollowOnDocumentCategory _FollowOnDocumentCategory
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion
_PaymentTerms _PaymentTerms
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_RFQLifecycleStatus _RFQLifecycleStatus
_RFQType _RFQType
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Central Request for Quotation'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.sapObjectNodeType.name: 'CentralRequestForQuotation'
@ObjectModel.semanticKey:  [ 'CentralRequestForQuotation' ]
@ObjectModel.representativeKey: 'CentralRequestForQuotation'
@ObjectModel: {
    usageType: {
      sizeCategory: #M,
      serviceQuality: #A,
      dataClass: #TRANSACTIONAL
    }
  }

@Metadata.ignorePropagatedAnnotations: true

define root view entity R_CentralRequestForQuotationTP
  as select from R_CentralRequestForQuotation

  composition [1..*] of R_CentralReqForQuotationItemTP as _CentralReqForQuotationItem

  composition [1..*] of R_CntrlReqForQuotationBidderTP as _CntrlReqForQuotationBidder

  ----Extension Association
  association [0..1] to E_PurchasingDocument           as _CentralReqForQuotationExtn on _CentralReqForQuotationExtn.PurchasingDocument = $projection.CentralRequestForQuotation

{

  key CentralRequestForQuotation,

      @ObjectModel: { foreignKey.association: '_CompanyCode'}
      CompanyCode,

      @ObjectModel: {foreignKey.association: '_PurchasingDocumentCategory' }
      PurchasingDocumentCategory,

      @ObjectModel: {foreignKey.association: '_RFQType' }
      PurchasingDocumentType,
      CreatedByUser,
      CreationDate,

      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      Language,

      @ObjectModel: { foreignKey.association: '_PurchasingOrganization'}
      PurchasingOrganization,

      @ObjectModel: { foreignKey.association: '_PurchasingGroup'}
      PurchasingGroup,

      @ObjectModel: { foreignKey.association: '_DocumentCurrency'}
      DocumentCurrency,

      @ObjectModel: { foreignKey.association: '_IncotermsClassification' }
      IncotermsClassification,
      IncotermsTransferLocation,

      @ObjectModel: {foreignKey.association: '_IncotermsVersion' }
      IncotermsVersion,
      IncotermsLocation1,
      IncotermsLocation2,

      @ObjectModel.foreignKey.association: '_PaymentTerms'
      PaymentTerms,
      CashDiscount1Days,
      CashDiscount2Days,
      CashDiscount1Percent,
      CashDiscount2Percent,
      NetPaymentDays,
      RFQPublishingDate,
      QuotationLatestSubmissionDate,
      BindingPeriodValidityEndDate,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TargetAmount,

      @ObjectModel: {  foreignKey.association: '_RFQLifecycleStatus'}
      RFQLifecycleStatus,
      RequestForQuotationName,
      QuotationEarliestSubmsnDate,
      LatestRegistrationDate,
      CorrespncInternalReference,

      @ObjectModel.foreignKey.association: '_FollowOnDocumentCategory'
      FollowOnDocumentCategory,

      PurgDocFollowOnDocumentType,
      PurchasingDocumentDeletionCode,

      @Semantics.booleanIndicator
      IsEndOfPurposeBlocked,
      PurContrValidityStartDate,
      PurContrValidityEndDate,

      /* Associations */
      _CentralReqForQuotationItem,
      _CntrlReqForQuotationBidder,
      _CompanyCode,
      _DocumentCurrency,
      _FollowOnDocumentCategory,
      _IncotermsClassification,
      _IncotermsVersion,
      _PaymentTerms,
      _PurchasingDocumentCategory,
      _PurchasingGroup,
      _PurchasingOrganization,
      _RFQLifecycleStatus,
      _RFQType
}