P_SrcgProjItemHierDraftText
P_SrcgProjItemHierDraftText is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_SrcgProjItmHierDraftTxtBase) and exposes 65 fields with key field SourcingProjectItemUUID. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SrcgProjItmHierDraftTxtBase | I_SrcgProjItmHierDraftTxtBase | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | R_SrcgProjItemQuotationCount | _SrcgProjItmQuotationCount | $projection.SourcingProjectItemUUID = _SrcgProjItmQuotationCount.SourcingProjectItemUUID |
| [1..1] | R_SrcgProjItemAwardedDetails | _SrcgProjItmAwardedDetails | $projection.SourcingProjectItemUUID = _SrcgProjItmAwardedDetails.SourcingProjectItemUUID |
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 (65)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SourcingProjectItemUUID | SourcingProjectItemUUID | Item UUID | |
| SourcingProjectUUID | SourcingProjectUUID | Sourcing Project UUID | ||
| SourcingProjectItemType | SourcingProjectItemType | Item Type | ||
| SourcingProjectItemTypeName | ||||
| SrcgProjItemClassification | SrcgProjItemClassification | Item Classification | ||
| SrcgProjItemClassificationName | ||||
| SourcingProject | SourcingProject | Sourcing Project | ||
| SourcingProjectName | SourcingProjectName | Name | ||
| SrcgProjLifecycleStatus | SrcgProjLifecycleStatus | Status | ||
| SourcingProjectType | SourcingProjectType | Sourcing Project Type | ||
| SourcingProjectTypeText | ||||
| SrcgProjItemDescription | SrcgProjItemDescription | Description | ||
| AlternativeItemID | AlternativeItemID | Alternative Item ID | ||
| HierarchyLevel | ||||
| Material | Material | Vehicle Model | ||
| MaterialName | ||||
| ProductType | ProductType | Product Type Group | ||
| ProductTypeName | ||||
| MaterialGroup | MaterialGroup | Product Group | ||
| MaterialGroupName | ||||
| RequestedQuantityUnit | RequestedQuantityUnit | Requested Quantity Unit | ||
| UnitOfMeasureName | ||||
| SourcingScenario | SourcingScenario | Integration Scenario | ||
| SrcgProjSourcingScenarioText | ||||
| SourcingOrigin | SourcingOrigin | Sourcing Origin | ||
| SrcgProjSourcingOriginText | ||||
| 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 | _SrcgProjItemClassification | SourcingProjectItemIconURI | Sourcing Project Item Icon | |
| PurchasingDocumentCategoryName | ||||
| SrcgProjFollowOnDocumentCat | SrcgProjFollowOnDocumentCat | Follow-On Document Category | ||
| SrcgProjFollowOnDocumentType | SrcgProjFollowOnDocumentType | Follow-On Document Type | ||
| PurchasingDocumentTypeName | ||||
| SrcgProjItemDemandConfCode | SrcgProjItemDemandConfCode | Confirmation Code | ||
| SrcgProjItemDemandConfCodeName | ||||
| SrcgProjItemUnconfdDemandRsn | SrcgProjItemUnconfdDemandRsn | Rsn for Unconfd Dmnd | ||
| SourcingProjectReasonText | ||||
| SrcgProjectItemSettledStatus | SrcgProjectItemSettledStatus | Item Status | ||
| SrcgProjItemSettledStatusName | ||||
| NumberOfAwardedQuotations | _SrcgProjItmQuotationCount | NumberOfAwardedQuotations | ||
| NumberOfSubmittedQuotations | _SrcgProjItmQuotationCount | NumberOfSubmittedQuotations | ||
| SrcgProjTotalNumberOfQuotation | _SrcgProjItmQuotationCount | SrcgProjTotalNumberOfQuotation | ||
| SrcgProjItmRemainingQuantity | _SrcgProjItmAwardedDetails | SrcgProjItmRemainingQuantity | ||
| SrcgProjQtnOfferedQuantity | _SrcgProjItmAwardedDetails | SrcgProjQtnOfferedQuantity | Offered Quantity | |
| SourceSourcingProject | ||||
| SourceSourcingProjectItem | _SourceSourcingProjectItem | SourcingProjectItem | Item | |
| _SrcgProjItemClassification | _SrcgProjItemClassification | |||
| _BackendCoCodeForPurg | _BackendCoCodeForPurg | |||
| _MaterialGroupText | _MaterialGroupText | |||
| _UnitOfMeasureText | _UnitOfMeasureText | |||
| _PurgDocumentCategoryText | _PurgDocumentCategoryText | |||
| _BackendPlantForPurg | _BackendPlantForPurg | |||
| _ProcmtHubPurgOrg | _ProcmtHubPurgOrg | |||
| _SourcingProjectItemTypeText | _SourcingProjectItemTypeText | |||
| _SrcgProjItemClassfctnText | _SrcgProjItemClassfctnText | |||
| _ProductTypeCodeText | _ProductTypeCodeText | |||
| _RequestedQuantityUnit | _RequestedQuantityUnit | |||
| _PurchasingDocumentTypeText | _PurchasingDocumentTypeText |
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_SrcgProjItemHierDraftText.
-- 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.
-- SQL view name: PSRCGPIDTXT
CREATE VIEW P_SrcgProjItemHierDraftText AS
SELECT
SourcingProjectItemUUID,
SourcingProjectUUID,
SourcingProjectItemType,
_SourcingProjectItemTypeText[ Language = $session.system_language ].SourcingProjectItemTypeName AS SourcingProjectItemTypeName,
SrcgProjItemClassification,
_SrcgProjItemClassfctnText[ Language = $session.system_language ].SrcgProjItemClassificationName AS SrcgProjItemClassificationName,
SourcingProject,
SourcingProjectName,
SrcgProjLifecycleStatus,
SourcingProjectType,
_SourcingProjectTypeText[ Language = $session.system_language ].SourcingProjectTypeText AS SourcingProjectTypeText,
SrcgProjItemDescription,
AlternativeItemID,
cast( 0 as abap.int4 ) AS HierarchyLevel,
Material,
_MaterialText[ Language = $session.system_language ].MaterialName AS MaterialName,
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,
SourcingScenario,
_SrcgProjSourcingScenarioText[ Language = $session.system_language ].SrcgProjSourcingScenarioText AS SrcgProjSourcingScenarioText,
SourcingOrigin,
_SrcgProjSourcingOriginText[ Language = $session.system_language ].SrcgProjSourcingOriginText AS SrcgProjSourcingOriginText,
Plant,
_BackendPlantForPurg.PlantName AS PlantName,
CompanyCode,
_BackendCoCodeForPurg.CompanyCodeName AS CompanyCodeName,
PurchasingGroup,
PurchasingOrganization,
_ProcmtHubPurgOrg.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
ProcurementHubSourceSystem,
_BackendCoCodeForPurg.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName,
_SrcgProjItemClassification.SourcingProjectItemIconURI AS SourcingProjectItemIconURI,
_PurgDocumentCategoryText[ Language = $session.system_language ].PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
SrcgProjFollowOnDocumentCat,
SrcgProjFollowOnDocumentType,
_PurchasingDocumentTypeText[ Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
SrcgProjItemDemandConfCode,
_SrcgProjItemDmndConfCodeText[1:Language = $session.system_language ].SrcgProjItemDemandConfCodeName AS SrcgProjItemDemandConfCodeName,
SrcgProjItemUnconfdDemandRsn,
_SourcingProjectReasonText[1:Language = $session.system_language ].ProductSourcingReasonText AS SourcingProjectReasonText,
SrcgProjectItemSettledStatus,
_SrcgProjItmSettledStatusText[1:Language = $session.system_language ].SrcgProjItemSettledStatusName AS SrcgProjItemSettledStatusName,
_SrcgProjItmQuotationCount.NumberOfAwardedQuotations AS NumberOfAwardedQuotations,
_SrcgProjItmQuotationCount.NumberOfSubmittedQuotations AS NumberOfSubmittedQuotations,
_SrcgProjItmQuotationCount.SrcgProjTotalNumberOfQuotation AS SrcgProjTotalNumberOfQuotation,
_SrcgProjItmAwardedDetails.SrcgProjItmRemainingQuantity AS SrcgProjItmRemainingQuantity,
_SrcgProjItmAwardedDetails.SrcgProjQtnOfferedQuantity AS SrcgProjQtnOfferedQuantity,
_SourceSourcingProjectItem._SourcingProject.SourcingProject AS SourceSourcingProject,
_SourceSourcingProjectItem.SourcingProjectItem AS SourceSourcingProjectItem
FROM I_SrcgProjItmHierDraftTxtBase
LEFT OUTER JOIN R_SrcgProjItemQuotationCount AS _SrcgProjItmQuotationCount ON SourcingProjectItemUUID = _SrcgProjItmQuotationCount.SourcingProjectItemUUID -- association [1..1]
LEFT OUTER JOIN R_SrcgProjItemAwardedDetails AS _SrcgProjItmAwardedDetails ON SourcingProjectItemUUID = _SrcgProjItmAwardedDetails.SourcingProjectItemUUID -- association [1..1]
;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