I_OrderOperationPRTLongText

DDL: I_ORDEROPERATIONPRTLONGTEXT Type: view_entity BASIC
12 Fields 1 Data Sources 1 Associations

Order Operation PRT Long Text

I_OrderOperationPRTLongText is a Basic CDS View that provides data about "Order Operation PRT Long Text" in SAP S/4HANA. It reads from 1 data source (P_OrderOperationPRTLongText) and exposes 12 fields with key fields OrderInternalID, OrderProdnRsceToolInternalID, LongTextLanguage. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_OrderOperationPRTLongText prt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_TextObjectPlainLongText _TextObjectPlainLongText _TextObjectPlainLongText.TextObjectKey = prt.TextObjectKey and _TextObjectPlainLongText.TextObjectCategory = 'AUFK' and _TextObjectPlainLongText.TextObjectType = 'FHMT'

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey OrderProdnRsceToolInternalID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
EndUserText.label Order Operation PRT Long Text view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID P_OrderOperationPRTLongText OrderInternalID Plan No.f.Oper.
KEY OrderProdnRsceToolInternalID P_OrderOperationPRTLongText OrderProdnRsceToolInternalID
KEY LongTextLanguage
TextObjectKey P_OrderOperationPRTLongText TextObjectKey Text Name
OrderProdnRsceToolText P_OrderOperationPRTLongText OrderProdnRsceToolText
OrderProdnRsceToolLongText _TextObjectPlainLongText PlainLongText Long Text
OrderID P_OrderOperationPRTLongText OrderID Order ID
OrderCategory P_OrderOperationPRTLongText OrderCategory Order Category
_Order P_OrderOperationPRTLongText _Order
_OrderCategory P_OrderOperationPRTLongText _OrderCategory
_OrderInternalID P_OrderOperationPRTLongText _OrderInternalID
_TextObjectPlainLongText _TextObjectPlainLongText

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_OrderOperationPRTLongText.
-- 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 I_OrderOperationPRTLongText AS
SELECT
  prt.OrderInternalID AS OrderInternalID,
  prt.OrderProdnRsceToolInternalID AS OrderProdnRsceToolInternalID,
  cast(prt.LongTextLanguage as pph_longtextlang preserving type) AS LongTextLanguage,
  prt.TextObjectKey AS TextObjectKey,
  prt.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  _TextObjectPlainLongText.PlainLongText AS OrderProdnRsceToolLongText,
  prt.OrderID AS OrderID,
  prt.OrderCategory AS OrderCategory,
  prt._Order AS _Order,
  prt._OrderCategory AS _OrderCategory,
  prt._OrderInternalID AS _OrderInternalID
FROM P_OrderOperationPRTLongText AS prt
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON _TextObjectPlainLongText.TextObjectKey = prt.TextObjectKey AND _TextObjectPlainLongText.TextObjectCategory = 'AUFK' AND _TextObjectPlainLongText.TextObjectType = 'FHMT'  -- association [0..1]
;

Learn More