R_CentralRFQItemDistributionTP

DDL: R_CENTRALRFQITEMDISTRIBUTIONTP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_CRFQ
26 Fields 1 Data Sources 1 Associations

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. Part of development package RAP_MM_PUR_CRFQ.

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 Purchasing Document
KEY CentralRequestForQuotationItem CentralRequestForQuotationItem Purchasing Doc. Item
KEY DistributionKey DistributionKey Distr. Number
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
LogicalSystem LogicalSystem Logical System
DocumentCurrency DocumentCurrency Document Currency
Currency Currency Valuation Crcy
PurchasingGroup PurchasingGroup Purchasing Group
StorageLocation StorageLocation StorageLocation
CntrlPurgDistributionInPercent CntrlPurgDistributionInPercent Distribution %
TargetQuantity TargetQuantity Target Quantity
PurgDocItmDistrLineDeltnCode PurgDocItmDistrLineDeltnCode TRUE
OrderQuantityUnit OrderQuantityUnit Sales Unit
DistributionType DistributionType Distribution Type
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
ProcmtHubPurchaseRequisition ProcmtHubPurchaseRequisition Purchase Req.
ProcmtHubPurRequisitionItem ProcmtHubPurRequisitionItem Requisn. item
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
LastChangeDateTime _CntrlRFQ LastChangeDateTime Timestamp
_CentralReqForQuotationItem _CentralReqForQuotationItem
_CntrlRFQ _CntrlRFQ
_OrderQuantityUnit _OrderQuantityUnit

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_CentralRFQItemDistributionTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_CentralRFQItemDistributionTP AS
SELECT
  CentralRequestForQuotation,
  CentralRequestForQuotationItem,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  LogicalSystem,
  DocumentCurrency,
  Currency,
  PurchasingGroup,
  StorageLocation,
  CntrlPurgDistributionInPercent,
  TargetQuantity,
  PurgDocItmDistrLineDeltnCode,
  OrderQuantityUnit,
  DistributionType,
  ProcurementHubSourceSystem,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  PurReqnReleaseStatus,
  _CntrlRFQ.LastChangeDateTime AS LastChangeDateTime
FROM R_CentralRFQItemDistribution
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
;

Learn More