I_ACCRITEMTYPEFORLEDGERGROUP

CDS View

Accrual Item Type for Ledger Group

I_ACCRITEMTYPEFORLEDGERGROUP is a CDS View in S/4HANA. Accrual Item Type for Ledger Group. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
FACRA_RUN_PROGRAM view left_outer

Fields (1)

KeyField CDS FieldsUsed in Views
KEY LedgerGroup ldgrp 1 
@AbapCatalog.sqlViewName: 'IITEMGRP'
@EndUserText.label: 'Accrual Item Type for Ledger Group'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #MASTER
}
@VDM.viewType: #BASIC
define view I_AccrItemTypeForLedgerGroup
  as select from    tace_itemtypel  as _itemtypel
    left outer join finsc_ledger    as _leading on  _leading.xleading = 'X'
                                                and _itemtypel.ldgrp  = ''
    left outer join fagl_tldgrp_map as _map     on  _itemtypel.ldgrp = _map.ldgrp
                                                and _map.represent   = 'X'
  association [0..1] to I_AccrEnginePerdcPostgFrqcy   as _PerdcPostgFrqcy      on  $projection.AccrPerdcPostingFrequency = _PerdcPostgFrqcy.AccrPerdcPostingFrequency                                                
{
  key  _itemtypel.comp                                      as AccrualEngineApplication,
  key  _itemtypel.itemtype                                  as AccrualItemType,
  key  _itemtypel.bukrs                                     as CompanyCode,
  key  _itemtypel.ldgrp                                     as LedgerGroup,
       cast( case
       when _leading.rldnr <> '' then _leading.rldnr
       else _map.rldnr end as fins_ledger preserving type ) as Ledger,
       @ObjectModel.foreignKey.association: '_PerdcPostgFrqcy'
       _itemtypel.rhythm                                    as AccrPerdcPostingFrequency,
       xinactive                                            as AccrualItemTypeIsInactive,
       
       _PerdcPostgFrqcy

}where xinactive = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAGL_TLDGRP_MAP",
"FINSC_LEDGER",
"TACE_ITEMTYPEL"
],
"ASSOCIATED":
[
"I_ACCRENGINEPERDCPOSTGFRQCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More