I_CentralRequestForQuotation

DDL: I_CENTRALREQUESTFORQUOTATION SQL: ICNTRLRFQHDR Type: view BASIC Package: VDM_MM_PUR_CRFQ

Central Request For Quotation Header

I_CentralRequestForQuotation is a Basic CDS View that provides data about "Central Request For Quotation Header" in SAP S/4HANA. It reads from 1 data source (R_CentralRequestForQuotation) and exposes 55 fields with key field CentralRequestForQuotation. It has 6 associations to related views. Part of development package VDM_MM_PUR_CRFQ.

Data Sources (1)

SourceAliasJoin Type
R_CentralRequestForQuotation R_CentralRequestForQuotation from

Associations (6)

CardinalityTargetAliasCondition
[1..*] I_CentralReqForQuotationItem _CentralReqForQuotationItem $projection.CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation
[1..*] I_CntrlReqForQuotationBidder _CntrlReqForQuotationBidder $projection.CentralRequestForQuotation = _CntrlReqForQuotationBidder.CentralRequestForQuotation
[0..1] I_PurchasingDocumentType _FollowOnDocumentType $projection.PurchasingDocumentCategory = _FollowOnDocumentType.PurchasingDocumentCategory and $projection.PurchasingDocumentType = _FollowOnDocumentType.PurchasingDocumentType
[0..1] I_PurchasingDocumentCategory _FollowOnDocumentCategory $projection.PurchasingDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory
[0..*] I_CentralSupplierQuotation _CentralSupplierQuotation $projection.CentralRequestForQuotation = _CentralSupplierQuotation.CentralRequestForQuotation --Extension
[1..1] E_PurchasingDocument _CentralReqForQuotationExtn _CentralReqForQuotationExtn.PurchasingDocument = $projection.CentralRequestForQuotation

Annotations (14)

NameValueLevelField
VDM.viewType #BASIC view
EndUserText.label Central Request For Quotation Header view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ICNTRLRFQHDR view
ObjectModel.representativeKey CentralRequestForQuotation view
ObjectModel.semanticKey CentralRequestForQuotation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (55)

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
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
RFQPublishingDate RFQPublishingDate
QuotationLatestSubmissionDate QuotationLatestSubmissionDate
BindingPeriodValidityEndDate BindingPeriodValidityEndDate
TargetAmount TargetAmount
RFQLifecycleStatus RFQLifecycleStatus
RequestForQuotationName RequestForQuotationName
QuotationEarliestSubmsnDate QuotationEarliestSubmsnDate
LatestRegistrationDate LatestRegistrationDate
CorrespncInternalReference CorrespncInternalReference
FollowOnDocumentCategory FollowOnDocumentCategory
FollowOnDocumentType FollowOnDocumentType
PurgDocFollowOnDocumentType PurgDocFollowOnDocumentType
PurchasingDocumentDeletionCode PurchasingDocumentDeletionCode
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
PurContrValidityStartDate PurContrValidityStartDate
PurContrValidityEndDate PurContrValidityEndDate
_CentralReqForQuotationItem _CentralReqForQuotationItem
_CntrlReqForQuotationBidder _CntrlReqForQuotationBidder
_PurchasingDocumentType _PurchasingDocumentType
_PurchasingDocumentCategory _PurchasingDocumentCategory
_CreatedByUser _CreatedByUser
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion
_DocumentCurrency _DocumentCurrency
_CompanyCode _CompanyCode
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_CentralSupplierQuotation _CentralSupplierQuotation
_Language _Language
_FollowOnDocumentCategory _FollowOnDocumentCategory
_FollowOnDocumentType _FollowOnDocumentType
@VDM.viewType: #BASIC
@EndUserText.label: 'Central Request For Quotation Header'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ICNTRLRFQHDR'
//@AccessControl.privilegedAssociations: [ '_CreatedByUser' ]


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

@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.supportedCapabilities:[ #SQL_DATA_SOURCE,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #CDS_MODELING_ASSOCIATION_TARGET ]

define view I_CentralRequestForQuotation
  as select from R_CentralRequestForQuotation

    association [1..*] to I_CentralReqForQuotationItem as _CentralReqForQuotationItem on  $projection.CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation
  
    association [1..*] to I_CntrlReqForQuotationBidder as _CntrlReqForQuotationBidder on  $projection.CentralRequestForQuotation = _CntrlReqForQuotationBidder.CentralRequestForQuotation
   
    association [0..1] to I_PurchasingDocumentType     as _FollowOnDocumentType       on  $projection.PurchasingDocumentCategory = _FollowOnDocumentType.PurchasingDocumentCategory
                                                                                      and $projection.PurchasingDocumentType     = _FollowOnDocumentType.PurchasingDocumentType
  
    //association [0..1] to I_RequestForQuotationType    as _RFQType                    on  $projection.PurchasingDocumentType = _RFQType.RFQType

  
    association [0..1] to I_PurchasingDocumentCategory as _FollowOnDocumentCategory   on  $projection.PurchasingDocumentCategory = _FollowOnDocumentCategory.PurchasingDocumentCategory
  
    association [0..*] to I_CentralSupplierQuotation   as _CentralSupplierQuotation   on  $projection.CentralRequestForQuotation = _CentralSupplierQuotation.CentralRequestForQuotation
  
    //association [0..1] to I_RFQLifecycleStatus         as _RFQLifecycleStatus         on  $projection.RFQLifecycleStatus = _RFQLifecycleStatus.RFQLifecycleStatus

    
--Extension Association
  association [1..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,
      LastChangeDateTime,
      Language,

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

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

      @Semantics.currencyCode:true
      @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,
      ValidityStartDate,
      ValidityEndDate,
      RFQPublishingDate,
      QuotationLatestSubmissionDate,
      BindingPeriodValidityEndDate,

      @DefaultAggregation:#NONE
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TargetAmount,

      //@ObjectModel: {  foreignKey.association: '_RFQLifecycleStatus'}

      RFQLifecycleStatus,
      RequestForQuotationName,
      QuotationEarliestSubmsnDate,
      LatestRegistrationDate,
      CorrespncInternalReference,

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

      @ObjectModel.foreignKey.association: '_FollowOnDocumentType'
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'PurgDocFollowOnDocumentType'
      FollowOnDocumentType,
      PurgDocFollowOnDocumentType,
      PurchasingDocumentDeletionCode,

      @Semantics.booleanIndicator: true
      IsEndOfPurposeBlocked,
      PurContrValidityStartDate,
      PurContrValidityEndDate,

      /* Associations */
      _CentralReqForQuotationItem,
      _CntrlReqForQuotationBidder,
      _PurchasingDocumentType,
      _PurchasingDocumentCategory,
      //_RFQType,

      //_PaymentTerms,

      _CreatedByUser,
      _IncotermsClassification,
      _IncotermsVersion,
      _DocumentCurrency,
      _CompanyCode,
      _PurchasingGroup,
      _PurchasingOrganization,
      _CentralSupplierQuotation,
      _Language,
      //_RFQLifecycleStatus,

      _FollowOnDocumentCategory,
      _FollowOnDocumentType
}
where
  PurchasingDocumentCategory = 'N'