R_SESPricingElementTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_SESPricingElement | I_SESPricingElement | from |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA