P_QUANTITYCONTRACT

CDS View

P_QUANTITYCONTRACT is a CDS View in S/4HANA. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_QuantityContractRelHistory view from CONSUMPTION

Fields (3)

KeyField CDS FieldsUsed in Views
Plant Plant 1
PurchaseContract PurchaseContract 1
PurchaseContractItem PurchaseContractItem 1 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory: #L 
@AbapCatalog.sqlViewName: 'PQTYCONTRACT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view P_QuantityContract as select from I_PurchaseContractItem as PurchaseContractItem

inner join I_PurchaseContract as PurchaseContract
    on  PurchaseContractItem.PurchaseContract = PurchaseContract.ActivePurchasingDocument

inner join I_CalendarDate  as RelevantDates
    on  PurchaseContract.ValidityStartDate = RelevantDates.CalendarDate

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

//left outer join I_PurchaseContractHistory on 

//    PurchaseContractItem.PurchaseContract       = I_PurchaseContractHistory.PurchaseContract and

//    PurchaseContractItem.PurchaseContractItem   = I_PurchaseContractHistory.PurchaseContractItem



//left outer join P_ReleaseDocumentationValues3 as ReleaseDocumentation

//    on  PurchaseContractItem.PurchaseContract = ReleaseDocumentation.PurchaseContract

//    and PurchaseContractItem.PurchaseContractItem = ReleaseDocumentation.PurchaseContractItem

{
  PurchaseContract.ActivePurchasingDocument as PurchaseContract,
  PurchaseContract.PurchaseContractType,

    PurchaseContract.PurchasingOrganization,
    PurchaseContract.PurchasingGroup,
    Plant,
    PurchaseContractItem.PurchaseContractItem, 
    CalendarYear, 
    CalendarQuarter, 
    CalendarMonth, 
    CalendarWeek,
    OrderQuantityUnit, 
    PurchaseContract.ValidityStartDate,
    PurchaseContract.ValidityEndDate,
    TargetQuantity, 
    TargetAmount, 
   
//    ReleaseOrderItemNetAmount, 

//    ReleaseOrderItemOrderQuantity,

//    ReleaseOrderCurrency,

//    ReleaseOrderItemLastChgDate,

    dats_days_between(ValidityStartDate, ValidityEndDate) as CONT_LEN
    
} 
  where ContractClassification.PurchaseContractClassification = '1' and ValidityEndDate!='00000000' and ValidityStartDate!= '00000000' and PurchaseContract.IsEndOfPurposeBlocked = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURCONTRACTCLASSIFICATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More