P_PurchaseCtrTextFileInter

DDL: P_PURCHASECTRTEXTFILEINTER SQL: PPCTRTXTFILEINTR Type: view BASIC

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.

2 data source(s) 5 fields

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
KEY ArchitecturalObjectNumber I_TextObject TextObjectKey
KEY DocumentText I_TextObject TextObjectType
Language I_TextObjectTypeText Language
Note I_TextObjectTypeText TextObjectTypeName 
@VDM.private : true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PPCTRTXTFILEINTR'
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_PurchaseCtrTextFileInter as select from I_TextObject as txthdr
 
left outer join I_TextObjectTypeText as text on (txthdr.TextObjectType = text.TextObjectType and txthdr.TextObjectCategory = text.TextObjectCategory)
{

           key txthdr.TextObjectCategory as TechnicalObjectType,
                
           key txthdr.TextObjectKey as ArchitecturalObjectNumber,
                
           key txthdr.TextObjectType as DocumentText,
           
           text.Language,
           
           text.TextObjectTypeName as Note
            
} 
            
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTOBJECT",
"I_TEXTOBJECTTYPETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More