I_LEDGERGROUPASSIGNMENT
Assignment of Ledgers to Ledger Groups
I_LEDGERGROUPASSIGNMENT is a CDS View in S/4HANA. Assignment of Ledgers to Ledger Groups. It contains 3 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FAA_UPA_MIG_BAL_DOC | view_entity | inner | Asset documents | |
| FAA_UPA_MIG_BAL_ODOC | view_entity | inner | Old asset documents | |
| I_AdditionalCurrencyRoles | view | inner | BASIC | Additional Currency Roles for Company Code |
| I_DeprAreaByCoCodeWithCrcyRole | view | left_outer | COMPOSITE | Depreciation Areas of Company Code with Currency Role |
| I_DepreciationAreaWithLedger | view | left_outer | BASIC | Depreciation Area with Ledger |
Fields (3)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Ledger | Ledger | 3 |
| KEY | LedgerGroup | LedgerGroup | 1 |
| _Ledger | _Ledger | 1 |
@AbapCatalog: {sqlViewName: 'IFILDGRPASSGMT', preserveKey: true}
@EndUserText.label: 'Assignment of Ledgers to Ledger Groups'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
usageType.sizeCategory: #S,
usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view I_LedgerGroupAssignment
as select from fagl_tldgrp_map
association [1] to I_LedgerGroup as _LedgerGroup on $projection.LedgerGroup = _LedgerGroup.LedgerGroup
association [1] to I_Ledger as _Ledger on $projection.Ledger = _Ledger.Ledger
{
@ObjectModel.foreignKey.association: '_LedgerGroup'
key ldgrp as LedgerGroup,
@ObjectModel.foreignKey.association: '_Ledger'
key rldnr as Ledger,
represent as IsRepresentativeLedger,
_LedgerGroup,
_Ledger
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAGL_TLDGRP_MAP"
],
"ASSOCIATED":
[
"I_LEDGER",
"I_LEDGERGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/