R_SESPricingElementTP

DDL: R_SESPRICINGELEMENTTP Type: view_entity TRANSACTIONAL

SES Pricing Element

R_SESPricingElementTP is a Transactional CDS View that provides data about "SES Pricing Element" in SAP S/4HANA. It reads from 1 data source (I_SESPricingElement) and exposes 79 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem, PricingDocument, PricingDocumentItem, PricingProcedureStep.

Data Sources (1)

SourceAliasJoin Type
I_SESPricingElement I_SESPricingElement from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label SES Pricing Element view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (79)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem
KEY PricingDocument PricingDocument
KEY PricingDocumentItem PricingDocumentItem
KEY PricingProcedureStep PricingProcedureStep
KEY PricingProcedureCounter PricingProcedureCounter
ConditionApplication ConditionApplication
ConditionType ConditionType
PriceConditionDeterminationDte PriceConditionDeterminationDte
ConditionCalculationType ConditionCalculationType
ConditionBaseValue ConditionBaseValue
ConditionRateValue ConditionRateValue
ConditionCurrency ConditionCurrency
ConditionQuantity ConditionQuantity
ConditionQuantityUnit ConditionQuantityUnit
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr
ConditionCategory ConditionCategory
ConditionIsForStatistics ConditionIsForStatistics
PricingScaleType PricingScaleType
IsRelevantForAccrual IsRelevantForAccrual
CndnIsRelevantForInvoiceList CndnIsRelevantForInvoiceList
ConditionOrigin ConditionOrigin
IsGroupCondition IsGroupCondition
AccessNumberOfAccessSequence AccessNumberOfAccessSequence
ConditionRecord ConditionRecord
ConditionSequentialNumber ConditionSequentialNumber
AccountKeyForGLAccount AccountKeyForGLAccount
GLAccount GLAccount
TaxCode TaxCode
AcctKeyForAccrualsGLAccount AcctKeyForAccrualsGLAccount
AccrualsGLAccount AccrualsGLAccount
WithholdingTaxCode WithholdingTaxCode
FreightSupplier FreightSupplier
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount
ConditionAmount ConditionAmount
TransactionCurrency TransactionCurrency
ConditionControl ConditionControl
ConditionInactiveReason ConditionInactiveReason
ConditionClass ConditionClass
PrcgProcedureCounterForHeader PrcgProcedureCounterForHeader
FactorForConditionBasisValue FactorForConditionBasisValue
StructureCondition StructureCondition
PeriodFactorForCndnBasisValue PeriodFactorForCndnBasisValue
PricingScaleBasis PricingScaleBasis
ConditionScaleBasisValue ConditionScaleBasisValue
ConditionScaleBasisUnit ConditionScaleBasisUnit
ConditionScaleBasisCurrency ConditionScaleBasisCurrency
ConditionAlternativeCurrency ConditionAlternativeCurrency
ConditionAmountInLocalCrcy ConditionAmountInLocalCrcy
CndnIsRelevantForIntcoBilling CndnIsRelevantForIntcoBilling
ConditionIsManuallyChanged ConditionIsManuallyChanged
BillingPriceSource BillingPriceSource
TaxJurisdictionLevel TaxJurisdictionLevel
ConditionByteSequence ConditionByteSequence
CndnIsRelevantForLimitValue CndnIsRelevantForLimitValue
ConditionBasisLimitExceeded ConditionBasisLimitExceeded
ConditionAmountLimitExceeded ConditionAmountLimitExceeded
CumulatedConditionBasisValue CumulatedConditionBasisValue
CustomerRebateRecipient CustomerRebateRecipient
ConditionIsForConfiguration ConditionIsForConfiguration
VariantCondition VariantCondition
ConditionAcctAssgmtRelevance ConditionAcctAssgmtRelevance
ConditionMatrixMaintRelevance ConditionMatrixMaintRelevance
ConfigblParametersAndFormulas ConfigblParametersAndFormulas
ConditionAdjustedQuantity ConditionAdjustedQuantity
ConditionTypeName ConditionTypeName
ConditionBaseValueIntlUnit ConditionBaseValueIntlUnit
ConditionBaseValueUnit ConditionBaseValueUnit
ConditionRateValueIntlUnit ConditionRateValueIntlUnit
ConditionRateValueUnit ConditionRateValueUnit
TaxCodeName TaxCodeName
ConditionIsDeletable ConditionIsDeletable
PricingProcedure PricingProcedure
SuperordinateDocument SuperordinateDocument
SuperordinateDocumentItem SuperordinateDocumentItem
LastChangeDateTime _SESHeader LastChangeDateTime
_SESHeader _SESHeader
_ServiceEntrySheetItem _ServiceEntrySheetItem
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'SES Pricing Element'
@AccessControl.personalData.blocking: #REQUIRED

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.semanticKey:  ['ServiceEntrySheet', 'ServiceEntrySheetItem', 'PricingDocument','PricingDocumentItem','PricingProcedureStep', 'PricingProcedureCounter']

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}

@Metadata.ignorePropagatedAnnotations: true
define view entity R_SESPricingElementTP
  as select from I_SESPricingElement
  association to parent R_ServiceEntrySheetItemTP as _ServiceEntrySheetItem on  _ServiceEntrySheetItem.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem
                                                                            and _ServiceEntrySheetItem.ServiceEntrySheet     = $projection.ServiceEntrySheet

  association to R_ServiceEntrySheetTP            as _SESHeader             on  _SESHeader.ServiceEntrySheet = $projection.ServiceEntrySheet
{
      @ObjectModel.foreignKey.association: '_SESHeader'
  key ServiceEntrySheet,
      @ObjectModel.foreignKey.association: '_ServiceEntrySheetItem'
  key ServiceEntrySheetItem,
  key PricingDocument,
  key PricingDocumentItem,
  key PricingProcedureStep,
  key PricingProcedureCounter,
      ConditionApplication,
      ConditionType,
      PriceConditionDeterminationDte,
      ConditionCalculationType,
      ConditionBaseValue,
      ConditionRateValue,
      ConditionCurrency,
      @Semantics.quantity.unitOfMeasure: 'conditionquantityunit'
      ConditionQuantity,
      ConditionQuantityUnit,
      ConditionToBaseQtyNmrtr,
      ConditionToBaseQtyDnmntr,
      ConditionCategory,
      ConditionIsForStatistics,
      PricingScaleType,
      IsRelevantForAccrual,
      @Semantics.booleanIndicator
      CndnIsRelevantForInvoiceList,
      ConditionOrigin,
      @Semantics.booleanIndicator
      IsGroupCondition,
      AccessNumberOfAccessSequence,
      ConditionRecord,
      ConditionSequentialNumber,
      AccountKeyForGLAccount,
      GLAccount,
      TaxCode,
      AcctKeyForAccrualsGLAccount,
      AccrualsGLAccount,
      WithholdingTaxCode,
      FreightSupplier,
      @Semantics.amount.currencyCode: 'ConditionCurrency'
      CndnRoundingOffDiffAmount,
      @Semantics.amount.currencyCode: 'ConditionCurrency'
      ConditionAmount,
      TransactionCurrency,
      ConditionControl,
      ConditionInactiveReason,
      ConditionClass,
      PrcgProcedureCounterForHeader,
      FactorForConditionBasisValue,
      StructureCondition,
      PeriodFactorForCndnBasisValue,
      PricingScaleBasis,
      ConditionScaleBasisValue,
      ConditionScaleBasisUnit,
      ConditionScaleBasisCurrency,
      ConditionAlternativeCurrency,
      @Semantics.amount.currencyCode: 'ConditionCurrency'
      ConditionAmountInLocalCrcy,
      CndnIsRelevantForIntcoBilling,
      ConditionIsManuallyChanged,
      BillingPriceSource,
      TaxJurisdictionLevel,
      ConditionByteSequence,
      CndnIsRelevantForLimitValue,
      ConditionBasisLimitExceeded,
      ConditionAmountLimitExceeded,
      CumulatedConditionBasisValue,
      CustomerRebateRecipient,
      ConditionIsForConfiguration,
      VariantCondition,
      ConditionAcctAssgmtRelevance,
      ConditionMatrixMaintRelevance,
      ConfigblParametersAndFormulas,
      @Semantics.quantity.unitOfMeasure: 'conditionquantityunit'
      ConditionAdjustedQuantity,
      ConditionTypeName,
      ConditionBaseValueIntlUnit,
      ConditionBaseValueUnit,
      ConditionRateValueIntlUnit,
      ConditionRateValueUnit,
      TaxCodeName,
      @Semantics.booleanIndicator
      ConditionIsDeletable,
      PricingProcedure,
      SuperordinateDocument,
      SuperordinateDocumentItem,
      @Semantics.systemDateTime.lastChangedAt: true
      _SESHeader.LastChangeDateTime as LastChangeDateTime,
      /* Associations */
      _SESHeader,
      _ServiceEntrySheetItem


}
where
      _SESHeader.ServiceEntrySheet                 is not null
  and _ServiceEntrySheetItem.ServiceEntrySheetItem is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SESPRICINGELEMENT",
"R_SERVICEENTRYSHEETITEMTP",
"R_SERVICEENTRYSHEETTP"
],
"ASSOCIATED":
[
"R_SERVICEENTRYSHEETITEMTP",
"R_SERVICEENTRYSHEETTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/