A_SrcgProjQtnItmDmndDistrDet

DDL: A_SRCGPROJQTNITMDMNDDISTRDET Type: view_entity CONSUMPTION
8 Fields 1 Data Sources 1 OData Services

Demand Distribution Details

A_SrcgProjQtnItmDmndDistrDet is a Consumption CDS View that provides data about "Demand Distribution Details" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjQtnItmDmndDistrDetTP) and exposes 8 fields with key field SrcgProjQtnDmndDistrDetsUUID. It is exposed through 1 OData service (API_SOURCINGPROJECTQUOTATION).

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjQtnItmDmndDistrDetTP R_SrcgProjQtnItmDmndDistrDetTP projection

Annotations (16)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjQtnDmndDistrDetsUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Demand Distribution Details view
OData.entityType.name SrcgProjQtnDmndDistrDetails_Type view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SQK view
AbapCatalog.extensibility.quota.maximumFields 408 view
AbapCatalog.extensibility.quota.maximumBytes 8160 view
AbapCatalog.extensibility.allowNewCompositions true view

OData Services (1)

ServiceBindingVersionContractRelease
API_SOURCINGPROJECTQUOTATION API_SRCGPROJQUOTATION V4 C2 C1

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjQtnDmndDistrDetsUUID SrcgProjQtnDmndDistrDetsUUID Demand Distribution Details UUID
SrcgProjQtnDmndDistrUUID SrcgProjQtnDmndDistrUUID Demand Distribution UUID in Quotation
SourcingProjectQuotationUUID SourcingProjectQuotationUUID Supplier Quotation UUID
FiscalYear FiscalYear G/L Fiscal Year
RequestedQuantity RequestedQuantity Requested Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
RequestedQuantityISOUnit
SrcgProjQtnOfferedQuantity SrcgProjQtnOfferedQuantity Offered Quantity

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_SrcgProjQtnItmDmndDistrDet.
-- 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_SrcgProjQtnItmDmndDistrDet AS
SELECT
  SrcgProjQtnDmndDistrDetsUUID,
  SrcgProjQtnDmndDistrUUID,
  SourcingProjectQuotationUUID,
  FiscalYear,
  RequestedQuantity,
  RequestedQuantityUnit,
  cast(_RequestedQuantityUnit.UnitOfMeasureISOCode as vdm_requested_iso_unit preserving type ) AS RequestedQuantityISOUnit,
  SrcgProjQtnOfferedQuantity
FROM R_SrcgProjQtnItmDmndDistrDetTP
;

Learn More