P_ReleaseDocumentationValues4

DDL: P_RELEASEDOCUMENTATIONVALUES4 SQL: PMMRELDOCVAL4 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Released Documentation Values 4

P_ReleaseDocumentationValues4 is a Consumption CDS View that provides data about "Released Documentation Values 4" in SAP S/4HANA. It reads from 3 data sources (I_PurchaseContract, I_PurchaseContractItem, I_PurContractClassification) and exposes 20 fields with key fields PurchaseContract, PurchaseContractItem, identifier. Part of development package ODATA_MM_ANALYTICS.

3 data source(s) 20 fields

Data Sources (3)

SourceAliasJoin Type
I_PurchaseContract PurchaseContract inner
I_PurchaseContractItem PurchaseContractItem from
I_PurContractClassification PurContractClassification inner

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PMMRELDOCVAL4 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem
KEY identifier
PurchaseContractType I_PurchaseContract PurchaseContractType
TargetAmount
PurchaseContractTargetAmount
TargetQuantity TargetQuantity
ContractNetPriceAmount
Material I_PurchaseContractItem Material
MaterialGroup I_PurchaseContractItem MaterialGroup
Supplier I_PurchaseContract Supplier
CompanyCode I_PurchaseContract CompanyCode
PurchasingOrganization I_PurchaseContract PurchasingOrganization
PurchasingGroup I_PurchaseContract PurchasingGroup
ContractPlant I_PurchaseContractItem Plant
ValidityStartDate I_PurchaseContract ValidityStartDate
ValidityEndDate I_PurchaseContract ValidityEndDate
CreationDate I_PurchaseContract CreationDate
DocumentCurrency I_PurchaseContract DocumentCurrency
PurchaseContractClassification PurchaseContractClassification 
@AbapCatalog.sqlViewName: 'PMMRELDOCVAL4'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType : #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ReleaseDocumentationValues4
  with parameters
    P_StartDate       : bedat,
    P_EndDate         : bedat

  as select from I_PurchaseContractItem      as PurchaseContractItem

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


    inner join   I_PurContractClassification as PurContractClassification on PurchaseContract.PurchaseContractType = PurContractClassification.PurchasingDocumentType

{
  key PurchaseContractItem.PurchaseContract,

  key PurchaseContractItem.PurchaseContractItem                                                         as PurchaseContractItem,

  key concat( cast(PurchaseContract.ValidityStartDate as abap.char( 8 )),PurchaseContractItemUniqueID ) as identifier,

      PurchaseContract.PurchaseContractType,

      cast(TargetAmount as abap.curr(21,2))                                                             as TargetAmount,
      
      cast(PurchaseContractTargetAmount as abap.curr(21,2))                                             as PurchaseContractTargetAmount,

      TargetQuantity,

      cast(PurchaseContractItem.ContractNetPriceAmount as abap.curr(21,2))                              as ContractNetPriceAmount,

      PurchaseContractItem.Material,

      PurchaseContractItem.MaterialGroup,

      PurchaseContract.Supplier,

      PurchaseContract.CompanyCode,

      PurchaseContract.PurchasingOrganization,

      PurchaseContract.PurchasingGroup,

      PurchaseContractItem.Plant                                                                        as ContractPlant,

      PurchaseContract.ValidityStartDate,

      PurchaseContract.ValidityEndDate,

      PurchaseContract.CreationDate,

      PurchaseContract.DocumentCurrency,

      PurchaseContractClassification

}
where
        PurContractClassification.PurchaseContractClassification = '1'
  and   ValidityEndDate                                     >= $parameters.P_StartDate
  and   ValidityStartDate                                   <= $parameters.P_EndDate
  and   PurchaseContractItem.PurchasingContractDeletionCode = ''
  and   PurchaseContract.DocumentCurrency != ''
  and   PurchaseContract.DocumentCurrency                   is not null
  and   not(
      Material                                              = ''
      and IsStatisticalItem                                 = 'X'
    )

Learn More