P_ACMTrdgContrTextDet

DDL: P_ACMTRDGCONTRTEXTDET SQL: PACMCONTRHDRTXT Type: view BASIC

Private view: Text Details

P_ACMTrdgContrTextDet is a Basic CDS View that provides data about "Private view: Text Details" in SAP S/4HANA. It reads from 2 data sources (P_ACMTrdgContrHeaderTextVH, I_TextObject) and exposes 6 fields with key fields TradingContractNumber, TextObjectType, TradingContractType.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
P_ACMTrdgContrHeaderTextVH TextConfig inner
I_TextObject TextObject from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PACMCONTRHDRTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Private view: Text Details view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber
KEY TextObjectType P_ACMTrdgContrHeaderTextVH tdid
KEY TradingContractType P_ACMTrdgContrHeaderTextVH tctyp
TextObjectKey TextObjectKey
TextObjectCategory P_ACMTrdgContrHeaderTextVH tdobject
ExternalRelevance P_ACMTrdgContrHeaderTextVH ExternalRelevance 
@AbapCatalog.sqlViewName: 'PACMCONTRHDRTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Private view: Text Details'
define view P_ACMTrdgContrTextDet
  as select from I_TextObject               as TextObject
    inner join   P_ACMTrdgContrHeaderTextVH as TextConfig on  TextObject.TextObjectCategory = TextConfig.tdobject
                                                          and TextObject.TextObjectType     = TextConfig.tdid
{
  key    LEFT(TextObjectKey, 10) as TradingContractNumber,
  key    TextConfig.tdid         as TextObjectType,
  key    TextConfig.tctyp        as TradingContractType,
         TextObjectKey,
         TextConfig.tdobject     as TextObjectCategory,
         TextConfig.ExternalRelevance
         
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTOBJECT",
"P_ACMTRDGCONTRHEADERTEXTVH"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More