I_SESPricingElementTP
Service Entry Sheet Pricing Element - TP
I_SESPricingElementTP is a Transactional CDS View that provides data about "Service Entry Sheet Pricing Element - TP" in SAP S/4HANA. It reads from 1 data source (I_SESPricingElement) and exposes 105 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem, PricingDocument, PricingDocumentItem, PricingProcedureStep. It has 2 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SESPricingElement | Document | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_ServiceEntrySheetTP | _ServiceEntrySheet | _ServiceEntrySheet.ServiceEntrySheet = $projection.ServiceEntrySheet |
| [1..1] | I_ServiceEntrySheetItemTP | _ServiceEntrySheetItem | _ServiceEntrySheetItem.ServiceEntrySheet = $projection.ServiceEntrySheet and _ServiceEntrySheetItem.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.viewType | #TRANSACTIONAL | view | |
| AbapCatalog.sqlViewName | ISESPRCGELMNTTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #PRIVILEGED_ONLY | view | |
| EndUserText.label | Service Entry Sheet Pricing Element - TP | view | |
| AbapCatalog.preserveKey | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.writeDraftPersistence | SESPRCGELMNTTP_D | view | |
| ObjectModel.writeActivePersistence | ISESPRCGELMNTTP | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.sapObjectNodeType.name | ServiceEntrySheet | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view |
Fields (105)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ServiceEntrySheet | I_SESPricingElement | ServiceEntrySheet | |
| KEY | ServiceEntrySheetItem | I_SESPricingElement | ServiceEntrySheetItem | |
| KEY | PricingDocument | I_SESPricingElement | PricingDocument | |
| KEY | PricingDocumentItem | I_SESPricingElement | PricingDocumentItem | |
| KEY | PricingProcedureStep | I_SESPricingElement | PricingProcedureStep | |
| KEY | PricingProcedureCounter | I_SESPricingElement | PricingProcedureCounter | |
| ConditionApplication | I_SESPricingElement | ConditionApplication | ||
| ConditionType | I_SESPricingElement | ConditionType | ||
| PriceConditionDeterminationDte | I_SESPricingElement | PriceConditionDeterminationDte | ||
| ConditionCalculationType | I_SESPricingElement | ConditionCalculationType | ||
| ConditionBaseValue | I_SESPricingElement | ConditionBaseValue | ||
| ConditionRateValue | I_SESPricingElement | ConditionRateValue | ||
| ConditionCurrency | I_SESPricingElement | ConditionCurrency | ||
| ConditionQuantity | I_SESPricingElement | ConditionQuantity | ||
| ConditionQuantityUnit | I_SESPricingElement | ConditionQuantityUnit | ||
| ConditionToBaseQtyNmrtr | I_SESPricingElement | ConditionToBaseQtyNmrtr | ||
| ConditionToBaseQtyDnmntr | I_SESPricingElement | ConditionToBaseQtyDnmntr | ||
| ConditionCategory | I_SESPricingElement | ConditionCategory | ||
| ConditionIsForStatistics | I_SESPricingElement | ConditionIsForStatistics | ||
| PricingScaleType | I_SESPricingElement | PricingScaleType | ||
| IsRelevantForAccrual | I_SESPricingElement | IsRelevantForAccrual | ||
| CndnIsRelevantForInvoiceList | I_SESPricingElement | CndnIsRelevantForInvoiceList | ||
| ConditionOrigin | I_SESPricingElement | ConditionOrigin | ||
| IsGroupCondition | I_SESPricingElement | IsGroupCondition | ||
| AccessNumberOfAccessSequence | I_SESPricingElement | AccessNumberOfAccessSequence | ||
| ConditionRecord | I_SESPricingElement | ConditionRecord | ||
| ConditionSequentialNumber | I_SESPricingElement | ConditionSequentialNumber | ||
| AccountKeyForGLAccount | I_SESPricingElement | AccountKeyForGLAccount | ||
| GLAccount | I_SESPricingElement | GLAccount | ||
| TaxCode | I_SESPricingElement | TaxCode | ||
| AcctKeyForAccrualsGLAccount | I_SESPricingElement | AcctKeyForAccrualsGLAccount | ||
| AccrualsGLAccount | I_SESPricingElement | AccrualsGLAccount | ||
| WithholdingTaxCode | I_SESPricingElement | WithholdingTaxCode | ||
| FreightSupplier | I_SESPricingElement | FreightSupplier | ||
| CndnRoundingOffDiffAmount | I_SESPricingElement | CndnRoundingOffDiffAmount | ||
| ConditionAmount | I_SESPricingElement | ConditionAmount | ||
| TransactionCurrency | I_SESPricingElement | TransactionCurrency | ||
| ConditionControl | I_SESPricingElement | ConditionControl | ||
| ConditionInactiveReason | I_SESPricingElement | ConditionInactiveReason | ||
| ConditionInactiveReasonName | ||||
| ConditionClass | I_SESPricingElement | ConditionClass | ||
| PrcgProcedureCounterForHeader | I_SESPricingElement | PrcgProcedureCounterForHeader | ||
| FactorForConditionBasisValue | I_SESPricingElement | FactorForConditionBasisValue | ||
| StructureCondition | I_SESPricingElement | StructureCondition | ||
| PeriodFactorForCndnBasisValue | I_SESPricingElement | PeriodFactorForCndnBasisValue | ||
| PricingScaleBasis | I_SESPricingElement | PricingScaleBasis | ||
| ConditionScaleBasisValue | I_SESPricingElement | ConditionScaleBasisValue | ||
| ConditionScaleBasisUnit | I_SESPricingElement | ConditionScaleBasisUnit | ||
| ConditionScaleBasisCurrency | I_SESPricingElement | ConditionScaleBasisCurrency | ||
| ConditionAlternativeCurrency | I_SESPricingElement | ConditionAlternativeCurrency | ||
| ConditionAmountInLocalCrcy | I_SESPricingElement | ConditionAmountInLocalCrcy | ||
| CndnIsRelevantForIntcoBilling | I_SESPricingElement | CndnIsRelevantForIntcoBilling | ||
| ConditionIsManuallyChanged | I_SESPricingElement | ConditionIsManuallyChanged | ||
| BillingPriceSource | I_SESPricingElement | BillingPriceSource | ||
| TaxJurisdictionLevel | I_SESPricingElement | TaxJurisdictionLevel | ||
| ConditionByteSequence | I_SESPricingElement | ConditionByteSequence | ||
| CndnIsRelevantForLimitValue | I_SESPricingElement | CndnIsRelevantForLimitValue | ||
| ConditionBasisLimitExceeded | I_SESPricingElement | ConditionBasisLimitExceeded | ||
| ConditionAmountLimitExceeded | I_SESPricingElement | ConditionAmountLimitExceeded | ||
| CumulatedConditionBasisValue | I_SESPricingElement | CumulatedConditionBasisValue | ||
| CustomerRebateRecipient | I_SESPricingElement | CustomerRebateRecipient | ||
| ConditionIsForConfiguration | I_SESPricingElement | ConditionIsForConfiguration | ||
| VariantCondition | I_SESPricingElement | VariantCondition | ||
| ConditionAcctAssgmtRelevance | I_SESPricingElement | ConditionAcctAssgmtRelevance | ||
| ConditionMatrixMaintRelevance | I_SESPricingElement | ConditionMatrixMaintRelevance | ||
| ConfigblParametersAndFormulas | I_SESPricingElement | ConfigblParametersAndFormulas | ||
| ConditionAdjustedQuantity | I_SESPricingElement | ConditionAdjustedQuantity | ||
| ConditionTypeName | I_SESPricingElement | ConditionTypeName | ||
| ConditionBaseValueIntlUnit | I_SESPricingElement | ConditionBaseValueIntlUnit | ||
| ConditionBaseValueUnit | I_SESPricingElement | ConditionBaseValueUnit | ||
| ConditionRateValueIntlUnit | I_SESPricingElement | ConditionRateValueIntlUnit | ||
| TaxCodeName | I_SESPricingElement | TaxCodeName | ||
| ConditionIsDeletable | I_SESPricingElement | ConditionIsDeletable | ||
| PricingProcedure | I_SESPricingElement | PricingProcedure | ||
| SuperordinateDocument | I_SESPricingElement | SuperordinateDocument | ||
| SuperordinateDocumentItem | I_SESPricingElement | SuperordinateDocumentItem | ||
| ConditionRateValueUnit | I_SESPricingElement | ConditionRateValueUnit | ||
| OrderQuantity | I_SESPricingElement | OrderQuantity | ||
| PurchaseOrderQuantityUnit | I_SESPricingElement | PurchaseOrderQuantityUnit | ||
| PurgDocConditionRateValue | I_SESPricingElement | PurgDocConditionRateValue | ||
| PurgDocConditionAmount | I_SESPricingElement | PurgDocConditionAmount | ||
| PurgDocConditionCurrency | I_SESPricingElement | PurgDocConditionCurrency | ||
| _BillingPriceSource | I_SESPricingElement | _BillingPriceSource | ||
| _ConditionAcctAssgmtRelevance | I_SESPricingElement | _ConditionAcctAssgmtRelevance | ||
| _ConditionAlternativeCurrency | I_SESPricingElement | _ConditionAlternativeCurrency | ||
| _ConditionAmountLimitExceeded | I_SESPricingElement | _ConditionAmountLimitExceeded | ||
| _ConditionApplication | I_SESPricingElement | _ConditionApplication | ||
| _ConditionBasisLimitExceeded | I_SESPricingElement | _ConditionBasisLimitExceeded | ||
| _ConditionCalculationType | I_SESPricingElement | _ConditionCalculationType | ||
| _ConditionCategory | I_SESPricingElement | _ConditionCategory | ||
| _ConditionClass | I_SESPricingElement | _ConditionClass | ||
| _ConditionControl | I_SESPricingElement | _ConditionControl | ||
| _ConditionCurrency | I_SESPricingElement | _ConditionCurrency | ||
| _ConditionInactiveReason | I_SESPricingElement | _ConditionInactiveReason | ||
| _ConditionOrigin | I_SESPricingElement | _ConditionOrigin | ||
| _Customer | I_SESPricingElement | _Customer | ||
| _PricingScaleBasis | I_SESPricingElement | _PricingScaleBasis | ||
| _ConditionQuantityUnit | I_SESPricingElement | _ConditionQuantityUnit | ||
| _ScaleCurrency | I_SESPricingElement | _ScaleCurrency | ||
| _ScaleUnitOfMeasure | I_SESPricingElement | _ScaleUnitOfMeasure | ||
| _StructureCondition | I_SESPricingElement | _StructureCondition | ||
| _Supplier | I_SESPricingElement | _Supplier | ||
| _VariantCondition | I_SESPricingElement | _VariantCondition | ||
| _ServiceEntrySheet | _ServiceEntrySheet | |||
| _ServiceEntrySheetItem | _ServiceEntrySheetItem |
@VDM.viewType: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'ISESPRCGELMNTTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Service Entry Sheet Pricing Element - TP'
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel: {
semanticKey: ['ServiceEntrySheet', 'ServiceEntrySheetItem', 'PricingDocument', 'PricingDocumentItem', 'PricingProcedureStep', 'PricingProcedureCounter'],
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
writeDraftPersistence: 'SESPRCGELMNTTP_D',
writeActivePersistence: 'ISESPRCGELMNTTP'
}
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.sapObjectNodeType.name: 'ServiceEntrySheet'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_SESPricingElementTP
as select from I_SESPricingElement as Document
association [1..1] to I_ServiceEntrySheetTP as _ServiceEntrySheet on _ServiceEntrySheet.ServiceEntrySheet = $projection.ServiceEntrySheet
association [1..1] to I_ServiceEntrySheetItemTP as _ServiceEntrySheetItem on _ServiceEntrySheetItem.ServiceEntrySheet = $projection.ServiceEntrySheet
and _ServiceEntrySheetItem.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem
{
key Document.ServiceEntrySheet,
key Document.ServiceEntrySheetItem,
key Document.PricingDocument,
key Document.PricingDocumentItem,
key Document.PricingProcedureStep,
key Document.PricingProcedureCounter,
Document.ConditionApplication,
Document.ConditionType,
@Semantics.dateTime: true
//Document.PricingDateTime,
Document.PriceConditionDeterminationDte,
Document.ConditionCalculationType,
Document.ConditionBaseValue,
Document.ConditionRateValue,
Document.ConditionCurrency,
// Document.PriceDetnExchangeRate,
Document.ConditionQuantity,
Document.ConditionQuantityUnit,
Document.ConditionToBaseQtyNmrtr,
Document.ConditionToBaseQtyDnmntr,
Document.ConditionCategory,
Document.ConditionIsForStatistics,
Document.PricingScaleType,
Document.IsRelevantForAccrual,
Document.CndnIsRelevantForInvoiceList,
Document.ConditionOrigin,
Document.IsGroupCondition,
Document.AccessNumberOfAccessSequence,
Document.ConditionRecord,
Document.ConditionSequentialNumber,
Document.AccountKeyForGLAccount,
Document.GLAccount,
Document.TaxCode,
Document.AcctKeyForAccrualsGLAccount,
Document.AccrualsGLAccount,
Document.WithholdingTaxCode,
Document.FreightSupplier,
Document.CndnRoundingOffDiffAmount,
Document.ConditionAmount,
Document.TransactionCurrency,
Document.ConditionControl,
Document.ConditionInactiveReason,
_ConditionInactiveReason._Text[ 1: Language = $session.system_language ].ConditionInactiveReasonName,
Document.ConditionClass,
Document.PrcgProcedureCounterForHeader,
Document.FactorForConditionBasisValue,
Document.StructureCondition,
Document.PeriodFactorForCndnBasisValue,
Document.PricingScaleBasis,
Document.ConditionScaleBasisValue,
Document.ConditionScaleBasisUnit,
Document.ConditionScaleBasisCurrency,
Document.ConditionAlternativeCurrency,
Document.ConditionAmountInLocalCrcy,
Document.CndnIsRelevantForIntcoBilling,
Document.ConditionIsManuallyChanged,
Document.BillingPriceSource,
Document.TaxJurisdictionLevel,
Document.ConditionByteSequence,
Document.CndnIsRelevantForLimitValue,
Document.ConditionBasisLimitExceeded,
Document.ConditionAmountLimitExceeded,
Document.CumulatedConditionBasisValue,
Document.CustomerRebateRecipient,
Document.ConditionIsForConfiguration,
Document.VariantCondition,
Document.ConditionAcctAssgmtRelevance,
Document.ConditionMatrixMaintRelevance,
Document.ConfigblParametersAndFormulas,
Document.ConditionAdjustedQuantity,
Document.ConditionTypeName,
Document.ConditionBaseValueIntlUnit,
Document.ConditionBaseValueUnit,
Document.ConditionRateValueIntlUnit,
Document.TaxCodeName,
Document.ConditionIsDeletable,
Document.PricingProcedure,
Document.SuperordinateDocument,
Document.SuperordinateDocumentItem,
Document.ConditionRateValueUnit,
Document.OrderQuantity,
Document.PurchaseOrderQuantityUnit,
Document.PurgDocConditionRateValue,
Document.PurgDocConditionAmount,
Document.PurgDocConditionCurrency,
Document._BillingPriceSource,
Document._ConditionAcctAssgmtRelevance,
Document._ConditionAlternativeCurrency,
Document._ConditionAmountLimitExceeded,
Document._ConditionApplication,
Document._ConditionBasisLimitExceeded,
Document._ConditionCalculationType,
Document._ConditionCategory,
Document._ConditionClass,
Document._ConditionControl,
Document._ConditionCurrency,
Document._ConditionInactiveReason,
Document._ConditionOrigin,
// Document._Currency,
Document._Customer,
// Document._PricingConditionType,
Document._PricingScaleBasis,
Document._ConditionQuantityUnit,
Document._ScaleCurrency,
Document._ScaleUnitOfMeasure,
Document._StructureCondition,
Document._Supplier,
Document._VariantCondition,
@ObjectModel.association.type: #TO_COMPOSITION_ROOT
_ServiceEntrySheet,
@ObjectModel.association.type: #TO_COMPOSITION_PARENT
_ServiceEntrySheetItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONDITIONINACTIVEREASON",
"I_CONDITIONINACTIVEREASONTEXT",
"I_SESPRICINGELEMENT"
],
"ASSOCIATED":
[
"I_BILLINGPRICESOURCE",
"I_CONDITIONACCTASSGMTRELEVANCE",
"I_CONDITIONAMOUNTLIMITEXCEEDED",
"I_CONDITIONAPPLICATION",
"I_CONDITIONBASISLIMITEXCEEDED",
"I_CONDITIONCALCULATIONTYPE",
"I_CONDITIONCATEGORY",
"I_CONDITIONCLASS",
"I_CONDITIONCONTROL",
"I_CONDITIONINACTIVEREASON",
"I_CONDITIONORIGIN",
"I_CURRENCY",
"I_CUSTOMER",
"I_PRICINGSCALEBASIS",
"I_SERVICEENTRYSHEETITEMTP",
"I_SERVICEENTRYSHEETTP",
"I_STRUCTURECONDITION",
"I_SUPPLIER",
"I_UNITOFMEASURE",
"I_VARIANTCONDITION"
],
"BASE":
[
"I_SESPRICINGELEMENT"
],
"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