I_SrcgProjQtnItmDmndDistrTP

DDL: I_SRCGPROJQTNITMDMNDDISTRTP Type: view_entity TRANSACTIONAL

Dmnd Distr for Itm in Srcg Proj Qtn - TP

I_SrcgProjQtnItmDmndDistrTP is a Transactional 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 17 fields with key field SrcgProjQtnDmndDistrUUID.

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjQtnItmDmndDistrTP R_SrcgProjQtnItmDmndDistrTP projection

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SrcgProjQtnDmndDistrUUID view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name SrcgProjQtnItmDmndDistribution view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API 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 408 view
AbapCatalog.extensibility.quota.maximumBytes 8160 view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (17)

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
Plant Plant Valuation Area
CompanyCode CompanyCode Receiver Company Code
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
MaxAnnualRequestedQuantity MaxAnnualRequestedQuantity Max. Requested Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
SrcgProjQtnTotOfferedQuantity SrcgProjQtnTotOfferedQuantity Total Offered Quantity
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays Plnd dely time
StorageLocation StorageLocation StorageLocation
ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID Plant Unique ID
RequestedCommitmentPeriod RequestedCommitmentPeriod

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_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 I_SrcgProjQtnItmDmndDistrTP AS
SELECT
  SrcgProjQtnDmndDistrUUID,
  SourcingProjectQuotationUUID,
  SrcgProjQtnItemUUID,
  SrcgProjDmndDistributionUUID,
  ProcurementProject,
  Plant,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  ProcurementHubSourceSystem,
  MaxAnnualRequestedQuantity,
  RequestedQuantityUnit,
  SrcgProjQtnTotOfferedQuantity,
  PlannedDeliveryDurationInDays,
  StorageLocation,
  ProcmtHubPlantUniqueID,
  RequestedCommitmentPeriod
FROM R_SrcgProjQtnItmDmndDistrTP
;