P_CONTRACTAMOUNT

DDL: P_CONTRACTAMOUNT SQL: PCNTRCTAMT Type: view CONSUMPTION

Private View for Casting Amount

P_CONTRACTAMOUNT is a Consumption CDS View that provides data about "Private View for Casting Amount" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 6 fields with key fields PurchaseContract, PurchaseContractItem.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem PurchaseContractItem from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCNTRCTAMT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Private View for Casting Amount view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem
TargetAmount
ContractNetPriceAmount
PurchaseContractTargetAmount
DocumentCurrency DocumentCurrency 
@AbapCatalog.sqlViewName: 'PCNTRCTAMT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Private View for Casting Amount'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
define view P_CONTRACTAMOUNT as select from I_PurchaseContractItem as PurchaseContractItem{

  key PurchaseContractItem.PurchaseContract,

  key PurchaseContractItem.PurchaseContractItem,
    
    @Semantics.amount.currencyCode: 'DocumentCurrency'
   @DefaultAggregation: #SUM
      cast( PurchaseContractItem.ContractNetPriceAmount as abap.curr(18, 2))                        as TargetAmount,

      @Semantics.amount.currencyCode: 'DocumentCurrency'
      cast( PurchaseContractItem.ContractNetPriceAmount as abap.curr(18, 2))                        as ContractNetPriceAmount,
      
                                                                                                                                                   

   
      @Semantics.amount.currencyCode: 'DocumentCurrency'
  //    PurchaseContractItem._PurchaseContract.PurchaseContractTargetAmount

      cast( PurchaseContractItem._PurchaseContract.PurchaseContractTargetAmount as abap.curr(18, 2))           as PurchaseContractTargetAmount,
      
      @Semantics.currencyCode: true
      DocumentCurrency
      
    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More