C_CoCodeChiefFinOfficerDPM

DDL: C_COCODECHIEFFINOFFICERDPM Type: view CONSUMPTION

Data Plane DCL for Company Codes in GL Line Items

C_CoCodeChiefFinOfficerDPM is a Consumption CDS View that provides data about "Data Plane DCL for Company Codes in GL Line Items" in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 34 fields with key fields SourceLedger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem I_GLAccountLineItem from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CFICOCOCFO view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Data Plane DCL for Company Codes in GL Line Items view
ObjectModel.representativeKey LedgerGLLineItem view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_GLAccountLineItem SourceLedger
KEY CompanyCode I_GLAccountLineItem CompanyCode
KEY FiscalYear I_GLAccountLineItem FiscalYear
KEY AccountingDocument I_GLAccountLineItem AccountingDocument
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem
KEY Ledger I_GLAccountLineItem Ledger
GLAccount I_GLAccountLineItem GLAccount
ChartOfAccounts I_GLAccountLineItem ChartOfAccounts
FinancialAccountType I_GLAccountLineItem FinancialAccountType
BusinessArea I_GLAccountLineItem BusinessArea
Segment I_GLAccountLineItem Segment
ProfitCenter I_GLAccountLineItem ProfitCenter
CostCenter I_GLAccountLineItem CostCenter
ControllingArea I_GLAccountLineItem ControllingArea
Supplier I_GLAccountLineItem Supplier
Customer I_GLAccountLineItem Customer
AccountingDocumentType I_GLAccountLineItem AccountingDocumentType
_Ledger _Ledger
_SourceLedger _SourceLedger
_CompanyCode _CompanyCode
_FiscalYear _FiscalYear
_JournalEntry _JournalEntry
_GLAccountInCompanyCode _GLAccountInCompanyCode
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_AccountingDocumentType _AccountingDocumentType
_FinancialAccountType _FinancialAccountType
_BusinessArea _BusinessArea
_Segment _Segment
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_ControllingArea _ControllingArea
_Supplier _Supplier
_Customer _Customer 
//////////////////////////////////////////////////////////////////////////////

// Documentation: This view is only a dummy view for a DCL

//    which shall only be used in the context of Data Plane


@AbapCatalog: {sqlViewName: 'CFICOCOCFO',
               compiler.compareFilter: true,
               buffering.status: #NOT_ALLOWED,
               preserveKey: true }
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #REQUIRED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Data Plane DCL for Company Codes in GL Line Items'
@ObjectModel: { representativeKey: 'LedgerGLLineItem',
                usageType: { sizeCategory: #XXL,
                             dataClass:  #MIXED,
                             serviceQuality: #D }
              }
@Metadata: { ignorePropagatedAnnotations: true,
             allowExtensions:true }
@VDM.viewType: #CONSUMPTION

define view C_CoCodeChiefFinOfficerDPM
  as select from I_GLAccountLineItem
{

      @ObjectModel.foreignKey.association: '_SourceLedger'
  key I_GLAccountLineItem.SourceLedger,
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key I_GLAccountLineItem.CompanyCode,
      @ObjectModel.foreignKey.association: '_FiscalYear'
  key I_GLAccountLineItem.FiscalYear,
      @ObjectModel.foreignKey.association: '_JournalEntry'
  key I_GLAccountLineItem.AccountingDocument,
  key I_GLAccountLineItem.LedgerGLLineItem,
      @ObjectModel.foreignKey.association: '_Ledger'
  key I_GLAccountLineItem.Ledger,

      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
      I_GLAccountLineItem.GLAccount,
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      I_GLAccountLineItem.ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_FinancialAccountType'
      I_GLAccountLineItem.FinancialAccountType,
      @ObjectModel.foreignKey.association: '_BusinessArea'
      I_GLAccountLineItem.BusinessArea,
      @ObjectModel.foreignKey.association: '_Segment'
      I_GLAccountLineItem.Segment,
      @ObjectModel.foreignKey.association: '_ProfitCenter'
      I_GLAccountLineItem.ProfitCenter,
      @ObjectModel.foreignKey.association: '_CostCenter'
      I_GLAccountLineItem.CostCenter,      
      @ObjectModel.foreignKey.association: '_ControllingArea'
      I_GLAccountLineItem.ControllingArea,
      @ObjectModel.foreignKey.association: '_Supplier'
      I_GLAccountLineItem.Supplier,
      @ObjectModel.foreignKey.association: '_Customer'
      I_GLAccountLineItem.Customer,
      @ObjectModel.foreignKey.association: '_AccountingDocumentType'
      I_GLAccountLineItem.AccountingDocumentType,



      _Ledger,
      _SourceLedger,
      _CompanyCode,
      _FiscalYear,
      _JournalEntry,
      _GLAccountInCompanyCode,
      _GLAccountInChartOfAccounts,
      _ChartOfAccounts,
      _AccountingDocumentType,
      _FinancialAccountType,
      _BusinessArea,
      _Segment,
      _ProfitCenter,
      _CostCenter,
      _ControllingArea,
      _Supplier,
      _Customer
}
where
  1 <> 1

Learn More