P_SPQtnItmHierDraftAssocData
P_SPQtnItmHierDraftAssocData is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SPQtnItemDraftHierAssocBase) and exposes 67 fields with key field SrcgProjQtnItemUUID.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SPQtnItemDraftHierAssocBase | I_SPQtnItemDraftHierAssocBase | from |
Annotations (4)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view |
Fields (67)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SrcgProjQtnItemUUID | SrcgProjQtnItemUUID | Supplier Quotation Item UUID | |
| SourcingProjectQuotationUUID | SourcingProjectQuotationUUID | Supplier Quotation UUID | ||
| SrcgProjQuotationItemType | SrcgProjQuotationItemType | Item Type | ||
| SourcingProjectItemTypeName | ||||
| SrcgProjQtnItemClassification | SrcgProjQtnItemClassification | Item Classification | ||
| SrcgProjItemClassificationName | ||||
| SourcingProjectQuotation | SourcingProjectQuotation | Supplier Quotation | ||
| SourcingProjectQuotationName | SourcingProjectQuotationName | Name | ||
| SourcingProjectQuotationItem | SourcingProjectQuotationItem | Item | ||
| SourcingProjectQuotationType | SourcingProjectQuotationType | Sourcing Project Quotation Type | ||
| SrcgProjQuotationTypeText | ||||
| SrcgProjQtnItemDescription | SrcgProjQtnItemDescription | Description | ||
| AlternativeItemID | AlternativeItemID | Alternative Item ID | ||
| HierarchyLevel | ||||
| Material | Material | Vehicle Model | ||
| ProductType | ProductType | Product Type Group | ||
| ProductTypeName | ||||
| MaterialGroup | MaterialGroup | Product Group | ||
| MaterialGroupName | ||||
| RequestedQuantityUnit | RequestedQuantityUnit | Requested Quantity Unit | ||
| UnitOfMeasureName | ||||
| Plant | Plant | Valuation Area | ||
| PlantName | _BackendPlantForPurg | PlantName | Plant Name | |
| CompanyCode | CompanyCode | Receiver Company Code | ||
| CompanyCodeName | _BackendCoCodeForPurg | CompanyCodeName | Company Name | |
| PurchasingGroup | PurchasingGroup | Purchasing Group | ||
| PurchasingOrganization | PurchasingOrganization | Purchasing Organization | ||
| ProcmtHubPurgOrgName | _ProcmtHubPurgOrg | ProcmtHubPurgOrgName | ||
| ProcurementHubSourceSystem | ProcurementHubSourceSystem | Connected System ID | ||
| ProcurementHubSourceSystemName | _BackendCoCodeForPurg | ProcurementHubSourceSystemName | Connected Sys Name | |
| SourcingProjectItemIconURI | _SrcgProjQtnItemClassification | SourcingProjectItemIconURI | Sourcing Project Item Icon | |
| SrcgProjQtnItemOfferingCode | SrcgProjQtnItemOfferingCode | Item Offering Code | ||
| SrcgProjQtnItmOfferingCodeName | ||||
| DeviationPercentUnit | _DeviationPercentUnit | UnitOfMeasure | Unit Protected Qty | |
| ExchangeRateType | ||||
| SourcingProject | ||||
| SourcingProjectName | ||||
| SourcingProjectVersion | ||||
| SourcingProjectType | ||||
| SrcgProjItemTotalTargetAmount | _SourcingProjectItem | SrcgProjItemTotalTargetAmount | Total Target Amount | |
| DocumentCurrency | _SourcingProjectItem | DocumentCurrency | Document Currency | |
| SrcgProjAttchsAreForbidden | _SourcingProjectQuotation | SrcgProjAttchsAreForbidden | Forbid Attachments | |
| SrcgProjNotesAreForbidden | _SourcingProjectQuotation | SrcgProjNotesAreForbidden | Forbid Notes | |
| SrcgProjNegttnTargetNetPrcAmt | _NegotiationItem | SrcgProjNegttnTargetNetPrcAmt | Negotiation Target per UoM | |
| SrcgProjNegttnTargetQuantity | _NegotiationItem | SrcgProjNegttnTargetQuantity | Negotiation Target Quantity | |
| MaximumRequestedQuantity | _SourcingProjectItem | MaximumRequestedQuantity | Max. Requested Quantity | |
| SrcgProjItemTargetAmount | _SourcingProjectItem | SrcgProjItemTargetAmount | Target Price | |
| SrcgProjItmTgtAmtQuantity | _SourcingProjectItem | SrcgProjItmTgtAmtQuantity | Price Unit for Target Price | |
| SrcgProjQuotationVersion | _SourcingProjectQuotation | SrcgProjQuotationVersion | Version | |
| SrcgProjQtnSuitabilityText | ||||
| SrcgProjQtnItemSuitability | SrcgProjQtnItemSuitability | Suitability | ||
| SrcgProjItemDemandConfCodeName | ||||
| SourcingProjectReasonText | ||||
| SrcgProjItemDemandConfCode | _SourcingProjectItem | SrcgProjItemDemandConfCode | Confirmation Code | |
| SrcgProjItemUnconfdDemandRsn | _SourcingProjectItem | SrcgProjItemUnconfdDemandRsn | Rsn for Unconfd Dmnd | |
| SrcgProjQtnItemExcludingRsnTxt | ||||
| SrcgProjNegttnItmInclusionName | ||||
| SPQtnItemProdFprntCollCodeName | ||||
| _SrcgProjQtnItemClassification | _SrcgProjQtnItemClassification | |||
| _BackendCoCodeForPurg | _BackendCoCodeForPurg | |||
| _BackendPlantForPurg | _BackendPlantForPurg | |||
| _MaterialGroupText | _MaterialGroupText | |||
| _ProcmtHubPurgOrg | _ProcmtHubPurgOrg | |||
| _ProductTypeCodeText | _ProductTypeCodeText | |||
| _RequestedQuantityUnit | _RequestedQuantityUnit | |||
| _SrcgProjQtnItemClassfctnText | _SrcgProjQtnItemClassfctnText | |||
| _UnitOfMeasureText | _UnitOfMeasureText |
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 P_SPQtnItmHierDraftAssocData.
-- 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 P_SPQtnItmHierDraftAssocData AS
SELECT
SrcgProjQtnItemUUID,
SourcingProjectQuotationUUID,
SrcgProjQuotationItemType,
_SrcgProjQtnItemTypeText[ Language = $session.system_language ].SourcingProjectItemTypeName AS SourcingProjectItemTypeName,
SrcgProjQtnItemClassification,
_SrcgProjQtnItemClassfctnText[ Language = $session.system_language ].SrcgProjItemClassificationName AS SrcgProjItemClassificationName,
SourcingProjectQuotation,
SourcingProjectQuotationName,
SourcingProjectQuotationItem,
SourcingProjectQuotationType,
_SrcgProjQuotationTypeText[ Language = $session.system_language ].SourcingProjectTypeText AS SrcgProjQuotationTypeText,
SrcgProjQtnItemDescription,
AlternativeItemID,
cast( 0 as abap.int4 ) AS HierarchyLevel,
Material,
ProductType,
_ProductTypeCodeText[ Language = $session.system_language ].Name AS ProductTypeName,
MaterialGroup,
_MaterialGroupText[ Language = $session.system_language ].MaterialGroupName AS MaterialGroupName,
RequestedQuantityUnit,
_UnitOfMeasureText[ Language = $session.system_language ].UnitOfMeasureName AS UnitOfMeasureName,
Plant,
_BackendPlantForPurg.PlantName AS PlantName,
CompanyCode,
_BackendCoCodeForPurg.CompanyCodeName AS CompanyCodeName,
PurchasingGroup,
PurchasingOrganization,
_ProcmtHubPurgOrg.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
ProcurementHubSourceSystem,
_BackendCoCodeForPurg.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName,
_SrcgProjQtnItemClassification.SourcingProjectItemIconURI AS SourcingProjectItemIconURI,
SrcgProjQtnItemOfferingCode,
_SrcgProjQtnItemOfferCode._SrcgProjQtnItemOfferCodeText[ Language = $session.system_language ].SrcgProjQtnItmOfferingCodeName AS SrcgProjQtnItmOfferingCodeName,
_DeviationPercentUnit.UnitOfMeasure AS DeviationPercentUnit,
_SourcingProjectItem._SourcingProject.ExchangeRateType AS ExchangeRateType,
_SourcingProjectItem._SourcingProject.SourcingProject AS SourcingProject,
_SourcingProjectItem._SourcingProject.SourcingProjectName AS SourcingProjectName,
_SourcingProjectItem._SourcingProject.SourcingProjectVersion AS SourcingProjectVersion,
_SourcingProjectItem._SourcingProject.SourcingProjectType AS SourcingProjectType,
_SourcingProjectItem.SrcgProjItemTotalTargetAmount AS SrcgProjItemTotalTargetAmount,
_SourcingProjectItem.DocumentCurrency AS DocumentCurrency,
_SourcingProjectQuotation.SrcgProjAttchsAreForbidden AS SrcgProjAttchsAreForbidden,
_SourcingProjectQuotation.SrcgProjNotesAreForbidden AS SrcgProjNotesAreForbidden,
_NegotiationItem.SrcgProjNegttnTargetNetPrcAmt AS SrcgProjNegttnTargetNetPrcAmt,
_NegotiationItem.SrcgProjNegttnTargetQuantity AS SrcgProjNegttnTargetQuantity,
_SourcingProjectItem.MaximumRequestedQuantity AS MaximumRequestedQuantity,
_SourcingProjectItem.SrcgProjItemTargetAmount AS SrcgProjItemTargetAmount,
_SourcingProjectItem.SrcgProjItmTgtAmtQuantity AS SrcgProjItmTgtAmtQuantity,
_SourcingProjectQuotation.SrcgProjQuotationVersion AS SrcgProjQuotationVersion,
_SrcgProjQtnSuitabilityTxt[1:Language = $session.system_language ].SrcgProjQtnSuitabilityText AS SrcgProjQtnSuitabilityText,
SrcgProjQtnItemSuitability,
_SourcingProjectItem._SrcgProjItemDemandConfCode._Text[1:Language = $session.system_language ].SrcgProjItemDemandConfCodeName AS SrcgProjItemDemandConfCodeName,
_SourcingProjectItem._SourcingProjectReason._SourcingProjectReasonText[1:Language = $session.system_language ].ProductSourcingReasonText AS SourcingProjectReasonText,
_SourcingProjectItem.SrcgProjItemDemandConfCode AS SrcgProjItemDemandConfCode,
_SourcingProjectItem.SrcgProjItemUnconfdDemandRsn AS SrcgProjItemUnconfdDemandRsn,
_SourcingProjectReasonText[1:Language = $session.system_language].ProductSourcingReasonText AS SrcgProjQtnItemExcludingRsnTxt,
_SPNegttnQtnItemInclsnText[1:Language = $session.system_language ].SrcgProjNegttnItmInclusionName AS SrcgProjNegttnItmInclusionName,
_SPQtnItmProdFprntCollCodeTxt[1:Language = $session.system_language ].SPQtnItemProdFprntCollCodeName AS SPQtnItemProdFprntCollCodeName
FROM I_SPQtnItemDraftHierAssocBase
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA