I_ProfitLossAccountType_Vh

DDL: I_PROFITLOSSACCOUNTTYPE_VH SQL: IPLACCTYP Type: view BASIC

Profit/Loss Account Type

I_ProfitLossAccountType_Vh is a Basic CDS View (Dimension) that provides data about "Profit/Loss Account Type" in SAP S/4HANA. It reads from 1 data source (I_RetainedEarningsGLAccount) and exposes 6 fields with key fields ProfitLossAccountType, ChartOfAccounts. It has 3 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_RetainedEarningsGLAccount I_RetainedEarningsGLAccount from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_ChartOfAccountsText _ChartOfAccountsText $projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[0..*] I_GLAccountText _Text $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.RetainedEarningsGLAccount = _Text.GLAccount

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
EndUserText.label Profit/Loss Account Type view
Analytics.dataCategory #DIMENSION view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IPLACCTYP view
ObjectModel.representativeKey ProfitLossAccountType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProfitLossAccountType ProfitLossAccountType
KEY ChartOfAccounts ChartOfAccounts
RetainedEarningsGLAccount RetainedEarningsGLAccount
_Text _Text
_ChartOfAccounts _ChartOfAccounts
_ChartOfAccountsText _ChartOfAccountsText 
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true

@EndUserText.label: 'Profit/Loss Account Type'
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IPLACCTYP'
@ObjectModel.representativeKey:'ProfitLossAccountType'
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #MASTER
}
@ObjectModel.dataCategory: #VALUE_HELP

//--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

@AccessControl.privilegedAssociations: ['_ChartOfAccountsText']
// ]--GENERATED


define view I_ProfitLossAccountType_Vh
  as select from I_RetainedEarningsGLAccount

  //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

  association [0..*] to I_ChartOfAccountsText as _ChartOfAccountsText on  $projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts
  // ]--GENERATED

  association [0..1] to I_ChartOfAccounts     as _ChartOfAccounts     on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [0..*] to I_GLAccountText       as _Text                on  $projection.ChartOfAccounts           = _Text.ChartOfAccounts
                                                                      and $projection.RetainedEarningsGLAccount = _Text.GLAccount
{
  key ProfitLossAccountType,
      //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ChartOfAccountsStdVH',
                     element: 'ChartOfAccounts' }
        }]
      @ObjectModel.text.association: '_ChartOfAccountsText'
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key ChartOfAccounts,
      @ObjectModel.text.association: '_Text'
      RetainedEarningsGLAccount,
      _Text,

      _ChartOfAccounts,
      //--[ GENERATED:012:29JlHNUf7jY4ipE4XHfNBG

      @Consumption.hidden: true
      _ChartOfAccountsText
      // ]--GENERATED


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RETAINEDEARNINGSGLACCOUNT"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_CHARTOFACCOUNTSTEXT",
"I_GLACCOUNTTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More