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 13 fields with key field SrcgProjQtnDmndDistrDetsUUID.

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

Fields (13)

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
MaximumRequestedPeriodQuantity MaximumRequestedPeriodQuantity
MaximumOfferedPeriodQuantity MaximumOfferedPeriodQuantity
RequestedCommitmentPeriod _SrcgProjQtnDmndDistr RequestedCommitmentPeriod
RequestedCommitmentPeriodNamelocalized
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,
  MaximumRequestedPeriodQuantity,
  MaximumOfferedPeriodQuantity,
  _SrcgProjQtnDmndDistr.RequestedCommitmentPeriod AS RequestedCommitmentPeriod,
  _SrcgProjQtnDmndDistr._SPItmDmndDistrReqdCmtmtPerdT.RequestedCommitmentPeriodName : localized AS RequestedCommitmentPeriodNamelocalized,
  _SPNegttnQtnItmDmndDistrDet.SrcgProjNegttnTargetQuantity AS SrcgProjNegttnTargetQuantity,
  SPNegttnQtnItmDmndDistrDetUUID
FROM R_SrcgProjQtnItmDmndDistrDetTP
;