C_PurchaseOrderNoteType

DDL: C_PURCHASEORDERNOTETYPE SQL: CPOHDRNOTETYP Type: view CONSUMPTION

Note Types for Purchase Order

C_PurchaseOrderNoteType is a Consumption CDS View that provides data about "Note Types for Purchase Order" in SAP S/4HANA. It reads from 1 data source (I_Text_Type) and exposes 4 fields with key fields TechnicalObjectType, Language, DocumentText. It is exposed through 1 OData service (UI_PPS_PURCHASE_ORDER).

Data Sources (1)

SourceAliasJoin Type
I_Text_Type I_Text_Type from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CPOHDRNOTETYP view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Note Types for Purchase Order view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PPS_PURCHASE_ORDER UI_PPS_PURCHASE_ORDER_V2 V2 C1 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObjectType TechnicalObjectType Text object
KEY Language Language Report Text Language
KEY DocumentText DocumentText Text ID
Note Note TradeRequest Comment

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 C_PurchaseOrderNoteType.
-- 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: CPOHDRNOTETYP

CREATE VIEW C_PurchaseOrderNoteType AS
SELECT
  TechnicalObjectType,
  Language,
  DocumentText,
  Note
FROM I_Text_Type
;