C_RO_SAFTPurInvoiceItemC

DDL: C_RO_SAFTPURINVOICEITEMC SQL: CROSAFTPURINVIC Type: view CONSUMPTION Package: GLO_FIN_IS_SAFT_RO

Purchase invoice item for RO SAFT - Cube

C_RO_SAFTPurInvoiceItemC is a Consumption CDS View (Cube) that provides data about "Purchase invoice item for RO SAFT - Cube" in SAP S/4HANA. It reads from 2 data sources (P_RO_SAFTInvoiceItemCount, P_RO_SAFTOplAcctgDocItmExc) and exposes 31 fields with key fields StatryRptCategory, StatryRptgEntity, StatryRptRunID, SourceLedger, Ledger. Part of development package GLO_FIN_IS_SAFT_RO.

2 data source(s) 31 fields

Data Sources (2)

SourceAliasJoin Type
P_RO_SAFTInvoiceItemCount P_RO_SAFTInvoiceItemCount inner
P_RO_SAFTOplAcctgDocItmExc P_RO_SAFTOplAcctgDocItmExc inner

Parameters (1)

NameTypeDefault
P_AlternativeGLAccountIsUsed saft_ro_alt_gl_account_flag

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CROSAFTPURINVIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_INCLUDED view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Purchase invoice item for RO SAFT - Cube view
Metadata.allowExtensions true view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY StatryRptCategory Item StatryRptCategory
KEY StatryRptgEntity Item StatryRptgEntity
KEY StatryRptRunID Item StatryRptRunID
KEY SourceLedger Item SourceLedger
KEY Ledger Item Ledger
KEY CompanyCode Item CompanyCode
KEY FiscalYear Item FiscalYear
KEY AccountingDocument Item AccountingDocument
KEY LedgerGLLineItem Item LedgerGLLineItem
AccountingDocumentItem Item AccountingDocumentItem
AccountingDocumentType Item AccountingDocumentType
Product Item Product
BaseUnit Item BaseUnit
TransactionTypeDetermination Item TransactionTypeDetermination
PostingDate Item PostingDate
CompanyCodeCurrency Item CompanyCodeCurrency
TransactionCurrency Item TransactionCurrency
IsNegativePosting Item IsNegativePosting
RO_SAFTGoodsService Item RO_SAFTGoodsService
ProductDescription Item ProductDescription
SourceUnitOfMeasureFactor Item SourceUnitOfMeasureFactor
DebitCreditCode Item DebitCreditCode
ConversionFactor Item ConversionFactor
AmountInTransactionCurrency Item AmountInTransactionCurrency
AmountInCompanyCodeCurrency Item AmountInCompanyCodeCurrency
UnitPriceAmountInReportingCrcy Item UnitPriceAmountInReportingCrcy
TaxReportingDate Item TaxReportingDate
DocumentItemText Item DocumentItemText
Quantity Item Quantity
RO_SAFTExchangeRate Item RO_SAFTExchangeRate
RO_SAFTStandardAccount Item RO_SAFTStandardAccount 
@AbapCatalog.sqlViewName: 'CROSAFTPURINVIC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #CONSUMPTION
@Consumption.dbHints: ['PREAGGR_BEFORE_JOIN']
@Analytics: { dataCategory: #CUBE }
@Analytics.internalName:#LOCAL
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_INCLUDED
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Purchase invoice item for RO SAFT - Cube'
@Metadata.allowExtensions:true
define view C_RO_SAFTPurInvoiceItemC
  with parameters

    P_AlternativeGLAccountIsUsed : saft_ro_alt_gl_account_flag

  as select distinct from  P_RO_SAFTPurInvItem (P_AlternativeGLAccountIsUsed: $parameters.P_AlternativeGLAccountIsUsed)       as Item
    inner join             P_RO_SAFTOplAcctgDocItmExc(P_AlternativeGLAccountIsUsed: $parameters.P_AlternativeGLAccountIsUsed) as Bseg                     on  Bseg.AccountingDocument     = Item.AccountingDocument
                                                                                                                                                          and Bseg.CompanyCode            = Item.CompanyCode
                                                                                                                                                          and Bseg.FiscalYear             = Item.FiscalYear
                                                                                                                                                          and Bseg.PostingDate            = Item.PostingDate
                                                                                                                                                          and Bseg.AccountingDocumentType = Item.AccountingDocumentType
                                                                                                                                                          and Bseg.FinancialAccountType   = 'K'

    inner join             P_RO_SAFTInvoiceItemCount(P_AlternativeGLAccountIsUsed: $parameters.P_AlternativeGLAccountIsUsed)  as reporting_country_filter on  Item.AccountingDocument          = reporting_country_filter.AccountingDocument
                                                                                                                                                          and Item.CompanyCode                 = reporting_country_filter.CompanyCode
                                                                                                                                                          and Item.FiscalYear                  = reporting_country_filter.FiscalYear
                                                                                                                                                          and Item.PostingDate                 = reporting_country_filter.PostingDate
                                                                                                                                                          and Item.AccountingDocumentType      = reporting_country_filter.AccountingDocumentType
                                                                                                                                                          and reporting_country_filter.TaxType = 'V'

    left outer to one join I_RO_SAFTSpecialGLIndicator                                                                        as SpecialGLIndicator       on  Bseg.CompanyCode          = SpecialGLIndicator.CompanyCode
                                                                                                                                                          and Bseg.FinancialAccountType = SpecialGLIndicator.AccountType
                                                                                                                                                          and Bseg.SpecialGLCode        = SpecialGLIndicator.SpecialGLCode

{
  key Item.StatryRptCategory,
  key Item.StatryRptgEntity,
  key Item.StatryRptRunID,
  key Item.SourceLedger,
  key Item.Ledger,
  key Item.CompanyCode,
  key Item.FiscalYear,
  key Item.AccountingDocument,
  key Item.LedgerGLLineItem,
      Item.AccountingDocumentItem,
      Item.AccountingDocumentType,
      Item.Product,
      Item.BaseUnit,
      Item.TransactionTypeDetermination,
      Item.PostingDate,
      @Semantics.currencyCode:true
      Item.CompanyCodeCurrency,
      @Semantics.currencyCode:true
      Item.TransactionCurrency,
      Item.IsNegativePosting,
      Item.RO_SAFTGoodsService,
      Item.ProductDescription,
      Item.SourceUnitOfMeasureFactor,

      Item.DebitCreditCode,

      Item.ConversionFactor,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      Item.AmountInTransactionCurrency,

      @Aggregation.default: #SUM
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      Item.AmountInCompanyCodeCurrency,

      @Aggregation.default: #MAX
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      Item.UnitPriceAmountInReportingCrcy,

      Item.TaxReportingDate,

      Item.DocumentItemText, // Description


      @Aggregation.default: #SUM
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      Item.Quantity,         // Quantity


      @Aggregation.default: #MAX
      Item.RO_SAFTExchangeRate,

      Item.RO_SAFTStandardAccount

}
where
  SpecialGLIndicator.SpecialGLCode is null

Learn More