I_CentralRFQItemDistributionTP

DDL: I_CENTRALRFQITEMDISTRIBUTIONTP SQL: ICNTRLRFQDISTP Type: view TRANSACTIONAL Package: APPL_MM_PUR_CRFQ_SD
28 Fields 1 Data Sources 3 Associations

Transactional processing view for CRFQ Item Distribution

I_CentralRFQItemDistributionTP is a Transactional CDS View that provides data about "Transactional processing view for CRFQ Item Distribution" in SAP S/4HANA. It reads from 1 data source (R_CentralRFQItemDistribution) and exposes 28 fields with key fields CentralRequestForQuotation, CentralRequestForQuotationItem, DistributionKey. It has 3 associations to related views. Part of development package APPL_MM_PUR_CRFQ_SD.

Data Sources (1)

SourceAliasJoin Type
R_CentralRFQItemDistribution R_CentralRFQItemDistribution from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CentralRequestForQuotationTP _CentralRequestForQuotationTP _CentralRequestForQuotationTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation
[1..1] I_CentralReqForQuotationItemTP _CentralReqForQuotationItemTP _CentralReqForQuotationItemTP.CentralRequestForQuotationItem = $projection.CentralRequestForQuotationItem and _CentralReqForQuotationItemTP.CentralRequestForQuotation = $projection.CentralRequestForQuotation
[0..1] I_Currency _DocumentCurrency _DocumentCurrency.Currency = $projection.Currency

Annotations (16)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
EndUserText.label Transactional processing view for CRFQ Item Distribution view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ICNTRLRFQDISTP view
ObjectModel.writeDraftPersistence CNTRLRFQDIST_D view
ObjectModel.writeActivePersistence ICNTRLRFQDISTP view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

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
DocumentCurrencyendasDocumentCurrency
Currency Currency Valuation Crcy
PurchasingGroup PurchasingGroup Purchasing Group
StorageLocation StorageLocation StorageLocation
IsDeleted PurgDocItmDistrLineDeltnCode TRUE
OrderQuantityUnit OrderQuantityUnit Sales Unit
DistributionType DistributionType Distribution Type
DistrResponseMessageUUID DistrResponseMessageUUID GUID
ItemDistributionIsRelevant PurgDocItemDistrRelevanceCode Is Relevant
ReferenceHeaderDistributionKey ReferenceHeaderDistributionKey Distr. Number
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
ProcmtHubPurchaseRequisition ProcmtHubPurchaseRequisition Purchase Req.
ProcmtHubPurRequisitionItem ProcmtHubPurRequisitionItem Requisn. item
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
CntrlPurgDistributionInPercent CntrlPurgDistributionInPercent Distribution %
TargetQuantity TargetQuantity Target Quantity
_DocumentCurrency _DocumentCurrency
_CentralReqForQuotationItemTP _CentralReqForQuotationItemTP
_CentralRequestForQuotationTP _CentralRequestForQuotationTP

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 I_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.
-- SQL view name: ICNTRLRFQDISTP

CREATE VIEW I_CentralRFQItemDistributionTP AS
SELECT
  CentralRequestForQuotation,
  CentralRequestForQuotationItem,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  LogicalSystem,
  case when R_CentralRFQItemDistribution.DocumentCurrency = '' or R_CentralRFQItemDistribution.DocumentCurrency = ' ' then _CentralReqForQuotationItemTP.DocumentCurrency else R_CentralRFQItemDistribution.DocumentCurrency end as DocumentCurrency AS DocumentCurrencyendasDocumentCurrency,
  Currency,
  PurchasingGroup,
  StorageLocation,
  PurgDocItmDistrLineDeltnCode AS IsDeleted,
  OrderQuantityUnit,
  DistributionType,
  DistrResponseMessageUUID,
  PurgDocItemDistrRelevanceCode AS ItemDistributionIsRelevant,
  ReferenceHeaderDistributionKey,
  ProcurementHubSourceSystem,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  PurReqnReleaseStatus,
  CntrlPurgDistributionInPercent,
  TargetQuantity
FROM R_CentralRFQItemDistribution
LEFT OUTER JOIN I_CentralRequestForQuotationTP AS _CentralRequestForQuotationTP ON _CentralRequestForQuotationTP.CentralRequestForQuotation = CentralRequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_CentralReqForQuotationItemTP AS _CentralReqForQuotationItemTP ON _CentralReqForQuotationItemTP.CentralRequestForQuotationItem = CentralRequestForQuotationItem AND _CentralReqForQuotationItemTP.CentralRequestForQuotation = CentralRequestForQuotation  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON _DocumentCurrency.Currency = Currency  -- association [0..1]
;

Learn More