P_QuantityContractRelHistory

DDL: P_QUANTITYCONTRACTRELHISTORY SQL: PQTYCONTRACTR Type: view CONSUMPTION

P_QuantityContractRelHistory is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchaseContractHistory, P_QuantityContract) and exposes 21 fields.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchaseContractHistory I_PurchaseContractHistory left_outer
P_QuantityContract P_QuantityContract from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName PQTYCONTRACTR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (21)

KeyFieldSource TableSource FieldDescription
PurchaseContract P_QuantityContract PurchaseContract
PurchaseContractItem P_QuantityContract PurchaseContractItem
ReleaseOrder ReleaseOrder
CalendarYear CalendarYear
CalendarQuarter CalendarQuarter
CalendarMonth CalendarMonth
CalendarWeek CalendarWeek
OrderQuantityUnit OrderQuantityUnit
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
TargetQuantity TargetQuantity
TargetAmount TargetAmount
ReleaseOrderItemNetAmount I_PurchaseContractHistory ReleaseOrderItemNetAmount
ReleaseOrderItemOrderQuantity I_PurchaseContractHistory ReleaseOrderItemOrderQuantity
ReleaseOrderCurrency I_PurchaseContractHistory ReleaseOrderCurrency
ReleaseOrderItemLastChgDate I_PurchaseContractHistory ReleaseOrderItemLastChgDate
PurchaseContractType PurchaseContractType
PurchasingGroup PurchasingGroup
PurchasingOrganization I_PurchaseContractHistory PurchasingOrganization
Plant P_QuantityContract Plant
CONT_LEN CONT_LEN 
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory: #L 
@AbapCatalog.sqlViewName: 'PQTYCONTRACTR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK

@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_QuantityContractRelHistory as select from P_QuantityContract 
left outer join I_PurchaseContractHistory on 
    P_QuantityContract.PurchaseContract       = I_PurchaseContractHistory.PurchaseContract and
    P_QuantityContract.PurchaseContractItem   = I_PurchaseContractHistory.PurchaseContractItem

{
    P_QuantityContract.PurchaseContract, 
    P_QuantityContract.PurchaseContractItem, 
    ReleaseOrder,
    CalendarYear, 
    CalendarQuarter, 
    CalendarMonth, 
    CalendarWeek,
    OrderQuantityUnit, 
    ValidityStartDate,
    ValidityEndDate,
    TargetQuantity, 
    TargetAmount, 
    I_PurchaseContractHistory.ReleaseOrderItemNetAmount, 
    I_PurchaseContractHistory.ReleaseOrderItemOrderQuantity,
    I_PurchaseContractHistory.ReleaseOrderCurrency,
    I_PurchaseContractHistory.ReleaseOrderItemLastChgDate,
    PurchaseContractType,
    PurchasingGroup,
    I_PurchaseContractHistory.PurchasingOrganization,
    P_QuantityContract.Plant, 
    CONT_LEN
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTHISTORY",
"P_QUANTITYCONTRACT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More