P_SourcingProjectItemDEX

DDL: P_SOURCINGPROJECTITEMDEX Type: view_entity BASIC
23 Fields 1 Data Sources 1 Associations

Private Data Extraction For Sourcing Project Item

P_SourcingProjectItemDEX is a Basic CDS View that provides data about "Private Data Extraction For Sourcing Project Item" in SAP S/4HANA. It reads from 1 data source (mmsrcgpitem) and exposes 23 fields with key field SourcingProjectItemUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
mmsrcgpitem SourcingProjectItemDEX from

Associations (1)

CardinalityTargetAliasCondition
[1] R_SourcingProject _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID

Annotations (5)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.private true view
EndUserText.label Private Data Extraction For Sourcing Project Item view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectItemUUID mmsrcgpitem sourcingprojectitemuuid Item UUID
SourcingProjectUUID mmsrcgpitem sourcingprojectuuid Sourcing Project UUID
SourcingProjectItem mmsrcgpitem sourcingprojectitem Item
SourcingProjectItemType mmsrcgpitem sourcingprojectitemtype Item Type
SrcgProjItemClassification mmsrcgpitem srcgprojitemclassification Item Classification
RequestedQuantity mmsrcgpitem requestedquantity Requested Quantity
SrcgProjItmTgtAmtQuantity mmsrcgpitem srcgprojitmtgtamtquantity Price Unit for Target Price
SrcgProjItemTargetAmount srcgprojitemtargetamount Target Price
RequestedQuantityUnit mmsrcgpitem requestedquantityunit Requested Quantity Unit
Material mmsrcgpitem material Vehicle Model
SrcgProjItemDescription mmsrcgpitem srcgprojitemdescription Description
DocumentCurrency
SrcgProjItemTotalTargetAmount mmsrcgpitem srcgprojitemtotaltargetamount Total Target Amount
MaterialGroup mmsrcgpitem materialgroup Product Group
RequestedDeliveryDate mmsrcgpitem requesteddeliverydate Requested Delivery Date
MaximumRequestedQuantity mmsrcgpitem maximumrequestedquantity Max. Requested Quantity
ItemWeightUnit mmsrcgpitem itemweightunit Unit of Weight
ItemVolumeUnit mmsrcgpitem itemvolumeunit Volume Unit
ProcurementHubSourceSystem mmsrcgpitem procurementhubsourcesystem Connected System ID
SrcgProjFollowOnDocumentCat mmsrcgpitem srcgprojfollowondocumentcat Follow-On Document Category
SrcgProjFollowOnDocumentType mmsrcgpitem srcgprojfollowondocumenttype Follow-On Document Type
SrcgProjItemDemandConfCode mmsrcgpitem srcgprojitemdemandconfcode Confirmation Code
_SourcingProject _SourcingProject

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_SourcingProjectItemDEX.
-- 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_SourcingProjectItemDEX AS
SELECT
  SourcingProjectItemDEX.sourcingprojectitemuuid AS SourcingProjectItemUUID,
  SourcingProjectItemDEX.sourcingprojectuuid AS SourcingProjectUUID,
  SourcingProjectItemDEX.sourcingprojectitem AS SourcingProjectItem,
  SourcingProjectItemDEX.sourcingprojectitemtype AS SourcingProjectItemType,
  SourcingProjectItemDEX.srcgprojitemclassification AS SrcgProjItemClassification,
  SourcingProjectItemDEX.requestedquantity AS RequestedQuantity,
  SourcingProjectItemDEX.srcgprojitmtgtamtquantity AS SrcgProjItmTgtAmtQuantity,
  SrcgProjItemTargetAmount,
  SourcingProjectItemDEX.requestedquantityunit AS RequestedQuantityUnit,
  SourcingProjectItemDEX.material AS Material,
  SourcingProjectItemDEX.srcgprojitemdescription AS SrcgProjItemDescription,
  cast ( '' as vdm_documentcurrency ) AS DocumentCurrency,
  SourcingProjectItemDEX.srcgprojitemtotaltargetamount AS SrcgProjItemTotalTargetAmount,
  SourcingProjectItemDEX.materialgroup AS MaterialGroup,
  SourcingProjectItemDEX.requesteddeliverydate AS RequestedDeliveryDate,
  SourcingProjectItemDEX.maximumrequestedquantity AS MaximumRequestedQuantity,
  SourcingProjectItemDEX.itemweightunit AS ItemWeightUnit,
  SourcingProjectItemDEX.itemvolumeunit AS ItemVolumeUnit,
  SourcingProjectItemDEX.procurementhubsourcesystem AS ProcurementHubSourceSystem,
  SourcingProjectItemDEX.srcgprojfollowondocumentcat AS SrcgProjFollowOnDocumentCat,
  SourcingProjectItemDEX.srcgprojfollowondocumenttype AS SrcgProjFollowOnDocumentType,
  SourcingProjectItemDEX.srcgprojitemdemandconfcode AS SrcgProjItemDemandConfCode
FROM mmsrcgpitem AS SourcingProjectItemDEX
LEFT OUTER JOIN R_SourcingProject AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1]
;

Learn More