I_WrkItmPurRequisitionText

DDL: I_WRKITMPURREQUISITIONTEXT SQL: IWIPURREQNITMTXT Type: view COMPOSITE
14 Fields 1 Data Sources 1 Associations

Interface view Purchase requisition work item notes

I_WrkItmPurRequisitionText is a Composite CDS View that provides data about "Interface view Purchase requisition work item notes" in SAP S/4HANA. It reads from 1 data source (I_PurchaseReqnItemWorkItem) and exposes 14 fields with key fields PurchaseRequisition, PurchaseRequisitionItem, Language, DocumentText, TechnicalObjectType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseReqnItemWorkItem _PurchaseReqnItemWorkItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PurchaseReqnItemText _PurReqnTxt _PurReqnTxt.PurchaseRequisition = $projection.PurchaseRequisition and _PurReqnTxt.PurchaseRequisitionItem = $projection.PurchaseRequisitionItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IWIPURREQNITMTXT view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey PurchaseRequisition view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Interface view Purchase requisition work item notes view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchaseRequisition I_PurchaseReqnItemWorkItem PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_PurchaseReqnItemWorkItem PurchaseRequisitionItem Requisn. item
KEY Language _PurReqnTxt Language Report Text Language
KEY DocumentText _PurReqnTxt DocumentText Text ID
KEY TechnicalObjectType _PurReqnTxt TechnicalObjectType Text object
KEY ArchObjectNumber _PurReqnTxt ArchitecturalObjectNumber
KEY WorkflowTaskInternalID I_PurchaseReqnItemWorkItem WorkflowTaskInternalID Work Item ID
ArchObjectNumberForEdit _PurReqnTxt ArchitecturalObjectNumber
TechnicalObjectTypeForEdit _PurReqnTxt TechnicalObjectType Text object
LanguageForEdit _PurReqnTxt Language Report Text Language
NoteDescription _PurReqnTxt NoteDescription Long Text
FixedIndicator _PurReqnTxt FixedIndicator Fixing
DisplayModeOfTextTypeInPurg _PurReqnTxt DisplayModeOfTextTypeInPurg Text Display Mode
TextIsAdoptedFromReference _PurReqnTxt TextIsAdoptedFromReference Is Adopted

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_WrkItmPurRequisitionText.
-- 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: IWIPURREQNITMTXT

CREATE VIEW I_WrkItmPurRequisitionText AS
SELECT
  _PurchaseReqnItemWorkItem.PurchaseRequisition AS PurchaseRequisition,
  _PurchaseReqnItemWorkItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurReqnTxt.Language AS Language,
  _PurReqnTxt.DocumentText AS DocumentText,
  _PurReqnTxt.TechnicalObjectType AS TechnicalObjectType,
  _PurReqnTxt.ArchitecturalObjectNumber AS ArchObjectNumber,
  _PurchaseReqnItemWorkItem.WorkflowTaskInternalID AS WorkflowTaskInternalID,
  _PurReqnTxt.ArchitecturalObjectNumber AS ArchObjectNumberForEdit,
  _PurReqnTxt.TechnicalObjectType AS TechnicalObjectTypeForEdit,
  _PurReqnTxt.Language AS LanguageForEdit,
  _PurReqnTxt.NoteDescription AS NoteDescription,
  _PurReqnTxt.FixedIndicator AS FixedIndicator,
  _PurReqnTxt.DisplayModeOfTextTypeInPurg AS DisplayModeOfTextTypeInPurg,
  _PurReqnTxt.TextIsAdoptedFromReference AS TextIsAdoptedFromReference
FROM I_PurchaseReqnItemWorkItem AS _PurchaseReqnItemWorkItem
LEFT OUTER JOIN I_PurchaseReqnItemText AS _PurReqnTxt ON _PurReqnTxt.PurchaseRequisition = PurchaseRequisition AND _PurReqnTxt.PurchaseRequisitionItem = PurchaseRequisitionItem  -- association [0..*]
;

Learn More