P_ACMTrdgContrText

DDL: P_ACMTRDGCONTRTEXT SQL: PACMCONTHDRTXT Type: view BASIC

Private view: Text Details

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

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
P_ACMContrHeaderTextValueHelp TextConfig inner
I_TextObject TextObject from

Annotations (7)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY TradingContractNumber
KEY TextObjectType P_ACMContrHeaderTextValueHelp tdid
KEY TradingContractType P_ACMContrHeaderTextValueHelp tctyp
TextObjectKey TextObjectKey
TextObjectCategory P_ACMContrHeaderTextValueHelp tdobject
ExternalRelevance P_ACMContrHeaderTextValueHelp ExternalRelevance 
@AbapCatalog.sqlViewName: 'PACMCONTHDRTXT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Private view: Text Details'
define view P_ACMTrdgContrText
  as select from I_TextObject                  as TextObject
    inner join   P_ACMContrHeaderTextValueHelp 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
}
where
  TextObjectKey = left(TextObjectKey, 10)

Learn More