C_PurOrdRefPurConItm

DDL: C_PURORDREFPURCONITM SQL: CPOREFTOPCON Type: view CONSUMPTION

Purchase Contract Item

C_PurOrdRefPurConItm is a Consumption CDS View that provides data about "Purchase Contract Item" in SAP S/4HANA. It has 1 association to related views.

11 fields

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PurchasingDocumentTypeText _PurchasingDocumentTypeText $projection.PurchaseContractType = _PurchasingDocumentTypeText.PurchasingDocumentType and $projection.PurchasingDocumentCategory = _PurchasingDocumentTypeText.PurchasingDocumentCategory

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Contract Item view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CPOREFTOPCON view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract P_AssocPurOrdItmPurConItm PurchaseContract
KEY PurchaseContractItem P_AssocPurOrdItmPurConItm PurchaseContractItem
KEY PurchaseOrder P_AssocPurOrdItmPurConItm PurchaseOrder
OrderQuantityUnit OrderQuantityUnit
ReleasedQuantity ReleasedQuantity
TargetQuantity TargetQuantity
PurchaseContractType PurchaseContractType
PurchasingDocumentCategory PurchasingDocumentCategory
Plant Plant
StorageLocation StorageLocation
_PurchasingDocumentTypeText _PurchasingDocumentTypeText 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@EndUserText.label: 'Purchase Contract Item' 
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK  
@AbapCatalog.sqlViewName: 'CPOREFTOPCON' 
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

define view C_PurOrdRefPurConItm 
   as select distinct from P_AssocPurOrdItmPurConItm
 
association [0..*] to I_PurchasingDocumentTypeText  as _PurchasingDocumentTypeText
   on $projection.PurchaseContractType       =  _PurchasingDocumentTypeText.PurchasingDocumentType  and
      $projection.PurchasingDocumentCategory =  _PurchasingDocumentTypeText.PurchasingDocumentCategory
    
{ 
      @Consumption.semanticObject: 'PurchaseContract'
      key P_AssocPurOrdItmPurConItm.PurchaseContract,
  
      @UI.lineItem: [{ 
             qualifier: 'ContrItem',
             position: 10, 
             importance: #HIGH }, {
             position: 10, 
             importance: #HIGH }]
      @Consumption.semanticObject: 'PurchaseContractItem' 
      key P_AssocPurOrdItmPurConItm.PurchaseContractItem,
      
      key P_AssocPurOrdItmPurConItm.PurchaseOrder,   
    
      @Semantics.unitOfMeasure: true
      OrderQuantityUnit,       
     
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @UI.lineItem: [{ 
             qualifier: 'ContrItem',
             position: 30, 
             importance: #HIGH }, {
             position: 30, 
             importance: #HIGH }]
      ReleasedQuantity,
      
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      @UI.lineItem: [{ 
             qualifier: 'ContrItem',
             position: 40, 
             importance: #HIGH }, {
             position: 40, 
             importance: #HIGH }]
      TargetQuantity, 
      
      @ObjectModel.text.association: '_PurchasingDocumentTypeText'
      @UI.lineItem: [{ 
             qualifier: 'ContrItem',
             position: 20, 
             importance: #HIGH }, {
             position: 20, 
             importance: #HIGH }]
      PurchaseContractType,
      
      PurchasingDocumentCategory,
      
      Plant,
      
      StorageLocation,
  
      // associations

      _PurchasingDocumentTypeText
      
}
                                                                                                                                                 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ASSOCPURORDITMPURCONITM"
],
"ASSOCIATED":
[
"I_PURCHASINGDOCUMENTTYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More