R_PPS_PurchaseReqnItemTextTP

DDL: R_PPS_PURCHASEREQNITEMTEXTTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources 1 Associations

Purchase Req Item Text Basic View

R_PPS_PurchaseReqnItemTextTP is a Transactional CDS View that provides data about "Purchase Req Item Text Basic View" in SAP S/4HANA. It reads from 1 data source (I_PurchaseReqnItemText) and exposes 15 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, PurchaseRequisition. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseReqnItemText Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PPS_PurchaseReqnTP _PurchaseReqn _PurchaseReqn.PurchaseRequisition = $projection.PurchaseRequisition

Annotations (8)

NameValueLevelField
EndUserText.label Purchase Req Item Text Basic View view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
ObjectModel.dataCategory #TEXT view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Language I_PurchaseReqnItemText Language Report Text Language
KEY DocumentText I_PurchaseReqnItemText DocumentText Text ID
KEY TechnicalObjectType I_PurchaseReqnItemText TechnicalObjectType Text object
KEY ArchObjectNumber I_PurchaseReqnItemText ArchitecturalObjectNumber
KEY PurchaseRequisition I_PurchaseReqnItemText PurchaseRequisition Requisition
KEY PurchaseRequisitionItem I_PurchaseReqnItemText PurchaseRequisitionItem Requisn. item
ArchObjectNumberForEdit I_PurchaseReqnItemText ArchitecturalObjectNumber
TechnicalObjectTypeForEdit I_PurchaseReqnItemText TechnicalObjectType Text object
DocumentTextForEdit I_PurchaseReqnItemText DocumentText Text ID
NoteDescription I_PurchaseReqnItemText NoteDescription Long Text
FixedIndicator I_PurchaseReqnItemText FixedIndicator Fixing
DisplayModeOfTextTypeInPurg I_PurchaseReqnItemText DisplayModeOfTextTypeInPurg Text Display Mode
TextIsAdoptedFromReference I_PurchaseReqnItemText TextIsAdoptedFromReference Is Adopted
_PurchaseReqnItem _PurchaseReqnItem
_PurchaseReqn _PurchaseReqn

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 R_PPS_PurchaseReqnItemTextTP.
-- 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 R_PPS_PurchaseReqnItemTextTP AS
SELECT
  Document.Language AS Language,
  Document.DocumentText AS DocumentText,
  Document.TechnicalObjectType AS TechnicalObjectType,
  Document.ArchitecturalObjectNumber AS ArchObjectNumber,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Document.ArchitecturalObjectNumber AS ArchObjectNumberForEdit,
  Document.TechnicalObjectType AS TechnicalObjectTypeForEdit,
  Document.DocumentText AS DocumentTextForEdit,
  Document.NoteDescription AS NoteDescription,
  Document.FixedIndicator AS FixedIndicator,
  Document.DisplayModeOfTextTypeInPurg AS DisplayModeOfTextTypeInPurg,
  Document.TextIsAdoptedFromReference AS TextIsAdoptedFromReference
FROM I_PurchaseReqnItemText AS Document
LEFT OUTER JOIN R_PPS_PurchaseReqnTP AS _PurchaseReqn ON _PurchaseReqn.PurchaseRequisition = PurchaseRequisition  -- association [1..1]
;

Learn More