R_PurchaseContractItemTP

DDL: R_PURCHASECONTRACTITEMTP Type: view_entity TRANSACTIONAL

Purchase Contract Item

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

Data Sources (1)

SourceAliasJoin Type
I_PurchaseContractItem I_PurchaseContractItem from

Associations (5)

CardinalityTargetAliasCondition
[1..1] E_PurchasingDocumentItem _PurchasingDocumentItem $projection.PurchaseContract = _PurchasingDocumentItem.PurchasingDocument and $projection.PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem
[0..*] R_PurContrAccountTP _PurCtrAccount
[0..1] R_PurContrAddressTP _PurCtrAddress
[0..*] R_PurContrItemNotesTP _PurCtrItNotes
[1..*] R_PurContrItemCndnValdtyTP _PurContrItemCndnValdty

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Purchase Contract Item view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey PurchaseContractItem view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

Fields (82)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract PurchaseContract
KEY PurchaseContractItem PurchaseContractItem
PurchaseContractItemUniqueID PurchaseContractItemUniqueID
CompanyCode CompanyCode
Material Material
ManufacturerMaterial ManufacturerMaterial
PurchaseContractItemText PurchaseContractItemText
ContractNetPriceAmount ContractNetPriceAmount
OrderPriceUnit OrderPriceUnit
VolumeUnit VolumeUnit
OrderQuantityUnit OrderQuantityUnit
MaterialGroup MaterialGroup
Customer Customer
Subcontractor Subcontractor
ReferenceDeliveryAddressID ReferenceDeliveryAddressID
ManualDeliveryAddressID ManualDeliveryAddressID
DeliveryAddressID DeliveryAddressID
Plant Plant
StorageLocation StorageLocation
AccountAssignmentCategory AccountAssignmentCategory
GoodsReceiptIsExpected GoodsReceiptIsExpected
NetPriceQuantity NetPriceQuantity
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution
TargetQuantity TargetQuantity
TargetAmount TargetAmount
DocumentCurrency DocumentCurrency
OrdPriceUnitToOrderUnitDnmntr OrdPriceUnitToOrderUnitDnmntr
OrderPriceUnitToOrderUnitNmrtr OrderPriceUnitToOrderUnitNmrtr
PurchasingDocumentItemCategory PurchasingDocumentItemCategory
SupplierMaterialNumber SupplierMaterialNumber
EvaldRcptSettlmtIsAllowed EvaldRcptSettlmtIsAllowed
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct
PriceIsToBePrinted PriceIsToBePrinted
SupplierConfirmationControlKey SupplierConfirmationControlKey
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed
IncotermsClassification IncotermsClassification
IncotermsLocation1 IncotermsLocation1
InvoiceIsExpected InvoiceIsExpected
InvoiceIsGoodsReceiptBased InvoiceIsGoodsReceiptBased
PurgDocPriceDate PurgDocPriceDate
PurchasingInfoRecordUpdateCode PurchasingInfoRecordUpdateCode
PurgDocReleaseOrderQuantity PurgDocReleaseOrderQuantity
PurgDocOrderAcknNumber PurgDocOrderAcknNumber
PurchasingPriceIsEstimated PurgDocEstimatedPrice
IsInfoAtRegistration IsInfoAtRegistration
NoDaysReminder1 NoDaysReminder1
NoDaysReminder2 NoDaysReminder2
NoDaysReminder3 NoDaysReminder3
PlannedDeliveryDurationInDays PlannedDeliveryDurationInDays
StockType StockType
TaxCode TaxCode
TaxCountry TaxCountry
TaxDeterminationDate TaxDeterminationDate
RequirementTracking RequirementTracking
IsOrderAcknRqd IsOrderAcknRqd
ShippingInstruction ShippingInstruction
GoodsReceiptIsNonValuated GoodsReceiptIsNonValuated
ServicePerformer ServicePerformer
ProductTypeCode ProductTypeCode
MaterialType MaterialType
PurchaseContractItemFormatted PurchaseContractItemFormatted
PurchasingContractDeletionCode PurchasingContractDeletionCode
PurchaseRequisition PurchaseRequisition
PurchaseRequisitionItem PurchaseRequisitionItem
PartialInvoiceDistribution PartialInvoiceDistribution
ManufacturerPartNmbr ManufacturerPartNmbr
Manufacturer Manufacturer
PurContractItmReplnmtElmntType PurContractItmReplnmtElmntType
PurchasingCategory PurchasingCategory
PurgCatName PurgCatName
PurchaseContractType PurchaseContractType
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
PurgProdCmplncSupplierStatus PurgProdCmplncSupplierStatus
PurchasingIsCatalogRelevant PurchasingIsCatalogRelevant
LastChangeDateTime _PurchaseContract LastChangeDateTime
_PurchaseContract _PurchaseContract
_PurCtrAccount _PurCtrAccount
_PurCtrAddress _PurCtrAddress
_PurCtrItNotes _PurCtrItNotes
_PurContrItemCndnValdty _PurContrItemCndnValdty
//@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED

@EndUserText.label: 'Purchase Contract Item'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.semanticKey:  [ 'PurchaseContract','PurchaseContractItem' ]
@ObjectModel.representativeKey: 'PurchaseContractItem'

@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}

@Metadata.ignorePropagatedAnnotations: true

define view entity R_PurchaseContractItemTP
  as select from I_PurchaseContractItem

  composition [0..*] of R_PurContrAccountTP       as _PurCtrAccount
  composition [0..1] of R_PurContrAddressTP       as _PurCtrAddress
  composition [0..*] of R_PurContrItemNotesTP     as _PurCtrItNotes
  composition [1..*] of R_PurContrItemCndnValdtyTP as _PurContrItemCndnValdty

  association to parent R_PurchaseContractTP      as _PurchaseContract on $projection.PurchaseContract = _PurchaseContract.PurchaseContract

 ----Extension Association
  association [1..1] to E_PurchasingDocumentItem      as _PurchasingDocumentItem      on  $projection.PurchaseContract     = _PurchasingDocumentItem.PurchasingDocument
                                                                                      and $projection.PurchaseContractItem = _PurchasingDocumentItem.PurchasingDocumentItem

{

      @ObjectModel.foreignKey.association: '_PurchaseContract'
  key PurchaseContract,
  key PurchaseContractItem,
      PurchaseContractItemUniqueID,
      CompanyCode,
      Material,
      ManufacturerMaterial,
      PurchaseContractItemText,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      ContractNetPriceAmount,
      OrderPriceUnit,
      VolumeUnit,
      OrderQuantityUnit,
      MaterialGroup,
      Customer,
      Subcontractor,
      ReferenceDeliveryAddressID,
      ManualDeliveryAddressID,
      DeliveryAddressID,
      Plant,
      StorageLocation,
      AccountAssignmentCategory,
      GoodsReceiptIsExpected,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      NetPriceQuantity,
      MultipleAcctAssgmtDistribution,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      TargetQuantity,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      TargetAmount,
      DocumentCurrency,
      OrdPriceUnitToOrderUnitDnmntr,
      OrderPriceUnitToOrderUnitNmrtr,
      PurchasingDocumentItemCategory,
      SupplierMaterialNumber,
      EvaldRcptSettlmtIsAllowed,
      UnderdelivTolrtdLmtRatioInPct,
      PriceIsToBePrinted,
      SupplierConfirmationControlKey,
      OverdelivTolrtdLmtRatioInPct,
      UnlimitedOverdeliveryIsAllowed,
      IncotermsClassification,
      IncotermsLocation1,
      InvoiceIsExpected,
      InvoiceIsGoodsReceiptBased,
      PurgDocPriceDate,
      PurchasingInfoRecordUpdateCode,
      @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
      PurgDocReleaseOrderQuantity,
      PurgDocOrderAcknNumber,
      PurgDocEstimatedPrice as PurchasingPriceIsEstimated,
      IsInfoAtRegistration,
      NoDaysReminder1,
      NoDaysReminder2,
      NoDaysReminder3,
      PlannedDeliveryDurationInDays,
      StockType,
      TaxCode,
      TaxCountry,
      TaxDeterminationDate,
      RequirementTracking,
      IsOrderAcknRqd,
      ShippingInstruction,
      GoodsReceiptIsNonValuated,
      ServicePerformer,
      ProductTypeCode,
      MaterialType,
      PurchaseContractItemFormatted,
      PurchasingContractDeletionCode,
      cast ( case PurchasingContractDeletionCode
              when 'L' then 'X'
             else ' '
              end  as boolean ) as TextIsDeleted,
      cast ( case PurchasingContractDeletionCode
              when 'S' then 'X'
            else ' '
              end as boolean ) as OutlineAgrmtItmBlockedText,
      PurchaseRequisition,
      PurchaseRequisitionItem,
      PartialInvoiceDistribution,
      ManufacturerPartNmbr,
      Manufacturer,
      PurContractItmReplnmtElmntType,
      PurchasingCategory,
      PurgCatName,
      PurchaseContractType,
      PurchasingOrganization,
      PurchasingGroup,
      PurgProdCmplncSupplierStatus,
      PurchasingIsCatalogRelevant,
      @Semantics.systemDateTime.lastChangedAt: true
      _PurchaseContract.LastChangeDateTime as LastChangeDateTime,
      /* Associations */
      _PurchaseContract,
      _PurCtrAccount,
      _PurCtrAddress,
      _PurCtrItNotes,
      _PurContrItemCndnValdty
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASECONTRACTITEM",
"R_PURCHASECONTRACTTP"
],
"ASSOCIATED":
[
"R_PURCHASECONTRACTTP",
"R_PURCONTRACCOUNTTP",
"R_PURCONTRADDRESSTP",
"R_PURCONTRITEMCNDNVALDTYTP",
"R_PURCONTRITEMNOTESTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/