I_AcctgPrincipleCoCodeConfign

DDL: I_ACCTGPRINCIPLECOCODECONFIGN SQL: IFIAPCLS Type: view BASIC

Accounting Principle Confign per Co Code

I_AcctgPrincipleCoCodeConfign is a Basic CDS View that provides data about "Accounting Principle Confign per Co Code" in SAP S/4HANA. It reads from 3 data sources (P_LDCMP, t001, I_AcctgPrncpChtAcctsConfign) and exposes 6 fields with key fields Ledger, CompanyCode.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
P_LDCMP datasource1 from
t001 datasource2 left_outer
I_AcctgPrncpChtAcctsConfign datasource3 left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFIAPCLS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Accounting Principle Confign per Co Code view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Ledger P_LDCMP rldnr
KEY CompanyCode P_LDCMP bukrs
AccountingPrinciple P_LDCMP acc_principle
FunctionalCurrencyRole functional_currency
ChartOfAccounts t001 ktopl
FinancialStatementHierarchy I_AcctgPrncpChtAcctsConfign FinancialStatementHierarchy 
@AbapCatalog.sqlViewName: 'IFIAPCLS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Accounting Principle Confign per Co Code'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  serviceQuality: #B,
  dataClass: #CUSTOMIZING,
  sizeCategory: #S
}
  

define view I_AcctgPrincipleCoCodeConfign   as select from    P_LDCMP as datasource1
    left outer join t001    as datasource2 on datasource1.bukrs = datasource2.bukrs
    left outer join I_AcctgPrncpChtAcctsConfign as datasource3 on  datasource1.acc_principle = datasource3.AccountingPrinciple
                                           and datasource2.ktopl         = datasource3.ChartOfAccounts
{

  key datasource1.rldnr             as   Ledger,
  key datasource1.bukrs             as   CompanyCode,
      datasource1.acc_principle     as   AccountingPrinciple,
      functional_currency           as   FunctionalCurrencyRole,
      datasource2.ktopl             as   ChartOfAccounts,
      datasource3.FinancialStatementHierarchy      
}

Learn More