P_PurOrdMaintainItemActCalcPrc

DDL: P_PURORDMAINTAINITEMACTCALCPRC SQL: PPOMAINTITMACTCP Type: view CONSUMPTION

P_PurOrdMaintainItemActCalcPrc is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_Plant, I_PurchaseOrderItem) and exposes 4 fields with key fields PurchaseOrder, PurchaseOrderItem.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_Plant plant left_outer
I_PurchaseOrderItem po_item from

Annotations (4)

NameValueLevelField
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PPOMAINTITMACTCP view
VDM.private true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem
TaxCalculationProcedure
TaxJurisdictionCalcProcedure 
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PPOMAINTITMACTCP'
@VDM.private: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

define view P_PurOrdMaintainItemActCalcPrc 

  as select from I_PurchaseOrderItem as po_item
  
    left outer join I_Plant   as plant   on po_item.Plant = plant.Plant 
    
{
  key po_item.PurchaseOrder                           as PurchaseOrder,
  key po_item.PurchaseOrderItem                       as PurchaseOrderItem,
      plant._Address._Country.TaxCalculationProcedure as TaxCalculationProcedure,
      cast('' as abap.char(6))                        as TaxJurisdictionCalcProcedure
}

Learn More