C_SrcgProjQtnItmDmndDistrDetTP

DDL: C_SRCGPROJQTNITMDMNDDISTRDETTP Type: view_entity CONSUMPTION

Dmnd Distr Details for Itm in SPQtn - TP

C_SrcgProjQtnItmDmndDistrDetTP is a Consumption CDS View that provides data about "Dmnd Distr Details for Itm in SPQtn - TP" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjQtnItmDmndDistrDetTP) and exposes 9 fields with key field SrcgProjQtnDmndDistrDetsUUID. It is exposed through 1 OData service (UI_SRCGPROJQUOTATION_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjQtnItmDmndDistrDetTP R_SrcgProjQtnItmDmndDistrDetTP projection

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SrcgProjQtnDmndDistrDetsUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
EndUserText.label Dmnd Distr Details for Itm in SPQtn - TP view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SQK view
AbapCatalog.extensibility.quota.maximumFields 608 view
AbapCatalog.extensibility.quota.maximumBytes 60800 view
AbapCatalog.extensibility.allowNewCompositions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SRCGPROJQUOTATION_MANAGE UI_SRCGPROJQTN_MANAGE V2 C1 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjQtnDmndDistrDetsUUID SrcgProjQtnDmndDistrDetsUUID Demand Distribution Details UUID
SrcgProjQtnDmndDistrUUID SrcgProjQtnDmndDistrUUID Demand Distribution UUID in Quotation
SourcingProjectQuotationUUID SourcingProjectQuotationUUID Supplier Quotation UUID
FiscalYear G/L Fiscal Year
RequestedQuantity RequestedQuantity Requested Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
SrcgProjQtnOfferedQuantity SrcgProjQtnOfferedQuantity Offered Quantity
SrcgProjNegttnTargetQuantity _SPNegttnQtnItmDmndDistrDet SrcgProjNegttnTargetQuantity Negotiation Target Quantity
SPNegttnQtnItmDmndDistrDetUUID SPNegttnQtnItmDmndDistrDetUUID Demand Distribution Detail UUID

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 C_SrcgProjQtnItmDmndDistrDetTP.
-- 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 C_SrcgProjQtnItmDmndDistrDetTP AS
SELECT
  SrcgProjQtnDmndDistrDetsUUID,
  SrcgProjQtnDmndDistrUUID,
  SourcingProjectQuotationUUID,
  cast( FiscalYear as vdm_srcgprojitmdmnddistryear preserving type ) AS FiscalYear,
  RequestedQuantity,
  RequestedQuantityUnit,
  SrcgProjQtnOfferedQuantity,
  _SPNegttnQtnItmDmndDistrDet.SrcgProjNegttnTargetQuantity AS SrcgProjNegttnTargetQuantity,
  SPNegttnQtnItmDmndDistrDetUUID
FROM R_SrcgProjQtnItmDmndDistrDetTP
;