I_PurchaseOrderNoteTP

DDL: I_PURCHASEORDERNOTETP SQL: IPURORDNOTE Type: view TRANSACTIONAL
12 Fields 1 Data Sources 1 Associations

Notes for Purchase Order

I_PurchaseOrderNoteTP is a Transactional CDS View that provides data about "Notes for Purchase Order" in SAP S/4HANA. It reads from 1 data source (R_PurchaseOrderNote) and exposes 12 fields with key fields Language, DocumentText, TechnicalObjectType, ArchObjectNumber, PurchaseOrder. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PurchaseOrderNote Document from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderTP _PurchaseOrder _PurchaseOrder.PurchaseOrder = $projection.PurchaseOrder

Annotations (16)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IPURORDNOTE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Notes for Purchase Order view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence PURORDNOTE_D view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY Language R_PurchaseOrderNote Language Report Text Language
KEY DocumentText R_PurchaseOrderNote DocumentText Text ID
KEY TechnicalObjectType R_PurchaseOrderNote TechnicalObjectType Text object
KEY ArchObjectNumber R_PurchaseOrderNote ArchitecturalObjectNumber
KEY PurchaseOrder R_PurchaseOrderNote PurchaseOrder Purchasing Document
ArchObjectNumberForEdit R_PurchaseOrderNote ArchitecturalObjectNumber
TechnicalObjectTypeForEdit R_PurchaseOrderNote TechnicalObjectType Text object
DocumentTextForEdit R_PurchaseOrderNote DocumentText Text ID
LanguageForEdit R_PurchaseOrderNote Language Report Text Language
NoteDescription R_PurchaseOrderNote NoteDescription Long Text
FixedIndicator R_PurchaseOrderNote FixedIndicator Fixing
_PurchaseOrder _PurchaseOrder

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_PurchaseOrderNoteTP.
-- 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: IPURORDNOTE

CREATE VIEW I_PurchaseOrderNoteTP AS
SELECT
  Document.Language AS Language,
  Document.DocumentText AS DocumentText,
  Document.TechnicalObjectType AS TechnicalObjectType,
  Document.ArchitecturalObjectNumber AS ArchObjectNumber,
  Document.PurchaseOrder AS PurchaseOrder,
  Document.ArchitecturalObjectNumber AS ArchObjectNumberForEdit,
  Document.TechnicalObjectType AS TechnicalObjectTypeForEdit,
  Document.DocumentText AS DocumentTextForEdit,
  Document.Language AS LanguageForEdit,
  Document.NoteDescription AS NoteDescription,
  Document.FixedIndicator AS FixedIndicator
FROM R_PurchaseOrderNote AS Document
LEFT OUTER JOIN I_PurchaseOrderTP AS _PurchaseOrder ON _PurchaseOrder.PurchaseOrder = PurchaseOrder  -- association [1..1]
;

Learn More