R_CntrlSuplrQuotationItemDistr

DDL: R_CNTRLSUPLRQUOTATIONITEMDISTR SQL: RCNTRLQTNDISTR Type: view BASIC
30 Fields 1 Data Sources 3 Associations

Central Supplier Qtan Item Distribution

R_CntrlSuplrQuotationItemDistr is a Basic CDS View that provides data about "Central Supplier Qtan Item Distribution" in SAP S/4HANA. It reads from 1 data source (ekpo_distr) and exposes 30 fields with key fields CentralSupplierQuotation, CentralSupplierQuotationItem, DistributionKey. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ekpo_distr ekpo_distr from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_CentralSupplierQuotation _CentralSupplierQuotation $projection.CentralSupplierQuotation = _CentralSupplierQuotation.CentralSupplierQuotation
[1..1] R_CntrlSupplierQuotationItem _CntrlSupplierQuotationItem $projection.CentralSupplierQuotation = _CntrlSupplierQuotationItem.CentralSupplierQuotation and $projection.CentralSupplierQuotationItem = _CntrlSupplierQuotationItem.CentralSupplierQuotationItem
[0..1] I_UnitOfMeasure _OrderQuantityUnit $projection.OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName RCNTRLQTNDISTR view
VDM.viewType #BASIC view
EndUserText.label Central Supplier Qtan Item Distribution view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CentralSupplierQuotation purchasingdocument Purchasing Document
KEY CentralSupplierQuotationItem 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
CntrlPurgDistributionInPercent ekpo_distr purchasingdocumentdistrpct Distribution %
TargetQuantity ekpo_distr targetquantity Target Quantity
TargetAmount ekpo_distr targetvalue Target Value
IsDeleted ekpo_distr isdeleted TRUE
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
ProcmtHubPurchaseRequisition ekpo_distr procmthubpurchaserequisition Purchase Req.
ProcmtHubPurRequisitionItem ekpo_distr procmthubpurrequisitionitem Requisn. item
PurReqnReleaseStatus ekpo_distr purreqnreleasestatus Proc.state
_CentralSupplierQuotation _CentralSupplierQuotation
_CntrlSupplierQuotationItem _CntrlSupplierQuotationItem
_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_CntrlSuplrQuotationItemDistr.
-- 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: RCNTRLQTNDISTR

CREATE VIEW R_CntrlSuplrQuotationItemDistr AS
SELECT
  purchasingdocument AS CentralSupplierQuotation,
  purchasingdocumentitem AS CentralSupplierQuotationItem,
  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.purchasingdocumentdistrpct AS CntrlPurgDistributionInPercent,
  ekpo_distr.targetquantity AS TargetQuantity,
  ekpo_distr.targetvalue AS TargetAmount,
  ekpo_distr.isdeleted AS IsDeleted,
  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.procmthubpurchaserequisition AS ProcmtHubPurchaseRequisition,
  ekpo_distr.procmthubpurrequisitionitem AS ProcmtHubPurRequisitionItem,
  ekpo_distr.purreqnreleasestatus AS PurReqnReleaseStatus
FROM ekpo_distr
LEFT OUTER JOIN R_CentralSupplierQuotation AS _CentralSupplierQuotation ON CentralSupplierQuotation = _CentralSupplierQuotation.CentralSupplierQuotation  -- association [1..1]
LEFT OUTER JOIN R_CntrlSupplierQuotationItem AS _CntrlSupplierQuotationItem ON CentralSupplierQuotation = _CntrlSupplierQuotationItem.CentralSupplierQuotation AND CentralSupplierQuotationItem = _CntrlSupplierQuotationItem.CentralSupplierQuotationItem  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
;

Learn More