P_PURCONTRACTVALIDITY

CDS View

Purchase Contract Validity

P_PURCONTRACTVALIDITY is a CDS View in S/4HANA. Purchase Contract Validity. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_ContractStatusValueHelp view from CONSUMPTION Contract Status Value Help
P_ContractItemStatus view from CONSUMPTION Contract Item Status

Fields (4)

KeyField CDS FieldsUsed in Views
KEY PurchaseContract PurchaseContract 2
KEY PurchaseContractItem PurchaseContractItem 2
ValidityEndDate ValidityEndDate 2
ValidityStartDate ValidityStartDate 2 
@AbapCatalog.sqlViewName: 'PPCVALIDITY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Purchase Contract Validity'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
//@Search.searchable: true


define view P_PurContractValidity

  as select from P_PurchaseContractStatus( P_Date: $session.system_date) as ContractStatus

//This association has been commented to fix the issue described in incident 2080182728. Please do not remove.

//  association [0..*] to I_PurContrValidityText as _ValidityText on $projection.PurchaseContractValidityStatus = _ValidityText.PurchaseContractValidityStatus


{
  key ContractStatus.PurchaseContract,
  key ContractStatus.PurchaseContractItem,

      // @Search: { defaultSearchElement: true, ranking: #HIGH }

      ContractStatus.ValidityEndDate,
      // @Search: { defaultSearchElement: true, ranking: #HIGH }

      ContractStatus.ValidityStartDate,

      //Validity Status

      // @Search: { defaultSearchElement: true, ranking: #HIGH }

      cast(case when ContractStatus.ValidityEndDate < $session.system_date  //Expired

                  then '03'
                when ContractStatus.ValidityEndDate >= $session.system_date and PurchaseContractValidityStatus > 0.900   //Expiring ( 90 percent completion status achieved)

                  then '01'
                else '02'                                // Valid

      end as mm_contract_status_id ) as PurchaseContractValidityStatus,
      ContractStatus.PurchaseContractType,
      ContractStatus.PurchasingOrganization,
      ContractStatus.PurchasingGroup,
      Plant
      
      //This association has been commented to fix the issue described in incident 2080182728. Please do not remove.

      //_ValidityText


}

Learn More