I_CoCodeLedgerSourceLedger

DDL: I_COCODELEDGERSOURCELEDGER Type: view_entity BASIC Package: FINS_FIS_FICO

Company Code Assignment of Ledgers

I_CoCodeLedgerSourceLedger is a Basic CDS View that provides data about "Company Code Assignment of Ledgers" in SAP S/4HANA. It reads from 1 data source (I_LedgerCompanyCodeCrcyRoles) and exposes 18 fields with key fields Ledger, CompanyCode, SourceLedger. It has 1 association to related views. Part of development package FINS_FIS_FICO.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_LedgerCompanyCodeCrcyRoles _LedgerCompanyCodeCrcyRoles $projection.CompanyCode = _LedgerCompanyCodeCrcyRoles.CompanyCode and $projection.Ledger = _LedgerCompanyCodeCrcyRoles.Ledger

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Company Code Assignment of Ledgers view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.modelingPattern #NONE view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_LedgerCompanyCodeCrcyRoles Ledger
KEY CompanyCode I_LedgerCompanyCodeCrcyRoles CompanyCode
KEY SourceLedger I_LedgerSourceLedger SourceLedger
CompanyCodeCurrencyRole I_LedgerCompanyCodeCrcyRoles CompanyCodeCurrencyRole
GlobalCurrencyRole I_LedgerCompanyCodeCrcyRoles GlobalCurrencyRole
FreeDefinedCurrency1Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency1Role
FreeDefinedCurrency2Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency2Role
FreeDefinedCurrency3Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency3Role
FreeDefinedCurrency4Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency4Role
FreeDefinedCurrency5Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency5Role
FreeDefinedCurrency6Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency6Role
FreeDefinedCurrency7Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency7Role
FreeDefinedCurrency8Role I_LedgerCompanyCodeCrcyRoles FreeDefinedCurrency8Role
FunctionalCurrencyRole I_LedgerCompanyCodeCrcyRoles FunctionalCurrencyRole
AccountingPrinciple I_LedgerCompanyCodeCrcyRoles AccountingPrinciple
_CompanyCode I_LedgerCompanyCodeCrcyRoles _CompanyCode
_Ledger I_LedgerCompanyCodeCrcyRoles _Ledger
_LedgerCompanyCodeCrcyRoles _LedgerCompanyCodeCrcyRoles 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Company Code Assignment of Ledgers'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: { usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING },
  supportedCapabilities: [#SQL_DATA_SOURCE],
  modelingPattern: #NONE
}

@VDM.viewType: #BASIC

define view entity I_CoCodeLedgerSourceLedger as select from I_LedgerCompanyCodeCrcyRoles

left outer to many join I_LedgerSourceLedger on I_LedgerCompanyCodeCrcyRoles.Ledger = I_LedgerSourceLedger.Ledger

association [0..1] to I_LedgerCompanyCodeCrcyRoles as _LedgerCompanyCodeCrcyRoles on  $projection.CompanyCode = _LedgerCompanyCodeCrcyRoles.CompanyCode
                                                                                  and $projection.Ledger = _LedgerCompanyCodeCrcyRoles.Ledger

{
  key I_LedgerCompanyCodeCrcyRoles.Ledger,
  key I_LedgerCompanyCodeCrcyRoles.CompanyCode,
  key I_LedgerSourceLedger.SourceLedger,
  I_LedgerCompanyCodeCrcyRoles.CompanyCodeCurrencyRole,
  I_LedgerCompanyCodeCrcyRoles.GlobalCurrencyRole,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency1Role,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency2Role,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency3Role,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency4Role,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency5Role,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency6Role,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency7Role,
  I_LedgerCompanyCodeCrcyRoles.FreeDefinedCurrency8Role,
  I_LedgerCompanyCodeCrcyRoles.FunctionalCurrencyRole,
  I_LedgerCompanyCodeCrcyRoles.AccountingPrinciple,
  I_LedgerCompanyCodeCrcyRoles._CompanyCode,
  I_LedgerCompanyCodeCrcyRoles._Ledger,
  _LedgerCompanyCodeCrcyRoles
}

Learn More