I_SPNegttnQtnItmDmndDistrDet

DDL: I_SPNEGTTNQTNITMDMNDDISTRDET Type: view_entity BASIC Package: VDM_MM_PUR_SRCGPROJNGN
13 Fields 1 Data Sources 3 Associations

Demand Distr Dets for Srcg Proj Negttn

I_SPNegttnQtnItmDmndDistrDet is a Basic CDS View that provides data about "Demand Distr Dets for Srcg Proj Negttn" in SAP S/4HANA. It reads from 1 data source (R_SPNegttnQtnItmDmndDistrDet) and exposes 13 fields with key field SPNegttnQtnItmDmndDistrDetUUID. It has 3 associations to related views. Part of development package VDM_MM_PUR_SRCGPROJNGN.

Data Sources (1)

SourceAliasJoin Type
R_SPNegttnQtnItmDmndDistrDet R_SPNegttnQtnItmDmndDistrDet from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SPNegttnQtnItemDemandDistr _SPNegttnQtnItemDemandDistr $projection.SPNegttnQtnItemDemandDistrUUID = _SPNegttnQtnItemDemandDistr.SPNegttnQtnItemDemandDistrUUID
[1..1] I_SrcgProjQtnItmDmndDistrDet _SrcgProjQtnItmDmndDistrDet $projection.SrcgProjQtnDmndDistrDetsUUID = _SrcgProjQtnItmDmndDistrDet.SrcgProjQtnDmndDistrDetsUUID
[1..1] I_SrcgProjQtnItmDmndDistr _SrcgProjQtnDmndDistr $projection.SrcgProjQtnDmndDistrUUID = _SrcgProjQtnDmndDistr.SrcgProjQtnDmndDistrUUID

Annotations (11)

NameValueLevelField
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey SPNegttnQtnItmDmndDistrDetUUID view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Demand Distr Dets for Srcg Proj Negttn view
Analytics.technicalName ISPNGNQIDDDETS view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY SPNegttnQtnItmDmndDistrDetUUID SPNegttnQtnItmDmndDistrDetUUID Demand Distribution Detail UUID
SPNegttnQtnItemDemandDistrUUID SPNegttnQtnItemDemandDistrUUID Demand Distribution UUID of Item
SrcgProjQtnDmndDistrDetsUUID SrcgProjQtnDmndDistrDetsUUID Demand Distribution Details UUID
SrcgProjQtnDmndDistrUUID SrcgProjQtnDmndDistrUUID Demand Distribution UUID in Quotation
SourcingProjectNegotiationUUID SourcingProjectNegotiationUUID Negotiation UUID
FiscalYear FiscalYear G/L Fiscal Year
SrcgProjNegttnTargetQuantity SrcgProjNegttnTargetQuantity Negotiation Target Quantity
RequestedQuantity RequestedQuantity Requested Quantity
SrcgProjQtnOfferedQuantity SrcgProjQtnOfferedQuantity Offered Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
_SPNegttnQtnItemDemandDistr _SPNegttnQtnItemDemandDistr
_SrcgProjQtnDmndDistr _SrcgProjQtnDmndDistr
_SrcgProjQtnItmDmndDistrDet _SrcgProjQtnItmDmndDistrDet

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 I_SPNegttnQtnItmDmndDistrDet.
-- 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 I_SPNegttnQtnItmDmndDistrDet AS
SELECT
  SPNegttnQtnItmDmndDistrDetUUID,
  SPNegttnQtnItemDemandDistrUUID,
  SrcgProjQtnDmndDistrDetsUUID,
  SrcgProjQtnDmndDistrUUID,
  SourcingProjectNegotiationUUID,
  FiscalYear,
  SrcgProjNegttnTargetQuantity,
  RequestedQuantity,
  SrcgProjQtnOfferedQuantity,
  RequestedQuantityUnit
FROM R_SPNegttnQtnItmDmndDistrDet
LEFT OUTER JOIN I_SPNegttnQtnItemDemandDistr AS _SPNegttnQtnItemDemandDistr ON SPNegttnQtnItemDemandDistrUUID = _SPNegttnQtnItemDemandDistr.SPNegttnQtnItemDemandDistrUUID  -- association [1..1]
LEFT OUTER JOIN I_SrcgProjQtnItmDmndDistrDet AS _SrcgProjQtnItmDmndDistrDet ON SrcgProjQtnDmndDistrDetsUUID = _SrcgProjQtnItmDmndDistrDet.SrcgProjQtnDmndDistrDetsUUID  -- association [1..1]
LEFT OUTER JOIN I_SrcgProjQtnItmDmndDistr AS _SrcgProjQtnDmndDistr ON SrcgProjQtnDmndDistrUUID = _SrcgProjQtnDmndDistr.SrcgProjQtnDmndDistrUUID  -- association [1..1]
;

Learn More