I_PL_SAFTGENLDGRACCTBALCUBE

CDS View

SAFT PL KR General Ledger - Cube

I_PL_SAFTGENLDGRACCTBALCUBE is a CDS View in S/4HANA. SAFT PL KR General Ledger - Cube. It contains 25 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 25 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PL_SAFTGenLdgrAcctCube view_entity from COMPOSITE SAFT PL Accounting Balance - Cube
I_PL_SAFTGenLdgrAcctTagCube view_entity from COMPOSITE SAFT PL KR PD GLAccounts Tag - Cube

Fields (25)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY Ledger Ledger 2
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY SourceLedger SourceLedger 2
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
CompanyCodeCurrency CompanyCodeCurrency 2
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 2
CreditEndingBalAmtInCCCrcy CreditEndingBalAmtInCCCrcy 2
CreditStartingBalAmtInCCCrcy CreditStartingBalAmtInCCCrcy 2
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 2
DebitEndingBalAmtInCCCrcy DebitEndingBalAmtInCCCrcy 2
DebitStartingBalAmtInCCCrcy DebitStartingBalAmtInCCCrcy 2
DocumentDate DocumentDate 2
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 2
GLAccount GLAccount 1
GLAccountType GLAccountType 2
PostingDate PostingDate 2
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy 2
YTDCrdtAmtInCoCodeCrcy YTDCrdtAmtInCoCodeCrcy 2
YTDDebitAmtInCoCodeCrcy YTDDebitAmtInCoCodeCrcy 2 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@Analytics.dataCategory: #CUBE
@EndUserText.label: 'SAFT PL KR General Ledger - Cube'
@AccessControl.personalData.blocking:#NOT_REQUIRED
@Metadata.allowExtensions:true
@Analytics.internalName:#LOCAL
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #XL,
  dataClass: #MIXED
}
define view entity I_PL_SAFTGenLdgrAcctBalCube   with parameters
    P_FromPostingDate  : fis_budat_from,
    P_ToPostingDate    : fis_budat_to,

    @Consumption.hidden: true
    @Consumption.defaultValue: '000'
    P_FromFiscalPeriod : fis_period_from,

    @Consumption.hidden: true
    @Consumption.defaultValue: '000'
    P_ToFiscalPeriod   : fis_period_to,
    
    P_PL_IndicatorIsTrueOrFalse       : fipl_consider_vendor_customer
  as select from I_StRpTrialBalanceItemCube
                 ( P_FromPostingDate: $parameters.P_FromPostingDate,
                 P_ToPostingDate: $parameters.P_ToPostingDate,
                 P_FromFiscalPeriod: $parameters.P_FromFiscalPeriod,
                 P_ToFiscalPeriod: $parameters.P_ToFiscalPeriod )
                 

   
{
  key  I_StRpTrialBalanceItemCube.Ledger,
  key  I_StRpTrialBalanceItemCube.CompanyCode,
  key  I_StRpTrialBalanceItemCube.FiscalYear,
  key  I_StRpTrialBalanceItemCube.SourceLedger,
  key  I_StRpTrialBalanceItemCube.AccountingDocument,
  key  I_StRpTrialBalanceItemCube.LedgerGLLineItem,

  key  I_StRpTrialBalanceItemCube.StatryRptCategory,
  key  I_StRpTrialBalanceItemCube.StatryRptgEntity,
  key  I_StRpTrialBalanceItemCube.StatryRptRunID,

       I_StRpTrialBalanceItemCube.PostingDate,
       I_StRpTrialBalanceItemCube.DocumentDate,
       
       I_StRpTrialBalanceItemCube.GLAccount,
       I_StRpTrialBalanceItemCube.GLAccountLongName,
       I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts.GLAccountType,
       I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts.GLAccountGroup,
       case
         when I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName is initial or
              I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName is null
         then 'Nie dotyczy'
         else I_StRpTrialBalanceItemCube._GLAccountInChartOfAccounts._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName
       end as AccountGroupName,

       I_StRpTrialBalanceItemCube.CompanyCodeCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.StartingBalanceAmtInCoCodeCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.DebitStartingBalAmtInCCCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.CreditStartingBalAmtInCCCrcy,

       //current balance

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.AmountInCompanyCodeCurrency,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.DebitAmountInCoCodeCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.CreditAmountInCoCodeCrcy,

       //Ending Balance

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.EndingBalanceAmtInCoCodeCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.DebitEndingBalAmtInCCCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.CreditEndingBalAmtInCCCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.YTDDebitAmtInCoCodeCrcy,

       @DefaultAggregation: #SUM
       @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
       I_StRpTrialBalanceItemCube.YTDCrdtAmtInCoCodeCrcy,
       
       I_StRpTrialBalanceItemCube.ReconciliationAccountType,
       
       I_StRpTrialBalanceItemCube.AlternativeGLAccount,
       
       $parameters.P_PL_IndicatorIsTrueOrFalse as PL_IndicatorIsCustomerSupplier,
       
       I_StRpTrialBalanceItemCube.Customer,
        
       I_StRpTrialBalanceItemCube.Supplier,
       
       I_StRpTrialBalanceItemCube._Customer.CustomerName,
      
       I_StRpTrialBalanceItemCube._Supplier.SupplierName,
       
       I_StRpTrialBalanceItemCube.ChartOfAccounts,
       
       I_StRpTrialBalanceItemCube.FinancialAccountType,
       
       //Associations

       I_StRpTrialBalanceItemCube._CompanyCode,
       I_StRpTrialBalanceItemCube._Customer,
       I_StRpTrialBalanceItemCube._Supplier

}

Learn More