R_CentralRFQItemDistribution

DDL: R_CENTRALRFQITEMDISTRIBUTION SQL: RCNTRLRFQIDIS Type: view BASIC
41 Fields 1 Data Sources 2 Associations

Restricted View for Central RFQ Item Distribution

R_CentralRFQItemDistribution is a Basic CDS View that provides data about "Restricted View for Central RFQ Item Distribution" in SAP S/4HANA. It reads from 1 data source (ekpo_distr) and exposes 41 fields with key fields CentralRequestForQuotation, CentralRequestForQuotationItem, DistributionKey. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ekpo_distr ekpo_distr from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_CentralReqForQuotationItem _CentralReqForQuotationItem $projection.CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation and $projection.CentralRequestForQuotationItem = _CentralReqForQuotationItem.CentralRequestForQuotationItem
[1..1] R_CentralRequestForQuotation _CentralRequestForQuotation $projection.CentralRequestForQuotation = _CentralRequestForQuotation.CentralRequestForQuotation

Annotations (12)

NameValueLevelField
VDM.viewType #BASIC view
EndUserText.label Restricted View for Central RFQ Item Distribution view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName RCNTRLRFQIDIS view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CentralRequestForQuotation purchasingdocument Purchasing Document
KEY CentralRequestForQuotationItem purchasingdocumentitem Purchasing Doc. Item
KEY DistributionKey ekpo_distr distributionnumber Distr. Number
PurchasingDocumentCategory ekpo_distr purchasingdocumentcategory Doc. Category
PurchasingDocumentType ekpo_distr purchasingdocumenttype RFQ Type
PurchasingOrganization ekpo_distr purchasingorganization Purchasing Organization
CompanyCode ekpo_distr companycode Receiver Company Code
Plant ekpo_distr plant Valuation Area
LogicalSystem ekpo_distr logicalsystem Logical System
DocumentCurrency ekpo_distr documentcurrency Document Currency
Currency ekpo_distr documentcurrency Document Currency
PurchasingGroup ekpo_distr purchasinggroup Purchasing Group
StorageLocation ekpo_distr storagelocation StorageLocation
PaymentTerms ekpo_distr paymentterms Pyt Terms
CashDiscount1Days ekpo_distr cashdiscount1days Days from Baseline Date for Payment
CashDiscount2Days ekpo_distr cashdiscount2days Days from Baseline Date for Payment
NetPaymentDays ekpo_distr netpaymentdays Net Pmt Terms Period
CashDiscount1Percent ekpo_distr cashdiscount1percent Disc. Percent 1
CashDiscount2Percent ekpo_distr cashdiscount2percent Disc. Percent 2
Material ekpo_distr material Vehicle Model
MaterialGroup ekpo_distr materialgroup Product Group
CntrlPurgDistributionInPercent ekpo_distr purchasingdocumentdistrpct Distribution %
TargetQuantity ekpo_distr targetquantity Target Quantity
TargetAmount ekpo_distr targetvalue Target Value
ExtContractForPurg ekpo_distr extcontractforpurg Contract
ExtContractItemForPurg ekpo_distr extcontractitemforpurg Item
PurgDocItmDistrLineDeltnCode ekpo_distr isdeleted TRUE
OrderQuantityUnit ekpo_distr orderquantityunit Sales Unit
DistributionType ekpo_distr distributiontype Distribution Type
DistrResponseMessageUUID ekpo_distr responsemessageguid GUID
ItemDistributionIsRelevant ekpo_distr itemdistributionisrelevant Is Relevant
PurgDocItemDistrRelevanceCode ekpo_distr itemdistributionisrelevant Is Relevant
ReferenceHeaderDistributionKey ekpo_distr referencedhdrdistrnumber Distr. Number
ManualDeliveryAddressID ekpo_distr manualdeliveryaddressid Address Number
AddressType
ProcmtHubPurchaseRequisition ekpo_distr procmthubpurchaserequisition Purchase Req.
ProcmtHubPurRequisitionItem ekpo_distr procmthubpurrequisitionitem Requisn. item
PurReqnReleaseStatus ekpo_distr purreqnreleasestatus Proc.state
NetPriceAmount _CentralReqForQuotationItem NetPriceAmount Net Price
_CentralRequestForQuotation _CentralRequestForQuotation
_CentralReqForQuotationItem _CentralReqForQuotationItem

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_CentralRFQItemDistribution.
-- 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: RCNTRLRFQIDIS

CREATE VIEW R_CentralRFQItemDistribution AS
SELECT
  purchasingdocument AS CentralRequestForQuotation,
  purchasingdocumentitem AS CentralRequestForQuotationItem,
  ekpo_distr.distributionnumber AS DistributionKey,
  ekpo_distr.purchasingdocumentcategory AS PurchasingDocumentCategory,
  ekpo_distr.purchasingdocumenttype AS PurchasingDocumentType,
  ekpo_distr.purchasingorganization AS PurchasingOrganization,
  ekpo_distr.companycode AS CompanyCode,
  ekpo_distr.plant AS Plant,
  ekpo_distr.logicalsystem AS LogicalSystem,
  ekpo_distr.documentcurrency AS DocumentCurrency,
  ekpo_distr.documentcurrency AS Currency,
  ekpo_distr.purchasinggroup AS PurchasingGroup,
  ekpo_distr.storagelocation AS StorageLocation,
  ekpo_distr.paymentterms AS PaymentTerms,
  ekpo_distr.cashdiscount1days AS CashDiscount1Days,
  ekpo_distr.cashdiscount2days AS CashDiscount2Days,
  ekpo_distr.netpaymentdays AS NetPaymentDays,
  ekpo_distr.cashdiscount1percent AS CashDiscount1Percent,
  ekpo_distr.cashdiscount2percent AS CashDiscount2Percent,
  ekpo_distr.material AS Material,
  ekpo_distr.materialgroup AS MaterialGroup,
  ekpo_distr.purchasingdocumentdistrpct AS CntrlPurgDistributionInPercent,
  ekpo_distr.targetquantity AS TargetQuantity,
  ekpo_distr.targetvalue AS TargetAmount,
  ekpo_distr.extcontractforpurg AS ExtContractForPurg,
  ekpo_distr.extcontractitemforpurg AS ExtContractItemForPurg,
  ekpo_distr.isdeleted AS PurgDocItmDistrLineDeltnCode,
  ekpo_distr.orderquantityunit AS OrderQuantityUnit,
  ekpo_distr.distributiontype AS DistributionType,
  ekpo_distr.responsemessageguid AS DistrResponseMessageUUID,
  ekpo_distr.itemdistributionisrelevant AS ItemDistributionIsRelevant,
  ekpo_distr.itemdistributionisrelevant AS PurgDocItemDistrRelevanceCode,
  ekpo_distr.referencedhdrdistrnumber AS ReferenceHeaderDistributionKey,
  ekpo_distr.manualdeliveryaddressid AS ManualDeliveryAddressID,
  cast ( ekpo_distr.deliveryaddresstype as bu_adrkind ) AS AddressType,
  ekpo_distr.procmthubpurchaserequisition AS ProcmtHubPurchaseRequisition,
  ekpo_distr.procmthubpurrequisitionitem AS ProcmtHubPurRequisitionItem,
  ekpo_distr.purreqnreleasestatus AS PurReqnReleaseStatus,
  _CentralReqForQuotationItem.NetPriceAmount AS NetPriceAmount
FROM ekpo_distr
LEFT OUTER JOIN R_CentralReqForQuotationItem AS _CentralReqForQuotationItem ON CentralRequestForQuotation = _CentralReqForQuotationItem.CentralRequestForQuotation AND CentralRequestForQuotationItem = _CentralReqForQuotationItem.CentralRequestForQuotationItem  -- association [1..1]
LEFT OUTER JOIN R_CentralRequestForQuotation AS _CentralRequestForQuotation ON CentralRequestForQuotation = _CentralRequestForQuotation.CentralRequestForQuotation  -- association [1..1]
;

Learn More