P_QuantityContractWithHistory

DDL: P_QUANTITYCONTRACTWITHHISTORY SQL: PQTYCONTRHISTPAI Type: view CONSUMPTION

P_QuantityContractWithHistory is a Consumption CDS View in SAP S/4HANA. It reads from 4 data sources (I_PurContractClassification, I_PurchaseContractHistory, I_PurchaseContract, I_PurchaseContractItem) and exposes 10 fields.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
I_PurContractClassification ContractClassification inner
I_PurchaseContractHistory History from
I_PurchaseContract PurchaseContract inner
I_PurchaseContractItem PurchaseContractItem inner

Annotations (8)

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

Fields (10)

KeyFieldSource TableSource FieldDescription
PurchaseContract I_PurchaseContractHistory PurchaseContract
PurchaseContractItem I_PurchaseContractHistory PurchaseContractItem
PurchaseContractType I_PurchaseContract PurchaseContractType
ReleaseOrder ReleaseOrder
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
TargetQuantity TargetQuantity
TargetAmount TargetAmount
ReleaseOrderItemOrderQuantity ReleaseOrderItemOrderQuantity
CONT_LEN 
@AbapCatalog.sqlViewName: 'PQTYCONTRHISTPAI'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true 
@ClientHandling.algorithm: #SESSION_VARIABLE   
@VDM.viewType: #CONSUMPTION
@VDM.private : true 
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_QuantityContractWithHistory 
  as select from I_PurchaseContractHistory   as History
    inner join   I_PurchaseContractItem      as PurchaseContractItem   on  History.PurchaseContract     = PurchaseContractItem.PurchaseContract
                                                                       and History.PurchaseContractItem = PurchaseContractItem.PurchaseContractItem
    inner join   I_PurchaseContract          as PurchaseContract       on PurchaseContractItem.PurchaseContract = PurchaseContract.ActivePurchasingDocument

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

{
  History.PurchaseContract,
  History.PurchaseContractItem,
  
  PurchaseContract.PurchaseContractType,

  ReleaseOrder,  

  ValidityStartDate,
  ValidityEndDate,
  TargetQuantity,
  TargetAmount,

  ReleaseOrderItemOrderQuantity,
  
  dats_days_between(ValidityStartDate, ValidityEndDate) as CONT_LEN

}
where
  ContractClassification.PurchaseContractClassification = '1' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTHISTORY",
"I_PURCHASECONTRACTITEM",
"I_PURCONTRACTCLASSIFICATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More