C_CntrlRequestForQuotationInfo

DDL: C_CNTRLREQUESTFORQUOTATIONINFO SQL: CCNTRLRFQINFO Type: view CONSUMPTION

Consumption View for Central Request for Quotation Info

C_CntrlRequestForQuotationInfo is a Consumption CDS View that provides data about "Consumption View for Central Request for Quotation Info" in SAP S/4HANA. It reads from 1 data source (R_CentralRequestForQuotation) and exposes 14 fields with key field CentralRequestForQuotation. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
R_CentralRequestForQuotation CentralRequestForQuotation from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CntrlReqForQuotationType _CntrlReqForQuotationType _CntrlReqForQuotationType.RFQType = $projection.RFQType
[0..1] P_CRFQCustomizing _RFQCustomizing $projection.RFQType = _RFQCustomizing.PurchasingDocumentType

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCNTRLRFQINFO view
VDM.viewType #CONSUMPTION view
EndUserText.label Consumption View for Central Request for Quotation Info view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.semanticKey CentralRequestForQuotation view
ObjectModel.representativeKey CentralRequestForQuotation view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CentralRequestForQuotation R_CentralRequestForQuotation CentralRequestForQuotation
RequestForQuotationName R_CentralRequestForQuotation RequestForQuotationName
RFQCategory R_CentralRequestForQuotation PurchasingDocumentCategory
RFQType R_CentralRequestForQuotation PurchasingDocumentType
RFQExternalProcessingType _RFQCustomizing RFQExternalProcessingType
RFQAwardingType _RFQCustomizing RFQAwardingType
RFQLifecycleStatus R_CentralRequestForQuotation RFQLifecycleStatus
PurchasingOrganization R_CentralRequestForQuotation PurchasingOrganization
PurchasingGroup R_CentralRequestForQuotation PurchasingGroup
RFQPublishingDate R_CentralRequestForQuotation RFQPublishingDate
QuotationLatestSubmissionDate R_CentralRequestForQuotation QuotationLatestSubmissionDate
IsEndOfPurposeBlocked R_CentralRequestForQuotation IsEndOfPurposeBlocked
_PurchasingDocumentType R_CentralRequestForQuotation _PurchasingDocumentType
_CntrlReqForQuotationType _CntrlReqForQuotationType 
@AbapCatalog.sqlViewName: 'CCNTRLRFQINFO'
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Consumption View for Central Request for Quotation Info'
@AbapCatalog.preserveKey:true

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED

@ObjectModel.semanticKey: 'CentralRequestForQuotation'
@ObjectModel.representativeKey: 'CentralRequestForQuotation'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M

define view C_CntrlRequestForQuotationInfo 

  as select from R_CentralRequestForQuotation as CentralRequestForQuotation

  association [0..1] to I_CntrlReqForQuotationType as _CntrlReqForQuotationType        on _CntrlReqForQuotationType.RFQType = $projection.RFQType
  association [0..1] to P_CRFQCustomizing          as _RFQCustomizing on $projection.RFQType = _RFQCustomizing.PurchasingDocumentType

{
  
  key CentralRequestForQuotation.CentralRequestForQuotation,

      CentralRequestForQuotation.RequestForQuotationName,

      CentralRequestForQuotation.PurchasingDocumentCategory as RFQCategory,

      @ObjectModel.foreignKey.association: '_CntrlReqForQuotationType'
      CentralRequestForQuotation.PurchasingDocumentType     as RFQType,
      
      _RFQCustomizing.RFQExternalProcessingType,
      
      _RFQCustomizing.RFQAwardingType,

      CentralRequestForQuotation.RFQLifecycleStatus,

      CentralRequestForQuotation.PurchasingOrganization,

      CentralRequestForQuotation.PurchasingGroup,

      @Semantics.businessDate.at: true
      CentralRequestForQuotation.RFQPublishingDate,

      @Semantics.businessDate.to: true
      CentralRequestForQuotation.QuotationLatestSubmissionDate,

      CentralRequestForQuotation.IsEndOfPurposeBlocked,

      CentralRequestForQuotation._PurchasingDocumentType,
      _CntrlReqForQuotationType

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_CRFQCUSTOMIZING",
"R_CENTRALREQUESTFORQUOTATION"
],
"ASSOCIATED":
[
"I_CNTRLREQFORQUOTATIONTYPE",
"I_PURCHASINGDOCUMENTTYPE",
"P_CRFQCUSTOMIZING"
],
"BASE":
[
"R_CENTRALREQUESTFORQUOTATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More