P_ReleaseDocumentationForPC

DDL: P_RELEASEDOCUMENTATIONFORPC SQL: PMMRELVALPC Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Release Documentation For Contracts

P_ReleaseDocumentationForPC is a Consumption CDS View that provides data about "Release Documentation For Contracts" in SAP S/4HANA. It reads from 3 data sources (I_PurchaseContract, I_PurchaseContractHistory, I_PurchaseContractItem) and exposes 9 fields with key fields PurchaseContract, PurchaseContractItem, ReleaseOrder, ReleaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_PurchaseContract PurchaseContract inner
I_PurchaseContractHistory PurchaseContractHistory from
I_PurchaseContractItem PurchaseContractItem inner

Parameters (1)

NameTypeDefault
P_PurchaseContract ebeln

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PMMRELVALPC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Release Documentation For Contracts view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractHistory PurchaseContract
KEY PurchaseContractItem I_PurchaseContractHistory PurchaseContractItem
KEY ReleaseOrder I_PurchaseContractHistory ReleaseOrder
KEY ReleaseOrderItem I_PurchaseContractHistory ReleaseOrderItem
ReleaseOrderItemNetAmount
ReleaseOrderCurrency I_PurchaseContractHistory ReleaseOrderCurrency
DocumentCurrency I_PurchaseContract DocumentCurrency
ReleaseOrderDate I_PurchaseContractHistory ReleaseOrderDate
quan130asReleaseOrderItemOrderQuantity 
@AbapCatalog.sqlViewName: 'PMMRELVALPC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Release Documentation For Contracts'
define view P_ReleaseDocumentationForPC
  with parameters
    P_PurchaseContract : ebeln
  as select from I_PurchaseContractHistory as PurchaseContractHistory

    inner join   I_PurchaseContractItem    as PurchaseContractItem on  PurchaseContractItem.PurchaseContract     = PurchaseContractHistory.PurchaseContract
                                                                   and PurchaseContractItem.PurchaseContractItem = PurchaseContractHistory.PurchaseContractItem

    inner join   I_PurchaseContract        as PurchaseContract     on PurchaseContractItem.PurchaseContract = PurchaseContract.ActivePurchasingDocument


{
  key PurchaseContractHistory.PurchaseContract,

  key PurchaseContractHistory.PurchaseContractItem,

  key PurchaseContractHistory.ReleaseOrder,

  key PurchaseContractHistory.ReleaseOrderItem,

      cast(PurchaseContractHistory.ReleaseOrderItemNetAmount as abap.curr(21,2)) as ReleaseOrderItemNetAmount,
      PurchaseContractHistory.ReleaseOrderCurrency,
      PurchaseContract.DocumentCurrency,
      PurchaseContractHistory.ReleaseOrderDate,

      cast( unit_conversion
      (
         quantity    => ReleaseOrderItemOrderQuantity,
         source_unit => ReleaseOrderItemQuantityUnit,
         target_unit => PurchaseContractItem.OrderQuantityUnit,
         error_handling => 'KEEP_UNCONVERTED'
       ) as abap.quan( 13, 0 )  )                                                as ReleaseOrderItemOrderQuantity

}
where
      PurchaseContractHistory.PurchaseContract = $parameters.P_PurchaseContract
  and PurchaseContractHistory.ReleaseOrderCurrency != ''
  and PurchaseContract.DocumentCurrency != ''

Learn More