FAC_AUDIT_Z3_PRICEELEMENT

DDL: FAC_AUDIT_Z3_PRICEELEMENT SQL: FACZ3PRIELE Type: view Package: FINS_FI_DART_Z3
37 Fields 3 Data Sources 2 Associations

Pricing Element

FAC_AUDIT_Z3_PRICEELEMENT is a CDS View that provides data about "Pricing Element" in SAP S/4HANA. It reads from 3 data sources (I_BillingDocument, I_LedgerCompanyCodeCrcyRoles, I_PricingElement) and exposes 37 fields with key fields PricingDocument, PricingDocumentItem, BillingDocument, PricingProcedureStep, PricingProcedureCounter. It has 2 associations to related views. Part of development package FINS_FI_DART_Z3.

Data Sources (3)

SourceAliasJoin Type
I_BillingDocument BillingDocument left_outer
I_LedgerCompanyCodeCrcyRoles I_LedgerCompanyCodeCrcyRoles inner
I_PricingElement PricingElement from

Parameters (5)

NameTypeDefault
P_Ledger fins_ledger
P_FiscalYear fins_gjahr
P_FromFiscalPeriod fins_fagl_fiscper_from
P_ToFiscalPeriod fins_fagl_fiscper_to
P_Language sylangu

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_FiscalPeriodForVariant _ToFiscalPeriodForVariant _ToFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod
[0..1] I_FiscalPeriodForVariant _FromFiscalPeriodForVariant _FromFiscalPeriodForVariant.FiscalYearVariant = $projection.FiscalYearVariant and _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear and _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FACZ3PRIELE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Pricing Element view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PricingDocument I_PricingElement PricingDocument Document Condition
KEY PricingDocumentItem I_PricingElement PricingDocumentItem Item
KEY BillingDocument I_BillingDocument BillingDocument SD Document
KEY PricingProcedureStep I_PricingElement PricingProcedureStep Step Number
KEY PricingProcedureCounter I_PricingElement PricingProcedureCounter Pricing Procedure Counter
SystemClient System Client
ConditionApplication I_PricingElement ConditionApplication Application
ConditionApplicationName
ConditionType I_PricingElement ConditionType Condition type
PricingDateTime I_PricingElement PricingDateTime
PricingDate Pricing Date
ConditionCalculationType I_PricingElement ConditionCalculationType Calculat.Type
ConditionCalculationTypeName
ConditionBaseValue I_PricingElement ConditionBaseValue Cond.Basis
ConditionRateValue I_PricingElement ConditionRateValue Condition Rate Value
ConditionCurrency I_PricingElement ConditionCurrency Currency
PriceDetnExchangeRate I_PricingElement PriceDetnExchangeRate Exchange Rate
ConditionQuantity I_PricingElement ConditionQuantity Pricing Unit
ConditionQuantityUnit I_PricingElement ConditionQuantityUnit Unit of Measure
ConditionCategory I_PricingElement ConditionCategory Condit.Category
ConditionCategoryName
ConditionIsForStatistics I_PricingElement ConditionIsForStatistics Statistical
ConditionRecord I_PricingElement ConditionRecord Cond.Record No.
ConditionSequentialNumber I_PricingElement ConditionSequentialNumber SequNo of Cond.
GLAccount I_PricingElement GLAccount General Ledger
TaxCode I_PricingElement TaxCode Tax Code
AccrualsGLAccount I_PricingElement AccrualsGLAccount Accruals Acc.
WithholdingTaxCode I_PricingElement WithholdingTaxCode WTax Code
ConditionAmount I_PricingElement ConditionAmount Condition Value
TransactionCurrency I_PricingElement TransactionCurrency Transaction Currency
ConditionInactiveReason I_PricingElement ConditionInactiveReason Inactive
ConditionClass I_PricingElement ConditionClass Condition Class
ConditionClassName
FiscalYearVariant I_LedgerCompanyCodeCrcyRoles FiscalYearVariant FY Variant
SalesOrganization I_BillingDocument SalesOrganization Sales Organization
CompanyCode I_BillingDocument CompanyCode Receiver Company Code
_Currency _Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FAC_AUDIT_Z3_PRICEELEMENT.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FACZ3PRIELE
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_AUDIT_Z3_PRICEELEMENT AS
SELECT
  PricingElement.PricingDocument AS PricingDocument,
  PricingElement.PricingDocumentItem AS PricingDocumentItem,
  BillingDocument.BillingDocument AS BillingDocument,
  PricingElement.PricingProcedureStep AS PricingProcedureStep,
  PricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  $session.client AS SystemClient,
  PricingElement.ConditionApplication AS ConditionApplication,
  _ConditionApplication._Text[1: Language = $parameters.P_Language].ConditionApplicationName AS ConditionApplicationName,
  PricingElement.ConditionType AS ConditionType,
  PricingElement.PricingDateTime AS PricingDateTime,
  cast( substring(PricingElement.PricingDateTime, 1, 8 ) as dats ) AS PricingDate,
  PricingElement.ConditionCalculationType AS ConditionCalculationType,
  _ConditionCalculationType._Text[1: Language = $parameters.P_Language].ConditionCalculationTypeName AS ConditionCalculationTypeName,
  PricingElement.ConditionBaseValue AS ConditionBaseValue,
  PricingElement.ConditionRateValue AS ConditionRateValue,
  PricingElement.ConditionCurrency AS ConditionCurrency,
  PricingElement.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  PricingElement.ConditionQuantity AS ConditionQuantity,
  PricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  PricingElement.ConditionCategory AS ConditionCategory,
  _ConditionCategory._Text[1: Language = $parameters.P_Language].ConditionCategoryName AS ConditionCategoryName,
  PricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  PricingElement.ConditionRecord AS ConditionRecord,
  PricingElement.ConditionSequentialNumber AS ConditionSequentialNumber,
  PricingElement.GLAccount AS GLAccount,
  PricingElement.TaxCode AS TaxCode,
  PricingElement.AccrualsGLAccount AS AccrualsGLAccount,
  PricingElement.WithholdingTaxCode AS WithholdingTaxCode,
  PricingElement.ConditionAmount AS ConditionAmount,
  PricingElement.TransactionCurrency AS TransactionCurrency,
  PricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  PricingElement.ConditionClass AS ConditionClass,
  _ConditionClass._Text[1: Language = $parameters.P_Language].ConditionClassName AS ConditionClassName,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  BillingDocument.SalesOrganization AS SalesOrganization,
  BillingDocument.CompanyCode AS CompanyCode
FROM I_PricingElement AS PricingElement
LEFT OUTER JOIN I_BillingDocument AS BillingDocument ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
;

Learn More