A_CrdtMemoReqItmPrcgElmntSimln

DDL: A_CRDTMEMOREQITMPRCGELMNTSIMLN Type: view_entity COMPOSITE
56 Fields 2 Data Sources 1 Associations

Item Pricing Element Simulation

A_CrdtMemoReqItmPrcgElmntSimln is a Composite CDS View that provides data about "Item Pricing Element Simulation" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, I_PricingElement) and exposes 56 fields with key fields CreditMemoRequest, CreditMemoRequestItem, PricingProcedureStep, PricingProcedureCounter. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic CreditMemoRequest inner
I_PricingElement ItemPricingElement from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_CreditMemoRequestSimulation _CreditMemoRequest $projection.CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest

Annotations (8)

NameValueLevelField
EndUserText.label Item Pricing Element Simulation view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.ignorePropagatedAnnotations true view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY CreditMemoRequest I_SalesDocumentBasic SalesDocument SD Document
KEY CreditMemoRequestItem I_PricingElement PricingDocumentItem Item
KEY PricingProcedureStep I_PricingElement PricingProcedureStep Step Number
KEY PricingProcedureCounter I_PricingElement PricingProcedureCounter Pricing Procedure Counter
ConditionApplication I_PricingElement ConditionApplication Application
ConditionType I_PricingElement ConditionType Condition type
PriceConditionDeterminationDte I_PricingElement PriceConditionDeterminationDte Condition Pricing Date
ConditionCalculationType I_PricingElement ConditionCalculationType Calculat.Type
ConditionBaseValue I_PricingElement ConditionBaseValue Cond.Basis
ConditionRateValue I_PricingElement ConditionRateValue Condition Rate Value
ConditionCurrency I_PricingElement ConditionCurrency Currency
ConditionQuantity I_PricingElement ConditionQuantity Pricing Unit
ConditionQuantityUnit I_PricingElement ConditionQuantityUnit Unit of Measure
ConditionQuantitySAPUnit
ConditionQuantityISOUnit
ConditionToBaseQtyNmrtr I_PricingElement ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr I_PricingElement ConditionToBaseQtyDnmntr Denominator
ConditionCategory I_PricingElement ConditionCategory Condit.Category
ConditionIsForStatistics I_PricingElement ConditionIsForStatistics Statistical
PricingScaleType I_PricingElement PricingScaleType Scale Type
IsRelevantForAccrual I_PricingElement IsRelevantForAccrual Accruals
CndnIsRelevantForInvoiceList I_PricingElement CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionOrigin I_PricingElement ConditionOrigin Condit.Origin
IsGroupCondition I_PricingElement IsGroupCondition Group Condition
AccessNumberOfAccessSequence I_PricingElement AccessNumberOfAccessSequence Access
ConditionRecord I_PricingElement ConditionRecord Cond.Record No.
ConditionSequentialNumber I_PricingElement ConditionSequentialNumber SequNo of Cond.
TaxCode I_PricingElement TaxCode Tax Code
WithholdingTaxCode I_PricingElement WithholdingTaxCode WTax Code
CndnRoundingOffDiffAmount I_PricingElement CndnRoundingOffDiffAmount CondRoundDiff.
ConditionAmount I_PricingElement ConditionAmount Condition Value
TransactionCurrency I_PricingElement TransactionCurrency Transaction Currency
ConditionControl I_PricingElement ConditionControl Cond.Control
ConditionInactiveReason I_PricingElement ConditionInactiveReason Inactive
ConditionClass I_PricingElement ConditionClass Condition Class
PrcgProcedureCounterForHeader I_PricingElement PrcgProcedureCounterForHeader Pricing Procedure Counter for Header
FactorForConditionBasisValue I_PricingElement FactorForConditionBasisValue Factor for Condition Basis Value
StructureCondition I_PricingElement StructureCondition Structure Cond.
PeriodFactorForCndnBasisValue I_PricingElement PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
PricingScaleBasis I_PricingElement PricingScaleBasis Scale Basis
ConditionScaleBasisValue I_PricingElement ConditionScaleBasisValue Scale Base Val.
ConditionScaleBasisUnit I_PricingElement ConditionScaleBasisUnit Scale UoM
ConditionScaleBasisCurrency I_PricingElement ConditionScaleBasisCurrency Scale Currency
ConditionAlternativeCurrency I_PricingElement ConditionAlternativeCurrency Cndn Currency
ConditionAmountInLocalCrcy I_PricingElement ConditionAmountInLocalCrcy Cumulative Condition Value
CndnIsRelevantForIntcoBilling I_PricingElement CndnIsRelevantForIntcoBilling IntcoBillCond
ConditionIsManuallyChanged I_PricingElement ConditionIsManuallyChanged Changed Manual.
CumulatedConditionBasisValue I_PricingElement CumulatedConditionBasisValue Cond.Basis
ConditionIsForConfiguration I_PricingElement ConditionIsForConfiguration UsedfVarConfig
VariantCondition I_PricingElement VariantCondition Variant Key
CreditMemoRequestType I_SalesDocumentBasic SalesDocumentType Sales Doc. Type
OrganizationDivision I_SalesDocumentBasic OrganizationDivision Org. Division
SalesOrganization I_SalesDocumentBasic SalesOrganization Sales Organization
DistributionChannel I_SalesDocumentBasic DistributionChannel RefDistCh-Cust/Mat.
_CreditMemoRequest _CreditMemoRequest
_CreditMemoRequestItem _CreditMemoRequestItem

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 A_CrdtMemoReqItmPrcgElmntSimln.
-- 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.

CREATE VIEW A_CrdtMemoReqItmPrcgElmntSimln AS
SELECT
  CreditMemoRequest.SalesDocument AS CreditMemoRequest,
  ItemPricingElement.PricingDocumentItem AS CreditMemoRequestItem,
  ItemPricingElement.PricingProcedureStep AS PricingProcedureStep,
  ItemPricingElement.PricingProcedureCounter AS PricingProcedureCounter,
  ItemPricingElement.ConditionApplication AS ConditionApplication,
  ItemPricingElement.ConditionType AS ConditionType,
  ItemPricingElement.PriceConditionDeterminationDte AS PriceConditionDeterminationDte,
  ItemPricingElement.ConditionCalculationType AS ConditionCalculationType,
  ItemPricingElement.ConditionBaseValue AS ConditionBaseValue,
  ItemPricingElement.ConditionRateValue AS ConditionRateValue,
  ItemPricingElement.ConditionCurrency AS ConditionCurrency,
  ItemPricingElement.ConditionQuantity AS ConditionQuantity,
  ItemPricingElement.ConditionQuantityUnit AS ConditionQuantityUnit,
  cast(ItemPricingElement._ConditionQuantityUnit.UnitOfMeasureSAPCode as sd_cndn_qty_sapunit preserving type) AS ConditionQuantitySAPUnit,
  cast(ItemPricingElement._ConditionQuantityUnit.UnitOfMeasureISOCode as sd_cndn_qty_isounit preserving type) AS ConditionQuantityISOUnit,
  ItemPricingElement.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  ItemPricingElement.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  ItemPricingElement.ConditionCategory AS ConditionCategory,
  ItemPricingElement.ConditionIsForStatistics AS ConditionIsForStatistics,
  ItemPricingElement.PricingScaleType AS PricingScaleType,
  ItemPricingElement.IsRelevantForAccrual AS IsRelevantForAccrual,
  ItemPricingElement.CndnIsRelevantForInvoiceList AS CndnIsRelevantForInvoiceList,
  ItemPricingElement.ConditionOrigin AS ConditionOrigin,
  ItemPricingElement.IsGroupCondition AS IsGroupCondition,
  ItemPricingElement.AccessNumberOfAccessSequence AS AccessNumberOfAccessSequence,
  ItemPricingElement.ConditionRecord AS ConditionRecord,
  ItemPricingElement.ConditionSequentialNumber AS ConditionSequentialNumber,
  ItemPricingElement.TaxCode AS TaxCode,
  ItemPricingElement.WithholdingTaxCode AS WithholdingTaxCode,
  ItemPricingElement.CndnRoundingOffDiffAmount AS CndnRoundingOffDiffAmount,
  ItemPricingElement.ConditionAmount AS ConditionAmount,
  ItemPricingElement.TransactionCurrency AS TransactionCurrency,
  ItemPricingElement.ConditionControl AS ConditionControl,
  ItemPricingElement.ConditionInactiveReason AS ConditionInactiveReason,
  ItemPricingElement.ConditionClass AS ConditionClass,
  ItemPricingElement.PrcgProcedureCounterForHeader AS PrcgProcedureCounterForHeader,
  ItemPricingElement.FactorForConditionBasisValue AS FactorForConditionBasisValue,
  ItemPricingElement.StructureCondition AS StructureCondition,
  ItemPricingElement.PeriodFactorForCndnBasisValue AS PeriodFactorForCndnBasisValue,
  ItemPricingElement.PricingScaleBasis AS PricingScaleBasis,
  ItemPricingElement.ConditionScaleBasisValue AS ConditionScaleBasisValue,
  ItemPricingElement.ConditionScaleBasisUnit AS ConditionScaleBasisUnit,
  ItemPricingElement.ConditionScaleBasisCurrency AS ConditionScaleBasisCurrency,
  ItemPricingElement.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  ItemPricingElement.ConditionAmountInLocalCrcy AS ConditionAmountInLocalCrcy,
  ItemPricingElement.CndnIsRelevantForIntcoBilling AS CndnIsRelevantForIntcoBilling,
  ItemPricingElement.ConditionIsManuallyChanged AS ConditionIsManuallyChanged,
  ItemPricingElement.CumulatedConditionBasisValue AS CumulatedConditionBasisValue,
  ItemPricingElement.ConditionIsForConfiguration AS ConditionIsForConfiguration,
  ItemPricingElement.VariantCondition AS VariantCondition,
  CreditMemoRequest.SalesDocumentType AS CreditMemoRequestType,
  CreditMemoRequest.OrganizationDivision AS OrganizationDivision,
  CreditMemoRequest.SalesOrganization AS SalesOrganization,
  CreditMemoRequest.DistributionChannel AS DistributionChannel
FROM I_PricingElement AS ItemPricingElement
INNER JOIN I_SalesDocumentBasic AS CreditMemoRequest ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_CreditMemoRequestSimulation AS _CreditMemoRequest ON CreditMemoRequest = _CreditMemoRequest.CreditMemoRequest  -- association [1..1]
;

Learn More