P_ClearedAccount1

DDL: P_CLEAREDACCOUNT1 SQL: PCLRDACCNT1 Type: view CONSUMPTION Package: FINS_FIS_APAR_APPS

P_ClearedAccount1

P_ClearedAccount1 is a Consumption CDS View that provides data about "P_ClearedAccount1" in SAP S/4HANA. It reads from 2 data sources (agko, P_ClearedItem1) and exposes 8 fields. Part of development package FINS_FIS_APAR_APPS.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
agko agko union_all
P_ClearedItem1 P_ClearedItem1 from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCLRDACCNT1 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_ALLOWED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
ClearingJournalEntry ClearingJournalEntry
ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear
FinancialAccountType FinancialAccountType
ClearingJournalEntry
ClearingJournalEntryFiscalYear
FinancialAccountType
Account 
@AbapCatalog.sqlViewName: 'PCLRDACCNT1'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_ClearedAccount1 
  as select from P_ClearedItem1 
{
  CompanyCode,
  ClearingJournalEntry,
  ClearingJournalEntryFiscalYear,
  FinancialAccountType,
  Account
}
group by 
   CompanyCode,
   ClearingJournalEntry,
   ClearingJournalEntryFiscalYear,
   FinancialAccountType,
   Account

union all
  select from agko 
{
  cast( bukrs as fis_bukrs )                          as CompanyCode,
  cast( belnr as fis_augbl preserving type )          as ClearingJournalEntry, 
  cast( gjahr as fis_auggj_no_conv preserving type )  as ClearingJournalEntryFiscalYear,
  cast( koart as farp_koart )                         as FinancialAccountType,
  cast( agkto as konko )                              as Account
}

Learn More