P_PRODUCTVALUATIOND

CDS View

P_PRODUCTVALUATIOND is a CDS View in S/4HANA. It contains 18 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 18 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
P_Productmlaccountwd view inner COMPOSITE
P_ProductValuationWD view left_outer COMPOSITE
P_ProductValuationWD view union_all COMPOSITE

Fields (18)

KeyField CDS FieldsUsed in Views
KEY ActiveInventoryValuationType ActiveInventoryValuationType 1
KEY ActiveProduct ActiveProduct 1
KEY ActiveValuationArea ActiveValuationArea 1
inventoryvaluationprocedure inventoryvaluationprocedure 1
isproducedinhouse isproducedinhouse 1
movingaverageprice movingaverageprice 1
ParentDraftKey ParentDraftKey 1
pricedeterminationcontrol pricedeterminationcontrol 1
priceunitqty priceunitqty 1
prodcostestnumber prodcostestnumber 1
productorigintype productorigintype 1
productusagetype productusagetype 1
standardprice standardprice 1
valuationarea valuationarea 2
valuationcategory valuationcategory 1
valuationclass valuationclass 1
valuationmargin valuationmargin 1
valuationtype valuationtype 2 
// Product Valuation (draft)

@AbapCatalog.sqlViewName: 'PPRDVALUATIOND'
@VDM.private: true
@VDM.viewType: #BASIC 
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_ProductValuationD as select from prd_valuation as DraftDocument
{      
   key DraftDocument.draftkey                                              as Draftkey,
        key DraftDocument.activeproduct                                         as ActiveProduct,        
        key DraftDocument.activevaluationarea                                   as ActiveValuationArea,
        key DraftDocument.activeinventoryvaluationtype                          as ActiveInventoryValuationType,
        DraftDocument.parentdraftkey                                            as ParentDraftKey ,         
        DraftDocument.valuationarea,
        DraftDocument.valuationtype,          
        DraftDocument.valuationclass, 
        DraftDocument.pricedeterminationcontrol, 
        DraftDocument.taxclassificationcategory, 
        DraftDocument.valuationclassinprevyear, 
        DraftDocument.valuationclassinprevperiod,  
        DraftDocument.fiscalmonthcurrentperiod,
        DraftDocument.fiscalyearcurrentperiod,
        DraftDocument.standardprice,
        DraftDocument.priceunitqty,
        DraftDocument.inventoryvaluationprocedure,
        DraftDocument.futureevaluatedamountvalue,
        DraftDocument.futurepricevaliditystartdate, 
        DraftDocument.totalvalstockquantity,
        DraftDocument.movingaverageprice,
        DraftDocument.totalvalstockprevperiod,
        DraftDocument.totalvalstockprevperiodvalue,
        DraftDocument.totalvalstockprevyear,
        DraftDocument.totalvalstockprevyearvalue,
        DraftDocument.valuationcategory,
        DraftDocument.totalvalstockvalue,
        DraftDocument.productusagetype,
        DraftDocument.productorigintype,
        DraftDocument.isproducedinhouse,
        DraftDocument.valnclsforspclstkatvndr,
        DraftDocument.prodcostestnumber,
        DraftDocument.costestimatenumber,
        DraftDocument.ismarkedfordeletion,
        DraftDocument.hasactiveentity  ,
        
        //Retail field,

        DraftDocument.valuationmargin 
}  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PRD_VALUATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More