R_CentralRFQItemDistributionTP

DDL: R_CENTRALRFQITEMDISTRIBUTIONTP Type: view_entity TRANSACTIONAL

Cntrl Req for Quotation Itm Distribution

R_CentralRFQItemDistributionTP is a Transactional CDS View that provides data about "Cntrl Req for Quotation Itm Distribution" in SAP S/4HANA. It reads from 1 data source (R_CentralRFQItemDistribution) and exposes 26 fields with key fields CentralRequestForQuotation, CentralRequestForQuotationItem, DistributionKey. It has 1 association to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
R_CentralRFQItemDistribution R_CentralRFQItemDistribution from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _OrderQuantityUnit $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Cntrl Req for Quotation Itm Distribution view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey DistributionKey view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CentralRequestForQuotation CentralRequestForQuotation
KEY CentralRequestForQuotationItem CentralRequestForQuotationItem
KEY DistributionKey DistributionKey
PurchasingDocumentCategory PurchasingDocumentCategory
PurchasingDocumentType PurchasingDocumentType
PurchasingOrganization PurchasingOrganization
CompanyCode CompanyCode
Plant Plant
LogicalSystem LogicalSystem
DocumentCurrency DocumentCurrency
Currency Currency
PurchasingGroup PurchasingGroup
StorageLocation StorageLocation
CntrlPurgDistributionInPercent CntrlPurgDistributionInPercent
TargetQuantity TargetQuantity
PurgDocItmDistrLineDeltnCode PurgDocItmDistrLineDeltnCode
OrderQuantityUnit OrderQuantityUnit
DistributionType DistributionType
ProcurementHubSourceSystem ProcurementHubSourceSystem
ProcmtHubPurchaseRequisition ProcmtHubPurchaseRequisition
ProcmtHubPurRequisitionItem ProcmtHubPurRequisitionItem
PurReqnReleaseStatus PurReqnReleaseStatus
LastChangeDateTime _CntrlRFQ LastChangeDateTime
_CentralReqForQuotationItem _CentralReqForQuotationItem
_CntrlRFQ _CntrlRFQ
_OrderQuantityUnit _OrderQuantityUnit 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Cntrl Req for Quotation Itm Distribution'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.semanticKey:  [ 'CentralRequestForQuotation' , 'CentralRequestForQuotationItem', 'DistributionKey' ]
@ObjectModel.representativeKey: 'DistributionKey'

@ObjectModel: {
    usageType: {
      sizeCategory: #L,
      serviceQuality: #B,
      dataClass: #TRANSACTIONAL
    }
  }

@Metadata.ignorePropagatedAnnotations: true

define view entity R_CentralRFQItemDistributionTP
  as select from R_CentralRFQItemDistribution
  association        to parent R_CentralReqForQuotationItemTP as _CentralReqForQuotationItem on  $projection.CentralRequestForQuotation     = _CentralReqForQuotationItem.CentralRequestForQuotation
                                                                                             and $projection.CentralRequestForQuotationItem = _CentralReqForQuotationItem.CentralRequestForQuotationItem
  association        to R_CentralRequestForQuotationTP        as _CntrlRFQ                   on  $projection.CentralRequestForQuotation = _CntrlRFQ.CentralRequestForQuotation
  association [0..1] to I_UnitOfMeasure                       as _OrderQuantityUnit          on  $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure
{
      @ObjectModel.foreignKey: { association : '_CntrlRFQ' }
  key CentralRequestForQuotation,
      @ObjectModel.foreignKey: { association : '_CentralReqForQuotationItem' }
  key CentralRequestForQuotationItem,
  key DistributionKey,
      PurchasingDocumentCategory,
      PurchasingDocumentType,
      PurchasingOrganization,
      CompanyCode,
      Plant,
      LogicalSystem,
      DocumentCurrency,
      Currency,
      PurchasingGroup,
      StorageLocation,
      CntrlPurgDistributionInPercent,

      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      TargetQuantity,
      PurgDocItmDistrLineDeltnCode,
      OrderQuantityUnit,
      DistributionType,
      //      DistrResponseMessageUUID,

      //      PurgDocItemDistrRelevanceCode,

      //      ReferenceHeaderDistributionKey,


      ProcurementHubSourceSystem,
      ProcmtHubPurchaseRequisition,
      ProcmtHubPurRequisitionItem,
      PurReqnReleaseStatus,
      //      @Semantics.amount.currencyCode:'DocumentCurrency'

      //      NetPriceAmount,

      @Semantics.systemDateTime.lastChangedAt: true
      _CntrlRFQ.LastChangeDateTime as LastChangeDateTime,
      /* Associations */
      _CentralReqForQuotationItem,
      _CntrlRFQ,
      _OrderQuantityUnit
}
where
  _CntrlRFQ.CentralRequestForQuotation is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_CENTRALREQUESTFORQUOTATIONTP",
"R_CENTRALRFQITEMDISTRIBUTION"
],
"ASSOCIATED":
[
"I_UNITOFMEASURE",
"R_CENTRALREQFORQUOTATIONITEMTP",
"R_CENTRALREQUESTFORQUOTATIONTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More