P_PurchaseContractItemSOS

DDL: P_PURCHASECONTRACTITEMSOS SQL: PMMPURPCISOS Type: view COMPOSITE

P_PurchaseContractItemSOS is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 5 fields with key fields PurchaseContract, PurchaseContractItem.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from

Annotations (8)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
Material Material
Plant Plant
MaterialGroup MaterialGroup 
@AbapCatalog.sqlViewName: 'PMMPURPCISOS' 
//@EndUserText.label: 'Maintain contract item for sos'

 @AbapCatalog.preserveKey: true 
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE 
@VDM.private: true
@VDM.viewType: #COMPOSITE   
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_PurchaseContractItemSOS as select from I_PurchaseContractItem {
    key  PurchaseContract,
    key  PurchaseContractItem,
    Material,
    Plant,
    MaterialGroup
    
}where  (PurchasingContractDeletionCode = ''
  or  PurchasingContractDeletionCode = ' ')
  and Material != ''
  and _PurchaseContract.PurgDocChangeRequestStatus = '' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More