I_SESPricingElementTP

DDL: I_SESPRICINGELEMENTTP SQL: ISESPRCGELMNTTP Type: view TRANSACTIONAL

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)

SourceAliasJoin Type
I_SESPricingElement Document from

Associations (2)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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":""
}
}*/