I_PurchaseContractAPI01

DDL: I_PURCHASECONTRACTAPI01 SQL: IPURCONTRAPI Type: view BASIC

Purchase Contract

I_PurchaseContractAPI01 is a Basic CDS View that provides data about "Purchase Contract" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContract) and exposes 39 fields with key field PurchaseContract. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContract I_PurchaseContract from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_PurchasingDocument _HeaderExtension $projection.PurchaseContract = _HeaderExtension.PurchasingDocument

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPURCONTRAPI view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
EndUserText.label Purchase Contract view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContract PurchaseContract
PurchaseContractType I_PurchaseContract PurchaseContractType
PurchasingDocumentCategory I_PurchaseContract PurchasingDocumentCategory
CreationDate I_PurchaseContract CreationDate
Supplier I_PurchaseContract Supplier
CompanyCode I_PurchaseContract CompanyCode
PurchasingOrganization I_PurchaseContract PurchasingOrganization
PurchasingGroup I_PurchaseContract PurchasingGroup
DocumentCurrency I_PurchaseContract DocumentCurrency
IncotermsClassification I_PurchaseContract IncotermsClassification
IncotermsTransferLocation I_PurchaseContract IncotermsTransferLocation
PaymentTerms I_PurchaseContract PaymentTerms
CashDiscount1Days I_PurchaseContract CashDiscount1Days
CashDiscount2Days I_PurchaseContract CashDiscount2Days
NetPaymentDays I_PurchaseContract NetPaymentDays
CashDiscount1Percent I_PurchaseContract CashDiscount1Percent
CashDiscount2Percent I_PurchaseContract CashDiscount2Percent
PurchaseContractTargetAmount I_PurchaseContract PurchaseContractTargetAmount
ValidityStartDate I_PurchaseContract ValidityStartDate
ValidityEndDate I_PurchaseContract ValidityEndDate
ReleaseCode I_PurchaseContract ReleaseCode
CreatedByUser I_PurchaseContract CreatedByUser
PurchasingDocumentDeletionCode I_PurchaseContract PurchasingDocumentDeletionCode
SupplyingSupplier I_PurchaseContract SupplyingSupplier
InvoicingParty I_PurchaseContract InvoicingParty
ExchangeRate I_PurchaseContract ExchangeRate
ExchangeRateIsFixed I_PurchaseContract ExchangeRateIsFixed
QuotationSubmissionDate I_PurchaseContract QuotationSubmissionDate
SupplierQuotation I_PurchaseContract SupplierQuotation
CorrespncExternalReference I_PurchaseContract CorrespncExternalReference
CorrespncInternalReference I_PurchaseContract CorrespncInternalReference
SupplierRespSalesPersonName I_PurchaseContract SupplierRespSalesPersonName
SupplierPhoneNumber I_PurchaseContract SupplierPhoneNumber
IncotermsVersion I_PurchaseContract IncotermsVersion
IncotermsLocation1 I_PurchaseContract IncotermsLocation1
IncotermsLocation2 I_PurchaseContract IncotermsLocation2
ReleaseIsNotCompleted I_PurchaseContract ReleaseIsNotCompleted
SupplierAddressID I_PurchaseContract SupplierAddressID
PurgDocExternalReference I_PurchaseContract PurgDocExternalReference
@AbapCatalog.sqlViewName: 'IPURCONTRAPI'
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType : #BASIC
@EndUserText.label: 'Purchase Contract'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]

@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

define view I_PurchaseContractAPI01 as select from I_PurchaseContract
  
 association [0..1] to E_PurchasingDocument         as _HeaderExtension            on  $projection.PurchaseContract = _HeaderExtension.PurchasingDocument
 
 {

key I_PurchaseContract.PurchaseContract, 
I_PurchaseContract.PurchaseContractType, 
I_PurchaseContract.PurchasingDocumentCategory, 
I_PurchaseContract.CreationDate, 
I_PurchaseContract.Supplier, 
I_PurchaseContract.CompanyCode, 
I_PurchaseContract.PurchasingOrganization, 
I_PurchaseContract.PurchasingGroup, 
I_PurchaseContract.DocumentCurrency, 
I_PurchaseContract.IncotermsClassification, 
I_PurchaseContract.IncotermsTransferLocation, 
I_PurchaseContract.PaymentTerms, 
I_PurchaseContract.CashDiscount1Days, 
I_PurchaseContract.CashDiscount2Days, 
I_PurchaseContract.NetPaymentDays, 
I_PurchaseContract.CashDiscount1Percent, 
I_PurchaseContract.CashDiscount2Percent, 
@Semantics.amount.currencyCode: 'DocumentCurrency'
I_PurchaseContract.PurchaseContractTargetAmount, 
I_PurchaseContract.ValidityStartDate, 
I_PurchaseContract.ValidityEndDate, 
I_PurchaseContract.ReleaseCode, 
I_PurchaseContract.CreatedByUser, 
I_PurchaseContract.PurchasingDocumentDeletionCode, 
I_PurchaseContract.SupplyingSupplier, 
I_PurchaseContract.InvoicingParty, 
I_PurchaseContract.ExchangeRate, 
I_PurchaseContract.ExchangeRateIsFixed, 
I_PurchaseContract.QuotationSubmissionDate, 
I_PurchaseContract.SupplierQuotation, 
I_PurchaseContract.CorrespncExternalReference, 
I_PurchaseContract.CorrespncInternalReference, 
I_PurchaseContract.SupplierRespSalesPersonName, 
I_PurchaseContract.SupplierPhoneNumber, 
I_PurchaseContract.IncotermsVersion, 
I_PurchaseContract.IncotermsLocation1, 
I_PurchaseContract.IncotermsLocation2, 
I_PurchaseContract.ReleaseIsNotCompleted, 
I_PurchaseContract.SupplierAddressID,
I_PurchaseContract.PurgDocExternalReference



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