P_PurchaseCtrTextFileInter

DDL: P_PURCHASECTRTEXTFILEINTER SQL: PPCTRTXTFILEINTR Type: view BASIC
5 Fields 2 Data Sources

P_PurchaseCtrTextFileInter is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_TextObjectTypeText, I_TextObject) and exposes 5 fields with key fields TechnicalObjectType, ArchitecturalObjectNumber, DocumentText.

Data Sources (2)

SourceAliasJoin Type
I_TextObjectTypeText text left_outer
I_TextObject txthdr from

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PPCTRTXTFILEINTR view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TechnicalObjectType I_TextObject TextObjectCategory Text object
KEY ArchitecturalObjectNumber I_TextObject TextObjectKey Text Name
KEY DocumentText I_TextObject TextObjectType Text ID
Language I_TextObjectTypeText Language Report Text Language
Note I_TextObjectTypeText TextObjectTypeName Description

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 P_PurchaseCtrTextFileInter.
-- 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: PPCTRTXTFILEINTR

CREATE VIEW P_PurchaseCtrTextFileInter AS
SELECT
  txthdr.TextObjectCategory AS TechnicalObjectType,
  txthdr.TextObjectKey AS ArchitecturalObjectNumber,
  txthdr.TextObjectType AS DocumentText,
  text.Language AS Language,
  text.TextObjectTypeName AS Note
FROM I_TextObject AS txthdr
LEFT OUTER JOIN I_TextObjectTypeText AS text ON /* join condition not captured in parsed metadata */
;

Learn More