I_CentralRequestForQuotationTP

DDL: I_CENTRALREQUESTFORQUOTATIONTP SQL: ICNTRLRFQHDRTP Type: view TRANSACTIONAL Package: APPL_MM_PUR_CRFQ_SD

Transactional processing view for Central RFQ Header

I_CentralRequestForQuotationTP is a Transactional CDS View that provides data about "Transactional processing view for Central RFQ Header" in SAP S/4HANA. It reads from 1 data source (R_CentralRequestForQuotation) and exposes 55 fields with key field CentralRequestForQuotation. It has 4 associations to related views. Part of development package APPL_MM_PUR_CRFQ_SD.

Data Sources (1)

SourceAliasJoin Type
R_CentralRequestForQuotation Document from

Associations (4)

CardinalityTargetAliasCondition
[1..*] I_CentralReqForQuotationItemTP _CentralReqForQuotationItemTP _CentralReqForQuotationItemTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation
[1..*] I_CntrlReqForQuotationBidderTP _CntrlReqForQuotationBidderTP _CntrlReqForQuotationBidderTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation
[0..*] I_CentralSupplierQuotationTP _CentralSupplierQuotationTP _CentralSupplierQuotationTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation --Extension
[0..1] E_PurchasingDocument _CentralReqForQuotationExtn _CentralReqForQuotationExtn.PurchasingDocument = $projection.CentralRequestForQuotation

Annotations (20)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName ICNTRLRFQHDRTP view
EndUserText.label Transactional processing view for Central RFQ Header view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.semanticKey CentralRequestForQuotation view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence CNTRLRFQHDR_D view
ObjectModel.writeActivePersistence ICNTRLRFQHDRTP view
ObjectModel.draftEnabled true view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY CentralRequestForQuotation R_CentralRequestForQuotation CentralRequestForQuotation
CompanyCode R_CentralRequestForQuotation CompanyCode
PurchasingDocumentCategory R_CentralRequestForQuotation PurchasingDocumentCategory
PurchasingDocumentType R_CentralRequestForQuotation PurchasingDocumentType
CreatedByUser R_CentralRequestForQuotation CreatedByUser
CreationDate R_CentralRequestForQuotation CreationDate
LastChangeDateTime R_CentralRequestForQuotation LastChangeDateTime
Language R_CentralRequestForQuotation Language
PurchasingOrganization R_CentralRequestForQuotation PurchasingOrganization
PurchasingGroup R_CentralRequestForQuotation PurchasingGroup
DocumentCurrency R_CentralRequestForQuotation DocumentCurrency
IncotermsClassification R_CentralRequestForQuotation IncotermsClassification
IncotermsTransferLocation R_CentralRequestForQuotation IncotermsTransferLocation
IncotermsVersion R_CentralRequestForQuotation IncotermsVersion
IncotermsLocation1 R_CentralRequestForQuotation IncotermsLocation1
IncotermsLocation2 R_CentralRequestForQuotation IncotermsLocation2
PaymentTerms R_CentralRequestForQuotation PaymentTerms
CashDiscount1Days R_CentralRequestForQuotation CashDiscount1Days
CashDiscount2Days R_CentralRequestForQuotation CashDiscount2Days
CashDiscount1Percent R_CentralRequestForQuotation CashDiscount1Percent
CashDiscount2Percent R_CentralRequestForQuotation CashDiscount2Percent
NetPaymentDays R_CentralRequestForQuotation NetPaymentDays
RFQPublishingDate R_CentralRequestForQuotation RFQPublishingDate
QuotationLatestSubmissionDate R_CentralRequestForQuotation QuotationLatestSubmissionDate
BindingPeriodValidityEndDate R_CentralRequestForQuotation BindingPeriodValidityEndDate
TargetAmount R_CentralRequestForQuotation TargetAmount
CorrespncInternalReference R_CentralRequestForQuotation CorrespncInternalReference
RFQLifecycleStatus R_CentralRequestForQuotation RFQLifecycleStatus
RequestForQuotationName R_CentralRequestForQuotation RequestForQuotationName
QuotationEarliestSubmsnDate R_CentralRequestForQuotation QuotationEarliestSubmsnDate
LatestRegistrationDate R_CentralRequestForQuotation LatestRegistrationDate
FollowOnDocumentCategory R_CentralRequestForQuotation FollowOnDocumentCategory
FollowOnDocumentType R_CentralRequestForQuotation PurgDocFollowOnDocumentType
PurContrValidityStartDate R_CentralRequestForQuotation PurContrValidityStartDate
PurContrValidityEndDate R_CentralRequestForQuotation PurContrValidityEndDate
PurchasingDocumentDeletionCode R_CentralRequestForQuotation PurchasingDocumentDeletionCode
IsEndOfPurposeBlocked R_CentralRequestForQuotation IsEndOfPurposeBlocked
_CentralReqForQuotationItemTP _CentralReqForQuotationItemTP
_CntrlReqForQuotationBidderTP _CntrlReqForQuotationBidderTP
_CentralSupplierQuotationTP _CentralSupplierQuotationTP
_CompanyCode R_CentralRequestForQuotation _CompanyCode
_DocumentCurrency R_CentralRequestForQuotation _DocumentCurrency
_IncotermsClassification R_CentralRequestForQuotation _IncotermsClassification
_IncotermsVersion R_CentralRequestForQuotation _IncotermsVersion
_PaymentTerms R_CentralRequestForQuotation _PaymentTerms
_PurchasingDocumentType R_CentralRequestForQuotation _PurchasingDocumentType
_PurchasingGroup R_CentralRequestForQuotation _PurchasingGroup
_PurchasingOrganization R_CentralRequestForQuotation _PurchasingOrganization
_PurchasingDocumentCategory R_CentralRequestForQuotation _PurchasingDocumentCategory
_Language R_CentralRequestForQuotation _Language
_CreatedByUser R_CentralRequestForQuotation _CreatedByUser
_RFQLifecycleStatus R_CentralRequestForQuotation _RFQLifecycleStatus
_FollowOnDocumentType R_CentralRequestForQuotation _FollowOnDocumentType
_FollowOnDocumentCategory R_CentralRequestForQuotation _FollowOnDocumentCategory
_RFQType R_CentralRequestForQuotation _RFQType
@VDM.viewType: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'ICNTRLRFQHDRTP'
@EndUserText.label: 'Transactional processing view for Central RFQ Header'
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel:{compositionRoot: true,
              createEnabled: true,
              deleteEnabled: 'EXTERNAL_CALCULATION',
              semanticKey: 'CentralRequestForQuotation' ,
              transactionalProcessingEnabled: true,
              writeDraftPersistence: 'CNTRLRFQHDR_D',
              writeActivePersistence: 'ICNTRLRFQHDRTP',
              draftEnabled: true ,
              updateEnabled:'EXTERNAL_CALCULATION',
              usageType.dataClass: #TRANSACTIONAL,
              usageType.serviceQuality: #C,
              usageType.sizeCategory: #L,
              entityChangeStateId:'LastChangeDateTime'}
              
              

//@ObjectModel.representativeKey: 'CentralRequestForQuotation'


define view I_CentralRequestForQuotationTP
  as select from R_CentralRequestForQuotation as Document
  association [1..*] to I_CentralReqForQuotationItemTP as _CentralReqForQuotationItemTP on _CentralReqForQuotationItemTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation
  association [1..*] to I_CntrlReqForQuotationBidderTP as _CntrlReqForQuotationBidderTP on _CntrlReqForQuotationBidderTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation
  association [0..*] to I_CentralSupplierQuotationTP   as _CentralSupplierQuotationTP   on _CentralSupplierQuotationTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation
  --Extension Association
  association [0..1] to E_PurchasingDocument           as _CentralReqForQuotationExtn   on _CentralReqForQuotationExtn.PurchasingDocument = $projection.CentralRequestForQuotation
{
      @ObjectModel: { readOnly: true }
  key Document.CentralRequestForQuotation,

      Document.CompanyCode,

      Document.PurchasingDocumentCategory,

      @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
      Document.PurchasingDocumentType,

      @ObjectModel: { readOnly: true }
      Document.CreatedByUser,

      @ObjectModel: { readOnly: true }
      Document.CreationDate,

      @ObjectModel: { readOnly: true }
      Document.LastChangeDateTime,

      Document.Language,

      Document.PurchasingOrganization,

      Document.PurchasingGroup,

      Document.DocumentCurrency,

      Document.IncotermsClassification,

      Document.IncotermsTransferLocation,

      Document.IncotermsVersion,

      Document.IncotermsLocation1,

      Document.IncotermsLocation2,

      Document.PaymentTerms,

      Document.CashDiscount1Days,

      Document.CashDiscount2Days,

      Document.CashDiscount1Percent,

      Document.CashDiscount2Percent,

      Document.NetPaymentDays,

      @ObjectModel: { readOnly: true }
      Document.RFQPublishingDate,

      Document.QuotationLatestSubmissionDate,

      Document.BindingPeriodValidityEndDate,

      Document.TargetAmount,

      Document.CorrespncInternalReference,


      @ObjectModel: { readOnly: true }
      Document.RFQLifecycleStatus,

      //      Document.Criticality,


      Document.RequestForQuotationName,

      Document.QuotationEarliestSubmsnDate,

      Document.LatestRegistrationDate,

      Document.FollowOnDocumentCategory,

      Document.PurgDocFollowOnDocumentType as FollowOnDocumentType,

      Document.PurContrValidityStartDate,

      Document.PurContrValidityEndDate,
      @ObjectModel: { readOnly: true }
      Document.PurchasingDocumentDeletionCode,
      @ObjectModel: { readOnly: true }
      Document.IsEndOfPurposeBlocked,

      /*Association*/
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CentralReqForQuotationItemTP,
      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _CntrlReqForQuotationBidderTP,

      _CentralSupplierQuotationTP,

      Document._CompanyCode,

      Document._DocumentCurrency,

      Document._IncotermsClassification,

      Document._IncotermsVersion,

      Document._PaymentTerms,

      Document._PurchasingDocumentType,

      Document._PurchasingGroup,

      Document._PurchasingOrganization,

      Document._PurchasingDocumentCategory,

      Document._Language,

      Document._CreatedByUser,

      Document._RFQLifecycleStatus,

      Document._FollowOnDocumentType,

      Document._FollowOnDocumentCategory,

      Document._RFQType

}