P_FR_FECBusinessPartnerBalCA

DDL: P_FR_FECBUSINESSPARTNERBALCA SQL: PBPBALANCECARR Type: view CONSUMPTION

Business Partner Balance FR FEC

P_FR_FECBusinessPartnerBalCA is a Consumption CDS View that provides data about "Business Partner Balance FR FEC" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentBPItemPhysical, P_FR_FECPrevFsclYearDet) and exposes 14 fields with key fields CompanyCode, ChartOfAccounts, CountryChartOfAccounts, BusinessPartner, TransactionCurrency. It has 3 associations to related views.

2 data source(s) 14 fields

Data Sources (2)

SourceAliasJoin Type
I_CADocumentBPItemPhysical _BPItem from
P_FR_FECPrevFsclYearDet _CompFisc inner

Parameters (1)

NameTypeDefault
P_FiscalYear fis_gjahr

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CompanyCode _CompCode $projection.CompanyCode = _CompCode.CompanyCode
[0..1] I_RetainedEarningsGLAccount _RetEarnGLAccount $projection.ChartOfAccounts = _RetEarnGLAccount.ChartOfAccounts and _RetEarnGLAccount.ProfitLossAccountType = 'X'
[0..1] I_GLAccountInCompanyCode _AlternateGLAcctinCompany $projection.GLAccount = _AlternateGLAcctinCompany.GLAccount and $projection.CompanyCode = _AlternateGLAcctinCompany.CompanyCode

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PBPBALANCECARR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Business Partner Balance FR FEC view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CADocumentBPItemPhysical CompanyCode
KEY ChartOfAccounts _CompCode ChartOfAccounts
KEY CountryChartOfAccounts _CompCode CountryChartOfAccounts
KEY BusinessPartner I_CADocumentBPItemPhysical BusinessPartner
KEY TransactionCurrency I_CADocumentBPItemPhysical TransactionCurrency
KEY CompanyCodeCurrency I_CADocumentBPItemPhysical CompanyCodeCurrency
KEY GLAccount I_CADocumentBPItemPhysical CAReconciliationAccount
AmountInLocalCurrency
AmountInTransactionCurrency
FiscalYearStartDate P_FR_FECPrevFsclYearDet FiscalYearStartDate
FiscalPeriod P_FR_FECPrevFsclYearDet FiscalPeriod
_CompCode _CompCode
_RetEarnGLAccount _RetEarnGLAccount
_AlternateGLAcctinCompany _AlternateGLAcctinCompany 
@AbapCatalog.sqlViewName: 'PBPBALANCECARR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Business Partner Balance FR FEC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_FR_FECBusinessPartnerBalCA
  with parameters
    P_FiscalYear : fis_gjahr
  as select from I_CADocumentBPItemPhysical as _BPItem
    inner join   P_FR_FECPrevFsclYearDet    as _CompFisc on  _CompFisc.CompanyCode = _BPItem.CompanyCode
                                                         and _CompFisc.FiscalYear  = $parameters.P_FiscalYear
  association [1..1] to I_CompanyCode               as _CompCode         on  $projection.CompanyCode = _CompCode.CompanyCode
  association [0..1] to I_RetainedEarningsGLAccount as _RetEarnGLAccount on  $projection.ChartOfAccounts             = _RetEarnGLAccount.ChartOfAccounts
                                                                         and _RetEarnGLAccount.ProfitLossAccountType = 'X'
  association [0..1] to I_GLAccountInCompanyCode as _AlternateGLAcctinCompany on  $projection.GLAccount   = _AlternateGLAcctinCompany.GLAccount
                                                                              and $projection.CompanyCode = _AlternateGLAcctinCompany.CompanyCode
{

key  _BPItem.CompanyCode                 as CompanyCode,
key  _CompCode.ChartOfAccounts           as ChartOfAccounts,
key  _CompCode.CountryChartOfAccounts           as CountryChartOfAccounts,
key  _BPItem.BusinessPartner                     as BusinessPartner,
key  _BPItem.TransactionCurrency                 as TransactionCurrency,
key  _BPItem.CompanyCodeCurrency                 as CompanyCodeCurrency,
key  _BPItem.CAReconciliationAccount             as GLAccount,
  sum( _BPItem.CAAmountInLocalCurrency)       as AmountInLocalCurrency,
  sum( _BPItem.CAAmountInTransactionCurrency) as AmountInTransactionCurrency,
  _CompFisc.FiscalYearStartDate               as FiscalYearStartDate,
  _CompFisc.FiscalPeriod                      as FiscalPeriod,
  _CompCode,
  _RetEarnGLAccount,
  _AlternateGLAcctinCompany
}
where
      _BPItem.CAStatisticalItemCode =  ''
  and _BPItem.CAClearingStatus      =  ''
  and _BPItem.CAPostingDate         <= _CompFisc.PreviousFiscalYearEndDate
group by
  _BPItem.CompanyCode,
  _CompCode.ChartOfAccounts,
  _CompCode.CountryChartOfAccounts,
  _BPItem.BusinessPartner,
  _BPItem.TransactionCurrency,
  _BPItem.CompanyCodeCurrency,
  _BPItem.CAReconciliationAccount,
  _CompFisc.FiscalYearStartDate,
  _CompFisc.FiscalPeriod
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CADOCUMENTBPITEMPHYSICAL",
"I_COMPANYCODE",
"P_FR_FECPREVFSCLYEARDET"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_GLACCOUNTINCOMPANYCODE",
"I_RETAINEDEARNINGSGLACCOUNT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More