R_PPS_PurchaseReqnHeaderNoteTP

DDL: R_PPS_PURCHASEREQNHEADERNOTETP Type: view_entity TRANSACTIONAL
10 Fields 1 Data Sources

Purchase Requisition Header Notes - TP

R_PPS_PurchaseReqnHeaderNoteTP is a Transactional CDS View that provides data about "Purchase Requisition Header Notes - TP" in SAP S/4HANA. It reads from 1 data source (I_PurchaseReqnHeaderNotes) and exposes 10 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, PurchaseRequisition.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseReqnHeaderNotes Document from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchase Requisition Header Notes - TP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Language I_PurchaseReqnHeaderNotes Language Report Text Language
KEY DocumentText I_PurchaseReqnHeaderNotes DocumentText Text ID
KEY TechnicalObjectType I_PurchaseReqnHeaderNotes TechnicalObjectType Text object
KEY ArchObjectNumber I_PurchaseReqnHeaderNotes ArchitecturalObjectNumber
KEY PurchaseRequisition I_PurchaseReqnHeaderNotes PurchaseRequisition Requisition
NoteDescription I_PurchaseReqnHeaderNotes NoteDescription Long Text
FixedIndicator I_PurchaseReqnHeaderNotes FixedIndicator Fixing
DisplayModeOfTextTypeInPurg I_PurchaseReqnHeaderNotes DisplayModeOfTextTypeInPurg Text Display Mode
TextIsAdoptedFromReference I_PurchaseReqnHeaderNotes TextIsAdoptedFromReference Is Adopted
_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_PurchaseReqnHeaderNoteTP.
-- 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_PurchaseReqnHeaderNoteTP AS
SELECT
  Document.Language AS Language,
  Document.DocumentText AS DocumentText,
  Document.TechnicalObjectType AS TechnicalObjectType,
  Document.ArchitecturalObjectNumber AS ArchObjectNumber,
  Document.PurchaseRequisition AS PurchaseRequisition,
  Document.NoteDescription AS NoteDescription,
  Document.FixedIndicator AS FixedIndicator,
  Document.DisplayModeOfTextTypeInPurg AS DisplayModeOfTextTypeInPurg,
  Document.TextIsAdoptedFromReference AS TextIsAdoptedFromReference
FROM I_PurchaseReqnHeaderNotes AS Document
;

Learn More