P_PurContrItmCalcdFields

DDL: P_PURCONTRITMCALCDFIELDS SQL: PCTRITMCALCFLDS Type: view CONSUMPTION

Purchase Contract Item Calculated Fields

P_PurContrItmCalcdFields is a Consumption CDS View that provides data about "Purchase Contract Item Calculated Fields" in SAP S/4HANA. It reads from 1 data source (P_PurContrAggrgdItmFields) and exposes 17 fields with key fields PurchaseContract, PurchaseContractItem.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
P_PurContrAggrgdItmFields P_PurContrAggrgdItmFields from

Parameters (2)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_Date sydatum

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PCTRITMCALCFLDS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Contract Item Calculated Fields view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
ReleaseOrderItemNetAmount ReleaseOrderItemNetAmount
QuantityReleasedTillDate QuantityReleasedTillDate
ReleaseOrderDate ReleaseOrderDate
InvoicedAmountInDspCurrency InvoicedAmountInDspCurrency
PurchasingGroup PurchasingGroup
PurchasingOrganization PurchasingOrganization
PurContrLatestRelease
Supplier Supplier
Plant Plant
CompanyCode CompanyCode
MaterialGroup MaterialGroup
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
NoOfDaysFromValidityStart
NoOfDaysBtwnValidityStrtAndEnd 
@AbapCatalog.sqlViewName: 'PCTRITMCALCFLDS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Purchase Contract Item Calculated Fields'
define view P_PurContrItmCalcdFields
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_Date            : sydatum
  as select from P_PurContrAggrgdItmFields ( P_DisplayCurrency: $parameters.P_DisplayCurrency ) as _PurContrAgg
{
  key PurchaseContract,
  key PurchaseContractItem,

      ReleaseOrderItemNetAmount,
      QuantityReleasedTillDate,
      ReleaseOrderDate,
      InvoicedAmountInDspCurrency,

      PurchasingGroup,
      PurchasingOrganization,
      dats_days_between( ReleaseOrderDate, $parameters.P_Date )        as PurContrLatestRelease,
      Supplier,
      Plant,
      CompanyCode,
      MaterialGroup,
      ValidityStartDate,
      ValidityEndDate,

      dats_days_between( ValidityStartDate , $parameters.P_Date ) * 10 as NoOfDaysFromValidityStart,

      dats_days_between( ValidityStartDate , ValidityEndDate ) * 9     as NoOfDaysBtwnValidityStrtAndEnd
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PURCONTRAGGRGDITMFIELDS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More