C_PurOrdMaintainCtrItemValHelp

DDL: C_PURORDMAINTAINCTRITEMVALHELP SQL: CPOMAINTVHCTRITM Type: view CONSUMPTION

Contract Item Value Help

C_PurOrdMaintainCtrItemValHelp is a Consumption CDS View that provides data about "Contract Item Value Help" in SAP S/4HANA. It reads from 3 data sources (I_PurchaseContract, I_PurchaseContractItem, I_Supplier) and exposes 13 fields with key fields PurchaseContract, PurchaseContractItem. It has 2 associations to related views.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
I_PurchaseContract header left_outer
I_PurchaseContractItem item from
I_Supplier supplier left_outer

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material
[0..1] I_Plant I_plant $projection.Plant = I_plant.Plant

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPOMAINTVHCTRITM view
EndUserText.label Contract Item Value Help view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem
Supplier I_PurchaseContract Supplier
SupplierName I_Supplier SupplierName
CreationDate I_PurchaseContract CreationDate
Material Material
Plant Plant
PurchaseContractItemText PurchaseContractItemText
PlantName I_plant PlantName
PurchaseContractType I_PurchaseContract PurchaseContractType
PurchasingOrganization I_PurchaseContract PurchasingOrganization
PurchasingGroup I_PurchaseContract PurchasingGroup
_MaterialText _MaterialText 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CPOMAINTVHCTRITM'
@EndUserText.label: 'Contract Item Value Help'
@AccessControl.authorizationCheck: #CHECK

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view C_PurOrdMaintainCtrItemValHelp 
  as select from I_PurchaseContractItem   as item
   left outer join I_PurchaseContract     as header   on item.PurchaseContract = header.PurchaseContract
   left outer join I_Supplier             as supplier on header.Supplier       = supplier.Supplier   
   association [0..*] to I_MaterialText   as _MaterialText     on $projection.Material = _MaterialText.Material  
   association [0..1] to I_Plant          as I_plant           on $projection.Plant    = I_plant.Plant
     
 {
  key item.PurchaseContract         as PurchaseContract,
  key item.PurchaseContractItem     as PurchaseContractItem,
      header.Supplier               as Supplier, 
      supplier.SupplierName         as SupplierName, 
      header.CreationDate           as CreationDate,
      Material                      as Material,
      Plant                         as Plant,
      PurchaseContractItemText      as PurchaseContractItemText,
      I_plant.PlantName             as PlantName,
      header.PurchaseContractType   as PurchaseContractType,
      header.PurchasingOrganization as PurchasingOrganization,
      header.PurchasingGroup        as PurchasingGroup,
     _MaterialText     
 }                                                                                                                            
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PLANT",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_MATERIALTEXT",
"I_PLANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More