P_ContractItemStatus

DDL: P_CONTRACTITEMSTATUS SQL: PCONTRITEMVAL Type: view CONSUMPTION Package: ODATA_MM_PUR_CTRITEM_MNTR

Contract Item Status

P_ContractItemStatus is a Consumption CDS View that provides data about "Contract Item Status" in SAP S/4HANA. It reads from 1 data source (P_PurContractValidity) and exposes 8 fields with key fields PurchaseContract, PurchaseContractItem. It has 1 association to related views. Part of development package ODATA_MM_PUR_CTRITEM_MNTR.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_PurContractValidity ContractStatus from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PurContrValidityText _ValidityText $projection.PurchaseContractValidityStatus = _ValidityText.PurchaseContractValidityStatus

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCONTRITEMVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Contract Item Status view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract P_PurContractValidity PurchaseContract
KEY PurchaseContractItem P_PurContractValidity PurchaseContractItem
ValidityEndDate P_PurContractValidity ValidityEndDate
ValidityStartDate P_PurContractValidity ValidityStartDate
PurchaseContractValidityStatus PurchaseContractValidityStatus
PurContrValidityStatusName
NumberOfContractItems
_ValidityText _ValidityText 
@AbapCatalog.sqlViewName: 'PCONTRITEMVAL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Contract Item Status'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
//@Search.searchable: true


define view P_ContractItemStatus

  as select from P_PurContractValidity as ContractStatus

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

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

  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 }

      PurchaseContractValidityStatus,

      @Semantics.text: true
      _ValidityText[1: Language = $session.system_language].PurContrValidityStatusName          as PurContrValidityStatusName,

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

      //  max( ContractHistory.ReleaseOrderDate) as ReleaseOrderDate,


      @DefaultAggregation: #SUM
      cast( 1 as  mm_a_contractitems )                                                          as NumberOfContractItems,
      _ValidityText


}

Learn More