C_RO_SAFTJournalEntryItemQ

DDL: C_RO_SAFTJOURNALENTRYITEMQ SQL: CROSAFTJRNENITMQ Type: view CONSUMPTION

GL Item and Header for RO SAFT - Query

C_RO_SAFTJournalEntryItemQ is a Consumption CDS View that provides data about "GL Item and Header for RO SAFT - Query" in SAP S/4HANA. It reads from 1 data source (C_RO_SAFTJournalEntryItemC) and exposes 45 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument.

1 data source(s) 45 fields

Data Sources (1)

SourceAliasJoin Type
C_RO_SAFTJournalEntryItemC C_RO_SAFTJournalEntryItemC from

Parameters (2)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag
P_VATRegistration stceg

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTJRNENITMQ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Analytics.query true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label GL Item and Header for RO SAFT - Query view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger
KEY Ledger Ledger
KEY CompanyCode CompanyCode
KEY FiscalYear FiscalYear
KEY AccountingDocument AccountingDocument
KEY LedgerGLLineItem LedgerGLLineItem
AccountingDocumentItem AccountingDocumentItem
Customer Customer
Supplier Supplier
BusinessPartner BusinessPartner
VATRegistration VATRegistration
CustomerVATRegistration CustomerVATRegistration
SupplierVATRegistration SupplierVATRegistration
DebitCreditCode DebitCreditCode
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency
CompanyCodeCurrency CompanyCodeCurrency
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy
CreditAmountCurrency CreditAmountCurrency
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy
DebitAmountCurrency DebitAmountCurrency
AmountInTransactionCurrency AmountInTransactionCurrency
TransactionCurrency TransactionCurrency
CreditAmountInTransCrcy CreditAmountInTransCrcy
DebitAmountInTransCrcy DebitAmountInTransCrcy
TaxCode TaxCode
TaxCountry TaxCountry
GLAccount GLAccount
GLAccountType GLAccountType
RO_SAFTStandardAccount RO_SAFTStandardAccount
PostingDate PostingDate
DocumentDate DocumentDate
AccountingDocumentCreationDate AccountingDocumentCreationDate
AccountingDocumentType AccountingDocumentType
AccountingDocumentTypeName AccountingDocumentTypeName
AccountingDocCreatedByUser AccountingDocCreatedByUser
StatryRptCategory StatryRptCategory
StatryRptgEntity StatryRptgEntity
StatryRptRunID StatryRptRunID
RO_SAFTJournalTransaction RO_SAFTJournalTransaction
RO_SAFTJournalTransactionType RO_SAFTJournalTransactionType
RO_SAFTJournalTransDescription RO_SAFTJournalTransDescription
RO_SAFTSourceDocument RO_SAFTSourceDocument
ValueDate ValueDate
DocumentItemText DocumentItemText
TransactionTypeDetermination TransactionTypeDetermination 
@AbapCatalog.sqlViewName: 'CROSAFTJRNENITMQ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@Analytics.query:true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'GL Item and Header for RO SAFT - Query'
define view C_RO_SAFTJournalEntryItemQ

  with parameters

    P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag,
    P_VATRegistration : stceg
    
  as select from C_RO_SAFTJournalEntryItemC( P_AlternativeGLAccountIsUsed : $parameters.P_AlternativeGLAccountIsUsed, P_VATRegistration : $parameters.P_VATRegistration )

{
      @Consumption.filter.selectionType: #SINGLE
      @AnalyticsDetails.query.axis: #ROWS
  key SourceLedger,
      @Consumption.filter.selectionType: #SINGLE
      @AnalyticsDetails.query.axis: #ROWS
  key Ledger,
      @Consumption.filter : { selectionType : #SINGLE, multipleSelections : true}
      @AnalyticsDetails.query.axis: #ROWS  
  key CompanyCode,
      @AnalyticsDetails.query.axis: #ROWS
      @Consumption.filter.selectionType: #SINGLE
  key FiscalYear,
      @AnalyticsDetails.query.axis: #ROWS
      @Consumption.filter.selectionType: #SINGLE
  key AccountingDocument,
      @AnalyticsDetails.query.axis: #ROWS
  key LedgerGLLineItem,
      AccountingDocumentItem,
      @Consumption.filter.selectionType: #RANGE      
      Customer,
      @Consumption.filter.selectionType: #RANGE
      Supplier,
      @Consumption.filter.selectionType: #RANGE
      BusinessPartner,
      VATRegistration,
      CustomerVATRegistration,
      SupplierVATRegistration,
      DebitCreditCode,
      @AnalyticsDetails.query.axis: #COLUMNS
      AmountInCompanyCodeCurrency,      
      CompanyCodeCurrency,
      @AnalyticsDetails.query.axis: #COLUMNS            
      CreditAmountInCoCodeCrcy,
      CreditAmountCurrency,
      @AnalyticsDetails.query.axis: #COLUMNS      
      DebitAmountInCoCodeCrcy,
      DebitAmountCurrency,
      @AnalyticsDetails.query.axis: #COLUMNS      
      AmountInTransactionCurrency,
      TransactionCurrency,
      @AnalyticsDetails.query.axis: #COLUMNS      
      CreditAmountInTransCrcy,
      @AnalyticsDetails.query.axis: #COLUMNS      
      DebitAmountInTransCrcy,
      TaxCode,
      TaxCountry,
      GLAccount,
      GLAccountType,
      RO_SAFTStandardAccount,
      @Consumption.filter.selectionType: #RANGE
      PostingDate,
      DocumentDate,
      AccountingDocumentCreationDate,
      @Consumption.filter.selectionType: #SINGLE
      AccountingDocumentType,
      AccountingDocumentTypeName,
      AccountingDocCreatedByUser,
      @Consumption.filter.selectionType: #SINGLE
      StatryRptCategory,
      @Consumption.filter.selectionType: #SINGLE
      StatryRptgEntity,
      @Consumption.filter.selectionType: #SINGLE
      StatryRptRunID,
      RO_SAFTJournalTransaction,
      RO_SAFTJournalTransactionType,
      RO_SAFTJournalTransDescription,
      RO_SAFTSourceDocument,
      ValueDate,
      DocumentItemText,
      TransactionTypeDetermination      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_RO_SAFTJOURNALENTRYITEMC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More