What is R_STOItemPricingElementDraft in SAP S/4HANA?

R_STOItemPricingElementDraft is a basic CDS view in SAP S/4HANA. Pricing Element for STO Item - Draft It contains 78 fields.

Which tables does R_STOItemPricingElementDraft read from?

R_STOItemPricingElementDraft reads data from: mmstoitmprgelm_d.

What VDM layer is R_STOItemPricingElementDraft?

R_STOItemPricingElementDraft is classified as a Basic (interface) view providing a 1:1 representation of a database table.

R_STOItemPricingElementDraft

DDL: R_STOITEMPRICINGELEMENTDRAFT Type: view_entity BASIC Package: RAP_MM_STO

78 Fields 1 Data Sources

Pricing Element for STO Item - Draft

R_STOItemPricingElementDraft is a Basic CDS View that provides data about "Pricing Element for STO Item - Draft" in SAP S/4HANA. It reads from 1 data source (mmstoitmprgelm_d) and exposes 78 fields with key fields StockTransportOrder, StockTransportOrderItem, PricingDocument, PricingDocumentItem, PricingProcedureStep. Part of development package RAP_MM_STO.

Data Sources (1)

Source	Alias	Join Type
mmstoitmprgelm_d	mmstoitmprgelm_d	from

Annotations (9)

Name	Value	Level
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Pricing Element for STO Item - Draft	view

Fields (78)

Key	Field	Source Field	Description
KEY	StockTransportOrder	stocktransportorder	STO Number
KEY	StockTransportOrderItem	stocktransportorderitem	STO Item
KEY	PricingDocument	pricingdocument	Document Condition
KEY	PricingDocumentItem	pricingdocumentitem	Item
KEY	PricingProcedureStep	pricingprocedurestep	Step Number
KEY	PricingProcedureCounter	pricingprocedurecounter	Pricing Procedure Counter
KEY	DraftUUID	draftuuid	UUID
	ParentDraftUUID	parentdraftuuid	NodeID
	ConditionApplication	conditionapplication	Application
	ConditionType	conditiontype	Condition type
	PriceConditionDeterminationDte	priceconditiondeterminationdte	Condition Pricing Date
	ConditionCalculationType	conditioncalculationtype	Calculat.Type
	ConditionBaseAmount	conditionbaseamount	Condition Basis Amount
	ConditionRateAmount	conditionrateamount	Condition Amount
	ConditionRateRatio	conditionrateratio	Ratio
	ConditionRateRatioUnit	conditionrateratiounit	Unit of Measure
	ConditionCurrency	conditioncurrency	Currency
	PriceDetnExchangeRate	pricedetnexchangerate	Exchange Rate
	ConditionQuantity	conditionquantity	Pricing Unit
	ConditionQuantityUnit	conditionquantityunit	Unit of Measure
	ConditionToBaseQtyNmrtr	conditiontobaseqtynmrtr	Numerator
	ConditionToBaseQtyDnmntr	conditiontobaseqtydnmntr	Denominator
	ConditionCategory	conditioncategory	Condit.Category
	ConditionIsForStatistics	conditionisforstatistics	Statistical
	PricingScaleType	pricingscaletype	Scale Type
	IsRelevantForAccrual	isrelevantforaccrual	Accruals
	CndnIsRelevantForInvoiceList	cndnisrelevantforinvoicelist	Settlement Document List Condition
	ConditionOrigin	conditionorigin	Condit.Origin
	IsGroupCondition	isgroupcondition	Group Condition
	AccessNumberOfAccessSequence	accessnumberofaccesssequence	Access
	ConditionRecord	conditionrecord	Cond.Record No.
	ConditionSequentialNumber	conditionsequentialnumber	SequNo of Cond.
	AccountKeyForGLAccount	accountkeyforglaccount	Account Key
	GLAccount	glaccount	General Ledger
	TaxCode	taxcode	Tax Code
	AcctKeyForAccrualsGLAccount	acctkeyforaccrualsglaccount	Accruals
	AccrualsGLAccount	accrualsglaccount	Accruals Acc.
	WithholdingTaxCode	withholdingtaxcode	WTax Code
	FreightSupplier	freightsupplier	Supplier
	CndnRoundingOffDiffAmount	cndnroundingoffdiffamount	CondRoundDiff.
	ConditionAmount	conditionamount	Condition Value
	TransactionCurrency	transactioncurrency	Transaction Currency
	ConditionControl	conditioncontrol	Cond.Control
	ConditionInactiveReason	conditioninactivereason	Inactive
	ConditionClass	conditionclass	Condition Class
	PrcgProcedureCounterForHeader	prcgprocedurecounterforheader	Pricing Procedure Counter for Header
	FactorForConditionBasisValue	factorforconditionbasisvalue	Factor for Condition Basis Value
	StructureCondition	structurecondition	Structure Cond.
	PeriodFactorForCndnBasisValue	periodfactorforcndnbasisvalue	Period Factor for Condition Basis Value
	PricingScaleBasis	pricingscalebasis	Scale Basis
	ConditionScaleBasisCurrency	conditionscalebasiscurrency	Scale Currency
	ConditionAlternativeCurrency	conditionalternativecurrency	Cndn Currency
	ConditionAmountInLocalCrcy	conditionamountinlocalcrcy	Cumulative Condition Value
	CndnIsRelevantForIntcoBilling	cndnisrelevantforintcobilling	IntcoBillCond
	ConditionIsManuallyChanged	conditionismanuallychanged	Changed Manual.
	BillingPriceSource	billingpricesource	Single-Character Flag
	TaxJurisdictionLevel	taxjurisdictionlevel	Jurisdiction level
	ConditionByteSequence	conditionbytesequence	BitFlags
	CndnIsRelevantForLimitValue	cndnisrelevantforlimitvalue	Condit. Update
	ConditionBasisLimitExceeded	conditionbasislimitexceeded	Max Basis Value
	ConditionAmountLimitExceeded	conditionamountlimitexceeded	Maximum Amount
	CustomerRebateRecipient	customerrebaterecipient	Customer
	ConditionIsForConfiguration	conditionisforconfiguration	UsedfVarConfig
	VariantCondition	variantcondition	Variant Key
	ConditionAcctAssgmtRelevance	conditionacctassgmtrelevance	Rel.Acc.Assig.
	ConditionMatrixMaintRelevance	conditionmatrixmaintrelevance	Matrix Maint.
	ConfigblParametersAndFormulas	configblparametersandformulas	Form. ID in Document
	ConditionAdjustedQuantity	conditionadjustedquantity	Adjusted Qty.
	ConditionTypeName	conditiontypename	Name
	TaxCodeName	taxcodename	Tax Code Name
	ConditionIsDeletable	conditionisdeletable
	PricingProcedure	pricingprocedure	Procedure
	StkTransptOrdDraftUUID	stktransptorddraftuuid	Draft Document ID
	DraftEntityCreationDateTime	draftentitycreationdatetime	Draft Created On
	DraftEntityLastChangeDateTime	draftentitylastchangedatetime	Draft Last Changed On
	DraftAdministrativeDataUUID	draftadministrativedatauuid	UUID
	DraftEntityOperationCode	draftentityoperationcode	Draft - Operation Code
	HasActiveEntity	hasactiveentity	TRUE

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_STOItemPricingElementDraft.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_STOItemPricingElementDraft AS
SELECT
  StockTransportOrder,
  StockTransportOrderItem,
  PricingDocument,
  PricingDocumentItem,
  PricingProcedureStep,
  PricingProcedureCounter,
  DraftUUID,
  ParentDraftUUID,
  ConditionApplication,
  ConditionType,
  PriceConditionDeterminationDte,
  ConditionCalculationType,
  ConditionBaseAmount,
  ConditionRateAmount,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionCurrency,
  PriceDetnExchangeRate,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  ConditionCategory,
  ConditionIsForStatistics,
  PricingScaleType,
  IsRelevantForAccrual,
  CndnIsRelevantForInvoiceList,
  ConditionOrigin,
  IsGroupCondition,
  AccessNumberOfAccessSequence,
  ConditionRecord,
  ConditionSequentialNumber,
  AccountKeyForGLAccount,
  GLAccount,
  TaxCode,
  AcctKeyForAccrualsGLAccount,
  AccrualsGLAccount,
  WithholdingTaxCode,
  FreightSupplier,
  CndnRoundingOffDiffAmount,
  ConditionAmount,
  TransactionCurrency,
  ConditionControl,
  ConditionInactiveReason,
  ConditionClass,
  PrcgProcedureCounterForHeader,
  FactorForConditionBasisValue,
  StructureCondition,
  PeriodFactorForCndnBasisValue,
  PricingScaleBasis,
  ConditionScaleBasisCurrency,
  ConditionAlternativeCurrency,
  ConditionAmountInLocalCrcy,
  CndnIsRelevantForIntcoBilling,
  ConditionIsManuallyChanged,
  BillingPriceSource,
  TaxJurisdictionLevel,
  ConditionByteSequence,
  CndnIsRelevantForLimitValue,
  ConditionBasisLimitExceeded,
  ConditionAmountLimitExceeded,
  CustomerRebateRecipient,
  ConditionIsForConfiguration,
  VariantCondition,
  ConditionAcctAssgmtRelevance,
  ConditionMatrixMaintRelevance,
  ConfigblParametersAndFormulas,
  ConditionAdjustedQuantity,
  ConditionTypeName,
  TaxCodeName,
  ConditionIsDeletable,
  PricingProcedure,
  StkTransptOrdDraftUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity
FROM mmstoitmprgelm_d
;

Depth:

R_STOItemPricingElementDraft view_entity

mmstoitmprgelm_d