I_PurOrdPricingElementTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_PurOrdPricingElement | Document | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
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