P_PRODUCTVALUATIONBASIC
P_PRODUCTVALUATIONBASIC is a CDS View in S/4HANA. It contains 56 fields. 6 CDS views read from this table.
CDS Views using this table (6)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ProductListValuation | view_entity | from | BASIC | Product list Valuation |
| I_Productmlaccount | view | from | BASIC | Product: Val ML acc active core entity |
| I_ProductValuationAccounting_2 | view_entity | from | BASIC | Product Valuation Account |
| I_ProductValuationAcct | view | from | BASIC | Product Valuation Account |
| I_ProductValuationBasic | view | from | BASIC | Product Valuation |
| I_ProductValuationCosting | view | from | BASIC | Product Valuation Costing Core Entity |
Fields (56)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | Product | Product | 6 |
| KEY | ValuationArea | ValuationArea | 6 |
| KEY | ValuationType | ValuationType | 6 |
| _Product | _Product | 1 | |
| CommercialPrice1InCoCodeCrcy | CommercialPrice1InCoCodeCrcy | 2 | |
| CommercialPrice2InCoCodeCrcy | CommercialPrice2InCoCodeCrcy | 2 | |
| CommercialPrice3InCoCodeCrcy | CommercialPrice3InCoCodeCrcy | 2 | |
| CostingOverheadGroup | CostingOverheadGroup | 1 | |
| CostOriginGroup | CostOriginGroup | 1 | |
| DevaluationYearCount | DevaluationYearCount | 2 | |
| FuturePlndPrice1ValdtyDate | FuturePlndPrice1ValdtyDate | 1 | |
| FuturePlndPrice2ValdtyDate | FuturePlndPrice2ValdtyDate | 1 | |
| FuturePlndPrice3ValdtyDate | FuturePlndPrice3ValdtyDate | 1 | |
| FuturePrice | FutureEvaluatedAmountValue,FuturePrice | 3 | |
| FuturePriceValidityStartDate | FuturePriceValidityStartDate | 3 | |
| InventoryValuationProcedure | InventoryValuationProcedure | 2 | |
| IsLIFOAndFIFORelevant | IsLIFOAndFIFORelevant | 2 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| IsMaterialCostedWithQtyStruc | IsMaterialCostedWithQtyStruc | 1 | |
| IsMaterialRelatedOrigin | IsMaterialRelatedOrigin | 1 | |
| IsProducedInhouse | IsProducedInhouse | 1 | |
| LIFOValuationPoolNumber | LIFOValuationPoolNumber | 2 | |
| MaintenanceStatus | MaintenanceStatus | 2 | |
| MLIsActiveAtProductLevel | MLIsActiveAtProductLevel | 2 | |
| MovingAveragePrice | MovingAveragePrice | 2 | |
| MvgAveragePriceInPreviousYear | MvgAveragePriceInPreviousYear | 1 | |
| MvgAvgPriceInPreviousPeriod | MvgAvgPriceInPreviousPeriod | 1 | |
| PlannedPrice | PlannedPrice | 1 | |
| PlannedPrice1InCoCodeCrcy | PlannedPrice1InCoCodeCrcy | 1 | |
| PlannedPrice2InCoCodeCrcy | PlannedPrice2InCoCodeCrcy | 1 | |
| PlannedPrice3InCoCodeCrcy | PlannedPrice3InCoCodeCrcy | 1 | |
| PrevInvtryPriceInCoCodeCrcy | PrevInvtryPriceInCoCodeCrcy | 1 | |
| PriceDeterminationControl | PriceDeterminationControl | 1 | |
| PriceLastChangeDate | PriceLastChangeDate | 1 | |
| PriceUnitQty | PriceUnitQty | 2 | |
| ProdCostEstNumber | ProdCostEstNumber | 2 | |
| ProdPrcControlInPreviousPeriod | ProdPrcControlInPreviousPeriod | 1 | |
| ProdPrcUntQtyInPreviousPeriod | ProdPrcUntQtyInPreviousPeriod | 1 | |
| ProdPrcUntQtyInPreviousYear | ProdPrcUntQtyInPreviousYear | 1 | |
| ProdPriceControlInPreviousYear | ProdPriceControlInPreviousYear | 1 | |
| ProductOriginType | ProductOriginType | 1 | |
| ProductUsageType | ProductUsageType | 1 | |
| ProjectStockValuationClass | ProjectStockValuationClass | 1 | |
| StandardPrice | StandardPrice | 2 | |
| StandardPriceInPreviousPeriod | StandardPriceInPreviousPeriod | 1 | |
| StandardPricePrevYear | StandardPricePrevYear | 2 | |
| TaxBasedPricesPriceUnitQty | TaxBasedPricesPriceUnitQty | 4 | |
| TaxPrice2InCoCodeCrcy | TaxPrice2InCoCodeCrcy | 2 | |
| TaxPrice3InCoCodeCrcy | TaxPrice3InCoCodeCrcy | 2 | |
| TaxPricel1InCoCodeCrcy | TaxPricel1InCoCodeCrcy | 2 | |
| ValuationCategory | ValuationCategory | 2 | |
| ValuationClass | ValuationClass | 2 | |
| ValuationClassPreviousPeriod | ValuationClassPreviousPeriod | 1 | |
| ValuationClassPreviousYear | ValuationClassPreviousYear | 1 | |
| ValuationClassSalesOrderStock | ValuationClassSalesOrderStock | 1 | |
| ValuationMargin | ValuationMargin | 1 |
@AbapCatalog:{
sqlViewName: 'PPRDVALUATION',
compiler.compareFilter: true,
preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel:{
usageType.serviceQuality: #A,
usageType.sizeCategory : #L,
usageType.dataClass: #MASTER
}
@VDM.viewType: #BASIC
@VDM.private: true
// Scope of this view is V_MBEW _MD no fields from redirect views should be added
define view P_ProductValuationBasic
as select from mbew as Valuation
association [1..1] to I_Product as _Product on $projection.Product = _Product.Product
{
key cast ( Valuation.matnr as productnumber preserving type ) as Product,
key Valuation.bwkey as ValuationArea,
key Valuation.bwtar as ValuationType,
Valuation.lvorm as IsMarkedForDeletion,
cast (Valuation.vprsv as inventoryvaluationprocedure preserving type ) as InventoryValuationProcedure,
Valuation.verpr as MovingAveragePrice,
Valuation.stprs as StandardPrice,
Valuation.peinh as PriceUnitQty,
Valuation.bklas as ValuationClass,
Valuation.vmvpr as ProdPrcControlInPreviousPeriod,
Valuation.vmver as MvgAvgPriceInPreviousPeriod,
Valuation.vmstp as StandardPriceInPreviousPeriod,
Valuation.vmpei as ProdPrcUntQtyInPreviousPeriod,
Valuation.vmbkl as ValuationClassPreviousPeriod,
Valuation.vjvpr as ProdPriceControlInPreviousYear,
Valuation.vjver as MvgAveragePriceInPreviousYear,
Valuation.vjstp as StandardPricePrevYear,
Valuation.vjpei as ProdPrcUntQtyInPreviousYear,
Valuation.vjbkl as ValuationClassPreviousYear,
Valuation.lfgja as FiscalYearCurrentPeriod,
Valuation.lfmon as FiscalMonthCurrentPeriod,
Valuation.bwtty as ValuationCategory,
Valuation.stprv as PrevInvtryPriceInCoCodeCrcy,
Valuation.laepr as PriceLastChangeDate,
Valuation.zkprs as FuturePrice,
Valuation.zkdat as FuturePriceValidityStartDate,
Valuation.bwprs as TaxPricel1InCoCodeCrcy,
Valuation.bwprh as CommercialPrice1InCoCodeCrcy,
Valuation.vjbws as TaxPrice3InCoCodeCrcy,
Valuation.vjbwh as CommercialPrice3InCoCodeCrcy,
Valuation.zplpr as PlannedPrice,
Valuation.zplp1 as PlannedPrice1InCoCodeCrcy,
Valuation.zplp2 as PlannedPrice2InCoCodeCrcy,
Valuation.zplp3 as PlannedPrice3InCoCodeCrcy,
Valuation.zpld1 as FuturePlndPrice1ValdtyDate,
Valuation.zpld2 as FuturePlndPrice2ValdtyDate,
Valuation.zpld3 as FuturePlndPrice3ValdtyDate,
Valuation.pperl as ProdSpecCompUpperLimitQuantity,
Valuation.pperv as PCEctxPHScaleUprValTxt,
Valuation.kalkz as OperationIsIncludedInCosting,
Valuation.kalkl as HasStdCostEstForCurrentPeriod,
Valuation.kalkv as HasStdCostEstForPreviousPeriod,
cast (Valuation.xlifo as boole_d preserving type) as IsLIFOAndFIFORelevant,
Valuation.mypol as LIFOValuationPoolNumber,
Valuation.bwph1 as CommercialPrice2InCoCodeCrcy,
Valuation.bwps1 as TaxPrice2InCoCodeCrcy,
Valuation.abwkz as DevaluationYearCount,
Valuation.pstat as MaintenanceStatus,
Valuation.kaln1 as ProdCostEstNumber,
Valuation.kalnr as CostEstimateNumberOfOutput,
Valuation.bwva1 as FutrCostEstValuationVariant,
Valuation.bwva2 as CurCostEstValuationVariant,
Valuation.bwva3 as PrevCostEstValuationVariant,
Valuation.vers1 as FutureCostEstCostingVersion,
Valuation.vers2 as CurrentCostEstCostingVersion,
Valuation.vers3 as PreviousCostEstCostingVersion,
Valuation.hrkft as CostOriginGroup,
Valuation.kosgr as CostingOverheadGroup,
Valuation.pprdz as FutureCostEstimateFiscalPeriod,
Valuation.pprdl as CurrentCostEstFiscalPeriod,
Valuation.pprdv as PreviousCostEstFiscalPeriod,
Valuation.pdatz as FutureCostEstFiscalYear,
Valuation.pdatl as CurrentCostEstFiscalYear,
Valuation.pdatv as PreviousCostEstFiscalYear,
Valuation.ekalr as IsMaterialCostedWithQtyStruc,
Valuation.vplpr as PreviousPlanPriceInCoCodeCrcy,
Valuation.mlast as PriceDeterminationControl,
Valuation.lplpr as DairyCurrentPlannedPrice,
Valuation.hkmat as IsMaterialRelatedOrigin,
Valuation.bwspa as ValuationMargin,
Valuation.lplpx as FxdPortnOfPlanPrcInCoCodeCrcy,
Valuation.vplpx as FxdPortOfPrevPlPrcInCoCodeCrcy,
Valuation.lbwst as CurPlanProjSlsOrdValnStrategy,
Valuation.vbwst as PrevPlanProjSlsOrdValnStrategy,
Valuation.eklas as ValuationClassSalesOrderStock,
Valuation.qklas as ProjectStockValuationClass,
cast (Valuation.mtuse as productusagetype preserving type ) as ProductUsageType,
cast (Valuation.mtorg as productorigintype preserving type ) as ProductOriginType,
Valuation.ownpr as IsProducedInhouse,
Valuation.bwpei as TaxBasedPricesPriceUnitQty,
Valuation.mlmaa as MLIsActiveAtProductLevel,
_Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MBEW"
],
"ASSOCIATED":
[
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/