I_SourcingProjectQuotationTP

DDL: I_SOURCINGPROJECTQUOTATIONTP Type: view_entity TRANSACTIONAL

Quotation for Sourcing Project - TP

I_SourcingProjectQuotationTP is a Transactional CDS View that provides data about "Quotation for Sourcing Project - TP" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectQuotationTP) and exposes 39 fields with key field SourcingProjectQuotationUUID.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectQuotationTP R_SourcingProjectQuotationTP projection

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SourcingProjectQuotationUUID view
ObjectModel.sapObjectNodeType.name SourcingProjectQuotation view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Quotation for Sourcing Project - TP view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SQH view
AbapCatalog.extensibility.quota.maximumFields 204 view
AbapCatalog.extensibility.quota.maximumBytes 4080 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectQuotationUUID SourcingProjectQuotationUUID
SourcingProjectQuotation SourcingProjectQuotation
SrcgProjQuotationVersion SrcgProjQuotationVersion
SourcingProjectQuotationType SourcingProjectQuotationType
SourcingProjectQuotationName SourcingProjectQuotationName
SrcgProjQuotationIsSimulated SrcgProjQuotationIsSimulated
Bidder Bidder
CompanyCode CompanyCode
PurchasingGroup PurchasingGroup
PurchasingOrganization PurchasingOrganization
SrcgProjQtnOfferCurrency SrcgProjQtnOfferCurrency
SrcgProjQtnTotNetAmt SrcgProjQtnTotNetAmt
SrcgProjQtnLifecycleStatus SrcgProjQtnLifecycleStatus
SrcgProjQtnRevisionSts SrcgProjQtnRevisionSts
SrcgProjQtnActvtnSts SrcgProjQtnActvtnSts
SrcgProjQtnSubmsnSts SrcgProjQtnSubmsnSts
SrcgProjQtnAwardingStatus SrcgProjQtnAwardingStatus
SourcingProjectUUID SourcingProjectUUID
SourcingProjectNegotiationUUID SourcingProjectNegotiationUUID
PricingProcedure PricingProcedure
LastChangedByUser LastChangedByUser
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
CreationDateTime CreationDateTime
SrcgProjAttchsAreForbidden SrcgProjAttchsAreForbidden
SrcgProjNotesAreForbidden SrcgProjNotesAreForbidden
SourcingOrigin SourcingOrigin
ExternalSourcingProjectQtnRef ExternalSourcingProjectQtnRef
QtnLatestSubmissionDateTime QtnLatestSubmissionDateTime
LogicalSystem LogicalSystem
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
CashDiscount1Days CashDiscount1Days
CashDiscount2Days CashDiscount2Days
CashDiscount1Percent CashDiscount1Percent
CashDiscount2Percent CashDiscount2Percent
NetPaymentDays NetPaymentDays
MaterialGroup MaterialGroup
SourcingAwardingDate SourcingAwardingDate
SourcingProjectNegotiationType SourcingProjectNegotiationType
@AccessControl.authorizationCheck: #MANDATORY

@Metadata.ignorePropagatedAnnotations:true

@ObjectModel:{representativeKey:      'SourcingProjectQuotationUUID',
              semanticKey:           ['SourcingProjectQuotation'],
              sapObjectNodeType.name: 'SourcingProjectQuotation',

              modelingPattern:        #TRANSACTIONAL_INTERFACE,
              supportedCapabilities: [#TRANSACTIONAL_PROVIDER],

              usageType: {
                dataClass:      #TRANSACTIONAL,
                serviceQuality: #C,
                sizeCategory:   #L
              }
}

@VDM:{
  viewType:                #TRANSACTIONAL,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}

@EndUserText.label: 'Quotation for Sourcing Project - TP'
@AbapCatalog.extensibility: {
  extensible: true,
  dataSources: ['SourcingProjectQuotationTP'],
  allowNewDatasources: false,
  elementSuffix: 'SQH',
  quota: { maximumFields: 204,
           maximumBytes: 4080 },
  allowNewCompositions: true }
  
define root view entity I_SourcingProjectQuotationTP
  provider contract transactional_interface
  as projection on R_SourcingProjectQuotationTP as SourcingProjectQuotationTP
{

  key SourcingProjectQuotationUUID,
      SourcingProjectQuotation,
      SrcgProjQuotationVersion,
      SourcingProjectQuotationType,
      SourcingProjectQuotationName,
      SrcgProjQuotationIsSimulated,
      Bidder,
      CompanyCode,
      PurchasingGroup,
      PurchasingOrganization,
      SrcgProjQtnOfferCurrency,
      @Semantics.amount.currencyCode: 'SrcgProjQtnOfferCurrency'
      SrcgProjQtnTotNetAmt,
      SrcgProjQtnLifecycleStatus,
      SrcgProjQtnRevisionSts,
      SrcgProjQtnActvtnSts,
      SrcgProjQtnSubmsnSts,
      SrcgProjQtnAwardingStatus,
      SourcingProjectUUID,
      SourcingProjectNegotiationUUID,
      PricingProcedure,
      LastChangedByUser,
      CreatedByUser,
      LastChangeDateTime,
      CreationDateTime,
      SrcgProjAttchsAreForbidden,
      SrcgProjNotesAreForbidden,
      SourcingOrigin,
      ExternalSourcingProjectQtnRef,
      QtnLatestSubmissionDateTime,
      LogicalSystem,
      @Semantics.booleanIndicator: true
      IsEndOfPurposeBlocked,
      CashDiscount1Days,
      CashDiscount2Days,
      CashDiscount1Percent,
      CashDiscount2Percent,
      NetPaymentDays,
      MaterialGroup,
      SourcingAwardingDate,
      SourcingProjectNegotiationType,


      /* Compositions */
      _SrcgProjQtnAllowedCurrency : redirected to composition child I_SrcgProjQtnAllowedCurrencyTP,
      _SrcgProjQtnItem            : redirected to composition child I_SrcgProjQtnItemTP,
      _SrcgProjQtnSupplierContact : redirected to composition child I_SrcgProjQtnSupplierContactTP

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_SOURCINGPROJECTQUOTATIONTP"
],
"ASSOCIATED":
[
"I_SRCGPROJQTNALLOWEDCURRENCYTP",
"I_SRCGPROJQTNITEMTP",
"I_SRCGPROJQTNSUPPLIERCONTACTTP",
"R_SRCGPROJQTNALLOWEDCURRENCYTP",
"R_SRCGPROJQTNITEMTP",
"R_SRCGPROJQTNSUPPLIERCONTACTTP"
],
"BASE":
[
"R_SOURCINGPROJECTQUOTATIONTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/