A_CentralRFQItemDistribution

DDL: A_CENTRALRFQITEMDISTRIBUTION Type: view_entity CONSUMPTION
22 Fields 1 Data Sources

Distribution

A_CentralRFQItemDistribution is a Consumption CDS View that provides data about "Distribution" in SAP S/4HANA. It reads from 1 data source (R_CentralRFQItemDistributionTP) and exposes 22 fields with key fields CentralRequestForQuotation, CentralRequestForQuotationItem, DistributionKey.

Data Sources (1)

SourceAliasJoin Type
R_CentralRFQItemDistributionTP R_CentralRFQItemDistributionTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Distribution view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CentralRequestForQuotation CentralRequestForQuotation
KEY CentralRequestForQuotationItem CentralRequestForQuotationItem
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
PurchasingGroup PurchasingGroup Purchasing Group
StorageLocation StorageLocation StorageLocation
CntrlPurgDistributionInPercent CntrlPurgDistributionInPercent
TargetQuantity TargetQuantity Target Quantity
PurgDocItmDistrLineDeltnCode PurgDocItmDistrLineDeltnCode
OrderQuantityUnit OrderQuantityUnit Sales Unit
OrderQuantityUnitISOCode _OrderQuantityUnit UnitOfMeasureISOCode
DistributionType DistributionType Distribution Type
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
ProcmtHubPurchaseRequisition ProcmtHubPurchaseRequisition Purchase Req.
ProcmtHubPurRequisitionItem ProcmtHubPurRequisitionItem Requisn. item
PurReqnReleaseStatus PurReqnReleaseStatus Proc.state
LastChangeDateTime LastChangeDateTime Timestamp

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 A_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.

CREATE VIEW A_CentralRFQItemDistribution AS
SELECT
  CentralRequestForQuotation,
  CentralRequestForQuotationItem,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  LogicalSystem,
  PurchasingGroup,
  StorageLocation,
  CntrlPurgDistributionInPercent,
  TargetQuantity,
  PurgDocItmDistrLineDeltnCode,
  OrderQuantityUnit,
  _OrderQuantityUnit.UnitOfMeasureISOCode AS OrderQuantityUnitISOCode,
  DistributionType,
  ProcurementHubSourceSystem,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  PurReqnReleaseStatus,
  LastChangeDateTime
FROM R_CentralRFQItemDistributionTP
;

Learn More