C_SrcgProjQtnItmDmndDistrTP

DDL: C_SRCGPROJQTNITMDMNDDISTRTP Type: view_entity CONSUMPTION
27 Fields 1 Data Sources 1 OData Services

Dmnd Distr for Itm in Srcg Proj Qtn - TP

C_SrcgProjQtnItmDmndDistrTP is a Consumption CDS View that provides data about "Dmnd Distr for Itm in Srcg Proj Qtn - TP" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjQtnItmDmndDistrTP) and exposes 27 fields with key field SrcgProjQtnDmndDistrUUID. It is exposed through 1 OData service (UI_SRCGPROJQUOTATION_MANAGE).

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjQtnItmDmndDistrTP R_SrcgProjQtnItmDmndDistrTP projection

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SrcgProjQtnDmndDistrUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
EndUserText.label Dmnd Distr for Itm in Srcg Proj Qtn - TP view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.elementSuffix SQD 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 (27)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjQtnDmndDistrUUID SrcgProjQtnDmndDistrUUID Demand Distribution UUID in Quotation
SourcingProjectQuotationUUID SourcingProjectQuotationUUID Supplier Quotation UUID
SrcgProjQtnItemUUID SrcgProjQtnItemUUID Supplier Quotation Item UUID
SrcgProjDmndDistributionUUID SrcgProjDmndDistributionUUID Demand Distribution UUID
ProcurementProject ProcurementProject Project
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _ProcmtHubCompanyCode CompanyCodeName Company Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
MaxAnnualRequestedQuantity MaxAnnualRequestedQuantity Max. Requested Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
SrcgProjQtnTotOfferedQuantity SrcgProjQtnTotOfferedQuantity Total Offered Quantity
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
StorageLocation StorageLocation StorageLocation
ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID Plant Unique ID
SrcgProjQtnItemOfferingCode _SrcgProjQtnItem SrcgProjQtnItemOfferingCode Item Offering Code
SourcingProjectQuotationType _SourcingProjectQuotation SourcingProjectQuotationType Sourcing Project Quotation Type
SrcgProjItemDemandConfCodeNamelocalized
SrcgProjItemDemandConfCode _SrcgProjDemandDistribution SrcgProjItemDemandConfCode Confirmation Code
SrcgProjItemUnconfdDemandRsn _SrcgProjDemandDistribution SrcgProjItemUnconfdDemandRsn Rsn for Unconfd Dmnd
char1
_Plant _Plant
_ProcmtHubCompanyCode _ProcmtHubCompanyCode

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_SrcgProjQtnItmDmndDistrTP.
-- 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_SrcgProjQtnItmDmndDistrTP AS
SELECT
  SrcgProjQtnDmndDistrUUID,
  SourcingProjectQuotationUUID,
  SrcgProjQtnItemUUID,
  SrcgProjDmndDistributionUUID,
  ProcurementProject,
  ProcurementHubSourceSystem,
  CompanyCode,
  _ProcmtHubCompanyCode.CompanyCodeName AS CompanyCodeName,
  Plant,
  _Plant.PlantName AS PlantName,
  MaxAnnualRequestedQuantity,
  RequestedQuantityUnit,
  SrcgProjQtnTotOfferedQuantity,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  StorageLocation,
  ProcmtHubPlantUniqueID,
  _SrcgProjQtnItem.SrcgProjQtnItemOfferingCode AS SrcgProjQtnItemOfferingCode,
  _SourcingProjectQuotation.SourcingProjectQuotationType AS SourcingProjectQuotationType,
  _SrcgProjDemandDistribution._SrcgProjItemDemandConfCode._Text.SrcgProjItemDemandConfCodeName : localized AS SrcgProjItemDemandConfCodeNamelocalized,
  _SrcgProjDemandDistribution.SrcgProjItemDemandConfCode AS SrcgProjItemDemandConfCode,
  _SrcgProjDemandDistribution.SrcgProjItemUnconfdDemandRsn AS SrcgProjItemUnconfdDemandRsn,
  virtual UICT_ConfirmDemandEnablement : abap.char( 1 ) AS char1
FROM R_SrcgProjQtnItmDmndDistrTP
;

Learn More