C_SetlDocItmCustPrgElm_F3658A

DDL: C_SETLDOCITMCUSTPRGELM_F3658A Type: view_entity CONSUMPTION
88 Fields 1 Data Sources

Settlement Document Object Page Item Cust Pricing Element

C_SetlDocItmCustPrgElm_F3658A is a Consumption CDS View that provides data about "Settlement Document Object Page Item Cust Pricing Element" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocItmCustPrcgElmntTP) and exposes 88 fields with key fields SettlmtDoc, SettlmtDocItem, PricingProcedureStep, PricingProcedureCounter.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocItmCustPrcgElmntTP R_SettlmtDocItmCustPrcgElmntTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Settlement Document Object Page Item Cust Pricing Element view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.query.implementedBy ABAP:CL_WLF_SDOC_F3658A_PRCG_IT_CUS view

Fields (88)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
KEY SettlmtDocItem SettlmtDocItem Item
KEY PricingProcedureStep PricingProcedureStep Step Number
KEY PricingProcedureCounter PricingProcedureCounter Pricing Procedure Counter
ConditionType ConditionType Condition type
ConditionRateAmount ConditionRateAmount Condition Amount
ConditionRateRatio ConditionRateRatio Ratio
ConditionBaseAmount ConditionBaseAmount Condition Basis Amount
ConditionBaseQuantity Quantity
ConditionQuantity ConditionQuantity Pricing Unit
ConditionAmount ConditionAmount Condition Value
IsRelevantForAccrual IsRelevantForAccrual Accruals
ConditionCurrency ConditionCurrency Currency
TransactionCurrency TransactionCurrency Transaction Currency
ConditionQuantityUnit ConditionQuantityUnit Unit of Measure
ConditionRateRatioUnit ConditionRateRatioUnit Unit of Measure
ConditionIsForStatistics ConditionIsForStatistics Statistical
ConditionIsManuallyChanged ConditionIsManuallyChanged Changed Manual.
ConditionInactiveReason ConditionInactiveReason Inactive
int1
virtualUICT_CndPricingUnitHiddenboolean
virtualUICT_ValueIsHiddenboolean
virtualUICT_BaseAmountIsHiddenboolean
virtualUICT_BaseQuantityIsHiddenboolean
virtualUICT_TaxRegionIsEmptyboolean
virtualUICT_ScaleValuesEmptyboolean
virtualUICT_ExpenseSupplierEmptyboolean
virtualUICT_ExpenseCustomerEmptyboolean
ConditionApplication ConditionApplication Application
ConditionClass ConditionClass Condition Class
ConditionCalculationType ConditionCalculationType Calculat.Type
ConditionCategory ConditionCategory Condit.Category
ConditionControl ConditionControl Cond.Control
ConditionOrigin ConditionOrigin Condit.Origin
TaxCode TaxCode Tax Code
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr Denominator
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr Numerator
AccountKeyForGLAccount AccountKeyForGLAccount Account Key
GLAccount GLAccount General Ledger
AcctKeyForAccrualsGLAccount AcctKeyForAccrualsGLAccount Accruals
WithholdingTaxCode WithholdingTaxCode WTax Code
AccrualsGLAccount AccrualsGLAccount Accruals Acc.
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount CondRoundDiff.
FactorForConditionBasisValue FactorForConditionBasisValue Factor for Condition Basis Value
IsGroupCondition IsGroupCondition Group Condition
PeriodFactorForCndnBasisValue PeriodFactorForCndnBasisValue Period Factor for Condition Basis Value
PriceConditionDeterminationDte PriceConditionDeterminationDte Condition Pricing Date
CndnIsRelevantForInvoiceList CndnIsRelevantForInvoiceList Settlement Document List Condition
ConditionIsForConfiguration ConditionIsForConfiguration UsedfVarConfig
StructureCondition StructureCondition Structure Cond.
PricingScaleBasis PricingScaleBasis Scale Basis
PricingScaleType PricingScaleType Scale Type
ConditionAlternativeCurrency ConditionAlternativeCurrency Cndn Currency
PriceDetnExchangeRate PriceDetnExchangeRate Exchange Rate
ConditionScaleBaseAmount ConditionScaleBaseAmount Scale Base Am.
ConditionScaleBaseQuantity ConditionScaleBaseQuantity Scale Base Qu.
ConditionScaleBasisUnit ConditionScaleBasisUnit Scale UoM
ConditionScaleBasisCurrency ConditionScaleBasisCurrency Scale Currency
ExpenseSupplier ExpenseSupplier Expense Supplier
TaxCountry TaxCountry Tax Ctry/Reg.
ExpenseCustomer ExpenseCustomer Expense Customer
ConditionAmountInLocalCrcy ConditionAmountInLocalCrcy Cumulative Condition Value
ConditionApplicationNamelocalized
ConditionCalculationTypeNamelocalized
ConditionCategoryNamelocalized
ConditionClassNamelocalized
ConditionControlNamelocalized
ConditionOriginNamelocalized
ConditionInactiveReasonNamelocalized
PricingScaleBasisNamelocalized
StructureConditionNamelocalized
virtualTaxCodeNamefis_mwskz_name
virtualConditionToBaseQtyDnmntrUnitkmein
virtualConditionToBaseQtyNmrtrUnitmeins
_ConditionApplication _ConditionApplication
_ConditionCalculationType _ConditionCalculationType
_ConditionCategory _ConditionCategory
_ConditionClass _ConditionClass
_ConditionControl _ConditionControl
_ConditionCurrency _ConditionCurrency
_ConditionInactiveReason _ConditionInactiveReason
_ConditionOrigin _ConditionOrigin
_ConditionQuantityUnit _ConditionQuantityUnit
_Currency _Currency
_PricingConditionType _PricingConditionType
_PricingScaleBasis _PricingScaleBasis
_RatioUnitOfMeasure _RatioUnitOfMeasure
_StructureCondition _StructureCondition

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 C_SetlDocItmCustPrgElm_F3658A.
-- 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 C_SetlDocItmCustPrgElm_F3658A AS
SELECT
  SettlmtDoc,
  SettlmtDocItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  ConditionType,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionBaseAmount,
  cast ( ConditionBaseQuantity as wlf_prcg_element_base_quantity preserving type ) AS ConditionBaseQuantity,
  ConditionQuantity,
  ConditionAmount,
  IsRelevantForAccrual,
  ConditionCurrency,
  TransactionCurrency,
  ConditionQuantityUnit,
  ConditionRateRatioUnit,
  ConditionIsForStatistics,
  ConditionIsManuallyChanged,
  ConditionInactiveReason,
  virtual UICT_ConditionTypeCriticality : abap.int1 AS int1,
  virtual UICT_CndPricingUnitHidden : boolean AS virtualUICT_CndPricingUnitHiddenboolean,
  virtual UICT_ValueIsHidden : boolean AS virtualUICT_ValueIsHiddenboolean,
  virtual UICT_BaseAmountIsHidden : boolean AS virtualUICT_BaseAmountIsHiddenboolean,
  virtual UICT_BaseQuantityIsHidden : boolean AS virtualUICT_BaseQuantityIsHiddenboolean,
  virtual UICT_TaxRegionIsEmpty : boolean AS virtualUICT_TaxRegionIsEmptyboolean,
  virtual UICT_ScaleValuesEmpty : boolean AS virtualUICT_ScaleValuesEmptyboolean,
  virtual UICT_ExpenseSupplierEmpty : boolean AS virtualUICT_ExpenseSupplierEmptyboolean,
  virtual UICT_ExpenseCustomerEmpty : boolean AS virtualUICT_ExpenseCustomerEmptyboolean,
  ConditionApplication,
  ConditionClass,
  ConditionCalculationType,
  ConditionCategory,
  ConditionControl,
  ConditionOrigin,
  TaxCode,
  ConditionToBaseQtyDnmntr,
  ConditionToBaseQtyNmrtr,
  AccountKeyForGLAccount,
  GLAccount,
  AcctKeyForAccrualsGLAccount,
  WithholdingTaxCode,
  AccrualsGLAccount,
  CndnRoundingOffDiffAmount,
  FactorForConditionBasisValue,
  IsGroupCondition,
  PeriodFactorForCndnBasisValue,
  PriceConditionDeterminationDte,
  CndnIsRelevantForInvoiceList,
  ConditionIsForConfiguration,
  StructureCondition,
  PricingScaleBasis,
  PricingScaleType,
  ConditionAlternativeCurrency,
  PriceDetnExchangeRate,
  ConditionScaleBaseAmount,
  ConditionScaleBaseQuantity,
  ConditionScaleBasisUnit,
  ConditionScaleBasisCurrency,
  ExpenseSupplier,
  TaxCountry,
  ExpenseCustomer,
  ConditionAmountInLocalCrcy,
  _ConditionApplication._Text.ConditionApplicationName : localized AS ConditionApplicationNamelocalized,
  _ConditionCalculationType._Text.ConditionCalculationTypeName : localized AS ConditionCalculationTypeNamelocalized,
  _ConditionCategory._Text.ConditionCategoryName : localized AS ConditionCategoryNamelocalized,
  _ConditionClass._Text.ConditionClassName : localized AS ConditionClassNamelocalized,
  _ConditionControl._Text.ConditionControlName : localized AS ConditionControlNamelocalized,
  _ConditionOrigin._Text.ConditionOriginName : localized AS ConditionOriginNamelocalized,
  _ConditionInactiveReason._Text.ConditionInactiveReasonName : localized AS ConditionInactiveReasonNamelocalized,
  _PricingScaleBasis._Text.PricingScaleBasisName : localized AS PricingScaleBasisNamelocalized,
  _StructureCondition._Text.StructureConditionName : localized AS StructureConditionNamelocalized,
  virtual TaxCodeName : fis_mwskz_name AS virtualTaxCodeNamefis_mwskz_name,
  virtual ConditionToBaseQtyDnmntrUnit : kmein AS virtualConditionToBaseQtyDnmntrUnitkmein,
  virtual ConditionToBaseQtyNmrtrUnit : meins AS virtualConditionToBaseQtyNmrtrUnitmeins
FROM R_SettlmtDocItmCustPrcgElmntTP
;

Learn More