I_CentralRequestForQuotationTP
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.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| R_CentralRequestForQuotation | Document | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CENTRALREQUESTFORQUOTATION"
],
"ASSOCIATED":
[
"E_PURCHASINGDOCUMENT",
"I_CENTRALREQFORQUOTATIONITEMTP",
"I_CENTRALSUPPLIERQUOTATIONTP",
"I_CNTRLREQFORQUOTATIONBIDDERTP",
"I_COMPANYCODE",
"I_CURRENCY",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSVERSION",
"I_LANGUAGE",
"I_PAYMENTTERMS",
"I_PURCHASINGDOCUMENTCATEGORY",
"I_PURCHASINGDOCUMENTTYPE",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_REQUESTFORQUOTATIONTYPE",
"I_RFQLIFECYCLESTATUS",
"I_USER"
],
"BASE":
[
"R_CENTRALREQUESTFORQUOTATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA