C_AccountingDocument

DDL: C_ACCOUNTINGDOCUMENT SQL: CACCTGDOC Type: view CONSUMPTION

Accounting Document

C_AccountingDocument is a Consumption CDS View that provides data about "Accounting Document" in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 14 fields with key fields CompanyCode, AccountingDocument, FiscalYear. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from

Associations (1)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CACCTGDOC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Accounting Document view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
UI.headerInfo.typeName Accounting Document view
UI.headerInfo.typeNamePlural Accounting Documents view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
AccountingDocumentCreationDate AccountingDocumentCreationDate
PostingDate PostingDate
AccountingDocumentType
CompanyCodeCurrency CompanyCodeCurrency
AccountingDocumentHeaderText
DocumentReferenceID DocumentReferenceID
FiscalPeriod FiscalPeriod
DocumentDate DocumentDate
AccountingDocCreatedByUser AccountingDocCreatedByUser
IntercompanyTransaction IntercompanyTransaction
_Header _Header 
@AbapCatalog.sqlViewName: 'CACCTGDOC'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Accounting Document'
@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: 'Accounting Document',
  typeNamePlural: 'Accounting Documents'
}

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

define view C_AccountingDocument
   as select from I_JournalEntry

    association [1..1] to C_ClearingDocument as _Header on  $projection.CompanyCode             = _Header.CompanyCode
                                                        and $projection.AccountingDocument      = _Header.ClearingJournalEntry 
                                                        and $projection.FiscalYear              = _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: 20, importance: #HIGH }]
      @Consumption.semanticObject: 'AccountingDocument'
  key AccountingDocument,
  

      @UI.lineItem: [{ position: 30, importance: #HIGH }]
      @Consumption.semanticObject: 'FiscalYear'
  key FiscalYear,
  
      @UI.lineItem: [{ position: 40, importance: #HIGH }]
      AccountingDocumentCreationDate, 

      @UI.lineItem: [{ position: 50, importance: #HIGH }]
      PostingDate,
      
      @UI.lineItem: [{ position: 60, importance: #HIGH }]
      cast(AccountingDocumentType as fis_blart)       as AccountingDocumentType,
      
      @UI.lineItem: [{ position: 70, importance: #HIGH }]
      CompanyCodeCurrency,
      
      @UI.lineItem: [{ position: 80, exclude: true, importance: #LOW }]
      cast(AccountingDocumentHeaderText as fac_bktxt) as AccountingDocumentHeaderText,

      @UI.lineItem: [{ position: 90, exclude: true, importance: #LOW }]
      DocumentReferenceID,
      
      @UI.lineItem: [{ position: 100, exclude: true, importance: #LOW  }]
      FiscalPeriod,

       @UI.lineItem: [{ position: 110, exclude: true, importance: #LOW  }]
      DocumentDate,

      @UI.lineItem: [{ position: 120, exclude: true, importance: #LOW  }]
      AccountingDocCreatedByUser,
      
      @UI.hidden: true
      IntercompanyTransaction,
      
      _Header
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY"
],
"ASSOCIATED":
[
"C_CLEARINGDOCUMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More