C_SPNegttnQtnItmDmndDistrDetTP

DDL: C_SPNEGTTNQTNITMDMNDDISTRDETTP Type: view_entity CONSUMPTION
15 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Dmnd Distr Dets for Srcg Proj Negttn-TP

C_SPNegttnQtnItmDmndDistrDetTP is a Consumption CDS View that provides data about "Dmnd Distr Dets for Srcg Proj Negttn-TP" in SAP S/4HANA. It reads from 1 data source (R_SPNegttnQtnItmDmndDistrDetTP) and exposes 15 fields with key field SPNegttnQtnItmDmndDistrDetUUID. It is exposed through 1 OData service (UI_SRCGPROJNEGTTN_MANAGE). It is used in 1 Fiori application: Manage Negotiations.

Data Sources (1)

SourceAliasJoin Type
R_SPNegttnQtnItmDmndDistrDetTP R_SPNegttnQtnItmDmndDistrDetTP projection

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SPNegttnQtnItmDmndDistrDetUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SNT view
AbapCatalog.extensibility.quota.maximumFields 404 view
AbapCatalog.extensibility.quota.maximumBytes 40400 view
AbapCatalog.extensibility.allowNewCompositions true view
Metadata.allowExtensions true view
EndUserText.label Dmnd Distr Dets for Srcg Proj Negttn-TP view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SRCGPROJNEGTTN_MANAGE UI_SRCGPROJNEGTTN_MANAGE V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F5551 Manage Negotiations Transactional An application to manage the negotiation of Sourcing Project Quotations.

Manage Negotiations

Business Role: Purchaser

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SPNegttnQtnItmDmndDistrDetUUID _SPNegttnQtnItmDmndDistrDetTP SPNegttnQtnItmDmndDistrDetUUID Demand Distribution Detail UUID
SPNegttnQtnItemDemandDistrUUID _SPNegttnQtnItmDmndDistrDetTP SPNegttnQtnItemDemandDistrUUID Demand Distribution UUID of Item
SourcingProjectNegotiationUUID _SPNegttnQtnItmDmndDistrDetTP SourcingProjectNegotiationUUID Negotiation UUID
SrcgProjQtnDmndDistrDetsUUID _SPNegttnQtnItmDmndDistrDetTP SrcgProjQtnDmndDistrDetsUUID Demand Distribution Details UUID
FiscalYear _SPNegttnQtnItmDmndDistrDetTP FiscalYear G/L Fiscal Year
SrcgProjNegttnTargetQuantity _SPNegttnQtnItmDmndDistrDetTP SrcgProjNegttnTargetQuantity Negotiation Target Quantity
RequestedQuantity _SPNegttnQtnItmDmndDistrDetTP RequestedQuantity Requested Quantity
SrcgProjQtnOfferedQuantity _SPNegttnQtnItmDmndDistrDetTP SrcgProjQtnOfferedQuantity Offered Quantity
RequestedQuantityUnit _SPNegttnQtnItmDmndDistrDetTP RequestedQuantityUnit Requested Quantity Unit
SourcingProjectItemStableUUID
SrcgProjQtnDmndDistrUUID _SPNegttnQtnItemDemandDistrTP SrcgProjQtnDmndDistrUUID Demand Distribution UUID in Quotation
SrcgProjNegttnQtanItemUUID _SPNegttnQtnItemDemandDistrTP SrcgProjNegttnQtanItemUUID UUID of Quotation Item in Negotiation
SrcgProjDmndDistributionUUID _SPNegttnQtnItmDmndDistrDetTP SrcgProjDmndDistributionUUID Demand Distribution UUID
SourcingProjectUUID _SPNegttnQtnItmDmndDistrDetTP SourcingProjectUUID Sourcing Project UUID
SrcgProjNegttnItmInclusionType _SPNegttnQtnItmDmndDistrDetTP SrcgProjNegttnItmInclusionType Negotiation Item Include Type Code

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_SPNegttnQtnItmDmndDistrDetTP.
-- 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_SPNegttnQtnItmDmndDistrDetTP AS
SELECT
  _SPNegttnQtnItmDmndDistrDetTP.SPNegttnQtnItmDmndDistrDetUUID AS SPNegttnQtnItmDmndDistrDetUUID,
  _SPNegttnQtnItmDmndDistrDetTP.SPNegttnQtnItemDemandDistrUUID AS SPNegttnQtnItemDemandDistrUUID,
  _SPNegttnQtnItmDmndDistrDetTP.SourcingProjectNegotiationUUID AS SourcingProjectNegotiationUUID,
  _SPNegttnQtnItmDmndDistrDetTP.SrcgProjQtnDmndDistrDetsUUID AS SrcgProjQtnDmndDistrDetsUUID,
  _SPNegttnQtnItmDmndDistrDetTP.FiscalYear AS FiscalYear,
  _SPNegttnQtnItmDmndDistrDetTP.SrcgProjNegttnTargetQuantity AS SrcgProjNegttnTargetQuantity,
  _SPNegttnQtnItmDmndDistrDetTP.RequestedQuantity AS RequestedQuantity,
  _SPNegttnQtnItmDmndDistrDetTP.SrcgProjQtnOfferedQuantity AS SrcgProjQtnOfferedQuantity,
  _SPNegttnQtnItmDmndDistrDetTP.RequestedQuantityUnit AS RequestedQuantityUnit,
  _SPNegttnQtnItemDemandDistrTP._SrcgProjNegttnQtanItem.SourcingProjectItemStableUUID AS SourcingProjectItemStableUUID,
  _SPNegttnQtnItemDemandDistrTP.SrcgProjQtnDmndDistrUUID AS SrcgProjQtnDmndDistrUUID,
  _SPNegttnQtnItemDemandDistrTP.SrcgProjNegttnQtanItemUUID AS SrcgProjNegttnQtanItemUUID,
  _SPNegttnQtnItmDmndDistrDetTP.SrcgProjDmndDistributionUUID AS SrcgProjDmndDistributionUUID,
  _SPNegttnQtnItmDmndDistrDetTP.SourcingProjectUUID AS SourcingProjectUUID,
  _SPNegttnQtnItmDmndDistrDetTP.SrcgProjNegttnItmInclusionType AS SrcgProjNegttnItmInclusionType
FROM R_SPNegttnQtnItmDmndDistrDetTP
;

Learn More