C_PurchaseContractHdr

DDL: C_PURCHASECONTRACTHDR SQL: CMMPURHDR Type: view CONSUMPTION

Purchase Contract Header View

C_PurchaseContractHdr is a Consumption CDS View that provides data about "Purchase Contract Header View" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContract) and exposes 23 fields with key field PurchaseContract. It has 3 associations to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContract PurchaseContract from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_SupplierDetails _Supplier _Supplier.Supplier = $projection.Supplier
[1..*] C_PurchaseContractItem _PurCtrItem _PurCtrItem.PurchaseContract = $projection.PurchaseContract
[0..*] I_PurCtrCond _PurContHdrCond _PurContHdrCond.PurchaseContract = $projection.PurchaseContract

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMMPURHDR view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Contract Header View view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContract PurchaseContract
PurchaseContractType I_PurchaseContract PurchaseContractType
CreationDate I_PurchaseContract CreationDate
CreatedByUser I_PurchaseContract CreatedByUser
SupplierRespSalesPersonName I_PurchaseContract SupplierRespSalesPersonName
ValidityStartDate I_PurchaseContract ValidityStartDate
ValidityEndDate I_PurchaseContract ValidityEndDate
IncotermsClassification I_PurchaseContract IncotermsClassification
IncotermsTransferLocation I_PurchaseContract IncotermsTransferLocation
DocumentCurrency I_PurchaseContract DocumentCurrency
SupplierQuotation I_PurchaseContract SupplierQuotation
QuotationSubmissionDate I_PurchaseContract QuotationSubmissionDate
CorrespncExternalReference I_PurchaseContract CorrespncExternalReference
PaymentTerms I_PurchaseContract PaymentTerms
PurchaseContractTargetAmount I_PurchaseContract PurchaseContractTargetAmount
Supplier I_PurchaseContract Supplier
IncotermsVersion I_PurchaseContract IncotermsVersion
PurchasingGroup I_PurchaseContract PurchasingGroup
PurchasingOrganization I_PurchaseContract PurchasingOrganization
IsEndOfPurposeBlocked I_PurchaseContract IsEndOfPurposeBlocked
_Supplier _Supplier
_PurCtrItem _PurCtrItem
_PurContHdrCond _PurContHdrCond 
@AbapCatalog.sqlViewName: 'CMMPURHDR'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Contract Header View' 

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AccessControl.personalData.blocking:#REQUIRED
 

define view C_PurchaseContractHdr
  as select from I_PurchaseContract as PurchaseContract

  association [0..*] to C_SupplierDetails      as _Supplier       on _Supplier.Supplier = $projection.Supplier
        
  association [1..*] to C_PurchaseContractItem as _PurCtrItem     on _PurCtrItem.PurchaseContract = $projection.PurchaseContract

  association [0..*] to I_PurCtrCond           as _PurContHdrCond on _PurContHdrCond.PurchaseContract = $projection.PurchaseContract

{
      //Key

  key PurchaseContract.PurchaseContract,
     PurchaseContract.PurchaseContractType,
      PurchaseContract.CreationDate,
      PurchaseContract.CreatedByUser,   
      PurchaseContract.SupplierRespSalesPersonName,
      @Semantics.businessDate.createdAt
      PurchaseContract.ValidityStartDate,
      PurchaseContract.ValidityEndDate,
      PurchaseContract.IncotermsClassification,
      PurchaseContract.IncotermsTransferLocation,
      PurchaseContract.DocumentCurrency,
      PurchaseContract.SupplierQuotation,
      PurchaseContract.QuotationSubmissionDate,
      PurchaseContract.CorrespncExternalReference,
      PurchaseContract.PaymentTerms,
      PurchaseContract.PurchaseContractTargetAmount,
      PurchaseContract.Supplier,
      PurchaseContract.IncotermsVersion,
      PurchaseContract.PurchasingGroup,
      PurchaseContract.PurchasingOrganization,
      PurchaseContract.IsEndOfPurposeBlocked,
      
      _Supplier,
      _PurCtrItem,
      _PurContHdrCond 
} 
  

  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACT"
],
"ASSOCIATED":
[
"C_PURCHASECONTRACTITEM",
"C_SUPPLIERDETAILS",
"I_PURCTRCOND"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More