P_ID_PricingElementGroup

DDL: P_ID_PRICINGELEMENTGROUP Type: view COMPOSITE

P_ID_PricingElementGroup is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CFinBillingDocument, I_CFinBillingDocumentItem) and exposes 16 fields with key fields SenderLogicalSystem, BillingDocument, BillingDocumentItem.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_CFinBillingDocument I_BillingDocumentHeader inner
I_CFinBillingDocumentItem I_CFinBillingDocumentItem from

Parameters (2)

NameTypeDefault
P_CompanyCode fis_bukrs
P_FiscalYear gjahr

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PIDPRICELMG view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SenderLogicalSystem I_CFinBillingDocumentItem SenderLogicalSystem
KEY BillingDocument I_CFinBillingDocumentItem CentralFinanceBillingDocument
KEY BillingDocumentItem I_CFinBillingDocumentItem CFinBillingDocumentItem
TaxCode I_CFinBillingDocumentItem TaxCode
Material I_CFinBillingDocumentItem Material
BillingQuantity I_CFinBillingDocumentItem BillingQuantity
EligibleAmountForCashDiscount
NetAmount I_CFinBillingDocumentItem NetAmount
GrossAmount I_BillingDocumentItem GrossAmount
Subtotal1Amount I_BillingDocumentItem Subtotal1Amount
BillingDocumentItemText I_CFinBillingDocumentItem BillingDocumentItemText
TaxAmountinTransCrcy I_BillingDocumentItem TaxAmount
FiscalYear _Billing FiscalYear
AccountingDocument _Billing AccountingDocument
BillingDocumentType _Billing BillingDocumentType
SalesOrganization _Billing SalesOrganization 
@AccessControl: {authorizationCheck: #NOT_REQUIRED}
@AbapCatalog: {sqlViewName: 'PIDPRICELMG', preserveKey: true, compiler.compareFilter: true}
@VDM: {private: true, viewType: #COMPOSITE}
@ClientHandling: {algorithm: #SESSION_VARIABLE}
define view P_ID_PricingElementGroup
  with parameters
    @EndUserText.label: 'Company Code'
    P_CompanyCode : fis_bukrs,
    P_FiscalYear  : gjahr
  as select from            I_CFinBillingDocumentItem      as I_CFinBillingDocumentItem
    inner join              I_CFinBillingDocument          as I_BillingDocumentHeader  on  I_CFinBillingDocumentItem.CentralFinanceBillingDocument = I_BillingDocumentHeader.CentralFinanceBillingDocument
    left outer to one join  I_BillingDocument              as _Billing                 on  I_CFinBillingDocumentItem.CentralFinanceBillingDocument = _Billing.BillingDocument
                                                                                       and _Billing.CompanyCode                                    = :P_CompanyCode
                                                                                       and _Billing.FiscalYear                                     = :P_FiscalYear
                                                                                       and _Billing.AccountingDocument                             is not initial
    left outer to many join I_CentralFinancePricingElement as BillingDocumentPrcgElmnt on  I_BillingDocumentHeader.PricingDocument                 = BillingDocumentPrcgElmnt.CentralFinancePricingDocument
                                                                                       and I_CFinBillingDocumentItem.CFinBillingDocumentItem       = BillingDocumentPrcgElmnt.CFinPricingDocumentItem
                                                                                       and BillingDocumentPrcgElmnt.ConditionClass                 = 'A'
                                                                                       and ConditionInactiveReason                                 = ''
    // get tax amount(cFin not included)

    left outer to one join  I_BillingDocumentItem          as I_BillingDocumentItem    on  I_CFinBillingDocumentItem.SenderLogicalSystem           = '          '
                                                                                       and I_CFinBillingDocumentItem.CentralFinanceBillingDocument = I_BillingDocumentItem.BillingDocument
                                                                                       and I_CFinBillingDocumentItem.CFinBillingDocumentItem       = I_BillingDocumentItem.BillingDocumentItem
{
  key I_CFinBillingDocumentItem.SenderLogicalSystem,
  key I_CFinBillingDocumentItem.CentralFinanceBillingDocument as BillingDocument,
  key I_CFinBillingDocumentItem.CFinBillingDocumentItem       as BillingDocumentItem,
      I_CFinBillingDocumentItem.TaxCode,
      I_CFinBillingDocumentItem.Material,
      I_CFinBillingDocumentItem.BillingQuantity,
      sum(BillingDocumentPrcgElmnt.ConditionAmount)           as EligibleAmountForCashDiscount,
      I_CFinBillingDocumentItem.NetAmount,
      I_BillingDocumentItem.GrossAmount,
      I_BillingDocumentItem.Subtotal1Amount,
      I_CFinBillingDocumentItem.BillingDocumentItemText,
      I_BillingDocumentItem.TaxAmount                         as TaxAmountinTransCrcy,
      _Billing.FiscalYear,
      _Billing.AccountingDocument,
      _Billing.BillingDocumentType,
      _Billing.SalesOrganization
}
where
  I_BillingDocumentHeader.CompanyCode = :P_CompanyCode
group by
  I_CFinBillingDocumentItem.SenderLogicalSystem,
  I_CFinBillingDocumentItem.CentralFinanceBillingDocument,
  I_CFinBillingDocumentItem.CFinBillingDocumentItem,
  I_CFinBillingDocumentItem.TaxCode,
  I_CFinBillingDocumentItem.Material,
  I_CFinBillingDocumentItem.BillingQuantity,
  I_CFinBillingDocumentItem.NetAmount,
  I_BillingDocumentItem.GrossAmount,
  I_BillingDocumentItem.Subtotal1Amount,
  I_CFinBillingDocumentItem.BillingDocumentItemText,
  I_BillingDocumentItem.TaxAmount,
  _Billing.FiscalYear,
  _Billing.AccountingDocument,
  _Billing.BillingDocumentType,
  _Billing.SalesOrganization
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM",
"I_CENTRALFINANCEPRICINGELEMENT",
"I_CFINBILLINGDOCUMENT",
"I_CFINBILLINGDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More