P_ACMTrdgContrItemTxtConfigDet

DDL: P_ACMTRDGCONTRITEMTXTCONFIGDET SQL: PACMCONTRITMTXT Type: view BASIC

Private view: Contract Item Text Details

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

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
P_ACMTrdgContrTextConfigDet TextConfig inner
I_TextObject TextObject from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PACMCONTRITMTXT 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: Contract Item Text Details view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber
KEY TradingContractItem
KEY TextObjectType P_ACMTrdgContrTextConfigDet TextObjectType
KEY TradingContractType P_ACMTrdgContrTextConfigDet TradingContractType
TextObjectKey TextObjectKey
TextObjectCategory P_ACMTrdgContrTextConfigDet TextObjectCategory
ExternalRelevance P_ACMTrdgContrTextConfigDet ExternalRelevance 
@AbapCatalog.sqlViewName: 'PACMCONTRITMTXT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Private view: Contract Item Text Details'
define view P_ACMTrdgContrItemTxtConfigDet
  as select from I_TextObject                as TextObject
    inner join   P_ACMTrdgContrTextConfigDet as TextConfig on  TextObject.TextObjectCategory = TextConfig.TextObjectCategory
                                                           and TextObject.TextObjectType     = TextConfig.TextObjectType
{
  key    cast(LEFT(TextObjectKey, 10) as tkonn) as TradingContractNumber,
  key    cast(RIGHT(TextObjectKey, 6) as tposn) as TradingContractItem,
  key    TextConfig.TextObjectType,
  key    TextConfig.TradingContractType         as TradingContractType,
         TextObjectKey,
         TextConfig.TextObjectCategory,
         TextConfig.ExternalRelevance
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTOBJECT",
"P_ACMTRDGCONTRTEXTCONFIGDET"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More