C_ClearedAccount

DDL: C_CLEAREDACCOUNT SQL: CCLRDACCNT Type: view CONSUMPTION Package: FINS_FIS_APAR_APPS

Accounts of cleared items

C_ClearedAccount is a Consumption CDS View that provides data about "Accounts of cleared items" in SAP S/4HANA. It reads from 1 data source (P_ClearedAccount4) and exposes 13 fields with key fields CompanyCode, Account, FinancialAccountType, ClearingJournalEntry, ClearingJournalEntryFiscalYear. It has 1 association to related views. Part of development package FINS_FIS_APAR_APPS.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
P_ClearedAccount4 P_ClearedAccount4 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_ClearingDocument _Header $projection.CompanyCode = _Header.CompanyCode and $projection.ClearingJournalEntry = _Header.ClearingJournalEntry and $projection.ClearingJournalEntryFiscalYear = _Header.ClearingJournalEntryFiscalYear and $projection.IntercompanyTransaction = _Header.IntercompanyTransaction

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCLRDACCNT view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Accounts of cleared items view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
UI.headerInfo.typeName Account view
UI.headerInfo.typeNamePlural Accounts view
UI.headerInfo.title.type #STANDARD view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY Account Account
KEY FinancialAccountType FinancialAccountType
KEY ClearingJournalEntry ClearingJournalEntry
KEY ClearingJournalEntryFiscalYear ClearingJournalEntryFiscalYear
AccountName AccountName
FinancialAccountTypeName FinancialAccountTypeName
PostalCode PostalCode
CityName CityName
IntercompanyTransaction IntercompanyTransaction
ClearingAccountingDocument
ClearingDocFiscalYear
_Header _Header 
@AbapCatalog.sqlViewName: 'CCLRDACCNT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Accounts of cleared items'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
// ILM: BSEG et.al. belong to archiving object FI_DOCUMNT (deletion available according to SEC-12)

@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED

@UI.headerInfo: {
   typeName: 'Account',
   typeNamePlural: 'Accounts',
   title: { type: #STANDARD }
}

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

define view C_ClearedAccount
  as select from P_ClearedAccount4

  association [1..1] to C_ClearingDocument as _Header on  $projection.CompanyCode                     = _Header.CompanyCode
                                                      and $projection.ClearingJournalEntry            = _Header.ClearingJournalEntry 
                                                      and $projection.ClearingJournalEntryFiscalYear  = _Header.ClearingJournalEntryFiscalYear
                                                      and $projection.IntercompanyTransaction         = _Header.IntercompanyTransaction // See comment for field IntercompanyTransaction in view C_ClearingDocument

                                                      
{
      @UI.lineItem: [ { position:10, importance: #HIGH } ]
  key CompanyCode,
  
      @UI.lineItem: [ { position:40, importance: #HIGH } ]
  key Account,

      @UI.lineItem: [ { position:90, exclude: true, importance: #MEDIUM } ]
  key FinancialAccountType,
  
      @UI.hidden: true
  key ClearingJournalEntry,

      @UI.hidden: true
  key ClearingJournalEntryFiscalYear,
  
      @UI.lineItem: [ { position:50, label: 'Account Name', importance: #HIGH } ]
      AccountName,

      @UI.lineItem: [ { position:60, importance: #HIGH } ]
      FinancialAccountTypeName,

      @UI.lineItem: [ { position:70, importance: #HIGH } ]
      PostalCode,

      @UI.lineItem: [ { position:80, importance: #HIGH } ]
      CityName,
      
      @UI.hidden: true
      IntercompanyTransaction,
      
      @UI.hidden: true
      cast( ClearingJournalEntry as fis_augbl_depre  preserving type )                  as ClearingAccountingDocument,

      @UI.hidden: true
      cast( ClearingJournalEntryFiscalYear as fis_auggj_no_conv_depre preserving type ) as ClearingDocFiscalYear,
           
      _Header
}

Learn More