I_SrcgProjItmHierDraftTxtBase

DDL: I_SRCGPROJITMHIERDRAFTTXTBASE Type: view_entity BASIC
58 Fields 1 Data Sources 20 Associations

Itm Hierarchy in Srcg Proj - Draft Text

I_SrcgProjItmHierDraftTxtBase is a Basic CDS View that provides data about "Itm Hierarchy in Srcg Proj - Draft Text" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectItemDraft) and exposes 58 fields with key field SourcingProjectItemUUID. It has 20 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectItemDraft R_SourcingProjectItemDraft from

Associations (20)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _RequestedQuantityUnit $projection.RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure
[1..1] I_BackendCoCodeForPurg _BackendCoCodeForPurg $projection.ProcurementHubSourceSystem = _BackendCoCodeForPurg.ProcurementHubSourceSystem and $projection.CompanyCode = _BackendCoCodeForPurg.CompanyCode
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..*] I_MaterialGroupText _MaterialGroupText $projection.MaterialGroup = _MaterialGroupText.MaterialGroup
[0..*] I_UnitOfMeasureText _UnitOfMeasureText $projection.RequestedQuantityUnit = _UnitOfMeasureText.UnitOfMeasure
[0..*] I_PurgDocumentCategoryText _PurgDocumentCategoryText $projection.SrcgProjFollowOnDocumentCat = _PurgDocumentCategoryText.PurchasingDocumentCategory
[0..1] I_BackendPlantForPurg _BackendPlantForPurg $projection.Plant = _BackendPlantForPurg.Plant and $projection.CompanyCode = _BackendPlantForPurg.CompanyCode and $projection.ProcurementHubSourceSystem = _BackendPlantForPurg.ProcurementHubSourceSystem
[0..1] I_ProcmtHubPurgOrg _ProcmtHubPurgOrg $projection.PurchasingOrganization = _ProcmtHubPurgOrg.ProcmtHubPurchasingOrg and $projection.ProcurementHubSourceSystem = _ProcmtHubPurgOrg.ProcurementHubSourceSystem
[0..*] I_SourcingProjectItemTypeText _SourcingProjectItemTypeText $projection.SourcingProjectItemType = _SourcingProjectItemTypeText.SourcingProjectItemType
[0..*] I_SrcgProjItemClassfctnText _SrcgProjItemClassfctnText $projection.SrcgProjItemClassification = _SrcgProjItemClassfctnText.SrcgProjItemClassification and $projection.SourcingProjectItemType = _SrcgProjItemClassfctnText.SourcingProjectItemType
[0..*] I_ProductTypeCodeText _ProductTypeCodeText $projection.ProductType = _ProductTypeCodeText.ProductTypeCode
[0..*] I_PurchasingDocumentTypeText _PurchasingDocumentTypeText $projection.SrcgProjFollowOnDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType and $projection.SrcgProjFollowOnDocumentCat = _PurchasingDocumentTypeText.PurchasingDocumentCategory
[0..1] I_SrcgProjItemClassification _SrcgProjItemClassification $projection.SourcingProjectItemType = _SrcgProjItemClassification.SourcingProjectItemType and $projection.SrcgProjItemClassification = _SrcgProjItemClassification.SrcgProjItemClassification
[0..*] I_SourcingProjectTypeText _SourcingProjectTypeText $projection.SourcingProjectType = _SourcingProjectTypeText.SourcingProjectType
[0..*] I_SrcgProjItemDmndConfCodeText _SrcgProjItemDmndConfCodeText $projection.SrcgProjItemDemandConfCode = _SrcgProjItemDmndConfCodeText.SrcgProjItemDemandConfCode
[0..*] I_ProductSourcingReasonText _SourcingProjectReasonText $projection.SrcgProjItemUnconfdDemandRsn = _SourcingProjectReasonText.ProductSourcingReason
[0..*] I_SrcgProjItmSettledStatusText _SrcgProjItmSettledStatusText $projection.SrcgProjectItemSettledStatus = _SrcgProjItmSettledStatusText.SrcgProjectItemSettledStatus
[0..*] I_SrcgProjSourcingScenarioText _SrcgProjSourcingScenarioText $projection.SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario
[0..*] I_SrcgProjSourcingOriginText _SrcgProjSourcingOriginText $projection.SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin
[0..1] R_SourcingProjectItemDraft _SourceSourcingProjectItem $projection.SourceSourcingProjectItemUUID = _SourceSourcingProjectItem.SourcingProjectItemUUID

Annotations (9)

NameValueLevelField
ObjectModel.representativeKey SourcingProjectItemUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
AccessControl.authorizationCheck #MANDATORY view
Analytics.technicalName ItmHierDraftTxt view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Itm Hierarchy in Srcg Proj - Draft Text view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectItemUUID SourcingProjectItemUUID Item UUID
SourcingProjectItem SourcingProjectItem Item
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProjectItemType SourcingProjectItemType Item Type
SrcgProjItemClassification SrcgProjItemClassification Item Classification
SourcingProjectItemStableUUID SourcingProjectItemStableUUID Stable ID
AlternativeItemID AlternativeItemID Alternative Item ID
HierarchyNodeLevel HierarchyNodeLevel Hierarchy Node Level
SourcingProject _SourcingProject SourcingProject Sourcing Project
SourcingProjectName _SourcingProject SourcingProjectName Name
SrcgProjLifecycleStatus _SourcingProject SrcgProjLifecycleStatus Status
SourcingProjectType SourcingProjectType Sourcing Project Type
SrcgProjItemDescription SrcgProjItemDescription Description
Material Material Vehicle Model
ProductType ProductType Product Type Group
MaterialGroup MaterialGroup Product Group
RequestedQuantity RequestedQuantity Requested Quantity
RequestedQuantityUnit RequestedQuantityUnit Requested Quantity Unit
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
PerformancePeriodStartDate PerformancePeriodStartDate Start of Performance Period
PerformancePeriodEndDate PerformancePeriodEndDate End of Performance Period
OrderItemQtyToBaseQtyNmrtr OrderItemQtyToBaseQtyNmrtr Equal To
OrderItemQtyToBaseQtyDnmntr OrderItemQtyToBaseQtyDnmntr Denominator
Plant Plant Valuation Area
CompanyCode CompanyCode Receiver Company Code
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
StorageLocation StorageLocation StorageLocation
SrcgProjFollowOnDocumentCat SrcgProjFollowOnDocumentCat Follow-On Document Category
SrcgProjFollowOnDocumentType SrcgProjFollowOnDocumentType Follow-On Document Type
SrcgProjItemDemandConfCode SrcgProjItemDemandConfCode Confirmation Code
SrcgProjItemUnconfdDemandRsn SrcgProjItemUnconfdDemandRsn Rsn for Unconfd Dmnd
SourceSourcingProjectItemUUID SourceSourcingProjectItemUUID Source Item UUID
SrcgProjectItemSettledStatus SrcgProjectItemSettledStatus Item Status
SourcingScenario SourcingScenario Integration Scenario
SourcingOrigin SourcingOrigin Sourcing Origin
_SrcgProjItemClassification _SrcgProjItemClassification
_SourcingProject _SourcingProject
_BackendCoCodeForPurg _BackendCoCodeForPurg
_MaterialText _MaterialText
_MaterialGroupText _MaterialGroupText
_UnitOfMeasureText _UnitOfMeasureText
_PurgDocumentCategoryText _PurgDocumentCategoryText
_BackendPlantForPurg _BackendPlantForPurg
_ProcmtHubPurgOrg _ProcmtHubPurgOrg
_SourcingProjectItemTypeText _SourcingProjectItemTypeText
_SrcgProjItemClassfctnText _SrcgProjItemClassfctnText
_ProductTypeCodeText _ProductTypeCodeText
_RequestedQuantityUnit _RequestedQuantityUnit
_PurchasingDocumentTypeText _PurchasingDocumentTypeText
_SourcingProjectTypeText _SourcingProjectTypeText
_SrcgProjItemDmndConfCodeText _SrcgProjItemDmndConfCodeText
_SourcingProjectReasonText _SourcingProjectReasonText
_SourceSourcingProjectItem _SourceSourcingProjectItem
_SrcgProjItmSettledStatusText _SrcgProjItmSettledStatusText
_SrcgProjSourcingScenarioText _SrcgProjSourcingScenarioText
_SrcgProjSourcingOriginText _SrcgProjSourcingOriginText

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_SrcgProjItmHierDraftTxtBase.
-- 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_SrcgProjItmHierDraftTxtBase AS
SELECT
  SourcingProjectItemUUID,
  SourcingProjectItem,
  SourcingProjectUUID,
  SourcingProjectItemType,
  SrcgProjItemClassification,
  SourcingProjectItemStableUUID,
  AlternativeItemID,
  HierarchyNodeLevel,
  _SourcingProject.SourcingProject AS SourcingProject,
  _SourcingProject.SourcingProjectName AS SourcingProjectName,
  _SourcingProject.SrcgProjLifecycleStatus AS SrcgProjLifecycleStatus,
  SourcingProjectType,
  SrcgProjItemDescription,
  Material,
  ProductType,
  MaterialGroup,
  RequestedQuantity,
  RequestedQuantityUnit,
  RequestedDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  Plant,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  ProcurementHubSourceSystem,
  StorageLocation,
  SrcgProjFollowOnDocumentCat,
  SrcgProjFollowOnDocumentType,
  SrcgProjItemDemandConfCode,
  SrcgProjItemUnconfdDemandRsn,
  SourceSourcingProjectItemUUID,
  SrcgProjectItemSettledStatus,
  SourcingScenario,
  SourcingOrigin
FROM R_SourcingProjectItemDraft
LEFT OUTER JOIN I_UnitOfMeasure AS _RequestedQuantityUnit ON RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_BackendCoCodeForPurg AS _BackendCoCodeForPurg ON ProcurementHubSourceSystem = _BackendCoCodeForPurg.ProcurementHubSourceSystem AND CompanyCode = _BackendCoCodeForPurg.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasureText AS _UnitOfMeasureText ON RequestedQuantityUnit = _UnitOfMeasureText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON SrcgProjFollowOnDocumentCat = _PurgDocumentCategoryText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_BackendPlantForPurg AS _BackendPlantForPurg ON Plant = _BackendPlantForPurg.Plant AND CompanyCode = _BackendPlantForPurg.CompanyCode AND ProcurementHubSourceSystem = _BackendPlantForPurg.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubPurgOrg AS _ProcmtHubPurgOrg ON PurchasingOrganization = _ProcmtHubPurgOrg.ProcmtHubPurchasingOrg AND ProcurementHubSourceSystem = _ProcmtHubPurgOrg.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_SourcingProjectItemTypeText AS _SourcingProjectItemTypeText ON SourcingProjectItemType = _SourcingProjectItemTypeText.SourcingProjectItemType  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjItemClassfctnText AS _SrcgProjItemClassfctnText ON SrcgProjItemClassification = _SrcgProjItemClassfctnText.SrcgProjItemClassification AND SourcingProjectItemType = _SrcgProjItemClassfctnText.SourcingProjectItemType  -- association [0..*]
LEFT OUTER JOIN I_ProductTypeCodeText AS _ProductTypeCodeText ON ProductType = _ProductTypeCodeText.ProductTypeCode  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON SrcgProjFollowOnDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType AND SrcgProjFollowOnDocumentCat = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjItemClassification AS _SrcgProjItemClassification ON SourcingProjectItemType = _SrcgProjItemClassification.SourcingProjectItemType AND SrcgProjItemClassification = _SrcgProjItemClassification.SrcgProjItemClassification  -- association [0..1]
LEFT OUTER JOIN I_SourcingProjectTypeText AS _SourcingProjectTypeText ON SourcingProjectType = _SourcingProjectTypeText.SourcingProjectType  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjItemDmndConfCodeText AS _SrcgProjItemDmndConfCodeText ON SrcgProjItemDemandConfCode = _SrcgProjItemDmndConfCodeText.SrcgProjItemDemandConfCode  -- association [0..*]
LEFT OUTER JOIN I_ProductSourcingReasonText AS _SourcingProjectReasonText ON SrcgProjItemUnconfdDemandRsn = _SourcingProjectReasonText.ProductSourcingReason  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjItmSettledStatusText AS _SrcgProjItmSettledStatusText ON SrcgProjectItemSettledStatus = _SrcgProjItmSettledStatusText.SrcgProjectItemSettledStatus  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingScenarioText AS _SrcgProjSourcingScenarioText ON SourcingScenario = _SrcgProjSourcingScenarioText.SourcingScenario  -- association [0..*]
LEFT OUTER JOIN I_SrcgProjSourcingOriginText AS _SrcgProjSourcingOriginText ON SourcingOrigin = _SrcgProjSourcingOriginText.SourcingOrigin  -- association [0..*]
LEFT OUTER JOIN R_SourcingProjectItemDraft AS _SourceSourcingProjectItem ON SourceSourcingProjectItemUUID = _SourceSourcingProjectItem.SourcingProjectItemUUID  -- association [0..1]
;

Learn More