P_TrialBalanceFlow

DDL: P_TRIALBALANCEFLOW Type: view_entity COMPOSITE Package: FKK_ID_PL_REP

Overall Balance

P_TrialBalanceFlow is a Composite CDS View that provides data about "Overall Balance" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentBPItem, I_CADocumentBPItem) and exposes 14 fields with key fields CompanyCode, BusinessPartner, ContractAccount, CAReconciliationAccount, Clearing. Part of development package FKK_ID_PL_REP.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_CADocumentBPItem I_CADocumentBPItem from
I_CADocumentBPItem I_CADocumentBPItem union

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Overall Balance view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY BusinessPartner BusinessPartner
KEY ContractAccount ContractAccount
KEY CAReconciliationAccount CAReconciliationAccount
KEY Clearing
Balance
Debit
Credit
KEY BusinessPartner BusinessPartner
KEY ContractAccount ContractAccount
KEY CAReconciliationAccount CAReconciliationAccount
KEY Clearing
Balance
CompanyCodeCurrency CompanyCodeCurrency 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Overall Balance'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view entity P_TrialBalanceFlow
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : vdm_v_key_date
  as select from I_CADocumentBPItem
{
  key CompanyCode,
  key BusinessPartner,
  key ContractAccount,
  key CAReconciliationAccount,
  key '' as Clearing,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  sum( CAAmountInLocalCurrency ) as Balance,
  @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  sum( case when CAAmountInLocalCurrency > 0 then CAAmountInLocalCurrency else null end ) as Debit,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
  sum( case when CAAmountInLocalCurrency < 0 then CAAmountInLocalCurrency else null end ) as Credit,
  CompanyCodeCurrency
}
where
      CAPostingDate         <= $parameters.P_KeyDate
  and CAStatisticalItemCode is initial
group by
  CompanyCode,
  CompanyCodeCurrency,
  BusinessPartner,
  ContractAccount,
  CAReconciliationAccount
union select from I_CADocumentBPItem
{
  key CompanyCode,
  key BusinessPartner,
  key ContractAccount,
  key CAReconciliationAccount,
  key 'X' as Clearing,
  ( sum( CAAmountInLocalCurrency ) * -1 ) as Balance,
  ( sum( case when _CADocument.CAReversalDocumentNumber <> '' and CAAmountInLocalCurrency > 0 then CAAmountInLocalCurrency   
              when _CADocument.CAReversalDocumentNumber  = '' and CAAmountInLocalCurrency < 0 then CAAmountInLocalCurrency else null end ) * -1 ) as Debit,
  ( sum( case when _CADocument.CAReversalDocumentNumber <> '' and CAAmountInLocalCurrency < 0 then CAAmountInLocalCurrency   
              when _CADocument.CAReversalDocumentNumber  = '' and CAAmountInLocalCurrency > 0 then CAAmountInLocalCurrency else null end ) * -1 ) as Credit,
  CompanyCodeCurrency
}
where
      CAPostingDateOfClearingDoc <= $parameters.P_KeyDate
  and CAStatisticalItemCode      is initial
  and CAClearingStatus           = '9'
group by
  CompanyCode,
  CompanyCodeCurrency,
  BusinessPartner,
  ContractAccount,
  CAReconciliationAccount

Learn More