I_PurOrdPricingElementTP

DDL: I_PURORDPRICINGELEMENTTP SQL: IPOPRICINGTP Type: view TRANSACTIONAL

Transactional View for PO Pricing Element

I_PurOrdPricingElementTP is a Transactional CDS View that provides data about "Transactional View for PO Pricing Element" in SAP S/4HANA. It reads from 1 data source (I_PurOrdPricingElement) and exposes 101 fields with key fields PurchaseOrder, PurchaseOrderItem, PricingDocument, PricingDocumentItem, PricingProcedureStep. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurOrdPricingElement Document from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchaseOrderTP _PurchaseOrderTP _PurchaseOrderTP.PurchaseOrder = $projection.PurchaseOrder
[1..1] I_PurchaseOrderItemTP _PurchaseOrderItemTP _PurchaseOrderItemTP.PurchaseOrder = $projection.PurchaseOrder and _PurchaseOrderItemTP.PurchaseOrderItem = $projection.PurchaseOrderItem

Annotations (13)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
AbapCatalog.sqlViewName IPOPRICINGTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactional View for PO Pricing Element view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence POPRICINGTP_D view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (101)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurOrdPricingElement PurchaseOrder
KEY PurchaseOrderItem I_PurOrdPricingElement PurchaseOrderItem
KEY PricingDocument I_PurOrdPricingElement PricingDocument
KEY PricingDocumentItem I_PurOrdPricingElement PricingDocumentItem
KEY PricingProcedureStep I_PurOrdPricingElement PricingProcedureStep
KEY PricingProcedureCounter I_PurOrdPricingElement PricingProcedureCounter
ConditionApplication I_PurOrdPricingElement ConditionApplication
ConditionType I_PurOrdPricingElement ConditionType
PricingDateTime I_PurOrdPricingElement PricingDateTime
ConditionCalculationType I_PurOrdPricingElement ConditionCalculationType
ConditionBaseValue I_PurOrdPricingElement ConditionBaseValue
ConditionRateValue I_PurOrdPricingElement ConditionRateValue
ConditionCurrency I_PurOrdPricingElement ConditionCurrency
PriceDetnExchangeRate I_PurOrdPricingElement PriceDetnExchangeRate
ConditionQuantity I_PurOrdPricingElement ConditionQuantity
ConditionQuantityUnit I_PurOrdPricingElement ConditionQuantityUnit
ConditionToBaseQtyNmrtr I_PurOrdPricingElement ConditionToBaseQtyNmrtr
ConditionToBaseQtyDnmntr I_PurOrdPricingElement ConditionToBaseQtyDnmntr
ConditionCategory I_PurOrdPricingElement ConditionCategory
ConditionIsForStatistics I_PurOrdPricingElement ConditionIsForStatistics
PricingScaleType I_PurOrdPricingElement PricingScaleType
IsRelevantForAccrual I_PurOrdPricingElement IsRelevantForAccrual
CndnIsRelevantForInvoiceList I_PurOrdPricingElement CndnIsRelevantForInvoiceList
ConditionOrigin I_PurOrdPricingElement ConditionOrigin
IsGroupCondition I_PurOrdPricingElement IsGroupCondition
AccessNumberOfAccessSequence I_PurOrdPricingElement AccessNumberOfAccessSequence
ConditionRecord I_PurOrdPricingElement ConditionRecord
ConditionSequentialNumber I_PurOrdPricingElement ConditionSequentialNumber
AccountKeyForGLAccount I_PurOrdPricingElement AccountKeyForGLAccount
GLAccount I_PurOrdPricingElement GLAccount
TaxCode I_PurOrdPricingElement TaxCode
AcctKeyForAccrualsGLAccount I_PurOrdPricingElement AcctKeyForAccrualsGLAccount
AccrualsGLAccount I_PurOrdPricingElement AccrualsGLAccount
WithholdingTaxCode I_PurOrdPricingElement WithholdingTaxCode
FreightSupplier I_PurOrdPricingElement FreightSupplier
CndnRoundingOffDiffAmount I_PurOrdPricingElement CndnRoundingOffDiffAmount
ConditionAmount I_PurOrdPricingElement ConditionAmount
TransactionCurrency I_PurOrdPricingElement TransactionCurrency
ConditionControl I_PurOrdPricingElement ConditionControl
ConditionInactiveReason I_PurOrdPricingElement ConditionInactiveReason
ConditionInactiveReasonName
ConditionClass I_PurOrdPricingElement ConditionClass
PrcgProcedureCounterForHeader I_PurOrdPricingElement PrcgProcedureCounterForHeader
FactorForConditionBasisValue I_PurOrdPricingElement FactorForConditionBasisValue
StructureCondition I_PurOrdPricingElement StructureCondition
PeriodFactorForCndnBasisValue I_PurOrdPricingElement PeriodFactorForCndnBasisValue
PricingScaleBasis I_PurOrdPricingElement PricingScaleBasis
ConditionScaleBasisValue I_PurOrdPricingElement ConditionScaleBasisValue
ConditionScaleBasisUnit I_PurOrdPricingElement ConditionScaleBasisUnit
ConditionScaleBasisCurrency I_PurOrdPricingElement ConditionScaleBasisCurrency
ConditionAlternativeCurrency I_PurOrdPricingElement ConditionAlternativeCurrency
ConditionAmountInLocalCrcy I_PurOrdPricingElement ConditionAmountInLocalCrcy
CndnIsRelevantForIntcoBilling I_PurOrdPricingElement CndnIsRelevantForIntcoBilling
ConditionIsManuallyChanged I_PurOrdPricingElement ConditionIsManuallyChanged
BillingPriceSource I_PurOrdPricingElement BillingPriceSource
TaxJurisdictionLevel I_PurOrdPricingElement TaxJurisdictionLevel
ConditionByteSequence I_PurOrdPricingElement ConditionByteSequence
CndnIsRelevantForLimitValue I_PurOrdPricingElement CndnIsRelevantForLimitValue
ConditionBasisLimitExceeded I_PurOrdPricingElement ConditionBasisLimitExceeded
ConditionAmountLimitExceeded I_PurOrdPricingElement ConditionAmountLimitExceeded
CumulatedConditionBasisValue I_PurOrdPricingElement CumulatedConditionBasisValue
CustomerRebateRecipient I_PurOrdPricingElement CustomerRebateRecipient
ConditionIsForConfiguration I_PurOrdPricingElement ConditionIsForConfiguration
VariantCondition I_PurOrdPricingElement VariantCondition
ConditionAcctAssgmtRelevance I_PurOrdPricingElement ConditionAcctAssgmtRelevance
ConditionMatrixMaintRelevance I_PurOrdPricingElement ConditionMatrixMaintRelevance
ConfigblParametersAndFormulas I_PurOrdPricingElement ConfigblParametersAndFormulas
ConditionAdjustedQuantity I_PurOrdPricingElement ConditionAdjustedQuantity
ConditionTypeName I_PurOrdPricingElement ConditionTypeName
ConditionBaseValueIntlUnit I_PurOrdPricingElement ConditionBaseValueIntlUnit
ConditionBaseValueUnit I_PurOrdPricingElement ConditionBaseValueUnit
ConditionRateValueIntlUnit I_PurOrdPricingElement ConditionRateValueIntlUnit
TaxCodeName I_PurOrdPricingElement TaxCodeName
ConditionIsDeletable I_PurOrdPricingElement ConditionIsDeletable
PricingProcedure I_PurOrdPricingElement PricingProcedure
SuperordinateDocument I_PurOrdPricingElement SuperordinateDocument
SuperordinateDocumentItem I_PurOrdPricingElement SuperordinateDocumentItem
ConditionRateValueUnit I_PurOrdPricingElement ConditionRateValueUnit
_BillingPriceSource I_PurOrdPricingElement _BillingPriceSource
_ConditionAcctAssgmtRelevance I_PurOrdPricingElement _ConditionAcctAssgmtRelevance
_ConditionAlternativeCurrency I_PurOrdPricingElement _ConditionAlternativeCurrency
_ConditionAmountLimitExceeded I_PurOrdPricingElement _ConditionAmountLimitExceeded
_ConditionApplication I_PurOrdPricingElement _ConditionApplication
_ConditionBasisLimitExceeded I_PurOrdPricingElement _ConditionBasisLimitExceeded
_ConditionCalculationType I_PurOrdPricingElement _ConditionCalculationType
_ConditionCategory I_PurOrdPricingElement _ConditionCategory
_ConditionClass I_PurOrdPricingElement _ConditionClass
_ConditionControl I_PurOrdPricingElement _ConditionControl
_ConditionCurrency I_PurOrdPricingElement _ConditionCurrency
_ConditionInactiveReason I_PurOrdPricingElement _ConditionInactiveReason
_ConditionOrigin I_PurOrdPricingElement _ConditionOrigin
_Customer I_PurOrdPricingElement _Customer
_PricingScaleBasis I_PurOrdPricingElement _PricingScaleBasis
_ConditionQuantityUnit I_PurOrdPricingElement _ConditionQuantityUnit
_ScaleCurrency I_PurOrdPricingElement _ScaleCurrency
_ScaleUnitOfMeasure I_PurOrdPricingElement _ScaleUnitOfMeasure
_StructureCondition I_PurOrdPricingElement _StructureCondition
_Supplier I_PurOrdPricingElement _Supplier
_VariantCondition I_PurOrdPricingElement _VariantCondition
_PurchaseOrderTP _PurchaseOrderTP
_PurchaseOrderItemTP _PurchaseOrderItemTP
@VDM.viewType: #TRANSACTIONAL
@AbapCatalog.sqlViewName: 'IPOPRICINGTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transactional View for PO Pricing Element'

@ObjectModel: {
    semanticKey: ['PurchaseOrder', 'PurchaseOrderItem', 'PricingDocument', 'PricingDocumentItem', 'PricingProcedureStep', 'PricingProcedureCounter'],
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    writeDraftPersistence: 'POPRICINGTP_D'
}

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_PurOrdPricingElementTP
  as select from I_PurOrdPricingElement as Document

  association [1..1] to I_PurchaseOrderTP     as _PurchaseOrderTP     on  _PurchaseOrderTP.PurchaseOrder = $projection.PurchaseOrder
  association [1..1] to I_PurchaseOrderItemTP as _PurchaseOrderItemTP on  _PurchaseOrderItemTP.PurchaseOrder     = $projection.PurchaseOrder
                                                                      and _PurchaseOrderItemTP.PurchaseOrderItem = $projection.PurchaseOrderItem

{

  key Document.PurchaseOrder,
  key Document.PurchaseOrderItem,
  key Document.PricingDocument,
  key Document.PricingDocumentItem,
  key Document.PricingProcedureStep,
  key Document.PricingProcedureCounter,
      Document.ConditionApplication,
      Document.ConditionType,
      @Semantics.dateTime: true
      Document.PricingDateTime,
      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._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
      _PurchaseOrderTP,
      @ObjectModel.association.type: #TO_COMPOSITION_PARENT
      _PurchaseOrderItemTP

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONDITIONINACTIVEREASON",
"I_CONDITIONINACTIVEREASONTEXT",
"I_PURORDPRICINGELEMENT"
],
"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_PURCHASEORDERITEMTP",
"I_PURCHASEORDERTP",
"I_STRUCTURECONDITION",
"I_SUPPLIER",
"I_UNITOFMEASURE",
"I_VARIANTCONDITION"
],
"BASE":
[
"I_PURORDPRICINGELEMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/