I_PurchaseContractItemAPI01

DDL: I_PURCHASECONTRACTITEMAPI01 SQL: IPURCONTRITEMAPI Type: view COMPOSITE

Purchase Contract Item

I_PurchaseContractItemAPI01 is a Composite CDS View that provides data about "Purchase Contract Item" in SAP S/4HANA. It reads from 1 data source (I_PurchaseContractItem) and exposes 69 fields with key fields PurchaseContract, PurchaseContractItem. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContractAPI01 _PurchaseContractAPI01 $projection.PurchaseContract = _PurchaseContractAPI01.PurchaseContract
[1..1] I_PurchasingCategoryMatlGroup _PurchasingCategoryMatlGroup $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup
[0..1] E_PurchasingDocumentItem _ItemExtension $projection.PurchaseContract = _ItemExtension.PurchasingDocument and $projection.PurchaseContractItem = _ItemExtension.PurchasingDocumentItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPURCONTRITEMAPI view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Purchase Contract Item view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurchaseContractItem PurchaseContract
KEY PurchaseContractItem I_PurchaseContractItem PurchaseContractItem
Material I_PurchaseContractItem Material
PurchaseContractItemText I_PurchaseContractItem PurchaseContractItemText
ContractNetPriceAmount I_PurchaseContractItem ContractNetPriceAmount
OrderPriceUnit I_PurchaseContractItem OrderPriceUnit
VolumeUnit I_PurchaseContractItem VolumeUnit
OrderQuantityUnit I_PurchaseContractItem OrderQuantityUnit
MaterialGroup I_PurchaseContractItem MaterialGroup
Customer I_PurchaseContractItem Customer
Subcontractor I_PurchaseContractItem Subcontractor
ReferenceDeliveryAddressID I_PurchaseContractItem ReferenceDeliveryAddressID
ManualDeliveryAddressID I_PurchaseContractItem ManualDeliveryAddressID
DeliveryAddressID
DeliveryAddressID_2 I_PurchaseContractItem DeliveryAddressID
Plant I_PurchaseContractItem Plant
StorageLocation I_PurchaseContractItem StorageLocation
AccountAssignmentCategory I_PurchaseContractItem AccountAssignmentCategory
GoodsReceiptIsExpected I_PurchaseContractItem GoodsReceiptIsExpected
NetPriceQuantity I_PurchaseContractItem NetPriceQuantity
MultipleAcctAssgmtDistribution I_PurchaseContractItem MultipleAcctAssgmtDistribution
TargetQuantity I_PurchaseContractItem TargetQuantity
TargetAmount I_PurchaseContractItem TargetAmount
DocumentCurrency I_PurchaseContractItem DocumentCurrency
OrdPriceUnitToOrderUnitDnmntr I_PurchaseContractItem OrdPriceUnitToOrderUnitDnmntr
OrderPriceUnitToOrderUnitNmrtr I_PurchaseContractItem OrderPriceUnitToOrderUnitNmrtr
PurchasingDocumentItemCategory I_PurchaseContractItem PurchasingDocumentItemCategory
SupplierMaterialNumber I_PurchaseContractItem SupplierMaterialNumber
EvaldRcptSettlmtIsAllowed I_PurchaseContractItem EvaldRcptSettlmtIsAllowed
UnderdelivTolrtdLmtRatioInPct I_PurchaseContractItem UnderdelivTolrtdLmtRatioInPct
PriceIsToBePrinted I_PurchaseContractItem PriceIsToBePrinted
SupplierConfirmationControlKey I_PurchaseContractItem SupplierConfirmationControlKey
OverdelivTolrtdLmtRatioInPct I_PurchaseContractItem OverdelivTolrtdLmtRatioInPct
UnlimitedOverdeliveryIsAllowed I_PurchaseContractItem UnlimitedOverdeliveryIsAllowed
InvoiceIsExpected I_PurchaseContractItem InvoiceIsExpected
InvoiceIsGoodsReceiptBased I_PurchaseContractItem InvoiceIsGoodsReceiptBased
PurgDocPriceDate I_PurchaseContractItem PurgDocPriceDate
IsInfoRecordUpdated I_PurchaseContractItem IsInfoRecordUpdated
PurchasingInfoRecordUpdateCode I_PurchaseContractItem PurchasingInfoRecordUpdateCode
PurgDocReleaseOrderQuantity I_PurchaseContractItem PurgDocReleaseOrderQuantity
PurgDocOrderAcknNumber I_PurchaseContractItem PurgDocOrderAcknNumber
PurgDocEstimatedPrice I_PurchaseContractItem PurgDocEstimatedPrice
IsInfoAtRegistration I_PurchaseContractItem IsInfoAtRegistration
NoDaysReminder1 I_PurchaseContractItem NoDaysReminder1
NoDaysReminder2 I_PurchaseContractItem NoDaysReminder2
NoDaysReminder3 I_PurchaseContractItem NoDaysReminder3
StockType I_PurchaseContractItem StockType
TaxCode I_PurchaseContractItem TaxCode
RequirementTracking I_PurchaseContractItem RequirementTracking
IsOrderAcknRqd I_PurchaseContractItem IsOrderAcknRqd
ShippingInstruction I_PurchaseContractItem ShippingInstruction
ShippingType I_PurchaseContractItem ShippingType
GoodsReceiptIsNonValuated I_PurchaseContractItem GoodsReceiptIsNonValuated
ServicePerformer I_PurchaseContractItem ServicePerformer
ProductType I_PurchaseContractItem ProductType
ProductTypeCode I_PurchaseContractItem ProductTypeCode
MaterialType I_PurchaseContractItem MaterialType
FormattedPurchaseContractItem I_PurchaseContractItem FormattedPurchaseContractItem
PurchaseContractItemFormatted I_PurchaseContractItem PurchaseContractItemFormatted
PurchasingContractDeletionCode I_PurchaseContractItem PurchasingContractDeletionCode
PurchaseContractItemUniqueID I_PurchaseContractItem PurchaseContractItemUniqueID
PurchasingParentItem I_PurchaseContractItem PurchasingParentItem
IsStatisticalItem I_PurchaseContractItem IsStatisticalItem
PurgConfigurableItemNumber I_PurchaseContractItem PurgConfigurableItemNumber
PurgDocAggrgdSubitemCategory I_PurchaseContractItem PurgDocAggrgdSubitemCategory
PurgExternalSortNumber I_PurchaseContractItem PurgExternalSortNumber
PurchasingCategory
PurgCatName
_PurchaseContractAPI01 _PurchaseContractAPI01
@AbapCatalog.sqlViewName: 'IPURCONTRITEMAPI'
@VDM.viewType : #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Purchase Contract Item'

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

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

define view I_PurchaseContractItemAPI01 as select from I_PurchaseContractItem

association [1..1] to I_PurchaseContractAPI01    as _PurchaseContractAPI01    on  $projection.PurchaseContract = _PurchaseContractAPI01.PurchaseContract
association [1..1] to I_PurchasingCategoryMatlGroup as _PurchasingCategoryMatlGroup on  $projection.MaterialGroup = _PurchasingCategoryMatlGroup.MaterialGroup
association [0..1] to E_PurchasingDocumentItem   as _ItemExtension            on  $projection.PurchaseContract     = _ItemExtension.PurchasingDocument
                                                                                 and $projection.PurchaseContractItem = _ItemExtension.PurchasingDocumentItem   //3404005

 {
 
  key I_PurchaseContractItem.PurchaseContract, 
  key I_PurchaseContractItem.PurchaseContractItem,
  I_PurchaseContractItem.Material, 
  I_PurchaseContractItem.PurchaseContractItemText, 
  @Semantics.amount.currencyCode: 'DocumentCurrency'
  I_PurchaseContractItem.ContractNetPriceAmount, 
  I_PurchaseContractItem.OrderPriceUnit, 
  I_PurchaseContractItem.VolumeUnit, 
  I_PurchaseContractItem.OrderQuantityUnit, 
  I_PurchaseContractItem.MaterialGroup, 
  I_PurchaseContractItem.Customer, 
  I_PurchaseContractItem.Subcontractor, 
  I_PurchaseContractItem.ReferenceDeliveryAddressID, 
  I_PurchaseContractItem.ManualDeliveryAddressID, 
  @API.element.releaseState: #DEPRECATED
  @API.element.successor: 'DeliveryAddressID_2'
  cast(I_PurchaseContractItem.DeliveryAddressID as contactcardaddress) as DeliveryAddressID,
  I_PurchaseContractItem.DeliveryAddressID as DeliveryAddressID_2,
  I_PurchaseContractItem.Plant, 
  I_PurchaseContractItem.StorageLocation, 
  I_PurchaseContractItem.AccountAssignmentCategory, 
  I_PurchaseContractItem.GoodsReceiptIsExpected, 
  @Semantics.quantity.unitOfMeasure: 'OrderPriceUnit'
  I_PurchaseContractItem.NetPriceQuantity, 
  I_PurchaseContractItem.MultipleAcctAssgmtDistribution,
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit' 
  I_PurchaseContractItem.TargetQuantity,
  @Semantics.amount.currencyCode: 'DocumentCurrency' 
  I_PurchaseContractItem.TargetAmount, 
  I_PurchaseContractItem.DocumentCurrency, 
  I_PurchaseContractItem.OrdPriceUnitToOrderUnitDnmntr, 
  I_PurchaseContractItem.OrderPriceUnitToOrderUnitNmrtr, 
  I_PurchaseContractItem.PurchasingDocumentItemCategory, 
  I_PurchaseContractItem.SupplierMaterialNumber, 
  I_PurchaseContractItem.EvaldRcptSettlmtIsAllowed, 
  I_PurchaseContractItem.UnderdelivTolrtdLmtRatioInPct, 
  I_PurchaseContractItem.PriceIsToBePrinted, 
  I_PurchaseContractItem.SupplierConfirmationControlKey, 
  I_PurchaseContractItem.OverdelivTolrtdLmtRatioInPct, 
  I_PurchaseContractItem.UnlimitedOverdeliveryIsAllowed, 
  I_PurchaseContractItem.InvoiceIsExpected, 
  I_PurchaseContractItem.InvoiceIsGoodsReceiptBased, 
  I_PurchaseContractItem.PurgDocPriceDate,   
  @API.element.releaseState: #DEPRECATED
  @API.element.successor: 'PurchasingInfoRecordUpdateCode'
  I_PurchaseContractItem.IsInfoRecordUpdated, 
  I_PurchaseContractItem.PurchasingInfoRecordUpdateCode,
  @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
  I_PurchaseContractItem.PurgDocReleaseOrderQuantity, 
  I_PurchaseContractItem.PurgDocOrderAcknNumber, 
  I_PurchaseContractItem.PurgDocEstimatedPrice, 
  I_PurchaseContractItem.IsInfoAtRegistration, 
  I_PurchaseContractItem.NoDaysReminder1, 
  I_PurchaseContractItem.NoDaysReminder2, 
  I_PurchaseContractItem.NoDaysReminder3, 
  I_PurchaseContractItem.StockType, 
  I_PurchaseContractItem.TaxCode, 
  I_PurchaseContractItem.RequirementTracking, 
  I_PurchaseContractItem.IsOrderAcknRqd, 
  I_PurchaseContractItem.ShippingInstruction, 
  I_PurchaseContractItem.ShippingType,
  I_PurchaseContractItem.GoodsReceiptIsNonValuated, 
  I_PurchaseContractItem.ServicePerformer, 
  @API.element.releaseState: #DEPRECATED
  @API.element.successor: 'ProductTypeCode' 
  I_PurchaseContractItem.ProductType,
  I_PurchaseContractItem.ProductTypeCode,
  I_PurchaseContractItem.MaterialType, 
  @API.element.releaseState: #DEPRECATED
  @API.element.successor: 'PurchaseContractItemFormatted' 
  I_PurchaseContractItem.FormattedPurchaseContractItem, 
  I_PurchaseContractItem.PurchaseContractItemFormatted, 
  I_PurchaseContractItem.PurchasingContractDeletionCode, 
  I_PurchaseContractItem.PurchaseContractItemUniqueID,
  
  //Added for item hierarchy

  I_PurchaseContractItem.PurchasingParentItem,
  I_PurchaseContractItem.IsStatisticalItem,
  I_PurchaseContractItem.PurgConfigurableItemNumber,
  I_PurchaseContractItem.PurgDocAggrgdSubitemCategory,
  I_PurchaseContractItem.PurgExternalSortNumber,
      
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory,
  _PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName,
  _PurchaseContractAPI01
} 
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTITEM",
"I_PURCHASINGCATEGORY",
"I_PURCHASINGCATEGORYMATLGROUP"
],
"ASSOCIATED":
[
"E_PURCHASINGDOCUMENTITEM",
"I_PURCHASECONTRACTAPI01",
"I_PURCHASINGCATEGORYMATLGROUP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/