I_SESPRICINGELEMENT
Service Entry Sheet Pricing Element
I_SESPRICINGELEMENT is a CDS View in S/4HANA. Service Entry Sheet Pricing Element. It contains 102 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_SESPricingElementTP | view | from | TRANSACTIONAL | Service Entry Sheet Pricing Element - TP |
| R_SESPricingElementTP | view_entity | from | TRANSACTIONAL | SES Pricing Element |
Fields (102)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | PricingDocument | PricingDocument | 1 |
| KEY | PricingDocumentItem | PricingDocumentItem | 1 |
| KEY | PricingProcedureCounter | PricingProcedureCounter | 1 |
| KEY | PricingProcedureStep | PricingProcedureStep | 1 |
| KEY | ServiceEntrySheet | ServiceEntrySheet | 1 |
| KEY | ServiceEntrySheetItem | ServiceEntrySheetItem | 1 |
| _BillingPriceSource | _BillingPriceSource | 1 | |
| _ConditionAcctAssgmtRelevance | _ConditionAcctAssgmtRelevance | 1 | |
| _ConditionAlternativeCurrency | _ConditionAlternativeCurrency | 1 | |
| _ConditionAmountLimitExceeded | _ConditionAmountLimitExceeded | 1 | |
| _ConditionApplication | _ConditionApplication | 1 | |
| _ConditionBasisLimitExceeded | _ConditionBasisLimitExceeded | 1 | |
| _ConditionCalculationType | _ConditionCalculationType | 1 | |
| _ConditionCategory | _ConditionCategory | 1 | |
| _ConditionClass | _ConditionClass | 1 | |
| _ConditionControl | _ConditionControl | 1 | |
| _ConditionCurrency | _ConditionCurrency | 1 | |
| _ConditionInactiveReason | _ConditionInactiveReason | 1 | |
| _ConditionOrigin | _ConditionOrigin | 1 | |
| _ConditionQuantityUnit | _ConditionQuantityUnit | 1 | |
| _Customer | _Customer | 1 | |
| _PricingScaleBasis | _PricingScaleBasis | 1 | |
| _ScaleCurrency | _ScaleCurrency | 1 | |
| _ScaleUnitOfMeasure | _ScaleUnitOfMeasure | 1 | |
| _StructureCondition | _StructureCondition | 1 | |
| _Supplier | _Supplier | 1 | |
| _VariantCondition | _VariantCondition | 1 | |
| AccessNumberOfAccessSequence | AccessNumberOfAccessSequence | 1 | |
| AccountKeyForGLAccount | AccountKeyForGLAccount | 1 | |
| AccrualsGLAccount | AccrualsGLAccount | 1 | |
| AcctKeyForAccrualsGLAccount | AcctKeyForAccrualsGLAccount | 1 | |
| BillingPriceSource | BillingPriceSource | 1 | |
| CndnIsRelevantForIntcoBilling | CndnIsRelevantForIntcoBilling | 1 | |
| CndnIsRelevantForInvoiceList | CndnIsRelevantForInvoiceList | 1 | |
| CndnIsRelevantForLimitValue | CndnIsRelevantForLimitValue | 1 | |
| CndnRoundingOffDiffAmount | CndnRoundingOffDiffAmount | 1 | |
| ConditionAcctAssgmtRelevance | ConditionAcctAssgmtRelevance | 1 | |
| ConditionAdjustedQuantity | ConditionAdjustedQuantity | 1 | |
| ConditionAlternativeCurrency | ConditionAlternativeCurrency | 1 | |
| ConditionAmount | ConditionAmount | 1 | |
| ConditionAmountInLocalCrcy | ConditionAmountInLocalCrcy | 1 | |
| ConditionAmountLimitExceeded | ConditionAmountLimitExceeded | 1 | |
| ConditionApplication | ConditionApplication | 1 | |
| ConditionBaseValue | ConditionBaseValue | 1 | |
| ConditionBaseValueIntlUnit | ConditionBaseValueIntlUnit | 1 | |
| ConditionBaseValueUnit | ConditionBaseValueUnit | 1 | |
| ConditionBasisLimitExceeded | ConditionBasisLimitExceeded | 1 | |
| ConditionByteSequence | ConditionByteSequence | 1 | |
| ConditionCalculationType | ConditionCalculationType | 1 | |
| ConditionCategory | ConditionCategory | 1 | |
| ConditionClass | ConditionClass | 1 | |
| ConditionControl | ConditionControl | 1 | |
| ConditionCurrency | ConditionCurrency | 1 | |
| ConditionInactiveReason | ConditionInactiveReason | 1 | |
| ConditionIsDeletable | ConditionIsDeletable | 1 | |
| ConditionIsForConfiguration | ConditionIsForConfiguration | 1 | |
| ConditionIsForStatistics | ConditionIsForStatistics | 1 | |
| ConditionIsManuallyChanged | ConditionIsManuallyChanged | 1 | |
| ConditionMatrixMaintRelevance | ConditionMatrixMaintRelevance | 1 | |
| ConditionOrigin | ConditionOrigin | 1 | |
| ConditionQuantity | ConditionQuantity | 1 | |
| ConditionQuantityUnit | ConditionQuantityUnit | 1 | |
| ConditionRateValue | ConditionRateValue | 1 | |
| ConditionRateValueIntlUnit | ConditionRateValueIntlUnit | 1 | |
| ConditionRateValueUnit | ConditionRateValueUnit | 1 | |
| ConditionRecord | ConditionRecord | 1 | |
| ConditionScaleBasisCurrency | ConditionScaleBasisCurrency | 1 | |
| ConditionScaleBasisUnit | ConditionScaleBasisUnit | 1 | |
| ConditionScaleBasisValue | ConditionScaleBasisValue | 1 | |
| ConditionSequentialNumber | ConditionSequentialNumber | 1 | |
| ConditionToBaseQtyDnmntr | ConditionToBaseQtyDnmntr | 1 | |
| ConditionToBaseQtyNmrtr | ConditionToBaseQtyNmrtr | 1 | |
| ConditionType | ConditionType | 1 | |
| ConditionTypeName | ConditionTypeName | 1 | |
| ConfigblParametersAndFormulas | ConfigblParametersAndFormulas | 1 | |
| CumulatedConditionBasisValue | CumulatedConditionBasisValue | 1 | |
| CustomerRebateRecipient | CustomerRebateRecipient | 1 | |
| FactorForConditionBasisValue | FactorForConditionBasisValue | 1 | |
| FreightSupplier | FreightSupplier | 1 | |
| GLAccount | GLAccount | 1 | |
| IsGroupCondition | IsGroupCondition | 1 | |
| IsRelevantForAccrual | IsRelevantForAccrual | 1 | |
| OrderQuantity | OrderQuantity | 1 | |
| PeriodFactorForCndnBasisValue | PeriodFactorForCndnBasisValue | 1 | |
| PrcgProcedureCounterForHeader | PrcgProcedureCounterForHeader | 1 | |
| PriceConditionDeterminationDte | PriceConditionDeterminationDte | 1 | |
| PricingProcedure | PricingProcedure | 1 | |
| PricingScaleBasis | PricingScaleBasis | 1 | |
| PricingScaleType | PricingScaleType | 1 | |
| PurchaseOrderQuantityUnit | PurchaseOrderQuantityUnit | 1 | |
| PurgDocConditionAmount | PurgDocConditionAmount | 1 | |
| PurgDocConditionCurrency | PurgDocConditionCurrency | 1 | |
| PurgDocConditionRateValue | PurgDocConditionRateValue | 1 | |
| StructureCondition | StructureCondition | 1 | |
| SuperordinateDocument | SuperordinateDocument | 1 | |
| SuperordinateDocumentItem | SuperordinateDocumentItem | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxCodeName | TaxCodeName | 1 | |
| TaxJurisdictionLevel | TaxJurisdictionLevel | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| VariantCondition | VariantCondition | 1 | |
| WithholdingTaxCode | WithholdingTaxCode | 1 |
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory:#XL
@EndUserText.label: 'Service Entry Sheet Pricing Element'
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AbapCatalog.sqlViewName: 'ISESPRCGELMNT'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel: {
semanticKey: ['ServiceEntrySheet', 'ServiceEntrySheetItem', 'PricingDocument', 'PricingDocumentItem','PricingProcedureStep', 'PricingProcedureCounter']
}
@ObjectModel.sapObjectNodeType.name: 'ServiceEntrySheet'
define view I_SESPricingElement
/*as select from I_PurgDocPricingElement
inner join I_ServiceEntrySheet as ServiceEntrySheet on I_PurgDocPricingElement.PurchasingDocument = ServiceEntrySheet.ServiceEntrySheet
*/
as select from I_ServiceEntrySheet as ServiceEntrySheet
//right outer join I_ServiceEntrySheetItem as ServiceEntrySheetItem on ServiceEntrySheet.ServiceEntrySheet = ServiceEntrySheetItem.ServiceEntrySheet
inner join I_PricingElement on ServiceEntrySheet.PricingDocument = I_PricingElement.PricingDocument
// and ServiceEntrySheetItem.ServiceEntrySheetItem = substring(I_PricingElement.PricingDocumentItem,2,6)
association [1..1] to I_ServiceEntrySheet as _ServiceEntrySheet on _ServiceEntrySheet.ServiceEntrySheet = $projection.ServiceEntrySheet
association [1..1] to I_ServiceEntrySheetItem as _ServiceEntrySheetItem on _ServiceEntrySheetItem.ServiceEntrySheet = $projection.ServiceEntrySheet
and _ServiceEntrySheetItem.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem
association [0..1] to I_ConditionTypeText as _PricingConditionTypeText on _PricingConditionTypeText.ConditionApplication = $projection.ConditionApplication
and _PricingConditionTypeText.ConditionType = $projection.ConditionType
and _PricingConditionTypeText.ConditionUsage = 'A'
and _PricingConditionTypeText.Language = $session.system_language
association [0..1] to I_SESPurgDocItemFixedAmountDta as _SESPurgDocItemFixedAmountDta on _SESPurgDocItemFixedAmountDta.ServiceEntrySheet = $projection.ServiceEntrySheet
and _SESPurgDocItemFixedAmountDta.ServiceEntrySheetItem = $projection.PricingDocumentItem
and _SESPurgDocItemFixedAmountDta.PricingProcedureStep = $projection.PricingProcedureStep
and _SESPurgDocItemFixedAmountDta.PricingProcedureCounter = $projection.PricingProcedureCounter
{
@ObjectModel.foreignKey.association: '_ServiceEntrySheet'
key ServiceEntrySheet.ServiceEntrySheet,
@ObjectModel.foreignKey.association: '_ServiceEntrySheetItem'
//key _ServiceEntrySheetItem.ServiceEntrySheetItem,
key cast(substring(I_PricingElement.PricingDocumentItem,2,6) as numc5) as ServiceEntrySheetItem,
key I_PricingElement.PricingDocument,
key I_PricingElement.PricingDocumentItem,
key I_PricingElement.PricingProcedureStep,
key I_PricingElement.PricingProcedureCounter,
I_PricingElement.ConditionApplication,
I_PricingElement.ConditionType,
//@Semantics.dateTime: true
//I_PricingElement.PricingDateTime,
cast( '' as abap.dats ) as PriceConditionDeterminationDte,
I_PricingElement.ConditionCalculationType,
I_PricingElement.ConditionBaseValue,
I_PricingElement.ConditionRateValue,
I_PricingElement.ConditionCurrency,
// I_PricingElement.PriceDetnExchangeRate,
I_PricingElement.ConditionQuantity,
I_PricingElement.ConditionQuantityUnit,
I_PricingElement.ConditionToBaseQtyNmrtr,
I_PricingElement.ConditionToBaseQtyDnmntr,
I_PricingElement.ConditionCategory,
I_PricingElement.ConditionIsForStatistics,
I_PricingElement.PricingScaleType,
I_PricingElement.IsRelevantForAccrual,
I_PricingElement.CndnIsRelevantForInvoiceList,
I_PricingElement.ConditionOrigin,
I_PricingElement.IsGroupCondition,
I_PricingElement.AccessNumberOfAccessSequence,
I_PricingElement.ConditionRecord,
I_PricingElement.ConditionSequentialNumber,
I_PricingElement.AccountKeyForGLAccount,
I_PricingElement.GLAccount,
I_PricingElement.TaxCode,
I_PricingElement.AcctKeyForAccrualsGLAccount,
I_PricingElement.AccrualsGLAccount,
I_PricingElement.WithholdingTaxCode,
I_PricingElement.FreightSupplier,
I_PricingElement.CndnRoundingOffDiffAmount,
I_PricingElement.ConditionAmount,
I_PricingElement.TransactionCurrency,
I_PricingElement.ConditionControl,
I_PricingElement.ConditionInactiveReason,
I_PricingElement.ConditionClass,
I_PricingElement.PrcgProcedureCounterForHeader,
I_PricingElement.FactorForConditionBasisValue,
I_PricingElement.StructureCondition,
I_PricingElement.PeriodFactorForCndnBasisValue,
I_PricingElement.PricingScaleBasis,
I_PricingElement.ConditionScaleBasisValue,
I_PricingElement.ConditionScaleBasisUnit,
I_PricingElement.ConditionScaleBasisCurrency,
I_PricingElement.ConditionAlternativeCurrency,
I_PricingElement.ConditionAmountInLocalCrcy,
I_PricingElement.CndnIsRelevantForIntcoBilling,
I_PricingElement.ConditionIsManuallyChanged,
I_PricingElement.BillingPriceSource,
I_PricingElement.TaxJurisdictionLevel,
I_PricingElement.ConditionByteSequence,
I_PricingElement.CndnIsRelevantForLimitValue,
I_PricingElement.ConditionBasisLimitExceeded,
I_PricingElement.ConditionAmountLimitExceeded,
I_PricingElement.CumulatedConditionBasisValue,
I_PricingElement.CustomerRebateRecipient,
I_PricingElement.ConditionIsForConfiguration,
I_PricingElement.VariantCondition,
I_PricingElement.ConditionAcctAssgmtRelevance,
I_PricingElement.ConditionMatrixMaintRelevance,
I_PricingElement.ConfigblParametersAndFormulas,
I_PricingElement.ConditionAdjustedQuantity,
@ObjectModel.readOnly: true
_PricingConditionTypeText.ConditionTypeName,
@Semantics.currencyCode: true
case
when ConditionCalculationType = 'C'
or ConditionCalculationType = 'M'
or ConditionCalculationType = 'N'
or ConditionCalculationType = 'O'
or ConditionCalculationType = 'P'
or ConditionCalculationType = 'Q'
or ConditionCalculationType = 'V'
or ConditionCalculationType = 'D'
or ConditionCalculationType = 'E'
or ConditionCalculationType = 'F'
or ConditionCalculationType = 'R'
then
case ConditionBaseValue
when floor(cast(ConditionBaseValue as abap.curr(15,2)))
then cast(cast('0' as char5) as waers)
else
cast(cast('5' as char5) as waers)
end
else
cast(cast(coalesce(I_PricingElement._Currency.Decimals, 2) as char5) as waers)
end as ConditionBaseValueIntlUnit,
@Semantics.currencyCode: true
case
when ConditionCalculationType = 'C'
or ConditionCalculationType = 'M'
or ConditionCalculationType = 'N'
or ConditionCalculationType = 'O'
or ConditionCalculationType = 'P'
or ConditionCalculationType = 'Q'
or ConditionCalculationType = 'V'
or ConditionCalculationType = 'D'
or ConditionCalculationType = 'E'
or ConditionCalculationType = 'F'
or ConditionCalculationType = 'R'
then cast(substring (ConditionQuantityUnit, 1, 3) as koein)
else cast(substring (TransactionCurrency, 1, 5) as koein)
end as ConditionBaseValueUnit,
@Semantics.currencyCode: true
case
when ConditionCalculationType = 'A'
or ConditionCalculationType = 'H'
or ConditionCalculationType = 'I'
or ConditionCalculationType = 'J'
or ConditionCalculationType = 'K'
then cast(cast('3' as char5) as waers)
when ConditionCalculationType = 'V'
then cast(cast('5' as char5) as waers)
else
cast(cast(coalesce(I_PricingElement._Currency.Decimals, 2) as char5) as waers)
end as ConditionRateValueIntlUnit,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
@Semantics.currencyCode: true
ConditionCurrency as ConditionRateValueUnit,
cast(' ' as price_element_tax_code_descr) as TaxCodeName,
@ObjectModel.readOnly: true
cast(' ' as abap.char( 1 )) as ConditionIsDeletable,
@ObjectModel.readOnly: true
cast(' ' as kalsm_d ) as PricingProcedure,
@ObjectModel.readOnly: true
cast(' ' as abap.char ( 32 )) as SuperordinateDocument,
@ObjectModel.readOnly: true
cast(' ' as abap.char ( 70 )) as SuperordinateDocumentItem,
I_PricingElement._BillingPriceSource,
I_PricingElement._ConditionAcctAssgmtRelevance,
I_PricingElement._ConditionAlternativeCurrency,
I_PricingElement._ConditionAmountLimitExceeded,
I_PricingElement._ConditionApplication,
I_PricingElement._ConditionBasisLimitExceeded,
I_PricingElement._ConditionCalculationType,
I_PricingElement._ConditionCategory,
I_PricingElement._ConditionClass,
I_PricingElement._ConditionControl,
I_PricingElement._ConditionCurrency,
I_PricingElement._ConditionInactiveReason,
I_PricingElement._ConditionOrigin,
I_PricingElement._Currency,
I_PricingElement._Customer,
I_PricingElement._PricingConditionType,
I_PricingElement._PricingScaleBasis,
I_PricingElement._ConditionQuantityUnit,
I_PricingElement._ScaleCurrency,
I_PricingElement._ScaleUnitOfMeasure,
I_PricingElement._StructureCondition,
I_PricingElement._Supplier,
I_PricingElement._VariantCondition,
_SESPurgDocItemFixedAmountDta.OrderQuantity,
_SESPurgDocItemFixedAmountDta.PurchaseOrderQuantityUnit,
_SESPurgDocItemFixedAmountDta.ConditionRateValue as PurgDocConditionRateValue,
_SESPurgDocItemFixedAmountDta.ConditionAmount as PurgDocConditionAmount,
_SESPurgDocItemFixedAmountDta.ConditionCurrency as PurgDocConditionCurrency,
/* Associations */
@ObjectModel.association.type: #TO_COMPOSITION_ROOT
_ServiceEntrySheet,
@ObjectModel.association.type: #TO_COMPOSITION_PARENT
_ServiceEntrySheetItem
}
where
ServiceEntrySheet.PricingDocument is not initial
and I_PricingElement.PricingDocumentItem is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONDITIONTYPETEXT",
"I_CURRENCY",
"I_PRICINGELEMENT",
"I_SERVICEENTRYSHEET",
"I_SESPURGDOCITEMFIXEDAMOUNTDTA"
],
"ASSOCIATED":
[
"I_BILLINGPRICESOURCE",
"I_CONDITIONACCTASSGMTRELEVANCE",
"I_CONDITIONAMOUNTLIMITEXCEEDED",
"I_CONDITIONAPPLICATION",
"I_CONDITIONBASISLIMITEXCEEDED",
"I_CONDITIONCALCULATIONTYPE",
"I_CONDITIONCATEGORY",
"I_CONDITIONCLASS",
"I_CONDITIONCONTROL",
"I_CONDITIONINACTIVEREASON",
"I_CONDITIONORIGIN",
"I_CONDITIONTYPETEXT",
"I_CURRENCY",
"I_CUSTOMER",
"I_PRICINGCONDITIONTYPE",
"I_PRICINGSCALEBASIS",
"I_SERVICEENTRYSHEET",
"I_SERVICEENTRYSHEETITEM",
"I_SESPURGDOCITEMFIXEDAMOUNTDTA",
"I_STRUCTURECONDITION",
"I_SUPPLIER",
"I_UNITOFMEASURE",
"I_VARIANTCONDITION"
],
"BASE":
[
"I_PRICINGELEMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/