P_AU_STRPTPARSERVICETYPE

CDS View

P_AU_STRPTPARSERVICETYPE is a CDS View in S/4HANA. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AU_StRpTPARInvoiceLineItems view inner COMPOSITE Australia TPAR Invoice Line Items

Fields (2)

KeyField CDS FieldsUsed in Views
AU_TPARGrantName AU_TPARGrantName 1
AU_TPARServiceType AU_TPARServiceType 1 
@AbapCatalog.sqlViewName: 'PAUSRTPARSTYP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_AU_StrpTPARServiceType
  as select from           I_AU_StRpTPARServiceType      as StRpTPARServiceType
    left outer to one join I_AU_StRpTPARGrantsConfignObj as StRpTPARGrantsConfignObj on StRpTPARServiceType.CompanyCode = StRpTPARGrantsConfignObj.CompanyCode
    left outer to one join I_WBSElementBasicData         as WBSElementBasicData      on  StRpTPARServiceType.AU_TPARGrantObject                = WBSElementBasicData.WBSElementExternalID
                                                                                     and StRpTPARServiceType.AU_TPARServiceType                = 'G'
                                                                                     and StRpTPARGrantsConfignObj.AU_TPARGrantHasConfignObject = 'W'

{
  key  StRpTPARServiceType.CompanyCode,
  key  FromGLAccount,
  key  ToGLAccount,
  key  cast ( WBSElementBasicData.WBSElementInternalID as fiau_tpar_grant_object ) as WBSElementInternalIDCharFormat,
       AU_TPARGrantObject,
       AU_TPARServiceType,
       AU_TPARGrantHasConfignObject,
       AU_TPARGrantName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_AU_STRPTPARGRANTSCONFIGNOBJ",
"I_AU_STRPTPARSERVICETYPE",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More